Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,201–1,225 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1201 | 237 | 7255 | 2018-12-11 18:37:16 |
| 1202 | 254 | 7292 | 2018-12-20 08:24:13 |
| 1203 | 254 | 7293 | 2018-12-20 08:24:13 |
| 1204 | 254 | 7294 | 2018-12-20 08:24:13 |
| 1205 | 254 | 7295 | 2018-12-20 08:24:13 |
| 1206 | 254 | 7296 | 2018-12-20 08:24:13 |
| 1207 | 254 | 7297 | 2018-12-20 08:24:13 |
| 1208 | 254 | 7298 | 2018-12-20 08:24:13 |
| 1209 | 254 | 7299 | 2018-12-20 08:24:13 |
| 1210 | 254 | 7300 | 2018-12-20 08:24:13 |
| 1211 | 254 | 7301 | 2018-12-20 08:24:13 |
| 1212 | 254 | 7302 | 2018-12-20 08:24:13 |
| 1213 | 254 | 7303 | 2018-12-20 08:24:13 |
| 1214 | 254 | 7304 | 2018-12-20 08:24:13 |
| 1215 | 254 | 7305 | 2018-12-20 08:24:13 |
| 1216 | 254 | 7306 | 2018-12-20 08:24:13 |
| 1217 | 254 | 7307 | 2018-12-20 08:24:13 |
| 1218 | 254 | 7308 | 2018-12-20 08:24:13 |
| 1219 | 254 | 7309 | 2018-12-20 08:24:13 |
| 1220 | 254 | 7310 | 2018-12-20 08:24:13 |
| 1221 | 254 | 7311 | 2018-12-20 08:24:13 |
| 1222 | 254 | 7312 | 2018-12-20 08:24:13 |
| 1223 | 254 | 7313 | 2018-12-20 08:24:13 |
| 1224 | 254 | 7314 | 2018-12-20 08:24:13 |
| 1225 | 254 | 7315 | 2018-12-20 08:24:13 |
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;