Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 51–75 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 51 | 7 | 58 | 2015-02-19 16:08:44 |
| 52 | 7 | 59 | 2015-02-19 16:08:44 |
| 53 | 7 | 60 | 2015-02-19 16:08:44 |
| 54 | 7 | 61 | 2015-02-19 16:08:44 |
| 55 | 7 | 62 | 2015-02-19 16:08:44 |
| 56 | 7 | 63 | 2015-02-19 16:08:44 |
| 57 | 7 | 64 | 2015-02-19 16:08:44 |
| 58 | 7 | 65 | 2015-02-19 16:08:44 |
| 59 | 3 | 82 | 2015-03-05 23:00:21 |
| 60 | 1 | 107 | 2015-03-17 22:55:18 |
| 61 | 11 | 112 | 2015-03-20 16:14:05 |
| 62 | 11 | 113 | 2015-03-20 16:14:05 |
| 63 | 11 | 114 | 2015-03-20 16:14:05 |
| 64 | 11 | 115 | 2015-03-20 16:14:05 |
| 65 | 11 | 116 | 2015-03-20 16:14:05 |
| 66 | 11 | 117 | 2015-03-20 16:14:05 |
| 67 | 11 | 118 | 2015-03-20 16:14:05 |
| 68 | 11 | 119 | 2015-03-20 16:14:05 |
| 69 | 11 | 120 | 2015-03-20 16:14:05 |
| 70 | 11 | 121 | 2015-03-20 16:14:05 |
| 71 | 11 | 122 | 2015-03-20 16:14:05 |
| 72 | 11 | 123 | 2015-03-20 16:14:05 |
| 73 | 11 | 124 | 2015-03-20 16:14:05 |
| 74 | 11 | 125 | 2015-03-20 16:14:05 |
| 75 | 11 | 126 | 2015-03-20 16:14:05 |
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;