Table
audio_guide_hire
Each hire: ticket, device, language, issuing and returning wing, times and payment.
Replaces in 2020: Hired Audio Guide
Rows 976–1,000 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 |
|---|---|---|---|---|---|---|---|---|
| 976 | 8899 | D547F386X8659H60 | 4867 | en | 2 | 2019-09-10 11:10:34 | 3 | 2019-09-10 12:40:40 |
| 977 | 8730 | D119M445Z8873B29 | 4874 | fr | 2 | 2019-09-11 12:31:30 | 2 | 2019-09-11 13:50:06 |
| 978 | 8954 | D432J989K2788F27 | 4879 | zh | 1 | 2019-09-13 11:37:15 | 1 | 2019-09-13 12:43:18 |
| 979 | 8953 | D592Z759N4619V32 | 4880 | zh | 1 | 2019-09-13 11:41:06 | 2 | 2019-09-13 13:54:55 |
| 980 | 8950 | D592Z759N4619V32 | 4882 | ru | 2 | 2019-09-14 09:28:07 | 2 | 2019-09-14 11:48:28 |
| 981 | 8952 | D186L149Z2216U43 | 4884 | en | 2 | 2019-09-14 14:47:24 | 2 | 2019-09-14 16:34:36 |
| 982 | 9098 | D127T102L7940A93 | 4902 | pt | 3 | 2019-09-22 12:56:58 | 3 | 2019-09-22 14:53:58 |
| 983 | 9086 | D570K624F8858E76 | 4903 | en | 2 | 2019-09-22 15:52:01 | 1 | 2019-09-22 17:58:15 |
| 984 | 9107 | D607F479P4765P37 | 4906 | fr | 2 | 2019-09-23 10:42:02 | 1 | 2019-09-23 12:59:31 |
| 985 | 9119 | D561K998R8427R26 | 4916 | it | 2 | 2019-09-29 09:23:24 | 3 | 2019-09-29 10:55:54 |
| 986 | 9141 | D072X344L7834Y11 | 4930 | en | 3 | 2019-10-07 09:41:26 | 3 | 2019-10-07 10:50:05 |
| 987 | 9147 | D207S645U1857P52 | 4933 | fr | 1 | 2019-10-08 11:16:53 | 1 | 2019-10-08 12:19:30 |
| 988 | 9150 | D952G324M2778N96 | 4934 | fr | 1 | 2019-10-08 11:18:38 | 1 | 2019-10-08 13:22:12 |
| 989 | 9166 | D910N244E8046F15 | 4944 | en | 1 | 2019-10-11 10:44:14 | 2 | 2019-10-11 11:48:12 |
| 990 | 9167 | D004U524E2632P53 | 4945 | en | 1 | 2019-10-11 10:52:46 | 3 | 2019-10-11 12:24:23 |
| 991 | 9113 | D034Y265X8016K49 | 4954 | zh | 3 | 2019-10-14 10:59:14 | 3 | 2019-10-14 12:36:09 |
| 992 | 9138 | D607F479P4765P37 | 4963 | nl | 1 | 2019-10-16 11:08:42 | 3 | 2019-10-16 12:59:04 |
| 993 | 9128 | D413Q817Y7694B71 | 4965 | zh | 2 | 2019-10-17 11:08:12 | 2 | 2019-10-17 12:33:56 |
| 994 | 9129 | D767Q927C0149V09 | 4966 | zh | 3 | 2019-10-17 11:17:24 | 1 | 2019-10-17 12:20:23 |
| 995 | 9234 | D592Z759N4619V32 | 4971 | en | 2 | 2019-10-18 10:46:42 | 1 | 2019-10-18 11:52:02 |
| 996 | 9295 | D626G044Z7549L99 | 4981 | en | 2 | 2019-10-22 11:51:37 | 3 | 2019-10-22 14:06:56 |
| 997 | 9305 | D710U525C8071V72 | 4992 | en | 1 | 2019-10-25 09:54:46 | 2 | 2019-10-25 12:43:34 |
| 998 | 9297 | D831V786T8186E00 | 4995 | en | 3 | 2019-10-26 10:45:01 | 1 | 2019-10-26 12:05:06 |
| 999 | 9183 | D665U414D8903Q14 | 4996 | nl | 3 | 2019-10-26 11:49:26 | 3 | 2019-10-26 13:09:02 |
| 1000 | 9238 | D831V786T8186E00 | 4997 | pt | 2 | 2019-10-26 15:07:17 | 3 | 2019-10-26 17:58:22 |
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;