팀플

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