Physical Design Dictionary

 NCEDC/TriNet Waveform Schema
Version 1.2.3

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

NCEDC/TriNet Waveform Schema

Diagram Name	NCEDC/TriNet Waveform Schema	
Description	NCEDC/TriNet Waveform Schema ER Diagram	
Author	Stephane Zuzlewski	
Company	Berkeley Seismological Laboratory	
Version	1.2.3	
Copyright	NCEDC/TriNet	
Copyright Year	2002	

NCEDC

Model Name	NCEDC	
Database Platform	Oracle 9i	

Table Summary Report

Table Name	Table Type	Primary Keys	# Col	
AssocWaE	Dependent	wfid,evid	5	
Filename	Independent	fileid	7	
Pathname	Independent	pathname,net,wave_fmt	3	
Subdir	Independent	subdirid	3	
Waveform	Independent	wfid	26	

Table Detail Reports

AssocWaE

Table Name	AssocWaE	
Owner Name		
Primary Keys	wfid,evid	
Definition	Data associating waveforms with events	
Columns 

Column Name	Domain	Datatype	Null	Definition	
wfid		NUMBER(15, 0)	N	Waveform identifier. The key field is a unique identifier for a segment of digital waveform data	 
evid		NUMBER(15, 0)	N	Event identifier.  Each event is assigned a unique integer which identifies it in a database. It is possible for several records in the Origin relation to have the same evid. This indicates there are several opinions about the location of the event. The evid does not have to be identical to the local network's event identifier, which is stored in the Origin table. This allows to merge data for a single event from multiple sources without insisting that database evid is identical to the source's local event identifier
	 
datetime_on		NUMBER(25, 10)	N	Time of first datum	 
datetime_off		NUMBER(25, 10)	N	Time of last datum	 
lddate		DATE	N	Load date. Date and time that the record was created or last modified	 
Storage 

TABLESPACE	WF_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION	Heap	
CACHE	NO	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Waveform	AssocWaE	Identifying	Waveform_Event	 
DDL Code 

CREATE TABLE AssocWaE(
    wfid            NUMBER(15, 0)     NOT NULL,
    evid            NUMBER(15, 0)     NOT NULL,
    datetime_on     NUMBER(25, 10)    NOT NULL,
    datetime_off    NUMBER(25, 10)    NOT NULL,
    lddate          DATE              DEFAULT (SYSDATE) NOT NULL,
    CONSTRAINT AWE00 PRIMARY KEY (wfid, evid), 
    CONSTRAINT Waveform_Event FOREIGN KEY (wfid)
    REFERENCES Waveform(wfid)
) 
TABLESPACE WF_DATA
;

	

wfid

Column Name	wfid	Table Name	AssocWaE	
Role Name	wfid	
Primary Key	YES	
Foreign Key	YES	Parent Table	Waveform	
Definition 

Waveform identifier. The key field is a unique identifier for a segment of digital waveform data	
Column Properties 

Data Type	NUMBER(15, 0)	Width	15	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

evid

Column Name	evid	Table Name	AssocWaE	
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. It is possible for several records in the Origin relation to have the same evid. This indicates there are several opinions about the location of the event. The evid does not have to be identical to the local network's event identifier, which is stored in the Origin table. This allows to merge data for a single event from multiple sources without insisting that database evid is identical to the source's local event identifier
	
Column Properties 

Data Type	NUMBER(15, 0)	Width	15	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

datetime_on

Column Name	datetime_on	Table Name	AssocWaE	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Time of first datum	
Column Properties 

Data Type	NUMBER(25, 10)	Width	25	Scale	10	
Nullable	NO	
Identity	NO	
Identity	NO	

datetime_off

Column Name	datetime_off	Table Name	AssocWaE	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Time of last datum	
Column Properties 

Data Type	NUMBER(25, 10)	Width	25	Scale	10	
Nullable	NO	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	AssocWaE	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

Filename

Table Name	Filename	
Owner Name		
Primary Keys	fileid	
Definition	Summary information on a waveform filenames	
Columns 

Column Name	Domain	Datatype	Null	Definition	
fileid		NUMBER(15, 0)	N	Filename identifier. The key field is a unique identifier for a physical file on a disk	 
dfile		VARCHAR2(32)	N	Data file. This is the file name of a disk-based waveform file	 
datetime_on		NUMBER(25, 10)	N	Time of first sample in the waveform file	 
datetime_off		NUMBER(25, 10)	N	Time of last sample in the waveform file	 
nbytes		NUMBER(10, 0)	Y	Number of bytes. This quantity is the number of bytes in a waveform segment or a file	 
subdirid		NUMBER(15, 0)	N	Directory identifier. The key field is a unique identifier for a directory name on a disk	 
lddate		DATE	N	Load date. Date and time that the record was created or last modified	 
Storage 

TABLESPACE	WF_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION	Heap	
CACHE	NO	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Subdir	Filename	Non-Identifying	Filename_PartialPath	 
Filename	Waveform	Non-Identifying	Waveform_Filename	 
DDL Code 

CREATE TABLE Filename(
    fileid          NUMBER(15, 0)     NOT NULL,
    dfile           VARCHAR2(32)      NOT NULL,
    datetime_on     NUMBER(25, 10)    NOT NULL,
    datetime_off    NUMBER(25, 10)    NOT NULL,
    nbytes          NUMBER(10, 0),
    subdirid        NUMBER(15, 0)     NOT NULL,
    lddate          DATE              DEFAULT (SYSDATE) NOT NULL,
    CONSTRAINT Fil00 PRIMARY KEY (fileid), 
    CONSTRAINT Filename_PartialPath FOREIGN KEY (subdirid)
    REFERENCES Subdir(subdirid)
) 
TABLESPACE WF_DATA
;

	

fileid

Column Name	fileid	Table Name	Filename	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Filename identifier. The key field is a unique identifier for a physical file on a disk	
Column Properties 

Data Type	NUMBER(15, 0)	Width	15	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

dfile

Column Name	dfile	Table Name	Filename	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Data file. This is the file name of a disk-based waveform file	
Column Properties 

Data Type	VARCHAR2(32)	Width	32	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

datetime_on

Column Name	datetime_on	Table Name	Filename	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Time of first sample in the waveform file	
Column Properties 

Data Type	NUMBER(25, 10)	Width	25	Scale	10	
Nullable	NO	
Identity	NO	
Identity	NO	

datetime_off

Column Name	datetime_off	Table Name	Filename	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Time of last sample in the waveform file	
Column Properties 

Data Type	NUMBER(25, 10)	Width	25	Scale	10	
Nullable	NO	
Identity	NO	
Identity	NO	

nbytes

Column Name	nbytes	Table Name	Filename	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Number of bytes. This quantity is the number of bytes in a waveform segment or a file	
Column Properties 

Data Type	NUMBER(10, 0)	Width	10	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

subdirid

Column Name	subdirid	Table Name	Filename	
Role Name	subdirid	
Primary Key	NO	
Foreign Key	YES	Parent Table	Subdir	
Definition 

Directory identifier. The key field is a unique identifier for a directory name on a disk	
Column Properties 

Data Type	NUMBER(15, 0)	Width	15	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Filename	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

Pathname

Table Name	Pathname	
Owner Name		
Primary Keys	pathname,net,wave_fmt	
Definition	Summary information on possible path options of waveforms for a given network	
Columns 

Column Name	Domain	Datatype	Null	Definition	
pathname		VARCHAR2(255)	N	Path name	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
wave_fmt		NUMBER(2, 0)	N	Waveform type	 
Storage 

TABLESPACE	WF_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION	Heap	
CACHE	NO	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
DDL Code 

CREATE TABLE Pathname(
    pathname    VARCHAR2(255)    NOT NULL,
    net         VARCHAR2(8)      NOT NULL,
    wave_fmt    NUMBER(2, 0)     NOT NULL,
    CONSTRAINT PKPathname PRIMARY KEY (pathname, net, wave_fmt)
) 
TABLESPACE WF_DATA
;

	

pathname

Column Name	pathname	Table Name	Pathname	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Path name	
Column Properties 

Data Type	VARCHAR2(255)	Width	255	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

net

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

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

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

wave_fmt

Column Name	wave_fmt	Table Name	Pathname	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Waveform type	
Column Properties 

Data Type	NUMBER(2, 0)	Width	2	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

Subdir

Table Name	Subdir	
Owner Name		
Primary Keys	subdirid	
Definition	Summary information on a directory name	
Columns 

Column Name	Domain	Datatype	Null	Definition	
subdirid		NUMBER(15, 0)	N	Directory identifier. The key field is a unique identifier for a directory name on a disk	 
subdirname		VARCHAR2(64)	N	Path name. This is the name of a disk-based directory	 
lddate		DATE	N	Load date. Date and time that the record was created or last modified
	 
Storage 

TABLESPACE	WF_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION	Heap	
CACHE	NO	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Subdir	Filename	Non-Identifying	Filename_PartialPath	 
DDL Code 

CREATE TABLE Subdir(
    subdirid      NUMBER(15, 0)    NOT NULL,
    subdirname    VARCHAR2(64)     NOT NULL,
    lddate        DATE             DEFAULT (SYSDATE) NOT NULL,
    CONSTRAINT Sub00 PRIMARY KEY (subdirid)
) 
TABLESPACE WF_DATA
;

	

subdirid

Column Name	subdirid	Table Name	Subdir	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Directory identifier. The key field is a unique identifier for a directory name on a disk	
Column Properties 

Data Type	NUMBER(15, 0)	Width	15	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

subdirname

Column Name	subdirname	Table Name	Subdir	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Path name. This is the name of a disk-based directory	
Column Properties 

Data Type	VARCHAR2(64)	Width	64	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

lddate

Column Name	lddate	Table Name	Subdir	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified
	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

Waveform

Table Name	Waveform	
Owner Name		
Primary Keys	wfid	
Definition	Summary information on a waveform	
Columns 

Column Name	Domain	Datatype	Null	Definition	
wfid		NUMBER(15, 0)	N	Waveform identifier. The key field is a unique identifier for a segment of digital waveform data	 
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	 
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 a unique source within the domain specified by auth	 
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.)	 
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)	Y	Describes the individual sites on an array station, operated by the same network operator	 
archive		VARCHAR2(8)	N	This field specifies the place where the seismogram is archived	 
datetime_on		NUMBER(25, 10)	N	Time of first datum	 
datetime_off		NUMBER(25, 10)	N	Time of last datum	 
samprate		NUMBER(12, 8)	N	Sampling rate. This attribute is the sample rate in samples/second	 
wavetype		VARCHAR2(1)	Y	This attribute denotes the type of waveform	 
fileid		NUMBER(15, 0)	N	Filename identifier. The key field is a unique identifier for a physical file on a disk	 
foff		NUMBER(12, 0)	Y	File offset. This is the byte offset of a waveform segment within a data file	 
nbytes		NUMBER(10, 0)	Y	Number of bytes. This quantity is the number of bytes in a waveform segment or a file	 
traceoff		NUMBER(10, 0)	Y	File offset. This is the byte offset of the entire trace	 
tracelen		NUMBER(10, 0)	Y	Number of bytes. This quantity represents the length of the entire trace	 
status		VARCHAR2(1)	N	This attribute denotes the status of the waveform in the file	 
wave_fmt		NUMBER(2, 0)	Y	Waveform type	 
format_id		NUMBER(2, 0)	Y	This attribute denotes a code indicating the encoding format. This number is assigned by the FDSN Data Exchange Working Group	 
wordorder		NUMBER(1, 0)	Y	Word order	 
recordsize		NUMBER(5, 0)	Y	Record size for data. For MiniSEED, the value is the MiniSEED record size, eg. 512, 4096, etc	 
locevid		VARCHAR2(12)	Y	Local event identifier. This attribute describes the original event identifier of the event. In combination with auth and subsource, it can be used to uniquely identify the original event identifier from that source. For example, waveforms from the original source may be associated with this identifier	 
lddate		DATE	N	Load date. Date and time that the record was created or last modified
	 
Storage 

TABLESPACE	WF_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION	Heap	
CACHE	NO	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

PARTITION NAME	Wf1986	
COLUMN HIGH VALUE	datetime_on:536457613	
TABLESPACE	PWF1986	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1987	
COLUMN HIGH VALUE	datetime_on:567993614	
TABLESPACE	PWF1987	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1988	
COLUMN HIGH VALUE	datetime_on:599616014	
TABLESPACE	PWF1988	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1989	
COLUMN HIGH VALUE	datetime_on:631152015	
TABLESPACE	PWF1989	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1990	
COLUMN HIGH VALUE	datetime_on:662688016	
TABLESPACE	PWF1990	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1991	
COLUMN HIGH VALUE	datetime_on:694224016	
TABLESPACE	PWF1991	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1992	
COLUMN HIGH VALUE	datetime_on:725846417	
TABLESPACE	PWF1992	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1993	
COLUMN HIGH VALUE	datetime_on:757382418	
TABLESPACE	PWF1993	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1994	
COLUMN HIGH VALUE	datetime_on:788918419	
TABLESPACE	PWF1994	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1995	
COLUMN HIGH VALUE	datetime_on:820454420	
TABLESPACE	PWF1995	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1996	
COLUMN HIGH VALUE	datetime_on:852076820	
TABLESPACE	PWF1996	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1997	
COLUMN HIGH VALUE	datetime_on:883612821	
TABLESPACE	PWF1997	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1998	
COLUMN HIGH VALUE	datetime_on:915148821	
TABLESPACE	PWF1998	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
PARTITION NAME	Wf1999	
COLUMN HIGH VALUE	datetime_on:946684821	
TABLESPACE	PWF1999	
PCTFREE	0	
PCTUSED 	0	
PCTINCREASE		
MINEXTENTS	0	
MAXEXTENTS	0	
INITIAL	0	
NEXT	0	
INITRANS	0	
MAXTRANS	0	
LOGGING		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
		
Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Filename	Waveform	Non-Identifying	Waveform_Filename	 
Waveform	AssocWaE	Identifying	Waveform_Event	 
DDL Code 

CREATE TABLE Waveform(
    wfid            NUMBER(15, 0)     NOT NULL,
    net             VARCHAR2(8)       NOT NULL,
    sta             VARCHAR2(6)       NOT NULL,
    auth            VARCHAR2(15)      NOT NULL,
    subsource       VARCHAR2(8),
    channel         VARCHAR2(3),
    channelsrc      VARCHAR2(8),
    seedchan        VARCHAR2(3)       NOT NULL,
    location        VARCHAR2(2),
    archive         VARCHAR2(8)       NOT NULL,
    datetime_on     NUMBER(25, 10)    NOT NULL,
    datetime_off    NUMBER(25, 10)    NOT NULL,
    samprate        NUMBER(12, 8)     NOT NULL,
    wavetype        VARCHAR2(1),
    fileid          NUMBER(15, 0)     NOT NULL,
    foff            NUMBER(12, 0),
    nbytes          NUMBER(10, 0),
    traceoff        NUMBER(10, 0),
    tracelen        NUMBER(10, 0),
    status          VARCHAR2(1)       NOT NULL,
    wave_fmt        NUMBER(2, 0),
    format_id       NUMBER(2, 0),
    wordorder       NUMBER(1, 0),
    recordsize      NUMBER(5, 0),
    locevid         VARCHAR2(12),
    lddate          DATE              DEFAULT (SYSDATE) NOT NULL,
    CONSTRAINT WF00 PRIMARY KEY (wfid), 
    CONSTRAINT Waveform_Filename FOREIGN KEY (fileid)
    REFERENCES Filename(fileid)
) 
TABLESPACE WF_DATA
PARTITION BY RANGE (datetime_on)(
PARTITION Wf1986
VALUES LESS THAN (536457613)
TABLESPACE PWF1986,
PARTITION Wf1987
VALUES LESS THAN (567993614)
TABLESPACE PWF1987,
PARTITION Wf1988
VALUES LESS THAN (599616014)
TABLESPACE PWF1988,
PARTITION Wf1989
VALUES LESS THAN (631152015)
TABLESPACE PWF1989,
PARTITION Wf1990
VALUES LESS THAN (662688016)
TABLESPACE PWF1990,
PARTITION Wf1991
VALUES LESS THAN (694224016)
TABLESPACE PWF1991,
PARTITION Wf1992
VALUES LESS THAN (725846417)
TABLESPACE PWF1992,
PARTITION Wf1993
VALUES LESS THAN (757382418)
TABLESPACE PWF1993,
PARTITION Wf1994
VALUES LESS THAN (788918419)
TABLESPACE PWF1994,
PARTITION Wf1995
VALUES LESS THAN (820454420)
TABLESPACE PWF1995,
PARTITION Wf1996
VALUES LESS THAN (852076820)
TABLESPACE PWF1996,
PARTITION Wf1997
VALUES LESS THAN (883612821)
TABLESPACE PWF1997,
PARTITION Wf1998
VALUES LESS THAN (915148821)
TABLESPACE PWF1998,
PARTITION Wf1999
VALUES LESS THAN (946684821)
TABLESPACE PWF1999
)
;

	

wfid

Column Name	wfid	Table Name	Waveform	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Waveform identifier. The key field is a unique identifier for a segment of digital waveform data	
Column Properties 

Data Type	NUMBER(15, 0)	Width	15	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

net

Column Name	net	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

sta

Column Name	sta	Table Name	Waveform	
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	
Column Properties 

Data Type	VARCHAR2(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

auth

Column Name	auth	Table Name	Waveform	
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
	
Column Properties 

Data Type	VARCHAR2(15)	Width	15	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

subsource

Column Name	subsource	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

A second identifier to specify a unique source within the domain specified by auth	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

channel

Column Name	channel	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Channel name	
Column Properties 

Data Type	VARCHAR2(3)	Width	3	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

channelsrc

Column Name	channelsrc	Table Name	Waveform	
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.)	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

seedchan

Column Name	seedchan	Table Name	Waveform	
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
	
Column Properties 

Data Type	VARCHAR2(3)	Width	3	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

location

Column Name	location	Table Name	Waveform	
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	
Column Properties 

Data Type	VARCHAR2(2)	Width	2	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

archive

Column Name	archive	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This field specifies the place where the seismogram is archived	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

datetime_on

Column Name	datetime_on	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Time of first datum	
Column Properties 

Data Type	NUMBER(25, 10)	Width	25	Scale	10	
Nullable	NO	
Identity	NO	
Identity	NO	

datetime_off

Column Name	datetime_off	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Time of last datum	
Column Properties 

Data Type	NUMBER(25, 10)	Width	25	Scale	10	
Nullable	NO	
Identity	NO	
Identity	NO	

samprate

Column Name	samprate	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Sampling rate. This attribute is the sample rate in samples/second	
Column Properties 

Data Type	NUMBER(12, 8)	Width	12	Scale	8	
Nullable	NO	
Identity	NO	
Identity	NO	

wavetype

Column Name	wavetype	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the type of waveform	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

fileid

Column Name	fileid	Table Name	Waveform	
Role Name	fileid	
Primary Key	NO	
Foreign Key	YES	Parent Table	Filename	
Definition 

Filename identifier. The key field is a unique identifier for a physical file on a disk	
Column Properties 

Data Type	NUMBER(15, 0)	Width	15	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

foff

Column Name	foff	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

File offset. This is the byte offset of a waveform segment within a data file	
Column Properties 

Data Type	NUMBER(12, 0)	Width	12	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

nbytes

Column Name	nbytes	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Number of bytes. This quantity is the number of bytes in a waveform segment or a file	
Column Properties 

Data Type	NUMBER(10, 0)	Width	10	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

traceoff

Column Name	traceoff	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

File offset. This is the byte offset of the entire trace	
Column Properties 

Data Type	NUMBER(10, 0)	Width	10	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

tracelen

Column Name	tracelen	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Number of bytes. This quantity represents the length of the entire trace	
Column Properties 

Data Type	NUMBER(10, 0)	Width	10	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

status

Column Name	status	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the status of the waveform in the file	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

wave_fmt

Column Name	wave_fmt	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Waveform type	
Column Properties 

Data Type	NUMBER(2, 0)	Width	2	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

format_id

Column Name	format_id	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

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

Data Type	NUMBER(2, 0)	Width	2	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

wordorder

Column Name	wordorder	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Word order	
Column Properties 

Data Type	NUMBER(1, 0)	Width	1	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

recordsize

Column Name	recordsize	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Record size for data. For MiniSEED, the value is the MiniSEED record size, eg. 512, 4096, etc	
Column Properties 

Data Type	NUMBER(5, 0)	Width	5	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

locevid

Column Name	locevid	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Local event identifier. This attribute describes the original event identifier of the event. In combination with auth and subsource, it can be used to uniquely identify the original event identifier from that source. For example, waveforms from the original source may be associated with this identifier	
Column Properties 

Data Type	VARCHAR2(12)	Width	12	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

lddate

Column Name	lddate	Table Name	Waveform	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified
	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

Index Summary Report

Table Name	Index Name	 Index Type	Unique	
AssocWaE	AWE00	PrimaryKey	YES	 
Filename	Fil00	PrimaryKey	YES	 
Filename	wffileind	Index	NO	 
Subdir	Sub00	PrimaryKey	YES	 
Waveform	wfdonind	Index	NO	 
Waveform	wfdoffind	Index	NO	 
Waveform	WF00	PrimaryKey	YES	 

Index Detail Reports

AWE00

Index Name	AWE00	
Table Name	AssocWaE	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	wfid,evid	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

Fil00

Index Name	Fil00	
Table Name	Filename	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	fileid	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE	B-Tree	
BYTE ORDER	Forward	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

DDL Code 

wffileind

Index Name	wffileind	
Table Name	Filename	
Index Type	Index	
Unique	NO	
Index Keys	dfile	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE	B-Tree	
BYTE ORDER	Forward	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

DDL Code 

Sub00

Index Name	Sub00	
Table Name	Subdir	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	subdirid	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE	B-Tree	
BYTE ORDER	Forward	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

DDL Code 

wfdonind

Index Name	wfdonind	
Table Name	Waveform	
Index Type	Index	
Unique	NO	
Index Keys	datetime_on	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE	B-Tree	
BYTE ORDER	Forward	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

DDL Code 

wfdoffind

Index Name	wfdoffind	
Table Name	Waveform	
Index Type	Index	
Unique	NO	
Index Keys	datetime_off	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE	B-Tree	
BYTE ORDER	Forward	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

DDL Code 

WF00

Index Name	WF00	
Table Name	Waveform	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	wfid	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE	B-Tree	
BYTE ORDER	Forward	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

DDL Code 

Foreign Key Summary Report

Parent Table	Child Table	Type	No. of Keys	
Waveform	AssocWaE	Identifying	1	
Subdir	Filename	Non-Identifying	1	
Filename	Waveform	Non-Identifying	1	

Foreign Key Detail Reports

Foreign Key: Waveform to AssocWaE

Name	Waveform_Event	
Type	Identifying	
Parent Table	Waveform	
Child Table	AssocWaE	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition	This relationship associates a waveform with an event	
Keys 

Parent Key	Child Key	
wfid	wfid	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Subdir to Filename

Name	Filename_PartialPath	
Type	Non-Identifying	
Parent Table	Subdir	
Child Table	Filename	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition	This relationship associates a filename with its partial path	
Keys 

Parent Key	Child Key	
subdirid	subdirid	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Filename to Waveform

Name	Waveform_Filename	
Type	Non-Identifying	
Parent Table	Filename	
Child Table	Waveform	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition	This relationship associates a waveform with its filename	
Keys 

Parent Key	Child Key	
fileid	fileid	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Oracle Sequence Summary Report

Name	ObjectType	
ncedcdba.fiseq	Sequence	
ncedcdba.sdseq	Sequence	
ncedcdba.waseq	Sequence	

Oracle Sequence Detail Report

ncedcdba.fiseq

Name	fiseq	
ObjectType	Sequence	
Description 

Sequence for primary key Filename.fileid	
SQL 

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

ncedcdba.sdseq

Name	sdseq	
ObjectType	Sequence	
Description 

Sequence for primary key Subdir.subdirid	
SQL 

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

ncedcdba.waseq

Name	waseq	
ObjectType	Sequence	
Description 

Sequence for primary key Waveform.wfid	
SQL 

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