Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,301–1,325 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1301 | 271 | 7540 | 2019-01-31 12:13:23 |
| 1302 | 271 | 7541 | 2019-01-31 12:13:23 |
| 1303 | 271 | 7542 | 2019-01-31 12:13:23 |
| 1304 | 271 | 7543 | 2019-01-31 12:13:23 |
| 1305 | 271 | 7544 | 2019-01-31 12:13:23 |
| 1306 | 271 | 7545 | 2019-01-31 12:13:23 |
| 1307 | 271 | 7546 | 2019-01-31 12:13:23 |
| 1308 | 271 | 7547 | 2019-01-31 12:13:23 |
| 1309 | 271 | 7548 | 2019-01-31 12:13:23 |
| 1310 | 271 | 7549 | 2019-01-31 12:13:23 |
| 1311 | 271 | 7550 | 2019-01-31 12:13:23 |
| 1312 | 271 | 7551 | 2019-01-31 12:13:23 |
| 1313 | 271 | 7552 | 2019-01-31 12:13:23 |
| 1314 | 271 | 7553 | 2019-01-31 12:13:23 |
| 1315 | 271 | 7554 | 2019-01-31 12:13:23 |
| 1316 | 271 | 7555 | 2019-01-31 12:13:23 |
| 1317 | 271 | 7556 | 2019-01-31 12:13:23 |
| 1318 | 271 | 7557 | 2019-01-31 12:13:23 |
| 1319 | 271 | 7558 | 2019-01-31 12:13:23 |
| 1320 | 271 | 7559 | 2019-01-31 12:13:23 |
| 1321 | 271 | 7560 | 2019-01-31 12:13:23 |
| 1322 | 271 | 7561 | 2019-01-31 12:13:23 |
| 1323 | 271 | 7562 | 2019-01-31 12:13:23 |
| 1324 | 271 | 7563 | 2019-01-31 12:13:23 |
| 1325 | 271 | 7564 | 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;