Domain Model / ERD (High Level)

Movie- movie_id *- title- rating- runtime

Showtime- showtime_id *- movie_id- theatre_id- start_at

Theatre- theatre_id- name- capacity

Seat- seat_id- theatre_id- label- type

Order- order_id *- customer_id- total- status- created_at

OrderItem- item_id- order_id- ticket_type- price- seat_id?- showtime_id

Payment- payment_id *- order_id- amount- method- status

Customer- customer_id- name- email- phone

User (Admin)- user_id- role- email- password_hash