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)