Data Consistency Test Schema
Tables (3)
Reservation (reservation)
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(200)
- ticket_id — BIGINT — Foreign key → Ticket.id — NOT NULL
Ticket (ticket)
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(200)
Ticket Stock (ticket_stock)
- id — BIGINT — Primary key — NOT NULL
- quantity — INT
- ticket_id — BIGINT — Foreign key → Ticket.id — NOT NULL