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