예제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