Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,101–1,125 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1101 | 231 | 6986 | 2018-10-31 11:16:25 |
| 1102 | 231 | 6987 | 2018-10-31 11:16:25 |
| 1103 | 231 | 6988 | 2018-10-31 11:16:25 |
| 1104 | 231 | 6989 | 2018-10-31 11:16:25 |
| 1105 | 231 | 6990 | 2018-10-31 11:16:25 |
| 1106 | 231 | 6991 | 2018-10-31 11:16:25 |
| 1107 | 231 | 6992 | 2018-10-31 11:16:25 |
| 1108 | 231 | 6993 | 2018-10-31 11:16:25 |
| 1109 | 232 | 6994 | 2018-10-31 11:16:25 |
| 1110 | 232 | 6995 | 2018-10-31 11:16:25 |
| 1111 | 232 | 6996 | 2018-10-31 11:16:25 |
| 1112 | 232 | 6997 | 2018-10-31 11:16:25 |
| 1113 | 232 | 6998 | 2018-10-31 11:16:25 |
| 1114 | 232 | 6999 | 2018-10-31 11:16:25 |
| 1115 | 232 | 7000 | 2018-10-31 11:16:25 |
| 1116 | 220 | 7003 | 2018-10-31 20:32:31 |
| 1117 | 223 | 7005 | 2018-11-02 13:31:57 |
| 1118 | 223 | 7006 | 2018-11-02 13:31:57 |
| 1119 | 229 | 7014 | 2018-11-04 09:19:28 |
| 1120 | 229 | 7015 | 2018-11-04 09:19:28 |
| 1121 | 229 | 7016 | 2018-11-04 09:19:28 |
| 1122 | 222 | 7018 | 2018-11-04 15:29:41 |
| 1123 | 221 | 7040 | 2018-11-11 08:52:12 |
| 1124 | 221 | 7041 | 2018-11-11 08:52:12 |
| 1125 | 224 | 7043 | 2018-11-12 10:11:40 |
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;