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