Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,026–1,050 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1026 | 234 | 6796 | 2018-10-01 14:22:44 |
| 1027 | 234 | 6797 | 2018-10-01 14:22:44 |
| 1028 | 234 | 6798 | 2018-10-01 14:22:44 |
| 1029 | 234 | 6799 | 2018-10-01 14:22:44 |
| 1030 | 234 | 6800 | 2018-10-01 14:22:44 |
| 1031 | 234 | 6801 | 2018-10-01 14:22:44 |
| 1032 | 234 | 6802 | 2018-10-01 14:22:44 |
| 1033 | 234 | 6803 | 2018-10-01 14:22:44 |
| 1034 | 234 | 6804 | 2018-10-01 14:22:44 |
| 1035 | 234 | 6805 | 2018-10-01 14:22:44 |
| 1036 | 234 | 6806 | 2018-10-01 14:22:44 |
| 1037 | 234 | 6807 | 2018-10-01 14:22:44 |
| 1038 | 234 | 6808 | 2018-10-01 14:22:44 |
| 1039 | 234 | 6809 | 2018-10-01 14:22:44 |
| 1040 | 234 | 6810 | 2018-10-01 14:22:44 |
| 1041 | 234 | 6811 | 2018-10-01 14:22:44 |
| 1042 | 234 | 6812 | 2018-10-01 14:22:44 |
| 1043 | 234 | 6813 | 2018-10-01 14:22:44 |
| 1044 | 234 | 6814 | 2018-10-01 14:22:44 |
| 1045 | 234 | 6815 | 2018-10-01 14:22:44 |
| 1046 | 234 | 6816 | 2018-10-01 14:22:44 |
| 1047 | 234 | 6817 | 2018-10-01 14:22:44 |
| 1048 | 234 | 6818 | 2018-10-01 14:22:44 |
| 1049 | 234 | 6819 | 2018-10-01 14:22:44 |
| 1050 | 234 | 6820 | 2018-10-01 14:22:44 |
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;