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