Movie-revervation

Tables (3)

Movies

  • movie_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • director (Field2) — String
  • genre (Field3) — String
  • start_date (Field4) — LocalDateTime
  • end_date (Field5) — LocalDateTime
  • rating (Field6) — String

Reservations (Reverations)

  • reservation_id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → Users.user_id — NOT NULL
  • movie_id (Key3) — Long — Foreign key → Movies.movie_id — NOT NULL
  • reservation_date (Field) — LocalDateTime
  • head_count (Field2) — int

Users

  • user_id (Key) — Long — Primary key — NOT NULL
  • nickname (Field) — String
  • password (Field2) — String
  • role (Field3) — String
  • birth_date (Field4) — LocalDate