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)