4flex

Tables (6)

Untitled (movie_info)

  • Key (movieidx) — Primary key — NOT NULL
  • Field (title)
  • Field2 (desc)
  • Field3 (director)
  • Field4 (actors)
  • Field5 (date)
  • Field6 (age)
  • Field7 (pic1)
  • Field8 (pic2)
  • Field9 (pic3)
  • Field11 (genre)

Untitled (comment)

  • Key (reviewid) — Primary key — NOT NULL
  • Field2 (rate)
  • Field3 (comment)
  • Key (useridx) — int — Foreign key → user.Key — NOT NULL
  • Key (movieidx) — Foreign key → Untitled.Key — NOT NULL
  • Field (date)

comment like (Untitled)

  • Key (commentlikeidx) — Primary key — NOT NULL
  • Key (reviewid) — Foreign key → Untitled.Key — NOT NULL
  • Key (useridx) — int — Foreign key → user.Key — NOT NULL

fav movie (Untitled2)

  • Key (favmovieidx) — Primary key — NOT NULL
  • Key (useridx) — int — Foreign key → user.Key — NOT NULL
  • Key (movieidx) — Foreign key → Untitled.Key — NOT NULL

movie like

  • Key (movielikeidx) — Primary key — NOT NULL
  • Key (useridx) — int — Foreign key → user.Key — NOT NULL
  • Key (movieidx) — Foreign key → Untitled.Key — NOT NULL

user

  • Key (useridx) — int — Primary key — NOT NULL
  • Field (userid) — varchar(10)
  • Field2 (pw) — varchar(20)
  • Field3 (email) — varchar(20)
  • Field (nickname) — varchar(10)
  • Field (img) — varchar(10)
  • Field (favourite) — varchar(10)