Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 101–125 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 101 | 11 | 152 | 2015-03-20 16:14:05 |
| 102 | 11 | 153 | 2015-03-20 16:14:05 |
| 103 | 11 | 154 | 2015-03-20 16:14:05 |
| 104 | 12 | 155 | 2015-03-20 16:14:05 |
| 105 | 12 | 156 | 2015-03-20 16:14:05 |
| 106 | 2 | 165 | 2015-03-22 10:46:13 |
| 107 | 4 | 170 | 2015-03-24 10:39:23 |
| 108 | 4 | 171 | 2015-03-24 10:39:23 |
| 109 | 5 | 231 | 2015-04-02 15:25:42 |
| 110 | 5 | 232 | 2015-04-02 15:25:42 |
| 111 | 9 | 444 | 2015-05-06 18:08:18 |
| 112 | 9 | 445 | 2015-05-06 18:08:18 |
| 113 | 9 | 446 | 2015-05-06 18:08:18 |
| 114 | 10 | 447 | 2015-05-06 19:05:24 |
| 115 | 10 | 448 | 2015-05-06 19:05:24 |
| 116 | 10 | 449 | 2015-05-06 19:05:24 |
| 117 | 10 | 450 | 2015-05-06 19:05:24 |
| 118 | 10 | 451 | 2015-05-06 19:05:24 |
| 119 | 11 | 502 | 2015-05-09 12:17:33 |
| 120 | 11 | 503 | 2015-05-09 12:17:33 |
| 121 | 8 | 523 | 2015-05-15 08:35:08 |
| 122 | 13 | 620 | 2015-05-31 16:39:05 |
| 123 | 13 | 621 | 2015-05-31 16:39:05 |
| 124 | 14 | 654 | 2015-06-09 16:28:38 |
| 125 | 15 | 667 | 2015-06-12 23:26:08 |
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;