"Datalogger to Datalogger_Board"
RelationshipType Identifying
Relationship Name Dat_Boa_Dat
Parent Table Datalogger
Child Table Datalogger_Board
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
data_id data_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Datalogger_Board to Datalogger_Module"
RelationshipType Identifying
Relationship Name Dat_Mod_Dat_Boa
Parent Table Datalogger_Board
Child Table Datalogger_Module
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
data_id,board_nb data_id,board_nb

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Filamp to Filamp_PChannel"
RelationshipType Identifying
Relationship Name Fil_PCh_Fil
Parent Table Filamp
Child Table Filamp_PChannel
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
filamp_id filamp_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Filter_FIR to Filter_FIR_Data"
RelationshipType Identifying
Relationship Name Fil_FIR_Dat_Fil_FIR
Parent Table Filter_FIR
Child Table Filter_FIR_Data
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
fir_id fir_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Filter to Filter_Sequence_Data"
RelationshipType Non-Identifying
Relationship Name Fil_Seq_Dat_Fil
Parent Table Filter
Child Table Filter_Sequence_Data
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
filter_id filter_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Filter_Sequence to Filter_Sequence_Data"
RelationshipType Identifying
Relationship Name Fil_Seq_Dat_Fil_Seq
Parent Table Filter_Sequence
Child Table Filter_Sequence_Data
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
seqfil_id seqfil_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Filter_FIR to Response"
RelationshipType Non-Identifying
Relationship Name Res_Fil_FIR
Parent Table Filter_FIR
Child Table Response
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
fir_id resp_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Response_HP to Response"
RelationshipType Non-Identifying
Relationship Name Res_Res_HP
Parent Table Response_HP
Child Table Response
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
hp_id resp_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Response_LP to Response"
RelationshipType Non-Identifying
Relationship Name Res_Res_LP
Parent Table Response_LP
Child Table Response
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
lp_id resp_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Response_PN to Response"
RelationshipType Non-Identifying
Relationship Name Res_Res_PN
Parent Table Response_PN
Child Table Response
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
pn_id resp_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Response_PN to Response_PN_Data"
RelationshipType Identifying
Relationship Name Res_PN_Dat_Res_PN
Parent Table Response_PN
Child Table Response_PN_Data
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
pn_id pn_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Sensor to Sensor_Component"
RelationshipType Identifying
Relationship Name Sen_Com_Sen
Parent Table Sensor
Child Table Sensor_Component
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
sensor_id sensor_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Datalogger to Station_Datalogger"
RelationshipType Non-Identifying
Relationship Name Sta_Dat_Dat
Parent Table Datalogger
Child Table Station_Datalogger
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
data_id data_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Station to Station_Datalogger"
RelationshipType Identifying
Relationship Name Sta_Dat_Sta
Parent Table Station
Child Table Station_Datalogger
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
sta,net,ondate sta,net,ondate

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Filter_Sequence to Station_Datalogger_LChannel"
RelationshipType Non-Identifying
Relationship Name Sta_Dat_LCh_Fil_Seq
Parent Table Filter_Sequence
Child Table Station_Datalogger_LChannel
Cardinality Zero or One to Zero or More
Existence Optional
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
seqfil_id seqfil_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Station_Datalogger_PChannel to Station_Datalogger_LChannel"
RelationshipType Identifying
Relationship Name Sta_Dat_LCh_Sta_Dat_PCh
Parent Table Station_Datalogger_PChannel
Child Table Station_Datalogger_LChannel
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
sta,net,data_nb,pchannel_nb,ondate sta,net,data_nb,pchannel_nb,ondate

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Station_Datalogger to Station_Datalogger_PChannel"
RelationshipType Identifying
Relationship Name Sta_Dat_PCh_Sta_Dat
Parent Table Station_Datalogger
Child Table Station_Datalogger_PChannel
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
sta,net,data_nb,ondate sta,net,data_nb,ondate

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Station to Station_Digitizer"
RelationshipType Identifying
Relationship Name Sta_Dig_Sta
Parent Table Station
Child Table Station_Digitizer
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
sta,net,ondate sta,net,ondate

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Station_Digitizer to Station_Digitizer_PChannel"
RelationshipType Identifying
Relationship Name Sta_Dig_PCh_Sta_Dig
Parent Table Station_Digitizer
Child Table Station_Digitizer_PChannel
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
sta,net,digi_nb,ondate sta,net,digi_nb,ondate

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Filamp to Station_Filamp"
RelationshipType Non-Identifying
Relationship Name Sta_Fil_Fil
Parent Table Filamp
Child Table Station_Filamp
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
filamp_id filamp_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Station to Station_Filamp"
RelationshipType Identifying
Relationship Name Sta_Fil_Sta
Parent Table Station
Child Table Station_Filamp
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
sta,net,ondate sta,net,ondate

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Station_Filamp to Station_Filamp_PChannel"
RelationshipType Identifying
Relationship Name Sta_Fil_PCh_Sta_Fil
Parent Table Station_Filamp
Child Table Station_Filamp_PChannel
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
sta,net,filamp_nb,ondate sta,net,filamp_nb,ondate

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Sensor to Station_Sensor"
RelationshipType Non-Identifying
Relationship Name Sta_Sen_Sen
Parent Table Sensor
Child Table Station_Sensor
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
sensor_id sensor_id

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Station to Station_Sensor"
RelationshipType Identifying
Relationship Name Sta_Sen_Sta
Parent Table Station
Child Table Station_Sensor
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
sta,net,ondate sta,net,ondate

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description


"Station_Sensor to Station_Sensor_Component"
RelationshipType Identifying
Relationship Name Sta_Sen_Com_Sta_Sen
Parent Table Station_Sensor
Child Table Station_Sensor_Component
Cardinality One To Zero or More
Existence Mandatory
Propagated Key Primary Key

Relationship Description
Verb Sentence
Inverse Verb Sentence
Definition

Foreign Keys
Parent Key Child Key
sta,net,sensor_nb,ondate sta,net,sensor_nb,ondate

Trigger Templates
ParentInsert None
ParentUpdate None
ParentDelete None
ChildInsert None
ChildUpdate None
ChildDelete None

Attachments
Name Datatype Value Override Default Value Description