netflix
Tables (16)
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)
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
- 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
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
- chracterContactIdx — 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
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
- 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