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`