Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 601–625 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 601 | 138 | 4459 | 2017-08-20 12:49:00 |
| 602 | 138 | 4460 | 2017-08-20 12:49:00 |
| 603 | 138 | 4461 | 2017-08-20 12:49:00 |
| 604 | 138 | 4462 | 2017-08-20 12:49:00 |
| 605 | 138 | 4463 | 2017-08-20 12:49:00 |
| 606 | 138 | 4464 | 2017-08-20 12:49:00 |
| 607 | 132 | 4594 | 2017-09-15 17:48:24 |
| 608 | 132 | 4595 | 2017-09-15 17:48:24 |
| 609 | 132 | 4596 | 2017-09-15 17:48:24 |
| 610 | 132 | 4597 | 2017-09-15 17:48:24 |
| 611 | 132 | 4598 | 2017-09-15 17:48:24 |
| 612 | 132 | 4599 | 2017-09-15 17:48:24 |
| 613 | 132 | 4600 | 2017-09-15 17:48:24 |
| 614 | 132 | 4601 | 2017-09-15 17:48:24 |
| 615 | 132 | 4602 | 2017-09-15 17:48:24 |
| 616 | 132 | 4603 | 2017-09-15 17:48:24 |
| 617 | 132 | 4604 | 2017-09-15 17:48:24 |
| 618 | 132 | 4605 | 2017-09-15 17:48:24 |
| 619 | 132 | 4606 | 2017-09-15 17:48:24 |
| 620 | 132 | 4607 | 2017-09-15 17:48:24 |
| 621 | 132 | 4608 | 2017-09-15 17:48:24 |
| 622 | 132 | 4609 | 2017-09-15 17:48:24 |
| 623 | 132 | 4610 | 2017-09-15 17:48:24 |
| 624 | 132 | 4611 | 2017-09-15 17:48:24 |
| 625 | 132 | 4612 | 2017-09-15 17:48:24 |
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;