netflix_b팀 본(Bon)

테이블 (18)

Account

  • accountIdx — BIGINT — 기본 키 — 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 — 기본 키 — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • upatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL

ActorParticipate

  • actorParticipateIdx — BIGINT — 기본 키 — NOT NULL
  • actorIdx — BIGINT — 외래 키 → Actor.actorIdx — NOT NULL
  • videoIdx — BIGINT — 외래 키 → Video.videoIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • INDEX — `fk_Video_has_Actor_Actor1_idx`
  • INDEX — `fk_ActorParticipate_Video1_idx`

Alarm

  • alarmIdx — BIGINT — 기본 키 — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • profileIdx — BIGINT — 외래 키 → Profile.profileIdx — NOT NULL
  • videoIdx — BIGINT — 외래 키 → Video.videoIdx — NOT NULL
  • INDEX — `fk_Alarm_Video1_idx`
  • INDEX — `profileIdx`

Assessment

  • assessmentIdx — BIGINT — 기본 키 — NOT NULL
  • profileIdx — BIGINT — 외래 키 → Profile.profileIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • videoIdx — BIGINT — 외래 키 → Video.videoIdx — NOT NULL
  • INDEX — `fk_Like_Profile1_idx`
  • INDEX — `fk_Like_Video1_idx`

Bookmark

  • bookmarkIdx — BIGINT — 기본 키 — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • videoIdx — BIGINT — 외래 키 → Video.videoIdx — NOT NULL
  • profileIdx — BIGINT — 외래 키 → Profile.profileIdx — NOT NULL
  • INDEX — `fk_Bookmark_Video1_idx`
  • INDEX — `fk_Bookmark_Profile1_idx`

Character

  • characterIdx — BIGINT — 기본 키 — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • upatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL

CharacterContact

  • characterContactIdx — BIGINT — 기본 키 — NOT NULL
  • characterIdx — BIGINT — 외래 키 → Character.characterIdx — NOT NULL
  • videoIdx — BIGINT — 외래 키 → Video.videoIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • INDEX — `fk_Character_has_Video_Video1_idx`
  • INDEX — `fk_Character_has_Video_Character1_idx`

Director

  • directorIdx — BIGINT — 기본 키 — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • upatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL

DirectorParticipate

  • directorParticipateIdx — BIGINT — 기본 키 — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • videoIdx — BIGINT — 외래 키 → Video.videoIdx — NOT NULL
  • directorIdx — BIGINT — 외래 키 → Director.directorIdx — NOT NULL
  • INDEX — `fk_DirectorParticipate_Video1_idx`
  • INDEX — `fk_DirectorParticipate_Director1_idx`

Genre

  • genreIdx — BIGINT — 기본 키 — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • upatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL

GenreContact

  • genreContactIdx — BIGINT — 기본 키 — NOT NULL
  • genreIdx — BIGINT — 외래 키 → Genre.genreIdx — NOT NULL
  • videoIdx — BIGINT — 외래 키 → Video.videoIdx — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • INDEX — `fk_Video_has_Genre_Genre1_idx`
  • INDEX — `fk_GenreContact_Video1_idx`

Play

  • playIdx — BIGINT — 기본 키 — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • currentPlayTime — FLOAT — NOT NULL
  • profileIdx — BIGINT — 외래 키 → Profile.profileIdx — NOT NULL
  • videosIdx — BIGINT — 외래 키 → Videos.videosIdx — NOT NULL
  • INDEX — `fk_MoviePlay_Profile1_idx`
  • INDEX — `fk_Play_Videos1_idx`

Profile

  • profileIdx — BIGINT — 기본 키 — 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
  • accountIdx — BIGINT — 외래 키 → Account.accountIdx — NOT NULL
  • profilePhotoIdx — BIGINT — 외래 키 → ProfilePhoto.profilePhotoIdx — NOT NULL
  • status — TINYINT — NOT NULL
  • INDEX — `fk_Profile_Account_idx`
  • INDEX — `fk_Profile_ProfilePhoto1_idx`

ProfilePhoto

  • profilePhotoIdx — BIGINT — 기본 키 — 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 — 기본 키 — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • status — TINYINT — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL

Video

  • videoIdx — BIGINT — 기본 키 — 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 — 기본 키 — 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
  • videoIdx — BIGINT — 외래 키 → Video.videoIdx — NOT NULL
  • INDEX — `fk_VideoList_Video2_idx`