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