무비버스

테이블 (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)