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