ticket-reservation-db
Tables (3)
performances (Untitled)
- id (PK) — bigint generated by default — Primary key — NOT NULL
- title (Field) — text
- venue (Field2) — text
- starts_at (Field3) — timestamptz
- price (Field4) — integer
reservations
- id (PK) — bigint generated by default — Primary key — NOT NULL
- seat_id (FK)
- customer_name (Field2) — text
- customer_email (Field3) — text
- reserved_at (Field4) — timestamptz
seats (Untitled2)
- id (PK) — bigint generated by default — Primary key — NOT NULL
- performance_id (FK) — bigint generated by default — Foreign key → performances.id — NOT NULL
- row_label (Field2) — text
- seat_number (Field3) — integer
- is_available (Field4) — boolean