lost_city
Tables (4)
Room
- room_id (id) — int — Primary key — NOT NULL
- room_name — varchar(20)
card
- card_id (Key) — int — Primary key — NOT NULL
- Field (region) — varchar(20)
- Field2 (number) — int
player
- player_id (id) — int — Primary key — NOT NULL
- player_name (name) — varchar(20)
- player_number — int
- room_id (id2) — int — Foreign key → Room.room_id — NOT NULL
room_card (Untitled)
- room_card_id (Key) — int — Primary key — NOT NULL
- is_drawn (Field) — bool
- is_explored (Field2) — bool
- player (Field3) — int
- room_id (id) — int — Foreign key → Room.room_id — NOT NULL
- card_id (Key3) — int — Foreign key → card.card_id — NOT NULL