보드콜리
테이블 (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