hanTV

Tables (6)

Episode (Untitled4)

  • series_id (Key) — Primary key — NOT NULL
  • program_id (Key2) — Foreign key → Program.program_id — NOT NULL
  • title (Field)
  • episode_number (Field2)

Like (Untitled6)

  • user_id (Key) — Foreign key → user.user_id — NOT NULL
  • email (Field4) — Foreign key → user.email

Program (Untitled3)

  • program_id (Key) — Primary key — NOT NULL
  • title (Field)
  • description (Field2)
  • thumbnailPath; (Field3)

Video (Untitled2)

  • video_id (Key3) — Primary key — NOT NULL
  • episode_id (Key) — Foreign key → Episode.series_id — NOT NULL
  • program_id (Key2) — Foreign key → Episode.program_id — NOT NULL
  • file_name (Field)
  • file_path (Field2)
  • status (Field3)
  • createdAt (Field4)

comment (Untitled5)

  • series_id (Key) — Foreign key → Episode.series_id — NOT NULL
  • program_id (Key2) — Foreign key → Episode.program_id — NOT NULL
  • user_id (Key3) — Foreign key → user.user_id — NOT NULL
  • email (Field4) — Foreign key → user.email
  • user_id (Field)

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • email (Field4) — Primary key
  • user_name (Field)
  • user_nickname (Field2)
  • created_date (Field3)
  • role (Field5)