- movie_id *
- title
- rating
- runtime
- showtime_id *
- movie_id
- theatre_id
- start_at
- name
- capacity
- seat_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_id *
- amount
- method
- email
- phone
- user_id
- role
- password_hash
by sha