Table

audio_guide_device

Device register; retired_on stays empty while the guide is in service.

Replaces in 2020: Audio Guide Device

Rows 51–56 of 56

audio_guide_device, page 3 of 3
serial_numberTEXT	activated_onTEXT	retired_onTEXT
D841H941H0791Q12	2014-11-03	2019-02-10
D843X661P8223W21	2014-11-03	2019-07-19
D845W425F3685F62	2019-04-01	NULL
D910N244E8046F15	2019-04-01	NULL
D948A201L8911R06	2014-11-03	2019-07-01
D952G324M2778N96	2019-04-01	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;