Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,001–1,025 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1001 | 215 | 6163 | 2018-06-30 13:28:55 |
| 1002 | 215 | 6164 | 2018-06-30 13:28:55 |
| 1003 | 216 | 6165 | 2018-06-30 13:28:55 |
| 1004 | 205 | 6168 | 2018-07-02 15:59:23 |
| 1005 | 205 | 6169 | 2018-07-02 15:59:23 |
| 1006 | 211 | 6176 | 2018-07-05 10:15:54 |
| 1007 | 201 | 6186 | 2018-07-07 07:19:24 |
| 1008 | 201 | 6187 | 2018-07-07 07:19:24 |
| 1009 | 201 | 6188 | 2018-07-07 07:19:24 |
| 1010 | 201 | 6189 | 2018-07-07 07:19:24 |
| 1011 | 209 | 6215 | 2018-07-13 13:06:36 |
| 1012 | 212 | 6216 | 2018-07-13 16:53:02 |
| 1013 | 212 | 6217 | 2018-07-13 16:53:02 |
| 1014 | 212 | 6218 | 2018-07-13 16:53:02 |
| 1015 | 206 | 6223 | 2018-07-14 11:37:49 |
| 1016 | 210 | 6266 | 2018-07-19 08:08:12 |
| 1017 | 210 | 6267 | 2018-07-19 08:08:12 |
| 1018 | 214 | 6744 | 2018-09-23 13:20:30 |
| 1019 | 214 | 6745 | 2018-09-23 13:20:30 |
| 1020 | 234 | 6790 | 2018-10-01 14:22:44 |
| 1021 | 234 | 6791 | 2018-10-01 14:22:44 |
| 1022 | 234 | 6792 | 2018-10-01 14:22:44 |
| 1023 | 234 | 6793 | 2018-10-01 14:22:44 |
| 1024 | 234 | 6794 | 2018-10-01 14:22:44 |
| 1025 | 234 | 6795 | 2018-10-01 14:22:44 |
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;