Logical 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	

Logical

Model Name	Logical	
Database Platform	Logical	

Entity Summary Report

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

Entity Detail Reports

AssocWaE

Entity Name	AssocWaE	
Owner Name		
Entity Type	Dependent	
Primary Keys	wfid,evid	
Definition	Data associating waveforms with events	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
wfid		NUMERIC(15, 0)	N	Waveform identifier. The key field is a unique identifier for a segment of digital waveform data	 
evid		NUMERIC(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		NUMERIC(25, 10)	N	Time of first datum	 
datetime_off		NUMERIC(25, 10)	N	Time of last datum	 
lddate		DATE	N	Load date. Date and time that the record was created or last modified	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Waveform	AssocWaE	Identifying	Waveform_Event	 

wfid

Attribute Name	wfid	Entity Name	AssocWaE	
Logical Role Name	wfid	
Role Name	wfid	
Primary Key	YES	
Foreign Key	YES	Parent Entity	Waveform	
Definition 

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

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

evid

Attribute Name	evid	Entity Name	AssocWaE	
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. 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
	
Logical Column Properties 

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

datetime_on

Attribute Name	datetime_on	Entity Name	AssocWaE	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Time of first datum	
Logical Column Properties 

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

datetime_off

Attribute Name	datetime_off	Entity Name	AssocWaE	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Time of last datum	
Logical Column Properties 

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

lddate

Attribute Name	lddate	Entity Name	AssocWaE	
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	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

Filename

Entity Name	Filename	
Owner Name		
Entity Type	Independent	
Primary Keys	fileid	
Definition	Summary information on a waveform filenames	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
fileid		NUMERIC(15, 0)	N	Filename identifier. The key field is a unique identifier for a physical file on a disk	 
dfile		VARCHAR(32)	N	Data file. This is the file name of a disk-based waveform file	 
datetime_on		NUMERIC(25, 10)	N	Time of first sample in the waveform file	 
datetime_off		NUMERIC(25, 10)	N	Time of last sample in the waveform file	 
nbytes		NUMERIC(10, 0)	Y	Number of bytes. This quantity is the number of bytes in a waveform segment or a file	 
subdirid		NUMERIC(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	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Subdir	Filename	Non-Identifying	Filename_PartialPath	 
Filename	Waveform	Non-Identifying	Waveform_Filename	 

fileid

Attribute Name	fileid	Entity Name	Filename	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

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

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

dfile

Attribute Name	dfile	Entity Name	Filename	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Data Type	VARCHAR(32)	Width	32	Scale		
Nullable	NO	
Identity	NO	

datetime_on

Attribute Name	datetime_on	Entity Name	Filename	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Time of first sample in the waveform file	
Logical Column Properties 

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

datetime_off

Attribute Name	datetime_off	Entity Name	Filename	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Time of last sample in the waveform file	
Logical Column Properties 

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

nbytes

Attribute Name	nbytes	Entity Name	Filename	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

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

subdirid

Attribute Name	subdirid	Entity Name	Filename	
Logical Role Name	subdirid	
Role Name	subdirid	
Primary Key	NO	
Foreign Key	YES	Parent Entity	Subdir	
Definition 

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

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

lddate

Attribute Name	lddate	Entity Name	Filename	
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	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

Pathname

Entity Name	Pathname	
Owner Name		
Entity Type	Independent	
Primary Keys	pathname,net,wave_fmt	
Definition	Summary information on possible path options of waveforms for a given network	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
pathname		VARCHAR(255)	N	Path name	 
net		VARCHAR(8)	N	Unique network identifier. This character string is the name of a seismic network	 
wave_fmt		NUMERIC(2, 0)	N	Waveform type	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	

pathname

Attribute Name	pathname	Entity Name	Pathname	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Path name	
Logical Column Properties 

Data Type	VARCHAR(255)	Width	255	Scale		
Nullable	NO	
Identity	NO	

net

Attribute Name	net	Entity Name	Pathname	
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	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

wave_fmt

Attribute Name	wave_fmt	Entity Name	Pathname	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

Waveform type	
Logical Column Properties 

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

Subdir

Entity Name	Subdir	
Owner Name		
Entity Type	Independent	
Primary Keys	subdirid	
Definition	Summary information on a directory name	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
subdirid		NUMERIC(15, 0)	N	Directory identifier. The key field is a unique identifier for a directory name on a disk	 
subdirname		VARCHAR(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
	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Subdir	Filename	Non-Identifying	Filename_PartialPath	 

subdirid

Attribute Name	subdirid	Entity Name	Subdir	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

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

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

subdirname

Attribute Name	subdirname	Entity Name	Subdir	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Data Type	VARCHAR(64)	Width	64	Scale		
Nullable	NO	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Subdir	
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
	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

Waveform

Entity Name	Waveform	
Owner Name		
Entity Type	Independent	
Primary Keys	wfid	
Definition	Summary information on a waveform	
Attributes 

Attribute/Logical Rolename	Domain	Datatype	Null	Definition	
wfid		NUMERIC(15, 0)	N	Waveform identifier. The key field is a unique identifier for a segment of digital waveform data	 
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	 
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 a unique source within the domain specified by auth	 
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.)	 
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)	Y	Describes the individual sites on an array station, operated by the same network operator	 
archive		VARCHAR(8)	N	This field specifies the place where the seismogram is archived	 
datetime_on		NUMERIC(25, 10)	N	Time of first datum	 
datetime_off		NUMERIC(25, 10)	N	Time of last datum	 
samprate		NUMERIC(12, 8)	N	Sampling rate. This attribute is the sample rate in samples/second	 
wavetype		VARCHAR(1)	Y	This attribute denotes the type of waveform	 
fileid		NUMERIC(15, 0)	N	Filename identifier. The key field is a unique identifier for a physical file on a disk	 
foff		NUMERIC(12, 0)	Y	File offset. This is the byte offset of a waveform segment within a data file	 
nbytes		NUMERIC(10, 0)	Y	Number of bytes. This quantity is the number of bytes in a waveform segment or a file	 
traceoff		NUMERIC(10, 0)	Y	File offset. This is the byte offset of the entire trace	 
tracelen		NUMERIC(10, 0)	Y	Number of bytes. This quantity represents the length of the entire trace	 
status		VARCHAR(1)	N	This attribute denotes the status of the waveform in the file	 
wave_fmt		NUMERIC(2, 0)	Y	Waveform type	 
format_id		NUMERIC(2, 0)	Y	This attribute denotes a code indicating the encoding format. This number is assigned by the FDSN Data Exchange Working Group	 
wordorder		NUMERIC(1, 0)	Y	Word order	 
recordsize		NUMERIC(5, 0)	Y	Record size for data. For MiniSEED, the value is the MiniSEED record size, eg. 512, 4096, etc	 
locevid		VARCHAR(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
	 
Defaults, Rules and Check Constraints 

Attribute	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
Relationships 

Parent Entity	Child Entity	Type	Relationship Name	
Filename	Waveform	Non-Identifying	Waveform_Filename	 
Waveform	AssocWaE	Identifying	Waveform_Event	 

wfid

Attribute Name	wfid	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Entity		
Definition 

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

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

net

Attribute Name	net	Entity Name	Waveform	
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	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

sta

Attribute Name	sta	Entity Name	Waveform	
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	
Logical Column Properties 

Data Type	VARCHAR(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	

auth

Attribute Name	auth	Entity Name	Waveform	
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
	
Logical Column Properties 

Data Type	VARCHAR(15)	Width	15	Scale		
Nullable	NO	
Identity	NO	

subsource

Attribute Name	subsource	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	

channel

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

Channel name	
Logical Column Properties 

Data Type	VARCHAR(3)	Width	3	Scale		
Nullable	YES	
Identity	NO	

channelsrc

Attribute Name	channelsrc	Entity Name	Waveform	
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.)	
Logical Column Properties 

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	

seedchan

Attribute Name	seedchan	Entity Name	Waveform	
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
	
Logical Column Properties 

Data Type	VARCHAR(3)	Width	3	Scale		
Nullable	NO	
Identity	NO	

location

Attribute Name	location	Entity Name	Waveform	
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	
Logical Column Properties 

Data Type	VARCHAR(2)	Width	2	Scale		
Nullable	YES	
Identity	NO	

archive

Attribute Name	archive	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Data Type	VARCHAR(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	

datetime_on

Attribute Name	datetime_on	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Time of first datum	
Logical Column Properties 

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

datetime_off

Attribute Name	datetime_off	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Time of last datum	
Logical Column Properties 

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

samprate

Attribute Name	samprate	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

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

wavetype

Attribute Name	wavetype	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

This attribute denotes the type of waveform	
Logical Column Properties 

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	YES	
Identity	NO	

fileid

Attribute Name	fileid	Entity Name	Waveform	
Logical Role Name	fileid	
Role Name	fileid	
Primary Key	NO	
Foreign Key	YES	Parent Entity	Filename	
Definition 

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

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

foff

Attribute Name	foff	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

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

nbytes

Attribute Name	nbytes	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

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

traceoff

Attribute Name	traceoff	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

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

tracelen

Attribute Name	tracelen	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

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

status

Attribute Name	status	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

Data Type	VARCHAR(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	

wave_fmt

Attribute Name	wave_fmt	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Waveform type	
Logical Column Properties 

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

format_id

Attribute Name	format_id	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

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

wordorder

Attribute Name	wordorder	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

Word order	
Logical Column Properties 

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

recordsize

Attribute Name	recordsize	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
Definition 

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

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

locevid

Attribute Name	locevid	Entity Name	Waveform	
Logical Role Name		
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Entity		
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	
Logical Column Properties 

Data Type	VARCHAR(12)	Width	12	Scale		
Nullable	YES	
Identity	NO	

lddate

Attribute Name	lddate	Entity Name	Waveform	
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
	
Logical Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	

Key Summary Report

Entity Name	Key Name	 Key Type	Unique	
AssocWaE	AWE00	PrimaryKey	YES	 
Filename	Fil00	PrimaryKey	YES	 
Filename	wffileind	Inversion Entry	NO	 
Pathname	PK5	PrimaryKey	YES	 
Subdir	Sub00	PrimaryKey	YES	 
Waveform	WF00	PrimaryKey	YES	 
Waveform	wfdonind	Inversion Entry	NO	 
Waveform	wfdoffind	Inversion Entry	NO	 

AWE00

Key Name	AWE00	
Entity Name	AssocWaE	
Key Type	PrimaryKey	
Unique	YES	
Keys	wfid,evid	

Fil00

Key Name	Fil00	
Entity Name	Filename	
Key Type	PrimaryKey	
Unique	YES	
Keys	fileid	

wffileind

Key Name	wffileind	
Entity Name	Filename	
Key Type	Inversion Entry	
Unique	NO	
Keys	dfile	

PK5

Key Name	PK5	
Entity Name	Pathname	
Key Type	PrimaryKey	
Unique	YES	
Keys	pathname,net,wave_fmt	

Sub00

Key Name	Sub00	
Entity Name	Subdir	
Key Type	PrimaryKey	
Unique	YES	
Keys	subdirid	

WF00

Key Name	WF00	
Entity Name	Waveform	
Key Type	PrimaryKey	
Unique	YES	
Keys	wfid	

wfdonind

Key Name	wfdonind	
Entity Name	Waveform	
Key Type	Inversion Entry	
Unique	NO	
Keys	datetime_on	

wfdoffind

Key Name	wfdoffind	
Entity Name	Waveform	
Key Type	Inversion Entry	
Unique	NO	
Keys	datetime_off	

Relationship Summary Report

Parent Entity	Child Entity	Relationship Type	No of Keys	
Waveform	AssocWaE	Identifying	1	
Subdir	Filename	Non-Identifying	1	
Filename	Waveform	Non-Identifying	1	

Relationship Detail Reports

Relationship: Waveform to AssocWaE

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

Verb Sentence		
Inverse Verb Sentence		
Definition	This relationship associates a waveform with an event	
Relationship 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	 

Relationship: Subdir to Filename

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

Verb Sentence		
Inverse Verb Sentence		
Definition	This relationship associates a filename with its partial path	
Relationship 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	 

Relationship: Filename to Waveform

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

Verb Sentence		
Inverse Verb Sentence		
Definition	This relationship associates a waveform with its filename	
Relationship 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