final_pjt
Tables (10)
Answer
- Answer_id (answer_id) — PRIMARY_KEY — Primary key — NOT NULL
- Name (name) — NOT NULL
- Image (image) — NOT NULL
- Chapter_id (chapter_id) — PRIMARY_KEY — Foreign key → Chapter.Chapter_id — NOT NULL
BackgroundImage
- BackgroundImage_id (backgroundimage_id) — PRIMARY_KEY — Primary key — NOT NULL
- Image (image) — NOT NULL
- Chapter_id (chapter_id) — PRIMARY_KEY — Foreign key → Chapter.Chapter_id — NOT NULL
Chapter
- Chapter_id (chapter_id) — PRIMARY_KEY — Primary key — NOT NULL
- Title (title) — NOT NULL
- Clear_user (clear_user) — PRIMARY_KEY — Foreign key → User.User_id — NOT NULL
- Story_id (story_id) — PRIMARY_KEY — Foreign key → Story.Story_id — NOT NULL
Collection
- Collection_id (collection_id) — PRIMARY_KEY — Primary key — NOT NULL
- Image (image) — NOT NULL
- Timestamp (timestamp) — NOT NULL
- Chapter_id (chapter_id) — PRIMARY_KEY — Foreign key → Chapter.Chapter_id — NOT NULL
- User_id (user_id) — PRIMARY_KEY — Foreign key → User.User_id — NOT NULL
Item
- Item_id (item_id) — PRIMARY_KEY — Primary key — NOT NULL
- Name (name) — NOT NULL
- Sort_id (sort_id) — NOT NULL — Foreign key → Sort.Sort_id — NOT NULL
Script
- Script_id (script_id) — PRIMARY_KEY — Primary key — NOT NULL
- Name (name) — NOT NULL
- Content (content) — NOT NULL
- Record (record) — NOT NULL
- BackgroundImage_id (backgroundimage_id) — PRIMARY_KEY — Foreign key → BackgroundImage.BackgroundImage_id — NOT NULL
Sort
- Sort_id (sort_id) — PRIMARY_KEY — Primary key — NOT NULL
- Name (name) — NOT NULL
Story
- Story_id (story_id) — PRIMARY_KEY — Primary key — NOT NULL
- Title (title) — NOT NULL
- Chapter_cnt (chapter_cnt) — NOT NULL
- Image (image) — NOT NULL
- Difficulty (difficulty) — NOT NULL
- Clear_user (clear_user) — PRIMARY_KEY — Foreign key → User.User_id — NOT NULL
User
- User_id (user_id) — PRIMARY_KEY — Primary key — NOT NULL
- Name (name) — NOT NULL
- Age (age) — NOT NULL
- Gender (gender) — NOT NULL
- Play_time (play_time) — NULL
- Play_cnt (play_cnt) — NULL
- One_pick (one_pick) — NULL
- Story_id (story_id) — PRIMARY_KEY — Foreign key → Story.Story_id — NOT NULL
- Chapter_id (chapter_id) — PRIMARY_KEY — Foreign key → Chapter.Chapter_id — NOT NULL
Wear
- Wear_id (wear_id) — PRIMARY_KEY — Primary key — NOT NULL
- Check (check) — NOT NULL
- User_id (user_id) — PRIMARY_KEY — Foreign key → User.User_id — NOT NULL
- Item_id (item_id) — PRIMARY_KEY — Foreign key → Item.Item_id — NOT NULL