Table
audio_guide_hire
Each hire: ticket, device, language, issuing and returning wing, times and payment.
Replaces in 2020: Hired Audio Guide
Rows 676–700 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 |
|---|---|---|---|---|---|---|---|---|
| 676 | 5824 | D413Q817Y7694B71 | 3265 | nl | 1 | 2018-05-27 11:32:51 | 2 | 2018-05-27 14:25:01 |
| 677 | 5869 | D347R255R5948E69 | 3275 | en | 3 | 2018-05-30 09:56:55 | 3 | 2018-05-30 11:35:16 |
| 678 | 5871 | D948A201L8911R06 | 3277 | fr | 1 | 2018-05-30 12:00:32 | 3 | 2018-05-30 14:48:20 |
| 679 | 5822 | D767Q927C0149V09 | 3287 | zh | 1 | 2018-06-01 10:51:07 | 3 | 2018-06-01 13:14:40 |
| 680 | 5813 | D558F571V1033X91 | 3291 | zh | 1 | 2018-06-02 12:03:31 | 3 | 2018-06-02 14:14:02 |
| 681 | 5796 | D332R599Y1992N37 | 3292 | fr | 2 | 2018-06-02 12:43:48 | 1 | 2018-06-02 15:08:15 |
| 682 | 5893 | D130X023V8765P41 | 3294 | nl | 3 | 2018-06-02 14:29:21 | 1 | 2018-06-02 15:42:38 |
| 683 | 5947 | D547F386X8659H60 | 3314 | fr | 3 | 2018-06-09 13:50:03 | 1 | 2018-06-09 15:52:53 |
| 684 | 5948 | D477K685J7558W94 | 3315 | en | 2 | 2018-06-09 13:58:52 | 2 | 2018-06-09 15:40:14 |
| 685 | 6021 | D558F571V1033X91 | 3320 | en | 1 | 2018-06-10 12:58:04 | 1 | 2018-06-10 14:22:26 |
| 686 | 6030 | D265V521D1968K75 | 3327 | fr | 1 | 2018-06-12 15:29:21 | 1 | 2018-06-12 18:05:22 |
| 687 | 6042 | D831V786T8186E00 | 3332 | en | 2 | 2018-06-13 12:53:09 | 3 | 2018-06-13 14:56:59 |
| 688 | 6041 | D424A043K7283P36 | 3333 | fr | 3 | 2018-06-13 15:12:13 | 1 | 2018-06-13 17:51:27 |
| 689 | 6035 | D736D252Z3041D49 | 3340 | en | 1 | 2018-06-15 13:41:27 | 1 | 2018-06-15 14:32:12 |
| 690 | 6057 | D413Q817Y7694B71 | 3345 | it | 2 | 2018-06-17 12:41:27 | 3 | 2018-06-17 14:46:40 |
| 691 | 6019 | D072X344L7834Y11 | 3356 | en | 2 | 2018-06-23 14:13:58 | 2 | 2018-06-23 15:32:06 |
| 692 | 6079 | D186L149Z2216U43 | 3360 | en | 2 | 2018-06-24 10:40:12 | 2 | 2018-06-24 12:54:23 |
| 693 | 6081 | D948A201L8911R06 | 3373 | es | 1 | 2018-06-28 12:58:15 | 1 | 2018-06-28 16:03:09 |
| 694 | 6098 | D127T102L7940A93 | 3379 | en | 3 | 2018-06-29 11:02:13 | 2 | 2018-06-29 13:51:44 |
| 695 | 6087 | D177W168C4167Y04 | 3387 | zh | 2 | 2018-06-30 17:05:16 | 2 | 2018-06-30 18:10:00 |
| 696 | 6084 | D324Z884K8486X42 | 3388 | zh | 2 | 2018-06-30 17:11:44 | 2 | 2018-06-30 18:10:00 |
| 697 | 6113 | D547F386X8659H60 | 3396 | en | 2 | 2018-07-04 15:57:35 | 1 | 2018-07-04 17:28:45 |
| 698 | 6182 | D177W168C4167Y04 | 3402 | nl | 3 | 2018-07-05 13:19:38 | 2 | 2018-07-05 15:58:17 |
| 699 | 6186 | D462B968Z1112C56 | 3408 | en | 2 | 2018-07-07 09:13:30 | 2 | 2018-07-07 09:59:55 |
| 700 | 6190 | D724L458C1162U17 | 3411 | en | 3 | 2018-07-08 10:42:45 | 2 | 2018-07-08 12:41:30 |
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;