Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 651–675 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 651 | 141 | 4686 | 2017-10-01 13:20:13 |
| 652 | 141 | 4687 | 2017-10-01 13:20:13 |
| 653 | 141 | 4688 | 2017-10-01 13:20:13 |
| 654 | 141 | 4689 | 2017-10-01 13:20:13 |
| 655 | 141 | 4690 | 2017-10-01 13:20:13 |
| 656 | 141 | 4691 | 2017-10-01 13:20:13 |
| 657 | 141 | 4692 | 2017-10-01 13:20:13 |
| 658 | 141 | 4693 | 2017-10-01 13:20:13 |
| 659 | 141 | 4694 | 2017-10-01 13:20:13 |
| 660 | 141 | 4695 | 2017-10-01 13:20:13 |
| 661 | 141 | 4696 | 2017-10-01 13:20:13 |
| 662 | 141 | 4697 | 2017-10-01 13:20:13 |
| 663 | 141 | 4698 | 2017-10-01 13:20:13 |
| 664 | 141 | 4699 | 2017-10-01 13:20:13 |
| 665 | 141 | 4700 | 2017-10-01 13:20:13 |
| 666 | 141 | 4701 | 2017-10-01 13:20:13 |
| 667 | 141 | 4702 | 2017-10-01 13:20:13 |
| 668 | 141 | 4703 | 2017-10-01 13:20:13 |
| 669 | 141 | 4704 | 2017-10-01 13:20:13 |
| 670 | 141 | 4705 | 2017-10-01 13:20:13 |
| 671 | 141 | 4706 | 2017-10-01 13:20:13 |
| 672 | 141 | 4707 | 2017-10-01 13:20:13 |
| 673 | 141 | 4708 | 2017-10-01 13:20:13 |
| 674 | 141 | 4709 | 2017-10-01 13:20:13 |
| 675 | 141 | 4710 | 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;