Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1–25 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1 | 6 | 8 | 2015-02-19 16:08:44 |
| 2 | 6 | 9 | 2015-02-19 16:08:44 |
| 3 | 6 | 10 | 2015-02-19 16:08:44 |
| 4 | 6 | 11 | 2015-02-19 16:08:44 |
| 5 | 6 | 12 | 2015-02-19 16:08:44 |
| 6 | 6 | 13 | 2015-02-19 16:08:44 |
| 7 | 6 | 14 | 2015-02-19 16:08:44 |
| 8 | 6 | 15 | 2015-02-19 16:08:44 |
| 9 | 6 | 16 | 2015-02-19 16:08:44 |
| 10 | 6 | 17 | 2015-02-19 16:08:44 |
| 11 | 6 | 18 | 2015-02-19 16:08:44 |
| 12 | 6 | 19 | 2015-02-19 16:08:44 |
| 13 | 6 | 20 | 2015-02-19 16:08:44 |
| 14 | 6 | 21 | 2015-02-19 16:08:44 |
| 15 | 6 | 22 | 2015-02-19 16:08:44 |
| 16 | 6 | 23 | 2015-02-19 16:08:44 |
| 17 | 6 | 24 | 2015-02-19 16:08:44 |
| 18 | 6 | 25 | 2015-02-19 16:08:44 |
| 19 | 6 | 26 | 2015-02-19 16:08:44 |
| 20 | 6 | 27 | 2015-02-19 16:08:44 |
| 21 | 6 | 28 | 2015-02-19 16:08:44 |
| 22 | 6 | 29 | 2015-02-19 16:08:44 |
| 23 | 6 | 30 | 2015-02-19 16:08:44 |
| 24 | 6 | 31 | 2015-02-19 16:08:44 |
| 25 | 6 | 32 | 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;