Table
audio_guide_hire
Each hire: ticket, device, language, issuing and returning wing, times and payment.
Replaces in 2020: Hired Audio Guide
Rows 226–250 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 |
|---|---|---|---|---|---|---|---|---|
| 226 | 1962 | D072X344L7834Y11 | 1069 | en | 2 | 2016-03-19 15:35:10 | 3 | 2016-03-19 17:11:02 |
| 227 | 1967 | D597Q906D6251W67 | 1072 | nl | 3 | 2016-03-20 09:38:51 | 2 | 2016-03-20 11:19:00 |
| 228 | 1975 | D265V521D1968K75 | 1073 | en | 3 | 2016-03-20 09:57:25 | 2 | 2016-03-20 11:31:15 |
| 229 | 1881 | D191E591F4947H41 | 1074 | ko | 3 | 2016-03-20 11:42:03 | 3 | 2016-03-20 14:03:22 |
| 230 | 1954 | D779R288A0500T96 | 1078 | en | 2 | 2016-03-21 15:01:10 | 2 | 2016-03-21 16:52:57 |
| 231 | 1953 | D186L149Z2216U43 | 1079 | en | 2 | 2016-03-21 15:02:01 | 3 | 2016-03-21 16:21:01 |
| 232 | 1950 | D561K998R8427R26 | 1080 | en | 2 | 2016-03-21 15:17:57 | 3 | 2016-03-21 16:42:42 |
| 233 | 1979 | D265V521D1968K75 | 1081 | en | 1 | 2016-03-21 15:37:47 | 1 | 2016-03-21 17:34:10 |
| 234 | 1980 | D597Q906D6251W67 | 1082 | en | 1 | 2016-03-21 15:39:47 | 1 | 2016-03-21 18:10:00 |
| 235 | 1988 | D127T102L7940A93 | 1096 | en | 1 | 2016-03-28 11:13:50 | 1 | 2016-03-28 12:58:48 |
| 236 | 2021 | D424A043K7283P36 | 1106 | en | 2 | 2016-04-01 12:05:19 | 3 | 2016-04-01 13:46:42 |
| 237 | 2013 | D597Q906D6251W67 | 1107 | en | 2 | 2016-04-01 14:24:41 | 2 | 2016-04-01 16:03:02 |
| 238 | 2014 | D186L149Z2216U43 | 1108 | en | 2 | 2016-04-01 14:26:18 | 1 | 2016-04-01 17:34:18 |
| 239 | 2024 | D779R288A0500T96 | 1110 | fr | 2 | 2016-04-01 17:04:03 | 2 | 2016-04-01 18:10:00 |
| 240 | 1966 | D779R288A0500T96 | 1111 | nl | 2 | 2016-04-03 13:11:19 | NULL | NULL |
| 241 | 2041 | D736D252Z3041D49 | 1123 | fr | 1 | 2016-04-10 13:08:11 | 1 | 2016-04-10 16:09:55 |
| 242 | 2046 | D080D377C3402T31 | 1125 | zh | 2 | 2016-04-10 15:10:48 | 2 | 2016-04-10 16:06:49 |
| 243 | 2048 | D166C398W2353J43 | 1136 | zh | 2 | 2016-04-16 10:19:16 | 3 | 2016-04-16 13:05:08 |
| 244 | 2064 | D948A201L8911R06 | 1138 | zh | 1 | 2016-04-16 13:06:04 | 1 | 2016-04-16 14:30:13 |
| 245 | 2068 | D413Q817Y7694B71 | 1142 | en | 2 | 2016-04-17 10:25:09 | 1 | 2016-04-17 12:05:15 |
| 246 | 2069 | D177W168C4167Y04 | 1143 | en | 2 | 2016-04-17 10:34:45 | 1 | 2016-04-17 12:58:14 |
| 247 | 2071 | D127T102L7940A93 | 1147 | fr | 2 | 2016-04-19 09:15:18 | 1 | 2016-04-19 10:43:48 |
| 248 | 2074 | D462B968Z1112C56 | 1152 | en | 2 | 2016-04-22 11:14:14 | 1 | 2016-04-22 12:46:21 |
| 249 | 2072 | D547F386X8659H60 | 1153 | no | 3 | 2016-04-22 11:15:04 | 1 | 2016-04-22 14:53:22 |
| 250 | 2080 | D127T102L7940A93 | 1155 | ko | 3 | 2016-04-24 10:28:20 | 2 | 2016-04-24 11:55:23 |
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;