Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 301–325 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 301 | 44 | 1987 | 2016-03-24 13:28:01 |
| 302 | 44 | 1988 | 2016-03-24 13:28:01 |
| 303 | 46 | 1991 | 2016-03-25 20:16:44 |
| 304 | 46 | 1992 | 2016-03-25 20:16:44 |
| 305 | 46 | 1993 | 2016-03-25 20:16:44 |
| 306 | 46 | 1994 | 2016-03-25 20:16:44 |
| 307 | 46 | 1995 | 2016-03-25 20:16:44 |
| 308 | 47 | 2018 | 2016-04-01 11:14:57 |
| 309 | 47 | 2019 | 2016-04-01 11:14:57 |
| 310 | 47 | 2020 | 2016-04-01 11:14:57 |
| 311 | 49 | 2057 | 2016-04-13 20:37:35 |
| 312 | 49 | 2058 | 2016-04-13 20:37:35 |
| 313 | 52 | 2066 | 2016-04-16 17:50:28 |
| 314 | 52 | 2067 | 2016-04-16 17:50:28 |
| 315 | 50 | 2070 | 2016-04-18 18:32:11 |
| 316 | 51 | 2079 | 2016-04-19 19:48:27 |
| 317 | 51 | 2080 | 2016-04-19 19:48:27 |
| 318 | 51 | 2081 | 2016-04-19 19:48:27 |
| 319 | 51 | 2082 | 2016-04-19 19:48:27 |
| 320 | 54 | 2086 | 2016-04-24 13:35:34 |
| 321 | 53 | 2090 | 2016-04-27 14:19:30 |
| 322 | 53 | 2091 | 2016-04-27 14:19:30 |
| 323 | 53 | 2092 | 2016-04-27 14:19:30 |
| 324 | 55 | 2119 | 2016-05-01 12:14:33 |
| 325 | 57 | 2131 | 2016-05-02 21:14:06 |
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;