Table
audio_guide_device
Device register; retired_on stays empty while the guide is in service.
Replaces in 2020: Audio Guide Device
Rows 26–50 of 56
| serial_numberTEXT | activated_onTEXT | retired_onTEXT |
|---|---|---|
| D477K685J7558W94 | 2017-03-06 | NULL |
| D500A274G0533N08 | 2017-03-06 | NULL |
| D510H421W1552A28 | 2017-03-06 | NULL |
| D511E829D1120P99 | 2019-04-01 | NULL |
| D547F386X8659H60 | 2014-11-03 | NULL |
| D558F571V1033X91 | 2017-03-06 | NULL |
| D561K998R8427R26 | 2014-11-03 | NULL |
| D570K624F8858E76 | 2017-03-06 | NULL |
| D581C144M4385J90 | 2019-04-01 | NULL |
| D586V966T0652S73 | 2014-11-03 | 2018-10-23 |
| D592Z759N4619V32 | 2019-04-01 | NULL |
| D597Q906D6251W67 | 2014-11-03 | 2019-03-21 |
| D601B335Z9665H81 | 2019-04-01 | NULL |
| D607F479P4765P37 | 2017-03-06 | NULL |
| D611Q961Z6085N96 | 2017-03-06 | NULL |
| D626G044Z7549L99 | 2019-04-01 | NULL |
| D663Z129H2049D24 | 2017-03-06 | NULL |
| D665U414D8903Q14 | 2019-04-01 | NULL |
| D689M436C2815G77 | 2019-04-01 | NULL |
| D710U525C8071V72 | 2019-04-01 | NULL |
| D724L458C1162U17 | 2014-11-03 | 2019-08-06 |
| D736D252Z3041D49 | 2014-11-03 | NULL |
| D767Q927C0149V09 | 2014-11-03 | NULL |
| D779R288A0500T96 | 2014-11-03 | 2016-04-04 |
| D831V786T8186E00 | 2017-03-06 | NULL |
Table definition
CREATE TABLE audio_guide_device (
serial_number TEXT PRIMARY KEY
CHECK (length(serial_number) = 16 AND serial_number NOT GLOB '*[^0-9A-Z]*'),
activated_on TEXT NOT NULL,
retired_on TEXT,
CHECK (retired_on IS NULL OR retired_on >= activated_on)
) STRICT;