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