최종프젝

테이블 (6)

TB_board

  • board_num (Key) — 기본 키 — NOT NULL
  • user_num (Key2) — 외래 키 → TB_user.user_num — NOT NULL
  • b_user_id (Field)
  • board_title (Field2)
  • board_content (Field4)
  • board_date (Field5)
  • board_hit (Field3)
  • Field6

TB_movie

  • code (Key2) — 기본 키 — NOT NULL
  • title_eng (Field2)
  • title_kor (Field3)
  • genres (Field4)
  • director (Field5)
  • cast (Field7)
  • directors_kor (Field8)
  • cast_kor (Field6)
  • naver_user_rate (Field9)
  • naver_user_participate (Field10)
  • naver_critics_rate (Field11)
  • naver_critics_participate (Field12)
  • nation (Field13)
  • release_date (Field14)
  • running_time (Field15)
  • age (Field16)
  • story (Field17)
  • poster_url (Field18)
  • url (Field19) — \
  • movieId (Field)

TB_rating

  • rating_num (Key) — 기본 키 — NOT NULL
  • mv_code (Key22) — 외래 키 → TB_movie.code — NOT NULL
  • userId (Field)
  • rt_user_id (Field2)
  • movieId (Field3)
  • user_rating (Field5)

TB_reply

  • reply_num (Key) — 기본 키 — NOT NULL
  • board_num (Key2) — 외래 키 → TB_board.board_num — NOT NULL
  • r_user_num (Field)
  • r_user_id (Field2)
  • reply_content (Field4)
  • reply_date (Field5)

TB_user

  • user_num (Key) — 기본 키 — NOT NULL
  • user_name (Field)
  • user_id (Field2)
  • user_pwd (Field3)
  • user_phone (Field4)
  • user_email (Field5)
  • user_sex (Field7)
  • 생년월일 (Field8)

recommend_movies

  • index (Key) — 기본 키 — NOT NULL
  • userID (Key2) — 외래 키 → TB_user.user_num — NOT NULL
  • section (Field)
  • rec_mv_id (Field2)
  • title_kor (Field4)
  • poster_url (Field5)