아마존 익스프레스

테이블 (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