1CREATE TABLE manoeuvre_prediction (
2 sensing_time timestamp NOT NULL,
3 sid_num smallint NOT NULL,
4 product bigint NOT NULL,
5 file_gen_time timestamp NOT NULL,
6 optim_time timestamp NOT NULL,
7 mode varchar(20) NOT NULL,
8 size double precision NOT NULL,
9 pso double precision NOT NULL
10);
11ALTER TABLE manoeuvre_prediction ADD CONSTRAINT manoeuvre_prediction_c PRIMARY KEY (sid_num,sensing_time);