CREATE TABLE {schema}.c_events
(
  date character varying,
  receiver character varying,
  description character varying,
  data character varying,
  units character varying,
  CONSTRAINT c_evnt UNIQUE (date, receiver, description)
)
WITH (
  OIDS=FALSE
);

CREATE TABLE {schema}.c_detections
(
  date character varying,
  code_space character varying,
  id character varying,
  sensor_1 character varying,
  units_1 character varying,
  sensor_2 character varying,
  units_2 character varying,
  transmitter_name character varying,
  transmitter_sn character varying,
  receiver_name character varying,
  receiver_sn character varying,
  station_name character varying,
  station_lat character varying,
  station_lon character varying,
  CONSTRAINT c_dect UNIQUE (date, receiver_sn)
)
WITH (
  OIDS=FALSE
);

