무비버스
테이블 (6)
mark (북마크테이블)
- mark_num (Key) — int — 기본 키 — NOT NULL
- member_num (Key2) — int — 외래 키 → member.member_num — NOT NULL
- poster_path (Field) — varchar(45)
- mark_time (Field2) — char(10)
- type (Field3) — varchar(50)
- data_id (Field4) — varchar(50)
member (회원)
- member_num (Key) — int — 기본 키 — NOT NULL
- member_id (Field) — varchar(45)
- member_nick (Field2) — varchar(45)
- member_name (Field3) — varchar(45)
- member_pw (Field4) — varchar(45)
- member_sex (Field5) — char(2)
- member_address (Field6) — varchar(200)
- member_money (Field7) — int
- member_regtime (Field8) — varchar(50)
movie_review (영화리뷰)
- m_review_num (Key) — int — 기본 키 — NOT NULL
- member_num (Key2) — int — 외래 키 → member.member_num — NOT NULL
- m_review_star (Field) — int
- m_review_content (Field2) — varchar(1000)
- m_review_time (Field3) — char(10)
- m_review_content_id (Field4) — varchar(45)
- member_nick (Field5) — varchar(45)
- member_id (Field6) — varchar(45)
- poster_path (Field7) — varchar(45)
- data_id (Field8) — varchar(50)
- type (Field9) — varchar(50)
shareMember (계정공유_가입자)
- shareMember_num (Key) — int — 기본 키 — NOT NULL
- member_num (Key2) — int — 외래 키 → member.member_num — NOT NULL
- sharParty_num (Key3) — int — 외래 키 → shareParty.sharParty_num — NOT NULL
- member_num (Key22) — int — 외래 키 → shareParty.header_num — NOT NULL
shareParty (계정공유_파티)
- sharParty_num (Key) — int — 기본 키 — NOT NULL
- header_num (Key2) — int — 외래 키 → member.member_num — NOT NULL
- sharParty_time (Field) — varchar(20)
- sharParty_gauge (Field2) — int
- ott_name (Field3) — varchar(50)
- ottprice (Field4) — int
- shareHeader_bankName (Field5) — varchar(50)
- shareHeader_accountNum (Field6) — varchar(50)
- ott_id (Field7) — varchar(50)
- ott_pw (Field8) — varchar(50)
tv_review (tv시리즈리뷰)
- t_review_num (Key) — int — 기본 키 — NOT NULL
- member_num (Key2) — int — 외래 키 → member.member_num — NOT NULL
- t_review_star (Field) — int
- t_review_content (Field2) — varchar(1000)
- t_review_time (Field3) — char(10)
- t_review_content_id (Field4) — varchar(45)
- member_nick (Field5) — varchar(45)
- member_id (Field6) — varchar(45)
- poster_path (Field7) — varchar(45)
- data_id (Field8) — varchar(50)
- type (Field9) — varchar(50)