Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 626–650 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 626 | 132 | 4613 | 2017-09-15 17:48:24 |
| 627 | 132 | 4614 | 2017-09-15 17:48:24 |
| 628 | 132 | 4615 | 2017-09-15 17:48:24 |
| 629 | 132 | 4616 | 2017-09-15 17:48:24 |
| 630 | 132 | 4617 | 2017-09-15 17:48:24 |
| 631 | 132 | 4618 | 2017-09-15 17:48:24 |
| 632 | 132 | 4619 | 2017-09-15 17:48:24 |
| 633 | 132 | 4620 | 2017-09-15 17:48:24 |
| 634 | 132 | 4621 | 2017-09-15 17:48:24 |
| 635 | 132 | 4622 | 2017-09-15 17:48:24 |
| 636 | 132 | 4623 | 2017-09-15 17:48:24 |
| 637 | 132 | 4624 | 2017-09-15 17:48:24 |
| 638 | 132 | 4625 | 2017-09-15 17:48:24 |
| 639 | 132 | 4626 | 2017-09-15 17:48:24 |
| 640 | 132 | 4627 | 2017-09-15 17:48:24 |
| 641 | 132 | 4628 | 2017-09-15 17:48:24 |
| 642 | 132 | 4629 | 2017-09-15 17:48:24 |
| 643 | 132 | 4630 | 2017-09-15 17:48:24 |
| 644 | 132 | 4631 | 2017-09-15 17:48:24 |
| 645 | 132 | 4632 | 2017-09-15 17:48:24 |
| 646 | 132 | 4633 | 2017-09-15 17:48:24 |
| 647 | 132 | 4634 | 2017-09-15 17:48:24 |
| 648 | 132 | 4635 | 2017-09-15 17:48:24 |
| 649 | 141 | 4684 | 2017-10-01 13:20:13 |
| 650 | 141 | 4685 | 2017-10-01 13:20:13 |
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;