movieverse
Tables (4)
bookmark (Untitled2)
- int (bookmark_num) — Primary key
- int (member_num) — Foreign key → user.int — NOT NULL
- varchar (title) — Foreign key → review.int — NOT NULL
- int (choice_num)
- date (join_date)
- varchar (choice)
- varchar (poster)
- varchar (overview)
review (Untitled)
- int (review_num) — Primary key — NOT NULL
- int (like_num) — Foreign key → review_like.int — NOT NULL
- int (member_num) — Foreign key → user.int — NOT NULL
- date (review_date) — NOT NULL
- int (content_id)
- varchar (choice_content)
- varchar (review_content)
- flaot (star_rating)
- varchar (title)
- varchar (poster)
review_like (Untitled4)
- int (like_num) — Primary key — NOT NULL
- int (like_user_num)
- int (like_review_num)
user (Untitled3)
- int (member_num) — Primary key — NOT NULL
- varchar (email)
- varchar (passwd)
- varchar (nickname)
- date (join_date)
- varchar (img_link)
- varchar (identification)