Diagram Report

 NCEDC/TriNet Application
Version 1.0.0

Berkeley Seismological Laboratory
Stephane Zuzlewski
Last Modified 1/11/2006
Copyright 2006 NCEDC/TriNet
 
Table of Contents

            Table of Contents	          
            Diagram Summary Report	          
            Diagram Detail Reports	          
            NCEDC/TriNet Application	          
            Model Summary Report	          
            Model Detail Reports	          
            Entity Summary Report	          
            Entity Detail Reports	          
            Key Summary Report	          
            Key Detail Reports	          
            Relationship Summary Report	          
            Relationship Detail Reports	          
            Model Detail Reports	          
            Table Summary Report	          
            Table Detail Reports	          
            Index Summary Report	          
            Index Detail Reports	          
            Foreign Key Summary Report	          
            Foreign Key Detail Reports	          

Diagram Summary Report

Name	Author	Description	
NCEDC/TriNet Application	Stephane Zuzlewski	NCEDC/Trinet Application Schema ER Diagram	

Diagram Detail Reports

NCEDC/TriNet Application

Diagram Name	NCEDC/TriNet Application	
Description	NCEDC/Trinet Application Schema ER Diagram	
Author	Stephane Zuzlewski	
Company	Berkeley Seismological Laboratory	
Version	1.0.0	
Copyright	NCEDC/TriNet	
Copyright Year	2006	

Model Summary Report

Name	DatabasePlatform	 
Logical	Logical	
NCEDC	Oracle 9i	

Model Detail Reports

Logical

Model Name	Logical	
Database Platform	Logical	

Entity Summary Report

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

Entity Detail Reports

channelmap_ampparms

Entity Name	channelmap_ampparms	
Owner Name		
Primary Keys	net,sta,seedchan,location,ondate	
Definition	Channel clipping count values (used by magnitude algorithms)	
Keys 

Key Name	Key Type	Keys	
cm_amp_key	PrimaryKey	net, sta, seedchan, location, ondate	
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	

net

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

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network  	

sta

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

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

Range: Any free-format string up to 6 characters 	

seedchan

Attribute Name	seedchan	Entity Name	channelmap_ampparms	
Column Name	seedchan	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

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

Range: seedchan = E | S | H | B | M | L | V | U | R U A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W U Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W Band code: Sample rate (Hz) Corner period (sec) E = extremely short period ³ 80 < 10 S = short period ³ 10 to < 80 < 10 H = high broad band ³ 80 ³ 10 B = broad band ³ 10 to < 80 ³ 10 M = mid period > 1 to < 10 L = long period ~ 1 V = very long period ~ 0.1 U = ultra long period ~ 0.01 R = extremely long period ~ 0.001 Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components  	

location

Attribute Name	location	Entity Name	channelmap_ampparms	
Column Name	location	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Describes the individual sites on an array station, operated by the same network operator 	
Note 

Range: Any free-format string up to 2 characters long 	

ondate

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

This attribute denotes the start date 	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

offdate

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

This attribute denotes the end date 	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

channel

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

Channel name 	
Note 

Range: Any valid channel name, which may be network-specific. Networks using SEED channel names should use the same value for channel and seedchan 	

channelsrc

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

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

Range: Any free-format string up to 8 characters long 	

clip

Attribute Name	clip	Entity Name	channelmap_ampparms	
Column Name	clip	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Sample counts at which signal clips	
Note 

Clip data dependent on instrumentation so should mirror Simple_Response. By default use the MAX digital counts of digitizer output for clip when clip counts unknown	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

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)	
Keys 

Key Name	Key Type	Keys	
cm_coda_key	PrimaryKey	net, sta, seedchan, location, ondate	
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	

net

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

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network 	

sta

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

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

Range: Any free-format string up to 6 characters 	

seedchan

Attribute Name	seedchan	Entity Name	channelmap_codaparms	
Column Name	seedchan	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

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

Range: seedchan = E | S | H | B | M | L | V | U | R U A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W U Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W Band code: Sample rate (Hz) Corner period (sec) E = extremely short period ³ 80 < 10 S = short period ³ 10 to < 80 < 10 H = high broad band ³ 80 ³ 10 B = broad band ³ 10 to < 80 ³ 10 M = mid period > 1 to < 10 L = long period ~ 1 V = very long period ~ 0.1 U = ultra long period ~ 0.01 R = extremely long period ~ 0.001 Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components 	

location

Attribute Name	location	Entity Name	channelmap_codaparms	
Column Name	location	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Describes the individual sites on an array station, operated by the same network operator 	
Note 

Range: Any free-format string up to 2 characters long 	

ondate

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

This attribute denotes the start date 	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

offdate

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

This attribute denotes the end date 	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

channel

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

Channel name 	
Note 

Range: Any valid channel name, which may be network-specific. Networks using SEED channel names should use the same value for channel and seedchan 	

channelsrc

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

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

Range: Any free-format string up to 8 characters long 	

cutoff

Attribute Name	cutoff	Entity Name	channelmap_codaparms	
Column Name	cutoff	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

2-sec averaged absolute value amplitude counts	
Note 

49.19 legacy value for analogs,else derived from simple_response attributes value is the averaged abs value of digital counts over 2-sec window equivalent to cutoff == Simple_Response.gain*1.7295e-07 when gain_units are counts/m/s	

gain_corr

Attribute Name	gain_corr	Entity Name	channelmap_codaparms	
Column Name	gain_corr	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Magnitude units correction	
Note 

Md Magnitude correction for the analog channels with different atten (gain) settings i.e. legacy cutoff == 49.14 abs averaged counts for 2-sec window of timeseries regardless of the analog gain. Default should be null or 0. for new digital types	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

config_channel

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

Key Name	Key Type	Keys	
config_chankey01	PrimaryKey	progid, net, sta, seedchan, location	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
progid		NUMERIC(8, 0)	N	Keys to CONFIG_CHANNEL table	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network 	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 	 
seedchan		VARCHAR(3)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code 	 
config		VARCHAR(64)	Y	Misc note used by config file generation scripts.  Originally intended to identify configs within a program group	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype 	 
location		VARCHAR(2)	N	Describes the individual sites on an array station, operated by the same network operator 	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Relationships 

 Parent Relationships: 

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

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

progid

Attribute Name	progid	Entity Name	config_channel	
Column Name	progid	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Entity	program	
Definition 

Keys to CONFIG_CHANNEL table	
Note 

Range: progid > 0 	

net

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

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network  	

sta

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

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

Range: Any free-format string up to 6 characters 	

seedchan

Attribute Name	seedchan	Entity Name	config_channel	
Column Name	seedchan	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

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

Range: seedchan = E | S | H | B | M | L | V | U | R U A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W U Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W Band code: Sample rate (Hz) Corner period (sec) E = extremely short period ³ 80 < 10 S = short period ³ 10 to < 80 < 10 H = high broad band ³ 80 ³ 10 B = broad band ³ 10 to < 80 ³ 10 M = mid period > 1 to < 10 L = long period ~ 1 V = very long period ~ 0.1 U = ultra long period ~ 0.01 R = extremely long period ~ 0.001 Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components  	

config

Attribute Name	config	Entity Name	config_channel	
Column Name	config	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Misc note used by config file generation scripts.  Originally intended to identify configs within a program group	
Note 

Range: Any free-format string up to 64 characters 	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

location

Attribute Name	location	Entity Name	config_channel	
Column Name	location	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Describes the individual sites on an array station, operated by the same network operator 	
Note 

Range: Any free-format string up to 2 characters long 	

gazetteerbigtown

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

Key Name	Key Type	Keys	
gazbigtown_pk_gazid	PrimaryKey	gazid	
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				gazid	NO	 
 Child Relationships: 

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

gazid

Attribute Name	gazid	Entity Name	gazetteerbigtown	
Column Name	gazid	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Entity	gazetteerpt	
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0	

pop

Attribute Name	pop	Entity Name	gazetteerbigtown	
Column Name	pop	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Population >= 0	
Note 

Range: pop >= 0	

remark

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

Information about town	
Note 

Range: Any free-format string up to 80 characters long 	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

gazetteerfault

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

Key Name	Key Type	Keys	
gazfault_pk_gazid	PrimaryKey	gazid	
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				gazid	NO	 
 Child Relationships: 

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

gazid

Attribute Name	gazid	Entity Name	gazetteerfault	
Column Name	gazid	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Entity	GazetteerLine	
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0	

remark

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

Ancillary description of fault	
Note 

Range: Any free-format string up to 80 characters long 	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

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)	
Keys 

Key Name	Key Type	Keys	
gazline_pk_gazid	PrimaryKey	gazid	
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				type	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	 

gazid

Attribute Name	gazid	Entity Name	GazetteerLine	
Column Name	gazid	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0	

type

Attribute Name	code	Entity Name	GazetteerLine	
Column Name	type	
Logical Role Name	type	
Role Name	type	
Primary Key	NO	
Foreign Key	YES	Parent Entity	gazetteertype	
Definition 

References gazetteertype.code	
Note 

Range: type = 10 | 12 | 30 | 40 | 601 10 = town, 12 = bigTown, 30 = quarry, 40 = quake, 601 = fault	

name

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

Name of line group	
Note 

Range: Any free-format string up to 80 characters long 	

line

Attribute Name	line	Entity Name	GazetteerLine	
Column Name	line	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Line group segment number (>=0)	
Note 

Range: line >= 0 	

format

Attribute Name	format	Entity Name	GazetteerLine	
Column Name	format	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Known binary data byte type	
Note 

Range: Any free-format string up to 16 characters long 	

points

Attribute Name	points	Entity Name	GazetteerLine	
Column Name	points	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Binary data	
Note 

Range: Binary data	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

gazetteerpt

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

Key Name	Key Type	Keys	
gazpt_pk_gazid	PrimaryKey	gazid	
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				type	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	 

gazid

Attribute Name	gazid	Entity Name	gazetteerpt	
Column Name	gazid	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Derived from sequence gazseq	
Note 

Range: gazid > 0	

type

Attribute Name	code	Entity Name	gazetteerpt	
Column Name	type	
Logical Role Name	type	
Role Name	type	
Primary Key	NO	
Foreign Key	YES	Parent Entity	gazetteertype	
Definition 

References gazetteertype.code	
Note 

Range: type = 10 | 12 | 30 | 40 | 601 10 = town, 12 = bigTown, 30 = quarry, 40 = quake, 601 = fault	

lat

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

Latitude must be within +/- 90	
Note 

Range: -90.0 <= lat <= 90.0 Units: Degrees  	

lon

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

Longitude must be within +/-180	
Note 

Range: -180.0 <= lon <= 180.0 Units: Degrees  	

z

Attribute Name	z	Entity Name	gazetteerpt	
Column Name	z	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Elevation (+ is above sea level)	
Note 

Range: -10.0 <= z <= 1000.0 Units: Kilometers  	

name

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

Point place name	
Note 

Range: Any free-format string up to 48 characters 	

state

Attribute Name	state	Entity Name	gazetteerpt	
Column Name	state	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

State where point is located	
Note 

Range: Any free-format string up to 2 characters 	

county

Attribute Name	county	Entity Name	gazetteerpt	
Column Name	county	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

County where point is located	
Note 

Range: Any free-format string up to 32 characters 	

map

Attribute Name	map	Entity Name	gazetteerpt	
Column Name	map	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

A map reference	
Note 

Range: Any free-format string up to 48 characters 	

datumh

Attribute Name	datumh	Entity Name	gazetteerpt	
Column Name	datumh	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Map horizontal datum (eg. WGS84)	
Note 

Range: datumh =  NAD27 | WGS84 	

datumv

Attribute Name	datumv	Entity Name	gazetteerpt	
Column Name	datumv	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Map vertical datum	
Note 

Range: datumv =  NAD27 | WGS84 | AVERAGE AVERAGE = average of stations  	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

gazetteerquake

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

Key Name	Key Type	Keys	
gazeq_pk_gazid	PrimaryKey	gazid	
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				gazid	NO	 
 Child Relationships: 

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

gazid

Attribute Name	gazid	Entity Name	gazetteerquake	
Column Name	gazid	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Entity	gazetteerpt	
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0	

remark

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

Information about earthquake	
Note 

Range: Any free-format string up to 80 characters long 	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

gazetteerquarry

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

Key Name	Key Type	Keys	
gazqry_pk_gazid	PrimaryKey	gazid	
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				gazid	NO	 
 Child Relationships: 

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

gazid

Attribute Name	gazid	Entity Name	gazetteerquarry	
Column Name	gazid	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Entity	gazetteerpt	
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0 	

remark

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

Information about quarry	
Note 

Range: Any free-format string up to 80 characters long 	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

gazetteertown

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

Key Name	Key Type	Keys	
gaztown_pk_gazid	PrimaryKey	gazid	
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				gazid	NO	 
 Child Relationships: 

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

gazid

Attribute Name	gazid	Entity Name	gazetteertown	
Column Name	gazid	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Entity	gazetteerpt	
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0	

pop

Attribute Name	pop	Entity Name	gazetteertown	
Column Name	pop	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Population >= 0	
Note 

Range: pop >= 0	

remark

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

Information about town	
Note 

Range: Any free-format string up to 80 characters long 	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

gazetteertype

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

Key Name	Key Type	Keys	
gaztype_pk_code	PrimaryKey	code	
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	 

code

Attribute Name	code	Entity Name	gazetteertype	
Column Name	code	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

A number tag	
Note 

Range: code = 10 | 12 | 30 | 40 | 601 10 = town, 12 = bigTown, 30 = quarry, 40 = quake, 601 = fault	

name

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

A collective geographic type name	
Note 

Range: Any free-format string up to 32 characters 	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

jasieventlock

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

Key Name	Key Type	Keys	
PK3	PrimaryKey	evid	
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	

evid

Attribute Name	evid	Entity Name	jasieventlock	
Column Name	evid	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Event identifier. Each event is assigned a unique integer which identifies it in a database	
Note 

Range: evid > 0 	

hostname

Attribute Name	hostname	Entity Name	jasieventlock	
Column Name	hostname	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

URL of computer that has locked the event	
Note 

Range: Any free-format string up to 40 characters 	

application

Attribute Name	application	Entity Name	jasieventlock	
Column Name	application	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Name of computer application that has locked the event	
Note 

Range: Any free-format string up to 20 characters 	

username

Attribute Name	username	Entity Name	jasieventlock	
Column Name	username	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Username on remote computer that has locked the event	
Note 

Range: Any free-format string up to 20 characters 	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

program

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

Key Name	Key Type	Keys	
progkey01	PrimaryKey	progid	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
progid		NUMERIC(8, 0)	N	Primary Key	 
name		VARCHAR(16)	N	Program name used in sql_chanloader system.  Example: AmpGen	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype 	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	prog02	progid > 0	 
Relationships 

 Parent Relationships: 

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

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

progid

Attribute Name	progid	Entity Name	program	
Column Name	progid	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Primary Key	
Note 

Range: progid > 0	

name

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

Program name used in sql_chanloader system.  Example: AmpGen	
Note 

Range: Any free-format string up to 16 characters 	

lddate

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

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

request_card

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

Key Name	Key Type	Keys	
REQ03	Alternate Key	auth, subsource, net, sta, seedchan, location, staauth, datetime_on, datetime_off, request_type	
REQUEST_CARDKEY01	PrimaryKey	rcid	
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	

evid

Attribute Name	evid	Entity Name	request_card	
Column Name	EVID	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Event identifier. Each event is assigned a unique integer which identifies it in a database	
Note 

Range: evid > 0 	

auth

Attribute Name	auth	Entity Name	request_card	
Column Name	AUTH	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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 	
Note 

Range: Any free-format string up to 15 characters 	

subsource

Attribute Name	subsource	Entity Name	request_card	
Column Name	SUBSOURCE	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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 	
Note 

Range: Any free-format string up to 8 characters 	

net

Attribute Name	net	Entity Name	request_card	
Column Name	NET	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network  	

sta

Attribute Name	sta	Entity Name	request_card	
Column Name	STA	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Range: Any free-format string up to 6 characters 	

seedchan

Attribute Name	seedchan	Entity Name	request_card	
Column Name	SEEDCHAN	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Range: seedchan = E | S | H | B | M | L | V | U | R U A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W U Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W Band code: Sample rate (Hz) Corner period (sec) E = extremely short period ³ 80 < 10 S = short period ³ 10 to < 80 < 10 H = high broad band ³ 80 ³ 10 B = broad band ³ 10 to < 80 ³ 10 M = mid period > 1 to < 10 L = long period ~ 1 V = very long period ~ 0.1 U = ultra long period ~ 0.01 R = extremely long period ~ 0.001 Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components  	

staauth

Attribute Name	staauth	Entity Name	request_card	
Column Name	STAAUTH	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Purpose unknown (always same as subsource)	
Note 

Range: Any free-format string up to 15 characters long 	

channel

Attribute Name	channel	Entity Name	request_card	
Column Name	CHANNEL	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Channel name	
Note 

Range: Any valid channel name, which may be network-specific. Networks using SEED channel names should use the same value for channel and seedchan  	

datetime_on

Attribute Name	datetime_on	Entity Name	request_card	
Column Name	DATETIME_ON	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Start time of time window to save	
Note 

Range: Any valid float. datetime = 0.0 on January 01, 1970 at 00:00:00.0000 Units: Seconds  	

datetime_off

Attribute Name	datetime_off	Entity Name	request_card	
Column Name	DATETIME_OFF	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

End time of time window to save	
Note 

Range: Any valid float. datetime = 0.0 on January 01, 1970 at 00:00:00.0000 Units: Seconds  	

request_type

Attribute Name	request_type	Entity Name	request_card	
Column Name	REQUEST_TYPE	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Single character flag describing request type	
Note 

Range: request_type = T | C T = trigger, C = continuous	

lddate

Attribute Name	lddate	Entity Name	request_card	
Column Name	LDDATE	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

rcid

Attribute Name	rcid	Entity Name	request_card	
Column Name	RCID	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Unique request row number. Derived from REQSEQ.	
Note 

Range: rcid > 0 	

location

Attribute Name	location	Entity Name	request_card	
Column Name	LOCATION	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Describes the individual sites on an array station, operated by the same network operator 	
Note 

Range: Any free-format string up to 2 characters long 	

retry

Attribute Name	retry	Entity Name	request_card	
Column Name	RETRY	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Count of attempts to retrieve this waveform	
Note 

Range: retry > 0	

lastretry

Attribute Name	lastretry	Entity Name	request_card	
Column Name	LASTRETRY	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Time of last attempt to retrieve this waveform	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

priority

Attribute Name	priority	Entity Name	request_card	
Column Name	PRIORITY	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Rows are processed in priority order, 1 is highest priority	
Note 

Range: priority > 0	

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	
Keys 

Key Name	Key Type	Keys	
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	

primary_system

Attribute Name	primary_system	Entity Name	rt_role	
Column Name	primary_system	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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	
Note 

Range: primary_system = true | false true = primary, false = shadow  	

modification_time

Attribute Name	modification_time	Entity Name	rt_role	
Column Name	modification_time	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Time when status is updated	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

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	
Keys 

Key Name	Key Type	Keys	
stamapkey01	PrimaryKey	net, sta	
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	

net

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

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network  	

sta

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

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

Range: Any free-format string up to 6 characters 	

stanumber

Attribute Name	stanumber	Entity Name	stamapping	
Column Name	stanumber	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Station Number	
Note 

Range: stanumber > 0	

lddate

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

Load date. Date and time that the record was created or last modified, in Oracle date datat	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

locdescr

Attribute Name	locdescr	Entity Name	stamapping	
Column Name	locdescr	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Geographic description of station location	
Note 

Range: Any free-format string up to 40 characters 	

unassocamp

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

Key Name	Key Type	Keys	
UNASSOCAMPKEY01	PrimaryKey	ampid	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
ampid		NUMERIC(15, 0)	N	Amplitude identification. Each amplitude is assigned a unique positive integer identifying it. This number is used in the AssocAmO relation along with the origin identifier to link Amp and Origin. This number is used also in the AssocAmM relation along with the magnitude identifier to link Amp and Netmag 	 
commid		NUMERIC(15, 0)	Y	Comment identification. This is a key used to point to free-form comments entered in the Remark relation. These comments store additional information about a tuple in another relation. Within the Remark relation, there may be many tuples with the same commid and different lineno, but the same commid will appear in only one other tuple among the rest of the relations in the database 	 
datetime		NUMERIC(25, 10)	N	The date of associated with information in the record, in true epoch format 	 
sta		VARCHAR(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 	 
net		VARCHAR(8)	Y	Unique network identifier. This character string is the name of a seismic network 	 
auth		VARCHAR(15)	N	The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record 	 
subsource		VARCHAR(8)	Y	A second identifier to specify the system or process that derived the data. e.g., the origin's AUTH is CI, but the subsource (the solution) was computed by JIGGLE 	 
channel		VARCHAR(8)	Y	Channel name 	 
channelsrc		VARCHAR(8)	Y	Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) 	 
seedchan		VARCHAR(3)	Y	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code 	 
location		VARCHAR(2)	Y	Describes the individual sites on an array station, operated by the same network operator 	 
iphase		VARCHAR(8)	Y	Reported phase. This eight-character field holds the name initially given to a seismic phase. Standard seismological labels for the types of signals (or phases) are used (e.g., P, PKP, PcP, pP). Both upper and lower case letters are available and should be used when appropriate, for example, pP or PcP 	 
amplitude		FLOAT	N	Amplitude in appropriate units for type 	 
amptype		VARCHAR(8)	Y	Amplitude type 	 
units		VARCHAR(4)	N	Units of amplitude 	 
ampmeas		VARCHAR(1)	Y	Amplitude measure 	 
eramp		NUMERIC(5, 3)	Y	Uncertainty in amplitude measurement 	 
flagamp		VARCHAR(4)	Y	This attribute is a flag to indicate whether amplitude is over P packet, S packet, entire waveform, etc 	 
per		NUMERIC(10, 4)	Y	Signal period. This attribute is the period of the signal described by the amplitude record 	 
snr		FLOAT	Y	Signal-to-noise ratio. This is an estimate of the signal relative to that of the noise immediately preceding it 	 
tau		NUMERIC(9, 4)	Y	Coda duration (F-P time) 	 
quality		NUMERIC(2, 1)	Y	This attribute describes the completeness of the time window of data. A complete time window is 1.0, an incomplete time window is 0.0. If an incomplete time window has been human-reviewed and the analyst is confident that the peak amplitude was recorded and properly computed despite the presence of data gaps, the value is set to 0.5 to indicate the window contains data gaps, but is usable 	 
rflag		VARCHAR(2)	Y	This flag describes whether an observation was generated automatically, by a human, or has been finalized 	 
cflag		VARCHAR(2)	Y	This flag indicates whether the amplitude value is below noise, on scale or clipped 	 
wstart		FLOAT	N	Start of time window of amplitude measurement 	 
duration		FLOAT	N	Duration of amplitude reading 	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype 	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	UNASSOCAMP04	AMPTYPE IN ('C','WA','WAS','PGA','PGV','PGD', 'WAC','WAU','IV2','SP.3','SP1.0','SP3.0', 'ML100','ME100','EGY', 'HEL')	 
	Check	UNASSOCAMP06	eramp >= 0.0	 
	Check	UNASSOCAMP07	flagamp in ('P','S','R','PP','ALL','SUR')	 
	Check	UNASSOCAMP08	per > 0.0	 
	Check	UNASSOCAMP09	tau > 0.0	 
	Check	UNASSOCAMP10	units in ('c','s','mm','cm','m','ms','mss','cms','cmss','mms','mmss','mc','nm','e','iovs','spa','none')	 
	Check	UNASSOCAMP11	quality >=0.0 and quality <=1.0	 
	Check	UNASSOCAMP12	rflag in ('a','h','f','A','H','F')	 
	Check	UNASSOCAMP13	cflag in ('bn', 'os','cl','BN','OS','CL')	 
	Check	UNASSOCAMP02	amplitude >=0	 
	Check	UNASSOCAMP01	ampid > 0	 
	Check	UNASSOCAMP03	ampmeas in ('0','1')	 
Relationships 

 Parent Relationships: 

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

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

ampid

Attribute Name	ampid	Entity Name	unassocamp	
Column Name	AMPID	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

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 	
Note 

Range: ampid > 0 	

commid

Attribute Name	commid	Entity Name	unassocamp	
Column Name	COMMID	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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 	
Note 

Range: commid > 0 	

datetime

Attribute Name	datetime	Entity Name	unassocamp	
Column Name	DATETIME	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

The date of associated with information in the record, in true epoch format 	
Note 

Range: Any valid float. datetime = 0.0 on January 01, 1970 at 00:00:00.0000 Units: Seconds  	

sta

Attribute Name	sta	Entity Name	unassocamp	
Column Name	STA	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Range: Any free-format string up to 6 characters 	

net

Attribute Name	net	Entity Name	unassocamp	
Column Name	NET	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network  	

auth

Attribute Name	auth	Entity Name	unassocamp	
Column Name	AUTH	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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 	
Note 

Range: Any free-format string up to 15 characters 	

subsource

Attribute Name	subsource	Entity Name	unassocamp	
Column Name	SUBSOURCE	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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 	
Note 

Range: Any free-format string up to 8 characters 	

channel

Attribute Name	channel	Entity Name	unassocamp	
Column Name	CHANNEL	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Channel name 	
Note 

Range: Any valid channel name, which may be network-specific. Networks using SEED channel names should use the same value for channel and seedchan  	

channelsrc

Attribute Name	channelsrc	Entity Name	unassocamp	
Column Name	CHANNELSRC	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Range: Any free-format string up to 8 characters long 	

seedchan

Attribute Name	seedchan	Entity Name	unassocamp	
Column Name	SEEDCHAN	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Range: seedchan = E | S | H | B | M | L | V | U | R U A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W U Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W Band code: Sample rate (Hz) Corner period (sec) E = extremely short period ³ 80 < 10 S = short period ³ 10 to < 80 < 10 H = high broad band ³ 80 ³ 10 B = broad band ³ 10 to < 80 ³ 10 M = mid period > 1 to < 10 L = long period ~ 1 V = very long period ~ 0.1 U = ultra long period ~ 0.01 R = extremely long period ~ 0.001 Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components  	

location

Attribute Name	location	Entity Name	unassocamp	
Column Name	LOCATION	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Describes the individual sites on an array station, operated by the same network operator 	
Note 

Range: Any free-format string up to 2 characters long 	

iphase

Attribute Name	iphase	Entity Name	unassocamp	
Column Name	IPHASE	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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 	
Note 

Range: Any free-format string up to 8 characters 	

amplitude

Attribute Name	amplitude	Entity Name	unassocamp	
Column Name	AMPLITUDE	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Amplitude in appropriate units for type 	
Note 

Range: amplitude > 0.0	

amptype

Attribute Name	amptype	Entity Name	unassocamp	
Column Name	AMPTYPE	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Amplitude type 	
Note 

Range: amptype = WA | WAS | PGA | PGV | PGD | WAC | WAU | IV2 | SP.3 | SP1.0 | SP3.0 | ML100 | ME100 | EGY WA = Wood-Anderson photographic WAS = Wood-Anderson synthetic PGA = peak ground acceleration PGV = peak ground velocity PGD = peak ground displacement WAC = Wood-Anderson corrected WAU = Wood-Anderson uncorrected IV2 = integral of velocity squared SP.3 = spectral peak SP1.0 = spectral peak SP3.0 = spectral peak ML100 = local magnitude ME100 = energy magnitude EGY = energy  	

units

Attribute Name	units	Entity Name	unassocamp	
Column Name	UNITS	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Units of amplitude 	
Note 

Range: units Î c | s | mm | cm | m | ms | mss | cms | cmss | mms | mmss | mc | nm | e | iovs | spa  c = counts s = seconds mm = millimeters cm = centimeters m = meters ms = meters per second mss = meters per second per second cms = centimeters per second cmss = centimeters per second per second mms = millimeters per second mmss = millimeters per second per second mc = microns nm = nanometers e = ergs iovs = integral of velocity squared spa = spectral peak amplitude  	

ampmeas

Attribute Name	ampmeas	Entity Name	unassocamp	
Column Name	AMPMEAS	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Amplitude measure 	
Note 

Range: ampmeas = 0 | 1 0 = peak-to-peak 1 = zero-to-peak  	

eramp

Attribute Name	eramp	Entity Name	unassocamp	
Column Name	ERAMP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Uncertainty in amplitude measurement 	
Note 

Range: eramp >= 0.0	

flagamp

Attribute Name	flagamp	Entity Name	unassocamp	
Column Name	FLAGAMP	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute is a flag to indicate whether amplitude is over P packet, S packet, entire waveform, etc 	
Note 

Range: flagamp = SUR | P | S | ALL SUR = surface wave P = P packet S = S packet ALL = entire waveform  	

per

Attribute Name	per	Entity Name	unassocamp	
Column Name	PER	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Signal period. This attribute is the period of the signal described by the amplitude record 	
Note 

Range: per > 0.0 Units: Seconds  	

snr

Attribute Name	snr	Entity Name	unassocamp	
Column Name	SNR	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Signal-to-noise ratio. This is an estimate of the signal relative to that of the noise immediately preceding it 	
Note 

Range: snr > 0.0 	

tau

Attribute Name	tau	Entity Name	unassocamp	
Column Name	TAU	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Coda duration (F-P time) 	
Note 

Range: tau > 0.0 Units: Seconds  	

quality

Attribute Name	quality	Entity Name	unassocamp	
Column Name	QUALITY	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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 	
Note 

Range: 0.0 <= quality <= 1.0 	

rflag

Attribute Name	rflag	Entity Name	unassocamp	
Column Name	RFLAG	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This flag describes whether an observation was generated automatically, by a human, or has been finalized 	
Note 

Range: rflag = A | H | F A = automatic H = reviewed by human F = finalized  	

cflag

Attribute Name	cflag	Entity Name	unassocamp	
Column Name	CFLAG	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This flag indicates whether the amplitude value is below noise, on scale or clipped 	
Note 

Range: cflag in  BN | OS | CL BN = below noise OS = on scale CL = clipped  	

wstart

Attribute Name	wstart	Entity Name	unassocamp	
Column Name	WSTART	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Start of time window of amplitude measurement 	
Note 

Range: Any valid float. wstart = 0.0 on January 01, 1970 at 00:00:00.0000 Units: Seconds  	

duration

Attribute Name	duration	Entity Name	unassocamp	
Column Name	DURATION	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Duration of amplitude reading 	
Note 

Range: duration > 0.0 Units: Seconds  	

lddate

Attribute Name	lddate	Entity Name	unassocamp	
Column Name	LDDATE	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

Key Summary Report

Entity Name	Key Name	 Key Type	Unique	
channelmap_ampparms	cm_amp_key	PrimaryKey	YES	 
channelmap_codaparms	cm_coda_key	PrimaryKey	YES	 
config_channel	config_chankey01	PrimaryKey	YES	 
gazetteerbigtown	gazbigtown_pk_gazid	PrimaryKey	YES	 
gazetteerfault	gazfault_pk_gazid	PrimaryKey	YES	 
GazetteerLine	gazline_pk_gazid	PrimaryKey	YES	 
gazetteerpt	gazpt_pk_gazid	PrimaryKey	YES	 
gazetteerquake	gazeq_pk_gazid	PrimaryKey	YES	 
gazetteerquarry	gazqry_pk_gazid	PrimaryKey	YES	 
gazetteertown	gaztown_pk_gazid	PrimaryKey	YES	 
gazetteertype	gaztype_pk_code	PrimaryKey	YES	 
jasieventlock	PK3	PrimaryKey	YES	 
program	progkey01	PrimaryKey	YES	 
request_card	REQ03	Alternate Key	YES	 
request_card	REQUEST_CARDKEY01	PrimaryKey	YES	 
stamapping	stamapkey01	PrimaryKey	YES	 
unassocamp	UNASSOCAMPKEY01	PrimaryKey	YES	 

Key Detail Reports

cm_amp_key

Key Name	cm_amp_key	
Entity Name	channelmap_ampparms	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,seedchan,location,ondate	

cm_coda_key

Key Name	cm_coda_key	
Entity Name	channelmap_codaparms	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta,seedchan,location,ondate	

config_chankey01

Key Name	config_chankey01	
Entity Name	config_channel	
Key Type	PrimaryKey	
Unique	YES	
Keys	progid,net,sta,seedchan,location	

gazbigtown_pk_gazid

Key Name	gazbigtown_pk_gazid	
Entity Name	gazetteerbigtown	
Key Type	PrimaryKey	
Unique	YES	
Keys	gazid	

gazfault_pk_gazid

Key Name	gazfault_pk_gazid	
Entity Name	gazetteerfault	
Key Type	PrimaryKey	
Unique	YES	
Keys	gazid	

gazline_pk_gazid

Key Name	gazline_pk_gazid	
Entity Name	GazetteerLine	
Key Type	PrimaryKey	
Unique	YES	
Keys	gazid	

gazpt_pk_gazid

Key Name	gazpt_pk_gazid	
Entity Name	gazetteerpt	
Key Type	PrimaryKey	
Unique	YES	
Keys	gazid	

gazeq_pk_gazid

Key Name	gazeq_pk_gazid	
Entity Name	gazetteerquake	
Key Type	PrimaryKey	
Unique	YES	
Keys	gazid	

gazqry_pk_gazid

Key Name	gazqry_pk_gazid	
Entity Name	gazetteerquarry	
Key Type	PrimaryKey	
Unique	YES	
Keys	gazid	

gaztown_pk_gazid

Key Name	gaztown_pk_gazid	
Entity Name	gazetteertown	
Key Type	PrimaryKey	
Unique	YES	
Keys	gazid	

gaztype_pk_code

Key Name	gaztype_pk_code	
Entity Name	gazetteertype	
Key Type	PrimaryKey	
Unique	YES	
Keys	code	

PK3

Key Name	PK3	
Entity Name	jasieventlock	
Key Type	PrimaryKey	
Unique	YES	
Keys	evid	

progkey01

Key Name	progkey01	
Entity Name	program	
Key Type	PrimaryKey	
Unique	YES	
Keys	progid	

REQ03

Key Name	REQ03	
Entity Name	request_card	
Key Type	Alternate Key	
Unique	YES	
Keys	auth,subsource,net,sta,seedchan,location,staauth,datetime_on,datetime_off,request_type	

REQUEST_CARDKEY01

Key Name	REQUEST_CARDKEY01	
Entity Name	request_card	
Key Type	PrimaryKey	
Unique	YES	
Keys	rcid	

stamapkey01

Key Name	stamapkey01	
Entity Name	stamapping	
Key Type	PrimaryKey	
Unique	YES	
Keys	net,sta	

UNASSOCAMPKEY01

Key Name	UNASSOCAMPKEY01	
Entity Name	unassocamp	
Key Type	PrimaryKey	
Unique	YES	
Keys	ampid	

Relationship Summary Report

Parent Entity	Child Entity	Relationship Type	No of Keys	
program	config_channel	Identifying	1	
gazetteerpt	gazetteerbigtown	Identifying	1	
gazetteerpt	gazetteerquake	Identifying	1	
GazetteerLine	gazetteerfault	Identifying	1	
gazetteertype	GazetteerLine	Non-Identifying	1	
gazetteertype	gazetteerpt	Non-Identifying	1	
gazetteerpt	gazetteerquarry	Identifying	1	
gazetteerpt	gazetteertown	Identifying	1	

Relationship Detail Reports

Relationship: program to config_channel

Relationship Name		
Relationship Type	Identifying	
Parent Entity	program	
Child Entity	config_channel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
progid	progid	 

Relationship: gazetteerpt to gazetteerbigtown

Relationship Name	gazbigtown_fk_gazid	
Relationship Type	Identifying	
Parent Entity	gazetteerpt	
Child Entity	gazetteerbigtown	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
gazid	gazid	 

Relationship: gazetteerpt to gazetteerquake

Relationship Name	gazeq_fk_gazid	
Relationship Type	Identifying	
Parent Entity	gazetteerpt	
Child Entity	gazetteerquake	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
gazid	gazid	 

Relationship: GazetteerLine to gazetteerfault

Relationship Name	gazfault_fk_gazid	
Relationship Type	Identifying	
Parent Entity	GazetteerLine	
Child Entity	gazetteerfault	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
gazid	gazid	 

Relationship: gazetteertype to GazetteerLine

Relationship Name	gazline_fk_type	
Relationship Type	Non-Identifying	
Parent Entity	gazetteertype	
Child Entity	GazetteerLine	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
code	type	 

Relationship: gazetteertype to gazetteerpt

Relationship Name	gazpt_fk_type	
Relationship Type	Non-Identifying	
Parent Entity	gazetteertype	
Child Entity	gazetteerpt	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
code	type	 

Relationship: gazetteerpt to gazetteerquarry

Relationship Name	gazqry_fk_gazid	
Relationship Type	Identifying	
Parent Entity	gazetteerpt	
Child Entity	gazetteerquarry	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
gazid	gazid	 

Relationship: gazetteerpt to gazetteertown

Relationship Name	gaztown_fk_gazid	
Relationship Type	Identifying	
Parent Entity	gazetteerpt	
Child Entity	gazetteertown	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Relationship Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Relationship Keys 

Parent Key	Child Key	
gazid	gazid	 

Model Detail Reports

NCEDC

Model Name	NCEDC	
Database Platform	Oracle 9i	

Table Summary Report

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

Table Detail Reports

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 	 
Keys 

Key Name	Key Type	Keys	
cm_amp_key	PrimaryKey	net, sta, seedchan, location, ondate	
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	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
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)
)
;

COMMENT ON TABLE channelmap_ampparms IS 'Channel clipping count values (used by magnitude algorithms)'
;
COMMENT ON COLUMN channelmap_ampparms.net IS 'Unique network identifier. This character string is the name of a seismic network '
;
COMMENT ON COLUMN channelmap_ampparms.sta IS 'Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used '
;
COMMENT ON COLUMN channelmap_ampparms.seedchan IS 'SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code '
;
COMMENT ON COLUMN channelmap_ampparms.location IS 'Describes the individual sites on an array station, operated by the same network operator '
;
COMMENT ON COLUMN channelmap_ampparms.ondate IS 'This attribute denotes the start date '
;
COMMENT ON COLUMN channelmap_ampparms.offdate IS 'This attribute denotes the end date '
;
COMMENT ON COLUMN channelmap_ampparms.channel IS 'Channel name '
;
COMMENT ON COLUMN channelmap_ampparms.channelsrc IS 'Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) '
;
COMMENT ON COLUMN channelmap_ampparms.clip IS 'Sample counts at which signal clips'
;
COMMENT ON COLUMN channelmap_ampparms.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

net

Column Name	net	Table Name	channelmap_ampparms	
Attribute Name	net	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network  	

sta

Column Name	sta	Table Name	channelmap_ampparms	
Attribute Name	sta	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any free-format string up to 6 characters 	

seedchan

Column Name	seedchan	Table Name	channelmap_ampparms	
Attribute Name	seedchan	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

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

Range: seedchan = E | S | H | B | M | L | V | U | R U A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W U Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W Band code: Sample rate (Hz) Corner period (sec) E = extremely short period ³ 80 < 10 S = short period ³ 10 to < 80 < 10 H = high broad band ³ 80 ³ 10 B = broad band ³ 10 to < 80 ³ 10 M = mid period > 1 to < 10 L = long period ~ 1 V = very long period ~ 0.1 U = ultra long period ~ 0.01 R = extremely long period ~ 0.001 Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components  	

location

Column Name	location	Table Name	channelmap_ampparms	
Attribute Name	location	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Describes the individual sites on an array station, operated by the same network operator 	
Note 

Range: Any free-format string up to 2 characters long 	

ondate

Column Name	ondate	Table Name	channelmap_ampparms	
Attribute Name	ondate	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the start date 	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

offdate

Column Name	offdate	Table Name	channelmap_ampparms	
Attribute Name	offdate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date 	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

channel

Column Name	channel	Table Name	channelmap_ampparms	
Attribute Name	channel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Channel name 	
Note 

Range: Any valid channel name, which may be network-specific. Networks using SEED channel names should use the same value for channel and seedchan 	

channelsrc

Column Name	channelsrc	Table Name	channelmap_ampparms	
Attribute Name	channelsrc	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any free-format string up to 8 characters long 	

clip

Column Name	clip	Table Name	channelmap_ampparms	
Attribute Name	clip	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Sample counts at which signal clips	
Note 

Clip data dependent on instrumentation so should mirror Simple_Response. By default use the MAX digital counts of digitizer output for clip when clip counts unknown	

lddate

Column Name	lddate	Table Name	channelmap_ampparms	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

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	 
Keys 

Key Name	Key Type	Keys	
cm_coda_key	PrimaryKey	net, sta, seedchan, location, ondate	
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	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
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)
)
;

COMMENT ON TABLE channelmap_codaparms IS 'Channel response dependent data (used by coda magnitude algorithms)'
;
COMMENT ON COLUMN channelmap_codaparms.net IS 'Unique network identifier. This character string is the name of a seismic network '
;
COMMENT ON COLUMN channelmap_codaparms.sta IS 'Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used '
;
COMMENT ON COLUMN channelmap_codaparms.seedchan IS 'SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code '
;
COMMENT ON COLUMN channelmap_codaparms.location IS 'Describes the individual sites on an array station, operated by the same network operator '
;
COMMENT ON COLUMN channelmap_codaparms.ondate IS 'This attribute denotes the start date '
;
COMMENT ON COLUMN channelmap_codaparms.offdate IS 'This attribute denotes the end date '
;
COMMENT ON COLUMN channelmap_codaparms.channel IS 'Channel name '
;
COMMENT ON COLUMN channelmap_codaparms.channelsrc IS 'Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) '
;
COMMENT ON COLUMN channelmap_codaparms.cutoff IS '2-sec averaged absolute value amplitude counts'
;
COMMENT ON COLUMN channelmap_codaparms.gain_corr IS 'Magnitude units correction'
;
COMMENT ON COLUMN channelmap_codaparms.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype'
;

net

Column Name	net	Table Name	channelmap_codaparms	
Attribute Name	net	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network 	

sta

Column Name	sta	Table Name	channelmap_codaparms	
Attribute Name	sta	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any free-format string up to 6 characters 	

seedchan

Column Name	seedchan	Table Name	channelmap_codaparms	
Attribute Name	seedchan	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

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

Range: seedchan = E | S | H | B | M | L | V | U | R U A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W U Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W Band code: Sample rate (Hz) Corner period (sec) E = extremely short period ³ 80 < 10 S = short period ³ 10 to < 80 < 10 H = high broad band ³ 80 ³ 10 B = broad band ³ 10 to < 80 ³ 10 M = mid period > 1 to < 10 L = long period ~ 1 V = very long period ~ 0.1 U = ultra long period ~ 0.01 R = extremely long period ~ 0.001 Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components 	

location

Column Name	location	Table Name	channelmap_codaparms	
Attribute Name	location	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Describes the individual sites on an array station, operated by the same network operator 	
Note 

Range: Any free-format string up to 2 characters long 	

ondate

Column Name	ondate	Table Name	channelmap_codaparms	
Attribute Name	ondate	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the start date 	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

offdate

Column Name	offdate	Table Name	channelmap_codaparms	
Attribute Name	offdate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date 	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

channel

Column Name	channel	Table Name	channelmap_codaparms	
Attribute Name	channel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Channel name 	
Note 

Range: Any valid channel name, which may be network-specific. Networks using SEED channel names should use the same value for channel and seedchan 	

channelsrc

Column Name	channelsrc	Table Name	channelmap_codaparms	
Attribute Name	channelsrc	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any free-format string up to 8 characters long 	

cutoff

Column Name	cutoff	Table Name	channelmap_codaparms	
Attribute Name	cutoff	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

2-sec averaged absolute value amplitude counts	
Note 

49.19 legacy value for analogs,else derived from simple_response attributes value is the averaged abs value of digital counts over 2-sec window equivalent to cutoff == Simple_Response.gain*1.7295e-07 when gain_units are counts/m/s	

gain_corr

Column Name	gain_corr	Table Name	channelmap_codaparms	
Attribute Name	gain_corr	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Magnitude units correction	
Note 

Md Magnitude correction for the analog channels with different atten (gain) settings i.e. legacy cutoff == 49.14 abs averaged counts for 2-sec window of timeseries regardless of the analog gain. Default should be null or 0. for new digital types	

lddate

Column Name	lddate	Table Name	channelmap_codaparms	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

config_channel

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

Column Name	Domain	Datatype	Null	Definition	
progid		NUMBER(8, 0)	N	Keys to CONFIG_CHANNEL table	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network 	 
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 	 
seedchan		VARCHAR2(3)	N	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code 	 
config		VARCHAR2(64)	Y	Misc note used by config file generation scripts.  Originally intended to identify configs within a program group	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype 	 
location		VARCHAR2(2)	N	Describes the individual sites on an array station, operated by the same network operator 	 
Keys 

Key Name	Key Type	Keys	
config_chankey01	PrimaryKey	progid, net, sta, seedchan, location	
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	
program	Identifying	One To Zero or More				progid	NO	 
 Child Relationships: 

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

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

COMMENT ON TABLE config_channel IS 'Associates NSCL stream codes with programs (used in the sql_chanloader system)'
;
COMMENT ON COLUMN config_channel.progid IS 'Keys to CONFIG_CHANNEL table'
;
COMMENT ON COLUMN config_channel.net IS 'Unique network identifier. This character string is the name of a seismic network '
;
COMMENT ON COLUMN config_channel.sta IS 'Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used '
;
COMMENT ON COLUMN config_channel.seedchan IS 'SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code '
;
COMMENT ON COLUMN config_channel.config IS 'Misc note used by config file generation scripts.  Originally intended to identify configs within a program group'
;
COMMENT ON COLUMN config_channel.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;
COMMENT ON COLUMN config_channel.location IS 'Describes the individual sites on an array station, operated by the same network operator '
;

progid

Column Name	progid	Table Name	config_channel	
Attribute Name	progid	
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Table	program	
Definition 

Keys to CONFIG_CHANNEL table	
Note 

Range: progid > 0 	

net

Column Name	net	Table Name	config_channel	
Attribute Name	net	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network  	

sta

Column Name	sta	Table Name	config_channel	
Attribute Name	sta	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any free-format string up to 6 characters 	

seedchan

Column Name	seedchan	Table Name	config_channel	
Attribute Name	seedchan	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

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

Range: seedchan = E | S | H | B | M | L | V | U | R U A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W U Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W Band code: Sample rate (Hz) Corner period (sec) E = extremely short period ³ 80 < 10 S = short period ³ 10 to < 80 < 10 H = high broad band ³ 80 ³ 10 B = broad band ³ 10 to < 80 ³ 10 M = mid period > 1 to < 10 L = long period ~ 1 V = very long period ~ 0.1 U = ultra long period ~ 0.01 R = extremely long period ~ 0.001 Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components  	

config

Column Name	config	Table Name	config_channel	
Attribute Name	config	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Misc note used by config file generation scripts.  Originally intended to identify configs within a program group	
Note 

Range: Any free-format string up to 64 characters 	

lddate

Column Name	lddate	Table Name	config_channel	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

location

Column Name	location	Table Name	config_channel	
Attribute Name	location	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Describes the individual sites on an array station, operated by the same network operator 	
Note 

Range: Any free-format string up to 2 characters long 	

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 	 
Keys 

Key Name	Key Type	Keys	
gazbigtown_pk_gazid	PrimaryKey	gazid	
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	
gazetteerpt	Identifying	One To Zero or More	gazbigtown_fk_gazid			gazid	NO	 
 Child Relationships: 

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

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

COMMENT ON TABLE gazetteerbigtown IS 'Ancillary descriptive data for significant town entries in gazetteerpt table'
;
COMMENT ON COLUMN gazetteerbigtown.gazid IS 'References gazetteerpt.gazid'
;
COMMENT ON COLUMN gazetteerbigtown.pop IS 'Population >= 0'
;
COMMENT ON COLUMN gazetteerbigtown.remark IS 'Information about town'
;
COMMENT ON COLUMN gazetteerbigtown.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

gazid

Column Name	gazid	Table Name	gazetteerbigtown	
Attribute Name	gazid	
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Table	gazetteerpt	
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0	

pop

Column Name	pop	Table Name	gazetteerbigtown	
Attribute Name	pop	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Population >= 0	
Note 

Range: pop >= 0	

remark

Column Name	remark	Table Name	gazetteerbigtown	
Attribute Name	remark	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Information about town	
Note 

Range: Any free-format string up to 80 characters long 	

lddate

Column Name	lddate	Table Name	gazetteerbigtown	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

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(0, 0)	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 	 
Keys 

Key Name	Key Type	Keys	
gazfault_pk_gazid	PrimaryKey	gazid	
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	
gazetteerline	Identifying	One To Zero or More	gazfault_fk_gazid			gazid	NO	 
 Child Relationships: 

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

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

COMMENT ON TABLE gazetteerfault IS 'Ancillary descriptive data for fault entries in gazetteerpt table'
;
COMMENT ON COLUMN gazetteerfault.gazid IS 'References gazetteerpt.gazid'
;
COMMENT ON COLUMN gazetteerfault.remark IS 'Ancillary description of fault'
;
COMMENT ON COLUMN gazetteerfault.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

gazid

Column Name	gazid	Table Name	gazetteerfault	
Attribute Name	gazid	
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Table	gazetteerline	
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0	

remark

Column Name	remark	Table Name	gazetteerfault	
Attribute Name	remark	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Ancillary description of fault	
Note 

Range: Any free-format string up to 80 characters long 	

lddate

Column Name	lddate	Table Name	gazetteerfault	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

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(0, 0)	N	References gazetteerpt.gazid	 
type		NUMBER(3, 0)	N	References gazetteertype.code	 
name		VARCHAR2(80)	N	Name of line group	 
line		NUMBER(0, 0)	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 	 
Keys 

Key Name	Key Type	Keys	
gazline_pk_gazid	PrimaryKey	gazid	
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	
gazetteertype	Non-Identifying	One To Zero or More	gazline_fk_type			type	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
gazetteerfault	Identifying	One To Zero or More	gazfault_fk_gazid				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_pk_gazid PRIMARY KEY (gazid), 
    CONSTRAINT gazline_fk_type FOREIGN KEY (type)
    REFERENCES gazetteertype(code)
)
;

COMMENT ON TABLE gazetteerline IS 'Graphical line segments are defined by series of binary lat,lon stored as BLOB type (for fault lines)'
;
COMMENT ON COLUMN gazetteerline.gazid IS 'References gazetteerpt.gazid'
;
COMMENT ON COLUMN gazetteerline.type IS 'References gazetteertype.code'
;
COMMENT ON COLUMN gazetteerline.name IS 'Name of line group'
;
COMMENT ON COLUMN gazetteerline.line IS 'Line group segment number (>=0)'
;
COMMENT ON COLUMN gazetteerline.format IS 'Known binary data byte type'
;
COMMENT ON COLUMN gazetteerline.points IS 'Binary data'
;
COMMENT ON COLUMN gazetteerline.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

gazid

Column Name	gazid	Table Name	gazetteerline	
Attribute Name	gazid	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0	

type

Column Name	type	Table Name	gazetteerline	
Attribute Name	code	
Role Name	type	
Primary Key	NO	
Foreign Key	YES	Parent Table	gazetteertype	
Definition 

References gazetteertype.code	
Note 

Range: type = 10 | 12 | 30 | 40 | 601 10 = town, 12 = bigTown, 30 = quarry, 40 = quake, 601 = fault	

name

Column Name	name	Table Name	gazetteerline	
Attribute Name	name	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Name of line group	
Note 

Range: Any free-format string up to 80 characters long 	

line

Column Name	line	Table Name	gazetteerline	
Attribute Name	line	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Line group segment number (>=0)	
Note 

Range: line >= 0 	

format

Column Name	format	Table Name	gazetteerline	
Attribute Name	format	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Known binary data byte type	
Note 

Range: Any free-format string up to 16 characters long 	

points

Column Name	points	Table Name	gazetteerline	
Attribute Name	points	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Binary data	
Note 

Range: Binary data	

lddate

Column Name	lddate	Table Name	gazetteerline	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

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 	 
Keys 

Key Name	Key Type	Keys	
gazpt_pk_gazid	PrimaryKey	gazid	
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	
gazetteertype	Non-Identifying	One To Zero or More	gazpt_fk_type			type	NO	 
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
gazetteerbigtown	Identifying	One To Zero or More	gazbigtown_fk_gazid				NO	 
gazetteerquake	Identifying	One To Zero or More	gazeq_fk_gazid				NO	 
gazetteerquarry	Identifying	One To Zero or More	gazqry_fk_gazid				NO	 
gazetteertown	Identifying	One To Zero or More	gaztown_fk_gazid				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_pk_gazid PRIMARY KEY (gazid), 
    CONSTRAINT gazpt_fk_type FOREIGN KEY (type)
    REFERENCES gazetteertype(code)
)
;

COMMENT ON TABLE gazetteerpt IS 'Geographic points of interest described by lat,lon,z and other map location data'
;
COMMENT ON COLUMN gazetteerpt.gazid IS 'Derived from sequence gazseq'
;
COMMENT ON COLUMN gazetteerpt.type IS 'References gazetteertype.code'
;
COMMENT ON COLUMN gazetteerpt.lat IS 'Latitude must be within +/- 90'
;
COMMENT ON COLUMN gazetteerpt.lon IS 'Longitude must be within +/-180'
;
COMMENT ON COLUMN gazetteerpt.z IS 'Elevation (+ is above sea level)'
;
COMMENT ON COLUMN gazetteerpt.name IS 'Point place name'
;
COMMENT ON COLUMN gazetteerpt.state IS 'State where point is located'
;
COMMENT ON COLUMN gazetteerpt.county IS 'County where point is located'
;
COMMENT ON COLUMN gazetteerpt.map IS 'A map reference'
;
COMMENT ON COLUMN gazetteerpt.datumh IS 'Map horizontal datum (eg. WGS84)'
;
COMMENT ON COLUMN gazetteerpt.datumv IS 'Map vertical datum'
;
COMMENT ON COLUMN gazetteerpt.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

gazid

Column Name	gazid	Table Name	gazetteerpt	
Attribute Name	gazid	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Derived from sequence gazseq	
Note 

Range: gazid > 0	

type

Column Name	type	Table Name	gazetteerpt	
Attribute Name	code	
Role Name	type	
Primary Key	NO	
Foreign Key	YES	Parent Table	gazetteertype	
Definition 

References gazetteertype.code	
Note 

Range: type = 10 | 12 | 30 | 40 | 601 10 = town, 12 = bigTown, 30 = quarry, 40 = quake, 601 = fault	

lat

Column Name	lat	Table Name	gazetteerpt	
Attribute Name	lat	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Latitude must be within +/- 90	
Note 

Range: -90.0 <= lat <= 90.0 Units: Degrees  	

lon

Column Name	lon	Table Name	gazetteerpt	
Attribute Name	lon	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Longitude must be within +/-180	
Note 

Range: -180.0 <= lon <= 180.0 Units: Degrees  	

z

Column Name	z	Table Name	gazetteerpt	
Attribute Name	z	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Elevation (+ is above sea level)	
Note 

Range: -10.0 <= z <= 1000.0 Units: Kilometers  	

name

Column Name	name	Table Name	gazetteerpt	
Attribute Name	name	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Point place name	
Note 

Range: Any free-format string up to 48 characters 	

state

Column Name	state	Table Name	gazetteerpt	
Attribute Name	state	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

State where point is located	
Note 

Range: Any free-format string up to 2 characters 	

county

Column Name	county	Table Name	gazetteerpt	
Attribute Name	county	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

County where point is located	
Note 

Range: Any free-format string up to 32 characters 	

map

Column Name	map	Table Name	gazetteerpt	
Attribute Name	map	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

A map reference	
Note 

Range: Any free-format string up to 48 characters 	

datumh

Column Name	datumh	Table Name	gazetteerpt	
Attribute Name	datumh	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Map horizontal datum (eg. WGS84)	
Note 

Range: datumh =  NAD27 | WGS84 	

datumv

Column Name	datumv	Table Name	gazetteerpt	
Attribute Name	datumv	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Map vertical datum	
Note 

Range: datumv =  NAD27 | WGS84 | AVERAGE AVERAGE = average of stations  	

lddate

Column Name	lddate	Table Name	gazetteerpt	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

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 	 
Keys 

Key Name	Key Type	Keys	
gazeq_pk_gazid	PrimaryKey	gazid	
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	
gazetteerpt	Identifying	One To Zero or More	gazeq_fk_gazid			gazid	NO	 
 Child Relationships: 

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

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

COMMENT ON TABLE gazetteerquake IS 'Ancillary descriptive data for earthquake entries in gazetteerpt table'
;
COMMENT ON COLUMN gazetteerquake.gazid IS 'References gazetteerpt.gazid'
;
COMMENT ON COLUMN gazetteerquake.remark IS 'Information about earthquake'
;
COMMENT ON COLUMN gazetteerquake.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

gazid

Column Name	gazid	Table Name	gazetteerquake	
Attribute Name	gazid	
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Table	gazetteerpt	
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0	

remark

Column Name	remark	Table Name	gazetteerquake	
Attribute Name	remark	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Information about earthquake	
Note 

Range: Any free-format string up to 80 characters long 	

lddate

Column Name	lddate	Table Name	gazetteerquake	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

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 	 
Keys 

Key Name	Key Type	Keys	
gazqry_pk_gazid	PrimaryKey	gazid	
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	
gazetteerpt	Identifying	One To Zero or More	gazqry_fk_gazid			gazid	NO	 
 Child Relationships: 

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

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

COMMENT ON TABLE gazetteerquarry IS 'Ancillary descriptive data for quarry entries in gazetteerpt table'
;
COMMENT ON COLUMN gazetteerquarry.gazid IS 'References gazetteerpt.gazid'
;
COMMENT ON COLUMN gazetteerquarry.remark IS 'Information about quarry'
;
COMMENT ON COLUMN gazetteerquarry.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

gazid

Column Name	gazid	Table Name	gazetteerquarry	
Attribute Name	gazid	
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Table	gazetteerpt	
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0 	

remark

Column Name	remark	Table Name	gazetteerquarry	
Attribute Name	remark	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Information about quarry	
Note 

Range: Any free-format string up to 80 characters long 	

lddate

Column Name	lddate	Table Name	gazetteerquarry	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

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 	 
Keys 

Key Name	Key Type	Keys	
gaztown_pk_gazid	PrimaryKey	gazid	
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	
gazetteerpt	Identifying	One To Zero or More	gaztown_fk_gazid			gazid	NO	 
 Child Relationships: 

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

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

COMMENT ON TABLE gazetteertown IS 'Ancillary descriptive data for town entries in gazetteerpt table'
;
COMMENT ON COLUMN gazetteertown.gazid IS 'References gazetteerpt.gazid'
;
COMMENT ON COLUMN gazetteertown.pop IS 'Population >= 0'
;
COMMENT ON COLUMN gazetteertown.remark IS 'Information about town'
;
COMMENT ON COLUMN gazetteertown.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

gazid

Column Name	gazid	Table Name	gazetteertown	
Attribute Name	gazid	
Role Name		
Primary Key	YES	
Foreign Key	YES	Parent Table	gazetteerpt	
Definition 

References gazetteerpt.gazid	
Note 

Range: gazid > 0	

pop

Column Name	pop	Table Name	gazetteertown	
Attribute Name	pop	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Population >= 0	
Note 

Range: pop >= 0	

remark

Column Name	remark	Table Name	gazetteertown	
Attribute Name	remark	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Information about town	
Note 

Range: Any free-format string up to 80 characters long 	

lddate

Column Name	lddate	Table Name	gazetteertown	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

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 	 
Keys 

Key Name	Key Type	Keys	
gaztype_pk_code	PrimaryKey	code	
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	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
gazetteerline	Non-Identifying	One To Zero or More	gazline_fk_type				NO	 
gazetteerpt	Non-Identifying	One To Zero or More	gazpt_fk_type				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)
)
;

COMMENT ON TABLE gazetteertype IS 'Geographic map type keys and description'
;
COMMENT ON COLUMN gazetteertype.code IS 'A number tag'
;
COMMENT ON COLUMN gazetteertype.name IS 'A collective geographic type name'
;
COMMENT ON COLUMN gazetteertype.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

code

Column Name	code	Table Name	gazetteertype	
Attribute Name	code	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

A number tag	
Note 

Range: code = 10 | 12 | 30 | 40 | 601 10 = town, 12 = bigTown, 30 = quarry, 40 = quake, 601 = fault	

name

Column Name	name	Table Name	gazetteertype	
Attribute Name	name	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

A collective geographic type name	
Note 

Range: Any free-format string up to 32 characters 	

lddate

Column Name	lddate	Table Name	gazetteertype	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

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(0, 0)	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 	 
Keys 

Key Name	Key Type	Keys	
PK3	PrimaryKey	evid	
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	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
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)
)
;

COMMENT ON TABLE jasieventlock IS 'Current event locks (used in Jiggle)'
;
COMMENT ON COLUMN jasieventlock.evid IS 'Event identifier. Each event is assigned a unique integer which identifies it in a database'
;
COMMENT ON COLUMN jasieventlock.hostname IS 'URL of computer that has locked the event'
;
COMMENT ON COLUMN jasieventlock.application IS 'Name of computer application that has locked the event'
;
COMMENT ON COLUMN jasieventlock.username IS 'Username on remote computer that has locked the event'
;
COMMENT ON COLUMN jasieventlock.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

evid

Column Name	evid	Table Name	jasieventlock	
Attribute Name	evid	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Event identifier. Each event is assigned a unique integer which identifies it in a database	
Note 

Range: evid > 0 	

hostname

Column Name	hostname	Table Name	jasieventlock	
Attribute Name	hostname	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

URL of computer that has locked the event	
Note 

Range: Any free-format string up to 40 characters 	

application

Column Name	application	Table Name	jasieventlock	
Attribute Name	application	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Name of computer application that has locked the event	
Note 

Range: Any free-format string up to 20 characters 	

username

Column Name	username	Table Name	jasieventlock	
Attribute Name	username	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Username on remote computer that has locked the event	
Note 

Range: Any free-format string up to 20 characters 	

lddate

Column Name	lddate	Table Name	jasieventlock	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS 	

program

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

Column Name	Domain	Datatype	Null	Definition	
progid		NUMBER(8, 0)	N	Primary Key	 
name		VARCHAR2(16)	N	Program name used in sql_chanloader system.  Example: AmpGen	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype 	 
Keys 

Key Name	Key Type	Keys	
progkey01	PrimaryKey	progid	
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	prog02	progid > 0	 
Foreign Keys 

 Parent Relationships: 

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

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

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

COMMENT ON TABLE program IS 'Maps Program Names to PROGID''s (used in sql_chanloader system('
;
COMMENT ON COLUMN program.progid IS 'Primary Key'
;
COMMENT ON COLUMN program.name IS 'Program name used in sql_chanloader system.  Example: AmpGen'
;
COMMENT ON COLUMN program.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

progid

Column Name	progid	Table Name	program	
Attribute Name	progid	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Primary Key	
Note 

Range: progid > 0	

name

Column Name	name	Table Name	program	
Attribute Name	name	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Program name used in sql_chanloader system.  Example: AmpGen	
Note 

Range: Any free-format string up to 16 characters 	

lddate

Column Name	lddate	Table Name	program	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

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(0, 0)	Y	Rows are processed in priority order, 1 is highest priority	 
Keys 

Key Name	Key Type	Keys	
request_cardkey01	PrimaryKey	rcid	
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	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
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 request_cardkey01 PRIMARY KEY (rcid)
)
;

COMMENT ON TABLE request_card IS 'List of channel time windows to be archived'
;
COMMENT ON COLUMN request_card.evid IS 'Event identifier. Each event is assigned a unique integer which identifies it in a database'
;
COMMENT ON COLUMN request_card.auth IS '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 '
;
COMMENT ON COLUMN request_card.subsource IS '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 '
;
COMMENT ON COLUMN request_card.net IS 'Unique network identifier. This character string is the name of a seismic network '
;
COMMENT ON COLUMN request_card.sta IS 'Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used '
;
COMMENT ON COLUMN request_card.seedchan IS 'SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code '
;
COMMENT ON COLUMN request_card.staauth IS 'Purpose unknown (always same as subsource)'
;
COMMENT ON COLUMN request_card.channel IS 'Channel name'
;
COMMENT ON COLUMN request_card.datetime_on IS 'Start time of time window to save'
;
COMMENT ON COLUMN request_card.datetime_off IS 'End time of time window to save'
;
COMMENT ON COLUMN request_card.request_type IS 'Single character flag describing request type'
;
COMMENT ON COLUMN request_card.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;
COMMENT ON COLUMN request_card.rcid IS 'Unique request row number. Derived from REQSEQ.'
;
COMMENT ON COLUMN request_card.location IS 'Describes the individual sites on an array station, operated by the same network operator '
;
COMMENT ON COLUMN request_card.retry IS 'Count of attempts to retrieve this waveform'
;
COMMENT ON COLUMN request_card.lastretry IS 'Time of last attempt to retrieve this waveform'
;
COMMENT ON COLUMN request_card.priority IS 'Rows are processed in priority order, 1 is highest priority'
;

evid

Column Name	evid	Table Name	request_card	
Attribute Name	evid	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Event identifier. Each event is assigned a unique integer which identifies it in a database	
Note 

Range: evid > 0 	

auth

Column Name	auth	Table Name	request_card	
Attribute Name	auth	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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 	
Note 

Range: Any free-format string up to 15 characters 	

subsource

Column Name	subsource	Table Name	request_card	
Attribute Name	subsource	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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 	
Note 

Range: Any free-format string up to 8 characters 	

net

Column Name	net	Table Name	request_card	
Attribute Name	net	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network  	

sta

Column Name	sta	Table Name	request_card	
Attribute Name	sta	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any free-format string up to 6 characters 	

seedchan

Column Name	seedchan	Table Name	request_card	
Attribute Name	seedchan	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: seedchan = E | S | H | B | M | L | V | U | R U A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W U Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W Band code: Sample rate (Hz) Corner period (sec) E = extremely short period ³ 80 < 10 S = short period ³ 10 to < 80 < 10 H = high broad band ³ 80 ³ 10 B = broad band ³ 10 to < 80 ³ 10 M = mid period > 1 to < 10 L = long period ~ 1 V = very long period ~ 0.1 U = ultra long period ~ 0.01 R = extremely long period ~ 0.001 Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components  	

staauth

Column Name	staauth	Table Name	request_card	
Attribute Name	staauth	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Purpose unknown (always same as subsource)	
Note 

Range: Any free-format string up to 15 characters long 	

channel

Column Name	channel	Table Name	request_card	
Attribute Name	channel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Channel name	
Note 

Range: Any valid channel name, which may be network-specific. Networks using SEED channel names should use the same value for channel and seedchan  	

datetime_on

Column Name	datetime_on	Table Name	request_card	
Attribute Name	datetime_on	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Start time of time window to save	
Note 

Range: Any valid float. datetime = 0.0 on January 01, 1970 at 00:00:00.0000 Units: Seconds  	

datetime_off

Column Name	datetime_off	Table Name	request_card	
Attribute Name	datetime_off	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

End time of time window to save	
Note 

Range: Any valid float. datetime = 0.0 on January 01, 1970 at 00:00:00.0000 Units: Seconds  	

request_type

Column Name	request_type	Table Name	request_card	
Attribute Name	request_type	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Single character flag describing request type	
Note 

Range: request_type = T | C T = trigger, C = continuous	

lddate

Column Name	lddate	Table Name	request_card	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

rcid

Column Name	rcid	Table Name	request_card	
Attribute Name	rcid	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Unique request row number. Derived from REQSEQ.	
Note 

Range: rcid > 0 	

location

Column Name	location	Table Name	request_card	
Attribute Name	location	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Describes the individual sites on an array station, operated by the same network operator 	
Note 

Range: Any free-format string up to 2 characters long 	

retry

Column Name	retry	Table Name	request_card	
Attribute Name	retry	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Count of attempts to retrieve this waveform	
Note 

Range: retry > 0	

lastretry

Column Name	lastretry	Table Name	request_card	
Attribute Name	lastretry	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Time of last attempt to retrieve this waveform	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

priority

Column Name	priority	Table Name	request_card	
Attribute Name	priority	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Rows are processed in priority order, 1 is highest priority	
Note 

Range: priority > 0	

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	 
Keys 

Key Name	Key Type	Keys	
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	
 Child Relationships: 

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

CREATE TABLE rt_role(
    primary_system       VARCHAR2(5),
    modification_time    DATE           DEFAULT (SYSDATE)
)
;

COMMENT ON TABLE rt_role IS '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'
;
COMMENT ON COLUMN rt_role.primary_system IS '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'
;
COMMENT ON COLUMN rt_role.modification_time IS 'Time when status is updated'
;

primary_system

Column Name	primary_system	Table Name	rt_role	
Attribute Name	primary_system	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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	
Note 

Range: primary_system = true | false true = primary, false = shadow  	

modification_time

Column Name	modification_time	Table Name	rt_role	
Attribute Name	modification_time	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Time when status is updated	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

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	 
Keys 

Key Name	Key Type	Keys	
stamapkey01	PrimaryKey	net, sta	
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	
 Child Relationships: 

Table Name	Type	Cardinality	Constraint Name	Verb Phrase	Inverse Phrase	Foreign Keys	Is Subtype	
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 stamapkey01 PRIMARY KEY (net, sta)
)
;

COMMENT ON TABLE stamapping IS 'Provides geographic station location descriptions and maps station names to station numbers for the Strong-Motion 
Community'
;
COMMENT ON COLUMN stamapping.net IS 'Unique network identifier. This character string is the name of a seismic network '
;
COMMENT ON COLUMN stamapping.sta IS 'Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used '
;
COMMENT ON COLUMN stamapping.stanumber IS 'Station Number'
;
COMMENT ON COLUMN stamapping.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datat'
;
COMMENT ON COLUMN stamapping.locdescr IS 'Geographic description of station location'
;

net

Column Name	net	Table Name	stamapping	
Attribute Name	net	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network  	

sta

Column Name	sta	Table Name	stamapping	
Attribute Name	sta	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any free-format string up to 6 characters 	

stanumber

Column Name	stanumber	Table Name	stamapping	
Attribute Name	stanumber	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Station Number	
Note 

Range: stanumber > 0	

lddate

Column Name	lddate	Table Name	stamapping	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datat	
Note 

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

locdescr

Column Name	locdescr	Table Name	stamapping	
Attribute Name	locdescr	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Geographic description of station location	
Note 

Range: Any free-format string up to 40 characters 	

unassocamp

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

Column Name	Domain	Datatype	Null	Definition	
ampid		NUMBER(15, 0)	N	Amplitude identification. Each amplitude is assigned a unique positive integer identifying it. This number is used in the AssocAmO relation along with the origin identifier to link Amp and Origin. This number is used also in the AssocAmM relation along with the magnitude identifier to link Amp and Netmag 	 
commid		NUMBER(15, 0)	Y	Comment identification. This is a key used to point to free-form comments entered in the Remark relation. These comments store additional information about a tuple in another relation. Within the Remark relation, there may be many tuples with the same commid and different lineno, but the same commid will appear in only one other tuple among the rest of the relations in the database 	 
datetime		NUMBER(25, 10)	N	The date of associated with information in the record, in true epoch format 	 
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 	 
net		VARCHAR2(8)	Y	Unique network identifier. This character string is the name of a seismic network 	 
auth		VARCHAR2(15)	N	The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record 	 
subsource		VARCHAR2(8)	Y	A second identifier to specify the system or process that derived the data. e.g., the origin's AUTH is CI, but the subsource (the solution) was computed by JIGGLE 	 
channel		VARCHAR2(8)	Y	Channel name 	 
channelsrc		VARCHAR2(8)	Y	Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) 	 
seedchan		VARCHAR2(3)	Y	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code 	 
location		VARCHAR2(2)	Y	Describes the individual sites on an array station, operated by the same network operator 	 
iphase		VARCHAR2(8)	Y	Reported phase. This eight-character field holds the name initially given to a seismic phase. Standard seismological labels for the types of signals (or phases) are used (e.g., P, PKP, PcP, pP). Both upper and lower case letters are available and should be used when appropriate, for example, pP or PcP 	 
amplitude		DOUBLE PRECISION	N	Amplitude in appropriate units for type 	 
amptype		VARCHAR2(8)	Y	Amplitude type 	 
units		VARCHAR2(4)	N	Units of amplitude 	 
ampmeas		VARCHAR2(1)	Y	Amplitude measure 	 
eramp		NUMBER(5, 3)	Y	Uncertainty in amplitude measurement 	 
flagamp		VARCHAR2(4)	Y	This attribute is a flag to indicate whether amplitude is over P packet, S packet, entire waveform, etc 	 
per		NUMBER(10, 4)	Y	Signal period. This attribute is the period of the signal described by the amplitude record 	 
snr		DOUBLE PRECISION	Y	Signal-to-noise ratio. This is an estimate of the signal relative to that of the noise immediately preceding it 	 
tau		NUMBER(9, 4)	Y	Coda duration (F-P time) 	 
quality		NUMBER(2, 1)	Y	This attribute describes the completeness of the time window of data. A complete time window is 1.0, an incomplete time window is 0.0. If an incomplete time window has been human-reviewed and the analyst is confident that the peak amplitude was recorded and properly computed despite the presence of data gaps, the value is set to 0.5 to indicate the window contains data gaps, but is usable 	 
rflag		VARCHAR2(2)	Y	This flag describes whether an observation was generated automatically, by a human, or has been finalized 	 
cflag		VARCHAR2(2)	Y	This flag indicates whether the amplitude value is below noise, on scale or clipped 	 
wstart		DOUBLE PRECISION	N	Start of time window of amplitude measurement 	 
duration		DOUBLE PRECISION	N	Duration of amplitude reading 	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype 	 
Keys 

Key Name	Key Type	Keys	
unassocampkey01	PrimaryKey	ampid	
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	
 Child Relationships: 

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

CREATE TABLE unassocamp(
    ampid         NUMBER(15, 0)       NOT NULL,
    commid        NUMBER(15, 0),
    datetime      NUMBER(25, 10)      NOT NULL,
    sta           VARCHAR2(6)         NOT NULL,
    net           VARCHAR2(8),
    auth          VARCHAR2(15)        NOT NULL,
    subsource     VARCHAR2(8),
    channel       VARCHAR2(8),
    channelsrc    VARCHAR2(8),
    seedchan      VARCHAR2(3),
    location      VARCHAR2(2),
    iphase        VARCHAR2(8),
    amplitude     DOUBLE PRECISION    NOT NULL,
    amptype       VARCHAR2(8),
    units         VARCHAR2(4)         NOT NULL,
    ampmeas       VARCHAR2(1),
    eramp         NUMBER(5, 3),
    flagamp       VARCHAR2(4),
    per           NUMBER(10, 4),
    snr           DOUBLE PRECISION,
    tau           NUMBER(9, 4),
    quality       NUMBER(2, 1),
    rflag         VARCHAR2(2),
    cflag         VARCHAR2(2),
    wstart        DOUBLE PRECISION    NOT NULL,
    duration      DOUBLE PRECISION    NOT NULL,
    lddate        DATE                DEFAULT (SYSDATE),
    CONSTRAINT unassocampkey01 PRIMARY KEY (ampid)
)
;

COMMENT ON TABLE unassocamp IS 'Stores imported unassociated amplitudes'
;
COMMENT ON COLUMN unassocamp.ampid IS '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 '
;
COMMENT ON COLUMN unassocamp.commid IS '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 '
;
COMMENT ON COLUMN unassocamp.datetime IS 'The date of associated with information in the record, in true epoch format '
;
COMMENT ON COLUMN unassocamp.sta IS 'Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used '
;
COMMENT ON COLUMN unassocamp.net IS 'Unique network identifier. This character string is the name of a seismic network '
;
COMMENT ON COLUMN unassocamp.auth IS '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 '
;
COMMENT ON COLUMN unassocamp.subsource IS '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 '
;
COMMENT ON COLUMN unassocamp.channel IS 'Channel name '
;
COMMENT ON COLUMN unassocamp.channelsrc IS 'Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) '
;
COMMENT ON COLUMN unassocamp.seedchan IS 'SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code '
;
COMMENT ON COLUMN unassocamp.location IS 'Describes the individual sites on an array station, operated by the same network operator '
;
COMMENT ON COLUMN unassocamp.iphase IS '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 '
;
COMMENT ON COLUMN unassocamp.amplitude IS 'Amplitude in appropriate units for type '
;
COMMENT ON COLUMN unassocamp.amptype IS 'Amplitude type '
;
COMMENT ON COLUMN unassocamp.units IS 'Units of amplitude '
;
COMMENT ON COLUMN unassocamp.ampmeas IS 'Amplitude measure '
;
COMMENT ON COLUMN unassocamp.eramp IS 'Uncertainty in amplitude measurement '
;
COMMENT ON COLUMN unassocamp.flagamp IS 'This attribute is a flag to indicate whether amplitude is over P packet, S packet, entire waveform, etc '
;
COMMENT ON COLUMN unassocamp.per IS 'Signal period. This attribute is the period of the signal described by the amplitude record '
;
COMMENT ON COLUMN unassocamp.snr IS 'Signal-to-noise ratio. This is an estimate of the signal relative to that of the noise immediately preceding it '
;
COMMENT ON COLUMN unassocamp.tau IS 'Coda duration (F-P time) '
;
COMMENT ON COLUMN unassocamp.quality IS '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 '
;
COMMENT ON COLUMN unassocamp.rflag IS 'This flag describes whether an observation was generated automatically, by a human, or has been finalized '
;
COMMENT ON COLUMN unassocamp.cflag IS 'This flag indicates whether the amplitude value is below noise, on scale or clipped '
;
COMMENT ON COLUMN unassocamp.wstart IS 'Start of time window of amplitude measurement '
;
COMMENT ON COLUMN unassocamp.duration IS 'Duration of amplitude reading '
;
COMMENT ON COLUMN unassocamp.lddate IS 'Load date. Date and time that the record was created or last modified, in Oracle date datatype '
;

ampid

Column Name	ampid	Table Name	unassocamp	
Attribute Name	ampid	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

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 	
Note 

Range: ampid > 0 	

commid

Column Name	commid	Table Name	unassocamp	
Attribute Name	commid	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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 	
Note 

Range: commid > 0 	

datetime

Column Name	datetime	Table Name	unassocamp	
Attribute Name	datetime	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The date of associated with information in the record, in true epoch format 	
Note 

Range: Any valid float. datetime = 0.0 on January 01, 1970 at 00:00:00.0000 Units: Seconds  	

sta

Column Name	sta	Table Name	unassocamp	
Attribute Name	sta	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any free-format string up to 6 characters 	

net

Column Name	net	Table Name	unassocamp	
Attribute Name	net	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Unique network identifier. This character string is the name of a seismic network 	
Note 

Range: Any free-format string up to 8 characters. If available, use the two character FDSN code for the network  	

auth

Column Name	auth	Table Name	unassocamp	
Attribute Name	auth	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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 	
Note 

Range: Any free-format string up to 15 characters 	

subsource

Column Name	subsource	Table Name	unassocamp	
Attribute Name	subsource	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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 	
Note 

Range: Any free-format string up to 8 characters 	

channel

Column Name	channel	Table Name	unassocamp	
Attribute Name	channel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Channel name 	
Note 

Range: Any valid channel name, which may be network-specific. Networks using SEED channel names should use the same value for channel and seedchan  	

channelsrc

Column Name	channelsrc	Table Name	unassocamp	
Attribute Name	channelsrc	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any free-format string up to 8 characters long 	

seedchan

Column Name	seedchan	Table Name	unassocamp	
Attribute Name	seedchan	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: seedchan = E | S | H | B | M | L | V | U | R U A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W U Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W Band code: Sample rate (Hz) Corner period (sec) E = extremely short period ³ 80 < 10 S = short period ³ 10 to < 80 < 10 H = high broad band ³ 80 ³ 10 B = broad band ³ 10 to < 80 ³ 10 M = mid period > 1 to < 10 L = long period ~ 1 V = very long period ~ 0.1 U = ultra long period ~ 0.01 R = extremely long period ~ 0.001 Instrument code: A = tiltmeter B = creepmeter D = pressure F = magnetometer G = gravimeter/accelerometer H = high gain seismometer I = humidity K = temperature L = low gain seismometer M = mass position seismometer P = geophone R = rainfall S = linear strainmeter V = volumetric strain T = tide meter W = wind Component code: N = north-south E = east-west T = transverse R = radial Z = vertical A, B, C = triaxial 1, 2, 3 = orthogonal components but non-traditional orientations U, V, W = optional components  	

location

Column Name	location	Table Name	unassocamp	
Attribute Name	location	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Describes the individual sites on an array station, operated by the same network operator 	
Note 

Range: Any free-format string up to 2 characters long 	

iphase

Column Name	iphase	Table Name	unassocamp	
Attribute Name	iphase	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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 	
Note 

Range: Any free-format string up to 8 characters 	

amplitude

Column Name	amplitude	Table Name	unassocamp	
Attribute Name	amplitude	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Amplitude in appropriate units for type 	
Note 

Range: amplitude > 0.0	

amptype

Column Name	amptype	Table Name	unassocamp	
Attribute Name	amptype	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Amplitude type 	
Note 

Range: amptype = WA | WAS | PGA | PGV | PGD | WAC | WAU | IV2 | SP.3 | SP1.0 | SP3.0 | ML100 | ME100 | EGY WA = Wood-Anderson photographic WAS = Wood-Anderson synthetic PGA = peak ground acceleration PGV = peak ground velocity PGD = peak ground displacement WAC = Wood-Anderson corrected WAU = Wood-Anderson uncorrected IV2 = integral of velocity squared SP.3 = spectral peak SP1.0 = spectral peak SP3.0 = spectral peak ML100 = local magnitude ME100 = energy magnitude EGY = energy  	

units

Column Name	units	Table Name	unassocamp	
Attribute Name	units	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Units of amplitude 	
Note 

Range: units Î c | s | mm | cm | m | ms | mss | cms | cmss | mms | mmss | mc | nm | e | iovs | spa  c = counts s = seconds mm = millimeters cm = centimeters m = meters ms = meters per second mss = meters per second per second cms = centimeters per second cmss = centimeters per second per second mms = millimeters per second mmss = millimeters per second per second mc = microns nm = nanometers e = ergs iovs = integral of velocity squared spa = spectral peak amplitude  	

ampmeas

Column Name	ampmeas	Table Name	unassocamp	
Attribute Name	ampmeas	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Amplitude measure 	
Note 

Range: ampmeas = 0 | 1 0 = peak-to-peak 1 = zero-to-peak  	

eramp

Column Name	eramp	Table Name	unassocamp	
Attribute Name	eramp	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Uncertainty in amplitude measurement 	
Note 

Range: eramp >= 0.0	

flagamp

Column Name	flagamp	Table Name	unassocamp	
Attribute Name	flagamp	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute is a flag to indicate whether amplitude is over P packet, S packet, entire waveform, etc 	
Note 

Range: flagamp = SUR | P | S | ALL SUR = surface wave P = P packet S = S packet ALL = entire waveform  	

per

Column Name	per	Table Name	unassocamp	
Attribute Name	per	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Signal period. This attribute is the period of the signal described by the amplitude record 	
Note 

Range: per > 0.0 Units: Seconds  	

snr

Column Name	snr	Table Name	unassocamp	
Attribute Name	snr	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Signal-to-noise ratio. This is an estimate of the signal relative to that of the noise immediately preceding it 	
Note 

Range: snr > 0.0 	

tau

Column Name	tau	Table Name	unassocamp	
Attribute Name	tau	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Coda duration (F-P time) 	
Note 

Range: tau > 0.0 Units: Seconds  	

quality

Column Name	quality	Table Name	unassocamp	
Attribute Name	quality	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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 	
Note 

Range: 0.0 <= quality <= 1.0 	

rflag

Column Name	rflag	Table Name	unassocamp	
Attribute Name	rflag	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This flag describes whether an observation was generated automatically, by a human, or has been finalized 	
Note 

Range: rflag = A | H | F A = automatic H = reviewed by human F = finalized  	

cflag

Column Name	cflag	Table Name	unassocamp	
Attribute Name	cflag	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This flag indicates whether the amplitude value is below noise, on scale or clipped 	
Note 

Range: cflag in  BN | OS | CL BN = below noise OS = on scale CL = clipped  	

wstart

Column Name	wstart	Table Name	unassocamp	
Attribute Name	wstart	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Start of time window of amplitude measurement 	
Note 

Range: Any valid float. wstart = 0.0 on January 01, 1970 at 00:00:00.0000 Units: Seconds  	

duration

Column Name	duration	Table Name	unassocamp	
Attribute Name	duration	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Duration of amplitude reading 	
Note 

Range: duration > 0.0 Units: Seconds  	

lddate

Column Name	lddate	Table Name	unassocamp	
Attribute Name	lddate	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Range: Any valid date between January 01, 4712 BC and January 01, 4712 AD Units: YYYY/MM/DD HH24:MI:SS  	

Index Summary Report

Table Name	Index Name	 Index Type	Unique	
channelmap_ampparms	cm_amp_key	PrimaryKey	YES	 
channelmap_codaparms	cm_coda_key	PrimaryKey	YES	 
config_channel	config_chankey01	PrimaryKey	YES	 
gazetteerbigtown	gazbigtown_pk_gazid	PrimaryKey	YES	 
gazetteerfault	gazfault_pk_gazid	PrimaryKey	YES	 
gazetteerline	gazline_pk_gazid	PrimaryKey	YES	 
gazetteerpt	gazpt_pk_gazid	PrimaryKey	YES	 
gazetteerquake	gazeq_pk_gazid	PrimaryKey	YES	 
gazetteerquarry	gazqry_pk_gazid	PrimaryKey	YES	 
gazetteertown	gaztown_pk_gazid	PrimaryKey	YES	 
gazetteertype	gaztype_pk_code	PrimaryKey	YES	 
jasieventlock	PK3	PrimaryKey	YES	 
program	progkey01	PrimaryKey	YES	 
request_card	request_cardkey01	PrimaryKey	YES	 
stamapping	stamapkey01	PrimaryKey	YES	 
unassocamp	unassocampkey01	PrimaryKey	YES	 

Index Detail Reports

cm_amp_key

Index Name	cm_amp_key	
Table Name	channelmap_ampparms	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	net,sta,seedchan,location,ondate	
Index Keys 

Index Key	Sort Order	
net	Ascending	 
sta	Ascending	 
seedchan	Ascending	 
location	Ascending	 
ondate	Ascending	 

cm_coda_key

Index Name	cm_coda_key	
Table Name	channelmap_codaparms	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	net,sta,seedchan,location,ondate	
Index Keys 

Index Key	Sort Order	
net	Ascending	 
sta	Ascending	 
seedchan	Ascending	 
location	Ascending	 
ondate	Ascending	 

config_chankey01

Index Name	config_chankey01	
Table Name	config_channel	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	progid,net,sta,seedchan,location	
Index Keys 

Index Key	Sort Order	
progid	Ascending	 
net	Ascending	 
sta	Ascending	 
seedchan	Ascending	 
location	Ascending	 

gazbigtown_pk_gazid

Index Name	gazbigtown_pk_gazid	
Table Name	gazetteerbigtown	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	gazid	
Index Keys 

Index Key	Sort Order	
gazid	Ascending	 

gazfault_pk_gazid

Index Name	gazfault_pk_gazid	
Table Name	gazetteerfault	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	gazid	
Index Keys 

Index Key	Sort Order	
gazid	Ascending	 

gazline_pk_gazid

Index Name	gazline_pk_gazid	
Table Name	gazetteerline	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	gazid	
Index Keys 

Index Key	Sort Order	
gazid	Ascending	 

gazpt_pk_gazid

Index Name	gazpt_pk_gazid	
Table Name	gazetteerpt	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	gazid	
Index Keys 

Index Key	Sort Order	
gazid	Ascending	 

gazeq_pk_gazid

Index Name	gazeq_pk_gazid	
Table Name	gazetteerquake	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	gazid	
Index Keys 

Index Key	Sort Order	
gazid	Ascending	 

gazqry_pk_gazid

Index Name	gazqry_pk_gazid	
Table Name	gazetteerquarry	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	gazid	
Index Keys 

Index Key	Sort Order	
gazid	Ascending	 

gaztown_pk_gazid

Index Name	gaztown_pk_gazid	
Table Name	gazetteertown	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	gazid	
Index Keys 

Index Key	Sort Order	
gazid	Ascending	 

gaztype_pk_code

Index Name	gaztype_pk_code	
Table Name	gazetteertype	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	code	
Index Keys 

Index Key	Sort Order	
code	Ascending	 

PK3

Index Name	PK3	
Table Name	jasieventlock	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	evid	
Index Keys 

Index Key	Sort Order	
evid	Ascending	 

progkey01

Index Name	progkey01	
Table Name	program	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	progid	
Index Keys 

Index Key	Sort Order	
progid	Ascending	 

request_cardkey01

Index Name	request_cardkey01	
Table Name	request_card	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	rcid	
Index Keys 

Index Key	Sort Order	
rcid	Ascending	 

stamapkey01

Index Name	stamapkey01	
Table Name	stamapping	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	net,sta	
Index Keys 

Index Key	Sort Order	
net	Ascending	 
sta	Ascending	 

unassocampkey01

Index Name	unassocampkey01	
Table Name	unassocamp	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	ampid	
Index Keys 

Index Key	Sort Order	
ampid	Ascending	 

Foreign Key Summary Report

Parent Table	Child Table	Type	No. of Keys	
program	config_channel	Identifying	1	
gazetteerpt	gazetteerbigtown	Identifying	1	
gazetteerpt	gazetteerquake	Identifying	1	
gazetteerline	gazetteerfault	Identifying	1	
gazetteertype	gazetteerline	Non-Identifying	1	
gazetteertype	gazetteerpt	Non-Identifying	1	
gazetteerpt	gazetteerquarry	Identifying	1	
gazetteerpt	gazetteertown	Identifying	1	

Foreign Key Detail Reports

Foreign Key: program to config_channel

Name		
Type	Identifying	
Parent Table	program	
Child Table	config_channel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
progid	progid	 

Foreign Key: gazetteerpt to gazetteerbigtown

Name	gazbigtown_fk_gazid	
Type	Identifying	
Parent Table	gazetteerpt	
Child Table	gazetteerbigtown	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
gazid	gazid	 

Foreign Key: gazetteerpt to gazetteerquake

Name	gazeq_fk_gazid	
Type	Identifying	
Parent Table	gazetteerpt	
Child Table	gazetteerquake	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
gazid	gazid	 

Foreign Key: gazetteerline to gazetteerfault

Name	gazfault_fk_gazid	
Type	Identifying	
Parent Table	gazetteerline	
Child Table	gazetteerfault	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
gazid	gazid	 

Foreign Key: gazetteertype to gazetteerline

Name	gazline_fk_type	
Type	Non-Identifying	
Parent Table	gazetteertype	
Child Table	gazetteerline	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
code	type	 

Foreign Key: gazetteertype to gazetteerpt

Name	gazpt_fk_type	
Type	Non-Identifying	
Parent Table	gazetteertype	
Child Table	gazetteerpt	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
code	type	 

Foreign Key: gazetteerpt to gazetteerquarry

Name	gazqry_fk_gazid	
Type	Identifying	
Parent Table	gazetteerpt	
Child Table	gazetteerquarry	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
gazid	gazid	 

Foreign Key: gazetteerpt to gazetteertown

Name	gaztown_fk_gazid	
Type	Identifying	
Parent Table	gazetteerpt	
Child Table	gazetteertown	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
gazid	gazid