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)