assocevampset 
Logical Entity Name  assocevampset 
Default Table Name  assocevampset 
Definition  This table associates amplitude sets with an event 

assocevampset Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
ampsetid(PK)    NUMERIC(0, 0)  NO  Amplitude set identifier 
ampsettype(PK)(FK)    VARCHAR(20)  NO  Amplitude set type 
evid(FK)    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 merging data for a single event from multiple sources without insisting that database evid is identical to the source’s local event identifier 
subsource    VARCHAR(8)  NO  Name tag of the application creating the set (e.g. AmpGen AmpGenPp Gmp2Db) 
isvalid    NUMERIC(0, 0)  NO  Has value 1 if preferred set, 0 otherwise  
lddate    DATE  YES  Load date. Date and time that the record was created, in Oracle date datatype 

assocevampset Keys 
Key Name  Key Type  Keys 
assocevampsetkey01  PrimaryKey  ampsetid, ampsettype 

assocevampset Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
event  Non-Identifying  One To Zero or More        evid  NO 
ampsettypes  Identifying  One To Zero or More        ampsettype  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
ampset  Non-Specific            NO 

assocevampset Check Constraints 
Check Constraint Name  CheckConstraint