Database Documentation

characters

Column	Data type
id	INT PK
user	INT FK
name	STR
species	STR
class	STR
career	STR
career tier	STR
career path	STR
status	STR
age	INT
height	INT
hair	STR
eyes	STR
backstory	STR
other information	STR

characteristics

Column	Data type
id	INT PK
character_id	INT FK
WS_initial	INT
WS_advances	INT
WS_current	INT
BS_initial	INT
BS_advances	INT
BS_current	INT
S_initial	INT
S_advances	INT
S_current	INT
T_initial	INT
T_advances	INT
T_current	INT
I_initial	INT
I_advances	INT
I_current	INT
Ag_initial	INT
Ag_advances	INT
Ag_current	INT
Dex_initial	INT
Dex_advances	INT
Dex_current	INT
Int_initial	INT
Int_advances	INT
Int_current	INT
WP_initial	INT
WP_advances	INT
WP_current	INT
Fel_initial	INT
Fel_advances	INT
Fel_current	INT

fate

Column	Data type
id	INT PK
character_id	INT FK
fate	INT
fortune	INT

resilience

Column	Data type
id	INT PK
character_id	INT FK
resilience	INT
resolve	INT
motivation	STR

experience

Column	Data type
id	INT PK
character_id	INT FK
current	INT
spent	INT
total	INT

movement

Column	Data type
id	INT PK
character_id	INT FK
movement	INT
walk	INT
run	INT

basic_skills

Column	Data type
id	INT PK
character_id	INT FK
art_characteristics	INT
art_advances	INT
art_skill	INT
athletics_characteristics	INT
athletics_advances	INT
athletics_skill	INT
bribery_characteristics	INT
bribery_advances	INT
bribery_skill	INT
charm_characteristics	INT
charm_advances	INT
charm_skill	INT
charm_animal_characteristics	INT
charm_animal_advances	INT
charm_animal_skill	INT
climb_characteristics	INT
climb_advances	INT
climb_skill	INT
cool_characteristics	INT
cool_advances	INT
cool_skill	INT
consume_alcohol_characteristics	INT
consume_alcohol_advances	INT
consume_alcohol_skill	INT
dodge_characteristics	INT
dodge_advances	INT
dodge_skill	INT
drive_characteristics	INT
drive_advances	INT
drive_skill	INT
endurance_characteristics	INT
endurance_advances	INT
endurance_skill	INT
entertain_characteristics	INT
entertain_advances	INT
entertain_skill	INT
gamble_characteristics	INT
gamble_advances	INT
gamble_skill	INT
gossip_characteristics	INT
gossip_advances	INT
gossip_skill	INT
haggle_characteristics	INT
haggle_advances	INT
haggle_skill	INT
intimidate_characteristics	INT
intimidate_advances	INT
intimidate_skill	INT
intuition_characteristics	INT
intuition_advances	INT
intuition_skill	INT
leadership_characteristics	INT
leadership_advances	INT
leadership_skill	INT
melee_basic_characteristics	INT
melee_basic_advances	INT
melee_basic_skill	INT
melee_characteristics	INT
melee_advances	INT
melee_skill	INT
navigation_characteristics	INT
navigation_advances	INT
navigation_skill	INT
outdoor_survival_characteristics	INT
outdoor_survival_advances	INT
outdoor_survival_skill	INT
perception_characteristics	INT
perception_advances	INT
perception_skill	INT
ride_characteristics	INT
ride_advances	INT
ride_skill	INT
row_characteristics	INT
row_advances	INT
row_skill	INT
stealth_characteristics	INT
stealth_advances	INT
stealth_skill	INT

advanced_skills

Column	Data type
id	INT PK
character_id	INT FK
name	STR
attribute_name	STR
attribute_value	INT
advances	INT
total	INT

talents

Column	Data type
id	INT PK
character_id	INT FK
talent	STR
times_taken	INT
description	STR

ambitions

Column	Data type
id	INT PK
character_id	INT FK
short_term	STR
long_term	STR

party

Column	Data type
id	INT PK
character_id	INT FK
party_name	STR
short_term	STR
long_term	STR
members	STR

psychology

Column	Data type
id	INT PK
character_id	INT FK
effect	STR

corruption_and_mutation

Column	Data type
id	INT PK
character_id	INT FK
effect	STR

wounds

Column	Data type
id	INT PK
character_id	INT FK
sb	INT
tb_x2	INT
wbp	INT
hardy	INT
wounds	INT
current wounds	INT

sin

Column	Data type
id	INT PK
character_id	INT FK
sin	INT

Previous Next