Logical Design Dictionary

 NCEDC/TriNet Instrument Responses
Version 1.5.1

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

NCEDC/TriNet Instrument Responses

Diagram Name	NCEDC/TriNet Instrument Responses	
Description	NCEDC/Trinet Instrument Responses Schema ER Diagram	
Author	Stephane Zuzlewski	
Company	Berkeley Seismological Laboratory	
Version	1.5.1	
Copyright	NCEDC/TriNet	
Copyright Year	2002	

Logical

Model Name	Logical	
Database Platform	Logical	

Entity Summary Report

Entity Name	Entity Type	Primary Keys	 # Attr	
Channel_Comment	Dependent	net,sta,seedchan,location,ondate,comment_id	11	
Channel_Data	Dependent	net,sta,seedchan,location,ondate	24	
Coefficients	Dependent	net,sta,seedchan,location,ondate,stage_seq	14	
D_Abbreviation	Independent	id	2	
D_Comment	Independent	id	4	
D_Format	Independent	id	4	
D_Format_Data	Dependent	id,row_id	3	
D_Unit	Independent	id	3	
DC	Independent	key	5	
DC_Data	Dependent	key,row_key	5	
Decimation	Dependent	net,sta,seedchan,location,ondate,stage_seq	11	
DM	Independent	key	8	
PN	Independent	key	7	
PN_Data	Dependent	key,row_key	3	
Poles_Zeros	Dependent	net,sta,seedchan,location,ondate,stage_seq	16	
Polynomial	Dependent	net,sta,seedchan,location,ondate,stage_seq	14	
PZ	Independent	key	3	
PZ_Data	Dependent	key,row_key	7	
Sensitivity	Dependent	net,sta,seedchan,location,ondate,stage_seq	12	
Simple_Response	Dependent	net,sta,seedchan,location,ondate	16	
Station_Comment	Dependent	net,sta,ondate,comment_id	7	
Station_Data	Independent	net,sta,ondate	12	

Entity Detail Reports

Channel_Comment

Entity Name	Channel_Comment	
Owner Name		
Entity Type	Dependent	
Primary Keys	net,sta,seedchan,location,ondate,comment_id	
Definition	Comments for a channel	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR(3)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	 
location		VARCHAR(2)	N	Describes the individual sites on an array station, operated by the same network operator	 
ondate		DATE	N	This attribute denotes the start date	 
comment_id		NUMERIC(8, 0)	N	The comment code key of the associated Comment Description Dictionary	 
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, etc.)	 
offdate		DATE	Y	This attribute denotes the end date	 
comment_level		NUMERIC(8, 0)	N	The numeric value (if any) associated with the Units of comment level in the same Comment Description Dictionary. Together, this numeric value, its units, and the Description of comment of the associated Comment Description, all describe a comment for the station/channel	 
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)	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Channel_Data	Channel_Comment	Identifying	Cha_Com_Cha_Dat	 
D_Comment	Channel_Comment	Identifying	Cha_Com_D_Com	 

net

Attribute Name	net	Entity Name	Channel_Comment	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

sta

Attribute Name	sta	Entity Name	Channel_Comment	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

seedchan

Attribute Name	seedchan	Entity Name	Channel_Comment	
Logical Role Name	seedchan	
Role Name	seedchan	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

location

Attribute Name	location	Entity Name	Channel_Comment	
Logical Role Name	location	
Role Name	location	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Channel_Comment	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

comment_id

Attribute Name	id	Entity Name	Channel_Comment	
Logical Role Name	comment_id	
Role Name	comment_id	
Primary Key	YES	
Foreign Key	YES	Parent Entity	D_Comment	
Definition 

The comment code key of the associated Comment Description Dictionary	
Logical Column Properties 

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

channel

Attribute Name	channel	Entity Name	Channel_Comment	
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	Channel_Comment	
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, etc.)	
Logical Column Properties 

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

offdate

Attribute Name	offdate	Entity Name	Channel_Comment	
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	

comment_level

Attribute Name	comment_level	Entity Name	Channel_Comment	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The numeric value (if any) associated with the Units of comment level in the same Comment Description Dictionary. Together, this numeric value, its units, and the Description of comment of the associated Comment Description, all describe a comment for the station/channel	
Logical Column Properties 

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

lddate

Attribute Name	lddate	Entity Name	Channel_Comment	
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	

Channel_Data

Entity Name	Channel_Data	
Owner Name		
Entity Type	Dependent	
Primary Keys	net,sta,seedchan,location,ondate	
Definition	Summary information on a channel	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR(3)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	 
location		VARCHAR(2)	N	Describes the individual sites on an array station, operated by the same network operator	 
ondate		DATE	N	This attribute denotes the start date	 
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, etc.)	 
inid		NUMERIC(8, 0)	Y	Instrument identifier. It refers to the Generic Abbreviation Dictionary, that contains a name for this instrument	 
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	 
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	 
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	 
azimuth		FLOAT	Y	The azimuth of the instrument from north, clockwise	 
dip		FLOAT	Y	The dip of the instrument, down from horizontal	 
format_id		NUMERIC(8, 0)	N	A data format lookup key that refers to the Data Format Dictionary that describes the format of the data in the data section for this channel	 
record_length		NUMERIC(8, 0)	Y	The exponent (as a power of two) of the record length for these data	 
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	 
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	ChD01	azimuth >= 0.0 AND azimuth <= 360.0	 
	Check	ChD02	clock_drift >= 0.0	 
	Check	ChD03	dip >= -90.0 AND dip <= 90.0	 
	Check	ChD04	edepth >= 0.0	 
	Check	ChD06	lat >= -90.0 AND lat <= 90.0	 
	Check	ChD07	lon >= -180.0 AND lon <= 180.0	 
	Check	ChD08	record_length >= 8 AND record_length <= 12	 
	Check	ChD09	samprate >= 0.0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
D_Abbreviation	Channel_Data	Non-Identifying	Cha_Dat_D_Abb	 
D_Format	Channel_Data	Non-Identifying	Cha_Dat_D_For	 
D_Unit	Channel_Data	Non-Identifying	Cha_Dat_D_Uni	 
D_Unit	Channel_Data	Non-Identifying	Cha_Dat_D_Uni2	 
Station_Data	Channel_Data	Identifying	Cha_Dat_Sta_Dat	 
Channel_Data	Channel_Comment	Identifying	Cha_Com_Cha_Dat	 
Channel_Data	Coefficients	Identifying	Coe_Cha_Dat	 
Channel_Data	Decimation	Identifying	Dec_Cha_Dat	 
Channel_Data	Polynomial	Identifying	Pol_Cha_Dat	 
Channel_Data	Poles_Zeros	Identifying	Pol_Zer_Cha_Dat	 
Channel_Data	Sensitivity	Identifying	Sen_Cha_Dat	 
Channel_Data	Simple_Response	Identifying	Sim_Res_Cha_Dat	 

net

Attribute Name	net	Entity Name	Channel_Data	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Data	
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	

sta

Attribute Name	sta	Entity Name	Channel_Data	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Data	
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	

seedchan

Attribute Name	seedchan	Entity Name	Channel_Data	
Logical Role Name		
Role Name		
Primary Key	YES	
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	NO	
Identity	NO	

location

Attribute Name	location	Entity Name	Channel_Data	
Logical Role Name		
Role Name		
Primary Key	YES	
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	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Channel_Data	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Data	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

channel

Attribute Name	channel	Entity Name	Channel_Data	
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	Channel_Data	
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, etc.)	
Logical Column Properties 

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

inid

Attribute Name	id	Entity Name	Channel_Data	
Logical Role Name	inid	
Role Name	inid	
Primary Key	NO	
Foreign Key	YES	Parent Entity	D_Abbreviation	
Definition 

Instrument identifier. It refers to the Generic Abbreviation Dictionary, that contains a name for this instrument	
Logical Column Properties 

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

remark

Attribute Name	remark	Entity Name	Channel_Data	
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	

unit_signal

Attribute Name	id	Entity Name	Channel_Data	
Logical Role Name	unit_signal	
Role Name	unit_signal	
Primary Key	NO	
Foreign Key	YES	Parent Entity	D_Unit	
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	id	Entity Name	Channel_Data	
Logical Role Name	unit_calib	
Role Name	unit_calib	
Primary Key	NO	
Foreign Key	YES	Parent Entity	D_Unit	
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	

lat

Attribute Name	lat	Entity Name	Channel_Data	
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	Channel_Data	
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	Channel_Data	
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	Channel_Data	
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	

azimuth

Attribute Name	azimuth	Entity Name	Channel_Data	
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	Channel_Data	
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	

format_id

Attribute Name	id	Entity Name	Channel_Data	
Logical Role Name	format_id	
Role Name	format_id	
Primary Key	NO	
Foreign Key	YES	Parent Entity	D_Format	
Definition 

A data format lookup key that refers to the Data Format Dictionary that describes the format of the data in the data section for this channel	
Logical Column Properties 

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

record_length

Attribute Name	record_length	Entity Name	Channel_Data	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The exponent (as a power of two) of the record length for these data	
Logical Column Properties 

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

samprate

Attribute Name	samprate	Entity Name	Channel_Data	
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	Channel_Data	
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	Channel_Data	
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	

offdate

Attribute Name	offdate	Entity Name	Channel_Data	
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	Channel_Data	
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	

Coefficients

Entity Name	Coefficients	
Owner Name		
Entity Type	Dependent	
Primary Keys	net,sta,seedchan,location,ondate,stage_seq	
Definition	Data associating a channel with a response	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR(3)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	 
location		VARCHAR(2)	N	Describes the individual sites on an array station, operated by the same network operator	 
ondate		DATE	N	This attribute denotes the start date	 
stage_seq		NUMERIC(8, 0)	N	This attribute denotes the stage number	 
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, etc.)	 
offdate		DATE	Y	This attribute denotes the end date	 
dc_key		NUMERIC(8, 0)	Y	Response (Coefficients) key	 
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	 
tf_type		VARCHAR(1)	Y	A single character describing the type of stage	 
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	Co01	stage_seq >= 0	 
	Check	Co02	tf_type IN ('A','B','C','D','P')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Channel_Data	Coefficients	Identifying	Coe_Cha_Dat	 
D_Unit	Coefficients	Non-Identifying	Coe_D_Uni	 
D_Unit	Coefficients	Non-Identifying	Coe_D_Uni2	 
DC	Coefficients	Non-Identifying	Coe_DC	 

net

Attribute Name	net	Entity Name	Coefficients	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

sta

Attribute Name	sta	Entity Name	Coefficients	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

seedchan

Attribute Name	seedchan	Entity Name	Coefficients	
Logical Role Name	seedchan	
Role Name	seedchan	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

location

Attribute Name	location	Entity Name	Coefficients	
Logical Role Name	location	
Role Name	location	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Coefficients	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

stage_seq

Attribute Name	stage_seq	Entity Name	Coefficients	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the stage number	
Logical Column Properties 

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

channel

Attribute Name	channel	Entity Name	Coefficients	
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	Coefficients	
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, etc.)	
Logical Column Properties 

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

offdate

Attribute Name	offdate	Entity Name	Coefficients	
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	

dc_key

Attribute Name	key	Entity Name	Coefficients	
Logical Role Name	dc_key	
Role Name	dc_key	
Primary Key	NO	
Foreign Key	YES	Parent Entity	DC	
Definition 

Response (Coefficients) key	
Logical Column Properties 

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

unit_in

Attribute Name	id	Entity Name	Coefficients	
Logical Role Name	unit_in	
Role Name	unit_in	
Primary Key	NO	
Foreign Key	YES	Parent Entity	D_Unit	
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	id	Entity Name	Coefficients	
Logical Role Name	unit_out	
Role Name	unit_out	
Primary Key	NO	
Foreign Key	YES	Parent Entity	D_Unit	
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	

tf_type

Attribute Name	tf_type	Entity Name	Coefficients	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

A single character describing the type of stage	
Logical Column Properties 

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

lddate

Attribute Name	lddate	Entity Name	Coefficients	
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	

D_Abbreviation

Entity Name	D_Abbreviation	
Owner Name		
Entity Type	Independent	
Primary Keys	id	
Definition	Abbreviation dictionary	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
id		NUMERIC(8, 0)	N	A cross reference code to indicate this particular dictionary entry	 
description		VARCHAR(70)	Y	This is a description of an abbreviation	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
D_Abbreviation	Channel_Data	Non-Identifying	Cha_Dat_D_Abb	 
D_Abbreviation	Station_Data	Non-Identifying	Sta_Dat_D_Abb	 

id

Attribute Name	id	Entity Name	D_Abbreviation	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

A cross reference code to indicate this particular dictionary entry	
Logical Column Properties 

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

description

Attribute Name	description	Entity Name	D_Abbreviation	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This is a description of an abbreviation	
Logical Column Properties 

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

D_Comment

Entity Name	D_Comment	
Owner Name		
Entity Type	Independent	
Primary Keys	id	
Definition	Comment dictionary	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
id		NUMERIC(8, 0)	N	A cross reference code to indicate this particular dictionary entry	 
class		VARCHAR(1)	N	A single letter that determines to what the code refers	 
description		VARCHAR(70)	Y	This is a description of a comment	 
unit		NUMERIC(8, 0)	N	Units of comment level	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
D_Comment	Channel_Comment	Identifying	Cha_Com_D_Com	 
D_Comment	Station_Comment	Identifying	Sta_Com_D_Com	 

id

Attribute Name	id	Entity Name	D_Comment	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

A cross reference code to indicate this particular dictionary entry	
Logical Column Properties 

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

class

Attribute Name	class	Entity Name	D_Comment	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

A single letter that determines to what the code refers	
Logical Column Properties 

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

description

Attribute Name	description	Entity Name	D_Comment	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This is a description of a comment	
Logical Column Properties 

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

unit

Attribute Name	unit	Entity Name	D_Comment	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Units of comment level	
Logical Column Properties 

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

D_Format

Entity Name	D_Format	
Owner Name		
Entity Type	Independent	
Primary Keys	id	
Definition	Format dictionary	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
id		NUMERIC(8, 0)	N	A cross reference code to indicate this particular dictionary entry	 
name		VARCHAR(80)	Y	Descriptive name	 
family		NUMERIC(8, 0)	N	This field is used by the data decoder to describe the data family type. It tells a potential program what general algorithm to use to decode the associated data. Each algorithm requires some number of decoder keys that contain special additional information, enabling the algorithm to decode the data	 
ms_id		NUMERIC(8, 0)	N	This attribute denotes a code indicating the encoding format. This number is assigned by the FDSN Data Exchange Working Group	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
D_Format	Channel_Data	Non-Identifying	Cha_Dat_D_For	 
D_Format	D_Format_Data	Identifying	D_For_Dat_D_For	 

id

Attribute Name	id	Entity Name	D_Format	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

A cross reference code to indicate this particular dictionary entry	
Logical Column Properties 

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

name

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

Descriptive name	
Logical Column Properties 

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

family

Attribute Name	family	Entity Name	D_Format	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This field is used by the data decoder to describe the data family type. It tells a potential program what general algorithm to use to decode the associated data. Each algorithm requires some number of decoder keys that contain special additional information, enabling the algorithm to decode the data	
Logical Column Properties 

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

ms_id

Attribute Name	ms_id	Entity Name	D_Format	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a code indicating the encoding format. This number is assigned by the FDSN Data Exchange Working Group	
Logical Column Properties 

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

D_Format_Data

Entity Name	D_Format_Data	
Owner Name		
Entity Type	Dependent	
Primary Keys	id,row_id	
Definition	Format data	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
id		NUMERIC(8, 0)	N	A cross reference code to indicate this particular dictionary entry	 
row_id		NUMERIC(8, 0)	N	Row identifier for the decoder keys	 
key_d		VARCHAR(80)	N	This attribute denotes the decoder keys used by the data family type	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	D_F_D01	row_id >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
D_Format	D_Format_Data	Identifying	D_For_Dat_D_For	 

id

Attribute Name	id	Entity Name	D_Format_Data	
Logical Role Name	id	
Role Name	id	
Primary Key	YES	
Foreign Key	YES	Parent Entity	D_Format	
Definition 

A cross reference code to indicate this particular dictionary entry	
Logical Column Properties 

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

row_id

Attribute Name	row_id	Entity Name	D_Format_Data	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Row identifier for the decoder keys	
Logical Column Properties 

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

key_d

Attribute Name	key_d	Entity Name	D_Format_Data	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the decoder keys used by the data family type	
Logical Column Properties 

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

D_Unit

Entity Name	D_Unit	
Owner Name		
Entity Type	Independent	
Primary Keys	id	
Definition	Unit dictionary	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
id		NUMERIC(8, 0)	N	A cross reference code to indicate this particular dictionary entry	 
name		VARCHAR(80)	Y	Descriptive name	 
description		VARCHAR(70)	Y	This is a description of a unit	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
D_Unit	Channel_Data	Non-Identifying	Cha_Dat_D_Uni	 
D_Unit	Channel_Data	Non-Identifying	Cha_Dat_D_Uni2	 
D_Unit	Coefficients	Non-Identifying	Coe_D_Uni	 
D_Unit	Coefficients	Non-Identifying	Coe_D_Uni2	 
D_Unit	Polynomial	Non-Identifying	Pol_D_Uni	 
D_Unit	Polynomial	Non-Identifying	Pol_D_Uni2	 
D_Unit	Poles_Zeros	Non-Identifying	Pol_Zer_D_Uni	 
D_Unit	Poles_Zeros	Non-Identifying	Pol_Zer_D_Uni2	 

id

Attribute Name	id	Entity Name	D_Unit	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

A cross reference code to indicate this particular dictionary entry	
Logical Column Properties 

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

name

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

Descriptive name	
Logical Column Properties 

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

description

Attribute Name	description	Entity Name	D_Unit	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This is a description of a unit	
Logical Column Properties 

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

DC

Entity Name	DC	
Owner Name		
Entity Type	Independent	
Primary Keys	key	
Definition	Summary information on a response (Coefficients)	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
key		NUMERIC(8, 0)	N	This attribute denotes a unique identifier for a response (digital coefficients)	 
name		VARCHAR(80)	Y	Descriptive name	 
symmetry		VARCHAR(1)	Y	This attribute denotes the eventual symmetry of a response	 
storage		VARCHAR(1)	Y	This attribute denotes if half or all the coefficients are stored in the DC_Data table	 
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	DC01	dcstorage IN ('H','F')	 
	Check	DC02	symmetry IN ('E','O','N')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
DC	Coefficients	Non-Identifying	Coe_DC	 
DC	DC_Data	Identifying	DC_Dat_DC	 

key

Attribute Name	key	Entity Name	DC	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a unique identifier for a response (digital coefficients)	
Logical Column Properties 

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

name

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

Descriptive name	
Logical Column Properties 

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

symmetry

Attribute Name	symmetry	Entity Name	DC	
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	YES	
Identity	NO	

storage

Attribute Name	storage	Entity Name	DC	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes if half or all the coefficients are stored in the DC_Data table	
Logical Column Properties 

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

lddate

Attribute Name	lddate	Entity Name	DC	
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	

DC_Data

Entity Name	DC_Data	
Owner Name		
Entity Type	Dependent	
Primary Keys	key,row_key	
Definition	Coefficients of a response	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
key		NUMERIC(8, 0)	N	This attribute denotes a unique identifier for a response (digital coefficients)	 
row_key		NUMERIC(8, 0)	N	Row key for responses	 
type		VARCHAR(1)	Y	This attribute denotes whether a value is associated with a numerator/denominator	 
coefficient		FLOAT	N	The numerator/denominator coefficient value	 
error		FLOAT	Y	This attribute denotes the numerator/denominator error	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	DCD01	row_key >= 0	 
	Check	DCD02	type IN ('P','Z','N','D')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
DC	DC_Data	Identifying	DC_Dat_DC	 

key

Attribute Name	key	Entity Name	DC_Data	
Logical Role Name	key	
Role Name	key	
Primary Key	YES	
Foreign Key	YES	Parent Entity	DC	
Definition 

This attribute denotes a unique identifier for a response (digital coefficients)	
Logical Column Properties 

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

row_key

Attribute Name	row_key	Entity Name	DC_Data	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Row key for responses	
Logical Column Properties 

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

type

Attribute Name	type	Entity Name	DC_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	YES	
Identity	NO	

coefficient

Attribute Name	coefficient	Entity Name	DC_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	DC_Data	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the numerator/denominator error	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

Decimation

Entity Name	Decimation	
Owner Name		
Entity Type	Dependent	
Primary Keys	net,sta,seedchan,location,ondate,stage_seq	
Definition	Data associating a channel with a decimation	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR(3)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	 
location		VARCHAR(2)	N	Describes the individual sites on an array station, operated by the same network operator	 
ondate		DATE	N	This attribute denotes the start date	 
stage_seq		NUMERIC(8, 0)	N	This attribute denotes the stage number	 
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, etc.)	 
offdate		DATE	Y	This attribute denotes the end date	 
dm_key		NUMERIC(8, 0)	N	Decimation key	 
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	De01	stage_seq >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Channel_Data	Decimation	Identifying	Dec_Cha_Dat	 
DM	Decimation	Non-Identifying	Dec_DM	 

net

Attribute Name	net	Entity Name	Decimation	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

sta

Attribute Name	sta	Entity Name	Decimation	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

seedchan

Attribute Name	seedchan	Entity Name	Decimation	
Logical Role Name	seedchan	
Role Name	seedchan	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

location

Attribute Name	location	Entity Name	Decimation	
Logical Role Name	location	
Role Name	location	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Decimation	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

stage_seq

Attribute Name	stage_seq	Entity Name	Decimation	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the stage number	
Logical Column Properties 

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

channel

Attribute Name	channel	Entity Name	Decimation	
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	Decimation	
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, etc.)	
Logical Column Properties 

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

offdate

Attribute Name	offdate	Entity Name	Decimation	
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	

dm_key

Attribute Name	key	Entity Name	Decimation	
Logical Role Name	dm_key	
Role Name	dm_key	
Primary Key	NO	
Foreign Key	YES	Parent Entity	DM	
Definition 

Decimation key	
Logical Column Properties 

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

lddate

Attribute Name	lddate	Entity Name	Decimation	
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	

DM

Entity Name	DM	
Owner Name		
Entity Type	Independent	
Primary Keys	key	
Definition	Summary information on a decimation	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
key		NUMERIC(8, 0)	N	This attribute denotes a unique identifier for a decimation	 
name		VARCHAR(80)	Y	Descriptive name	 
samprate		FLOAT	N	Sampling rate. This attribute is the sample rate in samples/second	 
factor		NUMERIC(8, 0)	N	The decimation factor. When this number of samples are read in, one final sample comes out. The output sample rate can be calculated by dividing samprate by the decimation factor	 
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 stage	 
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	 
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	DM01	offset >= 0.0	 
	Check	DM02	samprate >= 0.0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
DM	Decimation	Non-Identifying	Dec_DM	 

key

Attribute Name	key	Entity Name	DM	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a unique identifier for a decimation	
Logical Column Properties 

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

name

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

Descriptive name	
Logical Column Properties 

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

samprate

Attribute Name	samprate	Entity Name	DM	
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	

factor

Attribute Name	factor	Entity Name	DM	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The decimation factor. When this number of samples are read in, one final sample comes out. The output sample rate can be calculated by dividing samprate by the decimation factor	
Logical Column Properties 

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

offset

Attribute Name	offset	Entity Name	DM	
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	DM	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The estimated pure delay for the stage	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

correction

Attribute Name	correction	Entity Name	DM	
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	

lddate

Attribute Name	lddate	Entity Name	DM	
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	

PN

Entity Name	PN	
Owner Name		
Entity Type	Independent	
Primary Keys	key	
Definition	Summary information on a response (Polynomial)	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
key		NUMERIC(8, 0)	N	This attribute denotes a unique identifier for a response (poles & zeros)	 
name		VARCHAR(80)	Y	Descriptive name	 
poly_type		VARCHAR(1)	Y	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	 
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	PN01	poly_type IN ('C','L','M')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
PN	PN_Data	Identifying	PN_Data_PN	 
PN	Polynomial	Non-Identifying	Pol_PN	 

key

Attribute Name	key	Entity Name	PN	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a unique identifier for a response (poles & zeros)	
Logical Column Properties 

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

name

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

Descriptive name	
Logical Column Properties 

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

poly_type

Attribute Name	poly_type	Entity Name	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	YES	
Identity	NO	

lower_bound

Attribute Name	lower_bound	Entity Name	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	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	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	

lddate

Attribute Name	lddate	Entity Name	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	

PN_Data

Entity Name	PN_Data	
Owner Name		
Entity Type	Dependent	
Primary Keys	key,row_key	
Definition	Coefficients of a polynomial	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
key		NUMERIC(8, 0)	N	This attribute denotes a unique identifier for a response (poles & zeros)	 
row_key		NUMERIC(8, 0)	N	Row key for responses	 
pn_value		FLOAT	Y	This attribute denotes the coefficient value of a polynomial	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	PND01	row_key >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
PN	PN_Data	Identifying	PN_Data_PN	 

key

Attribute Name	key	Entity Name	PN_Data	
Logical Role Name	key	
Role Name	key	
Primary Key	YES	
Foreign Key	YES	Parent Entity	PN	
Definition 

This attribute denotes a unique identifier for a response (poles & zeros)	
Logical Column Properties 

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

row_key

Attribute Name	row_key	Entity Name	PN_Data	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Row key for responses	
Logical Column Properties 

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

pn_value

Attribute Name	pn_value	Entity Name	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	YES	
Identity	NO	

Poles_Zeros

Entity Name	Poles_Zeros	
Owner Name		
Entity Type	Dependent	
Primary Keys	net,sta,seedchan,location,ondate,stage_seq	
Definition	Data associating a channel with poles & zeros	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR(3)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	 
location		VARCHAR(2)	N	Describes the individual sites on an array station, operated by the same network operator	 
ondate		DATE	N	This attribute denotes the start date	 
stage_seq		NUMERIC(8, 0)	N	This attribute denotes the stage number	 
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, etc.)	 
offdate		DATE	Y	This attribute denotes the end date	 
pz_key		NUMERIC(8, 0)	N	Response (Poles & zeros) key	 
tf_type		VARCHAR(1)	Y	A single character describing the type of stage	 
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	 
AO		FLOAT	N	This field is mandatory and must be set such that when the polynomial is evaluated at the reference frequency the result will be 1	 
AF		FLOAT	Y	Frequency fn, at which the value in field AO is normalized (if any)	 
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	P_Z01	AF >= 0.0	 
	Check	P_Z02	stage_seq >= 0	 
	Check	P_Z03	tf_type IN ('A','B','C','D','P')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Channel_Data	Poles_Zeros	Identifying	Pol_Zer_Cha_Dat	 
D_Unit	Poles_Zeros	Non-Identifying	Pol_Zer_D_Uni	 
D_Unit	Poles_Zeros	Non-Identifying	Pol_Zer_D_Uni2	 
PZ	Poles_Zeros	Non-Identifying	Pol_Zer_PZ	 

net

Attribute Name	net	Entity Name	Poles_Zeros	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

sta

Attribute Name	sta	Entity Name	Poles_Zeros	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

seedchan

Attribute Name	seedchan	Entity Name	Poles_Zeros	
Logical Role Name	seedchan	
Role Name	seedchan	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

location

Attribute Name	location	Entity Name	Poles_Zeros	
Logical Role Name	location	
Role Name	location	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Poles_Zeros	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

stage_seq

Attribute Name	stage_seq	Entity Name	Poles_Zeros	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the stage number	
Logical Column Properties 

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

channel

Attribute Name	channel	Entity Name	Poles_Zeros	
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	Poles_Zeros	
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, etc.)	
Logical Column Properties 

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

offdate

Attribute Name	offdate	Entity Name	Poles_Zeros	
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	

pz_key

Attribute Name	key	Entity Name	Poles_Zeros	
Logical Role Name	pz_key	
Role Name	pz_key	
Primary Key	NO	
Foreign Key	YES	Parent Entity	PZ	
Definition 

Response (Poles & zeros) key	
Logical Column Properties 

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

tf_type

Attribute Name	tf_type	Entity Name	Poles_Zeros	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

A single character describing the type of stage	
Logical Column Properties 

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

unit_in

Attribute Name	id	Entity Name	Poles_Zeros	
Logical Role Name	unit_in	
Role Name	unit_in	
Primary Key	NO	
Foreign Key	YES	Parent Entity	D_Unit	
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	id	Entity Name	Poles_Zeros	
Logical Role Name	unit_out	
Role Name	unit_out	
Primary Key	NO	
Foreign Key	YES	Parent Entity	D_Unit	
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	

AO

Attribute Name	AO	Entity Name	Poles_Zeros	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This field is mandatory and must be set such that when the polynomial is evaluated at the reference frequency the result will be 1	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

AF

Attribute Name	AF	Entity Name	Poles_Zeros	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Frequency fn, at which the value in field AO is normalized (if any)	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Poles_Zeros	
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	

Polynomial

Entity Name	Polynomial	
Owner Name		
Entity Type	Dependent	
Primary Keys	net,sta,seedchan,location,ondate,stage_seq	
Definition	Data associating a channel with a polynomial	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR(3)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	 
location		VARCHAR(2)	N	Describes the individual sites on an array station, operated by the same network operator	 
ondate		DATE	N	This attribute denotes the start date	 
stage_seq		NUMERIC(8, 0)	N	This attribute denotes the stage number	 
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, etc.)	 
offdate		DATE	Y	This attribute denotes the end date	 
pn_key		NUMERIC(8, 0)	N	Response (Polynomial) key	 
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	 
tf_type		VARCHAR(1)	Y	A single character describing the type of stage	 
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	Po01	stage_seq >= 0	 
	Check	Po02	tf_type IN ('A','B','C','D','P')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Channel_Data	Polynomial	Identifying	Pol_Cha_Dat	 
D_Unit	Polynomial	Non-Identifying	Pol_D_Uni	 
D_Unit	Polynomial	Non-Identifying	Pol_D_Uni2	 
PN	Polynomial	Non-Identifying	Pol_PN	 

net

Attribute Name	net	Entity Name	Polynomial	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

sta

Attribute Name	sta	Entity Name	Polynomial	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

seedchan

Attribute Name	seedchan	Entity Name	Polynomial	
Logical Role Name	seedchan	
Role Name	seedchan	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

location

Attribute Name	location	Entity Name	Polynomial	
Logical Role Name	location	
Role Name	location	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Polynomial	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

stage_seq

Attribute Name	stage_seq	Entity Name	Polynomial	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the stage number	
Logical Column Properties 

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

channel

Attribute Name	channel	Entity Name	Polynomial	
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	Polynomial	
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, etc.)	
Logical Column Properties 

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

offdate

Attribute Name	offdate	Entity Name	Polynomial	
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	

pn_key

Attribute Name	key	Entity Name	Polynomial	
Logical Role Name	pn_key	
Role Name	pn_key	
Primary Key	NO	
Foreign Key	YES	Parent Entity	PN	
Definition 

Response (Polynomial) key	
Logical Column Properties 

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

unit_in

Attribute Name	id	Entity Name	Polynomial	
Logical Role Name	unit_in	
Role Name	unit_in	
Primary Key	NO	
Foreign Key	YES	Parent Entity	D_Unit	
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	id	Entity Name	Polynomial	
Logical Role Name	unit_out	
Role Name	unit_out	
Primary Key	NO	
Foreign Key	YES	Parent Entity	D_Unit	
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	

tf_type

Attribute Name	tf_type	Entity Name	Polynomial	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

A single character describing the type of stage	
Logical Column Properties 

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

lddate

Attribute Name	lddate	Entity Name	Polynomial	
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	

PZ

Entity Name	PZ	
Owner Name		
Entity Type	Independent	
Primary Keys	key	
Definition	Summary information on a response (Poles & Zeros)	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
key		NUMERIC(8, 0)	N	This attribute denotes a unique identifier for a response (poles & zeros)	 
name		VARCHAR(80)	Y	Descriptive name	 
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)	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
PZ	Poles_Zeros	Non-Identifying	Pol_Zer_PZ	 
PZ	PZ_Data	Identifying	PZ_Dat_PZ	 

key

Attribute Name	key	Entity Name	PZ	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes a unique identifier for a response (poles & zeros)	
Logical Column Properties 

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

name

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

Descriptive name	
Logical Column Properties 

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

lddate

Attribute Name	lddate	Entity Name	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	

PZ_Data

Entity Name	PZ_Data	
Owner Name		
Entity Type	Dependent	
Primary Keys	key,row_key	
Definition	Poles & zeros of a response	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
key		NUMERIC(8, 0)	N	This attribute denotes a unique identifier for a response (poles & zeros)	 
row_key		NUMERIC(8, 0)	N	Row key for responses	 
type		VARCHAR(1)	Y	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	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	PZD01	row_key >= 0	 
	Check	PZD02	type IN ('P','Z','N','D')	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
PZ	PZ_Data	Identifying	PZ_Dat_PZ	 

key

Attribute Name	key	Entity Name	PZ_Data	
Logical Role Name	key	
Role Name	key	
Primary Key	YES	
Foreign Key	YES	Parent Entity	PZ	
Definition 

This attribute denotes a unique identifier for a response (poles & zeros)	
Logical Column Properties 

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

row_key

Attribute Name	row_key	Entity Name	PZ_Data	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Row key for responses	
Logical Column Properties 

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

type

Attribute Name	type	Entity Name	PZ_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 pole/zero	
Logical Column Properties 

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

r_value

Attribute Name	r_value	Entity Name	PZ_Data	
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	PZ_Data	
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	PZ_Data	
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	PZ_Data	
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	

Sensitivity

Entity Name	Sensitivity	
Owner Name		
Entity Type	Dependent	
Primary Keys	net,sta,seedchan,location,ondate,stage_seq	
Definition	Data associating a channel with a sensitivity	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR(3)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	 
location		VARCHAR(2)	N	Describes the individual sites on an array station, operated by the same network operator	 
ondate		DATE	N	This attribute denotes the start date	 
stage_seq		NUMERIC(8, 0)	N	This attribute denotes the stage number	 
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, etc.)	 
offdate		DATE	Y	This attribute denotes the end date	 
sensitivity		FLOAT	N	The gain (Sd) at this stage, or the sensitivity (Sd) for the channel	 
frequency		FLOAT	Y	The frequency (fs) at which the value in sensitivity 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	Se01	frequency >= 0.0	 
	Check	Se02	stage_seq >= 0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Channel_Data	Sensitivity	Identifying	Sen_Cha_Dat	 

net

Attribute Name	net	Entity Name	Sensitivity	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

sta

Attribute Name	sta	Entity Name	Sensitivity	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

seedchan

Attribute Name	seedchan	Entity Name	Sensitivity	
Logical Role Name	seedchan	
Role Name	seedchan	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

location

Attribute Name	location	Entity Name	Sensitivity	
Logical Role Name	location	
Role Name	location	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Sensitivity	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

stage_seq

Attribute Name	stage_seq	Entity Name	Sensitivity	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the stage number	
Logical Column Properties 

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

channel

Attribute Name	channel	Entity Name	Sensitivity	
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	Sensitivity	
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, etc.)	
Logical Column Properties 

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

offdate

Attribute Name	offdate	Entity Name	Sensitivity	
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	

sensitivity

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

The gain (Sd) at this stage, or the sensitivity (Sd) for the channel	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	NO	
Identity	NO	

frequency

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

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

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Sensitivity	
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	

Simple_Response

Entity Name	Simple_Response	
Owner Name		
Entity Type	Dependent	
Primary Keys	net,sta,seedchan,location,ondate	
Definition	Summary information on a simplified response	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR(3)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	 
location		VARCHAR(2)	N	Describes the individual sites on an array station, operated by the same network operator	 
ondate		DATE	N	This attribute denotes the start date	 
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, etc.)	 
natural_frequency		FLOAT	Y	Natural frequency	 
damping_constant		FLOAT	Y	This attribute denotes the damping constant of the system	 
gain		FLOAT	Y	This attribute denotes the gain of the system. The units of the gain are given by the gain_units attribute	 
gain_units		VARCHAR(20)	Y	This attribute denotes the units of the gain of the system, as given by the gain attribute	 
low_freq_corner		FLOAT	Y	Low frequency corner	 
high_freq_corner		FLOAT	Y	High frequency corner	 
offdate		DATE	Y	This attribute denotes the end date	 
dlogsens		NUMERIC(8, 0)	Y	Digitizer sensitivity	 
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	SiRe01	natural_frequency >= 0.0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Channel_Data	Simple_Response	Identifying	Sim_Res_Cha_Dat	 

net

Attribute Name	net	Entity Name	Simple_Response	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

sta

Attribute Name	sta	Entity Name	Simple_Response	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	

seedchan

Attribute Name	seedchan	Entity Name	Simple_Response	
Logical Role Name	seedchan	
Role Name	seedchan	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

location

Attribute Name	location	Entity Name	Simple_Response	
Logical Role Name	location	
Role Name	location	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
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	NO	
Identity	NO	

ondate

Attribute Name	ondate	Entity Name	Simple_Response	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Channel_Data	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

channel

Attribute Name	channel	Entity Name	Simple_Response	
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	Simple_Response	
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, etc.)	
Logical Column Properties 

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

natural_frequency

Attribute Name	natural_frequency	Entity Name	Simple_Response	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Natural frequency	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

damping_constant

Attribute Name	damping_constant	Entity Name	Simple_Response	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the damping constant of the system	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

gain

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

This attribute denotes the gain of the system. The units of the gain are given by the gain_units attribute	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

gain_units

Attribute Name	gain_units	Entity Name	Simple_Response	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the units of the gain of the system, as given by the gain attribute	
Logical Column Properties 

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

low_freq_corner

Attribute Name	low_freq_corner	Entity Name	Simple_Response	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Low frequency corner	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

high_freq_corner

Attribute Name	high_freq_corner	Entity Name	Simple_Response	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

High frequency corner	
Logical Column Properties 

Data Type	FLOAT	Width		Scale		
Nullable	YES	
Identity	NO	

offdate

Attribute Name	offdate	Entity Name	Simple_Response	
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	

dlogsens

Attribute Name	dlogsens	Entity Name	Simple_Response	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Digitizer sensitivity	
Logical Column Properties 

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

lddate

Attribute Name	lddate	Entity Name	Simple_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	

Station_Comment

Entity Name	Station_Comment	
Owner Name		
Entity Type	Dependent	
Primary Keys	net,sta,ondate,comment_id	
Definition	Comments for a station	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
ondate		DATE	N	This attribute denotes the start date	 
comment_id		NUMERIC(8, 0)	N	The comment code key of the associated Comment Description Dictionary	 
offdate		DATE	Y	This attribute denotes the end date	 
comment_level		NUMERIC(8, 0)	Y	The numeric value (if any) associated with the Units of comment level in the same Comment Description Dictionary. Together, this numeric value, its units, and the Description of comment of the associated Comment Description, all describe a comment for the station/channel	 
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)	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
D_Comment	Station_Comment	Identifying	Sta_Com_D_Com	 
Station_Data	Station_Comment	Identifying	Sta_Com_Sta_Dat	 

net

Attribute Name	net	Entity Name	Station_Comment	
Logical Role Name	net	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Data	
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	

sta

Attribute Name	sta	Entity Name	Station_Comment	
Logical Role Name	sta	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Data	
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	

ondate

Attribute Name	ondate	Entity Name	Station_Comment	
Logical Role Name	ondate	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Station_Data	
Definition 

This attribute denotes the start date	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

comment_id

Attribute Name	id	Entity Name	Station_Comment	
Logical Role Name	comment_id	
Role Name	comment_id	
Primary Key	YES	
Foreign Key	YES	Parent Entity	D_Comment	
Definition 

The comment code key of the associated Comment Description Dictionary	
Logical Column Properties 

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

offdate

Attribute Name	offdate	Entity Name	Station_Comment	
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	

comment_level

Attribute Name	comment_level	Entity Name	Station_Comment	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The numeric value (if any) associated with the Units of comment level in the same Comment Description Dictionary. Together, this numeric value, its units, and the Description of comment of the associated Comment Description, all describe a comment for the station/channel	
Logical Column Properties 

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

lddate

Attribute Name	lddate	Entity Name	Station_Comment	
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_Data

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

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
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	 
net_id		NUMERIC(8, 0)	Y	The abbreviation lookup code from the Generic Abbreviation Dictionary, that refers to the network to which the station belongs	 
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	 
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	StD02	lat >= -90.0 AND lat <= 90.0	 
	Check	StD03	lon >= -180.0 AND lon <= 180.0	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
D_Abbreviation	Station_Data	Non-Identifying	Sta_Dat_D_Abb	 
Station_Data	Channel_Data	Identifying	Cha_Dat_Sta_Dat	 
Station_Data	Station_Comment	Identifying	Sta_Com_Sta_Dat	 

net

Attribute Name	net	Entity Name	Station_Data	
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	

sta

Attribute Name	sta	Entity Name	Station_Data	
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	

ondate

Attribute Name	ondate	Entity Name	Station_Data	
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_Data	
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_Data	
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_Data	
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_Data	
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	

net_id

Attribute Name	id	Entity Name	Station_Data	
Logical Role Name	net_id	
Role Name	net_id	
Primary Key	NO	
Foreign Key	YES	Parent Entity	D_Abbreviation	
Definition 

The abbreviation lookup code from the Generic Abbreviation Dictionary, that refers to the network to which the station belongs	
Logical Column Properties 

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

word_32

Attribute Name	word_32	Entity Name	Station_Data	
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	Station_Data	
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	

offdate

Attribute Name	offdate	Entity Name	Station_Data	
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_Data	
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	
Channel_Comment	ChC00	PrimaryKey	YES	 
Channel_Data	ChD00	PrimaryKey	YES	 
Coefficients	Co00	PrimaryKey	YES	 
D_Abbreviation	D_A00	PrimaryKey	YES	 
D_Comment	D_C00	PrimaryKey	YES	 
D_Format	D_F00	PrimaryKey	YES	 
D_Format_Data	D_F_D00	PrimaryKey	YES	 
D_Unit	D_U00	PrimaryKey	YES	 
DC	DC00	PrimaryKey	YES	 
DC_Data	DCD00	PrimaryKey	YES	 
Decimation	De00	PrimaryKey	YES	 
DM	DM00	PrimaryKey	YES	 
PN	PN00	PrimaryKey	YES	 
PN_Data	PND00	PrimaryKey	YES	 
Poles_Zeros	P_Z00	PrimaryKey	YES	 
Polynomial	Po00	PrimaryKey	YES	 
PZ	PZ00	PrimaryKey	YES	 
PZ_Data	PZD00	PrimaryKey	YES	 
Sensitivity	Se00	PrimaryKey	YES	 
Simple_Response	SiRe00	PrimaryKey	YES	 
Station_Comment	StC00	PrimaryKey	YES	 
Station_Data	StD00	PrimaryKey	YES	 

ChC00

Key Name	ChC00	
Entity Name	Channel_Comment	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,seedchan,location,ondate,comment_id	

ChD00

Key Name	ChD00	
Entity Name	Channel_Data	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,seedchan,location,ondate	

Co00

Key Name	Co00	
Entity Name	Coefficients	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,seedchan,location,ondate,stage_seq	

D_A00

Key Name	D_A00	
Entity Name	D_Abbreviation	
Key Type	PrimaryKey	
Unique	YES	
Keys	id	

D_C00

Key Name	D_C00	
Entity Name	D_Comment	
Key Type	PrimaryKey	
Unique	YES	
Keys	id	

D_F00

Key Name	D_F00	
Entity Name	D_Format	
Key Type	PrimaryKey	
Unique	YES	
Keys	id	

D_F_D00

Key Name	D_F_D00	
Entity Name	D_Format_Data	
Key Type	PrimaryKey	
Unique	YES	
Keys	id,row_id	

D_U00

Key Name	D_U00	
Entity Name	D_Unit	
Key Type	PrimaryKey	
Unique	YES	
Keys	id	

DC00

Key Name	DC00	
Entity Name	DC	
Key Type	PrimaryKey	
Unique	YES	
Keys	key	

DCD00

Key Name	DCD00	
Entity Name	DC_Data	
Key Type	PrimaryKey	
Unique	YES	
Keys	key,row_key	

De00

Key Name	De00	
Entity Name	Decimation	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,seedchan,location,ondate,stage_seq	

DM00

Key Name	DM00	
Entity Name	DM	
Key Type	PrimaryKey	
Unique	YES	
Keys	key	

PN00

Key Name	PN00	
Entity Name	PN	
Key Type	PrimaryKey	
Unique	YES	
Keys	key	

PND00

Key Name	PND00	
Entity Name	PN_Data	
Key Type	PrimaryKey	
Unique	YES	
Keys	key,row_key	

P_Z00

Key Name	P_Z00	
Entity Name	Poles_Zeros	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,seedchan,location,ondate,stage_seq	

Po00

Key Name	Po00	
Entity Name	Polynomial	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,seedchan,location,ondate,stage_seq	

PZ00

Key Name	PZ00	
Entity Name	PZ	
Key Type	PrimaryKey	
Unique	YES	
Keys	key	

PZD00

Key Name	PZD00	
Entity Name	PZ_Data	
Key Type	PrimaryKey	
Unique	YES	
Keys	key,row_key	

Se00

Key Name	Se00	
Entity Name	Sensitivity	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,seedchan,location,ondate,stage_seq	

SiRe00

Key Name	SiRe00	
Entity Name	Simple_Response	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,seedchan,location,ondate	

StC00

Key Name	StC00	
Entity Name	Station_Comment	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,ondate,comment_id	

StD00

Key Name	StD00	
Entity Name	Station_Data	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,ondate	

Relationship Summary Report

Parent Entity	Child Entity	Relationship Type	No of Keys	
Channel_Data	Channel_Comment	Identifying	5	
D_Comment	Channel_Comment	Identifying	1	
D_Abbreviation	Channel_Data	Non-Identifying	1	
D_Format	Channel_Data	Non-Identifying	1	
D_Unit	Channel_Data	Non-Identifying	1	
D_Unit	Channel_Data	Non-Identifying	1	
Station_Data	Channel_Data	Identifying	3	
Channel_Data	Coefficients	Identifying	5	
D_Unit	Coefficients	Non-Identifying	1	
D_Unit	Coefficients	Non-Identifying	1	
DC	Coefficients	Non-Identifying	1	
D_Format	D_Format_Data	Identifying	1	
DC	DC_Data	Identifying	1	
Channel_Data	Decimation	Identifying	5	
DM	Decimation	Non-Identifying	1	
PN	PN_Data	Identifying	1	
Channel_Data	Poles_Zeros	Identifying	5	
D_Unit	Poles_Zeros	Non-Identifying	1	
D_Unit	Poles_Zeros	Non-Identifying	1	
PZ	Poles_Zeros	Non-Identifying	1	
Channel_Data	Polynomial	Identifying	5	
D_Unit	Polynomial	Non-Identifying	1	
D_Unit	Polynomial	Non-Identifying	1	
PN	Polynomial	Non-Identifying	1	
PZ	PZ_Data	Identifying	1	
Channel_Data	Sensitivity	Identifying	5	
Channel_Data	Simple_Response	Identifying	5	
D_Comment	Station_Comment	Identifying	1	
Station_Data	Station_Comment	Identifying	3	
D_Abbreviation	Station_Data	Non-Identifying	1	

Relationship Detail Reports

Relationship: Channel_Data to Channel_Comment

Relationship Name	Cha_Com_Cha_Dat	
Relationship Type	Identifying	
Parent Entity	Channel_Data	
Child Entity	Channel_Comment	
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	
net	net	 
sta	sta	 
seedchan	seedchan	 
location	location	 
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: D_Comment to Channel_Comment

Relationship Name	Cha_Com_D_Com	
Relationship Type	Identifying	
Parent Entity	D_Comment	
Child Entity	Channel_Comment	
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	
id	comment_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: D_Abbreviation to Channel_Data

Relationship Name	Cha_Dat_D_Abb	
Relationship Type	Non-Identifying	
Parent Entity	D_Abbreviation	
Child Entity	Channel_Data	
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	
id	inid	 
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: D_Format to Channel_Data

Relationship Name	Cha_Dat_D_For	
Relationship Type	Non-Identifying	
Parent Entity	D_Format	
Child Entity	Channel_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	
id	format_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: D_Unit to Channel_Data

Relationship Name	Cha_Dat_D_Uni	
Relationship Type	Non-Identifying	
Parent Entity	D_Unit	
Child Entity	Channel_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	
id	unit_signal	 
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: D_Unit to Channel_Data

Relationship Name	Cha_Dat_D_Uni2	
Relationship Type	Non-Identifying	
Parent Entity	D_Unit	
Child Entity	Channel_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	
id	unit_calib	 
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_Data to Channel_Data

Relationship Name	Cha_Dat_Sta_Dat	
Relationship Type	Identifying	
Parent Entity	Station_Data	
Child Entity	Channel_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	
net	net	 
sta	sta	 
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: Channel_Data to Coefficients

Relationship Name	Coe_Cha_Dat	
Relationship Type	Identifying	
Parent Entity	Channel_Data	
Child Entity	Coefficients	
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	
net	net	 
sta	sta	 
seedchan	seedchan	 
location	location	 
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: D_Unit to Coefficients

Relationship Name	Coe_D_Uni	
Relationship Type	Non-Identifying	
Parent Entity	D_Unit	
Child Entity	Coefficients	
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	
id	unit_in	 
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: D_Unit to Coefficients

Relationship Name	Coe_D_Uni2	
Relationship Type	Non-Identifying	
Parent Entity	D_Unit	
Child Entity	Coefficients	
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	
id	unit_out	 
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: DC to Coefficients

Relationship Name	Coe_DC	
Relationship Type	Non-Identifying	
Parent Entity	DC	
Child Entity	Coefficients	
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	
key	dc_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: D_Format to D_Format_Data

Relationship Name	D_For_Dat_D_For	
Relationship Type	Identifying	
Parent Entity	D_Format	
Child Entity	D_Format_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	
id	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: DC to DC_Data

Relationship Name	DC_Dat_DC	
Relationship Type	Identifying	
Parent Entity	DC	
Child Entity	DC_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	
key	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: Channel_Data to Decimation

Relationship Name	Dec_Cha_Dat	
Relationship Type	Identifying	
Parent Entity	Channel_Data	
Child Entity	Decimation	
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	
net	net	 
sta	sta	 
seedchan	seedchan	 
location	location	 
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: DM to Decimation

Relationship Name	Dec_DM	
Relationship Type	Non-Identifying	
Parent Entity	DM	
Child Entity	Decimation	
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	
key	dm_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: PN to PN_Data

Relationship Name	PN_Data_PN	
Relationship Type	Identifying	
Parent Entity	PN	
Child Entity	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	
key	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: Channel_Data to Poles_Zeros

Relationship Name	Pol_Zer_Cha_Dat	
Relationship Type	Identifying	
Parent Entity	Channel_Data	
Child Entity	Poles_Zeros	
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	
net	net	 
sta	sta	 
seedchan	seedchan	 
location	location	 
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: D_Unit to Poles_Zeros

Relationship Name	Pol_Zer_D_Uni	
Relationship Type	Non-Identifying	
Parent Entity	D_Unit	
Child Entity	Poles_Zeros	
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	
id	unit_in	 
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: D_Unit to Poles_Zeros

Relationship Name	Pol_Zer_D_Uni2	
Relationship Type	Non-Identifying	
Parent Entity	D_Unit	
Child Entity	Poles_Zeros	
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	
id	unit_out	 
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: PZ to Poles_Zeros

Relationship Name	Pol_Zer_PZ	
Relationship Type	Non-Identifying	
Parent Entity	PZ	
Child Entity	Poles_Zeros	
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	
key	pz_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: Channel_Data to Polynomial

Relationship Name	Pol_Cha_Dat	
Relationship Type	Identifying	
Parent Entity	Channel_Data	
Child Entity	Polynomial	
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	
net	net	 
sta	sta	 
seedchan	seedchan	 
location	location	 
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: D_Unit to Polynomial

Relationship Name	Pol_D_Uni	
Relationship Type	Non-Identifying	
Parent Entity	D_Unit	
Child Entity	Polynomial	
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	
id	unit_in	 
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: D_Unit to Polynomial

Relationship Name	Pol_D_Uni2	
Relationship Type	Non-Identifying	
Parent Entity	D_Unit	
Child Entity	Polynomial	
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	
id	unit_out	 
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: PN to Polynomial

Relationship Name	Pol_PN	
Relationship Type	Non-Identifying	
Parent Entity	PN	
Child Entity	Polynomial	
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	
key	pn_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: PZ to PZ_Data

Relationship Name	PZ_Dat_PZ	
Relationship Type	Identifying	
Parent Entity	PZ	
Child Entity	PZ_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	
key	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: Channel_Data to Sensitivity

Relationship Name	Sen_Cha_Dat	
Relationship Type	Identifying	
Parent Entity	Channel_Data	
Child Entity	Sensitivity	
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	
net	net	 
sta	sta	 
seedchan	seedchan	 
location	location	 
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: Channel_Data to Simple_Response

Relationship Name	Sim_Res_Cha_Dat	
Relationship Type	Identifying	
Parent Entity	Channel_Data	
Child Entity	Simple_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	
net	net	 
sta	sta	 
seedchan	seedchan	 
location	location	 
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: D_Comment to Station_Comment

Relationship Name	Sta_Com_D_Com	
Relationship Type	Identifying	
Parent Entity	D_Comment	
Child Entity	Station_Comment	
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	
id	comment_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_Data to Station_Comment

Relationship Name	Sta_Com_Sta_Dat	
Relationship Type	Identifying	
Parent Entity	Station_Data	
Child Entity	Station_Comment	
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	
net	net	 
sta	sta	 
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: D_Abbreviation to Station_Data

Relationship Name	Sta_Dat_D_Abb	
Relationship Type	Non-Identifying	
Parent Entity	D_Abbreviation	
Child Entity	Station_Data	
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	
id	net_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