예제2
테이블 (16)
AD_Movie (Untitled9)
- adm_id (Pk) — long — 기본 키 — NOT NULL
- ad_id (FK) — long — 외래 키 → Assist Director.ad_id — NOT NULL
- movie_id (PK) — long — 외래 키 → Movie.movie_id — NOT NULL
- director_id (Pk2) — long — 외래 키 → Movie.director_id — NOT NULL
- distributor_id (PK2) — long — 외래 키 → Movie.distributor_id — NOT NULL
Actor (Untitled4)
- actor_id (PK) — long — 기본 키 — NOT NULL
- actor_name (Field) — varchar
Assist Director (Untitled8)
- ad_id (PK) — long — 기본 키 — NOT NULL
- ad_name (Field) — varchar
Category (Untitled5)
- category_id (PK) — long — 기본 키 — NOT NULL
- category_name (Field) — varchar
Director (Untitled3)
- director_id (Pk) — long — 기본 키 — NOT NULL
- director_name (Field) — varchar
Distributor (Untitled16)
- distributor_id (PK) — long — 기본 키 — NOT NULL
- distributor_name (Field) — varchar
Movie (Untitled2)
- movie_id (PK) — long — 기본 키 — NOT NULL
- director_id (FK) — long — 외래 키 → Director.director_id — NOT NULL
- distributor_id (FK2) — long — 외래 키 → Distributor.distributor_id — NOT NULL
- movie_name (Field) — varchar
- movie_year (Field2) — varchar
- movie_release (Field3) — date
- movie_close (Field4) — date
- movie_runtime (Field5) — date
- created_at (Field6)
Movie_Actor (Untitled7)
- ma_id (PK) — long — 기본 키 — NOT NULL
- movie_id (FK) — long — 외래 키 → Movie.movie_id — NOT NULL
- actor_id (FK2) — long — 외래 키 → Actor.actor_id — NOT NULL
- director_id (Pk) — long — 외래 키 → Movie.director_id — NOT NULL
- distributor_id (PK2) — long — 외래 키 → Movie.distributor_id — NOT NULL
Movie_Category (Untitled6)
- mc_id (Pk) — long — 기본 키 — NOT NULL
- movie_id (FK) — long — 외래 키 → Movie.movie_id — NOT NULL
- category_id (FK2) — long — 외래 키 → Category.category_id — NOT NULL
- director_id (Pk2) — long — 외래 키 → Movie.director_id — NOT NULL
- distributor_id (PK2) — long — 외래 키 → Movie.distributor_id — NOT NULL
Production Company (Untitled13)
- pc_id (PK) — long — 기본 키 — NOT NULL
- pc_name (Field)
Production Company_Movie (Untitled15)
- pcm_id (PK) — long — 기본 키 — NOT NULL
- pc_id (PK2) — long — 외래 키 → Production Company.pc_id — NOT NULL
- movie_id (PK3) — long — 외래 키 → Movie.movie_id — NOT NULL
- distributor_id (PK22) — long — 외래 키 → Movie.distributor_id — NOT NULL
Reservation (Untitled14)
- reservation_id (PK) — long — 기본 키 — NOT NULL
- member_id (Fk) — long — 외래 키 → User.member_id — NOT NULL
- created_at (Field)
Seat (Untitled11)
- seat_id (Pk) — long — 기본 키 — NOT NULL
- seat_row (Field) — varchar
- seat_column (Field2) — varchar
Theater (Untitled12)
- theater_id (Key) — long — 기본 키 — NOT NULL
- theater_name (Field) — varchar
- theater_max (Field2) — long
- theater_price (Field3) — long
Ticket (Untitled10)
- ticket_id (PK) — long — 기본 키 — NOT NULL
- movie_id (FK1) — long — 외래 키 → Movie.movie_id — NOT NULL
- reservation_id (FK2) — long — 외래 키 → Reservation.reservation_id — NOT NULL
- member_id (FK3) — long — 외래 키 → Reservation.member_id — NOT NULL
- theater_id (FK4) — long — 외래 키 → Theater.theater_id — NOT NULL
- seat_id (FK5) — long — 외래 키 → Seat.seat_id — NOT NULL
- distributor_id (FK6) — long — 외래 키 → Movie.distributor_id — NOT NULL
User (Untitled)
- member_id (PK) — long — 기본 키 — NOT NULL
- member_email (Field) — varchar
- member_pwd (Field2) — varchar
- member_address (Field3) — varchar
- member_tel (Field4) — varchar
- created_at (Field5) — date