Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 326–350 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 326 | 57 | 2132 | 2016-05-02 21:14:06 |
| 327 | 62 | 2140 | 2016-05-05 08:10:29 |
| 328 | 62 | 2141 | 2016-05-05 08:10:29 |
| 329 | 62 | 2142 | 2016-05-05 08:10:29 |
| 330 | 56 | 2143 | 2016-05-06 07:36:18 |
| 331 | 58 | 2253 | 2016-05-13 13:05:03 |
| 332 | 65 | 2254 | 2016-05-13 14:02:15 |
| 333 | 60 | 2274 | 2016-05-17 22:37:20 |
| 334 | 60 | 2275 | 2016-05-17 22:37:20 |
| 335 | 60 | 2276 | 2016-05-17 22:37:20 |
| 336 | 60 | 2277 | 2016-05-17 22:37:20 |
| 337 | 59 | 2280 | 2016-05-18 13:56:40 |
| 338 | 59 | 2281 | 2016-05-18 13:56:40 |
| 339 | 63 | 2283 | 2016-05-22 11:58:37 |
| 340 | 63 | 2284 | 2016-05-22 11:58:37 |
| 341 | 66 | 2285 | 2016-05-23 11:31:01 |
| 342 | 66 | 2286 | 2016-05-23 11:31:01 |
| 343 | 64 | 2287 | 2016-05-24 21:17:15 |
| 344 | 61 | 2288 | 2016-05-25 07:00:47 |
| 345 | 61 | 2289 | 2016-05-25 07:00:47 |
| 346 | 67 | 2375 | 2016-06-14 20:13:35 |
| 347 | 67 | 2376 | 2016-06-14 20:13:35 |
| 348 | 69 | 2390 | 2016-06-18 21:00:22 |
| 349 | 72 | 2396 | 2016-06-21 11:41:33 |
| 350 | 68 | 2411 | 2016-06-25 17:37:38 |
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;