movie

Tables (5)

actor

  • actor_index — BIGINT(20) — Primary key — NOT NULL — 배우번호
  • birth — DATE — NOT NULL — 생년월일
  • name — VARCHAR(50) — NOT NULL — 이름' COLLATE 'utf8mb3_general_ci
  • gender — VARCHAR(50) — NOT NULL — 성별' COLLATE 'utf8mb3_general_ci
  • birth_place — VARCHAR(50) — NOT NULL — 출생지' COLLATE 'utf8mb3_general_ci
  • height — INT(11) — NOT NULL — 키
  • weight — INT(11) — NOT NULL — 몸무게
  • blood_type — VARCHAR(50) — NOT NULL — 혈액형' COLLATE 'utf8mb3_general_ci

director

  • director_index — BIGINT(20) — Primary key — NOT NULL — 등록번호
  • name — VARCHAR(50) — NOT NULL — 이름' COLLATE 'utf8mb3_general_ci
  • gender — VARCHAR(50) — NOT NULL — 성별' COLLATE 'utf8mb3_general_ci
  • birth — DATE — NOT NULL — 생년월일
  • birth_place — VARCHAR(50) — NOT NULL — 출생지' COLLATE 'utf8mb3_general_ci
  • education — VARCHAR(50) — NOT NULL — 학력사항' COLLATE 'utf8mb3_general_ci

movie

  • movie_code — BIGINT(20) — Primary key — NOT NULL — 영화코드 번호
  • title — VARCHAR(50) — NOT NULL — 제목' COLLATE 'utf8mb3_general_ci
  • make_year — VARCHAR(50) — NOT NULL — 제작년도' COLLATE 'utf8mb3_general_ci
  • make_country — VARCHAR(50) — NOT NULL — 제작국가' COLLATE 'utf8mb3_general_ci
  • show_time — TIME — NOT NULL — 상영시간
  • opening_date — DATE — NOT NULL — 개봉일자
  • product_company — VARCHAR(50) — NOT NULL — 제작사' COLLATE 'utf8mb3_general_ci
  • distributor — VARCHAR(50) — NOT NULL — 배급사' COLLATE 'utf8mb3_general_ci

movie_actor

  • movie_code — BIGINT(20) — Foreign key → movie.movie_code — NOT NULL — 영화코드 번호
  • actor_index — BIGINT(20) — Foreign key → actor.actor_index — NOT NULL — 배우번호

movie_director

  • movie_code — BIGINT(20) — Foreign key → movie.movie_code — NOT NULL — 영화코드 번호
  • director_index — BIGINT(20) — Foreign key → director.director_index — NOT NULL — 등록번호