RPG
Tables (5)
Dungeon (Untitled2)
- dungeon_id (Key) — Primary key — NOT NULL
- level_requirement (Field)
- Field2
Item (Untitled5)
- item_id (Key) — Primary key — NOT NULL
- Nickname (Key2) — Foreign key → Player.Nickname — NOT NULL
- name (Field)
- effect (Field2)
- price (Field3)
Monster (Untitled3)
- monster_id (Key) — Primary key — NOT NULL
- dungeon_id (Key2) — Foreign key → Dungeon.dungeon_id — NOT NULL
- health (Field)
- attack (Field2)
- defense (Field3)
- level (Field4)
- experience_reward (Field5)
Player (Untitled)
- Nickname (Key) — Primary key — NOT NULL
- level (Field3)
- health (Field)
- now_experience (Field2)
- attack (Field5)
- defense (Field6)
- total_experience (Field7)
- money (Field4)
Shop (Untitled4)
- shop_id (Key) — Primary key — NOT NULL
- item_id (Key2) — Foreign key → Item.item_id — NOT NULL
- Nickname (Key22) — Foreign key → Item.Nickname — NOT NULL
- price (Field2)