1CREATE TABLE predicted_orbit (
2 sensing_time timestamp NOT NULL,
3 sid_num smallint NOT NULL,
4 product bigint NOT NULL,
5 x double precision NOT NULL,
6 y double precision NOT NULL,
7 z double precision NOT NULL,
8 vx double precision NOT NULL,
9 vy double precision NOT NULL,
10 vz double precision NOT NULL
11);
12ALTER TABLE predicted_orbit ADD CONSTRAINT predicted_orbit_c PRIMARY KEY (sid_num,sensing_time);