final_Netflix

Tables (18)

Account

  • accountIdx — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(300) — NOT NULL
  • phoneNumber — VARCHAR(100)
  • membership — VARCHAR(30)
  • socialLoginIdx — VARCHAR(50)
  • socialLoginType — VARCHAR(50)
  • membershipStartDate — DATETIME
  • maileSubscriptionAgreement — TINYINT — NOT NULL

Actor

  • actorIdx — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • upatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL

ActorParticipate

  • actorParticipateIdx — BIGINT — Primary key — NOT NULL
  • actorIdx — BIGINT — Foreign key → Actor.actorIdx — NOT NULL
  • videoIdx — BIGINT — Foreign key → Video.videoIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL

Alarm

  • alarmIdx — BIGINT — Primary key — NOT NULL
  • profileIdx — BIGINT — Foreign key → Profile.profileIdx — NOT NULL
  • videoIdx — BIGINT — Foreign key → Video.videoIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL

Assessment

  • assessmentIdx — BIGINT — Primary key — NOT NULL
  • profileIdx — BIGINT — Foreign key → Profile.profileIdx — NOT NULL
  • videoIdx — BIGINT — Foreign key → Video.videoIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL

Bookmark

  • bookmarkIdx — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • videoIdx — BIGINT — Foreign key → Video.videoIdx — NOT NULL
  • profileIdx — BIGINT — Foreign key → Profile.profileIdx — NOT NULL

Character

  • characterIdx — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • upatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL

CharacterContact

  • characterContactIdx — BIGINT — Primary key — NOT NULL
  • characterIdx — BIGINT — Foreign key → Character.characterIdx — NOT NULL
  • videoIdx — BIGINT — Foreign key → Video.videoIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL

Director

  • directorIdx — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • upatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL

DirectorParticipate

  • directorParticipateIdx — BIGINT — Primary key — NOT NULL
  • directorIdx — BIGINT — Foreign key → Director.directorIdx — NOT NULL
  • videoIdx — BIGINT — Foreign key → Video.videoIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL

Genre

  • genreIdx — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • upatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL

GenreContact

  • genreContactIdx — BIGINT — Primary key — NOT NULL
  • genreIdx — BIGINT — Foreign key → Genre.genreIdx — NOT NULL
  • videoIdx — BIGINT — Foreign key → Video.videoIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL

Play

  • playIdx — BIGINT — Primary key — NOT NULL
  • profileIdx — BIGINT — Foreign key → Profile.profileIdx — NOT NULL
  • videosIdx — BIGINT — Foreign key → Videos.videosIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • currentPlayTime — FLOAT — NOT NULL

Profile

  • profileIdx — BIGINT — Primary key — NOT NULL
  • accountIdx — BIGINT — Foreign key → Account.accountIdx — NOT NULL
  • profilePhotoIdx — BIGINT — Foreign key → ProfilePhoto.profilePhotoIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • language — VARCHAR(50) — NOT NULL
  • ageGrade — INT — NOT NULL
  • settingAutoPrePlay — INT — NOT NULL
  • settingAutoNextPlay — INT
  • status — TINYINT — NOT NULL

ProfilePhoto

  • profilePhotoIdx — BIGINT — Primary key — NOT NULL
  • profilePhotoUrl — TEXT — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL

Search

  • searchIdx — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL

Video

  • videoIdx — BIGINT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • ageGrade — INT — NOT NULL
  • runningTime — VARCHAR(50)
  • photoUrl — TEXT — NOT NULL
  • heightPhotoUrl — TEXT
  • year — INT — NOT NULL
  • season — INT — NOT NULL
  • resolution — VARCHAR(30)
  • summary — TEXT — NOT NULL
  • director — VARCHAR(50)
  • previewVideoUrl — TEXT
  • openDate — DATETIME
  • closeDate — DATETIME
  • award — TINYINT — NOT NULL

Videos

  • videosIdx — BIGINT — Primary key — NOT NULL
  • videoIdx — BIGINT — Foreign key → Video.videoIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • runningTime — VARCHAR(45) — NOT NULL
  • summary — TEXT
  • season — INT
  • url — TEXT
  • episode — INT