QuiziumERD
Tables (7)
Channel (channel)
- id (Key) — bigint — Primary key — NOT NULL
- channel_id (Field) — varchar
- title (Field2) — varchar
- url (Field3) — varchar
- publisher_name (Field4) — varchar
- is_supported_channel (Field5) — boolean
Chapter (chapter)
- id (Key) — bigint — Primary key — NOT NULL
- video_id (FK) — bigint — Foreign key → Video.id — NOT NULL
- title (Field) — varchar
- start_time (Field2) — integer
- end_time (Field3) — integer
Question (question)
- id (Key) — bigint — Primary key — NOT NULL
- chapter_id (FK) — bigint — Foreign key → Chapter.id — NOT NULL
- title (Field) — varchar
- answers (Field2) — json
- distractors (Field3) — json
- model_version (Field4) — varchar
- description (Field5) — varchar
- _type (Field6) — varchar
- subtitle_type (Field7) — varchar
QuestionFeedBack (questionfeedback)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- question_id (FK2) — bigint — Foreign key → Question.id — NOT NULL
- _type (Field) — varchar
Summary (summary)
- id (Key) — bigint — Primary key — NOT NULL
- video_id (FK) — bigint — Foreign key → Video.id — NOT NULL
- summary (Field) — varchar
- model_version (Field2) — varchar
User (user)
- id (Key) — bigint — Primary key — NOT NULL
- email (Field) — varchar
- password (Field2) — varchar
- first_name (Field3) — varchar
- last_name (Field4) — varchar
- picture (Field5) — varchar
- locale (Field6) — varchar
- is_active (Field7) — boolean
- is_staff (Field8) — boolean
- sns_type (Field9) — varchar
- is_completed_onboarding (Field10) — boolean
Video (video)
- id (Key) — bigint — Primary key — NOT NULL
- channel_id (FK) — bigint — Foreign key → Channel.id — NOT NULL
- url (Field) — varchar
- thumbnail_url (Field2) — varchar
- video_id (Field3) — varchar
- title (Field4) — varchar
- tags (Field5) — json
- keywords (Field6) — json
- published_at (Field7) — datetime
- length (Field8) — integer