Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,526–1,550 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1526 | 294 | 8643 | 2019-07-26 19:35:23 |
| 1527 | 294 | 8644 | 2019-07-26 19:35:23 |
| 1528 | 297 | 8655 | 2019-07-29 07:56:51 |
| 1529 | 296 | 8710 | 2019-08-05 11:57:20 |
| 1530 | 299 | 8711 | 2019-08-05 17:11:22 |
| 1531 | 298 | 8719 | 2019-08-07 08:38:00 |
| 1532 | 298 | 8720 | 2019-08-07 08:38:00 |
| 1533 | 298 | 8721 | 2019-08-07 08:38:00 |
| 1534 | 295 | 8733 | 2019-08-08 20:15:19 |
| 1535 | 295 | 8734 | 2019-08-08 20:15:19 |
| 1536 | 295 | 8735 | 2019-08-08 20:15:19 |
| 1537 | 301 | 8845 | 2019-08-29 07:16:30 |
| 1538 | 300 | 8859 | 2019-08-30 17:28:03 |
| 1539 | 300 | 8860 | 2019-08-30 17:28:03 |
| 1540 | 300 | 8861 | 2019-08-30 17:28:03 |
| 1541 | 300 | 8862 | 2019-08-30 17:28:03 |
| 1542 | 300 | 8863 | 2019-08-30 17:28:03 |
| 1543 | 320 | 8901 | 2019-09-07 10:32:28 |
| 1544 | 320 | 8902 | 2019-09-07 10:32:28 |
| 1545 | 320 | 8903 | 2019-09-07 10:32:28 |
| 1546 | 320 | 8904 | 2019-09-07 10:32:28 |
| 1547 | 320 | 8905 | 2019-09-07 10:32:28 |
| 1548 | 320 | 8906 | 2019-09-07 10:32:28 |
| 1549 | 320 | 8907 | 2019-09-07 10:32:28 |
| 1550 | 320 | 8908 | 2019-09-07 10:32:28 |
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;