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 — 등록번호