1DROP TABLE geo_events;
2
3CREATE TABLE geo_events (
4 sensing_time timestamp NOT NULL,
5 sid_num smallint NOT NULL,
6 product bigint NOT NULL,
7 name varchar(20) NOT NULL,
8 description varchar(256),
9 absolute_orbit_number bigint CHECK (absolute_orbit_number >= 0) NOT NULL,
10 time_from_anx double precision NOT NULL,
11 deg_from_anx double precision NOT NULL,
12 parameters jsonb
13);
14ALTER TABLE geo_events ADD CONSTRAINT geo_events_pk PRIMARY KEY (sid_num,sensing_time,name);