1CREATE TABLE manoeuvre_prediction (
2 sensing_time timestamp NOT NULL,
3 sid_num smallint NOT NULL,
4 product bigint NOT NULL,
5 burn_id varchar(14) NOT NULL,
6 delta_v_value double precision NOT NULL,
7 delta_v_unit varchar(4) NOT NULL,
8 mode_1 varchar(4) NOT NULL,
9 mode_2 varchar(4) NOT NULL,
10 pso_value double precision NOT NULL,
11 pso_unit varchar(4) NOT NULL
12);
13ALTER TABLE manoeuvre_prediction ADD CONSTRAINT manoeuvre_prediction_c PRIMARY KEY (sid_num,sensing_time);