Table
audio_guide_hire
Each hire: ticket, device, language, issuing and returning wing, times and payment.
Replaces in 2020: Hired Audio Guide
Rows 251–275 of 1,085
| hire_idINTEGER | ticket_id→ ticket.ticket_id | serial_number→ audio_guide_device.serial_number | order_id→ purchase_order.order_id | language_code→ language.language_code | issued_wing_id→ wing.wing_id | issued_atTEXT | returned_wing_id→ wing.wing_id | returned_atTEXT |
|---|---|---|---|---|---|---|---|---|
| 251 | 2089 | D561K998R8427R26 | 1163 | en | 2 | 2016-04-26 17:05:16 | 1 | 2016-04-26 18:10:00 |
| 252 | 2120 | D034Y265X8016K49 | 1175 | fr | 3 | 2016-05-01 17:22:15 | 1 | 2016-05-01 18:10:00 |
| 253 | 2122 | D166C398W2353J43 | 1180 | zh | 2 | 2016-05-02 09:31:42 | 2 | 2016-05-02 10:34:26 |
| 254 | 2096 | D072X344L7834Y11 | 1182 | es | 1 | 2016-05-02 10:11:47 | 3 | 2016-05-02 11:39:51 |
| 255 | 2139 | D561K998R8427R26 | 1190 | fr | 1 | 2016-05-04 13:07:52 | 1 | 2016-05-04 15:00:30 |
| 256 | 2132 | D072X344L7834Y11 | 1203 | fr | 2 | 2016-05-08 14:43:55 | 2 | 2016-05-08 16:55:25 |
| 257 | 2257 | D948A201L8911R06 | 1224 | fi | 2 | 2016-05-14 13:10:02 | 1 | 2016-05-14 14:46:44 |
| 258 | 2128 | D724L458C1162U17 | 1225 | pt | 2 | 2016-05-14 14:28:17 | 1 | 2016-05-14 15:41:12 |
| 259 | 2278 | D547F386X8659H60 | 1239 | pl | 2 | 2016-05-18 11:40:41 | 3 | 2016-05-18 13:38:12 |
| 260 | 2281 | D547F386X8659H60 | 1241 | en | 2 | 2016-05-18 15:00:05 | 2 | 2016-05-18 17:57:55 |
| 261 | 2262 | D767Q927C0149V09 | 1243 | en | 2 | 2016-05-20 10:51:31 | 2 | 2016-05-20 13:19:45 |
| 262 | 2270 | D462B968Z1112C56 | 1247 | ko | 2 | 2016-05-23 09:23:16 | 3 | 2016-05-23 11:41:12 |
| 263 | 2269 | D166C398W2353J43 | 1248 | ko | 2 | 2016-05-23 09:34:21 | 2 | 2016-05-23 10:43:20 |
| 264 | 2141 | D724L458C1162U17 | 1253 | en | 2 | 2016-05-25 10:45:36 | 2 | 2016-05-25 12:25:51 |
| 265 | 2292 | D072X344L7834Y11 | 1256 | zh | 1 | 2016-05-26 11:39:58 | 3 | 2016-05-26 14:28:55 |
| 266 | 2296 | D034Y265X8016K49 | 1260 | en | 1 | 2016-05-28 10:54:19 | 1 | 2016-05-28 11:51:21 |
| 267 | 2299 | D177W168C4167Y04 | 1262 | ko | 2 | 2016-05-28 15:34:43 | 2 | 2016-05-28 18:10:00 |
| 268 | 2202 | D413Q817Y7694B71 | 1264 | fr | 2 | 2016-05-29 12:26:46 | 1 | 2016-05-29 13:55:40 |
| 269 | 2285 | D166C398W2353J43 | 1266 | ko | 2 | 2016-05-29 15:03:54 | 2 | 2016-05-29 17:49:53 |
| 270 | 2318 | D597Q906D6251W67 | 1274 | en | 2 | 2016-06-02 09:42:15 | 2 | 2016-06-02 12:07:30 |
| 271 | 2282 | D347R255R5948E69 | 1282 | en | 2 | 2016-06-04 10:33:16 | 3 | 2016-06-04 12:59:00 |
| 272 | 2335 | D424A043K7283P36 | 1284 | es | 3 | 2016-06-04 12:57:27 | 1 | 2016-06-04 14:20:15 |
| 273 | 2343 | D724L458C1162U17 | 1290 | fr | 1 | 2016-06-06 13:14:03 | 1 | 2016-06-06 14:49:55 |
| 274 | 2309 | D191E591F4947H41 | 1295 | fr | 2 | 2016-06-09 10:13:57 | 2 | 2016-06-09 12:24:45 |
| 275 | 2351 | D586V966T0652S73 | 1296 | ko | 1 | 2016-06-09 10:27:10 | 1 | 2016-06-09 12:50:58 |
Table definition
CREATE TABLE audio_guide_hire (
hire_id INTEGER PRIMARY KEY,
ticket_id INTEGER NOT NULL REFERENCES ticket (ticket_id),
serial_number TEXT NOT NULL REFERENCES audio_guide_device (serial_number),
order_id INTEGER NOT NULL UNIQUE REFERENCES purchase_order (order_id),
language_code TEXT NOT NULL REFERENCES language (language_code),
issued_wing_id INTEGER NOT NULL REFERENCES wing (wing_id),
issued_at TEXT NOT NULL,
returned_wing_id INTEGER REFERENCES wing (wing_id),
returned_at TEXT,
CHECK ((returned_at IS NULL) = (returned_wing_id IS NULL)),
CHECK (returned_at IS NULL OR returned_at > issued_at)
) STRICT;