1CREATE TABLE sat_mass_report (
2 sensing_time timestamp NOT NULL,
3 sid_num smallint NOT NULL,
4 product bigint NOT NULL,
5 xs double precision NOT NULL,
6 ys double precision NOT NULL,
7 zs double precision NOT NULL,
8 total_mass double precision NOT NULL,
9 fuel_mass double precision NOT NULL,
10 inertia_xx double precision NOT NULL,
11 inertia_yy double precision NOT NULL,
12 inertia_zz double precision NOT NULL,
13 inertia_xy double precision NOT NULL,
14 inertia_yz double precision NOT NULL,
15 inertia_zx double precision NOT NULL
16);
17ALTER TABLE sat_mass_report ADD CONSTRAINT sat_mass_report_c PRIMARY KEY (sid_num,sensing_time);