3 time timestamp with time zone default now(),
5 Alarm_axis smallint not null,
6 X_axis_angle float not null,
7 Y_axis_angle float not null,
8 Signal_strength smallint not null,
9 Arming_disarming smallint not null,
10 Sensor_temperature float not null,
11 Power_source_voltage float not null,
12 Sensor_operating_mode smallint not null,
16 create index zc_pn on zc(pn) ;
18 create user grafana password 'readonly' ;
19 grant select on zc to grafana ;