asd
Tables (5)
Choices
- choice_id — INT — Primary key — NOT NULL
- choice_text — VARCHAR(255) — NOT NULL
- next_plot_id — INT
- plot_id — INT — Foreign key → Plots.plot_id — NOT NULL
Images
- image_id — INT — Primary key — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- plot_id — INT — Foreign key → Plots.plot_id — NOT NULL
Plots
- plot_id — INT — Primary key — NOT NULL
- plot_number — INT — NOT NULL
- text — VARCHAR(255)
- image_url — VARCHAR(255)
- Story_Setting_id — INT — Foreign key → Story_Setting.Story_Setting_id — NOT NULL
Settings
- setting_id — INT — Primary key — NOT NULL
- setting_name — VARCHAR(255) — NOT NULL
- setting_value — VARCHAR(255) — NOT NULL
- Story_Setting_id — INT — Foreign key → Story_Setting.Story_Setting_id — NOT NULL
Story_Setting (Users)
- Story_Setting_id — INT — Primary key — NOT NULL
- user_name — VARCHAR(255) — NOT NULL
- gender — VARCHAR(50)
- character_type — VARCHAR(100)
- starting_place — VARCHAR(255)
- ending_count — INT
- age — INT
- era — VARCHAR(100)
- theme — VARCHAR(255)
- genre — VARCHAR(255)