Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 576–600 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 576 | 138 | 4434 | 2017-08-20 12:49:00 |
| 577 | 138 | 4435 | 2017-08-20 12:49:00 |
| 578 | 138 | 4436 | 2017-08-20 12:49:00 |
| 579 | 138 | 4437 | 2017-08-20 12:49:00 |
| 580 | 138 | 4438 | 2017-08-20 12:49:00 |
| 581 | 138 | 4439 | 2017-08-20 12:49:00 |
| 582 | 138 | 4440 | 2017-08-20 12:49:00 |
| 583 | 138 | 4441 | 2017-08-20 12:49:00 |
| 584 | 138 | 4442 | 2017-08-20 12:49:00 |
| 585 | 138 | 4443 | 2017-08-20 12:49:00 |
| 586 | 138 | 4444 | 2017-08-20 12:49:00 |
| 587 | 138 | 4445 | 2017-08-20 12:49:00 |
| 588 | 138 | 4446 | 2017-08-20 12:49:00 |
| 589 | 138 | 4447 | 2017-08-20 12:49:00 |
| 590 | 138 | 4448 | 2017-08-20 12:49:00 |
| 591 | 138 | 4449 | 2017-08-20 12:49:00 |
| 592 | 138 | 4450 | 2017-08-20 12:49:00 |
| 593 | 138 | 4451 | 2017-08-20 12:49:00 |
| 594 | 138 | 4452 | 2017-08-20 12:49:00 |
| 595 | 138 | 4453 | 2017-08-20 12:49:00 |
| 596 | 138 | 4454 | 2017-08-20 12:49:00 |
| 597 | 138 | 4455 | 2017-08-20 12:49:00 |
| 598 | 138 | 4456 | 2017-08-20 12:49:00 |
| 599 | 138 | 4457 | 2017-08-20 12:49:00 |
| 600 | 138 | 4458 | 2017-08-20 12:49:00 |
Table definition
CREATE TABLE exhibition_booking (
booking_id INTEGER PRIMARY KEY,
slot_id INTEGER NOT NULL REFERENCES exhibition_slot (slot_id),
ticket_id INTEGER NOT NULL REFERENCES ticket (ticket_id),
booked_at TEXT NOT NULL,
UNIQUE (slot_id, ticket_id)
) STRICT;