Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,251–1,275 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1251 | 249 | 7485 | 2019-01-29 13:45:00 |
| 1252 | 249 | 7486 | 2019-01-29 13:45:00 |
| 1253 | 249 | 7487 | 2019-01-29 13:45:00 |
| 1254 | 249 | 7488 | 2019-01-29 13:45:00 |
| 1255 | 249 | 7489 | 2019-01-29 13:45:00 |
| 1256 | 249 | 7490 | 2019-01-29 13:45:00 |
| 1257 | 249 | 7491 | 2019-01-29 13:45:00 |
| 1258 | 249 | 7492 | 2019-01-29 13:45:00 |
| 1259 | 249 | 7493 | 2019-01-29 13:45:00 |
| 1260 | 249 | 7494 | 2019-01-29 13:45:00 |
| 1261 | 249 | 7495 | 2019-01-29 13:45:00 |
| 1262 | 249 | 7496 | 2019-01-29 13:45:00 |
| 1263 | 249 | 7497 | 2019-01-29 13:45:00 |
| 1264 | 249 | 7498 | 2019-01-29 13:45:00 |
| 1265 | 249 | 7499 | 2019-01-29 13:45:00 |
| 1266 | 249 | 7500 | 2019-01-29 13:45:00 |
| 1267 | 249 | 7501 | 2019-01-29 13:45:00 |
| 1268 | 249 | 7502 | 2019-01-29 13:45:00 |
| 1269 | 249 | 7503 | 2019-01-29 13:45:00 |
| 1270 | 249 | 7504 | 2019-01-29 13:45:00 |
| 1271 | 249 | 7505 | 2019-01-29 13:45:00 |
| 1272 | 249 | 7506 | 2019-01-29 13:45:00 |
| 1273 | 249 | 7507 | 2019-01-29 13:45:00 |
| 1274 | 249 | 7508 | 2019-01-29 13:45:00 |
| 1275 | 249 | 7509 | 2019-01-29 13:45:00 |
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;