3rd week - netflix ERD

Tables (30)

Actor (출연 배우)

  • actorIdx (pk) — INT — Primary key — NOT NULL
  • name (출연자 이름) — VARCHAR(45)

Alarm (알림)

  • alarmIdx (pk) — INT — Primary key — NOT NULL
  • type (알림타입(신규,시청중)) — VARCHAR(45)
  • cotentIdx (fk) — INT — Foreign key → Content.cotentIdx — NOT NULL
  • profileIdx (pk2) — INT — Foreign key → Profile.profileIdx — NOT NULL

Card (결제카드)

  • cardIdx (pk) — INT — Primary key — NOT NULL
  • type (카드종류) — VARCHAR(45)
  • cardInfo (카드번호) — VARCHAR(45)
  • yymm (유효기간)
  • userIdx (fk) — INT — Foreign key → User.userIdx — NOT NULL

Category (카테고리)

  • categoryIdx (pk) — INT — Primary key — NOT NULL
  • type (카테고리) — VARCHAR(45)

Content (콘텐츠)

  • cotentIdx (pk) — INT — Primary key — NOT NULL
  • class (콘텐츠 클래스) — VARCHAR(45)
  • info (상세정보) — VARCHAR(100)
  • canDownload (저장 가능 여부) — INT
  • age (관람 가능 연령) — INT
  • playtime (재생 시간) — TIME
  • prieviewUrl (미리보기 영상 링크) — TEXT
  • title (콘텐츠 타이틀) — VARCHAR(45)
  • releasedAt (개봉 년도) — VARCHAR(4)
  • quality (영상 화질) — VARCHAR(10)

ContentActor (콘텐츠-출연자)

  • contentActorIdx (pk) — INT — Primary key — NOT NULL
  • actorIdx (pk2) — INT — Foreign key → Actor.actorIdx — NOT NULL
  • cotentIdx (pk3) — INT — Foreign key → Content.cotentIdx — NOT NULL

ContentCategory (콘텐츠-카테고리)

  • idx (pk) — INT — Primary key — NOT NULL
  • cotentIdx (fk) — INT — Foreign key → Content.cotentIdx — NOT NULL
  • categoryIdx (fk2) — INT — Foreign key → Category.categoryIdx — NOT NULL

ContentProducer (콘텐츠-크리에이터)

  • contentProducerIdx (pk) — INT — Primary key — NOT NULL
  • producerIdx (pk2) — INT — Foreign key → Producer.producerIdx — NOT NULL
  • cotentIdx (pk3) — INT — Foreign key → Content.cotentIdx — NOT NULL

ContentVideoGrade (콘텐츠-영상 관람등급)

  • idx (pk) — INT — Primary key — NOT NULL
  • cotentIdx (fk) — INT — Foreign key → Content.cotentIdx — NOT NULL
  • videoGradeIdx (fk2) — INT — Foreign key → VideoGrade.videoGradeIdx — NOT NULL

Credit (결제정보)

  • creditIdx (pk) — INT — Primary key — NOT NULL
  • createdAt (결제일자) — TIMESTAMP
  • updatedAt (수정일자) — TIMESTAMP
  • cost (결제금액) — INT
  • unit (단위) — VARCHAR(10)
  • tax (부가세) — INT
  • userIdx (fk) — INT — Foreign key → User.userIdx — NOT NULL

DetailContent (상세콘텐츠)

  • dtContentIdx (pk) — INT — Primary key — NOT NULL
  • season (시즌) — VARCHAR(45) — NOT NULL
  • episode (회차) — INT — NOT NULL
  • playtime (재생시간) — TIME
  • title (회차제목) — VARCHAR(45)
  • info (회차소개) — VARCHAR(100)
  • canDownload (저장가능) — INT
  • status (상태) — VARCHAR(10)
  • createdAt (등록일자) — TIMESTAMP
  • updatedAt (수정일자) — TIMESTAMP
  • quality (영상화질) — VARCHAR(10)
  • cotentIdx (fk) — INT — Foreign key → Content.cotentIdx — NOT NULL

Dubbing (음성)

  • Key — Primary key — NOT NULL
  • Field

Evaluate (평가)

  • evaluateIdx (pk) — INT — Primary key — NOT NULL
  • like (선호도) — INT
  • Field2
  • profileIdx (fk) — INT — Foreign key → Profile.profileIdx — NOT NULL
  • cotentIdx (fk2) — INT — Foreign key → Content.cotentIdx — NOT NULL

History (시청기록)

  • historyIdx (pk) — INT — Primary key — NOT NULL
  • watchTime (시청시간) — TIME
  • profileIdx (pk2) — INT — Foreign key → Profile.profileIdx — NOT NULL
  • cotentIdx (pk3) — INT — Foreign key → Content.cotentIdx — NOT NULL
  • status (기록 상태) — VARCHAR(10)
  • Field

Hot (모두가좋아해요)

  • hotIdx (pk) — INT — Primary key — NOT NULL
  • Field
  • cotentIdx (fk) — INT — Foreign key → Content.cotentIdx — NOT NULL

LanguagePack (제공언어팩)

  • languagePackIdx (Key) — INT — Primary key — NOT NULL
  • nation (언어) — VARCHAR(45)

LikeContent (찜한콘텐츠)

  • likeContentIdx (pk) — Primary key — NOT NULL
  • Field
  • Field2
  • profileIdx (pk2) — INT — Foreign key → Profile.profileIdx — NOT NULL

Membership (멤버쉽)

  • membershipIdx (pk) — INT — Primary key — NOT NULL
  • status (상태) — VARCHAR(10)
  • type (멤버쉽종류) — VARCHAR(45)
  • cost (비용) — INT

MostSearch (최다검색)

  • mostSearchIdx (pk) — INT — Primary key — NOT NULL
  • cotentIdx (fk) — INT — Foreign key → Content.cotentIdx — NOT NULL

New (공개 예정)

  • newIdx (pk) — INT — Primary key — NOT NULL
  • openDate (공개예정일) — VARCHAR(45)
  • cotentIdx (fk) — INT — Foreign key → Content.cotentIdx — NOT NULL

PresentLang (표시언어)

  • Key2 — Primary key — NOT NULL
  • languagePackIdx (Key) — INT — Foreign key → LanguagePack.languagePackIdx — NOT NULL

Producer (크리에이터)

  • producerIdx (pk) — INT — Primary key — NOT NULL
  • name (크리에이터 이름) — VARCHAR(45)

Profile (프로필)

  • profileIdx (pk) — INT — Primary key — NOT NULL
  • name (프로필 이름) — VARCHAR(45)
  • image (프로필 아이콘) — INT
  • password (프로필 비밀번호) — VARCHAR(4)
  • status (프로필 상태) — varchar(10)
  • createdAt (생성날짜) — TIMESTAMP
  • updatedAt (수정날짜) — TIMESTAMP
  • isKids (키즈 프로필 여부) — INT
  • isNext (다음화 자동 재생 여부) — INT
  • isPreview (미리보기 자동 재생 여부) — INT
  • userIdx (회원 pk) — INT — Foreign key → User.userIdx — NOT NULL
  • storage (저장 용량) — INT

SaveContent (저장한콘텐츠목록)

  • saveContentIdx (pk) — INT — Primary key — NOT NULL
  • Field
  • profileIdx (fk) — INT — Foreign key → Profile.profileIdx — NOT NULL
  • cotentIdx (fk2) — INT — Foreign key → Content.cotentIdx — NOT NULL

SettingLang (설정언어)

  • Key — Primary key — NOT NULL
  • languagePackIdx (fk) — INT — Foreign key → LanguagePack.languagePackIdx — NOT NULL

Subtitle (자막)

  • Key — Primary key — NOT NULL
  • Field

Top10 (톰10)

  • top10Idx (pk) — INT — Primary key — NOT NULL
  • Field
  • cotentIdx (fk) — INT — Foreign key → Content.cotentIdx — NOT NULL

User (회원)

  • userIdx (pk) — INT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(45)
  • password (비밀번호) — VARCHAR(100)
  • phone (전화번호) — TEXT
  • status (회원 상태) — varchar(10)
  • createdAt (생성날짜) — TIMESTAMP
  • updatedAt (수정날짜) — TIMESTAMP

VideoGrade (영상 관람등급)

  • videoGradeIdx (pk) — INT — Primary key — NOT NULL
  • category (심의 항목) — VARCHAR(45)

recommend (추천)

  • recommendIdx (pk) — INT — Primary key — NOT NULL
  • type (추천 타입) — VARCHAR(45)
  • cotentIdx (pk2) — INT — Foreign key → Content.cotentIdx — NOT NULL