영화관

테이블 (10)

Actor

  • actor_id (id) — Long — 기본 키 — NOT NULL
  • name — string
  • age — int
  • sex — string

Actor_Movie

  • actor_id (id) — Long — 외래 키 → Actor.actor_id — NOT NULL
  • movie_id (id2) — Long — 외래 키 → Movie.movie_id — NOT NULL
  • director_id (id22) — Long — 외래 키 → Movie.director_id — NOT NULL

Director

  • director_id (id) — Long — 기본 키 — NOT NULL
  • name — string
  • age (Field2) — int
  • sex — string

Member (CopyOfMovie)

  • member_id (id) — Long — 기본 키 — NOT NULL
  • name — string
  • sex — string
  • password — string

MemberMovie

  • movie_id (id) — Long — 외래 키 → Movie.movie_id — NOT NULL
  • director_id (id2) — Long — 외래 키 → Movie.director_id — NOT NULL
  • member_id (id3) — Long — 외래 키 → Member.member_id — NOT NULL

Movie

  • movie_id (id) — Long — 기본 키 — NOT NULL
  • director_id (director) — Director — 외래 키 → Director.director_id — NOT NULL
  • title (name) — string
  • date — LocalDateTime
  • genre — string

MovieTheaterRepository

  • movie_id (id) — Long — 외래 키 → Movie.movie_id — NOT NULL
  • director_id (id2) — Long — 외래 키 → Movie.director_id — NOT NULL
  • theater_room (id3) — Long — 외래 키 → TheaterRoom.theater_room — NOT NULL
  • theater_id (id4) — Long — 외래 키 → TheaterRoom.theater_id — NOT NULL
  • date
  • count — int

Review

  • member_id (id) — Long — 외래 키 → Member.member_id — NOT NULL
  • review — string
  • date

Theater

  • theater_id (id) — Long — 기본 키 — NOT NULL
  • name — int

TheaterRoom

  • theater_room (id) — Long — 기본 키 — NOT NULL
  • theater_id (id2) — Long — 외래 키 → Theater.theater_id — NOT NULL