Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,676–1,700 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1676 | 329 | 9206 | 2019-10-17 12:29:12 |
| 1677 | 329 | 9207 | 2019-10-17 12:29:12 |
| 1678 | 329 | 9208 | 2019-10-17 12:29:12 |
| 1679 | 329 | 9209 | 2019-10-17 12:29:12 |
| 1680 | 329 | 9210 | 2019-10-17 12:29:12 |
| 1681 | 329 | 9211 | 2019-10-17 12:29:12 |
| 1682 | 329 | 9212 | 2019-10-17 12:29:12 |
| 1683 | 329 | 9213 | 2019-10-17 12:29:12 |
| 1684 | 329 | 9214 | 2019-10-17 12:29:12 |
| 1685 | 329 | 9215 | 2019-10-17 12:29:12 |
| 1686 | 329 | 9216 | 2019-10-17 12:29:12 |
| 1687 | 329 | 9217 | 2019-10-17 12:29:12 |
| 1688 | 329 | 9218 | 2019-10-17 12:29:12 |
| 1689 | 329 | 9219 | 2019-10-17 12:29:12 |
| 1690 | 329 | 9220 | 2019-10-17 12:29:12 |
| 1691 | 329 | 9221 | 2019-10-17 12:29:12 |
| 1692 | 329 | 9222 | 2019-10-17 12:29:12 |
| 1693 | 329 | 9223 | 2019-10-17 12:29:12 |
| 1694 | 329 | 9224 | 2019-10-17 12:29:12 |
| 1695 | 329 | 9225 | 2019-10-17 12:29:12 |
| 1696 | 329 | 9226 | 2019-10-17 12:29:12 |
| 1697 | 329 | 9227 | 2019-10-17 12:29:12 |
| 1698 | 309 | 9236 | 2019-10-18 21:24:06 |
| 1699 | 309 | 9237 | 2019-10-18 21:24:06 |
| 1700 | 309 | 9238 | 2019-10-18 21:24:06 |
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;