몽글몽글 상상나래
테이블 (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