AssocWaE 
Logical Entity Name  AssocWaE 
Default Table Name  AssocWaE 
Definition  Data associating waveforms with events 

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

AssocWaE Keys 
Key Name  Key Type  Keys 
AWE00  PrimaryKey  wfid, evid 

AssocWaE Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Waveform  Identifying  One To Zero or More        wfid  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

AssocWaE Check Constraints 
Check Constraint Name  CheckConstraint