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)