Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,276–1,300 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1276 | 249 | 7510 | 2019-01-29 13:45:00 |
| 1277 | 249 | 7511 | 2019-01-29 13:45:00 |
| 1278 | 249 | 7512 | 2019-01-29 13:45:00 |
| 1279 | 249 | 7513 | 2019-01-29 13:45:00 |
| 1280 | 249 | 7514 | 2019-01-29 13:45:00 |
| 1281 | 249 | 7515 | 2019-01-29 13:45:00 |
| 1282 | 249 | 7516 | 2019-01-29 13:45:00 |
| 1283 | 249 | 7517 | 2019-01-29 13:45:00 |
| 1284 | 249 | 7518 | 2019-01-29 13:45:00 |
| 1285 | 249 | 7519 | 2019-01-29 13:45:00 |
| 1286 | 249 | 7520 | 2019-01-29 13:45:00 |
| 1287 | 249 | 7521 | 2019-01-29 13:45:00 |
| 1288 | 250 | 7522 | 2019-01-29 13:45:00 |
| 1289 | 250 | 7523 | 2019-01-29 13:45:00 |
| 1290 | 250 | 7524 | 2019-01-29 13:45:00 |
| 1291 | 250 | 7525 | 2019-01-29 13:45:00 |
| 1292 | 271 | 7531 | 2019-01-31 12:13:23 |
| 1293 | 271 | 7532 | 2019-01-31 12:13:23 |
| 1294 | 271 | 7533 | 2019-01-31 12:13:23 |
| 1295 | 271 | 7534 | 2019-01-31 12:13:23 |
| 1296 | 271 | 7535 | 2019-01-31 12:13:23 |
| 1297 | 271 | 7536 | 2019-01-31 12:13:23 |
| 1298 | 271 | 7537 | 2019-01-31 12:13:23 |
| 1299 | 271 | 7538 | 2019-01-31 12:13:23 |
| 1300 | 271 | 7539 | 2019-01-31 12:13:23 |
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;