팀플
테이블 (14)
actor
- actor_id — int — NOT NULL
- actor_name — VARCHAR(50) — NOT NULL
admin (관리자)
- admin_id (Key) — varchar(15) — 기본 키 — NOT NULL
- noti_id — int — 외래 키 → notice.noti_id — NOT NULL
- que_id — int — 외래 키 → question.que_id — NOT NULL
- mem_num — int — 외래 키
director
- director_id — int — NOT NULL
- director_name — VARCHAR(50) — NOT NULL
mem_que (Untitled)
- que_id — int — 외래 키 → question.que_id — NOT NULL
- mem_num — int — 외래 키 → member.mem_num
mem_review (작성리뷰)
- mem_num — int — 외래 키 → member.mem_num
- movie_id — int — 외래 키 → movie.movie_id — NOT NULL
mem_subscribe
- mem_subscribe_value — BOOLEAN
- mem_subscribe_start — DATE — NOT NULL
- mem_subscribe_end — DATE — NOT NULL
- mem_num (mem_num2) — int — 외래 키 → member.mem_num
member
- mem_num — int — 기본 키
- mem_password — VARCHAR(20) — NOT NULL
- mem_email — VARCHAR(30) — NOT NULL
- mem_tel — VARCHAR(20) — NOT NULL
- mem_gender — BOOLEAN — NOT NULL
- mem_birth — DATE — NOT NULL
- mem_id — VARCHAR(15) — NOT NULL
movie
- movie_id — int — 기본 키 — NOT NULL
- movie_name — VARCHAR(255) — NOT NULL
- movie_genre — VARCHAR(255) — NOT NULL
- open_date — date — NOT NULL
- movie_age_limit — VARCHAR(30) — NOT NULL
- movie_description — TEXT — NOT NULL
- director_id — int — 외래 키 → director.director_id — NOT NULL
- actor_id — int — 외래 키 → actor.actor_id — NOT NULL
movie_resource_p
- movie_photo — VARCHAR(255) — NOT NULL
- movie_id — int — 외래 키 → movie.movie_id — NOT NULL
movie_resource_v
- movie_video — VARCHAR(255) — NOT NULL
- movie_id — int — 외래 키 → movie.movie_id — NOT NULL
movie_review
- review_star — TINYINT — NOT NULL
- review_avg — DOUBLE — NOT NULL
- review_content — VARCHAR(100)
- movie_id — int — 외래 키 → movie.movie_id — NOT NULL
movie_view
- movie_views — LONG — NOT NULL
- movie_id — int — 외래 키 → movie.movie_id — NOT NULL
notice
- noti_id — int — 기본 키 — NOT NULL
- noti_title — VARCHAR(30) — NOT NULL
- noti_category — int — NOT NULL
- noti_content — TEXT — NOT NULL
- noti_date — DATE — NOT NULL
- mem_num — int — 외래 키 → member.mem_num — NOT NULL
question
- que_id — int — 기본 키 — NOT NULL
- que_title — VARCHAR(30) — NOT NULL
- que_category — int — NOT NULL
- que_content — TEXT — NOT NULL
- que_date — DATE — NOT NULL
- mem_num — int — 외래 키 → member.mem_num — NOT NULL