Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 676–700 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 676 | 141 | 4711 | 2017-10-01 13:20:13 |
| 677 | 141 | 4712 | 2017-10-01 13:20:13 |
| 678 | 141 | 4713 | 2017-10-01 13:20:13 |
| 679 | 141 | 4714 | 2017-10-01 13:20:13 |
| 680 | 141 | 4715 | 2017-10-01 13:20:13 |
| 681 | 141 | 4716 | 2017-10-01 13:20:13 |
| 682 | 141 | 4717 | 2017-10-01 13:20:13 |
| 683 | 141 | 4718 | 2017-10-01 13:20:13 |
| 684 | 141 | 4719 | 2017-10-01 13:20:13 |
| 685 | 141 | 4720 | 2017-10-01 13:20:13 |
| 686 | 141 | 4721 | 2017-10-01 13:20:13 |
| 687 | 141 | 4722 | 2017-10-01 13:20:13 |
| 688 | 141 | 4723 | 2017-10-01 13:20:13 |
| 689 | 141 | 4724 | 2017-10-01 13:20:13 |
| 690 | 141 | 4725 | 2017-10-01 13:20:13 |
| 691 | 141 | 4726 | 2017-10-01 13:20:13 |
| 692 | 141 | 4727 | 2017-10-01 13:20:13 |
| 693 | 141 | 4728 | 2017-10-01 13:20:13 |
| 694 | 142 | 4729 | 2017-10-01 13:20:13 |
| 695 | 142 | 4730 | 2017-10-01 13:20:13 |
| 696 | 142 | 4731 | 2017-10-01 13:20:13 |
| 697 | 142 | 4732 | 2017-10-01 13:20:13 |
| 698 | 142 | 4733 | 2017-10-01 13:20:13 |
| 699 | 142 | 4734 | 2017-10-01 13:20:13 |
| 700 | 142 | 4735 | 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;