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