Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 26–50 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 26 | 6 | 33 | 2015-02-19 16:08:44 |
| 27 | 6 | 34 | 2015-02-19 16:08:44 |
| 28 | 6 | 35 | 2015-02-19 16:08:44 |
| 29 | 6 | 36 | 2015-02-19 16:08:44 |
| 30 | 6 | 37 | 2015-02-19 16:08:44 |
| 31 | 6 | 38 | 2015-02-19 16:08:44 |
| 32 | 6 | 39 | 2015-02-19 16:08:44 |
| 33 | 6 | 40 | 2015-02-19 16:08:44 |
| 34 | 6 | 41 | 2015-02-19 16:08:44 |
| 35 | 6 | 42 | 2015-02-19 16:08:44 |
| 36 | 6 | 43 | 2015-02-19 16:08:44 |
| 37 | 6 | 44 | 2015-02-19 16:08:44 |
| 38 | 6 | 45 | 2015-02-19 16:08:44 |
| 39 | 6 | 46 | 2015-02-19 16:08:44 |
| 40 | 6 | 47 | 2015-02-19 16:08:44 |
| 41 | 6 | 48 | 2015-02-19 16:08:44 |
| 42 | 6 | 49 | 2015-02-19 16:08:44 |
| 43 | 6 | 50 | 2015-02-19 16:08:44 |
| 44 | 6 | 51 | 2015-02-19 16:08:44 |
| 45 | 6 | 52 | 2015-02-19 16:08:44 |
| 46 | 7 | 53 | 2015-02-19 16:08:44 |
| 47 | 7 | 54 | 2015-02-19 16:08:44 |
| 48 | 7 | 55 | 2015-02-19 16:08:44 |
| 49 | 7 | 56 | 2015-02-19 16:08:44 |
| 50 | 7 | 57 | 2015-02-19 16:08: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;