asd

Tables (5)

Choices

  • choice_id — INT
  • plot_id — INT
  • choice_text — TEXT — NOT NULL
  • next_plot_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Images

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

Plots

  • plot_id — INT
  • plot_number — INT — NOT NULL
  • text — TEXT
  • image_url — VARCHAR(255)
  • user_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

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
  • 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