distribute
Tables (5)
events
- event_id — INT
- name — VARCHAR(255)
- start_at — TIMESTAMP
- capacity — INT
payments
- payment_id — INT
- reservation_id — INT — Foreign key → reservations.reservation_id
- amount — INT
- status — VARCHAR(50)
reservations
- reservation_id — INT
- user_id — INT — Foreign key → users.user_id
- event_id — INT — Foreign key → events.event_id
- seat_id — INT — Foreign key → seats.seat_id
- status — VARCHAR(50)
seats
- seat_id — INT
- event_id — INT — Foreign key → events.event_id
- section_row_num — VARCHAR(255)
- status — VARCHAR(50)
- held_until — TIMESTAMP
users
- user_id — INT
- email — VARCHAR(255)
- phone — VARCHAR(255)