Diagram Report

 CISN Instrument Responses
Version 1.5.3

Berkeley Seismological Laboratory
Stephane Zuzlewski
Last Modified 1/9/2009
Copyright 2009 CISN
 
Table of Contents

            Table of Contents	          
            Model Summary Report	          
            Model Detail Reports	          
            Entity Summary Report	          
            Entity Detail Reports	          
            Model Detail Reports	          
            Table Summary Report	          
            Table Detail Reports	          
            Oracle Sequence Summary Report	          
            Oracle Sequence Detail Report	          

Model Summary Report

Name	DatabasePlatform	 
Logical	Logical	
NCEDC	Oracle 10g	

Model Detail Reports

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		
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(8)	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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
Channel_Data	Identifying	One To Zero or More					NO	 
D_Comment	Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

Channel_Data

Entity Name	Channel_Data	
Owner Name		
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(8)	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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
D_Abbreviation	Non-Identifying	Zero or One to Zero or More					NO	 
D_Format	Non-Identifying	One To Zero or More					NO	 
D_Unit	Non-Identifying	One To Zero or More					NO	 
D_Unit	Non-Identifying	One To Zero or More					NO	 
Station_Data	Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
Channel_Comment	Identifying	One To Zero or More					NO	 
Coefficients	Identifying	One To Zero or More					NO	 
Decimation	Identifying	One To Zero or More					NO	 
Polynomial	Identifying	One To Zero or More					NO	 
Poles_Zeros	Identifying	One To Zero or More					NO	 
Sensitivity	Identifying	One To Zero or More					NO	 
Simple_Response	Identifying	One To Zero or More					NO	 

Coefficients

Entity Name	Coefficients	
Owner Name		
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(8)	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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
Channel_Data	Identifying	One To Zero or More					NO	 
D_Unit	Non-Identifying	One To Zero or More					NO	 
D_Unit	Non-Identifying	One To Zero or More					NO	 
DC	Non-Identifying	Zero or One to Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

D_Abbreviation

Entity Name	D_Abbreviation	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
Channel_Data	Non-Identifying	One To Zero or More					NO	 
Station_Data	Non-Identifying	One To Zero or More					NO	 

D_Comment

Entity Name	D_Comment	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
Channel_Comment	Identifying	One To Zero or More					NO	 
Station_Comment	Identifying	One To Zero or More					NO	 

D_Format

Entity Name	D_Format	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
Channel_Data	Non-Identifying	One To Zero or More					NO	 
D_Format_Data	Identifying	One To Zero or More					NO	 

D_Format_Data

Entity Name	D_Format_Data	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
D_Format	Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

D_Unit

Entity Name	D_Unit	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
Channel_Data	Non-Identifying	One To Zero or More					NO	 
Channel_Data	Non-Identifying	One To Zero or More					NO	 
Coefficients	Non-Identifying	One To Zero or More					NO	 
Coefficients	Non-Identifying	One To Zero or More					NO	 
Polynomial	Non-Identifying	One To Zero or More					NO	 
Polynomial	Non-Identifying	One To Zero or More					NO	 
Poles_Zeros	Non-Identifying	One To Zero or More					NO	 
Poles_Zeros	Non-Identifying	Zero or One to Zero or More					NO	 

DC

Entity Name	DC	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
Coefficients	Non-Identifying	One To Zero or More					NO	 
DC_Data	Identifying	One To Zero or More					NO	 

DC_Data

Entity Name	DC_Data	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
DC	Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

Decimation

Entity Name	Decimation	
Owner Name		
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(8)	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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
Channel_Data	Identifying	One To Zero or More					NO	 
DM	Non-Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

DM

Entity Name	DM	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
Decimation	Non-Identifying	One To Zero or More					NO	 

PN

Entity Name	PN	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
PN_Data	Identifying	One To Zero or More					NO	 
Polynomial	Non-Identifying	One To Zero or More					NO	 

PN_Data

Entity Name	PN_Data	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
PN	Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

Poles_Zeros

Entity Name	Poles_Zeros	
Owner Name		
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(8)	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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
Channel_Data	Identifying	One To Zero or More					NO	 
D_Unit	Non-Identifying	One To Zero or More					NO	 
D_Unit	Non-Identifying	One To Zero or More					NO	 
PZ	Non-Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

Polynomial

Entity Name	Polynomial	
Owner Name		
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(8)	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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
Channel_Data	Identifying	One To Zero or More					NO	 
D_Unit	Non-Identifying	One To Zero or More					NO	 
D_Unit	Non-Identifying	One To Zero or More					NO	 
PN	Non-Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

PZ

Entity Name	PZ	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
Poles_Zeros	Non-Identifying	One To Zero or More					NO	 
PZ_Data	Identifying	One To Zero or More					NO	 

PZ_Data

Entity Name	PZ_Data	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
PZ	Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

Sensitivity

Entity Name	Sensitivity	
Owner Name		
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(8)	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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
Channel_Data	Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

Simple_Response

Entity Name	Simple_Response	
Owner Name		
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(8)	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)	N	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	 
	Check	SiRe02	gain_units IN ('DU/M/S','DU/M/S**2','counts/(cm/sec)','counts/(cm/sec2)')	 
Relationships 

 Parent Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
Channel_Data	Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

Station_Comment

Entity Name	Station_Comment	
Owner Name		
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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
D_Comment	Identifying	One To Zero or More					NO	 
Station_Data	Identifying	One To Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	

Station_Data

Entity Name	Station_Data	
Owner Name		
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(60)	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 Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	
D_Abbreviation	Non-Identifying	Zero or One to Zero or More					NO	 
 Child Relationships: 

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
Channel_Data	Identifying	One To Zero or More					NO	 
Station_Comment	Identifying	One To Zero or More					NO	 

Model Detail Reports

NCEDC

Model Name	NCEDC	
Database Platform	Oracle 10g	

Table Summary Report

Table Name	Table Type	Primary Keys	# Col	
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	netstaondate	12	

Table Detail Reports

Channel_Comment

Table Name	Channel_Comment	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate,comment_id	
Definition	Comments for a channel	
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR2(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		VARCHAR2(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		NUMBER(8, 0)	N	The comment code key of the associated Comment Description Dictionary	 
channel		VARCHAR2(8)	Y	Channel name	 
channelsrc		VARCHAR2(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		NUMBER(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 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
Channel_Data	Identifying	One To Zero or More	Cha_Com_Cha_Dat				NO	NO	 
D_Comment	Identifying	One To Zero or More	Cha_Com_D_Com				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE Channel_Comment(
    net              VARCHAR2(8)     NOT NULL,
    sta              VARCHAR2(6)     NOT NULL,
    seedchan         VARCHAR2(3)     NOT NULL,
    location         VARCHAR2(2)     NOT NULL,
    ondate           DATE            NOT NULL,
    comment_id       NUMBER(8, 0)    NOT NULL,
    channel          VARCHAR2(8),
    channelsrc       VARCHAR2(8),
    offdate          DATE,
    comment_level    NUMBER(8, 0)    NOT NULL,
    lddate           DATE            DEFAULT (SYSDATE),
    CONSTRAINT ChC00 PRIMARY KEY (net, sta, seedchan, location, ondate, comment_id)
    USING INDEX
        LOGGING, 
    CONSTRAINT Cha_Com_Cha_Dat FOREIGN KEY (net, sta, seedchan, location, ondate)
    REFERENCES Channel_Data(net, sta, seedchan, location, ondate),
    CONSTRAINT Cha_Com_D_Com FOREIGN KEY (comment_id)
    REFERENCES D_Comment(id)
)
TABLESPACE IR_DATA
LOGGING
;

Channel_Data

Table Name	Channel_Data	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate	
Definition	Summary information on a channel	
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR2(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		VARCHAR2(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		VARCHAR2(8)	Y	Channel name	 
channelsrc		VARCHAR2(8)	Y	Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)	 
inid		NUMBER(8, 0)	Y	Instrument identifier. It refers to the Generic Abbreviation Dictionary, that contains a name for this instrument	 
remark		VARCHAR2(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		NUMBER(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		NUMBER(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		BINARY_FLOAT	Y	Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes	 
lon		BINARY_FLOAT	Y	Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian	 
elev		BINARY_FLOAT	Y	Elevation. This attribute is the elevation of a seismic station relative to mean sea level	 
edepth		BINARY_FLOAT	Y	Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev	 
azimuth		BINARY_FLOAT	Y	The azimuth of the instrument from north, clockwise	 
dip		BINARY_FLOAT	Y	The dip of the instrument, down from horizontal	 
format_id		NUMBER(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		NUMBER(8, 0)	Y	The exponent (as a power of two) of the record length for these data	 
samprate		BINARY_FLOAT	N	Sampling rate. This attribute is the sample rate in samples/second	 
clock_drift		BINARY_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		VARCHAR2(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 

Column	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	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
D_Abbreviation	Non-Identifying	Zero or One to Zero or More	Cha_Dat_D_Abb				NO	NO	 
D_Format	Non-Identifying	One To Zero or More	Cha_Dat_D_For				NO	NO	 
D_Unit	Non-Identifying	One To Zero or More	Cha_Dat_D_Uni				NO	NO	 
D_Unit	Non-Identifying	One To Zero or More	Cha_Dat_D_Uni2				NO	NO	 
Station_Data	Identifying	One To Zero or More	Cha_Dat_Sta_Dat				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
Channel_Comment	Identifying	One To Zero or More	Cha_Com_Cha_Dat				NO	NO	 
Coefficients	Identifying	One To Zero or More	Coe_Cha_Dat				NO	NO	 
Decimation	Identifying	One To Zero or More	Dec_Cha_Dat				NO	NO	 
Polynomial	Identifying	One To Zero or More	Pol_Cha_Dat				NO	NO	 
Poles_Zeros	Identifying	One To Zero or More	Pol_Zer_Cha_Dat				NO	NO	 
Sensitivity	Identifying	One To Zero or More	Sen_Cha_Dat				NO	NO	 
Simple_Response	Identifying	One To Zero or More	Sim_Res_Cha_Dat				NO	NO	 
DDL Code 

CREATE TABLE Channel_Data(
    net              VARCHAR2(8)     NOT NULL,
    sta              VARCHAR2(6)     NOT NULL,
    seedchan         VARCHAR2(3)     NOT NULL,
    location         VARCHAR2(2)     NOT NULL,
    ondate           DATE            NOT NULL,
    channel          VARCHAR2(8),
    channelsrc       VARCHAR2(8),
    inid             NUMBER(8, 0),
    remark           VARCHAR2(30),
    unit_signal      NUMBER(8, 0)    NOT NULL,
    unit_calib       NUMBER(8, 0)    NOT NULL,
    lat              BINARY_FLOAT,
    lon              BINARY_FLOAT,
    elev             BINARY_FLOAT,
    edepth           BINARY_FLOAT,
    azimuth          BINARY_FLOAT,
    dip              BINARY_FLOAT,
    format_id        NUMBER(8, 0)    NOT NULL,
    record_length    NUMBER(8, 0),
    samprate         BINARY_FLOAT    NOT NULL,
    clock_drift      BINARY_FLOAT,
    flags            VARCHAR2(27),
    offdate          DATE,
    lddate           DATE            DEFAULT (SYSDATE),
    CONSTRAINT ChD01 CHECK (azimuth >= 0.0 AND azimuth <= 360.0),
    CONSTRAINT ChD02 CHECK (clock_drift >= 0.0),
    CONSTRAINT ChD03 CHECK (dip >= -90.0 AND dip <= 90.0),
    CONSTRAINT ChD04 CHECK (edepth >= 0.0),
    CONSTRAINT ChD06 CHECK (lat >= -90.0 AND lat <= 90.0),
    CONSTRAINT ChD07 CHECK (lon >= -180.0 AND lon <= 180.0),
    CONSTRAINT ChD08 CHECK (record_length >= 8 AND record_length <= 12),
    CONSTRAINT ChD09 CHECK (samprate >= 0.0),
    CONSTRAINT ChD00 PRIMARY KEY (net, sta, seedchan, location, ondate)
    USING INDEX
        LOGGING, 
    CONSTRAINT Cha_Dat_Sta_Dat FOREIGN KEY (net, sta, ondate)
    REFERENCES Station_Data(net, sta, ondate),
    CONSTRAINT Cha_Dat_D_Abb FOREIGN KEY (inid)
    REFERENCES D_Abbreviation(id),
    CONSTRAINT Cha_Dat_D_Uni FOREIGN KEY (unit_signal)
    REFERENCES D_Unit(id),
    CONSTRAINT Cha_Dat_D_Uni2 FOREIGN KEY (unit_calib)
    REFERENCES D_Unit(id),
    CONSTRAINT Cha_Dat_D_For FOREIGN KEY (format_id)
    REFERENCES D_Format(id)
)
TABLESPACE IR_DATA
LOGGING
;

Coefficients

Table Name	Coefficients	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate,stage_seq	
Definition	Data associating a channel with a response	
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR2(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		VARCHAR2(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		NUMBER(8, 0)	N	This attribute denotes the stage number	 
channel		VARCHAR2(8)	Y	Channel name	 
channelsrc		VARCHAR2(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		NUMBER(8, 0)	Y	Response (Coefficients) key	 
unit_in		NUMBER(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		NUMBER(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		VARCHAR2(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 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Co01	stage_seq >= 0	 
	Check	Co02	tf_type IN ('A','B','C','D','P')	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
Channel_Data	Identifying	One To Zero or More	Coe_Cha_Dat				NO	NO	 
D_Unit	Non-Identifying	One To Zero or More	Coe_D_Uni				NO	NO	 
D_Unit	Non-Identifying	One To Zero or More	Coe_D_Uni2				NO	NO	 
DC	Non-Identifying	Zero or One to Zero or More	Coe_DC				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE Coefficients(
    net           VARCHAR2(8)     NOT NULL,
    sta           VARCHAR2(6)     NOT NULL,
    seedchan      VARCHAR2(3)     NOT NULL,
    location      VARCHAR2(2)     NOT NULL,
    ondate        DATE            NOT NULL,
    stage_seq     NUMBER(8, 0)    NOT NULL,
    channel       VARCHAR2(8),
    channelsrc    VARCHAR2(8),
    offdate       DATE,
    dc_key        NUMBER(8, 0),
    unit_in       NUMBER(8, 0)    NOT NULL,
    unit_out      NUMBER(8, 0)    NOT NULL,
    tf_type       VARCHAR2(1),
    lddate        DATE            DEFAULT (SYSDATE),
    CONSTRAINT Co01 CHECK (stage_seq >= 0),
    CONSTRAINT Co02 CHECK (tf_type IN ('A','B','C','D','P')),
    CONSTRAINT Co00 PRIMARY KEY (net, sta, seedchan, location, ondate, stage_seq)
    USING INDEX
        LOGGING, 
    CONSTRAINT Coe_Cha_Dat FOREIGN KEY (net, sta, seedchan, location, ondate)
    REFERENCES Channel_Data(net, sta, seedchan, location, ondate),
    CONSTRAINT Coe_DC FOREIGN KEY (dc_key)
    REFERENCES DC(key),
    CONSTRAINT Coe_D_Uni FOREIGN KEY (unit_in)
    REFERENCES D_Unit(id),
    CONSTRAINT Coe_D_Uni2 FOREIGN KEY (unit_out)
    REFERENCES D_Unit(id)
)
TABLESPACE IR_DATA
LOGGING
;

D_Abbreviation

Table Name	D_Abbreviation	
Owner Name		
Primary Keys	id	
Definition	Abbreviation dictionary	
Columns 

Column Name	Domain	Datatype	Null	Definition	
id		NUMBER(8, 0)	N	A cross reference code to indicate this particular dictionary entry	 
description		VARCHAR2(70)	Y	This is a description of an abbreviation	 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
Channel_Data	Non-Identifying	One To Zero or More	Cha_Dat_D_Abb				NO	NO	 
Station_Data	Non-Identifying	One To Zero or More	Sta_Dat_D_Abb				NO	NO	 
DDL Code 

CREATE TABLE D_Abbreviation(
    id             NUMBER(8, 0)    NOT NULL,
    description    VARCHAR2(70),
    CONSTRAINT D_A00 PRIMARY KEY (id)
    USING INDEX
        LOGGING
)
TABLESPACE IR_DATA
LOGGING
;

D_Comment

Table Name	D_Comment	
Owner Name		
Primary Keys	id	
Definition	Comment dictionary	
Columns 

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

Column	Type	Name	Restriction	
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
Channel_Comment	Identifying	One To Zero or More	Cha_Com_D_Com				NO	NO	 
Station_Comment	Identifying	One To Zero or More	Sta_Com_D_Com				NO	NO	 
DDL Code 

CREATE TABLE D_Comment(
    id             NUMBER(8, 0)    NOT NULL,
    class          VARCHAR2(1)     NOT NULL,
    description    VARCHAR2(70),
    unit           NUMBER(8, 0)    NOT NULL,
    CONSTRAINT D_C00 PRIMARY KEY (id)
    USING INDEX
        LOGGING
)
TABLESPACE IR_DATA
LOGGING
;

D_Format

Table Name	D_Format	
Owner Name		
Primary Keys	id	
Definition	Format dictionary	
Columns 

Column Name	Domain	Datatype	Null	Definition	
id		NUMBER(8, 0)	N	A cross reference code to indicate this particular dictionary entry	 
name		VARCHAR2(80)	Y	Descriptive name	 
family		NUMBER(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		NUMBER(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 

Column	Type	Name	Restriction	
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
Channel_Data	Non-Identifying	One To Zero or More	Cha_Dat_D_For				NO	NO	 
D_Format_Data	Identifying	One To Zero or More	D_For_Dat_D_For				NO	NO	 
DDL Code 

CREATE TABLE D_Format(
    id        NUMBER(8, 0)    NOT NULL,
    name      VARCHAR2(80),
    family    NUMBER(8, 0)    NOT NULL,
    ms_id     NUMBER(8, 0)    NOT NULL,
    CONSTRAINT D_F00 PRIMARY KEY (id)
    USING INDEX
        LOGGING
)
TABLESPACE IR_DATA
LOGGING
;

D_Format_Data

Table Name	D_Format_Data	
Owner Name		
Primary Keys	id,row_id	
Definition	Format data	
Columns 

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

Column	Type	Name	Restriction	
	Check	D_F_D01	row_id >= 0	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
D_Format	Identifying	One To Zero or More	D_For_Dat_D_For				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE D_Format_Data(
    id        NUMBER(8, 0)    NOT NULL,
    row_id    NUMBER(8, 0)    NOT NULL,
    key_d     VARCHAR2(80)    NOT NULL,
    CONSTRAINT D_F_D01 CHECK (row_id >= 0),
    CONSTRAINT D_F_D00 PRIMARY KEY (id, row_id)
    USING INDEX
        LOGGING, 
    CONSTRAINT D_For_Dat_D_For FOREIGN KEY (id)
    REFERENCES D_Format(id)
)
TABLESPACE IR_DATA
LOGGING
;

D_Unit

Table Name	D_Unit	
Owner Name		
Primary Keys	id	
Definition	Unit dictionary	
Columns 

Column Name	Domain	Datatype	Null	Definition	
id		NUMBER(8, 0)	N	A cross reference code to indicate this particular dictionary entry	 
name		VARCHAR2(80)	Y	Descriptive name	 
description		VARCHAR2(70)	Y	This is a description of a unit	 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
Channel_Data	Non-Identifying	One To Zero or More	Cha_Dat_D_Uni				NO	NO	 
Channel_Data	Non-Identifying	One To Zero or More	Cha_Dat_D_Uni2				NO	NO	 
Coefficients	Non-Identifying	One To Zero or More	Coe_D_Uni				NO	NO	 
Coefficients	Non-Identifying	One To Zero or More	Coe_D_Uni2				NO	NO	 
Polynomial	Non-Identifying	One To Zero or More	Pol_D_Uni				NO	NO	 
Polynomial	Non-Identifying	One To Zero or More	Pol_D_Uni2				NO	NO	 
Poles_Zeros	Non-Identifying	One To Zero or More	Pol_Zer_D_Uni				NO	NO	 
Poles_Zeros	Non-Identifying	One To Zero or More	Pol_Zer_D_Uni2				NO	NO	 
DDL Code 

CREATE TABLE D_Unit(
    id             NUMBER(8, 0)    NOT NULL,
    name           VARCHAR2(80),
    description    VARCHAR2(70),
    CONSTRAINT D_U00 PRIMARY KEY (id)
    USING INDEX
        LOGGING
)
TABLESPACE IR_DATA
LOGGING
;

DC

Table Name	DC	
Owner Name		
Primary Keys	key	
Definition	Summary information on a response (Coefficients)	
Columns 

Column Name	Domain	Datatype	Null	Definition	
key		NUMBER(8, 0)	N	This attribute denotes a unique identifier for a response (digital coefficients)	 
name		VARCHAR2(80)	Y	Descriptive name	 
symmetry		VARCHAR2(1)	Y	This attribute denotes the eventual symmetry of a response	 
storage		VARCHAR2(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 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	DC01	dcstorage IN ('H','F')	 
	Check	DC02	symmetry IN ('E','O','N')	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
Coefficients	Non-Identifying	One To Zero or More	Coe_DC				NO	NO	 
DC_Data	Identifying	One To Zero or More	DC_Dat_DC				NO	NO	 
DDL Code 

CREATE TABLE DC(
    key         NUMBER(8, 0)    NOT NULL,
    name        VARCHAR2(80),
    symmetry    VARCHAR2(1),
    storage     VARCHAR2(1),
    lddate      DATE            DEFAULT (SYSDATE),
    CONSTRAINT DC01 CHECK (dcstorage IN ('H','F')),
    CONSTRAINT DC02 CHECK (symmetry IN ('E','O','N')),
    CONSTRAINT DC00 PRIMARY KEY (key)
    USING INDEX
        LOGGING
)
TABLESPACE IR_DATA
LOGGING
;

DC_Data

Table Name	DC_Data	
Owner Name		
Primary Keys	key,row_key	
Definition	Coefficients of a response	
Columns 

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

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

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
DC	Identifying	One To Zero or More	DC_Dat_DC				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE DC_Data(
    key            NUMBER(8, 0)    NOT NULL,
    row_key        NUMBER(8, 0)    NOT NULL,
    type           VARCHAR2(1),
    coefficient    BINARY_FLOAT    NOT NULL,
    error          BINARY_FLOAT,
    CONSTRAINT DCD01 CHECK (row_key >= 0),
    CONSTRAINT DCD02 CHECK (type IN ('P','Z','N','D')),
    CONSTRAINT DCD00 PRIMARY KEY (key, row_key)
    USING INDEX
        LOGGING, 
    CONSTRAINT DC_Dat_DC FOREIGN KEY (key)
    REFERENCES DC(key)
)
TABLESPACE IR_DATA
LOGGING
;

Decimation

Table Name	Decimation	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate,stage_seq	
Definition	Data associating a channel with a decimation	
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR2(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		VARCHAR2(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		NUMBER(8, 0)	N	This attribute denotes the stage number	 
channel		VARCHAR2(8)	Y	Channel name	 
channelsrc		VARCHAR2(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		NUMBER(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 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	De01	stage_seq >= 0	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
Channel_Data	Identifying	One To Zero or More	Dec_Cha_Dat				NO	NO	 
DM	Non-Identifying	One To Zero or More	Dec_DM				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE Decimation(
    net           VARCHAR2(8)     NOT NULL,
    sta           VARCHAR2(6)     NOT NULL,
    seedchan      VARCHAR2(3)     NOT NULL,
    location      VARCHAR2(2)     NOT NULL,
    ondate        DATE            NOT NULL,
    stage_seq     NUMBER(8, 0)    NOT NULL,
    channel       VARCHAR2(8),
    channelsrc    VARCHAR2(8),
    offdate       DATE,
    dm_key        NUMBER(8, 0)    NOT NULL,
    lddate        DATE            DEFAULT (SYSDATE),
    CONSTRAINT De01 CHECK (stage_seq >= 0),
    CONSTRAINT De00 PRIMARY KEY (net, sta, seedchan, location, ondate, stage_seq)
    USING INDEX
        LOGGING, 
    CONSTRAINT Dec_Cha_Dat FOREIGN KEY (net, sta, seedchan, location, ondate)
    REFERENCES Channel_Data(net, sta, seedchan, location, ondate),
    CONSTRAINT Dec_DM FOREIGN KEY (dm_key)
    REFERENCES DM(key)
)
TABLESPACE IR_DATA
LOGGING
;

DM

Table Name	DM	
Owner Name		
Primary Keys	key	
Definition	Summary information on a decimation	
Columns 

Column Name	Domain	Datatype	Null	Definition	
key		NUMBER(8, 0)	N	This attribute denotes a unique identifier for a decimation	 
name		VARCHAR2(80)	Y	Descriptive name	 
samprate		BINARY_FLOAT	N	Sampling rate. This attribute is the sample rate in samples/second	 
factor		NUMBER(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		NUMBER(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		BINARY_FLOAT	Y	The estimated pure delay for the stage	 
correction		BINARY_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 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	DM01	offset >= 0.0	 
	Check	DM02	samprate >= 0.0	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
Decimation	Non-Identifying	One To Zero or More	Dec_DM				NO	NO	 
DDL Code 

CREATE TABLE DM(
    key           NUMBER(8, 0)    NOT NULL,
    name          VARCHAR2(80),
    samprate      BINARY_FLOAT    NOT NULL,
    factor        NUMBER(8, 0)    NOT NULL,
    offset        NUMBER(8, 0),
    delay         BINARY_FLOAT,
    correction    BINARY_FLOAT    NOT NULL,
    lddate        DATE            DEFAULT (SYSDATE),
    CONSTRAINT DM01 CHECK (offset >= 0.0),
    CONSTRAINT DM02 CHECK (samprate >= 0.0),
    CONSTRAINT DM00 PRIMARY KEY (key)
    USING INDEX
        LOGGING
)
TABLESPACE IR_DATA
LOGGING
;

PN

Table Name	PN	
Owner Name		
Primary Keys	key	
Definition	Summary information on a response (Polynomial)	
Columns 

Column Name	Domain	Datatype	Null	Definition	
key		NUMBER(8, 0)	N	This attribute denotes a unique identifier for a response (poles & zeros)	 
name		VARCHAR2(80)	Y	Descriptive name	 
poly_type		VARCHAR2(1)	Y	This attribute represents the type of polynomial approximation	 
lower_bound		BINARY_FLOAT	Y	This attribute denotes the polynomial lower bound	 
upper_bound		BINARY_FLOAT	Y	This attribute denotes the polynomial upper bound	 
max_error		BINARY_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 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	PN01	poly_type IN ('C','L','M')	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
PN_Data	Identifying	One To Zero or More	PN_Data_PN				NO	NO	 
Polynomial	Non-Identifying	One To Zero or More	Pol_PN				NO	NO	 
DDL Code 

CREATE TABLE PN(
    key            NUMBER(8, 0)    NOT NULL,
    name           VARCHAR2(80),
    poly_type      VARCHAR2(1),
    lower_bound    BINARY_FLOAT,
    upper_bound    BINARY_FLOAT,
    max_error      BINARY_FLOAT,
    lddate         DATE            DEFAULT (SYSDATE),
    CONSTRAINT PN01 CHECK (poly_type IN ('C','L','M')),
    CONSTRAINT PN00 PRIMARY KEY (key)
    USING INDEX
        LOGGING
)
TABLESPACE IR_DATA
LOGGING
;

PN_Data

Table Name	PN_Data	
Owner Name		
Primary Keys	key,row_key	
Definition	Coefficients of a polynomial	
Columns 

Column Name	Domain	Datatype	Null	Definition	
key		NUMBER(8, 0)	N	This attribute denotes a unique identifier for a response (poles & zeros)	 
row_key		NUMBER(8, 0)	N	Row key for responses	 
pn_value		BINARY_FLOAT	Y	This attribute denotes the coefficient value of a polynomial	 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
	Check	PND01	row_key >= 0	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
PN	Identifying	One To Zero or More	PN_Data_PN				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE PN_Data(
    key         NUMBER(8, 0)    NOT NULL,
    row_key     NUMBER(8, 0)    NOT NULL,
    pn_value    BINARY_FLOAT,
    CONSTRAINT PND01 CHECK (row_key >= 0),
    CONSTRAINT PND00 PRIMARY KEY (key, row_key)
    USING INDEX
        LOGGING, 
    CONSTRAINT PN_Data_PN FOREIGN KEY (key)
    REFERENCES PN(key)
)
TABLESPACE IR_DATA
LOGGING
;

Poles_Zeros

Table Name	Poles_Zeros	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate,stage_seq	
Definition	Data associating a channel with poles & zeros	
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR2(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		VARCHAR2(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		NUMBER(8, 0)	N	This attribute denotes the stage number	 
channel		VARCHAR2(8)	Y	Channel name	 
channelsrc		VARCHAR2(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		NUMBER(8, 0)	N	Response (Poles & zeros) key	 
tf_type		VARCHAR2(1)	Y	A single character describing the type of stage	 
unit_in		NUMBER(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		NUMBER(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		BINARY_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		BINARY_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 

Column	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')	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
Channel_Data	Identifying	One To Zero or More	Pol_Zer_Cha_Dat				NO	NO	 
D_Unit	Non-Identifying	One To Zero or More	Pol_Zer_D_Uni				NO	NO	 
D_Unit	Non-Identifying	One To Zero or More	Pol_Zer_D_Uni2				NO	NO	 
PZ	Non-Identifying	One To Zero or More	Pol_Zer_PZ				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE Poles_Zeros(
    net           VARCHAR2(8)     NOT NULL,
    sta           VARCHAR2(6)     NOT NULL,
    seedchan      VARCHAR2(3)     NOT NULL,
    location      VARCHAR2(2)     NOT NULL,
    ondate        DATE            NOT NULL,
    stage_seq     NUMBER(8, 0)    NOT NULL,
    channel       VARCHAR2(8),
    channelsrc    VARCHAR2(8),
    offdate       DATE,
    pz_key        NUMBER(8, 0)    NOT NULL,
    tf_type       VARCHAR2(1),
    unit_in       NUMBER(8, 0)    NOT NULL,
    unit_out      NUMBER(8, 0)    NOT NULL,
    AO            BINARY_FLOAT    NOT NULL,
    AF            BINARY_FLOAT,
    lddate        DATE            DEFAULT (SYSDATE),
    CONSTRAINT P_Z01 CHECK (AF >= 0.0),
    CONSTRAINT P_Z02 CHECK (stage_seq >= 0),
    CONSTRAINT P_Z03 CHECK (tf_type IN ('A','B','C','D','P')),
    CONSTRAINT P_Z00 PRIMARY KEY (net, sta, seedchan, location, ondate, stage_seq)
    USING INDEX
        LOGGING, 
    CONSTRAINT Pol_Zer_Cha_Dat FOREIGN KEY (net, sta, seedchan, location, ondate)
    REFERENCES Channel_Data(net, sta, seedchan, location, ondate),
    CONSTRAINT Pol_Zer_PZ FOREIGN KEY (pz_key)
    REFERENCES PZ(key),
    CONSTRAINT Pol_Zer_D_Uni FOREIGN KEY (unit_in)
    REFERENCES D_Unit(id),
    CONSTRAINT Pol_Zer_D_Uni2 FOREIGN KEY (unit_out)
    REFERENCES D_Unit(id)
)
TABLESPACE IR_DATA
LOGGING
;

Polynomial

Table Name	Polynomial	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate,stage_seq	
Definition	Data associating a channel with a polynomial	
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR2(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		VARCHAR2(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		NUMBER(8, 0)	N	This attribute denotes the stage number	 
channel		VARCHAR2(8)	Y	Channel name	 
channelsrc		VARCHAR2(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		NUMBER(8, 0)	N	Response (Polynomial) key	 
unit_in		NUMBER(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		NUMBER(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		VARCHAR2(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 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Po01	stage_seq >= 0	 
	Check	Po02	tf_type IN ('A','B','C','D','P')	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
Channel_Data	Identifying	One To Zero or More	Pol_Cha_Dat				NO	NO	 
D_Unit	Non-Identifying	One To Zero or More	Pol_D_Uni				NO	NO	 
D_Unit	Non-Identifying	One To Zero or More	Pol_D_Uni2				NO	NO	 
PN	Non-Identifying	One To Zero or More	Pol_PN				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE Polynomial(
    net           VARCHAR2(8)     NOT NULL,
    sta           VARCHAR2(6)     NOT NULL,
    seedchan      VARCHAR2(3)     NOT NULL,
    location      VARCHAR2(2)     NOT NULL,
    ondate        DATE            NOT NULL,
    stage_seq     NUMBER(8, 0)    NOT NULL,
    channel       VARCHAR2(8),
    channelsrc    VARCHAR2(8),
    offdate       DATE,
    pn_key        NUMBER(8, 0)    NOT NULL,
    unit_in       NUMBER(8, 0)    NOT NULL,
    unit_out      NUMBER(8, 0)    NOT NULL,
    tf_type       VARCHAR2(1),
    lddate        DATE            DEFAULT (SYSDATE),
    CONSTRAINT Po01 CHECK (stage_seq >= 0),
    CONSTRAINT Po02 CHECK (tf_type IN ('A','B','C','D','P')),
    CONSTRAINT Po00 PRIMARY KEY (net, sta, seedchan, location, ondate, stage_seq)
    USING INDEX
        LOGGING, 
    CONSTRAINT Pol_Cha_Dat FOREIGN KEY (net, sta, seedchan, location, ondate)
    REFERENCES Channel_Data(net, sta, seedchan, location, ondate),
    CONSTRAINT Pol_PN FOREIGN KEY (pn_key)
    REFERENCES PN(key),
    CONSTRAINT Pol_D_Uni FOREIGN KEY (unit_in)
    REFERENCES D_Unit(id),
    CONSTRAINT Pol_D_Uni2 FOREIGN KEY (unit_out)
    REFERENCES D_Unit(id)
)
TABLESPACE IR_DATA
LOGGING
;

PZ

Table Name	PZ	
Owner Name		
Primary Keys	key	
Definition	Summary information on a response (Poles & Zeros)	
Columns 

Column Name	Domain	Datatype	Null	Definition	
key		NUMBER(8, 0)	N	This attribute denotes a unique identifier for a response (poles & zeros)	 
name		VARCHAR2(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 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
Poles_Zeros	Non-Identifying	One To Zero or More	Pol_Zer_PZ				NO	NO	 
PZ_Data	Identifying	One To Zero or More	PZ_Dat_PZ				NO	NO	 
DDL Code 

CREATE TABLE PZ(
    key       NUMBER(8, 0)    NOT NULL,
    name      VARCHAR2(80),
    lddate    DATE            DEFAULT (SYSDATE),
    CONSTRAINT PZ00 PRIMARY KEY (key)
    USING INDEX
        LOGGING
)
TABLESPACE IR_DATA
LOGGING
;

PZ_Data

Table Name	PZ_Data	
Owner Name		
Primary Keys	key,row_key	
Definition	Poles & zeros of a response	
Columns 

Column Name	Domain	Datatype	Null	Definition	
key		NUMBER(8, 0)	N	This attribute denotes a unique identifier for a response (poles & zeros)	 
row_key		NUMBER(8, 0)	N	Row key for responses	 
type		VARCHAR2(1)	Y	This attribute denotes whether a value is associated with a pole/zero	 
r_value		BINARY_FLOAT	N	The real portion of a complex pole/zero	 
r_error		BINARY_FLOAT	Y	The error value for the real portion of a complex pole/zero	 
i_value		BINARY_FLOAT	N	The imaginary portion of a complex pole/zero	 
i_error		BINARY_FLOAT	Y	The error value for the imaginary portion of a complex pole/zero	 
Defaults, Rules and Check Constraints 

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

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
PZ	Identifying	One To Zero or More	PZ_Dat_PZ				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE PZ_Data(
    key        NUMBER(8, 0)    NOT NULL,
    row_key    NUMBER(8, 0)    NOT NULL,
    type       VARCHAR2(1),
    r_value    BINARY_FLOAT    NOT NULL,
    r_error    BINARY_FLOAT,
    i_value    BINARY_FLOAT    NOT NULL,
    i_error    BINARY_FLOAT,
    CONSTRAINT PZD01 CHECK (row_key >= 0),
    CONSTRAINT PZD02 CHECK (type IN ('P','Z','N','D')),
    CONSTRAINT PZD00 PRIMARY KEY (key, row_key)
    USING INDEX
        LOGGING, 
    CONSTRAINT PZ_Dat_PZ FOREIGN KEY (key)
    REFERENCES PZ(key)
)
TABLESPACE IR_DATA
LOGGING
;

Sensitivity

Table Name	Sensitivity	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate,stage_seq	
Definition	Data associating a channel with a sensitivity	
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR2(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		VARCHAR2(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		NUMBER(8, 0)	N	This attribute denotes the stage number	 
channel		VARCHAR2(8)	Y	Channel name	 
channelsrc		VARCHAR2(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		BINARY_FLOAT	N	The gain (Sd) at this stage, or the sensitivity (Sd) for the channel	 
frequency		BINARY_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 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Se01	frequency >= 0.0	 
	Check	Se02	stage_seq >= 0	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
Channel_Data	Identifying	One To Zero or More	Sen_Cha_Dat				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE Sensitivity(
    net            VARCHAR2(8)     NOT NULL,
    sta            VARCHAR2(6)     NOT NULL,
    seedchan       VARCHAR2(3)     NOT NULL,
    location       VARCHAR2(2)     NOT NULL,
    ondate         DATE            NOT NULL,
    stage_seq      NUMBER(8, 0)    NOT NULL,
    channel        VARCHAR2(8),
    channelsrc     VARCHAR2(8),
    offdate        DATE,
    sensitivity    BINARY_FLOAT    NOT NULL,
    frequency      BINARY_FLOAT,
    lddate         DATE            DEFAULT (SYSDATE),
    CONSTRAINT Se01 CHECK (frequency >= 0.0),
    CONSTRAINT Se02 CHECK (stage_seq >= 0),
    CONSTRAINT Se00 PRIMARY KEY (net, sta, seedchan, location, ondate, stage_seq)
    USING INDEX
        LOGGING, 
    CONSTRAINT Sen_Cha_Dat FOREIGN KEY (net, sta, seedchan, location, ondate)
    REFERENCES Channel_Data(net, sta, seedchan, location, ondate)
)
TABLESPACE IR_DATA
LOGGING
;

Simple_Response

Table Name	Simple_Response	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate	
Definition	Summary information on a simplified response	
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
seedchan		VARCHAR2(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		VARCHAR2(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		VARCHAR2(8)	Y	Channel name	 
channelsrc		VARCHAR2(8)	Y	Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)	 
natural_frequency		BINARY_FLOAT	Y	Natural frequency	 
damping_constant		BINARY_FLOAT	Y	This attribute denotes the damping constant of the system	 
gain		BINARY_FLOAT	Y	This attribute denotes the gain of the system. The units of the gain are given by the gain_units attribute	 
gain_units		VARCHAR2(20)	N	This attribute denotes the units of the gain of the system, as given by the gain attribute	 
low_freq_corner		BINARY_FLOAT	Y	Low frequency corner	 
high_freq_corner		BINARY_FLOAT	Y	High frequency corner	 
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	 
dlogsens		NUMBER(8, 0)	Y	Digitizer sensitivity	 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	SiRe02	gain_units IN ('DU/M/S','DU/M/S**2','counts/(cm/sec)','counts/(cm/sec2)')	 
	Check	SiRe01	natural_frequency >= 0.0	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
Channel_Data	Identifying	One To Zero or More	Sim_Res_Cha_Dat				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE Simple_Response(
    net                  VARCHAR2(8)     NOT NULL,
    sta                  VARCHAR2(6)     NOT NULL,
    seedchan             VARCHAR2(3)     NOT NULL,
    location             VARCHAR2(2)     NOT NULL,
    ondate               DATE            NOT NULL,
    channel              VARCHAR2(8),
    channelsrc           VARCHAR2(8),
    natural_frequency    BINARY_FLOAT,
    damping_constant     BINARY_FLOAT,
    gain                 BINARY_FLOAT,
    gain_units           VARCHAR2(20)    NOT NULL,
    low_freq_corner      BINARY_FLOAT,
    high_freq_corner     BINARY_FLOAT,
    offdate              DATE,
    lddate               DATE            DEFAULT (SYSDATE),
    dlogsens             NUMBER(8, 0),
    CONSTRAINT SiRe02 CHECK (gain_units IN ('DU/M/S','DU/M/S**2','counts/(cm/sec)','counts/(cm/sec2)')),
    CONSTRAINT SiRe01 CHECK (natural_frequency >= 0.0),
    CONSTRAINT SiRe00 PRIMARY KEY (net, sta, seedchan, location, ondate)
    USING INDEX
        LOGGING, 
    CONSTRAINT Sim_Res_Cha_Dat FOREIGN KEY (net, sta, seedchan, location, ondate)
    REFERENCES Channel_Data(net, sta, seedchan, location, ondate)
)
TABLESPACE IR_DATA
LOGGING
;

Station_Comment

Table Name	Station_Comment	
Owner Name		
Primary Keys	net,sta,ondate,comment_id	
Definition	Comments for a station	
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR2(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		NUMBER(8, 0)	N	The comment code key of the associated Comment Description Dictionary	 
offdate		DATE	Y	This attribute denotes the end date	 
comment_level		NUMBER(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 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
D_Comment	Identifying	One To Zero or More	Sta_Com_D_Com				NO	NO	 
Station_Data	Identifying	One To Zero or More	Sta_Com_Sta_Dat				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
DDL Code 

CREATE TABLE Station_Comment(
    net              VARCHAR2(8)     NOT NULL,
    sta              VARCHAR2(6)     NOT NULL,
    ondate           DATE            NOT NULL,
    comment_id       NUMBER(8, 0)    NOT NULL,
    offdate          DATE,
    comment_level    NUMBER(8, 0),
    lddate           DATE            DEFAULT (SYSDATE),
    CONSTRAINT StC00 PRIMARY KEY (net, sta, ondate, comment_id)
    USING INDEX
        LOGGING, 
    CONSTRAINT Sta_Com_Sta_Dat FOREIGN KEY (net, sta, ondate)
    REFERENCES Station_Data(net, sta, ondate),
    CONSTRAINT Sta_Com_D_Com FOREIGN KEY (comment_id)
    REFERENCES D_Comment(id)
)
TABLESPACE IR_DATA
LOGGING
;

Station_Data

Table Name	Station_Data	
Owner Name		
Primary Keys	net,sta,ondate	
Definition	Summary information on a station	
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sta		VARCHAR2(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		BINARY_FLOAT	Y	Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes	 
lon		BINARY_FLOAT	Y	Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian	 
elev		BINARY_FLOAT	Y	Elevation. This attribute is the elevation of a seismic station relative to mean sea level	 
staname		VARCHAR2(60)	Y	Station name/description. This is the full name of the station whose code-name is in sta	 
net_id		NUMBER(8, 0)	Y	The abbreviation lookup code from the Generic Abbreviation Dictionary, that refers to the network to which the station belongs	 
word_32		NUMBER(8, 0)	N	The swap order in which 32-bit quantities are specified in the data headers	 
word_16		NUMBER(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 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StD02	lat >= -90.0 AND lat <= 90.0	 
	Check	StD03	lon >= -180.0 AND lon <= 180.0	 
Foreign Keys 

 Parent Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Supertype	Deferrable	
D_Abbreviation	Non-Identifying	Zero or One to Zero or More	Sta_Dat_D_Abb				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
Channel_Data	Identifying	One To Zero or More	Cha_Dat_Sta_Dat				NO	NO	 
Station_Comment	Identifying	One To Zero or More	Sta_Com_Sta_Dat				NO	NO	 
DDL Code 

CREATE TABLE Station_Data(
    net        VARCHAR2(8)     NOT NULL,
    sta        VARCHAR2(6)     NOT NULL,
    ondate     DATE            NOT NULL,
    lat        BINARY_FLOAT,
    lon        BINARY_FLOAT,
    elev       BINARY_FLOAT,
    staname    VARCHAR2(60),
    net_id     NUMBER(8, 0),
    word_32    NUMBER(8, 0)    NOT NULL,
    word_16    NUMBER(8, 0)    NOT NULL,
    offdate    DATE,
    lddate     DATE            DEFAULT (SYSDATE),
    CONSTRAINT StD02 CHECK (lat >= -90.0 AND lat <= 90.0),
    CONSTRAINT StD03 CHECK (lon >= -180.0 AND lon <= 180.0),
    CONSTRAINT StD00 PRIMARY KEY (net, sta, ondate)
    USING INDEX
        LOGGING, 
    CONSTRAINT Sta_Dat_D_Abb FOREIGN KEY (net_id)
    REFERENCES D_Abbreviation(id)
)
TABLESPACE IR_DATA
LOGGING
;

Oracle Sequence Summary Report

Name	ObjectType	
ncedcdba.abbseq	Sequence	
ncedcdba.comseq	Sequence	
ncedcdba.dcseq	Sequence	
ncedcdba.dmseq	Sequence	
ncedcdba.forseq	Sequence	
ncedcdba.poseq	Sequence	
ncedcdba.pzseq	Sequence	
ncedcdba.uniseq	Sequence	

Oracle Sequence Detail Report

ncedcdba.abbseq

Name	ncedcdba.abbseq	
ObjectType	Sequence	
Description 

Sequence for primary key D_Abbreviation.id	
SQL 

CREATE SEQUENCE NCEDCDBA.ABBSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER
	
ncedcdba.comseq

Name	ncedcdba.comseq	
ObjectType	Sequence	
Description 

Sequence for primary key D_Comment.id	
SQL 

CREATE SEQUENCE NCEDCDBA.COMSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER
	
ncedcdba.dcseq

Name	ncedcdba.dcseq	
ObjectType	Sequence	
Description 

Sequence for primary key DC.key	
SQL 

CREATE SEQUENCE NCEDCDBA.DCSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER
	
ncedcdba.dmseq

Name	ncedcdba.dmseq	
ObjectType	Sequence	
Description 

Sequence for primary key DM.key	
SQL 

CREATE SEQUENCE NCEDCDBA.DMSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER
	
ncedcdba.forseq

Name	ncedcdba.forseq	
ObjectType	Sequence	
Description 

Sequence for primary key D_Format.id	
SQL 

CREATE SEQUENCE NCEDCDBA.FORSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER
	
ncedcdba.poseq

Name	ncedcdba.poseq	
ObjectType	Sequence	
Description 

Sequence for primary key PN.key	
SQL 

CREATE SEQUENCE NCEDCDBA.POSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER
	
ncedcdba.pzseq

Name	ncedcdba.pzseq	
ObjectType	Sequence	
Description 

Sequence for primary key PZ.key	
SQL 

CREATE SEQUENCE NCEDCDBA.PZSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER
	
ncedcdba.uniseq

Name	ncedcdba.uniseq	
ObjectType	Sequence	
Description 

Sequence for primary key D_Unit.id	
SQL 

CREATE SEQUENCE NCEDCDBA.UNISEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER