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)