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