TaleOfIshimi_ERD

Tables (3)

ItemList

  • item_id — int — Primary key — NOT NULL
  • stage_id — int — Primary key — NOT NULL
  • name — linestring — NOT NULL
  • interaction_type — enum — NOT NULL
  • is_gettable — boolean — NOT NULL
  • max_quant — int — NOT NULL

SingleStory

  • stage_id — int — Primary key — NOT NULL
  • script_id — int — Primary key — NOT NULL
  • type — enum — NOT NULL
  • bgimg_num — int — NOT NULL
  • character_id — int
  • charimg_num — int
  • content — multilinestring — NOT NULL
  • next_goto — int — NOT NULL

StageInfo

  • stage_id — int — Primary key — NOT NULL
  • stage_type — enum — NOT NULL
  • story_max — int — NOT NULL