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