test
Tables (5)
Cinema (Untitled3)
- Key — Long — Primary key — NOT NULL
- id (PK) — long — Foreign key → Reservation.id — NOT NULL
- id (pk) — Long — Foreign key → Movie.movie_id — NOT NULL
- id (pk2) — Long — Foreign key → Showtime.id — NOT NULL
- ciema_name (Field) — String
- Max_row (Field2) — Integer
- Max_num (Field3) — Integer
- Max_seat (Field4) — Integer
Movie (Untitled5)
- movie_id (pk) — Long — Primary key — NOT NULL
- movie_name (Field) — String
- Genre (Field2) — Enum
- limited_age (Field3) — Interger
- movie_length (Field4) — Interger
Reservation (Untitled2)
- id (PK) — long — Foreign key → User.id — NOT NULL
Showtime (Untitled4)
- id (pk) — Long — Foreign key → Movie.movie_id — NOT NULL
- start_time (Field) — date
- end_time (Field2) — date
User (Untitled)
- id (PK) — Long — Primary key — NOT NULL
- user_id (pk) — String
- pw (Field) — String
- name (Field3) — String
- age (Field2) — Integer