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)