아마존 익스프레스
테이블 (6)
Choice (choice)
- id (Key) — BIGINT — 기본 키 — NOT NULL
- story_id (FK) — BIGINT — 외래 키 → Story.id — NOT NULL
- choiceText (Field) — TEXT
InGame (in_game)
- player_id (FK) — bigint — 외래 키 → PlayerInfo.id — NOT NULL
- water (Field) — INT
- food (Field2) — INT
- day (Field3) — INT
- hp (Field4) — INT
- id (Key) — BIGINT — NOT NULL
MiniGame (mini_game)
- id (Key) — BIGINT — 기본 키 — NOT NULL
- player_id (FK) — BIGINT — 외래 키 → PlayerInfo.id — NOT NULL
- damage (Field) — INT
PlayerInfo (playerInfo)
- id (Key) — BIGINT — 기본 키 — NOT NULL
- name (Field1) — VARCHAR(12)
- sex (Field2) — BOOLEAN
- age (Field3) — INT
Rank (rank)
- id (Key) — BIGINT — 기본 키 — NOT NULL
- name (Field) — TEXT
- day (Field2) — INT
- date (Field3) — DATETIME
Story (story)
- id (Key) — BIGINT — 기본 키 — NOT NULL
- player_id (FK) — BIGINT — 외래 키 → PlayerInfo.id — NOT NULL
- storyText (Field) — TEXT
- image (Field2) — BLOB