Table
exhibition_booking
A ticket's place in a slot; a trigger stops overbooking.
Replaces in 2020: Exhibition Booking, Booking Ticket
Rows 1,076–1,100 of 2,015
| booking_idINTEGER | slot_id→ exhibition_slot.slot_id | ticket_id→ ticket.ticket_id | booked_atTEXT |
|---|---|---|---|
| 1076 | 231 | 6961 | 2018-10-31 11:16:25 |
| 1077 | 231 | 6962 | 2018-10-31 11:16:25 |
| 1078 | 231 | 6963 | 2018-10-31 11:16:25 |
| 1079 | 231 | 6964 | 2018-10-31 11:16:25 |
| 1080 | 231 | 6965 | 2018-10-31 11:16:25 |
| 1081 | 231 | 6966 | 2018-10-31 11:16:25 |
| 1082 | 231 | 6967 | 2018-10-31 11:16:25 |
| 1083 | 231 | 6968 | 2018-10-31 11:16:25 |
| 1084 | 231 | 6969 | 2018-10-31 11:16:25 |
| 1085 | 231 | 6970 | 2018-10-31 11:16:25 |
| 1086 | 231 | 6971 | 2018-10-31 11:16:25 |
| 1087 | 231 | 6972 | 2018-10-31 11:16:25 |
| 1088 | 231 | 6973 | 2018-10-31 11:16:25 |
| 1089 | 231 | 6974 | 2018-10-31 11:16:25 |
| 1090 | 231 | 6975 | 2018-10-31 11:16:25 |
| 1091 | 231 | 6976 | 2018-10-31 11:16:25 |
| 1092 | 231 | 6977 | 2018-10-31 11:16:25 |
| 1093 | 231 | 6978 | 2018-10-31 11:16:25 |
| 1094 | 231 | 6979 | 2018-10-31 11:16:25 |
| 1095 | 231 | 6980 | 2018-10-31 11:16:25 |
| 1096 | 231 | 6981 | 2018-10-31 11:16:25 |
| 1097 | 231 | 6982 | 2018-10-31 11:16:25 |
| 1098 | 231 | 6983 | 2018-10-31 11:16:25 |
| 1099 | 231 | 6984 | 2018-10-31 11:16:25 |
| 1100 | 231 | 6985 | 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;