몽글몽글 상상나래

테이블 (5)

Choices

  • choice_id — INT — 기본 키 — NOT NULL
  • plot_id — INT
  • choice_text — TEXT — NOT NULL
  • next_plot_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • plot_id (plot_id2) — INT — 외래 키 → Plots.plot_id — NOT NULL

Images

  • image_id — INT — 기본 키 — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • plot_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Plots

  • plot_id — INT — 기본 키 — NOT NULL
  • plot_number — INT — NOT NULL
  • text — TEXT
  • image_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • user_id — INT — 외래 키 → Users.user_id — NOT NULL

Settings

  • setting_id — INT
  • setting_name — VARCHAR(255) — NOT NULL
  • setting_value — VARCHAR(255) — NOT NULL
  • user_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Users

  • user_id — INT — 기본 키 — NOT NULL
  • user_name — VARCHAR(255) — NOT NULL
  • gender — VARCHAR(50)
  • character_type — VARCHAR(100)
  • starting_place — VARCHAR(255)
  • ending_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP