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 |  | NUMERIC(0, 0) | NO | Amplitude set identifier
ampsettype |  | VARCHAR(20) | NO | Amplitude set type
evid |  | 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