보드콜리

테이블 (6)

Game (보드게임)

  • game_id (PK) — bigint — 기본 키 — NOT NULL
  • game_title_eng (Field) — varchar(45)
  • game_title_kor (Field9) — varchar(45)
  • game_min_player (Field2) — bigint
  • game_max_player (Field3) — bigint
  • gmae_time (Field4) — bigint
  • game_image (Field7) — varchar(200)
  • qr_image (Field8) — varchar(200)

GameRelation (Untitled3)

  • game_relation_id (PK) — bigint — 기본 키 — NOT NULL
  • game_id (PK2) — bigint — 외래 키 → Game.game_id — NOT NULL
  • related_game_id (Field) — bigint

Game_Tag (Untitled)

  • game_tag_id (Key) — bigint — 기본 키 — NOT NULL
  • game_id (PK) — bigint — 외래 키 → Game.game_id — NOT NULL
  • tag_id (PK2) — bigint — 외래 키 → Tag.tag_id — NOT NULL

Question (질문)

  • question_id (Key) — bigint — 기본 키 — NOT NULL
  • created_at (Field) — datetime
  • is_valid (Field2)
  • updated_at (Field3)
  • answer (Field4) — text
  • game_id (Field5) — bigint
  • content (Field6) — text

Tag (태그)

  • tag_id (PK) — bigint — 기본 키 — NOT NULL
  • tag_name_kor (Field) — varchar(45)
  • tag_name_eng (Field3) — varchar(45)
  • tag_description (Field2) — varchar(400)

Tutorial (튜토리얼)

  • tutorial_id (PK) — 기본 키 — NOT NULL
  • game_id (PK2) — bigint — 외래 키 → Game.game_id — NOT NULL