Logical Design Dictionary

 NCEDC/TriNet Hardware Tracking
Version 1.5.2

Berkeley Seismological Laboratory
Stephane Zuzlewski
Last Modified 11/20/2002
Copyright 2002 NCEDC/TriNet

NCEDC/TriNet Hardware Tracking

Diagram Name	NCEDC/TriNet Hardware Tracking	
Description	NCEDC/TriNet Hardware Tracking Schema ER Diagram	
Author	Stephane Zuzlewski	
Company	Berkeley Seismological Laboratory	
Version	1.5.2	
Copyright	NCEDC/TriNet	
Copyright Year	2002	

Logical

Model Name	Logical	
Database Platform	Logical	

Entity Summary Report

Entity Name	Entity Type	Primary Keys	 # Attr	
Datalogger	Independent	data_id	12	
Datalogger_Board	Dependent	data_id,board_nb	6	
Datalogger_Module	Dependent	data_id,board_nb,module_nb	7	
Filamp	Independent	filamp_id	7	
Filamp_PChannel	Dependent	filamp_id,pchannel_nb	6	
Filter	Independent	filter_id	10	
Filter_FIR	Independent	fir_id	5	
Filter_FIR_Data	Dependent	fir_id,coeff_nb	5	
Filter_Sequence	Independent	seqfil_id	6	
Filter_Sequence_Data	Dependent	seqfil_id,filter_nb	3	
Response	Independent	seqresp_id,resp_nb	8	
Response_HP	Independent	hp_id	6	
Response_LP	Independent	lp_id	6	
Response_PN	Independent	pn_id	8	
Response_PN_Data	Dependent	pn_id,pn_nb	3	
Response_PZ	Independent	pz_id,pz_nb	8	
Sensor	Independent	sensor_id	7	
Sensor_Component	Dependent	sensor_id,component_nb	8	
Station	Independent	sta,net,ondate	15	
Station_Datalogger	Dependent	sta,net,data_nb,ondate	8	
Station_Datalogger_LChannel	Dependent	sta,net,data_nb,pchannel_nb,lchannel_nb,ondate	24	
Station_Datalogger_PChannel	Dependent	sta,net,data_nb,pchannel_nb,ondate	11	
Station_Digitizer	Dependent	sta,net,digi_nb,ondate	9	
Station_Digitizer_PChannel	Dependent	sta,net,digi_nb,pchannel_nb,ondate	12	
Station_Filamp	Dependent	sta,net,filamp_nb,ondate	8	
Station_Filamp_PChannel	Dependent	sta,net,filamp_nb,pchannel_nb,ondate	10	
Station_Sensor	Dependent	sta,net,sensor_nb,ondate	14	
Station_Sensor_Component	Dependent	sta,net,sensor_nb,component_nb,ondate	12	

Entity Detail Reports

Datalogger

Entity Name	Datalogger	
Owner Name		
Entity Type	Independent	
Primary Keys	data_id	
Definition	Summary information on a datalogger	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
data_id		NUMERIC(8, 0)	N	Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	 
data_type		VARCHAR(80)	Y	This attribute represents a datalogger type	 
serial_nb		VARCHAR(80)	Y	This attribute denotes a serial number of a datalogger	 
firmware_nb		VARCHAR(80)	Y	This attribute describes the firmware number of a datalogger	 
software		VARCHAR(80)	Y	Datalogger’s software (mshear, ushear, ...)	 
software_nb		VARCHAR(80)	Y	Datalogger’s software version number	 
ondate		DATE	N	This attribute denotes the start date	 
offdate		DATE	Y	This attribute denotes the end date	 
nb_board		NUMERIC(8, 0)	Y	This attribute denotes the number of boards of a datalogger	 
word_32		NUMERIC(8, 0)	N	The swap order in which 32-bit quantities are specified in the data headers	 
word_16		NUMERIC(8, 0)	N	16-bit quantity byte swapping order, for the data headers only	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Da01	nb_board >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Datalogger	Datalogger_Board	Identifying	Dat_Boa_Dat	 
Datalogger	Station_Datalogger	Non-Identifying	Sta_Dat_Dat	 

data_id

Attribute Name	data_id	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

data_type

Attribute Name	data_type	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents a datalogger type	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

serial_nb

Attribute Name	serial_nb	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a serial number of a datalogger	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

firmware_nb

Attribute Name	firmware_nb	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute describes the firmware number of a datalogger	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

software

Attribute Name	software	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Datalogger’s software (mshear, ushear, ...)	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

software_nb

Attribute Name	software_nb	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Datalogger’s software version number	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

nb_board

Attribute Name	nb_board	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of boards of a datalogger	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	

word_32

Attribute Name	word_32	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The swap order in which 32-bit quantities are specified in the data headers	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

word_16

Attribute Name	word_16	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

16-bit quantity byte swapping order, for the data headers only	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Datalogger_Board

Entity Name	Datalogger_Board	
Owner Name		
Entity Type	Dependent	
Primary Keys	data_id,board_nb	
Definition	Board of a datalogger	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
data_id		NUMERIC(8, 0)	N	Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	 
board_nb		NUMERIC(8, 0)	N	This attribute denotes the number of boards of a datalogger	 
serial_nb		VARCHAR(80)	Y	This attribute denotes a serial number of a datalogger board	 
nb_module		NUMERIC(8, 0)	N	This attribute denotes the number of modules of a datalogger’s board	 
firmware_nb		VARCHAR(80)	Y	This attribute describes the firmware number of a datalogger	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	DaB01	board_nb >= 1	 
	Check	DaB02	nb_module >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Datalogger	Datalogger_Board	Identifying	Dat_Boa_Dat	 
Station_Digitizer	Datalogger_Board	Non-Specific	Sta_Dig_Dat_Boa	 
Datalogger_Board	Datalogger_Module	Identifying	Dat_Mod_Dat_Boa	 

data_id

Attribute Name	data_id	Entity Name	Datalogger_Board	
Logical Role Name	data_id	
Role Name	data_id	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Datalogger	
Definition 

Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

board_nb

Attribute Name	board_nb	Entity Name	Datalogger_Board	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of boards of a datalogger	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

serial_nb

Attribute Name	serial_nb	Entity Name	Datalogger_Board	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a serial number of a datalogger board	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

nb_module

Attribute Name	nb_module	Entity Name	Datalogger_Board	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of modules of a datalogger’s board	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

firmware_nb

Attribute Name	firmware_nb	Entity Name	Datalogger_Board	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute describes the firmware number of a datalogger	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Datalogger_Board	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Datalogger_Module

Entity Name	Datalogger_Module	
Owner Name		
Entity Type	Dependent	
Primary Keys	data_id,board_nb,module_nb	
Definition	Module of a datalogger’s board	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
data_id		NUMERIC(8, 0)	N	Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	 
board_nb		NUMERIC(8, 0)	N	This attribute denotes the number of boards of a datalogger	 
module_nb		NUMERIC(8, 0)	N	This attribute represents the module number of a datalogger’s board	 
serial_nb		VARCHAR(80)	Y	This attribute denotes a serial number of a datalogger module	 
firmware_nb		VARCHAR(80)	Y	This attribute describes the firmware number of a datalogger	 
sensitivity		FLOAT	Y	This attribute denotes the sensitivity (Sd) for a sensor or a digitizer	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	DaM01	board_nb >= 1	 
	Check	DaM02	module_nb >= 1	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Datalogger_Board	Datalogger_Module	Identifying	Dat_Mod_Dat_Boa	 

data_id

Attribute Name	data_id	Entity Name	Datalogger_Module	
Logical Role Name	data_id	
Role Name	data_id	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Datalogger_Board	
Definition 

Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

board_nb

Attribute Name	board_nb	Entity Name	Datalogger_Module	
Logical Role Name	board_nb	
Role Name	board_nb	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Datalogger_Board	
Definition 

This attribute denotes the number of boards of a datalogger	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

module_nb

Attribute Name	module_nb	Entity Name	Datalogger_Module	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the module number of a datalogger’s board	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

serial_nb

Attribute Name	serial_nb	Entity Name	Datalogger_Module	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a serial number of a datalogger module	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

firmware_nb

Attribute Name	firmware_nb	Entity Name	Datalogger_Module	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute describes the firmware number of a datalogger	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

sensitivity

Attribute Name	sensitivity	Entity Name	Datalogger_Module	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the sensitivity (Sd) for a sensor or a digitizer	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Datalogger_Module	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Filamp

Entity Name	Filamp	
Owner Name		
Entity Type	Independent	
Primary Keys	filamp_id	
Definition	Summary information on a filter-amplifier	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
filamp_id		NUMERIC(8, 0)	N	Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	 
name		VARCHAR(80)	Y	This attribute denotes a descriptive name for a filter-amplifier	 
serial_nb		VARCHAR(80)	Y	This attribute denotes a serial number of a filter-amplifier	 
ondate		DATE	N	This attribute denotes the start date	 
offdate		DATE	Y	This attribute denotes the end date	 
nb_pchannel		NUMERIC(8, 0)	N	This attribute denotes the number of physical channels of a datalogger	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Filamp01	nb_pchannel >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Filamp	Filamp_PChannel	Identifying	Fil_PCh_Fil	 
Filamp	Station_Filamp	Non-Identifying	Sta_Fil_Fil	 

filamp_id

Attribute Name	filamp_id	Entity Name	Filamp	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

name

Attribute Name	name	Entity Name	Filamp	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a descriptive name for a filter-amplifier	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

serial_nb

Attribute Name	serial_nb	Entity Name	Filamp	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a serial number of a filter-amplifier	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Filamp	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Filamp	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

nb_pchannel

Attribute Name	nb_pchannel	Entity Name	Filamp	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of physical channels of a datalogger	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Filamp	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Filamp_PChannel

Entity Name	Filamp_PChannel	
Owner Name		
Entity Type	Dependent	
Primary Keys	filamp_id,pchannel_nb	
Definition	Physical channel of a filter-amplifier	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
filamp_id		NUMERIC(8, 0)	N	Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	 
pchannel_nb		NUMERIC(8, 0)	N	This attribute denotes a physical channel	 
gain		FLOAT	Y	This attribute denotes the gain	 
frequency		FLOAT	Y	The frequency (fs) at which the value in sensitivity/gain is correct	 
seqresp_id		NUMERIC(8, 0)	Y	Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	FiP01	pchannel_nb >= 1	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Filamp	Filamp_PChannel	Identifying	Fil_PCh_Fil	 
Response	Filamp_PChannel	Non-Specific	Fil_PCh_Res	 

filamp_id

Attribute Name	filamp_id	Entity Name	Filamp_PChannel	
Logical Role Name	filamp_id	
Role Name	filamp_id	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Filamp	
Definition 

Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

pchannel_nb

Attribute Name	pchannel_nb	Entity Name	Filamp_PChannel	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a physical channel	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

gain

Attribute Name	gain	Entity Name	Filamp_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the gain	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

frequency

Attribute Name	frequency	Entity Name	Filamp_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The frequency (fs) at which the value in sensitivity/gain is correct	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

seqresp_id

Attribute Name	seqresp_id	Entity Name	Filamp_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Filamp_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Filter

Entity Name	Filter	
Owner Name		
Entity Type	Independent	
Primary Keys	filter_id	
Definition	Summary information on a filter	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
filter_id		NUMERIC(8, 0)	N	Filter identifier. Each filter is assigned a unique integer which identifies it in a database	 
gain		FLOAT	Y	This attribute denotes the gain	 
frequency		FLOAT	Y	The frequency (fs) at which the value in sensitivity/gain is correct	 
in_sp_rate		FLOAT	Y	Sampling rate. This attribute is the input sample rate in samples/second	 
out_sp_rate		FLOAT	Y	Sampling rate. This attribute is the output sample rate in samples/second	 
offset		NUMERIC(8, 0)	Y	This field determines which sample is chosen for use. The value of this field has to be greater than or equal to zero, but less than the decimation factor	 
delay		FLOAT	Y	The estimated pure delay for the filter	 
correction		FLOAT	N	The time shift applied to the time tag due to delay at this stage of the filter; a negative number indicating the amount of time added to the former time tag. The actual delay is difficult to estimate, and the correction applied neglects dispersion. This field allows to know how much correction was used, in case a more accurate correction is to be applied later. A zero here implies no correction was done	 
seqresp_id		NUMERIC(8, 0)	Y	Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Fi01	frequency >= 0.0	 
	Check	Fi02	in_sp_rate > 0.0	 
	Check	Fi03	out_sp_rate > 0.0	 
	Check	Fi04	offset >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Response	Filter	Non-Specific	Fil_Res	 
Filter	Filter_Sequence_Data	Non-Identifying	Fil_Seq_Dat_Fil	 

filter_id

Attribute Name	filter_id	Entity Name	Filter	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Filter identifier. Each filter is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

gain

Attribute Name	gain	Entity Name	Filter	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the gain	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

frequency

Attribute Name	frequency	Entity Name	Filter	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The frequency (fs) at which the value in sensitivity/gain is correct	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

in_sp_rate

Attribute Name	in_sp_rate	Entity Name	Filter	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Sampling rate. This attribute is the input sample rate in samples/second	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

out_sp_rate

Attribute Name	out_sp_rate	Entity Name	Filter	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Sampling rate. This attribute is the output sample rate in samples/second	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

offset

Attribute Name	offset	Entity Name	Filter	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This field determines which sample is chosen for use. The value of this field has to be greater than or equal to zero, but less than the decimation factor	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	

delay

Attribute Name	delay	Entity Name	Filter	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The estimated pure delay for the filter	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

correction

Attribute Name	correction	Entity Name	Filter	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The time shift applied to the time tag due to delay at this stage of the filter; a negative number indicating the amount of time added to the former time tag. The actual delay is difficult to estimate, and the correction applied neglects dispersion. This field allows to know how much correction was used, in case a more accurate correction is to be applied later. A zero here implies no correction was done	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

seqresp_id

Attribute Name	seqresp_id	Entity Name	Filter	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Filter	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Filter_FIR

Entity Name	Filter_FIR	
Owner Name		
Entity Type	Independent	
Primary Keys	fir_id	
Definition	Summary information on a FIR filter	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
fir_id		NUMERIC(8, 0)	N	FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database	 
name		VARCHAR(80)	Y	This attribute denotes a descriptive name for a FIR filter	 
symmetry		VARCHAR(1)	N	This attribute denotes the eventual symmetry of a response	 
gain		FLOAT	Y	This attribute denotes the gain	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	FFIR01	symmetry IN ('E','O','N')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Filter_FIR	Filter_FIR_Data	Identifying	Fil_FIR_Dat_Fil_FIR	 
Filter_FIR	Response	Non-Identifying	Res_Fil_FIR	 

fir_id

Attribute Name	fir_id	Entity Name	Filter_FIR	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

name

Attribute Name	name	Entity Name	Filter_FIR	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a descriptive name for a FIR filter	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

symmetry

Attribute Name	symmetry	Entity Name	Filter_FIR	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the eventual symmetry of a response	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	

gain

Attribute Name	gain	Entity Name	Filter_FIR	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the gain	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Filter_FIR	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Filter_FIR_Data

Entity Name	Filter_FIR_Data	
Owner Name		
Entity Type	Dependent	
Primary Keys	fir_id,coeff_nb	
Definition	Coefficients of a FIR filter	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
fir_id		NUMERIC(8, 0)	N	FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database	 
coeff_nb		NUMERIC(8, 0)	N	The numerator/denominator number	 
type		VARCHAR(1)	N	This attribute denotes whether a value is associated with a numerator/denominator	 
coefficient		FLOAT	N	The numerator/denominator coefficient value	 
error		FLOAT	Y	This attributes denotes the numerator/denominator error	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	FFD01	coeff_nb >= 1	 
	Check	FFD02	type IN ('N','D')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Filter_FIR	Filter_FIR_Data	Identifying	Fil_FIR_Dat_Fil_FIR	 

fir_id

Attribute Name	fir_id	Entity Name	Filter_FIR_Data	
Logical Role Name	fir_id	
Role Name	fir_id	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Filter_FIR	
Definition 

FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

coeff_nb

Attribute Name	coeff_nb	Entity Name	Filter_FIR_Data	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

The numerator/denominator number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

type

Attribute Name	type	Entity Name	Filter_FIR_Data	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes whether a value is associated with a numerator/denominator	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	

coefficient

Attribute Name	coefficient	Entity Name	Filter_FIR_Data	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The numerator/denominator coefficient value	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

error

Attribute Name	error	Entity Name	Filter_FIR_Data	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attributes denotes the numerator/denominator error	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

Filter_Sequence

Entity Name	Filter_Sequence	
Owner Name		
Entity Type	Independent	
Primary Keys	seqfil_id	
Definition	Summary information on a sequence of filters	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
seqfil_id		NUMERIC(8, 0)	N	Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	 
name		VARCHAR(32)	N	This attribute denotes a descriptive name for a chain of filters	 
nb_filter		NUMERIC(8, 0)	N	This attribute denotes the number of filters of a sequence	 
gain		FLOAT	Y	This attribute denotes the gain	 
frequency		FLOAT	Y	The frequency (fs) at which the value in sensitivity/gain is correct	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	FiS01	frequency >= 0.0	 
	Check	FiS02	nb_filter >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Filter_Sequence	Filter_Sequence_Data	Identifying	Fil_Seq_Dat_Fil_Seq	 
Filter_Sequence	Station_Datalogger_LChannel	Non-Identifying	Sta_Dat_LCh_Fil_Seq	 

seqfil_id

Attribute Name	seqfil_id	Entity Name	Filter_Sequence	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

name

Attribute Name	name	Entity Name	Filter_Sequence	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a descriptive name for a chain of filters	
Logical Column Properties 

Data Type	VARCHAR(32)	Width	32	Scale		
Nullable	NO	
Identity	NO	

nb_filter

Attribute Name	nb_filter	Entity Name	Filter_Sequence	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of filters of a sequence	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

gain

Attribute Name	gain	Entity Name	Filter_Sequence	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the gain	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

frequency

Attribute Name	frequency	Entity Name	Filter_Sequence	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The frequency (fs) at which the value in sensitivity/gain is correct	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Filter_Sequence	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Filter_Sequence_Data

Entity Name	Filter_Sequence_Data	
Owner Name		
Entity Type	Dependent	
Primary Keys	seqfil_id,filter_nb	
Definition	Filter of a sequence	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
seqfil_id		NUMERIC(8, 0)	N	Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	 
filter_nb		NUMERIC(8, 0)	N	This attribute represents the filter number in a sequence	 
filter_id		NUMERIC(8, 0)	N	Filter identifier. Each filter is assigned a unique integer which identifies it in a database	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	FiSeD01	filter_nb >= 1	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Filter	Filter_Sequence_Data	Non-Identifying	Fil_Seq_Dat_Fil	 
Filter_Sequence	Filter_Sequence_Data	Identifying	Fil_Seq_Dat_Fil_Seq	 

seqfil_id

Attribute Name	seqfil_id	Entity Name	Filter_Sequence_Data	
Logical Role Name	seqfil_id	
Role Name	seqfil_id	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Filter_Sequence	
Definition 

Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

filter_nb

Attribute Name	filter_nb	Entity Name	Filter_Sequence_Data	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the filter number in a sequence	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

filter_id

Attribute Name	filter_id	Entity Name	Filter_Sequence_Data	
Logical Role Name	filter_id	
Role Name	filter_id	
Primary Key	NO	
Foreign Key	YES	Parent Entity	Filter	
Definition 

Filter identifier. Each filter is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

Response

Entity Name	Response	
Owner Name		
Entity Type	Independent	
Primary Keys	seqresp_id,resp_nb	
Definition	Summary information on a sequence of responses	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
seqresp_id		NUMERIC(8, 0)	N	Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	 
resp_nb		NUMERIC(8, 0)	N	This attribute denotes the response number of a sequence	 
resp_type		VARCHAR(1)	N	This attribute denotes the response type	 
resp_id		NUMERIC(8, 0)	N	Response identifier. Each response is assigned a unique integer which identifies it in a database	 
unit_in		NUMERIC(8, 0)	N	A unit lookup key that refers to the Units Abbreviation Dictionary for the units of the incoming to this stage of the filter. This signal will usually be ground motion, volts, or counts, depending on where it is in the filter system	 
unit_out		NUMERIC(8, 0)	N	A unit lookup key that refers to the Units Abbreviation Dictionary for the stage’s output signal. Analog filters usually emit volts, and digital filters usually emit counts	 
r_type		VARCHAR(1)	Y	A single character describing the type of response	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Re01	r_type IN ('A','B','C','D','P')	 
	Check	Re02	resp_nb >= 1	 
	Check	Re03	resp_type IN ('H','L','P','Z','F','N')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Filter_FIR	Response	Non-Identifying	Res_Fil_FIR	 
Response_HP	Response	Non-Identifying	Res_Res_HP	 
Response_LP	Response	Non-Identifying	Res_Res_LP	 
Response_PN	Response	Non-Identifying	Res_Res_PN	 
Response_PZ	Response	Non-Specific	Res_Res_PZ	 
Response	Filamp_PChannel	Non-Specific	Fil_PCh_Res	 
Response	Filter	Non-Specific	Fil_Res	 
Response	Sensor_Component	Non-Specific	Sen_Com_Res	 

seqresp_id

Attribute Name	seqresp_id	Entity Name	Response	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

resp_nb

Attribute Name	resp_nb	Entity Name	Response	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the response number of a sequence	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

resp_type

Attribute Name	resp_type	Entity Name	Response	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the response type	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	

resp_id

Attribute Name	hp_id	Entity Name	Response	
Logical Role Name	resp_id	
Role Name	resp_id	
Primary Key	NO	
Foreign Key	YES	Parent Entity	Filter_FIR	
Definition 

Response identifier. Each response is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

unit_in

Attribute Name	unit_in	Entity Name	Response	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

A unit lookup key that refers to the Units Abbreviation Dictionary for the units of the incoming to this stage of the filter. This signal will usually be ground motion, volts, or counts, depending on where it is in the filter system	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

unit_out

Attribute Name	unit_out	Entity Name	Response	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

A unit lookup key that refers to the Units Abbreviation Dictionary for the stage’s output signal. Analog filters usually emit volts, and digital filters usually emit counts	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

r_type

Attribute Name	r_type	Entity Name	Response	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

A single character describing the type of response	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Response	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Response_HP

Entity Name	Response_HP	
Owner Name		
Entity Type	Independent	
Primary Keys	hp_id	
Definition	Summary information on a high-pass filter	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
hp_id		NUMERIC(8, 0)	N	High-pass filter identifier. Each high-pass filter is assigned a unique integer which identifies it in a database	 
filter_type		VARCHAR(2)	N	This attribute denotes the type of a high-pass filter	 
nb_pole		NUMERIC(8, 0)	N	This attribute denotes the number of poles of a high-pass filter	 
corner_freq		FLOAT	N	This attribute represents the corner frequency of a high-pass filter	 
damping_value		FLOAT	N	This attribute represents the fraction of critical damping of a high-pass filter	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	RHP01	filter_type IN ('BW','DG','ND')	 
	Check	RHP02	nb_pole > 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Response_HP	Response	Non-Identifying	Res_Res_HP	 

hp_id

Attribute Name	hp_id	Entity Name	Response_HP	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

High-pass filter identifier. Each high-pass filter is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

filter_type

Attribute Name	filter_type	Entity Name	Response_HP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the type of a high-pass filter	
Logical Column Properties 

Data Type	VARCHAR(2)	Width	2	Scale		
Nullable	NO	
Identity	NO	

nb_pole

Attribute Name	nb_pole	Entity Name	Response_HP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of poles of a high-pass filter	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

corner_freq

Attribute Name	corner_freq	Entity Name	Response_HP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the corner frequency of a high-pass filter	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

damping_value

Attribute Name	damping_value	Entity Name	Response_HP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the fraction of critical damping of a high-pass filter	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Response_HP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Response_LP

Entity Name	Response_LP	
Owner Name		
Entity Type	Independent	
Primary Keys	lp_id	
Definition	Summary information on a low-pass filter	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
lp_id		NUMERIC(8, 0)	N	Low-pass filter identifier. Each low-pass filter is assigned a unique integer which identifies it in a database	 
filter_type		VARCHAR(2)	Y	This attribute denotes the type of a low-pass filter	 
nb_pole		NUMERIC(8, 0)	Y	This attribute denotes the number of poles of a low-pass filter	 
corner_freq		FLOAT	N	This attribute represents the corner frequency of a low-pass filter	 
damping_value		FLOAT	N	This attribute represents the fraction of critical damping of a low-pass filter	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	RLP01	filter_type IN ('BW','DG','ND')	 
	Check	RLP02	nb_pole > 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Response_LP	Response	Non-Identifying	Res_Res_LP	 

lp_id

Attribute Name	lp_id	Entity Name	Response_LP	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Low-pass filter identifier. Each low-pass filter is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

filter_type

Attribute Name	filter_type	Entity Name	Response_LP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the type of a low-pass filter	
Logical Column Properties 

Data Type	VARCHAR(2)	Width	2	Scale		
Nullable	YES	
Identity	NO	

nb_pole

Attribute Name	nb_pole	Entity Name	Response_LP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of poles of a low-pass filter	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	

corner_freq

Attribute Name	corner_freq	Entity Name	Response_LP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the corner frequency of a low-pass filter	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

damping_value

Attribute Name	damping_value	Entity Name	Response_LP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the fraction of critical damping of a low-pass filter	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Response_LP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Response_PN

Entity Name	Response_PN	
Owner Name		
Entity Type	Independent	
Primary Keys	pn_id	
Definition	Summary information on a polynomial	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
pn_id		NUMERIC(8, 0)	N	Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database	 
name		VARCHAR(80)	Y	This attribute denotes a descriptive name for a polynomial	 
poly_type		VARCHAR(1)	N	This attribute represents the type of polynomial approximation	 
lower_bound		FLOAT	Y	This attribute denotes the polynomial lower bound	 
upper_bound		FLOAT	Y	This attribute denotes the polynomial upper bound	 
max_error		FLOAT	Y	This attribute represents the maximum error of polynomial approximation	 
nb_coeff		NUMERIC(8, 0)	Y	This attribute denotes the number of polynomial coefficients	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	RPN01	nb_coeff >= 0	 
	Check	RPN02	poly_type IN ('C','L','M')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Response_PN	Response_PN_Data	Identifying	Res_PN_Dat_Res_PN	 
Response_PN	Response	Non-Identifying	Res_Res_PN	 

pn_id

Attribute Name	pn_id	Entity Name	Response_PN	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

name

Attribute Name	name	Entity Name	Response_PN	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a descriptive name for a polynomial	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

poly_type

Attribute Name	poly_type	Entity Name	Response_PN	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the type of polynomial approximation	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	

lower_bound

Attribute Name	lower_bound	Entity Name	Response_PN	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the polynomial lower bound	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

upper_bound

Attribute Name	upper_bound	Entity Name	Response_PN	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the polynomial upper bound	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

max_error

Attribute Name	max_error	Entity Name	Response_PN	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the maximum error of polynomial approximation	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

nb_coeff

Attribute Name	nb_coeff	Entity Name	Response_PN	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of polynomial coefficients	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Response_PN	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Response_PN_Data

Entity Name	Response_PN_Data	
Owner Name		
Entity Type	Dependent	
Primary Keys	pn_id,pn_nb	
Definition	Coefficients of a polynomial	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
pn_id		NUMERIC(8, 0)	N	Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database	 
pn_nb		NUMERIC(8, 0)	N	This attribute denotes the coefficient number of a polynomial	 
pn_value		FLOAT	N	This attribute denotes the coefficient value of a polynomial	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	RPND01	pn_nb >= 1	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Response_PN	Response_PN_Data	Identifying	Res_PN_Dat_Res_PN	 

pn_id

Attribute Name	pn_id	Entity Name	Response_PN_Data	
Logical Role Name	pn_id	
Role Name	pn_id	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Response_PN	
Definition 

Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

pn_nb

Attribute Name	pn_nb	Entity Name	Response_PN_Data	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the coefficient number of a polynomial	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

pn_value

Attribute Name	pn_value	Entity Name	Response_PN_Data	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the coefficient value of a polynomial	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

Response_PZ

Entity Name	Response_PZ	
Owner Name		
Entity Type	Independent	
Primary Keys	pz_id,pz_nb	
Definition	Summary information on poles & zeros	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
pz_id		NUMERIC(8, 0)	N	Poles & zeros set identifier. Each poles & zeros set is assigned a unique integer which identifies it in a database	 
pz_nb		NUMERIC(8, 0)	N	This attribute denotes the pole/zero number of a response	 
type		VARCHAR(1)	N	This attribute denotes whether a value is associated with a pole/zero	 
r_value		FLOAT	N	The real portion of a complex pole/zero	 
r_error		FLOAT	Y	The error value for the real portion of a complex pole/zero	 
i_value		FLOAT	N	The imaginary portion of a complex pole/zero	 
i_error		FLOAT	Y	The error value for the imaginary portion of a complex pole/zero	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	RPZ01	pz_nb >= 1	 
	Check	RPZ02	type IN ('P','Z')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Response_PZ	Response	Non-Specific	Res_Res_PZ	 

pz_id

Attribute Name	pz_id	Entity Name	Response_PZ	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Poles & zeros set identifier. Each poles & zeros set is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

pz_nb

Attribute Name	pz_nb	Entity Name	Response_PZ	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the pole/zero number of a response	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

type

Attribute Name	type	Entity Name	Response_PZ	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes whether a value is associated with a pole/zero	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	

r_value

Attribute Name	r_value	Entity Name	Response_PZ	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The real portion of a complex pole/zero	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

r_error

Attribute Name	r_error	Entity Name	Response_PZ	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The error value for the real portion of a complex pole/zero	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

i_value

Attribute Name	i_value	Entity Name	Response_PZ	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The imaginary portion of a complex pole/zero	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

i_error

Attribute Name	i_error	Entity Name	Response_PZ	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The error value for the imaginary portion of a complex pole/zero	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Response_PZ	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Sensor

Entity Name	Sensor	
Owner Name		
Entity Type	Independent	
Primary Keys	sensor_id	
Definition	Summary information on a sensor	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sensor_id		NUMERIC(8, 0)	N	Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	 
name		VARCHAR(80)	Y	This attribute denotes a descriptive name for a sensor	 
serial_nb		VARCHAR(80)	Y	This attribute denotes a serial number of a sensor	 
ondate		DATE	N	This attribute denotes the start date	 
offdate		DATE	Y	This attribute denotes the end date	 
nb_component		NUMERIC(8, 0)	N	This attribute denotes the number of components of a sensor	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Sensor01	nb_component >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Sensor	Sensor_Component	Identifying	Sen_Com_Sen	 
Sensor	Station_Sensor	Non-Identifying	Sta_Sen_Sen	 

sensor_id

Attribute Name	sensor_id	Entity Name	Sensor	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

name

Attribute Name	name	Entity Name	Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a descriptive name for a sensor	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

serial_nb

Attribute Name	serial_nb	Entity Name	Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a serial number of a sensor	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

nb_component

Attribute Name	nb_component	Entity Name	Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of components of a sensor	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Sensor_Component

Entity Name	Sensor_Component	
Owner Name		
Entity Type	Dependent	
Primary Keys	sensor_id,component_nb	
Definition	Component of a sensor	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sensor_id		NUMERIC(8, 0)	N	Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	 
component_nb		NUMERIC(8, 0)	N	This attribute represents the component number	 
channel_comp		VARCHAR(2)	Y	Component channel	 
component_type		VARCHAR(1)	Y	This attribute denotes the component type	 
sensitivity		FLOAT	N	This attribute denotes the sensitivity (Sd) for a sensor or a digitizer	 
frequency		FLOAT	Y	The frequency (fs) at which the value in sensitivity/gain is correct	 
seqresp_id		NUMERIC(8, 0)	Y	Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	SeC01	component_nb >= 1	 
	Check	SeC02	frequency >= 0.0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Response	Sensor_Component	Non-Specific	Sen_Com_Res	 
Sensor	Sensor_Component	Identifying	Sen_Com_Sen	 

sensor_id

Attribute Name	sensor_id	Entity Name	Sensor_Component	
Logical Role Name	sensor_id	
Role Name	sensor_id	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Sensor	
Definition 

Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

component_nb

Attribute Name	component_nb	Entity Name	Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the component number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

channel_comp

Attribute Name	channel_comp	Entity Name	Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Component channel	
Logical Column Properties 

Data Type	VARCHAR(2)	Width	2	Scale		
Nullable	YES	
Identity	NO	

component_type

Attribute Name	component_type	Entity Name	Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the component type	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	YES	
Identity	NO	

sensitivity

Attribute Name	sensitivity	Entity Name	Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the sensitivity (Sd) for a sensor or a digitizer	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

frequency

Attribute Name	frequency	Entity Name	Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The frequency (fs) at which the value in sensitivity/gain is correct	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

seqresp_id

Attribute Name	seqresp_id	Entity Name	Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Station

Entity Name	Station	
Owner Name		
Entity Type	Independent	
Primary Keys	sta,net,ondate	
Definition	Summary information on a station	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
ondate		DATE	N	This attribute denotes the start date	 
lat		FLOAT	Y	Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes	 
lon		FLOAT	Y	Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian	 
elev		FLOAT	Y	Elevation. This attribute is the elevation of a seismic station relative to mean sea level	 
staname		VARCHAR(50)	Y	Station name/description. This is the full name of the station whose code-name is in sta	 
nb_sensor		NUMERIC(8, 0)	Y	This attribute denotes the number of sensors of a station	 
nb_filamp		NUMERIC(8, 0)	Y	This attribute denotes the number of filter-amplifiers of a station	 
nb_digi		NUMERIC(8, 0)	N	This attribute denotes the number of digitizers of a station	 
nb_data		NUMERIC(8, 0)	N	This attribute denotes the number of dataloggers of a station	 
datumhor		VARCHAR(8)	Y	Datum type for horizontal (latitude and longitude) coordinates	 
datumver		VARCHAR(8)	Y	Datum type for depth or elevation	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	St01	datumhor IN ('NAD27','WGS84')	 
	Check	St02	datumver IN ('NAD27','WGS84','AVERAGE')	 
	Check	St03	elev >= -5000.0 AND elev <= 5000.0	 
	Check	St04	lat >= -90.0 AND lat <= 90.0	 
	Check	St05	lon >= -180.0 AND lon <= 180.0	 
	Check	St06	nb_data >= 0	 
	Check	St07	nb_digi >= 0	 
	Check	St08	nb_filamp >= 0	 
	Check	St09	nb_sensor >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Station	Station_Datalogger	Identifying	Sta_Dat_Sta	 
Station	Station_Digitizer	Identifying	Sta_Dig_Sta	 
Station	Station_Filamp	Identifying	Sta_Fil_Sta	 
Station	Station_Sensor	Identifying	Sta_Sen_Sta	 

sta

Attribute Name	sta	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Logical Column Properties 

Data Type	VARCHAR(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	

net

Attribute Name	net	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Unique network identifier. This character string is the name of a seismic network	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

lat

Attribute Name	lat	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

lon

Attribute Name	lon	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

elev

Attribute Name	elev	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Elevation. This attribute is the elevation of a seismic station relative to mean sea level	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

staname

Attribute Name	staname	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Station name/description. This is the full name of the station whose code-name is in sta	
Logical Column Properties 

Data Type	VARCHAR(50)	Width	50	Scale		
Nullable	YES	
Identity	NO	

nb_sensor

Attribute Name	nb_sensor	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of sensors of a station	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	

nb_filamp

Attribute Name	nb_filamp	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of filter-amplifiers of a station	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	

nb_digi

Attribute Name	nb_digi	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of digitizers of a station	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

nb_data

Attribute Name	nb_data	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of dataloggers of a station	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

datumhor

Attribute Name	datumhor	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Datum type for horizontal (latitude and longitude) coordinates	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	

datumver

Attribute Name	datumver	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Datum type for depth or elevation	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Station	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Station_Datalogger

Entity Name	Station_Datalogger	
Owner Name		
Entity Type	Dependent	
Primary Keys	sta,net,data_nb,ondate	
Definition	Data associating a station with a datalogger	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
data_nb		NUMERIC(8, 0)	N	This attribute represents the datalogger number	 
ondate		DATE	N	This attribute denotes the start date	 
data_id		NUMERIC(8, 0)	N	Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	 
nb_pchannel		NUMERIC(8, 0)	N	This attribute denotes the number of physical channels of a datalogger	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StDa01	data_nb >= 1	 
	Check	StDa02	nb_pchannel >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Datalogger	Station_Datalogger	Non-Identifying	Sta_Dat_Dat	 
Station	Station_Datalogger	Identifying	Sta_Dat_Sta	 
Station_Datalogger	Station_Datalogger_PChannel	Identifying	Sta_Dat_PCh_Sta_Dat	 

sta

Attribute Name	sta	Entity Name	Station_Datalogger	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Logical Column Properties 

Data Type	VARCHAR(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	

net

Attribute Name	net	Entity Name	Station_Datalogger	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

data_nb

Attribute Name	data_nb	Entity Name	Station_Datalogger	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the datalogger number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Station_Datalogger	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

data_id

Attribute Name	data_id	Entity Name	Station_Datalogger	
Logical Role Name	data_id	
Role Name	data_id	
Primary Key	NO	
Foreign Key	YES	Parent Entity	Datalogger	
Definition 

Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

nb_pchannel

Attribute Name	nb_pchannel	Entity Name	Station_Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of physical channels of a datalogger	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Station_Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Station_Datalogger	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Station_Datalogger_LChannel

Entity Name	Station_Datalogger_LChannel	
Owner Name		
Entity Type	Dependent	
Primary Keys	sta,net,data_nb,pchannel_nb,lchannel_nb,ondate	
Definition	Summary information on a channel	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
data_nb		NUMERIC(8, 0)	N	This attribute represents the datalogger number	 
pchannel_nb		NUMERIC(8, 0)	N	This attribute denotes a physical channel	 
lchannel_nb		NUMERIC(8, 0)	N	This attribute denotes a logical channel of a datalogger	 
ondate		DATE	N	This attribute denotes the start date	 
seqfil_id		NUMERIC(8, 0)	Y	Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	 
seedchan		VARCHAR(3)	Y	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	 
channel		VARCHAR(3)	Y	Channel name	 
channelsrc		VARCHAR(8)	Y	Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, ...)	 
location		VARCHAR(2)	Y	Describes the individual sites on an array station, operated by the same network operator	 
rgain		FLOAT	Y	This attribute denotes the gain at the response frequency	 
rfrequency		FLOAT	Y	The frequency (fs) at which the value in rgain is correct	 
samprate		FLOAT	N	Sampling rate. This attribute is the sample rate in samples/second	 
clock_drift		FLOAT	Y	A tolerance value, measured in seconds per sample, used as a thresold for time error detection in the data. The number of samples in a record are multiplied by this value to calculate a maximum drift allowed for the time in the next record. If the difference in time is less than this drift, consider them in the same time series	 
flags		VARCHAR(27)	Y	Channel flags	 
data_format		VARCHAR(80)	N	This attribute represents the data format	 
comp_type		NUMERIC(8, 0)	N	Compression type. A lookup key that refers to the Format Dictionary	 
unit_signal		NUMERIC(8, 0)	N	A unit lookup key that refers to the Units Abbreviation Dictionary for the signal response of the instrument – usually the ground motion response, or something else for non-seismic devices	 
unit_calib		NUMERIC(8, 0)	N	A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps	 
block_size		NUMERIC(8, 0)	N	The record length of the data	 
offdate		DATE	Y	This attribute denotes the end date	 
remark		VARCHAR(30)	Y	An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StDaL01	block_size >= 256 AND block_size <= 4096	 
	Check	StDaL02	clock_drift >= 0.0	 
	Check	StDaL03	data_nb >= 1	 
	Check	StDaL04	lchannel_nb >= 1	 
	Check	StDaL05	pchannel_nb >= 1	 
	Check	StDaL06	rfrequency > 0.0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Filter_Sequence	Station_Datalogger_LChannel	Non-Identifying	Sta_Dat_LCh_Fil_Seq	 
Station_Datalogger_PChannel	Station_Datalogger_LChannel	Identifying	Sta_Dat_LCh_Sta_Dat_PCh	 

sta

Attribute Name	sta	Entity Name	Station_Datalogger_LChannel	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Datalogger_PChannel	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Logical Column Properties 

Data Type	VARCHAR(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	

net

Attribute Name	net	Entity Name	Station_Datalogger_LChannel	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Datalogger_PChannel	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

data_nb

Attribute Name	data_nb	Entity Name	Station_Datalogger_LChannel	
Logical Role Name	data_nb	
Role Name	data_nb	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Datalogger_PChannel	
Definition 

This attribute represents the datalogger number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

pchannel_nb

Attribute Name	pchannel_nb	Entity Name	Station_Datalogger_LChannel	
Logical Role Name	pchannel_nb	
Role Name	pchannel_nb	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Datalogger_PChannel	
Definition 

This attribute denotes a physical channel	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

lchannel_nb

Attribute Name	lchannel_nb	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a logical channel of a datalogger	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Station_Datalogger_LChannel	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Datalogger_PChannel	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

seqfil_id

Attribute Name	seqfil_id	Entity Name	Station_Datalogger_LChannel	
Logical Role Name	seqfil_id	
Role Name	seqfil_id	
Primary Key	NO	
Foreign Key	YES	Parent Entity	Filter_Sequence	
Definition 

Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	

seedchan

Attribute Name	seedchan	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	
Logical Column Properties 

Data Type	VARCHAR(3)	Width	3	Scale		
Nullable	YES	
Identity	NO	

channel

Attribute Name	channel	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Channel name	
Logical Column Properties 

Data Type	VARCHAR(3)	Width	3	Scale		
Nullable	YES	
Identity	NO	

channelsrc

Attribute Name	channelsrc	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, ...)	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	

location

Attribute Name	location	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Describes the individual sites on an array station, operated by the same network operator	
Logical Column Properties 

Data Type	VARCHAR(2)	Width	2	Scale		
Nullable	YES	
Identity	NO	

rgain

Attribute Name	rgain	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the gain at the response frequency	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

rfrequency

Attribute Name	rfrequency	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The frequency (fs) at which the value in rgain is correct	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

samprate

Attribute Name	samprate	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Sampling rate. This attribute is the sample rate in samples/second	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

clock_drift

Attribute Name	clock_drift	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

A tolerance value, measured in seconds per sample, used as a thresold for time error detection in the data. The number of samples in a record are multiplied by this value to calculate a maximum drift allowed for the time in the next record. If the difference in time is less than this drift, consider them in the same time series	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

flags

Attribute Name	flags	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Channel flags	
Logical Column Properties 

Data Type	VARCHAR(27)	Width	27	Scale		
Nullable	YES	
Identity	NO	

data_format

Attribute Name	data_format	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the data format	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	NO	
Identity	NO	

comp_type

Attribute Name	comp_type	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Compression type. A lookup key that refers to the Format Dictionary	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

unit_signal

Attribute Name	unit_signal	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

A unit lookup key that refers to the Units Abbreviation Dictionary for the signal response of the instrument – usually the ground motion response, or something else for non-seismic devices	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

unit_calib

Attribute Name	unit_calib	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

block_size

Attribute Name	block_size	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The record length of the data	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

remark

Attribute Name	remark	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications	
Logical Column Properties 

Data Type	VARCHAR(30)	Width	30	Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Station_Datalogger_LChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Station_Datalogger_PChannel

Entity Name	Station_Datalogger_PChannel	
Owner Name		
Entity Type	Dependent	
Primary Keys	sta,net,data_nb,pchannel_nb,ondate	
Definition	Data associating channels	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
data_nb		NUMERIC(8, 0)	N	This attribute represents the datalogger number	 
pchannel_nb		NUMERIC(8, 0)	N	This attribute denotes a physical channel	 
ondate		DATE	N	This attribute denotes the start date	 
board_type		VARCHAR(1)	N	This attribute describes the board type on the datalogger where the physical channel resides. Regular seismic channels are usually on a primary board. Auxiliary channels (internal temperature, external power, …) are usually on an auxiliary board. A value of external is used to represent a digitizer that is not part of the datalogger (for example an embedded digitizer in a digital pressure sensor). A digital board is used to represent truly digital sensors which don’t actually have any digitizing stage from Volts to Counts (for example a rainfall sensor that uses a digital counter)	 
channel_type		VARCHAR(1)	N	This attribute describes the type of the input channel. An input channel is usually classified as physical when the data is digitized (velocity, acceleration, ...). An input channel is defined as synthetic when the data is not derived directly from a sensor (clock frequency, available telemetry buffer channel, clock quality, ...)	 
seed_io		VARCHAR(2)	N	This attribute represents the SEED instrument and orientation	 
nb_lchannel		NUMERIC(8, 0)	N	This attribute denotes the number of logical channels of a datalogger	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StDaP01	data_nb >= 1	 
	Check	StDaP02	nb_lchannel >= 1	 
	Check	StDaP03	pchannel_nb >= 1	 
	Check	StDaP04	board_type IN ('P', 'A', 'E', 'D')	 
	Check	StDaP05	channel_type IN ('P', 'S')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Station_Datalogger	Station_Datalogger_PChannel	Identifying	Sta_Dat_PCh_Sta_Dat	 
Station_Datalogger_PChannel	Station_Datalogger_LChannel	Identifying	Sta_Dat_LCh_Sta_Dat_PCh	 

sta

Attribute Name	sta	Entity Name	Station_Datalogger_PChannel	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Datalogger	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Logical Column Properties 

Data Type	VARCHAR(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	

net

Attribute Name	net	Entity Name	Station_Datalogger_PChannel	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Datalogger	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

data_nb

Attribute Name	data_nb	Entity Name	Station_Datalogger_PChannel	
Logical Role Name	data_nb	
Role Name	data_nb	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Datalogger	
Definition 

This attribute represents the datalogger number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

pchannel_nb

Attribute Name	pchannel_nb	Entity Name	Station_Datalogger_PChannel	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a physical channel	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Station_Datalogger_PChannel	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Datalogger	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

board_type

Attribute Name	board_type	Entity Name	Station_Datalogger_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute describes the board type on the datalogger where the physical channel resides. Regular seismic channels are usually on a primary board. Auxiliary channels (internal temperature, external power, …) are usually on an auxiliary board. A value of external is used to represent a digitizer that is not part of the datalogger (for example an embedded digitizer in a digital pressure sensor). A digital board is used to represent truly digital sensors which don’t actually have any digitizing stage from Volts to Counts (for example a rainfall sensor that uses a digital counter)	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	

channel_type

Attribute Name	channel_type	Entity Name	Station_Datalogger_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute describes the type of the input channel. An input channel is usually classified as physical when the data is digitized (velocity, acceleration, ...). An input channel is defined as synthetic when the data is not derived directly from a sensor (clock frequency, available telemetry buffer channel, clock quality, ...)	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	

seed_io

Attribute Name	seed_io	Entity Name	Station_Datalogger_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the SEED instrument and orientation	
Logical Column Properties 

Data Type	VARCHAR(2)	Width	2	Scale		
Nullable	NO	
Identity	NO	

nb_lchannel

Attribute Name	nb_lchannel	Entity Name	Station_Datalogger_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of logical channels of a datalogger	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Station_Datalogger_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Station_Datalogger_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Station_Digitizer

Entity Name	Station_Digitizer	
Owner Name		
Entity Type	Dependent	
Primary Keys	sta,net,digi_nb,ondate	
Definition	Data associating a station with a digitizer	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
digi_nb		NUMERIC(8, 0)	N	This attribute represents the digitizer number	 
ondate		DATE	N	This attribute denotes the start date	 
serial_nb		VARCHAR(80)	N	This attribute denotes a serial number of a datalogger board	 
nb_pri_pchannel		NUMERIC(8, 0)	N	This attribute denotes the number of primary physical channels of a digitizer	 
nb_aux_pchannel		NUMERIC(8, 0)	N	This attribute denotes the number of auxiliary physical channels of a digitizer	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StDi01	digi_nb >= 1	 
	Check	StDi02	nb_aux_pchannel >= 0	 
	Check	StDi03	nb_pri_pchannel >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Station	Station_Digitizer	Identifying	Sta_Dig_Sta	 
Station_Digitizer	Datalogger_Board	Non-Specific	Sta_Dig_Dat_Boa	 
Station_Digitizer	Station_Digitizer_PChannel	Identifying	Sta_Dig_PCh_Sta_Dig	 

sta

Attribute Name	sta	Entity Name	Station_Digitizer	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Logical Column Properties 

Data Type	VARCHAR(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	

net

Attribute Name	net	Entity Name	Station_Digitizer	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

digi_nb

Attribute Name	digi_nb	Entity Name	Station_Digitizer	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the digitizer number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Station_Digitizer	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

serial_nb

Attribute Name	serial_nb	Entity Name	Station_Digitizer	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a serial number of a datalogger board	
Logical Column Properties 

Data Type	VARCHAR(80)	Width	80	Scale		
Nullable	NO	
Identity	NO	

nb_pri_pchannel

Attribute Name	nb_pri_pchannel	Entity Name	Station_Digitizer	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of primary physical channels of a digitizer	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

nb_aux_pchannel

Attribute Name	nb_aux_pchannel	Entity Name	Station_Digitizer	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of auxiliary physical channels of a digitizer	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Station_Digitizer	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Station_Digitizer	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Station_Digitizer_PChannel

Entity Name	Station_Digitizer_PChannel	
Owner Name		
Entity Type	Dependent	
Primary Keys	sta,net,digi_nb,pchannel_nb,ondate	
Definition	Data associating physical channels	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
digi_nb		NUMERIC(8, 0)	N	This attribute represents the digitizer number	 
pchannel_nb		NUMERIC(8, 0)	N	This attribute denotes a physical channel	 
ondate		DATE	N	This attribute denotes the start date	 
data_nb		NUMERIC(8, 0)	N	This attribute represents the datalogger number	 
data_pchannel		NUMERIC(8, 0)	N	This attribute represents a datalogger physical channel	 
digi_type		VARCHAR(3)	N	This attribute represents the digitizer type	 
digi_polarity		VARCHAR(1)	N	This attribute represents the digitizer polarity	 
digi_channel		NUMERIC(8, 0)	N	This attribute represents a digitizer module on a board	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StDiP01	data_nb >= 1	 
	Check	StDiP02	data_pchannel >= 1	 
	Check	StDiP03	digi_nb >= 1	 
	Check	StDiP05	pchannel_nb >= 1	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Station_Digitizer	Station_Digitizer_PChannel	Identifying	Sta_Dig_PCh_Sta_Dig	 

sta

Attribute Name	sta	Entity Name	Station_Digitizer_PChannel	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Digitizer	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Logical Column Properties 

Data Type	VARCHAR(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	

net

Attribute Name	net	Entity Name	Station_Digitizer_PChannel	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Digitizer	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

digi_nb

Attribute Name	digi_nb	Entity Name	Station_Digitizer_PChannel	
Logical Role Name	digi_nb	
Role Name	digi_nb	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Digitizer	
Definition 

This attribute represents the digitizer number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

pchannel_nb

Attribute Name	pchannel_nb	Entity Name	Station_Digitizer_PChannel	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a physical channel	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Station_Digitizer_PChannel	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Digitizer	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

data_nb

Attribute Name	data_nb	Entity Name	Station_Digitizer_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the datalogger number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

data_pchannel

Attribute Name	data_pchannel	Entity Name	Station_Digitizer_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents a datalogger physical channel	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

digi_type

Attribute Name	digi_type	Entity Name	Station_Digitizer_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the digitizer type	
Logical Column Properties 

Data Type	VARCHAR(3)	Width	3	Scale		
Nullable	NO	
Identity	NO	

digi_polarity

Attribute Name	digi_polarity	Entity Name	Station_Digitizer_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the digitizer polarity	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	

digi_channel

Attribute Name	digi_channel	Entity Name	Station_Digitizer_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents a digitizer module on a board	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Station_Digitizer_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Station_Digitizer_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Station_Filamp

Entity Name	Station_Filamp	
Owner Name		
Entity Type	Dependent	
Primary Keys	sta,net,filamp_nb,ondate	
Definition	Data associating a station with a filter-amplifier	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
filamp_nb		NUMERIC(8, 0)	N	This attribute represents the filter-amplifier number	 
ondate		DATE	N	This attribute denotes the start date	 
filamp_id		NUMERIC(8, 0)	N	Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	 
nb_pchannel		NUMERIC(8, 0)	N	This attribute denotes the number of physical channels of a datalogger	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StFi01	filamp_nb >= 1	 
	Check	StFi02	nb_pchannel >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Filamp	Station_Filamp	Non-Identifying	Sta_Fil_Fil	 
Station	Station_Filamp	Identifying	Sta_Fil_Sta	 
Station_Filamp	Station_Filamp_PChannel	Identifying	Sta_Fil_PCh_Sta_Fil	 

sta

Attribute Name	sta	Entity Name	Station_Filamp	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Logical Column Properties 

Data Type	VARCHAR(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	

net

Attribute Name	net	Entity Name	Station_Filamp	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

filamp_nb

Attribute Name	filamp_nb	Entity Name	Station_Filamp	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the filter-amplifier number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Station_Filamp	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

filamp_id

Attribute Name	filamp_id	Entity Name	Station_Filamp	
Logical Role Name	filamp_id	
Role Name	filamp_id	
Primary Key	NO	
Foreign Key	YES	Parent Entity	Filamp	
Definition 

Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

nb_pchannel

Attribute Name	nb_pchannel	Entity Name	Station_Filamp	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of physical channels of a datalogger	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Station_Filamp	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Station_Filamp	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Station_Filamp_PChannel

Entity Name	Station_Filamp_PChannel	
Owner Name		
Entity Type	Dependent	
Primary Keys	sta,net,filamp_nb,pchannel_nb,ondate	
Definition	Data associating physical channels	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
filamp_nb		NUMERIC(8, 0)	N	This attribute represents the filter-amplifier number	 
pchannel_nb		NUMERIC(8, 0)	N	This attribute denotes a physical channel	 
ondate		DATE	N	This attribute denotes the start date	 
next_hard_type		VARCHAR(1)	N	This attribute denotes the next hardware type	 
next_hard_nb		NUMERIC(8, 0)	N	This attribute denotes the next hardware number	 
next_hard_pchannel		NUMERIC(8, 0)	N	This attribute denotes the next hardware physical channel	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StFiP01	filamp_nb >= 1	 
	Check	StFiP02	next_hard_nb >= 1	 
	Check	StFiP03	next_hard_pchannel >= 1	 
	Check	StFiP04	next_hard_type IN ('F','D')	 
	Check	StFiP05	pchannel_nb >= 1	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Station_Filamp	Station_Filamp_PChannel	Identifying	Sta_Fil_PCh_Sta_Fil	 

sta

Attribute Name	sta	Entity Name	Station_Filamp_PChannel	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Filamp	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Logical Column Properties 

Data Type	VARCHAR(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	

net

Attribute Name	net	Entity Name	Station_Filamp_PChannel	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Filamp	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

filamp_nb

Attribute Name	filamp_nb	Entity Name	Station_Filamp_PChannel	
Logical Role Name	filamp_nb	
Role Name	filamp_nb	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Filamp	
Definition 

This attribute represents the filter-amplifier number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

pchannel_nb

Attribute Name	pchannel_nb	Entity Name	Station_Filamp_PChannel	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a physical channel	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Station_Filamp_PChannel	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Filamp	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

next_hard_type

Attribute Name	next_hard_type	Entity Name	Station_Filamp_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the next hardware type	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	

next_hard_nb

Attribute Name	next_hard_nb	Entity Name	Station_Filamp_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the next hardware number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

next_hard_pchannel

Attribute Name	next_hard_pchannel	Entity Name	Station_Filamp_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the next hardware physical channel	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Station_Filamp_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Station_Filamp_PChannel	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Station_Sensor

Entity Name	Station_Sensor	
Owner Name		
Entity Type	Dependent	
Primary Keys	sta,net,sensor_nb,ondate	
Definition	Data associating a station with a sensor	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sensor_nb		NUMERIC(8, 0)	N	This attribute represents the sensor number	 
ondate		DATE	N	This attribute denotes the start date	 
sensor_id		NUMERIC(8, 0)	N	Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	 
lat		FLOAT	Y	Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes	 
lon		FLOAT	Y	Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian	 
elev		FLOAT	Y	Elevation. This attribute is the elevation of a seismic station relative to mean sea level	 
edepth		FLOAT	Y	Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev	 
nb_component		NUMERIC(8, 0)	N	This attribute denotes the number of components of a sensor	 
datumhor		VARCHAR(8)	Y	Datum type for horizontal (latitude and longitude) coordinates	 
datumver		VARCHAR(8)	Y	Datum type for depth or elevation	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StSe01	datumhor IN ('NAD27','WGS84')	 
	Check	StSe02	datumver IN ('NAD27','WGS84','AVERAGE')	 
	Check	StSe03	edepth >= 0.0	 
	Check	StSe04	elev >= -5000.0 AND elev <= 5000.0	 
	Check	StSe05	lat >= -90.0 AND lat <= 90.0	 
	Check	StSe06	lon >= -180.0 AND lon <= 180.0	 
	Check	StSe07	nb_component >= 0	 
	Check	StSe08	sensor_nb >= 1	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Sensor	Station_Sensor	Non-Identifying	Sta_Sen_Sen	 
Station	Station_Sensor	Identifying	Sta_Sen_Sta	 
Station_Sensor	Station_Sensor_Component	Identifying	Sta_Sen_Com_Sta_Sen	 

sta

Attribute Name	sta	Entity Name	Station_Sensor	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Logical Column Properties 

Data Type	VARCHAR(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	

net

Attribute Name	net	Entity Name	Station_Sensor	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

sensor_nb

Attribute Name	sensor_nb	Entity Name	Station_Sensor	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the sensor number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Station_Sensor	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

sensor_id

Attribute Name	sensor_id	Entity Name	Station_Sensor	
Logical Role Name	sensor_id	
Role Name	sensor_id	
Primary Key	NO	
Foreign Key	YES	Parent Entity	Sensor	
Definition 

Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

lat

Attribute Name	lat	Entity Name	Station_Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

lon

Attribute Name	lon	Entity Name	Station_Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

elev

Attribute Name	elev	Entity Name	Station_Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Elevation. This attribute is the elevation of a seismic station relative to mean sea level	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

edepth

Attribute Name	edepth	Entity Name	Station_Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

nb_component

Attribute Name	nb_component	Entity Name	Station_Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the number of components of a sensor	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

datumhor

Attribute Name	datumhor	Entity Name	Station_Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Datum type for horizontal (latitude and longitude) coordinates	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	

datumver

Attribute Name	datumver	Entity Name	Station_Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Datum type for depth or elevation	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Station_Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Station_Sensor	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Station_Sensor_Component

Entity Name	Station_Sensor_Component	
Owner Name		
Entity Type	Dependent	
Primary Keys	sta,net,sensor_nb,component_nb,ondate	
Definition	Data associating physical channels	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sensor_nb		NUMERIC(8, 0)	N	This attribute represents the sensor number	 
component_nb		NUMERIC(8, 0)	N	This attribute represents the component number	 
ondate		DATE	N	This attribute denotes the start date	 
next_hard_type		VARCHAR(1)	N	This attribute denotes the next hardware type	 
next_hard_nb		NUMERIC(8, 0)	N	This attribute denotes the next hardware number	 
next_hard_pchannel		NUMERIC(8, 0)	N	This attribute denotes the next hardware physical channel	 
azimuth		FLOAT	Y	The azimuth of the instrument from north, clockwise	 
dip		FLOAT	Y	The dip of the instrument, down from horizontal	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StSeC01	azimuth >= 0.0 AND azimuth <= 360.0	 
	Check	StSeC02	component_nb >= 1	 
	Check	StSec03	dip >= -90.0 AND dip <= 90.0	 
	Check	StSec04	next_hard_nb >= 1	 
	Check	StSec05	next_hard_pchannel >= 1	 
	Check	StSec06	next_hard_type IN ('F','D')	 
	Check	StSec07	sensor_nb >= 1	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Station_Sensor	Station_Sensor_Component	Identifying	Sta_Sen_Com_Sta_Sen	 

sta

Attribute Name	sta	Entity Name	Station_Sensor_Component	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Sensor	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Logical Column Properties 

Data Type	VARCHAR(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	

net

Attribute Name	net	Entity Name	Station_Sensor_Component	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Sensor	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

sensor_nb

Attribute Name	sensor_nb	Entity Name	Station_Sensor_Component	
Logical Role Name	sensor_nb	
Role Name	sensor_nb	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Sensor	
Definition 

This attribute represents the sensor number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

component_nb

Attribute Name	component_nb	Entity Name	Station_Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute represents the component number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Station_Sensor_Component	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Sensor	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

next_hard_type

Attribute Name	next_hard_type	Entity Name	Station_Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the next hardware type	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	

next_hard_nb

Attribute Name	next_hard_nb	Entity Name	Station_Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the next hardware number	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

next_hard_pchannel

Attribute Name	next_hard_pchannel	Entity Name	Station_Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the next hardware physical channel	
Logical Column Properties 

Data Type	NUMERIC(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	

azimuth

Attribute Name	azimuth	Entity Name	Station_Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The azimuth of the instrument from north, clockwise	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

dip

Attribute Name	dip	Entity Name	Station_Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The dip of the instrument, down from horizontal	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Station_Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the end date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Station_Sensor_Component	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	

Key Summary Report

Entity Name	Key Name	 Key Type	Unique	
Datalogger	Da00	PrimaryKey	YES	 
Datalogger_Board	DaB00	PrimaryKey	YES	 
Datalogger_Module	DaM00	PrimaryKey	YES	 
Filamp	Filamp00	PrimaryKey	YES	 
Filamp_PChannel	FiP00	PrimaryKey	YES	 
Filter	Fi00	PrimaryKey	YES	 
Filter_FIR	FFIR00	PrimaryKey	YES	 
Filter_FIR_Data	FFD00	PrimaryKey	YES	 
Filter_Sequence	FiS00	PrimaryKey	YES	 
Filter_Sequence_Data	FiSeD00	PrimaryKey	YES	 
Response	Re00	PrimaryKey	YES	 
Response_HP	RHP00	PrimaryKey	YES	 
Response_LP	RLP00	PrimaryKey	YES	 
Response_PN	RPN00	PrimaryKey	YES	 
Response_PN_Data	RPND00	PrimaryKey	YES	 
Response_PZ	RPZ00	PrimaryKey	YES	 
Sensor	Sensor00	PrimaryKey	YES	 
Sensor_Component	SeC00	PrimaryKey	YES	 
Station	St00	PrimaryKey	YES	 
Station_Datalogger	StDa00	PrimaryKey	YES	 
Station_Datalogger_LChannel	StDaL00	PrimaryKey	YES	 
Station_Datalogger_PChannel	StDaP00	PrimaryKey	YES	 
Station_Digitizer	StDi00	PrimaryKey	YES	 
Station_Digitizer_PChannel	StDiP00	PrimaryKey	YES	 
Station_Filamp	StFi00	PrimaryKey	YES	 
Station_Filamp_PChannel	StFiP00	PrimaryKey	YES	 
Station_Sensor	StSe00	PrimaryKey	YES	 
Station_Sensor_Component	StSeC00	PrimaryKey	YES	 

Da00

Key Name	Da00	
Entity Name	Datalogger	
Key Type	PrimaryKey	
Unique	YES	
Keys	data_id	

DaB00

Key Name	DaB00	
Entity Name	Datalogger_Board	
Key Type	PrimaryKey	
Unique	YES	
Keys	data_id,board_nb	

DaM00

Key Name	DaM00	
Entity Name	Datalogger_Module	
Key Type	PrimaryKey	
Unique	YES	
Keys	data_id,board_nb,module_nb	

Filamp00

Key Name	Filamp00	
Entity Name	Filamp	
Key Type	PrimaryKey	
Unique	YES	
Keys	filamp_id	

FiP00

Key Name	FiP00	
Entity Name	Filamp_PChannel	
Key Type	PrimaryKey	
Unique	YES	
Keys	filamp_id,pchannel_nb	

Fi00

Key Name	Fi00	
Entity Name	Filter	
Key Type	PrimaryKey	
Unique	YES	
Keys	filter_id	

FFIR00

Key Name	FFIR00	
Entity Name	Filter_FIR	
Key Type	PrimaryKey	
Unique	YES	
Keys	fir_id	

FFD00

Key Name	FFD00	
Entity Name	Filter_FIR_Data	
Key Type	PrimaryKey	
Unique	YES	
Keys	fir_id,coeff_nb	

FiS00

Key Name	FiS00	
Entity Name	Filter_Sequence	
Key Type	PrimaryKey	
Unique	YES	
Keys	seqfil_id	

FiSeD00

Key Name	FiSeD00	
Entity Name	Filter_Sequence_Data	
Key Type	PrimaryKey	
Unique	YES	
Keys	seqfil_id,filter_nb	

Re00

Key Name	Re00	
Entity Name	Response	
Key Type	PrimaryKey	
Unique	YES	
Keys	seqresp_id,resp_nb	

RHP00

Key Name	RHP00	
Entity Name	Response_HP	
Key Type	PrimaryKey	
Unique	YES	
Keys	hp_id	

RLP00

Key Name	RLP00	
Entity Name	Response_LP	
Key Type	PrimaryKey	
Unique	YES	
Keys	lp_id	

RPN00

Key Name	RPN00	
Entity Name	Response_PN	
Key Type	PrimaryKey	
Unique	YES	
Keys	pn_id	

RPND00

Key Name	RPND00	
Entity Name	Response_PN_Data	
Key Type	PrimaryKey	
Unique	YES	
Keys	pn_id,pn_nb	

RPZ00

Key Name	RPZ00	
Entity Name	Response_PZ	
Key Type	PrimaryKey	
Unique	YES	
Keys	pz_id,pz_nb	

Sensor00

Key Name	Sensor00	
Entity Name	Sensor	
Key Type	PrimaryKey	
Unique	YES	
Keys	sensor_id	

SeC00

Key Name	SeC00	
Entity Name	Sensor_Component	
Key Type	PrimaryKey	
Unique	YES	
Keys	sensor_id,component_nb	

St00

Key Name	St00	
Entity Name	Station	
Key Type	PrimaryKey	
Unique	YES	
Keys	sta,net,ondate	

StDa00

Key Name	StDa00	
Entity Name	Station_Datalogger	
Key Type	PrimaryKey	
Unique	YES	
Keys	sta,net,data_nb,ondate	

StDaL00

Key Name	StDaL00	
Entity Name	Station_Datalogger_LChannel	
Key Type	PrimaryKey	
Unique	YES	
Keys	sta,net,data_nb,pchannel_nb,lchannel_nb,ondate	

StDaP00

Key Name	StDaP00	
Entity Name	Station_Datalogger_PChannel	
Key Type	PrimaryKey	
Unique	YES	
Keys	sta,net,data_nb,pchannel_nb,ondate	

StDi00

Key Name	StDi00	
Entity Name	Station_Digitizer	
Key Type	PrimaryKey	
Unique	YES	
Keys	sta,net,digi_nb,ondate	

StDiP00

Key Name	StDiP00	
Entity Name	Station_Digitizer_PChannel	
Key Type	PrimaryKey	
Unique	YES	
Keys	sta,net,digi_nb,pchannel_nb,ondate	

StFi00

Key Name	StFi00	
Entity Name	Station_Filamp	
Key Type	PrimaryKey	
Unique	YES	
Keys	sta,net,filamp_nb,ondate	

StFiP00

Key Name	StFiP00	
Entity Name	Station_Filamp_PChannel	
Key Type	PrimaryKey	
Unique	YES	
Keys	sta,net,filamp_nb,pchannel_nb,ondate	

StSe00

Key Name	StSe00	
Entity Name	Station_Sensor	
Key Type	PrimaryKey	
Unique	YES	
Keys	sta,net,sensor_nb,ondate	

StSeC00

Key Name	StSeC00	
Entity Name	Station_Sensor_Component	
Key Type	PrimaryKey	
Unique	YES	
Keys	sta,net,sensor_nb,component_nb,ondate	

Relationship Summary Report

Parent Entity	Child Entity	Relationship Type	No of Keys	
Datalogger	Datalogger_Board	Identifying	1	
Station_Digitizer	Datalogger_Board	Non-Specific	0	
Datalogger_Board	Datalogger_Module	Identifying	2	
Filamp	Filamp_PChannel	Identifying	1	
Response	Filamp_PChannel	Non-Specific	0	
Response	Filter	Non-Specific	0	
Filter_FIR	Filter_FIR_Data	Identifying	1	
Filter	Filter_Sequence_Data	Non-Identifying	1	
Filter_Sequence	Filter_Sequence_Data	Identifying	1	
Filter_FIR	Response	Non-Identifying	1	
Response_HP	Response	Non-Identifying	1	
Response_LP	Response	Non-Identifying	1	
Response_PN	Response	Non-Identifying	1	
Response_PZ	Response	Non-Specific	0	
Response_PN	Response_PN_Data	Identifying	1	
Response	Sensor_Component	Non-Specific	0	
Sensor	Sensor_Component	Identifying	1	
Datalogger	Station_Datalogger	Non-Identifying	1	
Station	Station_Datalogger	Identifying	3	
Filter_Sequence	Station_Datalogger_LChannel	Non-Identifying	1	
Station_Datalogger_PChannel	Station_Datalogger_LChannel	Identifying	5	
Station_Datalogger	Station_Datalogger_PChannel	Identifying	4	
Station	Station_Digitizer	Identifying	3	
Station_Digitizer	Station_Digitizer_PChannel	Identifying	4	
Filamp	Station_Filamp	Non-Identifying	1	
Station	Station_Filamp	Identifying	3	
Station_Filamp	Station_Filamp_PChannel	Identifying	4	
Sensor	Station_Sensor	Non-Identifying	1	
Station	Station_Sensor	Identifying	3	
Station_Sensor	Station_Sensor_Component	Identifying	4	

Relationship Detail Reports

Relationship: Datalogger to Datalogger_Board

Relationship Name	Dat_Boa_Dat	
Relationship Type	Identifying	
Parent Entity	Datalogger	
Child Entity	Datalogger_Board	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
data_id	data_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Station_Digitizer to Datalogger_Board

Relationship Name	Sta_Dig_Dat_Boa	
Relationship Type	Non-Specific	
Parent Entity	Station_Digitizer	
Child Entity	Datalogger_Board	
Cardinality		
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Datalogger_Board to Datalogger_Module

Relationship Name	Dat_Mod_Dat_Boa	
Relationship Type	Identifying	
Parent Entity	Datalogger_Board	
Child Entity	Datalogger_Module	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
data_id	data_id	 
board_nb	board_nb	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Filamp to Filamp_PChannel

Relationship Name	Fil_PCh_Fil	
Relationship Type	Identifying	
Parent Entity	Filamp	
Child Entity	Filamp_PChannel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
filamp_id	filamp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Response to Filamp_PChannel

Relationship Name	Fil_PCh_Res	
Relationship Type	Non-Specific	
Parent Entity	Response	
Child Entity	Filamp_PChannel	
Cardinality		
Existence	Optional	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Response to Filter

Relationship Name	Fil_Res	
Relationship Type	Non-Specific	
Parent Entity	Response	
Child Entity	Filter	
Cardinality		
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Filter_FIR to Filter_FIR_Data

Relationship Name	Fil_FIR_Dat_Fil_FIR	
Relationship Type	Identifying	
Parent Entity	Filter_FIR	
Child Entity	Filter_FIR_Data	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
fir_id	fir_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Filter to Filter_Sequence_Data

Relationship Name	Fil_Seq_Dat_Fil	
Relationship Type	Non-Identifying	
Parent Entity	Filter	
Child Entity	Filter_Sequence_Data	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
filter_id	filter_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Filter_Sequence to Filter_Sequence_Data

Relationship Name	Fil_Seq_Dat_Fil_Seq	
Relationship Type	Identifying	
Parent Entity	Filter_Sequence	
Child Entity	Filter_Sequence_Data	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
seqfil_id	seqfil_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Filter_FIR to Response

Relationship Name	Res_Fil_FIR	
Relationship Type	Non-Identifying	
Parent Entity	Filter_FIR	
Child Entity	Response	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
fir_id	resp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Response_HP to Response

Relationship Name	Res_Res_HP	
Relationship Type	Non-Identifying	
Parent Entity	Response_HP	
Child Entity	Response	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
hp_id	resp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Response_LP to Response

Relationship Name	Res_Res_LP	
Relationship Type	Non-Identifying	
Parent Entity	Response_LP	
Child Entity	Response	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
lp_id	resp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Response_PN to Response

Relationship Name	Res_Res_PN	
Relationship Type	Non-Identifying	
Parent Entity	Response_PN	
Child Entity	Response	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
pn_id	resp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Response_PZ to Response

Relationship Name	Res_Res_PZ	
Relationship Type	Non-Specific	
Parent Entity	Response_PZ	
Child Entity	Response	
Cardinality		
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Response_PN to Response_PN_Data

Relationship Name	Res_PN_Dat_Res_PN	
Relationship Type	Identifying	
Parent Entity	Response_PN	
Child Entity	Response_PN_Data	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
pn_id	pn_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Response to Sensor_Component

Relationship Name	Sen_Com_Res	
Relationship Type	Non-Specific	
Parent Entity	Response	
Child Entity	Sensor_Component	
Cardinality		
Existence	Optional	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Sensor to Sensor_Component

Relationship Name	Sen_Com_Sen	
Relationship Type	Identifying	
Parent Entity	Sensor	
Child Entity	Sensor_Component	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
sensor_id	sensor_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Datalogger to Station_Datalogger

Relationship Name	Sta_Dat_Dat	
Relationship Type	Non-Identifying	
Parent Entity	Datalogger	
Child Entity	Station_Datalogger	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
data_id	data_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Station to Station_Datalogger

Relationship Name	Sta_Dat_Sta	
Relationship Type	Identifying	
Parent Entity	Station	
Child Entity	Station_Datalogger	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Filter_Sequence to Station_Datalogger_LChannel

Relationship Name	Sta_Dat_LCh_Fil_Seq	
Relationship Type	Non-Identifying	
Parent Entity	Filter_Sequence	
Child Entity	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		
Relationship Keys 

Parent Key	Child Key	
seqfil_id	seqfil_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Station_Datalogger_PChannel to Station_Datalogger_LChannel

Relationship Name	Sta_Dat_LCh_Sta_Dat_PCh	
Relationship Type	Identifying	
Parent Entity	Station_Datalogger_PChannel	
Child Entity	Station_Datalogger_LChannel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
data_nb	data_nb	 
pchannel_nb	pchannel_nb	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Station_Datalogger to Station_Datalogger_PChannel

Relationship Name	Sta_Dat_PCh_Sta_Dat	
Relationship Type	Identifying	
Parent Entity	Station_Datalogger	
Child Entity	Station_Datalogger_PChannel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
data_nb	data_nb	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Station to Station_Digitizer

Relationship Name	Sta_Dig_Sta	
Relationship Type	Identifying	
Parent Entity	Station	
Child Entity	Station_Digitizer	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Station_Digitizer to Station_Digitizer_PChannel

Relationship Name	Sta_Dig_PCh_Sta_Dig	
Relationship Type	Identifying	
Parent Entity	Station_Digitizer	
Child Entity	Station_Digitizer_PChannel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
digi_nb	digi_nb	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Filamp to Station_Filamp

Relationship Name	Sta_Fil_Fil	
Relationship Type	Non-Identifying	
Parent Entity	Filamp	
Child Entity	Station_Filamp	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
filamp_id	filamp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Station to Station_Filamp

Relationship Name	Sta_Fil_Sta	
Relationship Type	Identifying	
Parent Entity	Station	
Child Entity	Station_Filamp	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Station_Filamp to Station_Filamp_PChannel

Relationship Name	Sta_Fil_PCh_Sta_Fil	
Relationship Type	Identifying	
Parent Entity	Station_Filamp	
Child Entity	Station_Filamp_PChannel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
filamp_nb	filamp_nb	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Sensor to Station_Sensor

Relationship Name	Sta_Sen_Sen	
Relationship Type	Non-Identifying	
Parent Entity	Sensor	
Child Entity	Station_Sensor	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
sensor_id	sensor_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Station to Station_Sensor

Relationship Name	Sta_Sen_Sta	
Relationship Type	Identifying	
Parent Entity	Station	
Child Entity	Station_Sensor	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Relationship: Station_Sensor to Station_Sensor_Component

Relationship Name	Sta_Sen_Com_Sta_Sen	
Relationship Type	Identifying	
Parent Entity	Station_Sensor	
Child Entity	Station_Sensor_Component	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
sensor_nb	sensor_nb	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None