QuizKids - 2023-12-16 11:42:52

Tables (4)

quiz (Quiz)

  • id (quiz_id) — int — Primary key — NOT NULL
  • problem — varchar(255)
  • hit — int
  • answer — int
  • quiz_time — varchar(255)
  • answer_count — int
  • wrong_count — int
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int — Foreign key — NOT NULL
  • video_id — int — Foreign key — NOT NULL

users (User)

  • id (user_id) — int — Primary key — NOT NULL
  • nickname — varchar(40)
  • password — varchar(250)
  • sex — varchar(5)
  • age — int
  • img_idx — int
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime

videos (Video)

  • id (video_id) — int — Primary key — NOT NULL
  • name — varchar(50)
  • thumbnail — varchar(100)
  • url_link — varchar(255)
  • hit — int
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int — Foreign key — NOT NULL

view_history (ViewHistory)

  • user_id — int — Foreign key — NOT NULL
  • video_id — int — Foreign key — NOT NULL
  • stop_point — int
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime