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)