drop table zc;
create table zc (
	time timestamp with time zone default now(),
	PN integer not null,
	Alarm_axis smallint not null,
	X_axis_angle float not null,
	Y_axis_angle float not null,
	Signal_strength smallint not null,
	Arming_disarming smallint not null,
	Sensor_temperature float not null,
	Power_source_voltage float not null,
	Sensor_operating_mode smallint not null,
	_id serial
);


grant select on zc to  grafana ;
