Sua - Netflix ERD
Tables (30)
Actor
- actorIdx — BIGINT — Primary key — NOT NULL
- name — VARCHAR(45)
Alarm
- alarmIdx — BIGINT — Primary key — NOT NULL
- type — VARCHAR(45)
- profileIdx — BIGINT — Foreign key → Profile.profileIdx — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
Card
- cardIdx — BIGINT — Primary key — NOT NULL
- type — VARCHAR(45)
- cardInfo — VARCHAR(45)
- yymm — VARCHAR(4)
- userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
Category
- categoryIdx — BIGINT — Primary key — NOT NULL
- type — VARCHAR(45)
Content
- contentIdx — BIGINT — Primary key — NOT NULL
- class — VARCHAR(45)
- info — VARCHAR(100)
- canDownload — INT
- age — INT
- playtime — TIME
- previewUrl — TEXT
- title — VARCHAR(45) — NOT NULL
- releasedAt — VARCHAR(4)
- quality — VARCHAR(10)
- videoUrl — TEXT
- thumbnail — TEXT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- status — VARCHAR(10)
ContentActor
- contentActorIdx — BIGINT — Primary key — NOT NULL
- actorIdx — BIGINT — Foreign key → Actor.actorIdx — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
ContentCategory
- idx — BIGINT — Primary key — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
- categoryIdx — BIGINT — Foreign key → Category.categoryIdx — NOT NULL
ContentProducer
- contentProducerIdx — BIGINT — Primary key — NOT NULL
- producerIdx — BIGINT — Foreign key → Producer.producerIdx — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
ContentVideoGrade
- idx — BIGINT — Primary key — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
- videoGradeIdx — BIGINT — Foreign key → VideoGrade.videoGradeIdx — NOT NULL
Credit
- creditIdx — BIGINT — Primary key — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- cost — INT
- unit — VARCHAR(10)
- tax — INT
- userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
- cardIdx — BIGINT — Foreign key → Card.cardIdx — NOT NULL
- info — VARCHAR(45)
- period — VARCHAR(45)
DetailContent
- dtContentIdx — BIGINT — Primary key — NOT NULL
- season — VARCHAR(45)
- episode — INT — NOT NULL
- playtime — TIME
- title — VARCHAR(45) — NOT NULL
- info — VARCHAR(100)
- canDownload — INT
- status — VARCHAR(10)
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- quality — VARCHAR(10)
- videoUrl — TEXT
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
Dubbing
- dubbingIdx — BIGINT — Primary key — NOT NULL
- settingLangIdx — BIGINT — Foreign key → SettingLang.settingLangIdx — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
Evaluate
- evaluateIdx — BIGINT — Primary key — NOT NULL
- like — INT
- profileIdx — BIGINT — Foreign key → Profile.profileIdx — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
History
- historyIdx — BIGINT — Primary key — NOT NULL
- watchTime — TIME
- status — VARCHAR(10)
- profileIdx — BIGINT — Foreign key → Profile.profileIdx — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
Hot
- hotIdx — BIGINT — Primary key — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
LanguagePack
- languagePackIdx — BIGINT — Primary key — NOT NULL
- nation — VARCHAR(45)
LikeContent
- likeContentIdx — BIGINT — Primary key — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
- profileIdx — BIGINT — Foreign key → Profile.profileIdx — NOT NULL
Membership
- membershipIdx — BIGINT — Primary key — NOT NULL
- status — VARCHAR(10)
- type — VARCHAR(45)
- cost — INT
MostSearch
- mostSearchIdx — BIGINT — Primary key — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
New
- newIdx — BIGINT — Primary key — NOT NULL
- openDate — VARCHAR(45)
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
PresentLang
- presentLangIdx — BIGINT — Primary key — NOT NULL
- languagePackIdx — BIGINT — Foreign key → LanguagePack.languagePackIdx — NOT NULL
Producer
- producerIdx — BIGINT — Primary key — NOT NULL
- name — VARCHAR(45)
Profile
- profileIdx — BIGINT — Primary key — NOT NULL
- name — VARCHAR(45)
- image — TEXT
- password — VARCHAR(4)
- status — VARCHAR(10)
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- isKids — INT
- isNext — INT
- isPreview — INT
- userIdx — BIGINT — Foreign key → User.userIdx — NOT NULL
Recommend
- recommendIdx — BIGINT — Primary key — NOT NULL
- type — VARCHAR(45)
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
SaveContent
- saveContentIdx — BIGINT — Primary key — NOT NULL
- profileIdx — BIGINT — Foreign key → Profile.profileIdx — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
- status — VARCHAR(10)
SettingLang
- settingLangIdx — BIGINT — Primary key — NOT NULL
- languagePackIdx — BIGINT — Foreign key → LanguagePack.languagePackIdx — NOT NULL
- profileIdx — BIGINT — Foreign key → Profile.profileIdx — NOT NULL
Subtitle
- subtitleIdx — BIGINT — Primary key — NOT NULL
- settingLangIdx — BIGINT — Foreign key → SettingLang.settingLangIdx — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
Top10
- top10Idx — BIGINT — Primary key — NOT NULL
- contentIdx — BIGINT — Foreign key → Content.contentIdx — NOT NULL
User
- userIdx — BIGINT — Primary key — NOT NULL
- email — VARCHAR(45)
- password — TEXT
- phone — VARCHAR(20)
- status — VARCHAR(10)
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- membershipIdx — BIGINT — Foreign key → Membership.membershipIdx — NOT NULL
VideoGrade
- videoGradeIdx — BIGINT — Primary key — NOT NULL
- category — VARCHAR(45)