Database Documentation

melee_weapons

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR
reach	STR
damage	STR
qualities_and_flaws	STR
type	STR

ranged_weapons

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR
range	STR
damage	STR
qualities_and_flaws	STR
type	STR

ammunition

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR
range	STR
damage	STR
qualities_and_flaws	STR
type	STR

armour

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR
penalty	STR
locations	STR
aps	INT
qualities_and_flaws	STR
type	STR

packs_and_containers

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
carries	INT
availability	STR

clothing_and_accessories

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR

food_drink_and_lodging

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR

tools_and_kits

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR

books_and_documents

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR

trade_tools_and_workshops

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR

animals_and_vehicles

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
carries	INT
availability	STR

drugs_and_poisons

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR

herbs_and_draughts

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR

prosthetics

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR

miscellaneous_trappings

Column	Data type
id	INT PK
name	STR
price	STR
encumbrance	INT
availability	STR

hirelings

Column	Data type
id	INT PK
name	STR
quick_job	STR
daily_cost	STR
weekly_cost	STR
notes	STR

character_melee_weapons

Column	Data type
id	INT PK
character	INT FK
melee_weapon	INT FK
quantity	INT
equipped	BOOL

character_ranged_weapons

Column	Data type
id	INT PK
character	INT FK
ranged_weapon	INT FK
quantity	INT
equipped	BOOL

character_ammunition

Column	Data type
id	INT PK
character	INT FK
ammunition	INT FK
quantity	INT
equipped	BOOL

character_armour

Column	Data type
id	INT PK
character	INT FK
armour	INT FK
quantity	INT
equipped	BOOL

character_packs_and_containers

Column	Data type
id	INT PK
character	INT FK
packs_and_containers	INT FK
quantity	INT
equipped	BOOL

character_clothing_and_accessories

Column	Data type
id	INT PK
character	INT FK
clothing_and_accessories	INT FK
quantity	INT
equipped	BOOL

character_food_drink_and_lodging

Column	Data type
id	INT PK
character	INT FK
food_drink_and_lodging	INT FK
quantity	INT
equipped	BOOL

character_tools_and_kits

Column	Data type
id	INT PK
character	INT FK
tools_and_kits	INT FK
quantity	INT
equipped	BOOL

character_books_and_documents

Column	Data type
id	INT PK
character	INT FK
books_and_documents	INT FK
quantity	INT
equipped	BOOL

character_trade_tools_and_workshops

Column	Data type
id	INT PK
character	INT FK
trade_tools_and_workshops	INT FK
quantity	INT
equipped	BOOL

character_animals_and_vehicles

Column	Data type
id	INT PK
character	INT FK
animals_and_vehicles	INT FK
quantity	INT
equipped	BOOL

character_drugs_and_poisons

Column	Data type
id	INT PK
character	INT FK
drugs_and_poisons	INT FK
quantity	INT
equipped	BOOL

character_herbs_and_draughts

Column	Data type
id	INT PK
character	INT FK
herbs_and_draughts	INT FK
quantity	INT
equipped	BOOL

character_prosthetics

Column	Data type
id	INT PK
character	INT FK
prosthetics	INT FK
quantity	INT
equipped	BOOL

character_miscellaneous_trappings

Column	Data type
id	INT PK
character	INT FK
miscellaneous_trappings	INT FK
quantity	INT
equipped	BOOL

character_hirelings

Column	Data type
id	INT PK
character	INT FK
hirelings	INT FK
quantity	INT
equipped	BOOL

Previous Next