ss

Tables (6)

hold_seat

  • hold_id — BIGINT — Primary key — NOT NULL
  • seat_id — BIGINT — Primary key — NOT NULL

holds

  • id — BIGINT — Primary key — NOT NULL
  • user_id — VARCHAR(64) — NOT NULL
  • performance_id — BIGINT — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • expires_at — DATETIME(3) — NOT NULL
  • idempotency_key — VARCHAR(64)
  • created_at — DATETIME(3) — NOT NULL

payment

  • id — VARCHAR(64) — Primary key — NOT NULL
  • hold_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

payment_event

  • event_id — VARCHAR(64) — Primary key — NOT NULL
  • payment_id — VARCHAR(64) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • occurred_at — DATETIME(3) — NOT NULL
  • received_at — DATETIME(3) — NOT NULL
  • result — VARCHAR(30) — NOT NULL

performance

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • starts_at — DATETIME — NOT NULL

seat

  • id — BIGINT — Primary key — NOT NULL
  • performance_id — BIGINT — NOT NULL
  • seat_no — VARCHAR(20) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • hold_id — BIGINT
  • hold_expires_at — DATETIME(3)