rpg erd

Tables (9)

Character (Untitled7)

  • character_id (Key) — int — Primary key — NOT NULL
  • name (Field)

Inventory (Untitled4)

  • character_id (Key) — int — Foreign key → Character.character_id — NOT NULL
  • item_id (Key2) — Foreign key → Item.item_id — NOT NULL

Item (Untitled3)

  • item_id (Key) — Primary key — NOT NULL

NPC (Untitled8)

  • character_id (Key2) — int — Foreign key → Character.character_id — NOT NULL
  • type (Field) — enum

PlayerCharacter (Untitled2)

  • character_id (Key) — int — Foreign key → Character.character_id — NOT NULL
  • user_account (Key2) — int — Foreign key → UserAccount.id — NOT NULL

Quest (Untitled5)

  • quest_id (Key) — Primary key — NOT NULL
  • next_quest_id (Key2) — Foreign key → Quest.quest_id — NOT NULL

QuestProgess (Untitled6)

  • character_id (Key) — int — Foreign key → PlayerCharacter.character_id — NOT NULL
  • quest_id (Key2) — Foreign key → Quest.quest_id — NOT NULL
  • progress (Field)

Stat (Untitled9)

  • Key — Primary key — NOT NULL
  • character_id (Key2) — int — Foreign key → Character.character_id — NOT NULL
  • hp (Field)
  • mana (Field2)

UserAccount (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • password — string — NOT NULL