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