assocevampset Columns

ColumnName	Domain	Datatype	NULL	Definition
ampsetid		NUMBER	NO	Amplitude set identifier
ampsettype		VARCHAR2(20)	NO	Amplitude set type
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 merging data for a single event from multiple sources without insisting that database evid is identical to the source’s local event identifier
subsource		VARCHAR2(8)	NO	Name tag of the application creating the set (e.g. AmpGen AmpGenPp Gmp2Db)
isvalid		NUMBER	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 Primary and Unique Keys

Key Name	Key Type	Keys
assocevampsetkey01	PrimaryKey	ampsetid, ampsettype

assocevampset Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
event	Non-Identifying	One To Zero or More				evid	NO	NO	NO
ampsettypes	Identifying	One To Zero or More	assocevampsetkey02			ampsettype	NO	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

assocevampset Check Constraints

Check Constraint Name

CheckConstraint