Diagram Report

 CISN/ANSS Application
Version 1.0.2

Berkeley Seismological Laboratory
Stephane Zuzlewski
Last Modified 1/31/2013
Copyright 2013 CISN/ANSS
 
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 10g	

Model Detail Reports

Logical

Model Name	Logical	
Database Platform	Logical	

Entity Summary Report

Entity Name	Entity Type	Primary Keys	 # Attr	
alarm_action	Independent	EVENT_ID,ALARM_ACTION,ACTION_STATE,MODCOUNT	5	
appchannels	Dependent	progid,net,sta,seedchan,location,ondate	9	
applications	Independent	progid	3	
assoc_region_group	Dependent	grpid,name	4	
assocnte	Independent	NTID,EVID	7	
autoposter	Independent	INSTANCENAME	12	
channelmap_ampparms	Independent	net,sta,seedchan,location,ondate	10	
channelmap_codaparms	Independent	net,sta,seedchan,location,ondate	11	
config_param	Independent	PROGID	4	
credit	Independent	id,tname	3	
credit_alias	Independent	alias,keyid	2	
epochtimebase	Independent	base,ondate	3	
eventmatchpassingscore	Independent	AUTH	4	
eventpriorityparams	Independent	MAGFACTOR,AGEFACTOR,QUALFACTOR	3	
gazetteer_region_group	Independent	grpid	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	
leap_seconds	Independent		5	
magprefpriority	Independent	REGION_NAME,DATETIME_ON,PRIORITY	14	
mcaparms	Independent	NET,STA,SEEDCHAN,LOCATION,ONDATE	17	
messagetext	Independent	SrcNet,TextType,LineNo	4	
nettrig	Independent	NTID	13	
orgprefpriority	Independent	REGION_NAME,DATETIME_ON,PRIORITY	16	
pcs_signal	Independent	SIGID	12	
pcs_state	Independent	CONTROLGROUP,SOURCETABLE,ID,STATE	11	
pcs_transition	Independent	GROUPOLD,SOURCEOLD,STATEOLD,RESULTOLD,GROUPNEW,SOURCENEW,STATENEW	12	
peer_system_status	Independent		2	
request_card	Independent	rcid	17	
rt_role	Independent		2	
stacorrections	Independent	NET,STA,SEEDCHAN,LOCATION,CORR_TYPE,ONDATE	13	
stamapping	Independent	net,sta	5	
subnet	Independent		5	
subnet_channel	Independent		7	
swarm_events	Independent	EVID,REGION	3	
swarm_state	Independent	REGION	5	
system_status	Independent		2	
trig_channel	Independent	TRIGID	16	
unassocamp	Independent	ampid	28	

Entity Detail Reports

alarm_action

Entity Name	alarm_action	
Owner Name		
Primary Keys	EVENT_ID,ALARM_ACTION,ACTION_STATE,MODCOUNT	
Definition	This table is used by alarmact and alarmdist modules.  Alarmact makes insertion into the table specifying a specific action for the alarmdist to act on.  Alarmdist updates the entry with the status of the action	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
EVENT_ID		NUMERIC(15, 0)	N		 
ALARM_ACTION		VARCHAR(15)	N		 
ACTION_STATE		VARCHAR(15)	N		 
MODCOUNT		NUMERIC(8, 0)	N		 
MOD_TIME		DATE	Y		 
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	

appchannels

Entity Name	appchannels	
Owner Name		
Primary Keys	progid,net,sta,seedchan,location,ondate	
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	N	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	 

assoc_region_group

Entity Name	assoc_region_group	
Owner Name		
Primary Keys	grpid,name	
Definition	Table used to associate a group of named region polygons with a network authority	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
grpid		VARCHAR(4)	N		 
name		VARCHAR(24)	N		 
auth		VARCHAR(15)	N		 
rg_order		NUMERIC(2, 0)	N		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	chk_rank_assoc_reggrp	rg_order > 0	 
Relationships 

 Parent Relationships: 

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

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

assocnte

Entity Name	assocnte	
Owner Name		
Primary Keys	NTID,EVID	
Definition	Populated by tc module -- associates an event with a network trigger	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
NTID		NUMERIC(15, 0)	N		 
EVID		NUMERIC(15, 0)	N		 
AUTH		VARCHAR(15)	N		 
SUBSOURCE		VARCHAR(8)	Y		 
RFLAG		VARCHAR(2)	Y		 
LDDATE		DATE	Y		 
WFFLAG		NUMERIC(1, 0)	Y		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
LDDATE	Default		(SYSDATE)	 
	Check	ASSOCNTE01	rflag in ('a','h','f','A','H','F')	 
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	

autoposter

Entity Name	autoposter	
Owner Name		
Primary Keys	INSTANCENAME	
Definition	Part of pcs system, identifies an event type and a series of tasks. Maintained by PCS package	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
INSTANCENAME		VARCHAR(30)	N		 
CONTROLGROUP		VARCHAR(20)	N		 
SOURCETABLE		VARCHAR(20)	N		 
STATE		VARCHAR(20)	N		 
RANK		NUMERIC(0, 0)	N		 
RESULT		NUMERIC(0, 0)	Y		 
ACTON		VARCHAR(6)	Y		 
EVENTTYPE		VARCHAR(2)	Y		 
LASTID		NUMERIC(0, 0)	Y		 
LASTLDDATE		DATE	Y		 
LDDATE		DATE	Y		 
RESULTTEXT		VARCHAR(80)	Y		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	ACTIONLIST	actOn in ('EVENT', 'ORIGIN', 'NETMAG')	 
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_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_param

Entity Name	config_param	
Owner Name		
Primary Keys	PROGID	
Definition		
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
PROGID		NUMERIC(15, 0)	N		 
PARAMETER		VARCHAR(32)	Y		 
VALUE		VARCHAR(64)	Y		 
LDDATE		DATE	Y		 
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	

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	

epochtimebase

Entity Name	epochtimebase	
Owner Name		
Primary Keys	base,ondate	
Definition	Table used by TRUETIME package to say if time is nominal or UTC	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
base		VARCHAR(1)	N		 
ondate		DATE	N		 
offdate		DATE	Y		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	timebasechk	base IN ('T','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	

eventmatchpassingscore

Entity Name	eventmatchpassingscore	
Owner Name		
Primary Keys	AUTH	
Definition		
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
AUTH		VARCHAR(15)	N		 
PICKTIMEDIFF		NUMERIC(0, 0)	N		 
ORIGINTIMEDIFF		NUMERIC(0, 0)	N		 
HORIZDIFF		NUMERIC(0, 0)	N		 
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	

eventpriorityparams

Entity Name	eventpriorityparams	
Owner Name		
Primary Keys	MAGFACTOR,AGEFACTOR,QUALFACTOR	
Definition		
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
MAGFACTOR		NUMERIC(0, 0)	N		 
AGEFACTOR		NUMERIC(0, 0)	N		 
QUALFACTOR		NUMERIC(0, 0)	N		 
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	

gazetteer_region_group

Entity Name	gazetteer_region_group	
Owner Name		
Primary Keys	grpid	
Definition	Table used to associate a group of named region polygons with a network authority	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
grpid		VARCHAR(4)	N		 
description		VARCHAR(80)	N		 
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	
assoc_region_group	Identifying	One To Zero or More					NO	 

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	

leap_seconds

Entity Name	leap_seconds	
Owner Name		
Primary Keys		
Definition	Used to store leap seconds -- used by TRUETIME package	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
S_NOMINAL		NUMERIC(38, 0)	Y		 
E_NOMINAL		NUMERIC(38, 0)	Y		 
S_TRUE		NUMERIC(38, 0)	Y		 
E_TRUE		NUMERIC(38, 0)	Y		 
LS_COUNT		NUMERIC(38, 0)	Y		 
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	

magprefpriority

Entity Name	magprefpriority	
Owner Name		
Primary Keys	REGION_NAME,DATETIME_ON,PRIORITY	
Definition	Used to show rules where which magnitude type is used as preferred. Used by MAGPREF packages	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
REGION_NAME		VARCHAR(24)	N		 
DATETIME_ON		NUMERIC(0, 0)	N		 
DATETIME_OFF		NUMERIC(0, 0)	N		 
PRIORITY		NUMERIC(0, 0)	N		 
MAGTYPE		VARCHAR(6)	Y		 
AUTH		VARCHAR(15)	Y		 
SUBSOURCE		VARCHAR(8)	Y		 
MAGALGO		VARCHAR(15)	Y		 
MINMAG		NUMERIC(0, 0)	Y		 
MAXMAG		NUMERIC(0, 0)	Y		 
MINREADINGS		NUMERIC(0, 0)	Y		 
MAXUNCERTAINTY		NUMERIC(0, 0)	Y		 
QUALITY		NUMERIC(0, 0)	Y		 
LDDATE		DATE	Y		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
LDDATE	Default		(SYS_EXTRACT_UTC(SYSTIMESTAMP))	 
	Check	MAGPREF_MAGTYPE_CK	magtype IN ('a','b','e','l','l1','l2','lg','c','s','w','z','B','un','d','h','n')	 
	Check	MAGPREF_MINMAG_CK	minmag >= -10.0 and minmag <= 10.0	 
	Check	MAGPREF_MAXMAG_CK	maxmag >= -10.0 and maxmag <= 10.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	

mcaparms

Entity Name	mcaparms	
Owner Name		
Primary Keys	NET,STA,SEEDCHAN,LOCATION,ONDATE	
Definition		
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
NET		VARCHAR(8)	N		 
STA		VARCHAR(6)	N		 
SEEDCHAN		VARCHAR(3)	N		 
CHANNEL		VARCHAR(8)	Y		 
CHANNELSRC		VARCHAR(8)	Y		 
LOCATION		VARCHAR(2)	N		 
NEQ		NUMERIC(6, 0)	N		 
AFIX		NUMERIC(7, 4)	N		 
QFIX		NUMERIC(7, 4)	N		 
AFREE		NUMERIC(7, 4)	N		 
QFREE		NUMERIC(7, 4)	N		 
SLOPE		NUMERIC(7, 4)	N		 
CLIP		NUMERIC(10, 0)	Y		 
CUTOFF		NUMERIC(6, 0)	Y		 
ONDATE		DATE	N		 
OFFDATE		DATE	Y		 
LDDATE		DATE	Y		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
LOCATION	Default		'00'	 
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	

messagetext

Entity Name	messagetext	
Owner Name		
Primary Keys	SrcNet,TextType,LineNo	
Definition		
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
SrcNet		VARCHAR(2)	N		 
TextType		VARCHAR(40)	N		 
LineNo		NUMERIC(8, 0)	N		 
Text		VARCHAR(132)	N		 
Defaults, Rules and Check Constraints 

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

nettrig

Entity Name	nettrig	
Owner Name		
Primary Keys	NTID	
Definition	Populated by trig2db module	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
NTID		NUMERIC(15, 0)	N		 
AUTH		VARCHAR(15)	N		 
SUBSOURCE		VARCHAR(8)	Y		 
DATETIME		NUMERIC(25, 10)	N		 
ALGORITHM		VARCHAR(15)	Y		 
LOCTRIGID		VARCHAR(12)	Y		 
NTRIG		NUMERIC(5, 0)	N		 
ALLCHAN		NUMERIC(1, 0)	N		 
SAVESTART		NUMERIC(25, 10)	Y		 
SAVEEND		NUMERIC(25, 10)	Y		 
RFLAG		VARCHAR(2)	Y		 
LDDATE		DATE	Y		 
SUBNET_CODE		VARCHAR(20)	Y		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
LDDATE	Default		(SYSDATE)	 
	Check	NETTRIG01	(allchan >= 0) and (allchan <= 1)	 
	Check	NETTRIG02	saveend >= savestart	 
	Check	NETTRIG03	rflag in ('a','h','f','A','H','F')	 
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	

orgprefpriority

Entity Name	orgprefpriority	
Owner Name		
Primary Keys	REGION_NAME,DATETIME_ON,PRIORITY	
Definition	Used to show rules where which origin type is used as preferred. Used by ORGPREF packages	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
REGION_NAME		VARCHAR(24)	N		 
DATETIME_ON		NUMERIC(25, 10)	N		 
DATETIME_OFF		NUMERIC(25, 10)	N		 
PRIORITY		NUMERIC(5, 0)	N		 
TYPE		VARCHAR(2)	Y		 
AUTH		VARCHAR(15)	Y		 
SUBSOURCE		VARCHAR(8)	Y		 
ALGORITHM		VARCHAR(15)	Y		 
MIN_OBS		NUMERIC(3, 0)	Y		 
MAX_GAP		NUMERIC(4, 1)	Y		 
MAX_ERHOR		NUMERIC(7, 3)	Y		 
MAX_DIST		NUMERIC(7, 3)	Y		 
MAX_DEPTH		NUMERIC(7, 3)	Y		 
MAX_RMS		NUMERIC(5, 3)	Y		 
MIN_QUAL		NUMERIC(3, 2)	Y		 
LDDATE		DATE	Y		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
LDDATE	Default		(SYS_EXTRACT_UTC(SYSTIMESTAMP))	 
	Check	ORIGINPREF_TYPE_CK	type IN ('H','D')	 
	Check	ORIGINPREF_MIN_OBS_CK	min_obs >= 0	 
	Check	ORIGINPREF_MAX_GAP_CK	max_gap >= 0. and max_gap <= 360.0	 
	Check	ORIGINPREF_MAX_ERHOR_CK	max_erhor >= 0.	 
	Check	ORIGINPREF_MAX_DIST_CK	max_dist >= 0.	 
	Check	ORIGINPREF_MAX_RMS_CK	max_rms >= 0.	 
	Check	ORIGINPREF_MIN_QUAL_CK	min_qual BETWEEN 0. AND 1.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	

pcs_signal

Entity Name	pcs_signal	
Owner Name		
Primary Keys	SIGID	
Definition	Part of pcs system. Used by PCS package	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
SIGID		NUMERIC(15, 0)	N		 
PCS_GROUP		VARCHAR(20)	N		 
PCS_THREAD		VARCHAR(20)	N		 
PCS_STATE		VARCHAR(20)	N		 
ALGORITHM		VARCHAR(16)	N		 
DBNAME		VARCHAR(9)	N		 
DBUSER		VARCHAR(30)	N		 
USERHOST		VARCHAR(16)	N		 
USERNAME		VARCHAR(20)	N		 
STARTDATE		DATE	N		 
STOPDATE		DATE	Y		 
MESSAGE		VARCHAR(132)	Y		 
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	

pcs_state

Entity Name	pcs_state	
Owner Name		
Primary Keys	CONTROLGROUP,SOURCETABLE,ID,STATE	
Definition	Part of the pcs system. Stores state of a task. Used by PCS package	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
CONTROLGROUP		VARCHAR(20)	N		 
SOURCETABLE		VARCHAR(20)	N		 
ID		NUMERIC(0, 0)	N		 
STATE		VARCHAR(20)	N		 
RANK		NUMERIC(0, 0)	N		 
RESULT		NUMERIC(0, 0)	Y		 
SECONDARYID		NUMERIC(0, 0)	Y		 
SECONDARYSOURCETABLE		VARCHAR(20)	Y		 
AUTH		VARCHAR(15)	Y		 
SUBSOURCE		VARCHAR(8)	Y		 
LDDATE		DATE	Y		 
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	

pcs_transition

Entity Name	pcs_transition	
Owner Name		
Primary Keys	GROUPOLD,SOURCEOLD,STATEOLD,RESULTOLD,GROUPNEW,SOURCENEW,STATENEW	
Definition	Part of the pcs system. Stores a series of task. Used by PCS package	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
GROUPOLD		VARCHAR(20)	N		 
SOURCEOLD		VARCHAR(20)	N		 
STATEOLD		VARCHAR(20)	N		 
RESULTOLD		NUMERIC(0, 0)	N		 
GROUPNEW		VARCHAR(20)	N		 
SOURCENEW		VARCHAR(20)	N		 
STATENEW		VARCHAR(20)	N		 
RANKNEW		NUMERIC(0, 0)	Y		 
RESULTNEW		NUMERIC(0, 0)	Y		 
AUTH		VARCHAR(15)	Y		 
SUBSOURCE		VARCHAR(8)	Y		 
LDDATE		DATE	Y		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
GROUPNEW	Default		'null'	 
SOURCENEW	Default		'null'	 
STATENEW	Default		'null'	 
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	

peer_system_status

Entity Name	peer_system_status	
Owner Name		
Primary Keys		
Definition		
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
STATUS		VARCHAR(15)	Y		 
MOD_TIME		DATE	Y		 
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	

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	

stacorrections

Entity Name	stacorrections	
Owner Name		
Primary Keys	NET,STA,SEEDCHAN,LOCATION,CORR_TYPE,ONDATE	
Definition		
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
NET		VARCHAR(8)	N		 
STA		VARCHAR(6)	N		 
SEEDCHAN		VARCHAR(3)	N		 
CHANNEL		VARCHAR(8)	Y		 
CHANNELSRC		VARCHAR(8)	Y		 
LOCATION		VARCHAR(2)	N		 
AUTH		VARCHAR(15)	Y		 
CORR		REAL/SMALLFLOAT	N		 
CORR_FLAG		VARCHAR(1)	Y		 
CORR_TYPE		VARCHAR(3)	N		 
ONDATE		DATE	N		 
OFFDATE		DATE	N		 
LDDATE		DATE	Y		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
LDDATE	Default		(SYSDATE)	 
	Check	STAC01	corr_type in ('ml','me','mca','mh','md','mw','mb','m0','vel','acc')	 
	Check	STAC02	corr_flag in ('D','C','F')	 
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	

subnet

Entity Name	subnet	
Owner Name		
Primary Keys		
Definition	Used only at caltech -- to populate EW carlsubtrig file	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
SUBID		NUMERIC(15, 0)	N		 
CODE		VARCHAR(3)	N		 
DESCRIPTION		VARCHAR(80)	Y		 
MINTRIG		NUMERIC(15, 0)	N		 
LDDATE		DATE	Y		 
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	

subnet_channel

Entity Name	subnet_channel	
Owner Name		
Primary Keys		
Definition	Used only at caltech to populate EW carlsubtrig file	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
SUBID		NUMERIC(15, 0)	N		 
STA		VARCHAR(6)	N		 
NET		VARCHAR(8)	N		 
SEEDCHAN		VARCHAR(3)	N		 
LOCATION		VARCHAR(2)	Y		 
VOTER		VARCHAR(1)	N		 
LDDATE		DATE	Y		 
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	

swarm_events

Entity Name	swarm_events	
Owner Name		
Primary Keys	EVID,REGION	
Definition		
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
EVID		NUMERIC(15, 0)	N		 
REGION		VARCHAR(24)	N		 
DATETIME		NUMERIC(25, 10)	N		 
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	

swarm_state

Entity Name	swarm_state	
Owner Name		
Primary Keys	REGION	
Definition		
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
REGION		VARCHAR(24)	N		 
IN_PROGRESS		VARCHAR(1)	N		 
LAST_NOTIFY		NUMERIC(15, 0)	Y		 
LAST_RERATE		NUMERIC(15, 0)	Y		 
RATE_THRESHOLD		NUMERIC(7, 3)	N		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
	Check	SWARM_STATE02	in_progress in ('t','f','T','F')	 
	Check	SWARM_STATE03	rate_threshold > 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	

system_status

Entity Name	system_status	
Owner Name		
Primary Keys		
Definition	Used for peer health and health modules	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
STATUS		VARCHAR(15)	Y		 
MOD_TIME		DATE	Y		 
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	

trig_channel

Entity Name	trig_channel	
Owner Name		
Primary Keys	TRIGID	
Definition	Populated by trig2db	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
TRIGID		NUMERIC(15, 0)	N		 
NTID		NUMERIC(15, 0)	N		 
AUTH		VARCHAR(15)	N		 
SUBSOURCE		VARCHAR(8)	Y		 
STA		VARCHAR(6)	N		 
NET		VARCHAR(8)	Y		 
CHANNEL		VARCHAR(8)	Y		 
CHANNELSRC		VARCHAR(8)	Y		 
SEEDCHAN		VARCHAR(3)	Y		 
LOCATION		VARCHAR(2)	Y		 
TRIGFLAG		VARCHAR(1)	Y		 
DATETIME		NUMERIC(25, 10)	N		 
SAVESTART		NUMERIC(25, 10)	N		 
SAVEEND		NUMERIC(25, 10)	N		 
RFLAG		VARCHAR(2)	Y		 
LDDATE		DATE	Y		 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
LDDATE	Default		(SYSDATE)	 
	Check	TRIGCHAN01	saveend > savestart	 
	Check	TRIGCHAN02	rflag in ('a','h','f','A','H','F')	 
	Check	TRIGCHAN03	trigflag in ('u','t','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	

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 	 
fileid		NUMERIC(15, 0)	Y	The value is assigned to all new rows parsed from a single GMP channel packet. Rows having the same fileid value are associated with the same event origin	 
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 10g	

Table Summary Report

Table Name	Table Type	Primary Keys	# Col	
alarm_action	Independent	event_id,alarm_action,action_state,modcount,	5	
appchannels	Dependent	progid,net,sta,seedchan,location,ondate,	9	
applications	Independent	progid,	3	
assoc_region_group	Dependent	grpid,name,	4	
assocnte	Independent	ntid,evid,	7	
autoposter	Independent	instancename,	12	
channelmap_ampparms	Independent	net,sta,seedchan,location,ondate,	10	
channelmap_codaparms	Independent	net,sta,seedchan,location,ondate,	11	
config_param	Independent	progid,	4	
credit	Independent	id,tname,	3	
credit_alias	Independent	alias,keyid	2	
epochtimebase	Independent	base,ondate,	3	
eventmatchpassingscore	Independent	auth,	4	
eventpriorityparams	Independent	magfactor,agefactor,qualfactor	3	
gazetteer_region_group	Independent	grpid,	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	
leap_seconds	Independent		5	
magprefpriority	Independent	region_name,datetime_on,priority,	14	
mcaparms	Independent	net,sta,seedchan,location,ondate,	17	
messagetext	Independent	srcnet,texttype,lineno,	4	
nettrig	Independent	ntid,	13	
orgprefpriority	Independent	region_name,datetime_on,priority,	16	
pcs_signal	Independent	sigid,	12	
pcs_state	Independent	controlgroup,sourcetable,id,state,	11	
pcs_transition	Independent	groupold,sourceold,stateold,resultold,groupnew,sourcenew,statenew,	12	
peer_system_status	Independent		2	
request_card	Independent	rcid,	17	
rt_role	Independent		2	
stacorrections	Independent	net,sta,seedchan,location,corr_type,ondate,	13	
stamapping	Independent	net,sta,	5	
subnet	Independent		5	
subnet_channel	Independent		7	
swarm_events	Independent	evid,region,	3	
swarm_state	Independent	region,	5	
system_status	Independent		2	
trig_channel	Independent	trigid,	16	
unassocamp	Independent	ampid	28	

Table Detail Reports

alarm_action

Table Name	alarm_action	
Owner Name		
Primary Keys	event_id,alarm_action,action_state,modcount	
Definition	This table is used by alarmact and alarmdist modules.  Alarmact makes insertion into the table specifying a specific action for the alarmdist to act on.  Alarmdist updates the entry with the status of the action	
Columns 

Column Name	Domain	Datatype	Null	Definition	
event_id		NUMBER(15, 0)	N		 
alarm_action		VARCHAR2(15)	N		 
action_state		VARCHAR2(15)	N		 
modcount		NUMBER(8, 0)	N		 
mod_time		DATE	Y		 
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 alarm_action(
    event_id        NUMBER(15, 0)    NOT NULL,
    alarm_action    VARCHAR2(15)     NOT NULL,
    action_state    VARCHAR2(15)     NOT NULL,
    modcount        NUMBER(8, 0)     NOT NULL,
    mod_time        DATE,
    CONSTRAINT alarm_actionkey01 PRIMARY KEY (event_id, alarm_action, action_state, modcount)
    USING INDEX
        LOGGING
)
LOGGING
;

appchannels

Table Name	appchannels	
Owner Name		
Primary Keys	progid,net,sta,seedchan,location,ondate	
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	N	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            NOT NULL,
    offdate     DATE,
    lddate      DATE            DEFAULT (SYSDATE),
    CONSTRAINT config_chankey01_1 PRIMARY KEY (progid, net, sta, seedchan, location, ondate)
    USING INDEX
        LOGGING, 
    CONSTRAINT Refapplications12 FOREIGN KEY (progid)
    REFERENCES applications(progid)
)
LOGGING
;

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)
    USING INDEX
        LOGGING
)
LOGGING
;

assoc_region_group

Table Name	assoc_region_group	
Owner Name		
Primary Keys	grpid,name	
Definition	Table used to associate a group of named region polygons with a network authority	
Columns 

Column Name	Domain	Datatype	Null	Definition	
grpid		VARCHAR2(4)	N		 
name		VARCHAR2(24)	N		 
auth		VARCHAR2(15)	N		 
rg_order		NUMBER(2, 0)	N		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
	Check	chk_rank_assoc_reggrp	rg_order > 0	 
Foreign Keys 

 Parent Relationships: 

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

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

CREATE TABLE assoc_region_group(
    grpid       VARCHAR2(4)     NOT NULL,
    name        VARCHAR2(24)    NOT NULL,
    auth        VARCHAR2(15)    NOT NULL,
    rg_order    NUMBER(2, 0)    NOT NULL,
    CONSTRAINT chk_rank_assoc_reggrp CHECK (rg_order > 0),
    CONSTRAINT pk_assoc_reggrp PRIMARY KEY (grpid, name)
    USING INDEX
        LOGGING, 
    CONSTRAINT fk_reg_grpid FOREIGN KEY (grpid)
    REFERENCES gazetteer_region_group(grpid)
)
LOGGING
;

assocnte

Table Name	assocnte	
Owner Name		
Primary Keys	ntid,evid	
Definition	Populated by tc module -- associates an event with a network trigger	
Columns 

Column Name	Domain	Datatype	Null	Definition	
ntid		NUMBER(15, 0)	N		 
evid		NUMBER(15, 0)	N		 
auth		VARCHAR2(15)	N		 
subsource		VARCHAR2(8)	Y		 
rflag		VARCHAR2(2)	Y		 
lddate		DATE	Y		 
wfflag		NUMBER(1, 0)	Y		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	assocnte01	rflag in ('a','h','f','A','H','F')	 
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 assocnte(
    ntid         NUMBER(15, 0)    NOT NULL,
    evid         NUMBER(15, 0)    NOT NULL,
    auth         VARCHAR2(15)     NOT NULL,
    subsource    VARCHAR2(8),
    rflag        VARCHAR2(2),
    lddate       DATE             DEFAULT (SYSDATE),
    wfflag       NUMBER(1, 0),
    CONSTRAINT assocnte01 CHECK (rflag in ('a','h','f','A','H','F')),
    CONSTRAINT assocntekey01 PRIMARY KEY (ntid, evid)
    USING INDEX
        LOGGING
)
LOGGING
;

autoposter

Table Name	autoposter	
Owner Name		
Primary Keys	instancename	
Definition	Part of pcs system, identifies an event type and a series of tasks. Maintained by PCS package	
Columns 

Column Name	Domain	Datatype	Null	Definition	
instancename		VARCHAR2(30)	N		 
controlgroup		VARCHAR2(20)	N		 
sourcetable		VARCHAR2(20)	N		 
state		VARCHAR2(20)	N		 
rank		NUMBER	N		 
result		NUMBER	Y		 
acton		VARCHAR2(6)	Y		 
eventtype		VARCHAR2(2)	Y		 
lastid		NUMBER	Y		 
lastlddate		DATE	Y		 
lddate		DATE	Y		 
resulttext		VARCHAR2(80)	Y		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
	Check	actionlist	actOn in ('EVENT', 'ORIGIN', 'NETMAG')	 
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 autoposter(
    instancename    VARCHAR2(30)    NOT NULL,
    controlgroup    VARCHAR2(20)    NOT NULL,
    sourcetable     VARCHAR2(20)    NOT NULL,
    state           VARCHAR2(20)    NOT NULL,
    rank            NUMBER          NOT NULL,
    result          NUMBER,
    acton           VARCHAR2(6),
    eventtype       VARCHAR2(2),
    lastid          NUMBER,
    lastlddate      DATE,
    lddate          DATE,
    resulttext      VARCHAR2(80),
    CONSTRAINT actionlist CHECK (actOn in ('EVENT', 'ORIGIN', 'NETMAG')),
    CONSTRAINT pk3_1 PRIMARY KEY (instancename)
    USING INDEX
        LOGGING
)
LOGGING
;

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)
    USING INDEX
        LOGGING
)
LOGGING
;

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)
    USING INDEX
        LOGGING
)
LOGGING
;

config_param

Table Name	config_param	
Owner Name		
Primary Keys	progid	
Definition		
Columns 

Column Name	Domain	Datatype	Null	Definition	
progid		NUMBER(15, 0)	N		 
parameter		VARCHAR2(32)	Y		 
value		VARCHAR2(64)	Y		 
lddate		DATE	Y		 
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 config_param(
    progid       NUMBER(15, 0)    NOT NULL,
    parameter    VARCHAR2(32),
    value        VARCHAR2(64),
    lddate       DATE             DEFAULT (SYSDATE),
    CONSTRAINT configparamkey01 PRIMARY KEY (progid)
    USING INDEX
        LOGGING
)
LOGGING
;

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)
    USING INDEX
        LOGGING
)
LOGGING
;

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)
    USING INDEX
        LOGGING
)
LOGGING
;

epochtimebase

Table Name	epochtimebase	
Owner Name		
Primary Keys	base,ondate	
Definition	Table used by TRUETIME package to say if time is nominal or UTC	
Columns 

Column Name	Domain	Datatype	Null	Definition	
base		VARCHAR2(1)	N		 
ondate		DATE	N		 
offdate		DATE	Y		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
	Check	timebasechk	base IN ('T','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	
DDL Code 

CREATE TABLE epochtimebase(
    base       VARCHAR2(1)    NOT NULL,
    ondate     DATE           NOT NULL,
    offdate    DATE,
    CONSTRAINT timebasechk CHECK (base IN ('T','N')),
    CONSTRAINT pk5 PRIMARY KEY (base, ondate)
    USING INDEX
        LOGGING
)
LOGGING
;

eventmatchpassingscore

Table Name	eventmatchpassingscore	
Owner Name		
Primary Keys	auth	
Definition		
Columns 

Column Name	Domain	Datatype	Null	Definition	
auth		VARCHAR2(15)	N		 
picktimediff		NUMBER	N		 
origintimediff		NUMBER	N		 
horizdiff		NUMBER	N		 
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 eventmatchpassingscore(
    auth              VARCHAR2(15)    NOT NULL,
    picktimediff      NUMBER          NOT NULL,
    origintimediff    NUMBER          NOT NULL,
    horizdiff         NUMBER          NOT NULL,
    CONSTRAINT eventmatchpasskey01 PRIMARY KEY (auth)
    USING INDEX
        LOGGING
)
LOGGING
;

eventpriorityparams

Table Name	eventpriorityparams	
Owner Name		
Primary Keys	magfactor,agefactor,qualfactor	
Definition		
Columns 

Column Name	Domain	Datatype	Null	Definition	
magfactor		NUMBER	N		 
agefactor		NUMBER	N		 
qualfactor		NUMBER	N		 
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 eventpriorityparams(
    magfactor     NUMBER    NOT NULL,
    agefactor     NUMBER    NOT NULL,
    qualfactor    NUMBER    NOT NULL,
    CONSTRAINT eppkey01 PRIMARY KEY (magfactor, agefactor, qualfactor)
    USING INDEX
        LOGGING
)
LOGGING
;

gazetteer_region_group

Table Name	gazetteer_region_group	
Owner Name		
Primary Keys	grpid	
Definition	Table used to associate a group of named region polygons with a network authority	
Columns 

Column Name	Domain	Datatype	Null	Definition	
grpid		VARCHAR2(4)	N		 
description		VARCHAR2(80)	N		 
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	
assoc_region_group	Identifying	One To Zero or More	fk_reg_grpid				NO	NO	 
DDL Code 

CREATE TABLE gazetteer_region_group(
    grpid          VARCHAR2(4)     NOT NULL,
    description    VARCHAR2(80)    NOT NULL,
    CONSTRAINT pk_gazreggrp PRIMARY KEY (grpid)
    USING INDEX
        LOGGING
)
LOGGING
;

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)
    USING INDEX
        LOGGING, 
    CONSTRAINT gazbigtown_fk_gazid FOREIGN KEY (gazid)
    REFERENCES gazetteerpt(gazid)
)
LOGGING
;

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)
    USING INDEX
        LOGGING, 
    CONSTRAINT gazfault_fk_gazid FOREIGN KEY (gazid)
    REFERENCES gazetteerline(gazid)
)
LOGGING
;

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)
    USING INDEX
        LOGGING, 
    CONSTRAINT gazline_fk_type FOREIGN KEY (type)
    REFERENCES gazetteertype(code)
)
LOGGING
;

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)
    USING INDEX
        LOGGING, 
    CONSTRAINT gazpt_fk_type FOREIGN KEY (type)
    REFERENCES gazetteertype(code)
)
LOGGING
;

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)
    USING INDEX
        LOGGING, 
    CONSTRAINT gazeq_fk_gazid FOREIGN KEY (gazid)
    REFERENCES gazetteerpt(gazid)
)
LOGGING
;

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)
    USING INDEX
        LOGGING, 
    CONSTRAINT gazqry_fk_gazid FOREIGN KEY (gazid)
    REFERENCES gazetteerpt(gazid)
)
LOGGING
;

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)
    USING INDEX
        LOGGING, 
    CONSTRAINT gaztown_fk_gazid FOREIGN KEY (gazid)
    REFERENCES gazetteerpt(gazid)
)
LOGGING
;

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	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)
    USING INDEX
        LOGGING
)
LOGGING
;

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)
    USING INDEX
        LOGGING
)
LOGGING
;

leap_seconds

Table Name	leap_seconds	
Owner Name		
Primary Keys		
Definition	Used to store leap seconds -- used by TRUETIME package	
Columns 

Column Name	Domain	Datatype	Null	Definition	
s_nominal		NUMBER(38, 0)	Y		 
e_nominal		NUMBER(38, 0)	Y		 
s_true		NUMBER(38, 0)	Y		 
e_true		NUMBER(38, 0)	Y		 
ls_count		NUMBER(38, 0)	Y		 
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 leap_seconds(
    s_nominal    NUMBER(38, 0),
    e_nominal    NUMBER(38, 0),
    s_true       NUMBER(38, 0),
    e_true       NUMBER(38, 0),
    ls_count     NUMBER(38, 0)
)
LOGGING
;

magprefpriority

Table Name	magprefpriority	
Owner Name		
Primary Keys	region_name,datetime_on,priority	
Definition	Used to show rules where which magnitude type is used as preferred. Used by MAGPREF packages	
Columns 

Column Name	Domain	Datatype	Null	Definition	
region_name		VARCHAR2(24)	N		 
datetime_on		NUMBER	N		 
datetime_off		NUMBER	N		 
priority		NUMBER	N		 
magtype		VARCHAR2(6)	Y		 
auth		VARCHAR2(15)	Y		 
subsource		VARCHAR2(8)	Y		 
magalgo		VARCHAR2(15)	Y		 
minmag		NUMBER	Y		 
maxmag		NUMBER	Y		 
minreadings		NUMBER	Y		 
maxuncertainty		NUMBER	Y		 
quality		NUMBER	Y		 
lddate		DATE	Y		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYS_EXTRACT_UTC(SYSTIMESTAMP))	 
	Check	magpref_minmag_ck	minmag >= -10.0 and minmag <= 10.0	 
	Check	magpref_maxmag_ck	maxmag >= -10.0 and maxmag <= 10.0	 
	Check	magpref_magtype_ck	magtype IN ('a','b','e','l','l1','l2','lg','c','s','w','z','B','un','d','h','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	
DDL Code 

CREATE TABLE magprefpriority(
    region_name       VARCHAR2(24)    NOT NULL,
    datetime_on       NUMBER          NOT NULL,
    datetime_off      NUMBER          NOT NULL,
    priority          NUMBER          NOT NULL,
    magtype           VARCHAR2(6),
    auth              VARCHAR2(15),
    subsource         VARCHAR2(8),
    magalgo           VARCHAR2(15),
    minmag            NUMBER,
    maxmag            NUMBER,
    minreadings       NUMBER,
    maxuncertainty    NUMBER,
    quality           NUMBER,
    lddate            DATE            DEFAULT (SYS_EXTRACT_UTC(SYSTIMESTAMP)),
    CONSTRAINT magpref_minmag_ck CHECK (minmag >= -10.0 and minmag <= 10.0),
    CONSTRAINT magpref_maxmag_ck CHECK (maxmag >= -10.0 and maxmag <= 10.0),
    CONSTRAINT magpref_magtype_ck CHECK (magtype IN ('a','b','e','l','l1','l2','lg','c','s','w','z','B','un','d','h','n')),
    CONSTRAINT magpref_pk PRIMARY KEY (region_name, datetime_on, priority)
    USING INDEX
        LOGGING
)
LOGGING
;

mcaparms

Table Name	mcaparms	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate	
Definition		
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N		 
sta		VARCHAR2(6)	N		 
seedchan		VARCHAR2(3)	N		 
channel		VARCHAR2(8)	Y		 
channelsrc		VARCHAR2(8)	Y		 
location		VARCHAR2(2)	N		 
neq		NUMBER(6, 0)	N		 
afix		NUMBER(7, 4)	N		 
qfix		NUMBER(7, 4)	N		 
afree		NUMBER(7, 4)	N		 
qfree		NUMBER(7, 4)	N		 
slope		NUMBER(7, 4)	N		 
clip		NUMBER(10, 0)	Y		 
cutoff		NUMBER(6, 0)	Y		 
ondate		DATE	N		 
offdate		DATE	Y		 
lddate		DATE	Y		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
location	Default		'00'	 
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 mcaparms(
    net           VARCHAR2(8)      NOT NULL,
    sta           VARCHAR2(6)      NOT NULL,
    seedchan      VARCHAR2(3)      NOT NULL,
    channel       VARCHAR2(8),
    channelsrc    VARCHAR2(8),
    location      VARCHAR2(2)      DEFAULT '00' NOT NULL,
    neq           NUMBER(6, 0)     NOT NULL,
    afix          NUMBER(7, 4)     NOT NULL,
    qfix          NUMBER(7, 4)     NOT NULL,
    afree         NUMBER(7, 4)     NOT NULL,
    qfree         NUMBER(7, 4)     NOT NULL,
    slope         NUMBER(7, 4)     NOT NULL,
    clip          NUMBER(10, 0),
    cutoff        NUMBER(6, 0),
    ondate        DATE             NOT NULL,
    offdate       DATE,
    lddate        DATE             DEFAULT SYSDATE,
    CONSTRAINT mcaparms_key01 PRIMARY KEY (net, sta, seedchan, location, ondate)
    USING INDEX
        LOGGING
)
LOGGING
;

messagetext

Table Name	messagetext	
Owner Name		
Primary Keys	srcnet,texttype,lineno	
Definition		
Columns 

Column Name	Domain	Datatype	Null	Definition	
srcnet		VARCHAR2(2)	N		 
texttype		VARCHAR2(40)	N		 
lineno		NUMBER(8, 0)	N		 
text		VARCHAR2(132)	N		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lineno	Check		LineNo > 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 messagetext(
    srcnet      VARCHAR2(2)      NOT NULL,
    texttype    VARCHAR2(40)     NOT NULL,
    lineno      NUMBER(8, 0)     NOT NULL,
    text        VARCHAR2(132)    NOT NULL,
    CHECK (LineNo > 0),
    CONSTRAINT pk11 PRIMARY KEY (srcnet, texttype, lineno)
    USING INDEX
        LOGGING
)
LOGGING
;

nettrig

Table Name	nettrig	
Owner Name		
Primary Keys	ntid	
Definition	Populated by trig2db module	
Columns 

Column Name	Domain	Datatype	Null	Definition	
ntid		NUMBER(15, 0)	N		 
auth		VARCHAR2(15)	N		 
subsource		VARCHAR2(8)	Y		 
datetime		NUMBER(25, 10)	N		 
algorithm		VARCHAR2(15)	Y		 
loctrigid		VARCHAR2(12)	Y		 
ntrig		NUMBER(5, 0)	N		 
allchan		NUMBER(1, 0)	N		 
savestart		NUMBER(25, 10)	Y		 
saveend		NUMBER(25, 10)	Y		 
rflag		VARCHAR2(2)	Y		 
lddate		DATE	Y		 
subnet_code		VARCHAR2(20)	Y		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	nettrig02	saveend >= savestart	 
	Check	nettrig03	rflag in ('a','h','f','A','H','F')	 
	Check	nettrig01	(allchan >= 0) and (allchan <= 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 nettrig(
    ntid           NUMBER(15, 0)     NOT NULL,
    auth           VARCHAR2(15)      NOT NULL,
    subsource      VARCHAR2(8),
    datetime       NUMBER(25, 10)    NOT NULL,
    algorithm      VARCHAR2(15),
    loctrigid      VARCHAR2(12),
    ntrig          NUMBER(5, 0)      NOT NULL,
    allchan        NUMBER(1, 0)      NOT NULL,
    savestart      NUMBER(25, 10),
    saveend        NUMBER(25, 10),
    rflag          VARCHAR2(2),
    lddate         DATE              DEFAULT (SYSDATE),
    subnet_code    VARCHAR2(20),
    CONSTRAINT nettrig02 CHECK (saveend >= savestart),
    CONSTRAINT nettrig03 CHECK (rflag in ('a','h','f','A','H','F')),
    CONSTRAINT nettrig01 CHECK ((allchan >= 0) and (allchan <= 1)),
    CONSTRAINT nettrigkey01 PRIMARY KEY (ntid)
    USING INDEX
        LOGGING
)
LOGGING
;

orgprefpriority

Table Name	orgprefpriority	
Owner Name		
Primary Keys	region_name,datetime_on,priority	
Definition	Used to show rules where which origin type is used as preferred. Used by ORGPREF packages	
Columns 

Column Name	Domain	Datatype	Null	Definition	
region_name		VARCHAR2(24)	N		 
datetime_on		NUMBER(25, 10)	N		 
datetime_off		NUMBER(25, 10)	N		 
priority		NUMBER(5, 0)	N		 
type		VARCHAR2(2)	Y		 
auth		VARCHAR2(15)	Y		 
subsource		VARCHAR2(8)	Y		 
algorithm		VARCHAR2(15)	Y		 
min_obs		NUMBER(3, 0)	Y		 
max_gap		NUMBER(4, 1)	Y		 
max_erhor		NUMBER(7, 3)	Y		 
max_dist		NUMBER(7, 3)	Y		 
max_depth		NUMBER(7, 3)	Y		 
max_rms		NUMBER(5, 3)	Y		 
min_qual		NUMBER(3, 2)	Y		 
lddate		DATE	Y		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYS_EXTRACT_UTC(SYSTIMESTAMP))	 
	Check	originpref_min_obs_ck	min_obs >= 0	 
	Check	originpref_max_gap_ck	max_gap >= 0. and max_gap <= 360.0	 
	Check	originpref_max_erhor_ck	max_erhor >= 0.	 
	Check	originpref_max_dist_ck	max_dist >= 0.	 
	Check	originpref_max_rms_ck	max_rms >= 0.	 
	Check	originpref_min_qual_ck	min_qual BETWEEN 0. AND 1.0	 
	Check	originpref_type_ck	type IN ('H','D')	 
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 orgprefpriority(
    region_name     VARCHAR2(24)      NOT NULL,
    datetime_on     NUMBER(25, 10)    NOT NULL,
    datetime_off    NUMBER(25, 10)    NOT NULL,
    priority        NUMBER(5, 0)      NOT NULL,
    type            VARCHAR2(2),
    auth            VARCHAR2(15),
    subsource       VARCHAR2(8),
    algorithm       VARCHAR2(15),
    min_obs         NUMBER(3, 0),
    max_gap         NUMBER(4, 1),
    max_erhor       NUMBER(7, 3),
    max_dist        NUMBER(7, 3),
    max_depth       NUMBER(7, 3),
    max_rms         NUMBER(5, 3),
    min_qual        NUMBER(3, 2),
    lddate          DATE              DEFAULT (SYS_EXTRACT_UTC(SYSTIMESTAMP)),
    CONSTRAINT originpref_min_obs_ck CHECK (min_obs >= 0),
    CONSTRAINT originpref_max_gap_ck CHECK (max_gap >= 0. and max_gap <= 360.0),
    CONSTRAINT originpref_max_erhor_ck CHECK (max_erhor >= 0.),
    CONSTRAINT originpref_max_dist_ck CHECK (max_dist >= 0.),
    CONSTRAINT originpref_max_rms_ck CHECK (max_rms >= 0.),
    CONSTRAINT originpref_min_qual_ck CHECK (min_qual BETWEEN 0. AND 1.0),
    CONSTRAINT originpref_type_ck CHECK (type IN ('H','D')),
    CONSTRAINT originpref_pk PRIMARY KEY (region_name, datetime_on, priority)
    USING INDEX
        LOGGING
)
LOGGING
;

pcs_signal

Table Name	pcs_signal	
Owner Name		
Primary Keys	sigid	
Definition	Part of pcs system. Used by PCS package	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sigid		NUMBER(15, 0)	N		 
pcs_group		VARCHAR2(20)	N		 
pcs_thread		VARCHAR2(20)	N		 
pcs_state		VARCHAR2(20)	N		 
algorithm		VARCHAR2(16)	N		 
dbname		VARCHAR2(9)	N		 
dbuser		VARCHAR2(30)	N		 
userhost		VARCHAR2(16)	N		 
username		VARCHAR2(20)	N		 
startdate		DATE	N		 
stopdate		DATE	Y		 
message		VARCHAR2(132)	Y		 
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 pcs_signal(
    sigid         NUMBER(15, 0)    NOT NULL,
    pcs_group     VARCHAR2(20)     NOT NULL,
    pcs_thread    VARCHAR2(20)     NOT NULL,
    pcs_state     VARCHAR2(20)     NOT NULL,
    algorithm     VARCHAR2(16)     NOT NULL,
    dbname        VARCHAR2(9)      NOT NULL,
    dbuser        VARCHAR2(30)     NOT NULL,
    userhost      VARCHAR2(16)     NOT NULL,
    username      VARCHAR2(20)     NOT NULL,
    startdate     DATE             NOT NULL,
    stopdate      DATE,
    message       VARCHAR2(132),
    CONSTRAINT pk_sig PRIMARY KEY (sigid)
    USING INDEX
        LOGGING
)
LOGGING
;

pcs_state

Table Name	pcs_state	
Owner Name		
Primary Keys	controlgroup,sourcetable,id,state	
Definition	Part of the pcs system. Stores state of a task. Used by PCS package	
Columns 

Column Name	Domain	Datatype	Null	Definition	
controlgroup		VARCHAR2(20)	N		 
sourcetable		VARCHAR2(20)	N		 
id		NUMBER	N		 
state		VARCHAR2(20)	N		 
rank		NUMBER	N		 
result		NUMBER	Y		 
secondaryid		NUMBER	Y		 
secondarysourcetable		VARCHAR2(20)	Y		 
auth		VARCHAR2(15)	Y		 
subsource		VARCHAR2(8)	Y		 
lddate		DATE	Y		 
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 pcs_state(
    controlgroup            VARCHAR2(20)    NOT NULL,
    sourcetable             VARCHAR2(20)    NOT NULL,
    id                      NUMBER          NOT NULL,
    state                   VARCHAR2(20)    NOT NULL,
    rank                    NUMBER          NOT NULL,
    result                  NUMBER,
    secondaryid             NUMBER,
    secondarysourcetable    VARCHAR2(20),
    auth                    VARCHAR2(15),
    subsource               VARCHAR2(8),
    lddate                  DATE,
    CONSTRAINT pk14 PRIMARY KEY (controlgroup, sourcetable, id, state)
    USING INDEX
        LOGGING
)
LOGGING
;

pcs_transition

Table Name	pcs_transition	
Owner Name		
Primary Keys	groupold,sourceold,stateold,resultold,groupnew,sourcenew,statenew	
Definition	Part of the pcs system. Stores a series of task. Used by PCS package	
Columns 

Column Name	Domain	Datatype	Null	Definition	
groupold		VARCHAR2(20)	N		 
sourceold		VARCHAR2(20)	N		 
stateold		VARCHAR2(20)	N		 
resultold		NUMBER	N		 
groupnew		VARCHAR2(20)	N		 
sourcenew		VARCHAR2(20)	N		 
statenew		VARCHAR2(20)	N		 
ranknew		NUMBER	Y		 
resultnew		NUMBER	Y		 
auth		VARCHAR2(15)	Y		 
subsource		VARCHAR2(8)	Y		 
lddate		DATE	Y		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
groupnew	Default		'null'	 
sourcenew	Default		'null'	 
statenew	Default		'null'	 
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 pcs_transition(
    groupold     VARCHAR2(20)    NOT NULL,
    sourceold    VARCHAR2(20)    NOT NULL,
    stateold     VARCHAR2(20)    NOT NULL,
    resultold    NUMBER          NOT NULL,
    groupnew     VARCHAR2(20)    DEFAULT 'null' NOT NULL,
    sourcenew    VARCHAR2(20)    DEFAULT 'null' NOT NULL,
    statenew     VARCHAR2(20)    DEFAULT 'null' NOT NULL,
    ranknew      NUMBER,
    resultnew    NUMBER,
    auth         VARCHAR2(15),
    subsource    VARCHAR2(8),
    lddate       DATE            DEFAULT SYSDATE,
    CONSTRAINT pcs_state_pk PRIMARY KEY (groupold, sourceold, stateold, resultold, groupnew, sourcenew, statenew)
    USING INDEX
        LOGGING
)
LOGGING
;

peer_system_status

Table Name	peer_system_status	
Owner Name		
Primary Keys		
Definition		
Columns 

Column Name	Domain	Datatype	Null	Definition	
status		VARCHAR2(15)	Y		 
mod_time		DATE	Y		 
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 peer_system_status(
    status      VARCHAR2(15),
    mod_time    DATE
)
LOGGING
;

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)
    USING INDEX
        LOGGING
)
LOGGING
;

CREATE UNIQUE INDEX req03 ON request_card(auth, subsource, net, sta, seedchan, location, staauth, datetime_on, datetime_off, request_type)
    LOGGING
;

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'))
)
LOGGING
;

stacorrections

Table Name	stacorrections	
Owner Name		
Primary Keys	net,sta,seedchan,location,corr_type,ondate	
Definition		
Columns 

Column Name	Domain	Datatype	Null	Definition	
net		VARCHAR2(8)	N		 
sta		VARCHAR2(6)	N		 
seedchan		VARCHAR2(3)	N		 
channel		VARCHAR2(8)	Y		 
channelsrc		VARCHAR2(8)	Y		 
location		VARCHAR2(2)	N		 
auth		VARCHAR2(15)	Y		 
corr		FLOAT(126)	N		 
corr_flag		VARCHAR2(1)	Y		 
corr_type		VARCHAR2(3)	N		 
ondate		DATE	N		 
offdate		DATE	N		 
lddate		DATE	Y		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	stac02	corr_flag in ('D','C','F')	 
	Check	stac01	corr_type in ('ml','me','mca','mh','md','mw','mb','m0','vel','acc')	 
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 stacorrections(
    net           VARCHAR2(8)     NOT NULL,
    sta           VARCHAR2(6)     NOT NULL,
    seedchan      VARCHAR2(3)     NOT NULL,
    channel       VARCHAR2(8),
    channelsrc    VARCHAR2(8),
    location      VARCHAR2(2)     NOT NULL,
    auth          VARCHAR2(15),
    corr          FLOAT(126)      NOT NULL,
    corr_flag     VARCHAR2(1),
    corr_type     VARCHAR2(3)     NOT NULL,
    ondate        DATE            NOT NULL,
    offdate       DATE            NOT NULL,
    lddate        DATE            DEFAULT (SYSDATE),
    CONSTRAINT stac02 CHECK (corr_flag in ('D','C','F')),
    CONSTRAINT stac01 CHECK (corr_type in ('ml','me','mca','mh','md','mw','mb','m0','vel','acc')),
    CONSTRAINT stacoo PRIMARY KEY (net, sta, seedchan, location, corr_type, ondate)
    USING INDEX
        LOGGING
)
LOGGING
;

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)
    USING INDEX
        LOGGING
)
LOGGING
;

subnet

Table Name	subnet	
Owner Name		
Primary Keys		
Definition	Used only at caltech -- to populate EW carlsubtrig file	
Columns 

Column Name	Domain	Datatype	Null	Definition	
subid		NUMBER(15, 0)	N		 
code		VARCHAR2(3)	N		 
description		VARCHAR2(80)	Y		 
mintrig		NUMBER(15, 0)	N		 
lddate		DATE	Y		 
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 subnet(
    subid          NUMBER(15, 0)    NOT NULL,
    code           VARCHAR2(3)      NOT NULL,
    description    VARCHAR2(80),
    mintrig        NUMBER(15, 0)    NOT NULL,
    lddate         DATE
)
LOGGING
;

subnet_channel

Table Name	subnet_channel	
Owner Name		
Primary Keys		
Definition	Used only at caltech to populate EW carlsubtrig file	
Columns 

Column Name	Domain	Datatype	Null	Definition	
subid		NUMBER(15, 0)	N		 
sta		VARCHAR2(6)	N		 
net		VARCHAR2(8)	N		 
seedchan		VARCHAR2(3)	N		 
location		VARCHAR2(2)	Y		 
voter		VARCHAR2(1)	N		 
lddate		DATE	Y		 
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 subnet_channel(
    subid       NUMBER(15, 0)    NOT NULL,
    sta         VARCHAR2(6)      NOT NULL,
    net         VARCHAR2(8)      NOT NULL,
    seedchan    VARCHAR2(3)      NOT NULL,
    location    VARCHAR2(2),
    voter       VARCHAR2(1)      NOT NULL,
    lddate      DATE
)
LOGGING
;

swarm_events

Table Name	swarm_events	
Owner Name		
Primary Keys	evid,region	
Definition		
Columns 

Column Name	Domain	Datatype	Null	Definition	
evid		NUMBER(15, 0)	N		 
region		VARCHAR2(24)	N		 
datetime		NUMBER(25, 10)	N		 
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 swarm_events(
    evid        NUMBER(15, 0)     NOT NULL,
    region      VARCHAR2(24)      NOT NULL,
    datetime    NUMBER(25, 10)    NOT NULL,
    CONSTRAINT swarm_eventskey01 PRIMARY KEY (evid, region)
    USING INDEX
        LOGGING
)
LOGGING
;

swarm_state

Table Name	swarm_state	
Owner Name		
Primary Keys	region	
Definition		
Columns 

Column Name	Domain	Datatype	Null	Definition	
region		VARCHAR2(24)	N		 
in_progress		VARCHAR2(1)	N		 
last_notify		NUMBER(15, 0)	Y		 
last_rerate		NUMBER(15, 0)	Y		 
rate_threshold		NUMBER(7, 3)	N		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
	Check	swarm_state03	rate_threshold > 0.0	 
	Check	swarm_state02	in_progress in ('t','f','T','F')	 
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 swarm_state(
    region            VARCHAR2(24)     NOT NULL,
    in_progress       VARCHAR2(1)      NOT NULL,
    last_notify       NUMBER(15, 0),
    last_rerate       NUMBER(15, 0),
    rate_threshold    NUMBER(7, 3)     NOT NULL,
    CONSTRAINT swarm_state03 CHECK (rate_threshold > 0.0),
    CONSTRAINT swarm_state02 CHECK (in_progress in ('t','f','T','F')),
    CONSTRAINT swarm_statekey01 PRIMARY KEY (region)
    USING INDEX
        LOGGING
)
LOGGING
;

system_status

Table Name	system_status	
Owner Name		
Primary Keys		
Definition	Used for peer health and health modules	
Columns 

Column Name	Domain	Datatype	Null	Definition	
status		VARCHAR2(15)	Y		 
mod_time		DATE	Y		 
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 system_status(
    status      VARCHAR2(15),
    mod_time    DATE
)
LOGGING
;

trig_channel

Table Name	trig_channel	
Owner Name		
Primary Keys	trigid	
Definition	Populated by trig2db	
Columns 

Column Name	Domain	Datatype	Null	Definition	
trigid		NUMBER(15, 0)	N		 
ntid		NUMBER(15, 0)	N		 
auth		VARCHAR2(15)	N		 
subsource		VARCHAR2(8)	Y		 
sta		VARCHAR2(6)	N		 
net		VARCHAR2(8)	Y		 
channel		VARCHAR2(8)	Y		 
channelsrc		VARCHAR2(8)	Y		 
seedchan		VARCHAR2(3)	Y		 
location		VARCHAR2(2)	Y		 
trigflag		VARCHAR2(1)	Y		 
datetime		NUMBER(25, 10)	N		 
savestart		NUMBER(25, 10)	N		 
saveend		NUMBER(25, 10)	N		 
rflag		VARCHAR2(2)	Y		 
lddate		DATE	Y		 
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	trigchan02	rflag in ('a','h','f','A','H','F')	 
	Check	trigchan03	trigflag in ('u','t','m')	 
	Check	trigchan01	saveend > savestart	 
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 trig_channel(
    trigid        NUMBER(15, 0)     NOT NULL,
    ntid          NUMBER(15, 0)     NOT NULL,
    auth          VARCHAR2(15)      NOT NULL,
    subsource     VARCHAR2(8),
    sta           VARCHAR2(6)       NOT NULL,
    net           VARCHAR2(8),
    channel       VARCHAR2(8),
    channelsrc    VARCHAR2(8),
    seedchan      VARCHAR2(3),
    location      VARCHAR2(2),
    trigflag      VARCHAR2(1),
    datetime      NUMBER(25, 10)    NOT NULL,
    savestart     NUMBER(25, 10)    NOT NULL,
    saveend       NUMBER(25, 10)    NOT NULL,
    rflag         VARCHAR2(2),
    lddate        DATE              DEFAULT (SYSDATE),
    CONSTRAINT trigchan02 CHECK (rflag in ('a','h','f','A','H','F')),
    CONSTRAINT trigchan03 CHECK (trigflag in ('u','t','m')),
    CONSTRAINT trigchan01 CHECK (saveend > savestart),
    CONSTRAINT trigchankey01 PRIMARY KEY (trigid)
    USING INDEX
        LOGGING
)
LOGGING
;

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		BINARY_FLOAT	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		BINARY_FLOAT	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		BINARY_FLOAT	N	Start of time window of amplitude measurement 	 
duration		BINARY_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 	 
fileid		NUMBER(15, 0)	Y	The value is assigned to all new rows parsed from a single GMP channel packet. Rows having the same fileid value are associated with the same event origin	 
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     BINARY_FLOAT      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           BINARY_FLOAT,
    tau           NUMBER(9, 4),
    quality       NUMBER(2, 1),
    rflag         VARCHAR2(2),
    cflag         VARCHAR2(2),
    wstart        BINARY_FLOAT      NOT NULL,
    duration      BINARY_FLOAT      NOT NULL,
    lddate        DATE              DEFAULT (SYSDATE),
    fileid        NUMBER(15, 0),
    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)
    USING INDEX
        LOGGING
)
LOGGING
;