2025 DB Final
Tables (8)
character_classes
- id (charclass_id) — INT — Primary key — NOT NULL
- name — TEXT
- character_type (type) — Enum("Archer","Wizard", "Pirate")
characters
- id (user_id) — VARCHAR(50) — Foreign key → users.id — NOT NULL
- id (charclass_id) — INT — Foreign key → character_classes.id — NOT NULL
- name — TEXT
- gender — TEXT
inventories
- id (user_id) — VARCHAR(50) — Foreign key → characters.id — NOT NULL
- id (charclass_id) — INT — Foreign key → characters.id — NOT NULL
- capacity — FLOAT
inventory_items
- id (user_id) — VARCHAR(50) — Foreign key → inventories.id — NOT NULL
- id (charclass_id) — INT — Foreign key → inventories.id — NOT NULL
- quantity — INTEGER
- item_id — INT — Foreign key → items.item_id — NOT NULL
items
- item_id — INT — Primary key — NOT NULL
- name — TEXT
- type — ENUM("consumable", "weapon", "armor")
- description — TEXT
- capacity — FLOAT
position (Untitled)
- id (user_id) — VARCHAR(50) — Foreign key → characters.id — NOT NULL
- id (charclass_id) — INT — Foreign key → characters.id — NOT NULL
- x — FLOAT
- y — FLOAT
status
- id (user_id) — VARCHAR(50) — Foreign key → characters.id — NOT NULL
- id (charclass_id) — INT — Foreign key → characters.id — NOT NULL
- level — INTEGER
- xp — INTEGER
- strength — INTEGER
- intelligence — INTEGER
- hp — INTEGER
users
- id (user_id) — VARCHAR(50) — Primary key — NOT NULL
- email — TEXT
- password — VARCHAR(50)