pjt2

Tables (12)

branch

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (question) — NOT NULL
  • Field (back_image) — NOT NULL
  • Field (left_image) — NULL
  • Field (right_image) — NULL
  • Key (story_id) — NOT NULL — Foreign key → story.Key — NOT NULL

character

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (thumbnail) — NULL
  • Field (family_ability) — NOT NULL
  • Key (story_id) — NOT NULL — Foreign key → story.Key — NOT NULL
  • Field (gender) — NOT NULL

family

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (image) — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → user.Key — NOT NULL
  • Field (gender) — NOT NULL

mycharacter

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (mystory_id) — NOT NULL — Foreign key → mystory.Key — NOT NULL
  • Key (character_id) — NOT NULL — Foreign key → character.Key — NOT NULL
  • Key (family) — NOT NULL — Foreign key → family.Key — NOT NULL

mystory

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (created) — NOT NULL
  • Key (story_id) — NOT NULL — Foreign key → story.Key — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → user.Key — NOT NULL
  • Field (story_name) — NOT NULL
  • Key (mysubstory_id) — NOT NULL — Foreign key → mysubstory.Key — NOT NULL

mysubstory

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (substory_id) — NOT NULL — Foreign key → substory.Key — NOT NULL
  • Field (next_id) — NULL
  • Field (is_end) — NOT NULL

script

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (character_id) — NOT NULL — Foreign key → character.Key — NOT NULL
  • Field (order) — NOT NULL
  • Field (content) — NOT NULL
  • Key (substory_id) — NOT NULL — Foreign key → substory.Key — NOT NULL
  • Field (has_name) — NOT NULL

select

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (select) — NOT NULL
  • Key (substory_id) — NOT NULL — Foreign key → substory.Key — NOT NULL
  • Key (branch_id) — NOT NULL — Foreign key → branch.Key — NOT NULL

story

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Key (substory_id) — NOT NULL — Foreign key → substory.Key — NOT NULL
  • Field (cover_image) — NULL

storyimage

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (is_main_character) — NOT NULL
  • Key (substory_id) — NOT NULL — Foreign key → substory.Key — NOT NULL
  • Field (order) — NOT NULL

substory

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (back_image) — NULL
  • Field (next_id) — NULL
  • Field (has_branch) — NOT NULL

user

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (email) — NOT NULL
  • Field (username) — NOT NULL
  • Field (child_name) — NULL
  • Field (child_image) — NULL
  • Field (child_gender) — NULL
  • Field (password) — NOT NULL
  • Field (last_login) — NULL
  • Field (is_superuser) — NOT NULL
  • Field (date_joined) — NULL