Table
audio_guide_device
Device register; retired_on stays empty while the guide is in service.
Replaces in 2020: Audio Guide Device
Rows 1–25 of 56
| serial_numberTEXT | activated_onTEXT | retired_onTEXT |
|---|---|---|
| D004U524E2632P53 | 2019-04-01 | NULL |
| D023G377L5359W06 | 2019-04-01 | NULL |
| D034Y265X8016K49 | 2014-11-03 | NULL |
| D072X344L7834Y11 | 2014-11-03 | NULL |
| D080D377C3402T31 | 2014-11-03 | 2019-02-15 |
| D119M445Z8873B29 | 2019-04-01 | NULL |
| D127T102L7940A93 | 2014-11-03 | NULL |
| D130X023V8765P41 | 2017-03-06 | NULL |
| D166C398W2353J43 | 2014-11-03 | 2018-12-09 |
| D172H109Q6717T56 | 2017-03-06 | NULL |
| D177W168C4167Y04 | 2014-11-03 | 2018-09-15 |
| D186L149Z2216U43 | 2014-11-03 | NULL |
| D191E591F4947H41 | 2014-11-03 | 2019-01-20 |
| D207S645U1857P52 | 2019-04-01 | NULL |
| D265V521D1968K75 | 2014-11-03 | NULL |
| D324Z884K8486X42 | 2017-03-06 | NULL |
| D332R599Y1992N37 | 2017-03-06 | NULL |
| D347B753W8220U05 | 2019-04-01 | NULL |
| D347R255R5948E69 | 2014-11-03 | 2018-07-20 |
| D388J554M7671Q58 | 2017-03-06 | 2019-06-12 |
| D413Q817Y7694B71 | 2014-11-03 | NULL |
| D424A043K7283P36 | 2014-11-03 | NULL |
| D432J989K2788F27 | 2017-03-06 | NULL |
| D438U949Y7280M45 | 2017-03-06 | NULL |
| D462B968Z1112C56 | 2014-11-03 | 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;