ampset Columns

ColumnName	Domain	Datatype	NULL	Definition
ampsetid		NUMBER	NO	Amplitude set identifier
ampid		NUMBER(15, 0)	NO	Amplitude identification. Each amplitude is assigned a unique positive integer identifying it. This number is used in the AssocAmO relation along with the origin identifier to link Amp and Origin. This number is used also in the AssocAmM relation along with the magnitude identifier to link Amp and Netmag

ampset Primary and Unique Keys

Key Name	Key Type	Keys
ampsetkey01	PrimaryKey	ampsetid, ampid

ampset Foreign Keys

Parent Relationships:

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

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

ampset Check Constraints

Check Constraint Name

CheckConstraint