Movie

Tables (11)

Member (Untitled5)

  • member_id (Key) — Primary key — NOT NULL
  • nonMember_id (Key2) — Foreign key → NonMember.nonMember_id — NOT NULL
  • address (Field4)
  • points (Field5)

Movie (Untitled2)

  • movie_id (Key) — Primary key — NOT NULL
  • title (Field)
  • duration (Field2)

NonMember (Untitled10)

  • nonMember_id (Key) — Primary key — NOT NULL
  • name (Field)
  • contact (Field2)
  • email (Field3)

Payment (Untitled8)

  • payment_id (Key) — Primary key — NOT NULL
  • reservation_id (Key2) — Foreign key → Reservation.reservation_id — NOT NULL
  • payment_method (Field)
  • payment_amount (Field2)
  • payment_date (Field3)

Refund (Untitled7)

  • refund_id (Key) — Primary key — NOT NULL
  • reservation_id (Key2) — Foreign key → Reservation.reservation_id — NOT NULL
  • refund_amount (Field)
  • refund_date (Field2)
  • refund_status (Field3)

Reservation (Untitled9)

  • reservation_id (Key) — Primary key — NOT NULL
  • reservation_date (Field)
  • reservation_type (Field2)
  • refund_status (Field3)
  • refund_amount (Field4)
  • nonMember_id (Key2) — Foreign key → NonMember.nonMember_id — NOT NULL
  • ticket_id (Key3) — Foreign key → Ticket.ticket_id — NOT NULL

Screen (Untitled)

  • screen_id (Key) — Primary key — NOT NULL
  • theater_id (Key2) — Foreign key → Theater.theater_id — NOT NULL
  • name (Field)
  • seat_count (Field2)

Seat (Untitled11)

  • seat_id (Key) — Primary key — NOT NULL
  • screen_id (Key2) — Foreign key → Screen.screen_id — NOT NULL
  • seat_number (Field2)
  • seat_type (Field)

Showtime (Untitled6)

  • showtime_id (Key) — Primary key — NOT NULL
  • date (Field)
  • start_time (Field2)
  • screen_id (Key3) — Foreign key → Screen.screen_id — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.movie_id — NOT NULL

Theater (Untitled3)

  • theater_id (Key) — Primary key — NOT NULL
  • name (Field)
  • location (Field2)

Ticket (Untitled4)

  • ticket_id (Key) — Primary key — NOT NULL
  • status (Field)
  • payment_method (Field2)
  • amount (Field3)
  • showtime_id (Key2) — Foreign key → Showtime.showtime_id — NOT NULL
  • seat_id (Key3) — Foreign key → Seat.seat_id — NOT NULL