1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
CREATE TABLE SPECTRUM_S.SPECTRUM_T_SPM(
SPM_ID SERIAL NOT NULL ,
SPM_FITS_FILE VARCHAR (100) NOT NULL ,
SPM_HELIO_CORRECTION HELIOCORRECTION_D NOT NULL ,
SPM_TELLURIC_CORRECTION CHAR (50) NOT NULL ,
SPM_COSMIC_REMOVAL CHAR (50) NOT NULL ,
SPM_NORMALISATION CHAR (50) NOT NULL ,
SPM_DISPLAY BOOL NOT NULL ,
OBJ_ID INT NOT NULL ,
TLS_ID INT NOT NULL ,
TLP_ID INT NOT NULL ,
SPM_EXPOSURE_START_DATETIME TIMESTAMP NOT NULL ,
EXPOSURE_TIME INTERVAL SECOND NOT NULL ,
CONSTRAINT SPM_T_PK PRIMARY KEY (OBJ_ID,SPM_ID)
) WITHOUT OIDS;
ALTER TABLE SPECTRUM_S.SPECTRUM_T_SPM
ADD CONSTRAINT SPM_T_FK1 FOREIGN KEY (OBJ_ID)
REFERENCES CATALOG_S.OBJECT_T_OBJ (OBJ_ID);
ALTER TABLE SPECTRUM_S.SPECTRUM_T_SPM
ADD CONSTRAINT SPM_T_FK2 FOREIGN KEY (TLS_ID,TLP_ID)
REFERENCES SITE_S.TELESCOPE_SITE_T_TLS (TLS_ID,TLP_ID); |
Partager