Movie Recommend System
Tables (5)
Recommend (추천 결과물)
- id (Key) — int — Primary key — NOT NULL
- stbnumber (셋탑 번호) — int — Foreign key → USER.id — NOT NULL — user id
- rec1 (field1) — int — Foreign key → VOD.id — NOT NULL
- rec1 (recommend1) — int
- rec2 (recommend2) — int
- rec3 (recommend3) — int
- rec4 (recommend4) — int
- rec5 (recommend5) — int
- rec6 (recommend6) — int
- rec7 (recommend7) — int
- rec8 (recommend8) — int
- rec9 (recommend9) — int
- rec10 (recommend10) — int
- method — int
Review (리뷰)
- id (Key) — int — Primary key — NOT NULL
- UserID (Key2) — int — Foreign key → USER.id — NOT NULL — user id
- VodID (Key3) — int — Foreign key → VOD.id — NOT NULL
- Review (Field) — TextField
- rating (Field2) — int — 0부터 5점까지가능
USER (사용자)
- id (Key) — int — Primary key — NOT NULL — user id
- Email (Field) — email — NOT NULL
- Password (Field2) — char — NOT NULL
- is_active (Field4) — Bool — NOT NULL
- user_profile (Field5) — int
- Created_at (Field6) — date
- Updated_at (Field7) — date
- stbnumber (Field8) — int
VOD (컨텐츠 목록)
- id (Key) — int — Primary key — NOT NULL
- Name (field1) — char field — NOT NULL
- Description (field2) — Text Field
- Category (field3) — Char field — NOT NULL
- BigCategory (field4) — char Field
- smallCategory (field5) — char field
- searchactors (field6) — charfield
- actor (field7) — Json field
- director (field8) — char field
- running time (field9) — char field
- IMG_path (field10) — char field
- name_no_space (field11) — char field
- backgroundimgpath (field12) — charfield
- count (field13) — int field
- choseong (field14) — Char field
WishList (찜목록)
- id (Key) — int — Primary key — NOT NULL
- User (Key2) — int — Foreign key → USER.id — NOT NULL — user id
- VOD ID (Key3) — int — Foreign key → VOD.id — NOT NULL