Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,551–1,575 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1551 | 320 | 8909 | 2019-09-07 10:32:28 |
| 1552 | 320 | 8910 | 2019-09-07 10:32:28 |
| 1553 | 320 | 8911 | 2019-09-07 10:32:28 |
| 1554 | 320 | 8912 | 2019-09-07 10:32:28 |
| 1555 | 320 | 8913 | 2019-09-07 10:32:28 |
| 1556 | 320 | 8914 | 2019-09-07 10:32:28 |
| 1557 | 320 | 8915 | 2019-09-07 10:32:28 |
| 1558 | 320 | 8916 | 2019-09-07 10:32:28 |
| 1559 | 320 | 8917 | 2019-09-07 10:32:28 |
| 1560 | 320 | 8918 | 2019-09-07 10:32:28 |
| 1561 | 320 | 8919 | 2019-09-07 10:32:28 |
| 1562 | 320 | 8920 | 2019-09-07 10:32:28 |
| 1563 | 320 | 8921 | 2019-09-07 10:32:28 |
| 1564 | 320 | 8922 | 2019-09-07 10:32:28 |
| 1565 | 320 | 8923 | 2019-09-07 10:32:28 |
| 1566 | 320 | 8924 | 2019-09-07 10:32:28 |
| 1567 | 320 | 8925 | 2019-09-07 10:32:28 |
| 1568 | 320 | 8926 | 2019-09-07 10:32:28 |
| 1569 | 320 | 8927 | 2019-09-07 10:32:28 |
| 1570 | 320 | 8928 | 2019-09-07 10:32:28 |
| 1571 | 320 | 8929 | 2019-09-07 10:32:28 |
| 1572 | 320 | 8930 | 2019-09-07 10:32:28 |
| 1573 | 320 | 8931 | 2019-09-07 10:32:28 |
| 1574 | 320 | 8932 | 2019-09-07 10:32:28 |
| 1575 | 320 | 8933 | 2019-09-07 10:32:28 |
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;