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)