최종프젝
테이블 (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)