mo
Tables (9)
MEMBER
- member_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- membership_grade — VARCHAR(20)
- reservation_id — INT — Foreign key → RESERVATION.reservation_id
MOVIE
- movie_id — INT — Primary key
- title — VARCHAR(255) — NOT NULL
- director — VARCHAR(100)
- genre — VARCHAR(100)
- rating — VARCHAR(20)
- running_time_min — INT
- showing_id — INT — Foreign key → SHOWING.showing_id
PAYMENT
- reservation_id — INT — Primary key
- payment_method — VARCHAR(50) — NOT NULL
- payment_status — VARCHAR(20) — NOT NULL
- payment_time — DATETIME — NOT NULL
- approval_number — VARCHAR(100)
RESERVATION
- reservation_id — INT — Primary key
- member_id — INT — NOT NULL
- showing_id — INT — NOT NULL
- reservation_time — DATETIME — NOT NULL
- total_amount — DECIMAL(10, 2) — NOT NULL
- reservation_id (reservation_id2) — INT — Foreign key → PAYMENT.reservation_id
- ticket_id — INT — Foreign key → TICKET.ticket_id
SCREEN
- screen_id — INT — Primary key
- theater_id — INT — NOT NULL
- screen_name — VARCHAR(50) — NOT NULL
- total_seats — INT — NOT NULL
- seat_id — INT — Foreign key → SEAT.seat_id
- showing_id — INT — Foreign key → SHOWING.showing_id
SEAT
- seat_id — INT — Primary key
- screen_id — INT — NOT NULL
- seat_row — VARCHAR(10) — NOT NULL
- seat_number — INT — NOT NULL
- seat_type — VARCHAR(20)
- ticket_id — INT — Foreign key → TICKET.ticket_id
SHOWING
- showing_id — INT — Primary key
- movie_id — INT — NOT NULL
- screen_id — INT — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- reservation_id — INT — Foreign key → RESERVATION.reservation_id
THEATER
- theater_id — INT — Primary key
- theater_name — VARCHAR(100) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- screen_id — INT — Foreign key → SCREEN.screen_id
TICKET
- ticket_id — INT — Primary key
- reservation_id — INT — NOT NULL
- seat_id — INT — NOT NULL