Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,901–1,925 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1901 | 385 | 9599 | 2019-12-25 10:28:28 |
| 1902 | 385 | 9600 | 2019-12-25 10:28:28 |
| 1903 | 396 | 9601 | 2019-12-25 11:57:37 |
| 1904 | 396 | 9602 | 2019-12-25 11:57:37 |
| 1905 | 396 | 9603 | 2019-12-25 11:57:37 |
| 1906 | 396 | 9604 | 2019-12-25 11:57:37 |
| 1907 | 393 | 9609 | 2019-12-27 16:11:02 |
| 1908 | 393 | 9610 | 2019-12-27 16:11:02 |
| 1909 | 393 | 9611 | 2019-12-27 16:11:02 |
| 1910 | 393 | 9612 | 2019-12-27 16:11:02 |
| 1911 | 393 | 9613 | 2019-12-27 16:11:02 |
| 1912 | 400 | 9614 | 2019-12-28 08:38:06 |
| 1913 | 400 | 9615 | 2019-12-28 08:38:06 |
| 1914 | 400 | 9616 | 2019-12-28 08:38:06 |
| 1915 | 395 | 9618 | 2019-12-28 12:28:47 |
| 1916 | 395 | 9619 | 2019-12-28 12:28:47 |
| 1917 | 394 | 9630 | 2020-01-02 13:44:30 |
| 1918 | 394 | 9631 | 2020-01-02 13:44:30 |
| 1919 | 399 | 9632 | 2020-01-02 16:32:52 |
| 1920 | 399 | 9633 | 2020-01-02 16:32:52 |
| 1921 | 401 | 9634 | 2020-01-03 09:21:00 |
| 1922 | 401 | 9635 | 2020-01-03 09:21:00 |
| 1923 | 401 | 9636 | 2020-01-03 09:21:00 |
| 1924 | 401 | 9637 | 2020-01-03 09:21:00 |
| 1925 | 398 | 9638 | 2020-01-03 21:03:13 |
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;