Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 376–400 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 376 | 82 | 3016 | 2016-11-11 15:18:48 |
| 377 | 81 | 3161 | 2016-12-09 17:18:49 |
| 378 | 81 | 3162 | 2016-12-09 17:18:49 |
| 379 | 81 | 3163 | 2016-12-09 17:18:49 |
| 380 | 96 | 3253 | 2016-12-24 10:38:09 |
| 381 | 96 | 3254 | 2016-12-24 10:38:09 |
| 382 | 96 | 3255 | 2016-12-24 10:38:09 |
| 383 | 96 | 3256 | 2016-12-24 10:38:09 |
| 384 | 96 | 3257 | 2016-12-24 10:38:09 |
| 385 | 96 | 3258 | 2016-12-24 10:38:09 |
| 386 | 96 | 3259 | 2016-12-24 10:38:09 |
| 387 | 96 | 3260 | 2016-12-24 10:38:09 |
| 388 | 96 | 3261 | 2016-12-24 10:38:09 |
| 389 | 96 | 3262 | 2016-12-24 10:38:09 |
| 390 | 96 | 3263 | 2016-12-24 10:38:09 |
| 391 | 96 | 3264 | 2016-12-24 10:38:09 |
| 392 | 96 | 3265 | 2016-12-24 10:38:09 |
| 393 | 96 | 3266 | 2016-12-24 10:38:09 |
| 394 | 96 | 3267 | 2016-12-24 10:38:09 |
| 395 | 96 | 3268 | 2016-12-24 10:38:09 |
| 396 | 96 | 3269 | 2016-12-24 10:38:09 |
| 397 | 96 | 3270 | 2016-12-24 10:38:09 |
| 398 | 96 | 3271 | 2016-12-24 10:38:09 |
| 399 | 96 | 3272 | 2016-12-24 10:38:09 |
| 400 | 96 | 3273 | 2016-12-24 10:38:09 |
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;