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