netflix
Tables (10)
Casting (배우)
- cast_id — INT — Primary key — NOT NULL — 배우 ID (PK)
- cast (actor) — VARCHAR — 배우 이름
- created_at (Field) — NOT NULL
Director (감독)
- director_id — INT — Primary key — NOT NULL — 감독 ID (PK)
- director — VARCHAR — 감독 이름
- created_at — NOT NULL
Link_Cast_Showfact (관계형 테이블)
- show_id — VARCHARA — Foreign key → Showfact.show_id — NOT NULL — 작품 ID (FK)
- cast_id — INT — Foreign key → Casting.cast_id — NOT NULL — 배우 ID (FK)
- created_at (Field) — NOT NULL
Link_Director_Showfact (관계형 테이블3)
- show_id — VARCHARA — Foreign key → Showfact.show_id — NOT NULL — 작품 ID (FK)
- director_id — INT — Foreign key → Director.director_id — NOT NULL — 감독 ID (PK)
- created_at (Field) — NOT NULL
Link_ListedIn_Showfact (관계형 테이블2)
- show_id — VARCHAR — Foreign key → Showfact.show_id — NOT NULL — 작품 ID (FK)
- listed_in_id — Foreign key → Listed_in.listed_in_id — NOT NULL — 장르ID (FK)
- created_at (Field) — NOT NULL
Listed_in (장르)
- listed_in_id — Primary key — NOT NULL — 장르ID (PK)
- listed_in — NOT NULL — 장르
- created_at — NOT NULL
ShowMain (작품조회)
- showmain_id — INT — Primary key — NOT NULL — 작품조회ID (PK)
- show_id — VARCHARA — Foreign key → Showfact.show_id — NOT NULL — 작품 ID (FK)
- title — VARCHAR — NOT NULL — 작품 제목
- created_at — NOT NULL
Showfact (작품)
- show_id — VARCHAR — Primary key — NOT NULL — 작품 ID (PK)
- type — VARCHAR — NOT NULL — 콘텐츠 타입 (예: Movie, TV Show)
- duration — VARCHAR — 상영 시간
- country — VARCHAR — 제작 국가
- date_added — DATE — 등록일
- released_year — INT — 출시 연도
- description — TEXT — 설명
- created_at — NOT NULL
User (Untitled)
- User_id — Primary key — NOT NULL — 사용자ID(PK)
- username — NOT NULL — 사용자명
- password — NOT NULL — 비밀번호
- email — NOT NULL — 이메일
- age — INT
- created_at — NOT NULL
UserPreference (Untitled2)
- User_id — Foreign key → User.User_id — NOT NULL — 사용자ID(FK)
- director_id — INT — Foreign key → Director.director_id — NOT NULL — 감독 ID (FK)
- cast_id — INT — Foreign key → Casting.cast_id — NOT NULL — 배우 ID (FK)
- listed_in_id — Foreign key → Listed_in.listed_in_id — NOT NULL — 장르ID (FK)
- created_at — NOT NULL