Table
audio_guide_hire
Each hire: ticket, device, language, issuing and returning wing, times and payment.
Replaces in 2020: Hired Audio Guide
Rows 326–350 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 |
|---|---|---|---|---|---|---|---|---|
| 326 | 2652 | D547F386X8659H60 | 1507 | en | 2 | 2016-08-16 12:15:44 | 3 | 2016-08-16 13:44:38 |
| 327 | 2581 | D072X344L7834Y11 | 1516 | en | 2 | 2016-08-19 14:47:41 | 3 | 2016-08-19 16:58:41 |
| 328 | 2671 | D413Q817Y7694B71 | 1520 | it | 3 | 2016-08-21 10:49:00 | 3 | 2016-08-21 13:11:58 |
| 329 | 2670 | D072X344L7834Y11 | 1522 | en | 2 | 2016-08-21 14:00:47 | 2 | 2016-08-21 16:14:05 |
| 330 | 2676 | D177W168C4167Y04 | 1523 | en | 3 | 2016-08-21 14:44:31 | 1 | 2016-08-21 17:21:17 |
| 331 | 2738 | D186L149Z2216U43 | 1537 | en | 2 | 2016-08-26 09:21:12 | 2 | 2016-08-26 10:56:04 |
| 332 | 2745 | D191E591F4947H41 | 1540 | en | 2 | 2016-08-26 12:12:22 | 3 | 2016-08-26 14:16:50 |
| 333 | 2657 | D347R255R5948E69 | 1541 | it | 1 | 2016-08-26 14:55:36 | 1 | 2016-08-26 16:32:08 |
| 334 | 2656 | D127T102L7940A93 | 1542 | it | 1 | 2016-08-26 14:56:03 | 1 | 2016-08-26 16:16:54 |
| 335 | 2754 | D597Q906D6251W67 | 1548 | en | 2 | 2016-08-29 11:50:30 | 3 | 2016-08-29 12:43:39 |
| 336 | 2781 | D724L458C1162U17 | 1562 | fr | 2 | 2016-09-02 11:36:54 | 2 | 2016-09-02 13:55:25 |
| 337 | 2758 | D034Y265X8016K49 | 1574 | en | 2 | 2016-09-10 09:54:34 | 2 | 2016-09-10 11:46:42 |
| 338 | 2762 | D547F386X8659H60 | 1576 | fr | 2 | 2016-09-11 11:21:46 | 2 | 2016-09-11 14:23:48 |
| 339 | 2764 | D767Q927C0149V09 | 1577 | en | 2 | 2016-09-11 11:31:24 | 1 | 2016-09-11 12:41:52 |
| 340 | 2690 | D080D377C3402T31 | 1590 | pt | 2 | 2016-09-17 16:43:34 | 3 | 2016-09-17 18:10:00 |
| 341 | 2822 | D347R255R5948E69 | 1599 | en | 3 | 2016-09-20 09:51:40 | 3 | 2016-09-20 10:44:55 |
| 342 | 2814 | D561K998R8427R26 | 1602 | ru | 2 | 2016-09-21 11:23:49 | 2 | 2016-09-21 12:28:06 |
| 343 | 2834 | D127T102L7940A93 | 1607 | en | 1 | 2016-09-22 10:57:54 | 3 | 2016-09-22 12:27:47 |
| 344 | 2803 | D127T102L7940A93 | 1609 | en | 2 | 2016-09-22 16:00:38 | 1 | 2016-09-22 18:00:58 |
| 345 | 2843 | D072X344L7834Y11 | 1612 | en | 2 | 2016-09-24 14:05:34 | 3 | 2016-09-24 16:29:12 |
| 346 | 2842 | D424A043K7283P36 | 1613 | en | 1 | 2016-09-24 14:16:43 | 2 | 2016-09-24 15:21:32 |
| 347 | 2851 | D191E591F4947H41 | 1617 | zh | 2 | 2016-09-27 10:11:30 | 3 | 2016-09-27 12:49:00 |
| 348 | 2849 | D186L149Z2216U43 | 1621 | zh | 1 | 2016-09-28 10:58:23 | 2 | 2016-09-28 12:31:17 |
| 349 | 2850 | D413Q817Y7694B71 | 1622 | zh | 1 | 2016-09-28 10:58:23 | 3 | 2016-09-28 12:00:19 |
| 350 | 2808 | D347R255R5948E69 | 1627 | en | 3 | 2016-10-01 10:40:40 | 3 | 2016-10-01 15:35:51 |
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;