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