-- -- ER/Studio 8.0 SQL Code Generation -- Company : Berkeley Seismological Laboratory -- Project : CISN Hardware Tracking -- Author : Stephane Zuzlewski -- -- Date Created : Friday, January 09, 2009 10:16:37 -- Target DBMS : Oracle 10g -- DROP TABLE Datalogger CASCADE CONSTRAINTS ; DROP TABLE Datalogger_Board CASCADE CONSTRAINTS ; DROP TABLE Datalogger_Module CASCADE CONSTRAINTS ; DROP TABLE Filamp CASCADE CONSTRAINTS ; DROP TABLE Filamp_PChannel CASCADE CONSTRAINTS ; DROP TABLE Filter CASCADE CONSTRAINTS ; DROP TABLE Filter_FIR CASCADE CONSTRAINTS ; DROP TABLE Filter_FIR_Data CASCADE CONSTRAINTS ; DROP TABLE Filter_Sequence CASCADE CONSTRAINTS ; DROP TABLE Filter_Sequence_Data CASCADE CONSTRAINTS ; DROP TABLE Response CASCADE CONSTRAINTS ; DROP TABLE Response_HP CASCADE CONSTRAINTS ; DROP TABLE Response_LP CASCADE CONSTRAINTS ; DROP TABLE Response_PN CASCADE CONSTRAINTS ; DROP TABLE Response_PN_Data CASCADE CONSTRAINTS ; DROP TABLE Response_PZ CASCADE CONSTRAINTS ; DROP TABLE Sensor CASCADE CONSTRAINTS ; DROP TABLE Sensor_Component CASCADE CONSTRAINTS ; DROP TABLE Station CASCADE CONSTRAINTS ; DROP TABLE Station_Datalogger CASCADE CONSTRAINTS ; DROP TABLE Station_Datalogger_LChannel CASCADE CONSTRAINTS ; DROP TABLE Station_Datalogger_PChannel CASCADE CONSTRAINTS ; DROP TABLE Station_Digitizer CASCADE CONSTRAINTS ; DROP TABLE Station_Digitizer_PChannel CASCADE CONSTRAINTS ; DROP TABLE Station_Filamp CASCADE CONSTRAINTS ; DROP TABLE Station_Filamp_PChannel CASCADE CONSTRAINTS ; DROP TABLE Station_Sensor CASCADE CONSTRAINTS ; DROP TABLE Station_Sensor_Component CASCADE CONSTRAINTS ; DROP SEQUENCE dataseq ; DROP SEQUENCE filampseq ; DROP SEQUENCE filterseq ; DROP SEQUENCE firseq ; DROP SEQUENCE hpseq ; DROP SEQUENCE lpseq ; DROP SEQUENCE pnseq ; DROP SEQUENCE pzseq ; DROP SEQUENCE respseq ; DROP SEQUENCE sensorseq ; DROP SEQUENCE seqfilseq ; -- -- SEQUENCE: dataseq -- CREATE SEQUENCE DATASEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 ORDER ; -- -- SEQUENCE: filampseq -- CREATE SEQUENCE FILAMPSEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 ORDER ; -- -- SEQUENCE: filterseq -- CREATE SEQUENCE FILTERSEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 ORDER ; -- -- SEQUENCE: firseq -- CREATE SEQUENCE FIRSEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 ORDER ; -- -- SEQUENCE: hpseq -- CREATE SEQUENCE HPSEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 ORDER ; -- -- SEQUENCE: lpseq -- CREATE SEQUENCE LPSEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 ORDER ; -- -- SEQUENCE: pnseq -- CREATE SEQUENCE PNSEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 ORDER ; -- -- SEQUENCE: pzseq -- CREATE SEQUENCE PZSEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 ORDER ; -- -- SEQUENCE: respseq -- CREATE SEQUENCE RESPSEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 ORDER ; -- -- SEQUENCE: sensorseq -- CREATE SEQUENCE SENSORSEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 ORDER ; -- -- SEQUENCE: seqfilseq -- CREATE SEQUENCE SEQFILSEQ START WITH 1 INCREMENT BY 1 NOMINVALUE NOMAXVALUE CACHE 20 ORDER ; -- -- TABLE: Datalogger -- CREATE TABLE Datalogger( data_id NUMBER(8, 0) NOT NULL, data_type VARCHAR2(80), serial_nb VARCHAR2(80), firmware_nb VARCHAR2(80), software VARCHAR2(80), software_nb VARCHAR2(80), ondate DATE NOT NULL, offdate DATE, nb_board NUMBER(8, 0), word_32 NUMBER(8, 0) NOT NULL, word_16 NUMBER(8, 0) NOT NULL, lddate DATE DEFAULT (SYSDATE), CONSTRAINT Da00 PRIMARY KEY (data_id) ) TABLESPACE HT_DATA ; -- -- TABLE: Datalogger_Board -- CREATE TABLE Datalogger_Board( data_id NUMBER(8, 0) NOT NULL, board_nb NUMBER(8, 0) NOT NULL, serial_nb VARCHAR2(80), nb_module NUMBER(8, 0) NOT NULL, firmware_nb VARCHAR2(80), lddate DATE DEFAULT (SYSDATE), CONSTRAINT DaB00 PRIMARY KEY (data_id, board_nb) ) TABLESPACE HT_DATA ; -- -- TABLE: Datalogger_Module -- CREATE TABLE Datalogger_Module( data_id NUMBER(8, 0) NOT NULL, board_nb NUMBER(8, 0) NOT NULL, module_nb NUMBER(8, 0) NOT NULL, serial_nb VARCHAR2(80), firmware_nb VARCHAR2(80), sensitivity BINARY_FLOAT, lddate DATE DEFAULT (SYSDATE), CONSTRAINT DaM00 PRIMARY KEY (data_id, board_nb, module_nb) ) TABLESPACE HT_DATA ; -- -- TABLE: Filamp -- CREATE TABLE Filamp( filamp_id NUMBER(8, 0) NOT NULL, name VARCHAR2(80), serial_nb VARCHAR2(80), ondate DATE NOT NULL, offdate DATE, nb_pchannel NUMBER(8, 0) NOT NULL, lddate DATE DEFAULT (SYSDATE), CONSTRAINT Filamp00 PRIMARY KEY (filamp_id) ) TABLESPACE HT_DATA ; -- -- TABLE: Filamp_PChannel -- CREATE TABLE Filamp_PChannel( filamp_id NUMBER(8, 0) NOT NULL, pchannel_nb NUMBER(8, 0) NOT NULL, gain BINARY_FLOAT, frequency BINARY_FLOAT, seqresp_id NUMBER(8, 0), lddate DATE DEFAULT (SYSDATE), CONSTRAINT FiP00 PRIMARY KEY (filamp_id, pchannel_nb) ) TABLESPACE HT_DATA ; -- -- TABLE: Filter -- CREATE TABLE Filter( filter_id NUMBER(8, 0) NOT NULL, gain BINARY_FLOAT, frequency BINARY_FLOAT, in_sp_rate BINARY_FLOAT, out_sp_rate BINARY_FLOAT, offset NUMBER(8, 0), delay BINARY_FLOAT, correction BINARY_FLOAT NOT NULL, seqresp_id NUMBER(8, 0), lddate DATE DEFAULT (SYSDATE), CONSTRAINT Fi00 PRIMARY KEY (filter_id) ) TABLESPACE HT_DATA ; -- -- TABLE: Filter_FIR -- CREATE TABLE Filter_FIR( fir_id NUMBER(8, 0) NOT NULL, name VARCHAR2(80), symmetry VARCHAR2(1) NOT NULL, gain BINARY_FLOAT, lddate DATE DEFAULT (SYSDATE), CONSTRAINT FFIR00 PRIMARY KEY (fir_id) ) TABLESPACE HT_DATA ; -- -- TABLE: Filter_FIR_Data -- CREATE TABLE Filter_FIR_Data( fir_id NUMBER(8, 0) NOT NULL, coeff_nb NUMBER(8, 0) NOT NULL, type VARCHAR2(1) NOT NULL, coefficient BINARY_FLOAT NOT NULL, error BINARY_FLOAT, CONSTRAINT FFD00 PRIMARY KEY (fir_id, coeff_nb) ) TABLESPACE HT_DATA ; -- -- TABLE: Filter_Sequence -- CREATE TABLE Filter_Sequence( seqfil_id NUMBER(8, 0) NOT NULL, name VARCHAR2(32) NOT NULL, nb_filter NUMBER(8, 0) NOT NULL, gain BINARY_FLOAT, frequency BINARY_FLOAT, lddate DATE DEFAULT (SYSDATE), CONSTRAINT FiS00 PRIMARY KEY (seqfil_id) ) TABLESPACE HT_DATA ; -- -- TABLE: Filter_Sequence_Data -- CREATE TABLE Filter_Sequence_Data( seqfil_id NUMBER(8, 0) NOT NULL, filter_nb NUMBER(8, 0) NOT NULL, filter_id NUMBER(8, 0) NOT NULL, CONSTRAINT FiSeD00 PRIMARY KEY (seqfil_id, filter_nb) ) TABLESPACE HT_DATA ; -- -- TABLE: Response -- CREATE TABLE Response( seqresp_id NUMBER(8, 0) NOT NULL, resp_nb NUMBER(8, 0) NOT NULL, resp_type VARCHAR2(1) NOT NULL, resp_id NUMBER(8, 0) NOT NULL, unit_in NUMBER(8, 0) NOT NULL, unit_out NUMBER(8, 0) NOT NULL, r_type VARCHAR2(1), lddate DATE DEFAULT (SYSDATE), CONSTRAINT Re00 PRIMARY KEY (seqresp_id, resp_nb) ) TABLESPACE HT_DATA ; -- -- TABLE: Response_HP -- CREATE TABLE Response_HP( hp_id NUMBER(8, 0) NOT NULL, filter_type VARCHAR2(2) NOT NULL, nb_pole NUMBER(8, 0) NOT NULL, corner_freq BINARY_FLOAT NOT NULL, damping_value BINARY_FLOAT NOT NULL, lddate DATE DEFAULT (SYSDATE), CONSTRAINT RHP00 PRIMARY KEY (hp_id) ) TABLESPACE HT_DATA ; -- -- TABLE: Response_LP -- CREATE TABLE Response_LP( lp_id NUMBER(8, 0) NOT NULL, filter_type VARCHAR2(2), nb_pole NUMBER(8, 0), corner_freq BINARY_FLOAT NOT NULL, damping_value BINARY_FLOAT NOT NULL, lddate DATE DEFAULT (SYSDATE), CONSTRAINT RLP00 PRIMARY KEY (lp_id) ) TABLESPACE HT_DATA ; -- -- TABLE: Response_PN -- CREATE TABLE Response_PN( pn_id NUMBER(8, 0) NOT NULL, name VARCHAR2(80), poly_type VARCHAR2(1) NOT NULL, lower_bound BINARY_FLOAT, upper_bound BINARY_FLOAT, max_error BINARY_FLOAT, nb_coeff NUMBER(8, 0), lddate DATE DEFAULT (SYSDATE), CONSTRAINT RPN00 PRIMARY KEY (pn_id) ) TABLESPACE HT_DATA ; -- -- TABLE: Response_PN_Data -- CREATE TABLE Response_PN_Data( pn_id NUMBER(8, 0) NOT NULL, pn_nb NUMBER(8, 0) NOT NULL, pn_value BINARY_FLOAT NOT NULL, CONSTRAINT RPND00 PRIMARY KEY (pn_id, pn_nb) ) TABLESPACE HT_DATA ; -- -- TABLE: Response_PZ -- CREATE TABLE Response_PZ( pz_id NUMBER(8, 0) NOT NULL, pz_nb NUMBER(8, 0) NOT NULL, type VARCHAR2(1) NOT NULL, r_value BINARY_FLOAT NOT NULL, r_error BINARY_FLOAT, i_value BINARY_FLOAT NOT NULL, i_error BINARY_FLOAT, lddate DATE DEFAULT (SYSDATE), CONSTRAINT RPZ00 PRIMARY KEY (pz_id, pz_nb) ) TABLESPACE HT_DATA ; -- -- TABLE: Sensor -- CREATE TABLE Sensor( sensor_id NUMBER(8, 0) NOT NULL, name VARCHAR2(80), serial_nb VARCHAR2(80), ondate DATE NOT NULL, offdate DATE, nb_component NUMBER(8, 0) NOT NULL, lddate DATE DEFAULT (SYSDATE), CONSTRAINT Sensor00 PRIMARY KEY (sensor_id) ) TABLESPACE HT_DATA ; -- -- TABLE: Sensor_Component -- CREATE TABLE Sensor_Component( sensor_id NUMBER(8, 0) NOT NULL, component_nb NUMBER(8, 0) NOT NULL, channel_comp VARCHAR2(2), component_type VARCHAR2(1), sensitivity BINARY_FLOAT NOT NULL, frequency BINARY_FLOAT, seqresp_id NUMBER(8, 0), lddate DATE DEFAULT (SYSDATE), CONSTRAINT SeC00 PRIMARY KEY (sensor_id, component_nb) ) TABLESPACE HT_DATA ; -- -- TABLE: Station -- CREATE TABLE Station( sta VARCHAR2(6) NOT NULL, net VARCHAR2(8) NOT NULL, lat BINARY_FLOAT, lon BINARY_FLOAT, elev BINARY_FLOAT, staname VARCHAR2(60), nb_sensor NUMBER(8, 0), nb_filamp NUMBER(8, 0), nb_digi NUMBER(8, 0) NOT NULL, nb_data NUMBER(8, 0) NOT NULL, datumhor VARCHAR2(8), datumver VARCHAR2(8), ondate DATE NOT NULL, offdate DATE, lddate DATE DEFAULT (SYSDATE), CONSTRAINT St00 PRIMARY KEY (sta, net, ondate) ) TABLESPACE HT_DATA ; -- -- TABLE: Station_Datalogger -- CREATE TABLE Station_Datalogger( sta VARCHAR2(6) NOT NULL, net VARCHAR2(8) NOT NULL, data_nb NUMBER(8, 0) NOT NULL, ondate DATE NOT NULL, data_id NUMBER(8, 0) NOT NULL, nb_pchannel NUMBER(8, 0) NOT NULL, offdate DATE, lddate DATE DEFAULT (SYSDATE), CONSTRAINT StDa00 PRIMARY KEY (sta, net, data_nb, ondate) ) TABLESPACE HT_DATA ; -- -- TABLE: Station_Datalogger_LChannel -- CREATE TABLE Station_Datalogger_LChannel( sta VARCHAR2(6) NOT NULL, net VARCHAR2(8) NOT NULL, data_nb NUMBER(8, 0) NOT NULL, pchannel_nb NUMBER(8, 0) NOT NULL, lchannel_nb NUMBER(8, 0) NOT NULL, ondate DATE NOT NULL, seqfil_id NUMBER(8, 0), seedchan VARCHAR2(3), channel VARCHAR2(8), channelsrc VARCHAR2(8), location VARCHAR2(2), rgain BINARY_FLOAT, rfrequency BINARY_FLOAT, samprate BINARY_FLOAT NOT NULL, clock_drift BINARY_FLOAT, flags VARCHAR2(27), data_format VARCHAR2(80) NOT NULL, comp_type NUMBER(8, 0) NOT NULL, unit_signal NUMBER(8, 0) NOT NULL, unit_calib NUMBER(8, 0) NOT NULL, block_size NUMBER(8, 0) NOT NULL, offdate DATE, remark VARCHAR2(30), lddate DATE DEFAULT (SYSDATE), CONSTRAINT StDaL00 PRIMARY KEY (sta, net, data_nb, pchannel_nb, lchannel_nb, ondate) ) TABLESPACE HT_DATA ; -- -- TABLE: Station_Datalogger_PChannel -- CREATE TABLE Station_Datalogger_PChannel( sta VARCHAR2(6) NOT NULL, net VARCHAR2(8) NOT NULL, data_nb NUMBER(8, 0) NOT NULL, pchannel_nb NUMBER(8, 0) NOT NULL, ondate DATE NOT NULL, board_type VARCHAR2(1) NOT NULL, channel_type VARCHAR2(1) NOT NULL, seed_io VARCHAR2(2) NOT NULL, nb_lchannel NUMBER(8, 0) NOT NULL, offdate DATE, lddate DATE DEFAULT (SYSDATE), CONSTRAINT StDaP00 PRIMARY KEY (sta, net, data_nb, pchannel_nb, ondate) ) TABLESPACE HT_DATA ; -- -- TABLE: Station_Digitizer -- CREATE TABLE Station_Digitizer( sta VARCHAR2(6) NOT NULL, net VARCHAR2(8) NOT NULL, digi_nb NUMBER(8, 0) NOT NULL, ondate DATE NOT NULL, serial_nb VARCHAR2(80) NOT NULL, nb_pri_pchannel NUMBER(8, 0) NOT NULL, nb_aux_pchannel NUMBER(8, 0) NOT NULL, offdate DATE, lddate DATE DEFAULT (SYSDATE), CONSTRAINT StDi00 PRIMARY KEY (sta, net, digi_nb, ondate) ) TABLESPACE HT_DATA ; -- -- TABLE: Station_Digitizer_PChannel -- CREATE TABLE Station_Digitizer_PChannel( sta VARCHAR2(6) NOT NULL, net VARCHAR2(8) NOT NULL, digi_nb NUMBER(8, 0) NOT NULL, pchannel_nb NUMBER(8, 0) NOT NULL, ondate DATE NOT NULL, data_nb NUMBER(8, 0) NOT NULL, data_pchannel NUMBER(8, 0) NOT NULL, digi_type VARCHAR2(3) NOT NULL, digi_polarity VARCHAR2(1) NOT NULL, digi_channel NUMBER(8, 0) NOT NULL, offdate DATE, lddate DATE DEFAULT (SYSDATE), CONSTRAINT StDiP00 PRIMARY KEY (sta, net, digi_nb, pchannel_nb, ondate) ) TABLESPACE HT_DATA ; -- -- TABLE: Station_Filamp -- CREATE TABLE Station_Filamp( sta VARCHAR2(6) NOT NULL, net VARCHAR2(8) NOT NULL, filamp_nb NUMBER(8, 0) NOT NULL, ondate DATE NOT NULL, filamp_id NUMBER(8, 0) NOT NULL, nb_pchannel NUMBER(8, 0) NOT NULL, offdate DATE, lddate DATE DEFAULT (SYSDATE), CONSTRAINT StFi00 PRIMARY KEY (sta, net, filamp_nb, ondate) ) TABLESPACE HT_DATA ; -- -- TABLE: Station_Filamp_PChannel -- CREATE TABLE Station_Filamp_PChannel( sta VARCHAR2(6) NOT NULL, net VARCHAR2(8) NOT NULL, filamp_nb NUMBER(8, 0) NOT NULL, pchannel_nb NUMBER(8, 0) NOT NULL, ondate DATE NOT NULL, next_hard_type VARCHAR2(1) NOT NULL, next_hard_nb NUMBER(8, 0) NOT NULL, next_hard_pchannel NUMBER(8, 0) NOT NULL, offdate DATE, lddate DATE DEFAULT (SYSDATE), CONSTRAINT StFiP00 PRIMARY KEY (sta, net, filamp_nb, pchannel_nb, ondate) ) TABLESPACE HT_DATA ; -- -- TABLE: Station_Sensor -- CREATE TABLE Station_Sensor( sta VARCHAR2(6) NOT NULL, net VARCHAR2(8) NOT NULL, sensor_nb NUMBER(8, 0) NOT NULL, ondate DATE NOT NULL, sensor_id NUMBER(8, 0) NOT NULL, lat BINARY_FLOAT, lon BINARY_FLOAT, elev BINARY_FLOAT, edepth BINARY_FLOAT, nb_component NUMBER(8, 0) NOT NULL, datumhor VARCHAR2(8), datumver VARCHAR2(8), offdate DATE, lddate DATE DEFAULT (SYSDATE), CONSTRAINT StSe00 PRIMARY KEY (sta, net, sensor_nb, ondate) ) TABLESPACE HT_DATA ; -- -- TABLE: Station_Sensor_Component -- CREATE TABLE Station_Sensor_Component( sta VARCHAR2(6) NOT NULL, net VARCHAR2(8) NOT NULL, sensor_nb NUMBER(8, 0) NOT NULL, component_nb NUMBER(8, 0) NOT NULL, ondate DATE NOT NULL, next_hard_type VARCHAR2(1) NOT NULL, next_hard_nb NUMBER(8, 0) NOT NULL, next_hard_pchannel NUMBER(8, 0) NOT NULL, azimuth BINARY_FLOAT, dip BINARY_FLOAT, offdate DATE, lddate DATE DEFAULT (SYSDATE), CONSTRAINT StSeC00 PRIMARY KEY (sta, net, sensor_nb, component_nb, ondate) ) TABLESPACE HT_DATA ; -- -- TABLE: Datalogger_Board -- ALTER TABLE Datalogger_Board ADD CONSTRAINT Dat_Boa_Dat FOREIGN KEY (data_id) REFERENCES Datalogger(data_id) ; -- -- TABLE: Datalogger_Module -- ALTER TABLE Datalogger_Module ADD CONSTRAINT Dat_Mod_Dat_Boa FOREIGN KEY (data_id, board_nb) REFERENCES Datalogger_Board(data_id, board_nb) ; -- -- TABLE: Filamp_PChannel -- ALTER TABLE Filamp_PChannel ADD CONSTRAINT Fil_PCh_Fil FOREIGN KEY (filamp_id) REFERENCES Filamp(filamp_id) ; -- -- TABLE: Filter_FIR_Data -- ALTER TABLE Filter_FIR_Data ADD CONSTRAINT Fil_FIR_Dat_Fil_FIR FOREIGN KEY (fir_id) REFERENCES Filter_FIR(fir_id) ; -- -- TABLE: Filter_Sequence_Data -- ALTER TABLE Filter_Sequence_Data ADD CONSTRAINT Fil_Seq_Dat_Fil FOREIGN KEY (filter_id) REFERENCES Filter(filter_id) ; ALTER TABLE Filter_Sequence_Data ADD CONSTRAINT Fil_Seq_Dat_Fil_Seq FOREIGN KEY (seqfil_id) REFERENCES Filter_Sequence(seqfil_id) ; -- -- TABLE: Response -- ALTER TABLE Response ADD CONSTRAINT Res_Fil_FIR FOREIGN KEY (resp_id) REFERENCES Filter_FIR(fir_id) ; ALTER TABLE Response ADD CONSTRAINT Res_Res_HP FOREIGN KEY (resp_id) REFERENCES Response_HP(hp_id) ; ALTER TABLE Response ADD CONSTRAINT Res_Res_LP FOREIGN KEY (resp_id) REFERENCES Response_LP(lp_id) ; ALTER TABLE Response ADD CONSTRAINT Res_Res_PN FOREIGN KEY (resp_id) REFERENCES Response_PN(pn_id) ; -- -- TABLE: Response_PN_Data -- ALTER TABLE Response_PN_Data ADD CONSTRAINT Res_PN_Dat_Res_PN FOREIGN KEY (pn_id) REFERENCES Response_PN(pn_id) ; -- -- TABLE: Sensor_Component -- ALTER TABLE Sensor_Component ADD CONSTRAINT Sen_Com_Sen FOREIGN KEY (sensor_id) REFERENCES Sensor(sensor_id) ; -- -- TABLE: Station_Datalogger -- ALTER TABLE Station_Datalogger ADD CONSTRAINT Sta_Dat_Dat FOREIGN KEY (data_id) REFERENCES Datalogger(data_id) ; ALTER TABLE Station_Datalogger ADD CONSTRAINT Sta_Dat_Sta FOREIGN KEY (sta, net, ondate) REFERENCES Station(sta, net, ondate) ; -- -- TABLE: Station_Datalogger_LChannel -- ALTER TABLE Station_Datalogger_LChannel ADD CONSTRAINT Sta_Dat_LCh_Fil_Seq FOREIGN KEY (seqfil_id) REFERENCES Filter_Sequence(seqfil_id) ; ALTER TABLE Station_Datalogger_LChannel ADD CONSTRAINT Sta_Dat_LCh_Sta_Dat_PCh FOREIGN KEY (sta, net, data_nb, pchannel_nb, ondate) REFERENCES Station_Datalogger_PChannel(sta, net, data_nb, pchannel_nb, ondate) ; -- -- TABLE: Station_Datalogger_PChannel -- ALTER TABLE Station_Datalogger_PChannel ADD CONSTRAINT Sta_Dat_PCh_Sta_Dat FOREIGN KEY (sta, net, data_nb, ondate) REFERENCES Station_Datalogger(sta, net, data_nb, ondate) ; -- -- TABLE: Station_Digitizer -- ALTER TABLE Station_Digitizer ADD CONSTRAINT Sta_Dig_Sta FOREIGN KEY (sta, net, ondate) REFERENCES Station(sta, net, ondate) ; -- -- TABLE: Station_Digitizer_PChannel -- ALTER TABLE Station_Digitizer_PChannel ADD CONSTRAINT Sta_Dig_PCh_Sta_Dig FOREIGN KEY (sta, net, digi_nb, ondate) REFERENCES Station_Digitizer(sta, net, digi_nb, ondate) ; -- -- TABLE: Station_Filamp -- ALTER TABLE Station_Filamp ADD CONSTRAINT Sta_Fil_Fil FOREIGN KEY (filamp_id) REFERENCES Filamp(filamp_id) ; ALTER TABLE Station_Filamp ADD CONSTRAINT Sta_Fil_Sta FOREIGN KEY (sta, net, ondate) REFERENCES Station(sta, net, ondate) ; -- -- TABLE: Station_Filamp_PChannel -- ALTER TABLE Station_Filamp_PChannel ADD CONSTRAINT Sta_Fil_PCh_Sta_Fil FOREIGN KEY (sta, net, filamp_nb, ondate) REFERENCES Station_Filamp(sta, net, filamp_nb, ondate) ; -- -- TABLE: Station_Sensor -- ALTER TABLE Station_Sensor ADD CONSTRAINT Sta_Sen_Sen FOREIGN KEY (sensor_id) REFERENCES Sensor(sensor_id) ; ALTER TABLE Station_Sensor ADD CONSTRAINT Sta_Sen_Sta FOREIGN KEY (sta, net, ondate) REFERENCES Station(sta, net, ondate) ; -- -- TABLE: Station_Sensor_Component -- ALTER TABLE Station_Sensor_Component ADD CONSTRAINT Sta_Sen_Com_Sta_Sen FOREIGN KEY (sta, net, sensor_nb, ondate) REFERENCES Station_Sensor(sta, net, sensor_nb, ondate) ;