Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,051–1,075 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1051 | 234 | 6821 | 2018-10-01 14:22:44 |
| 1052 | 234 | 6822 | 2018-10-01 14:22:44 |
| 1053 | 234 | 6823 | 2018-10-01 14:22:44 |
| 1054 | 234 | 6824 | 2018-10-01 14:22:44 |
| 1055 | 234 | 6825 | 2018-10-01 14:22:44 |
| 1056 | 234 | 6826 | 2018-10-01 14:22:44 |
| 1057 | 234 | 6827 | 2018-10-01 14:22:44 |
| 1058 | 234 | 6828 | 2018-10-01 14:22:44 |
| 1059 | 213 | 6839 | 2018-10-04 07:12:21 |
| 1060 | 217 | 6888 | 2018-10-16 15:39:18 |
| 1061 | 219 | 6901 | 2018-10-21 15:31:45 |
| 1062 | 218 | 6925 | 2018-10-27 14:42:39 |
| 1063 | 218 | 6926 | 2018-10-27 14:42:39 |
| 1064 | 231 | 6949 | 2018-10-31 11:16:25 |
| 1065 | 231 | 6950 | 2018-10-31 11:16:25 |
| 1066 | 231 | 6951 | 2018-10-31 11:16:25 |
| 1067 | 231 | 6952 | 2018-10-31 11:16:25 |
| 1068 | 231 | 6953 | 2018-10-31 11:16:25 |
| 1069 | 231 | 6954 | 2018-10-31 11:16:25 |
| 1070 | 231 | 6955 | 2018-10-31 11:16:25 |
| 1071 | 231 | 6956 | 2018-10-31 11:16:25 |
| 1072 | 231 | 6957 | 2018-10-31 11:16:25 |
| 1073 | 231 | 6958 | 2018-10-31 11:16:25 |
| 1074 | 231 | 6959 | 2018-10-31 11:16:25 |
| 1075 | 231 | 6960 | 2018-10-31 11:16:25 |
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;