아그리콜라

테이블 (5)

job_card (CopyOfCopyOfUntitled2)

  • job_card_id (Key) — integer — 기본 키 — NOT NULL
  • player_id (Key2) — integer — 외래 키 → player.player_id — NOT NULL
  • name (Field) — varchar(50)
  • description (Field2) — varchar(200)
  • image (Field3) — varchar(100)

main_card (Untitled2)

  • main_card_id (Key) — integer — 기본 키 — NOT NULL
  • player_id (Key2) — integer — 외래 키 → player.player_id — NOT NULL
  • name (Field) — varchar(50)
  • description (Field2) — varchar(200)
  • image (Field3) — varchar(100)
  • need (Field4) — varchar(50)
  • score (Field5) — integer

player (CopyOfUntitled)

  • player_id (Key) — integer — 기본 키 — NOT NULL
  • order (Field2) — integer
  • is_first_player (Field) — TINYINT(1)
  • pig (Field3) — integer
  • cow (Field4) — integer
  • sheep (Field5) — integer
  • wheat (Field6) — integer
  • vegetable (Field7) — integer
  • wood (Field8) — integer
  • rock (Field9) — integer
  • reed (Field10) — integer
  • dirt (Field11) — integer
  • food (Field12) — integer
  • begging (Field13) — integer
  • family (Field14) — integer
  • fence (Field16) — integer
  • shed (Field15) — integer

round_card (Untitled)

  • round_card_id (Key) — integer — 기본 키 — NOT NULL
  • round (Field) — integer
  • name (Field2) — varchar(50)
  • description (Field3) — varchar(200)
  • image (Field4) — varchar(100)

sub_card (CopyOfUntitled2)

  • sub_card_id (Key) — integer — 기본 키 — NOT NULL
  • player_id (Key2) — integer — 외래 키 → player.player_id — NOT NULL
  • name (Field) — varchar(50)
  • description (Field2) — varchar(200)
  • image (Field3) — varchar(100)
  • need (Field4) — varchar(50)
  • score (Field5) — integer