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