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