netflix

Tables (7)

Contents (콘텐츠)

  • id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — string
  • description (Field2) — string
  • like (Field3) — string
  • director (Field4) — string
  • created_at (Field5) — datetime

Genres (장르)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — string

Histories (시청기록)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • video_id (Key3) — bigint — Foreign key → Video.id — NOT NULL
  • last_position (Field) — int
  • updated_at (Field2) — datetime

My_lists (찜하기)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • content_id (Key3) — bigint — Foreign key → Contents.id — NOT NULL
  • created_at (Field) — datetime

User (사용자)

  • id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — string
  • password (Field2) — string
  • role (Field3) — string
  • created_at (Field4) — datetime

Video (영상)

  • id (Key) — bigint — Primary key — NOT NULL
  • content_id (Field) — bigint
  • video_num (Field2) — int
  • runtime (Field3) — int

content_genres (콘텐츠-장르)

  • id (Key) — bigint — Primary key — NOT NULL
  • content_id (Key2) — bigint — Foreign key → Contents.id — NOT NULL
  • genre_id (Key3) — bigint — Foreign key → Genres.id — NOT NULL