AssocWaE Columns

ColumnName	Domain	Datatype	NULL	Definition
wfid		NUMBER(15, 0)	NO	Waveform identifier. The key field is a unique identifier for a segment of digital waveform data
evid		NUMBER(15, 0)	NO	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)	NO	Time of first datum
datetime_off		NUMBER(25, 10)	NO	Time of last datum
lddate		DATE	NO	Load date. Date and time that the record was created or last modified

AssocWaE Primary and Unique Keys

Key Name	Key Type	Keys
AWE00	PrimaryKey	wfid, evid

AssocWaE Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
Waveform	Identifying	One To Zero or More	Waveform_Event			wfid	NO	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

AssocWaE Check Constraints

Check Constraint Name

CheckConstraint