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