sfsdf

Tables (9)

Member

  • member_id — varchar(20) — Primary key — NOT NULL
  • member_pw — varchar(20)
  • member_email — varchar(50)
  • member_addr — varchar(200)
  • memeber_name — varchar(20)
  • member_phone — varchar(30)
  • member_birth — date
  • genre — varchar(50) — Foreign key → MovieGenre.genre — NOT NULL
  • member_recent_login — date
  • member_recent_logout — date

MovieBoard

  • mboard_no — int — Primary key — NOT NULL
  • moviecd — int — Foreign key → MovieDB.moviecd — NOT NULL
  • member_id — varchar(20) — Foreign key → Member.member_id — NOT NULL
  • mboard_title — varchar(1000)
  • mboard_header — varchar(50)
  • mboard_reg_date — date
  • mboard_hit_cnt — int
  • mboard_content — longtext
  • mboard_like_cnt — int
  • mboard_dislike_cnt — int
  • mboard_report_cnt — int
  • mboard_reply_cnt — int

MovieDB

  • moviecd — int — Primary key — NOT NULL
  • title — varchar(100)
  • director — varchar(20)
  • actor — varchar(100)
  • opendt — varchar(20)
  • runtime — varchar(10)
  • genre — varchar(50)
  • plot — longtext
  • poster — varchar(200)
  • audiacc — varchar(50)

MovieGenre

  • genre — varchar(50) — Primary key — NOT NULL
  • moviecd — int — Foreign key → MovieDB.moviecd

MovieRate

  • moviecd — int — Primary key — Foreign key → MovieDB.moviecd — NOT NULL
  • member_id — varchar(20) — Primary key — Foreign key → Member.member_id — NOT NULL
  • movie_rate — double
  • movie_reply — varchar(200)

MovieReply

  • mboard_rno — int — Primary key — NOT NULL
  • moviecd — int — Foreign key → MovieDB.moviecd — NOT NULL
  • mboard_no — int — Foreign key → MovieBoard.mboard_no — NOT NULL
  • member_id — varchar(20) — Foreign key → Member.member_id — NOT NULL
  • mreply_content — text
  • mreply_like_cnt — int
  • mreply_dislike_cnt — int
  • mreply_report_cnt — int

MovieWishList

  • moviecd — int — Primary key — Foreign key → MovieDB.moviecd — NOT NULL
  • member_id — varchar(20) — Primary key — Foreign key → Member.member_id — NOT NULL

NormalBoard

  • nboard_no — int — Primary key — NOT NULL
  • member_id — varchar(20) — Foreign key → Member.member_id — NOT NULL
  • nboard_title — varchar(1000)
  • nboard_reg_date — date
  • mboard_hit_cnt — int
  • nboard_content — longtext
  • nboard_like_cnt — int
  • nboard_dislike_cnt — int
  • nboard_report_cnt — int
  • nboard_reply_cnt — int

NormalReply

  • nboard_rno — int — Primary key — NOT NULL
  • nboard_no — int — Foreign key → NormalBoard.nboard_no — NOT NULL
  • member_id — varchar(20) — Foreign key → Member.member_id — NOT NULL
  • mreply_content — text
  • mreply_like_cnt — int
  • mreply_dislike_cnt — int
  • mreply_report_cnt — int