Diagram Report

 NCEDC/TriNet Application
Version 1.0.1

Berkeley Seismological Laboratory
Stephane Zuzlewski
Last Modified 2/20/2007
Copyright 2007 NCEDC/TriNet
 
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	          

Model Summary Report

Name	DatabasePlatform	 
Logical	Logical	
NCEDC	Oracle 9i	

Model Detail Reports

Logical

Model Name	Logical	
Database Platform	Logical	

Entity Summary Report

Entity Name	Entity Type	Primary Keys	 # Attr	
appchannels	Dependent	progid,net,sta,seedchan,location	9	
applications	Independent	progid	3	
channelmap_ampparms	Independent	net,sta,seedchan,location,ondate	10	
channelmap_codaparms	Independent	net,sta,seedchan,location,ondate	11	
config_channel	Dependent	progid,net,sta,seedchan,location	7	
credit	Independent	id,tname	3	
credit_alias	Independent	alias,keyid	2	
gazetteerbigtown	Dependent	gazid	4	
gazetteerfault	Dependent	gazid	3	
GazetteerLine	Independent	gazid	7	
gazetteerpt	Independent	gazid	12	
gazetteerquake	Dependent	gazid	3	
gazetteerquarry	Dependent	gazid	3	
gazetteertown	Dependent	gazid	4	
gazetteertype	Independent	code	3	
jasieventlock	Independent	evid	5	
program	Independent	progid	3	
request_card	Independent	rcid	17	
rt_role	Independent		2	
stamapping	Independent	net,sta	5	
unassocamp	Independent	ampid	27	

Entity Detail Reports

appchannels

Entity Name	appchannels	
Owner Name		
Primary Keys	progid,net,sta,seedchan,location	
Definition	Associates NSCL stream codes with programs (used in Jiggle)	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
progid		NUMERIC(8, 0)	N	Keys to CONFIG_CHANNEL table	 
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 	 
config		VARCHAR(64)	Y	Misc note used by config file generation scripts.  Originally intended to identify configs within a program group	 
ondate		DATE	Y	This attribute denotes the start date 	 
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)	 
Relationships 

 Parent Relationships: 

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

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

applications

Entity Name	applications	
Owner Name		
Primary Keys	progid	
Definition	Maps Program Names to PROGID's (used in Jiggle)	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
progid		NUMERIC(8, 0)	N	Primary Key	 
name		VARCHAR(16)	N	Program name used in sql_chanloader system.  Example: AmpGen	 
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	prog02_1	progid > 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	
appchannels	Identifying	One To Zero or More					NO	 

channelmap_ampparms

Entity Name	channelmap_ampparms	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate	
Definition	Channel clipping count values (used by magnitude algorithms)	
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 	 
offdate		DATE	N	This attribute denotes the end date 	 
channel		VARCHAR(3)	Y	Channel name 	 
channelsrc		VARCHAR(8)	Y	Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) 	 
clip		NUMERIC(14, 2)	Y	Sample counts at which signal clips	 
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	

channelmap_codaparms

Entity Name	channelmap_codaparms	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate	
Definition	Channel response dependent data (used by coda magnitude algorithms)	
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 	 
offdate		DATE	N	This attribute denotes the end date 	 
channel		VARCHAR(3)	Y	Channel name 	 
channelsrc		VARCHAR(8)	Y	Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) 	 
cutoff		NUMERIC(8, 2)	Y	2-sec averaged absolute value amplitude counts	 
gain_corr		NUMERIC(6, 3)	Y	Magnitude units correction	 
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	

config_channel

Entity Name	config_channel	
Owner Name		
Primary Keys	progid,net,sta,seedchan,location	
Definition	Associates NSCL stream codes with programs (used in the sql_chanloader system)	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
progid		NUMERIC(8, 0)	N	Keys to CONFIG_CHANNEL table	 
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 	 
config		VARCHAR(64)	Y	Misc note used by config file generation scripts.  Originally intended to identify configs within a program group	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype 	 
location		VARCHAR(2)	N	Describes the individual sites on an array station, operated by the same network operator 	 
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	
program	Identifying	One To Zero or More					NO	 
 Child Relationships: 

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

credit

Entity Name	credit	
Owner Name		
Primary Keys	id,tname	
Definition	Associates a credit reference to a table row (used by Jiggle)	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
id		NUMERIC(15, 0)	N	Primary key id like evid,orid,magid,mecid	 
tname		VARCHAR(30)	N	Name of table in which id is a key	 
refer		VARCHAR(80)	N	Credit reference (e.g. keyid of credit_alias table)	 
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	

credit_alias

Entity Name	credit_alias	
Owner Name		
Primary Keys	alias,keyid	
Definition	Credit Information (used by Jiggle)	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
alias		VARCHAR(32)	N	Host, application, or schema username	 
keyid		VARCHAR(32)	N	String mapped to alias (e.g. credit.refer)	 
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	

gazetteerbigtown

Entity Name	gazetteerbigtown	
Owner Name		
Primary Keys	gazid	
Definition	Ancillary descriptive data for significant town entries in gazetteerpt table	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
gazid		NUMERIC(16, 0)	N	References gazetteerpt.gazid	 
pop		NUMERIC(10, 0)	Y	Population >= 0	 
remark		VARCHAR(80)	Y	Information about town	 
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	gazbigtown_pop	pop >= 0	 
Relationships 

 Parent Relationships: 

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

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

gazetteerfault

Entity Name	gazetteerfault	
Owner Name		
Primary Keys	gazid	
Definition	Ancillary descriptive data for fault entries in gazetteerpt table	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
gazid		NUMERIC(0, 0)	N	References gazetteerpt.gazid	 
remark		VARCHAR(80)	Y	Ancillary description of fault	 
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	
GazetteerLine	Identifying	One To Zero or More					NO	 
 Child Relationships: 

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

GazetteerLine

Entity Name	GazetteerLine	
Owner Name		
Primary Keys	gazid	
Definition	Graphical line segments are defined by series of binary lat,lon stored as BLOB type (for fault lines)	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
gazid		NUMERIC(0, 0)	N	References gazetteerpt.gazid	 
type		NUMERIC(3, 0)	N	References gazetteertype.code	 
name		VARCHAR(80)	N	Name of line group	 
line		NUMERIC(0, 0)	N	Line group segment number (>=0)	 
format		VARCHAR(16)	Y	Known binary data byte type	 
points		PICTURE	Y	Binary data	 
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	gazline_value_format	format in ('double', 'float', 'int', 'long', 'char', 'byte')	 
	Check	gazline_value_line	line >= 0	 
Relationships 

 Parent Relationships: 

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

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

gazetteerpt

Entity Name	gazetteerpt	
Owner Name		
Primary Keys	gazid	
Definition	Geographic points of interest described by lat,lon,z and other map location data	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
gazid		NUMERIC(16, 0)	N	Derived from sequence gazseq	 
type		NUMERIC(3, 0)	N	References gazetteertype.code	 
lat		NUMERIC(9, 7)	N	Latitude must be within +/- 90	 
lon		NUMERIC(10, 7)	N	Longitude must be within +/-180	 
z		NUMERIC(7, 0)	Y	Elevation (+ is above sea level)	 
name		VARCHAR(48)	N	Point place name	 
state		VARCHAR(2)	Y	State where point is located	 
county		VARCHAR(32)	Y	County where point is located	 
map		VARCHAR(48)	Y	A map reference	 
datumh		VARCHAR(8)	Y	Map horizontal datum (eg. WGS84)	 
datumv		VARCHAR(8)	Y	Map vertical datum	 
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	gazpt_lat	lat >= -90.0 and lat <= 90.0	 
	Check	gazpt_lon	lon >= -180.0 and lon <= 180.0	 
Relationships 

 Parent Relationships: 

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

Entity Name	Type	Cardinality	Business Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
gazetteerbigtown	Identifying	One To Zero or More					NO	 
gazetteerquake	Identifying	One To Zero or More					NO	 
gazetteerquarry	Identifying	One To Zero or More					NO	 
gazetteertown	Identifying	One To Zero or More					NO	 

gazetteerquake

Entity Name	gazetteerquake	
Owner Name		
Primary Keys	gazid	
Definition	Ancillary descriptive data for earthquake entries in gazetteerpt table	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
gazid		NUMERIC(16, 0)	N	References gazetteerpt.gazid	 
remark		VARCHAR(80)	N	Information about earthquake	 
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	
gazetteerpt	Identifying	One To Zero or More					NO	 
 Child Relationships: 

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

gazetteerquarry

Entity Name	gazetteerquarry	
Owner Name		
Primary Keys	gazid	
Definition	Ancillary descriptive data for quarry entries in gazetteerpt table	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
gazid		NUMERIC(16, 0)	N	References gazetteerpt.gazid	 
remark		VARCHAR(80)	N	Information about quarry	 
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	
gazetteerpt	Identifying	One To Zero or More					NO	 
 Child Relationships: 

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

gazetteertown

Entity Name	gazetteertown	
Owner Name		
Primary Keys	gazid	
Definition	Ancillary descriptive data for town entries in gazetteerpt table	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
gazid		NUMERIC(16, 0)	N	References gazetteerpt.gazid	 
pop		NUMERIC(10, 0)	Y	Population >= 0	 
remark		VARCHAR(80)	Y	Information about town	 
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	gaztown_pop	pop >= 0	 
Relationships 

 Parent Relationships: 

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

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

gazetteertype

Entity Name	gazetteertype	
Owner Name		
Primary Keys	code	
Definition	Geographic map type keys and description	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
code		NUMERIC(3, 0)	N	A number tag	 
name		VARCHAR(32)	N	A collective geographic type 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	
GazetteerLine	Non-Identifying	One To Zero or More					NO	 
gazetteerpt	Non-Identifying	One To Zero or More					NO	 

jasieventlock

Entity Name	jasieventlock	
Owner Name		
Primary Keys	evid	
Definition	Current event locks (used in Jiggle)	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
evid		NUMERIC(0, 0)	N	Event identifier. Each event is assigned a unique integer which identifies it in a database	 
hostname		VARCHAR(40)	Y	URL of computer that has locked the event	 
application		VARCHAR(20)	Y	Name of computer application that has locked the event	 
username		VARCHAR(20)	Y	Username on remote computer that has locked the event	 
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	
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	

program

Entity Name	program	
Owner Name		
Primary Keys	progid	
Definition	Maps Program Names to PROGID's (used in sql_chanloader system)	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
progid		NUMERIC(8, 0)	N	Primary Key	 
name		VARCHAR(16)	N	Program name used in sql_chanloader system.  Example: AmpGen	 
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	prog02	progid > 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	
config_channel	Identifying	One To Zero or More					NO	 

request_card

Entity Name	request_card	
Owner Name		
Primary Keys	rcid	
Definition	List of channel time windows to be archived	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
evid		NUMERIC(15, 0)	Y	Event identifier. Each event is assigned a unique integer which identifies it in a database	 
auth		VARCHAR(15)	N	The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record 	 
subsource		VARCHAR(8)	N	A second identifier to specify the system or process that derived the data. e.g., the origin's AUTH is CI, but the subsource (the solution) was computed by JIGGLE 	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network 	 
sta		VARCHAR(8)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 	 
seedchan		VARCHAR(8)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code 	 
staauth		VARCHAR(15)	N	Purpose unknown (always same as subsource)	 
channel		VARCHAR(8)	N	Channel name	 
datetime_on		NUMERIC(25, 10)	N	Start time of time window to save	 
datetime_off		NUMERIC(25, 10)	N	End time of time window to save	 
request_type		VARCHAR(1)	N	Single character flag describing request type	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype 	 
rcid		NUMERIC(15, 0)	N	Unique request row number. Derived from REQSEQ.	 
location		VARCHAR(2)	N	Describes the individual sites on an array station, operated by the same network operator 	 
retry		NUMERIC(38, 0)	Y	Count of attempts to retrieve this waveform	 
lastretry		DATE	Y	Time of last attempt to retrieve this waveform	 
priority		NUMERIC(0, 0)	Y	Rows are processed in priority order, 1 is highest priority	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	REQ01	request_type in('T','C')	 
	Check	REQ02	retry >=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	

rt_role

Entity Name	rt_role	
Owner Name		
Primary Keys		
Definition	This table is used to store information about the current status of the RT machine. RT System runs two machines in parallel. One is always 'primary' and another is always 'shadow'. You can find out using this table if the machine in question is primary or shadow. Whenever the status of the RT machine change from 'primary' to 'shadow' or vice versa, the entry is created in the table with the timestamp	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
primary_system		VARCHAR(5)	Y	It stores (not enforced) two string values in the field. 'true' and 'false'. If the value is 'true', the system is primary and if the value is 'false' the system is shadow	 
modification_time		DATE	Y	Time when status is updated	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
modification_time	Default		(SYSDATE)	 
	Check	rt_role01	primary_system IN ('true', 'false', 'TRUE', 'FALSE')	 
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	

stamapping

Entity Name	stamapping	
Owner Name		
Primary Keys	net,sta	
Definition	Provides geographic station location descriptions and maps station names to station numbers for the Strong-Motion 
Community	
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 	 
stanumber		NUMERIC(8, 0)	N	Station Number	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datat	 
locdescr		VARCHAR(40)	Y	Geographic description of station location	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	stamap01	stanumber > 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	

unassocamp

Entity Name	unassocamp	
Owner Name		
Primary Keys	ampid	
Definition	Stores imported unassociated amplitudes	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
ampid		NUMERIC(15, 0)	N	Amplitude identification. Each amplitude is assigned a unique positive integer identifying it. This number is used in the AssocAmO relation along with the origin identifier to link Amp and Origin. This number is used also in the AssocAmM relation along with the magnitude identifier to link Amp and Netmag 	 
commid		NUMERIC(15, 0)	Y	Comment identification. This is a key used to point to free-form comments entered in the Remark relation. These comments store additional information about a tuple in another relation. Within the Remark relation, there may be many tuples with the same commid and different lineno, but the same commid will appear in only one other tuple among the rest of the relations in the database 	 
datetime		NUMERIC(25, 10)	N	The date of associated with information in the record, in true epoch format 	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 	 
net		VARCHAR(8)	Y	Unique network identifier. This character string is the name of a seismic network 	 
auth		VARCHAR(15)	N	The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record 	 
subsource		VARCHAR(8)	Y	A second identifier to specify the system or process that derived the data. e.g., the origin's AUTH is CI, but the subsource (the solution) was computed by JIGGLE 	 
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.) 	 
seedchan		VARCHAR(3)	Y	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code 	 
location		VARCHAR(2)	Y	Describes the individual sites on an array station, operated by the same network operator 	 
iphase		VARCHAR(8)	Y	Reported phase. This eight-character field holds the name initially given to a seismic phase. Standard seismological labels for the types of signals (or phases) are used (e.g., P, PKP, PcP, pP). Both upper and lower case letters are available and should be used when appropriate, for example, pP or PcP 	 
amplitude		FLOAT	N	Amplitude in appropriate units for type 	 
amptype		VARCHAR(8)	Y	Amplitude type 	 
units		VARCHAR(4)	N	Units of amplitude 	 
ampmeas		VARCHAR(1)	Y	Amplitude measure 	 
eramp		NUMERIC(5, 3)	Y	Uncertainty in amplitude measurement 	 
flagamp		VARCHAR(4)	Y	This attribute is a flag to indicate whether amplitude is over P packet, S packet, entire waveform, etc 	 
per		NUMERIC(10, 4)	Y	Signal period. This attribute is the period of the signal described by the amplitude record 	 
snr		FLOAT	Y	Signal-to-noise ratio. This is an estimate of the signal relative to that of the noise immediately preceding it 	 
tau		NUMERIC(9, 4)	Y	Coda duration (F-P time) 	 
quality		NUMERIC(2, 1)	Y	This attribute describes the completeness of the time window of data. A complete time window is 1.0, an incomplete time window is 0.0. If an incomplete time window has been human-reviewed and the analyst is confident that the peak amplitude was recorded and properly computed despite the presence of data gaps, the value is set to 0.5 to indicate the window contains data gaps, but is usable 	 
rflag		VARCHAR(2)	Y	This flag describes whether an observation was generated automatically, by a human, or has been finalized 	 
cflag		VARCHAR(2)	Y	This flag indicates whether the amplitude value is below noise, on scale or clipped 	 
wstart		FLOAT	N	Start of time window of amplitude measurement 	 
duration		FLOAT	N	Duration of amplitude reading 	 
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	UNASSOCAMP04	AMPTYPE IN ('C','WA','WAS','PGA','PGV','PGD', 'WAC','WAU','IV2','SP.3','SP1.0','SP3.0', 'ML100','ME100','EGY', 'HEL')	 
	Check	UNASSOCAMP06	eramp >= 0.0	 
	Check	UNASSOCAMP07	flagamp in ('P','S','R','PP','ALL','SUR')	 
	Check	UNASSOCAMP08	per > 0.0	 
	Check	UNASSOCAMP09	tau > 0.0	 
	Check	UNASSOCAMP10	units in ('c','s','mm','cm','m','ms','mss','cms','cmss','mms','mmss','mc','nm','e','iovs','spa','none')	 
	Check	UNASSOCAMP11	quality >=0.0 and quality <=1.0	 
	Check	UNASSOCAMP12	rflag in ('a','h','f','A','H','F')	 
	Check	UNASSOCAMP13	cflag in ('bn', 'os','cl','BN','OS','CL')	 
	Check	UNASSOCAMP02	amplitude >=0	 
	Check	UNASSOCAMP01	ampid > 0	 
	Check	UNASSOCAMP03	ampmeas in ('0','1')	 
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	

Model Detail Reports

NCEDC

Model Name	NCEDC	
Database Platform	Oracle 9i	

Table Summary Report

Table Name	Table Type	Primary Keys	# Col	
appchannels	Dependent	progid,net,sta,seedchan,location,	9	
applications	Independent	progid,	3	
channelmap_ampparms	Independent	net,sta,seedchan,location,ondate,	10	
channelmap_codaparms	Independent	net,sta,seedchan,location,ondate,	11	
config_channel	Dependent	progid,net,sta,seedchan,location	7	
credit	Independent	id,tname,	3	
credit_alias	Independent	alias,keyid	2	
gazetteerbigtown	Dependent	gazid,	4	
gazetteerfault	Dependent	gazid,	3	
gazetteerline	Independent	gazid,	7	
gazetteerpt	Independent	gazid,	12	
gazetteerquake	Dependent	gazid,	3	
gazetteerquarry	Dependent	gazid,	3	
gazetteertown	Dependent	gazid,	4	
gazetteertype	Independent	code,	3	
jasieventlock	Independent	evid,	5	
program	Independent	progid,	3	
request_card	Independent	rcid,	17	
rt_role	Independent		2	
stamapping	Independent	net,sta,	5	
unassocamp	Independent	ampid	27	

Table Detail Reports

appchannels

Table Name	appchannels	
Owner Name		
Primary Keys	progid,net,sta,seedchan,location	
Definition	Associates NSCL stream codes with programs (used in Jiggle)	
Columns 

Column Name	Domain	Datatype	Null	Definition	
progid		NUMBER(8, 0)	N	Keys to CONFIG_CHANNEL table	 
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 	 
config		VARCHAR2(64)	Y	Misc note used by config file generation scripts.  Originally intended to identify configs within a program group	 
ondate		DATE	Y	This attribute denotes the start date 	 
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	 
Foreign Keys 

 Parent Relationships: 

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

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

CREATE TABLE appchannels(
    progid      NUMBER(8, 0)    NOT NULL,
    net         VARCHAR2(8)     NOT NULL,
    sta         VARCHAR2(6)     NOT NULL,
    seedchan    VARCHAR2(3)     NOT NULL,
    location    VARCHAR2(2)     NOT NULL,
    config      VARCHAR2(64),
    ondate      DATE,
    offdate     DATE,
    lddate      DATE            DEFAULT SYSDATE,
    CONSTRAINT config_chankey01_1 PRIMARY KEY (progid, net, sta, seedchan, location), 
    CONSTRAINT Refapplications12 FOREIGN KEY (progid)
    REFERENCES applications(progid)
)
;

applications

Table Name	applications	
Owner Name		
Primary Keys	progid	
Definition	Maps Program Names to PROGID's (used in Jiggle)	
Columns 

Column Name	Domain	Datatype	Null	Definition	
progid		NUMBER(8, 0)	N	Primary Key	 
name		VARCHAR2(16)	N	Program name used in sql_chanloader system.  Example: AmpGen	 
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	prog02_1	progid > 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	
appchannels	Identifying	One To Zero or More					NO	NO	 
DDL Code 

CREATE TABLE applications(
    progid    NUMBER(8, 0)    NOT NULL,
    name      VARCHAR2(16)    NOT NULL,
    lddate    DATE            DEFAULT SYSDATE,
    CONSTRAINT prog02_1 CHECK (progid > 0),
    CONSTRAINT progkey01_1 PRIMARY KEY (progid)
)
;

channelmap_ampparms

Table Name	channelmap_ampparms	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate	
Definition	Channel clipping count values (used by magnitude algorithms)	
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 	 
offdate		DATE	N	This attribute denotes the end date 	 
channel		VARCHAR2(3)	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.) 	 
clip		NUMBER(14, 2)	Y	Sample counts at which signal clips	 
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	
DDL Code 

CREATE TABLE channelmap_ampparms(
    net           VARCHAR2(8)      NOT NULL,
    sta           VARCHAR2(6)      NOT NULL,
    seedchan      VARCHAR2(3)      NOT NULL,
    location      VARCHAR2(2)      NOT NULL,
    ondate        DATE             NOT NULL,
    offdate       DATE             NOT NULL,
    channel       VARCHAR2(3),
    channelsrc    VARCHAR2(8),
    clip          NUMBER(14, 2),
    lddate        DATE             DEFAULT (SYSDATE),
    CONSTRAINT cm_amp_key PRIMARY KEY (net, sta, seedchan, location, ondate)
)
;

channelmap_codaparms

Table Name	channelmap_codaparms	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate	
Definition	Channel response dependent data (used by coda magnitude algorithms)	
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 	 
offdate		DATE	N	This attribute denotes the end date 	 
channel		VARCHAR2(3)	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.) 	 
cutoff		NUMBER(8, 2)	Y	2-sec averaged absolute value amplitude counts	 
gain_corr		NUMBER(6, 3)	Y	Magnitude units correction	 
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	
DDL Code 

CREATE TABLE channelmap_codaparms(
    net           VARCHAR2(8)     NOT NULL,
    sta           VARCHAR2(6)     NOT NULL,
    seedchan      VARCHAR2(3)     NOT NULL,
    location      VARCHAR2(2)     NOT NULL,
    ondate        DATE            NOT NULL,
    offdate       DATE            NOT NULL,
    channel       VARCHAR2(3),
    channelsrc    VARCHAR2(8),
    cutoff        NUMBER(8, 2),
    gain_corr     NUMBER(6, 3),
    lddate        DATE            DEFAULT (SYSDATE),
    CONSTRAINT cm_coda_key PRIMARY KEY (net, sta, seedchan, location, ondate)
)
;

config_channel

Table Name	config_channel	
Owner Name		
Primary Keys	progid,net,sta,seedchan,location	
Definition	Associates NSCL stream codes with programs (used in the sql_chanloader system)	
Columns 

Column Name	Domain	Datatype	Null	Definition	
progid		NUMBER(8, 0)	N	Keys to CONFIG_CHANNEL table	 
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 	 
config		VARCHAR2(64)	Y	Misc note used by config file generation scripts.  Originally intended to identify configs within a program group	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype 	 
location		VARCHAR2(2)	N	Describes the individual sites on an array station, operated by the same network operator 	 
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	
program	Identifying	One To Zero or More					NO	NO	 
 Child Relationships: 

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

CREATE TABLE config_channel(
    progid      NUMBER(8, 0)    NOT NULL,
    net         VARCHAR2(8)     NOT NULL,
    sta         VARCHAR2(6)     NOT NULL,
    seedchan    VARCHAR2(3)     NOT NULL,
    config      VARCHAR2(64),
    lddate      DATE            DEFAULT (SYSDATE),
    location    VARCHAR2(2)     NOT NULL,
    CONSTRAINT config_chankey01 PRIMARY KEY (progid, net, sta, seedchan, location), 
    CONSTRAINT Refprogram8 FOREIGN KEY (progid)
    REFERENCES program(progid)
)
;

credit

Table Name	credit	
Owner Name		
Primary Keys	id,tname	
Definition	Associates a credit reference to a table row (used by Jiggle)	
Columns 

Column Name	Domain	Datatype	Null	Definition	
id		NUMBER(15, 0)	N	Primary key id like evid,orid,magid,mecid	 
tname		VARCHAR2(30)	N	Name of table in which id is a key	 
refer		VARCHAR2(80)	N	Credit reference (e.g. keyid of credit_alias table)	 
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	
DDL Code 

CREATE TABLE credit(
    id       NUMBER(15, 0)    NOT NULL,
    tname    VARCHAR2(30)     NOT NULL,
    refer    VARCHAR2(80)     NOT NULL,
    CONSTRAINT pk_credit PRIMARY KEY (id, tname)
)
;

credit_alias

Table Name	credit_alias	
Owner Name		
Primary Keys	alias,keyid	
Definition	Credit Information (used by Jiggle)	
Columns 

Column Name	Domain	Datatype	Null	Definition	
alias		VARCHAR2(32)	N	Host, application, or schema username	 
keyid		VARCHAR2(32)	N	String mapped to alias (e.g. credit.refer)	 
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	
DDL Code 

CREATE TABLE credit_alias(
    alias    VARCHAR2(32)    NOT NULL,
    keyid    VARCHAR2(32)    NOT NULL,
    CONSTRAINT pk_alias PRIMARY KEY (alias, keyid)
)
;

gazetteerbigtown

Table Name	gazetteerbigtown	
Owner Name		
Primary Keys	gazid	
Definition	Ancillary descriptive data for significant town entries in gazetteerpt table	
Columns 

Column Name	Domain	Datatype	Null	Definition	
gazid		NUMBER(16, 0)	N	References gazetteerpt.gazid	 
pop		NUMBER(10, 0)	Y	Population >= 0	 
remark		VARCHAR2(80)	Y	Information about town	 
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	gazbigtown_pop	pop >= 0	 
Foreign Keys 

 Parent Relationships: 

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

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

CREATE TABLE gazetteerbigtown(
    gazid     NUMBER(16, 0)    NOT NULL,
    pop       NUMBER(10, 0),
    remark    VARCHAR2(80),
    lddate    DATE             DEFAULT (SYSDATE),
    CONSTRAINT gazbigtown_pop CHECK (pop >= 0),
    CONSTRAINT gazbigtown_pk_gazid PRIMARY KEY (gazid), 
    CONSTRAINT gazbigtown_fk_gazid FOREIGN KEY (gazid)
    REFERENCES gazetteerpt(gazid)
)
;

gazetteerfault

Table Name	gazetteerfault	
Owner Name		
Primary Keys	gazid	
Definition	Ancillary descriptive data for fault entries in gazetteerpt table	
Columns 

Column Name	Domain	Datatype	Null	Definition	
gazid		NUMBER	N	References gazetteerpt.gazid	 
remark		VARCHAR2(80)	Y	Ancillary description of fault	 
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	
gazetteerline	Identifying	One To Zero or More	gazfault_fk_gazid				NO	NO	 
 Child Relationships: 

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

CREATE TABLE gazetteerfault(
    gazid     NUMBER          NOT NULL,
    remark    VARCHAR2(80),
    lddate    DATE            DEFAULT (SYSDATE),
    CONSTRAINT gazfault_pk_gazid PRIMARY KEY (gazid), 
    CONSTRAINT gazfault_fk_gazid FOREIGN KEY (gazid)
    REFERENCES gazetteerline(gazid)
)
;

gazetteerline

Table Name	gazetteerline	
Owner Name		
Primary Keys	gazid	
Definition	Graphical line segments are defined by series of binary lat,lon stored as BLOB type (for fault lines)	
Columns 

Column Name	Domain	Datatype	Null	Definition	
gazid		NUMBER	N	References gazetteerpt.gazid	 
type		NUMBER(3, 0)	N	References gazetteertype.code	 
name		VARCHAR2(80)	N	Name of line group	 
line		NUMBER	N	Line group segment number (>=0)	 
format		VARCHAR2(16)	Y	Known binary data byte type	 
points		BLOB	Y	Binary data	 
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	gazline_value_format	format in ('double', 'float', 'int', 'long', 'char', 'byte')	 
	Check	gazline_value_line	line >= 0	 
Foreign Keys 

 Parent Relationships: 

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

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
gazetteerfault	Identifying	One To Zero or More	gazfault_fk_gazid				NO	NO	 
DDL Code 

CREATE TABLE gazetteerline(
    gazid     NUMBER          NOT NULL,
    type      NUMBER(3, 0)    NOT NULL,
    name      VARCHAR2(80)    NOT NULL,
    line      NUMBER          NOT NULL,
    format    VARCHAR2(16),
    points    BLOB,
    lddate    DATE            DEFAULT (SYSDATE),
    CONSTRAINT gazline_value_format CHECK (format in ('double', 'float', 'int', 'long', 'char', 'byte')),
    CONSTRAINT gazline_value_line CHECK (line >= 0),
    CONSTRAINT gazline_pk_gazid PRIMARY KEY (gazid), 
    CONSTRAINT gazline_fk_type FOREIGN KEY (type)
    REFERENCES gazetteertype(code)
)
;

gazetteerpt

Table Name	gazetteerpt	
Owner Name		
Primary Keys	gazid	
Definition	Geographic points of interest described by lat,lon,z and other map location data	
Columns 

Column Name	Domain	Datatype	Null	Definition	
gazid		NUMBER(16, 0)	N	Derived from sequence gazseq	 
type		NUMBER(3, 0)	N	References gazetteertype.code	 
lat		NUMBER(9, 7)	N	Latitude must be within +/- 90	 
lon		NUMBER(10, 7)	N	Longitude must be within +/-180	 
z		NUMBER(7, 0)	Y	Elevation (+ is above sea level)	 
name		VARCHAR2(48)	N	Point place name	 
state		VARCHAR2(2)	Y	State where point is located	 
county		VARCHAR2(32)	Y	County where point is located	 
map		VARCHAR2(48)	Y	A map reference	 
datumh		VARCHAR2(8)	Y	Map horizontal datum (eg. WGS84)	 
datumv		VARCHAR2(8)	Y	Map vertical datum	 
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	gazpt_lat	lat >= -90.0 and lat <= 90.0	 
	Check	gazpt_lon	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	
gazetteertype	Non-Identifying	One To Zero or More	gazpt_fk_type				NO	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	Deferrable	
gazetteerbigtown	Identifying	One To Zero or More	gazbigtown_fk_gazid				NO	NO	 
gazetteerquake	Identifying	One To Zero or More	gazeq_fk_gazid				NO	NO	 
gazetteerquarry	Identifying	One To Zero or More	gazqry_fk_gazid				NO	NO	 
gazetteertown	Identifying	One To Zero or More	gaztown_fk_gazid				NO	NO	 
DDL Code 

CREATE TABLE gazetteerpt(
    gazid     NUMBER(16, 0)    NOT NULL,
    type      NUMBER(3, 0)     NOT NULL,
    lat       NUMBER(9, 7)     NOT NULL,
    lon       NUMBER(10, 7)    NOT NULL,
    z         NUMBER(7, 0),
    name      VARCHAR2(48)     NOT NULL,
    state     VARCHAR2(2),
    county    VARCHAR2(32),
    map       VARCHAR2(48),
    datumh    VARCHAR2(8),
    datumv    VARCHAR2(8),
    lddate    DATE             DEFAULT (SYSDATE),
    CONSTRAINT gazpt_lat CHECK (lat >= -90.0 and lat <= 90.0),
    CONSTRAINT gazpt_lon CHECK (lon >= -180.0 and lon <= 180.0),
    CONSTRAINT gazpt_pk_gazid PRIMARY KEY (gazid), 
    CONSTRAINT gazpt_fk_type FOREIGN KEY (type)
    REFERENCES gazetteertype(code)
)
;

gazetteerquake

Table Name	gazetteerquake	
Owner Name		
Primary Keys	gazid	
Definition	Ancillary descriptive data for earthquake entries in gazetteerpt table	
Columns 

Column Name	Domain	Datatype	Null	Definition	
gazid		NUMBER(16, 0)	N	References gazetteerpt.gazid	 
remark		VARCHAR2(80)	N	Information about earthquake	 
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	
gazetteerpt	Identifying	One To Zero or More	gazeq_fk_gazid				NO	NO	 
 Child Relationships: 

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

CREATE TABLE gazetteerquake(
    gazid     NUMBER(16, 0)    NOT NULL,
    remark    VARCHAR2(80)     NOT NULL,
    lddate    DATE             DEFAULT (SYSDATE),
    CONSTRAINT gazeq_pk_gazid PRIMARY KEY (gazid), 
    CONSTRAINT gazeq_fk_gazid FOREIGN KEY (gazid)
    REFERENCES gazetteerpt(gazid)
)
;

gazetteerquarry

Table Name	gazetteerquarry	
Owner Name		
Primary Keys	gazid	
Definition	Ancillary descriptive data for quarry entries in gazetteerpt table	
Columns 

Column Name	Domain	Datatype	Null	Definition	
gazid		NUMBER(16, 0)	N	References gazetteerpt.gazid	 
remark		VARCHAR2(80)	N	Information about quarry	 
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	
gazetteerpt	Identifying	One To Zero or More	gazqry_fk_gazid				NO	NO	 
 Child Relationships: 

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

CREATE TABLE gazetteerquarry(
    gazid     NUMBER(16, 0)    NOT NULL,
    remark    VARCHAR2(80)     NOT NULL,
    lddate    DATE             DEFAULT (SYSDATE),
    CONSTRAINT gazqry_pk_gazid PRIMARY KEY (gazid), 
    CONSTRAINT gazqry_fk_gazid FOREIGN KEY (gazid)
    REFERENCES gazetteerpt(gazid)
)
;

gazetteertown

Table Name	gazetteertown	
Owner Name		
Primary Keys	gazid	
Definition	Ancillary descriptive data for town entries in gazetteerpt table	
Columns 

Column Name	Domain	Datatype	Null	Definition	
gazid		NUMBER(16, 0)	N	References gazetteerpt.gazid	 
pop		NUMBER(10, 0)	Y	Population >= 0	 
remark		VARCHAR2(80)	Y	Information about town	 
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	gaztown_pop	pop >= 0	 
Foreign Keys 

 Parent Relationships: 

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

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

CREATE TABLE gazetteertown(
    gazid     NUMBER(16, 0)    NOT NULL,
    pop       NUMBER(10, 0),
    remark    VARCHAR2(80),
    lddate    DATE             DEFAULT (SYSDATE),
    CONSTRAINT gaztown_pop CHECK (pop >= 0),
    CONSTRAINT gaztown_pk_gazid PRIMARY KEY (gazid), 
    CONSTRAINT gaztown_fk_gazid FOREIGN KEY (gazid)
    REFERENCES gazetteerpt(gazid)
)
;

gazetteertype

Table Name	gazetteertype	
Owner Name		
Primary Keys	code	
Definition	Geographic map type keys and description	
Columns 

Column Name	Domain	Datatype	Null	Definition	
code		NUMBER(3, 0)	N	A number tag	 
name		VARCHAR2(32)	N	A collective geographic type 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	
gazetteerline	Non-Identifying	One To Zero or More	gazline_fk_type				NO	NO	 
gazetteerpt	Non-Identifying	Zero or One to Zero or More	gazpt_fk_type				NO	NO	 
DDL Code 

CREATE TABLE gazetteertype(
    code      NUMBER(3, 0)    NOT NULL,
    name      VARCHAR2(32)    NOT NULL,
    lddate    DATE            DEFAULT (SYSDATE),
    CONSTRAINT gaztype_pk_code PRIMARY KEY (code)
)
;

jasieventlock

Table Name	jasieventlock	
Owner Name		
Primary Keys	evid	
Definition	Current event locks (used in Jiggle)	
Columns 

Column Name	Domain	Datatype	Null	Definition	
evid		NUMBER	N	Event identifier. Each event is assigned a unique integer which identifies it in a database	 
hostname		VARCHAR2(40)	Y	URL of computer that has locked the event	 
application		VARCHAR2(20)	Y	Name of computer application that has locked the event	 
username		VARCHAR2(20)	Y	Username on remote computer that has locked the event	 
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	
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	
DDL Code 

CREATE TABLE jasieventlock(
    evid           NUMBER          NOT NULL,
    hostname       VARCHAR2(40),
    application    VARCHAR2(20),
    username       VARCHAR2(20),
    lddate         DATE,
    CONSTRAINT PK3 PRIMARY KEY (evid)
)
;

program

Table Name	program	
Owner Name		
Primary Keys	progid	
Definition	Maps Program Names to PROGID's (used in sql_chanloader system(	
Columns 

Column Name	Domain	Datatype	Null	Definition	
progid		NUMBER(8, 0)	N	Primary Key	 
name		VARCHAR2(16)	N	Program name used in sql_chanloader system.  Example: AmpGen	 
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	prog02	progid > 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	
config_channel	Identifying	One To Zero or More					NO	NO	 
DDL Code 

CREATE TABLE program(
    progid    NUMBER(8, 0)    NOT NULL,
    name      VARCHAR2(16)    NOT NULL,
    lddate    DATE            DEFAULT (SYSDATE),
    CONSTRAINT prog02 CHECK (progid > 0),
    CONSTRAINT progkey01 PRIMARY KEY (progid)
)
;

request_card

Table Name	request_card	
Owner Name		
Primary Keys	rcid	
Definition	List of channel time windows to be archived	
Columns 

Column Name	Domain	Datatype	Null	Definition	
evid		NUMBER(15, 0)	Y	Event identifier. Each event is assigned a unique integer which identifies it in a database	 
auth		VARCHAR2(15)	N	The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record 	 
subsource		VARCHAR2(8)	N	A second identifier to specify the system or process that derived the data. e.g., the origin's AUTH is CI, but the subsource (the solution) was computed by JIGGLE 	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network 	 
sta		VARCHAR2(8)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 	 
seedchan		VARCHAR2(8)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code 	 
staauth		VARCHAR2(15)	N	Purpose unknown (always same as subsource)	 
channel		VARCHAR2(8)	N	Channel name	 
datetime_on		NUMBER(25, 10)	N	Start time of time window to save	 
datetime_off		NUMBER(25, 10)	N	End time of time window to save	 
request_type		VARCHAR2(1)	N	Single character flag describing request type	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype 	 
rcid		NUMBER(15, 0)	N	Unique request row number. Derived from REQSEQ.	 
location		VARCHAR2(2)	N	Describes the individual sites on an array station, operated by the same network operator 	 
retry		NUMBER(38, 0)	Y	Count of attempts to retrieve this waveform	 
lastretry		DATE	Y	Time of last attempt to retrieve this waveform	 
priority		NUMBER	Y	Rows are processed in priority order, 1 is highest priority	 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	req01	request_type in('T','C')	 
	Check	req02	retry >=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	
DDL Code 

CREATE TABLE request_card(
    evid            NUMBER(15, 0),
    auth            VARCHAR2(15)      NOT NULL,
    subsource       VARCHAR2(8)       NOT NULL,
    net             VARCHAR2(8)       NOT NULL,
    sta             VARCHAR2(8)       NOT NULL,
    seedchan        VARCHAR2(8)       NOT NULL,
    staauth         VARCHAR2(15)      NOT NULL,
    channel         VARCHAR2(8)       NOT NULL,
    datetime_on     NUMBER(25, 10)    NOT NULL,
    datetime_off    NUMBER(25, 10)    NOT NULL,
    request_type    VARCHAR2(1)       NOT NULL,
    lddate          DATE              DEFAULT (SYSDATE),
    rcid            NUMBER(15, 0)     NOT NULL,
    location        VARCHAR2(2)       NOT NULL,
    retry           NUMBER(38, 0),
    lastretry       DATE,
    priority        NUMBER,
    CONSTRAINT req01 CHECK (request_type in('T','C')),
    CONSTRAINT req02 CHECK (retry >=0),
    CONSTRAINT request_cardkey01 PRIMARY KEY (rcid)
)
;

rt_role

Table Name	rt_role	
Owner Name		
Primary Keys		
Definition	This table is used to store information about the current status of the RT machine. RT System runs two machines in parallel. One is always 'primary' and another is always 'shadow'. You can find out using this table if the machine in question is primary or shadow. Whenever the status of the RT machine change from 'primary' to 'shadow' or vice versa, the entry is created in the table with the timestamp	
Columns 

Column Name	Domain	Datatype	Null	Definition	
primary_system		VARCHAR2(5)	Y	It stores (not enforced) two string values in the field. 'true' and 'false'. If the value is 'true', the system is primary and if the value is 'false' the system is shadow	 
modification_time		DATE	Y	Time when status is updated	 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
modification_time	Default		(SYSDATE)	 
	Check	rt_role01	primary_system IN ('true', 'false', 'TRUE', 'FALSE')	 
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	
DDL Code 

CREATE TABLE rt_role(
    primary_system       VARCHAR2(5),
    modification_time    DATE           DEFAULT (SYSDATE),
    CONSTRAINT rt_role01 CHECK (primary_system IN ('true', 'false', 'TRUE', 'FALSE'))
)
;

stamapping

Table Name	stamapping	
Owner Name		
Primary Keys	net,sta	
Definition	Provides geographic station location descriptions and maps station names to station numbers for the Strong-Motion 
Community	
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 	 
stanumber		NUMBER(8, 0)	N	Station Number	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datat	 
locdescr		VARCHAR2(40)	Y	Geographic description of station location	 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
	Check	stamap01	stanumber > 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	
DDL Code 

CREATE TABLE stamapping(
    net          VARCHAR2(8)     NOT NULL,
    sta          VARCHAR2(6)     NOT NULL,
    stanumber    NUMBER(8, 0)    NOT NULL,
    lddate       DATE,
    locdescr     VARCHAR2(40),
    CONSTRAINT stamap01 CHECK (stanumber > 0),
    CONSTRAINT stamapkey01 PRIMARY KEY (net, sta)
)
;

unassocamp

Table Name	unassocamp	
Owner Name		
Primary Keys	ampid	
Definition	Stores imported unassociated amplitudes	
Columns 

Column Name	Domain	Datatype	Null	Definition	
ampid		NUMBER(15, 0)	N	Amplitude identification. Each amplitude is assigned a unique positive integer identifying it. This number is used in the AssocAmO relation along with the origin identifier to link Amp and Origin. This number is used also in the AssocAmM relation along with the magnitude identifier to link Amp and Netmag 	 
commid		NUMBER(15, 0)	Y	Comment identification. This is a key used to point to free-form comments entered in the Remark relation. These comments store additional information about a tuple in another relation. Within the Remark relation, there may be many tuples with the same commid and different lineno, but the same commid will appear in only one other tuple among the rest of the relations in the database 	 
datetime		NUMBER(25, 10)	N	The date of associated with information in the record, in true epoch format 	 
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 	 
net		VARCHAR2(8)	Y	Unique network identifier. This character string is the name of a seismic network 	 
auth		VARCHAR2(15)	N	The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record 	 
subsource		VARCHAR2(8)	Y	A second identifier to specify the system or process that derived the data. e.g., the origin's AUTH is CI, but the subsource (the solution) was computed by JIGGLE 	 
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.) 	 
seedchan		VARCHAR2(3)	Y	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code 	 
location		VARCHAR2(2)	Y	Describes the individual sites on an array station, operated by the same network operator 	 
iphase		VARCHAR2(8)	Y	Reported phase. This eight-character field holds the name initially given to a seismic phase. Standard seismological labels for the types of signals (or phases) are used (e.g., P, PKP, PcP, pP). Both upper and lower case letters are available and should be used when appropriate, for example, pP or PcP 	 
amplitude		DOUBLE PRECISION	N	Amplitude in appropriate units for type 	 
amptype		VARCHAR2(8)	Y	Amplitude type 	 
units		VARCHAR2(4)	N	Units of amplitude 	 
ampmeas		VARCHAR2(1)	Y	Amplitude measure 	 
eramp		NUMBER(5, 3)	Y	Uncertainty in amplitude measurement 	 
flagamp		VARCHAR2(4)	Y	This attribute is a flag to indicate whether amplitude is over P packet, S packet, entire waveform, etc 	 
per		NUMBER(10, 4)	Y	Signal period. This attribute is the period of the signal described by the amplitude record 	 
snr		DOUBLE PRECISION	Y	Signal-to-noise ratio. This is an estimate of the signal relative to that of the noise immediately preceding it 	 
tau		NUMBER(9, 4)	Y	Coda duration (F-P time) 	 
quality		NUMBER(2, 1)	Y	This attribute describes the completeness of the time window of data. A complete time window is 1.0, an incomplete time window is 0.0. If an incomplete time window has been human-reviewed and the analyst is confident that the peak amplitude was recorded and properly computed despite the presence of data gaps, the value is set to 0.5 to indicate the window contains data gaps, but is usable 	 
rflag		VARCHAR2(2)	Y	This flag describes whether an observation was generated automatically, by a human, or has been finalized 	 
cflag		VARCHAR2(2)	Y	This flag indicates whether the amplitude value is below noise, on scale or clipped 	 
wstart		DOUBLE PRECISION	N	Start of time window of amplitude measurement 	 
duration		DOUBLE PRECISION	N	Duration of amplitude reading 	 
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	unassocamp04	AMPTYPE IN ('C','WA','WAS','PGA','PGV','PGD', 'WAC','WAU','IV2','SP.3','SP1.0','SP3.0', 'ML100','ME100','EGY', 'HEL')	 
	Check	unassocamp06	eramp >= 0.0	 
	Check	unassocamp07	flagamp in ('P','S','R','PP','ALL','SUR')	 
	Check	unassocamp08	per > 0.0	 
	Check	unassocamp09	tau > 0.0	 
	Check	unassocamp10	units in ('c','s','mm','cm','m','ms','mss','cms','cmss','mms','mmss','mc','nm','e','iovs','spa','none')	 
	Check	unassocamp11	quality >=0.0 and quality <=1.0	 
	Check	unassocamp12	rflag in ('a','h','f','A','H','F')	 
	Check	unassocamp13	cflag in ('bn', 'os','cl','BN','OS','CL')	 
	Check	unassocamp02	amplitude >=0	 
	Check	unassocamp01	ampid > 0	 
	Check	unassocamp03	ampmeas in ('0','1')	 
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	
DDL Code 

CREATE TABLE unassocamp(
    ampid         NUMBER(15, 0)       NOT NULL,
    commid        NUMBER(15, 0),
    datetime      NUMBER(25, 10)      NOT NULL,
    sta           VARCHAR2(6)         NOT NULL,
    net           VARCHAR2(8),
    auth          VARCHAR2(15)        NOT NULL,
    subsource     VARCHAR2(8),
    channel       VARCHAR2(8),
    channelsrc    VARCHAR2(8),
    seedchan      VARCHAR2(3),
    location      VARCHAR2(2),
    iphase        VARCHAR2(8),
    amplitude     DOUBLE PRECISION    NOT NULL,
    amptype       VARCHAR2(8),
    units         VARCHAR2(4)         NOT NULL,
    ampmeas       VARCHAR2(1),
    eramp         NUMBER(5, 3),
    flagamp       VARCHAR2(4),
    per           NUMBER(10, 4),
    snr           DOUBLE PRECISION,
    tau           NUMBER(9, 4),
    quality       NUMBER(2, 1),
    rflag         VARCHAR2(2),
    cflag         VARCHAR2(2),
    wstart        DOUBLE PRECISION    NOT NULL,
    duration      DOUBLE PRECISION    NOT NULL,
    lddate        DATE                DEFAULT (SYSDATE),
    CONSTRAINT unassocamp04 CHECK (AMPTYPE IN ('C','WA','WAS','PGA','PGV','PGD', 'WAC','WAU','IV2','SP.3','SP1.0','SP3.0', 'ML100','ME100','EGY', 'HEL')),
    CONSTRAINT unassocamp06 CHECK (eramp >= 0.0),
    CONSTRAINT unassocamp07 CHECK (flagamp in ('P','S','R','PP','ALL','SUR')),
    CONSTRAINT unassocamp08 CHECK (per > 0.0),
    CONSTRAINT unassocamp09 CHECK (tau > 0.0),
    CONSTRAINT unassocamp10 CHECK (units in ('c','s','mm','cm','m','ms','mss','cms','cmss','mms','mmss','mc','nm','e','iovs','spa','none')),
    CONSTRAINT unassocamp11 CHECK (quality >=0.0 and quality <=1.0),
    CONSTRAINT unassocamp12 CHECK (rflag in ('a','h','f','A','H','F')),
    CONSTRAINT unassocamp13 CHECK (cflag in ('bn', 'os','cl','BN','OS','CL')),
    CONSTRAINT unassocamp02 CHECK (amplitude >=0),
    CONSTRAINT unassocamp01 CHECK (ampid > 0),
    CONSTRAINT unassocamp03 CHECK (ampmeas in ('0','1')),
    CONSTRAINT unassocampkey01 PRIMARY KEY (ampid)
)
;