mecfreq Columns

ColumnName	Domain	Datatype	NULL	Definition
mecfreqid		NUMBER(15, 0)	NO	Frequency information identifier
mecalgo		VARCHAR2(15)	YES	This attribute represents the algorithm used to compute the mechanism
lddate		DATE	YES	Load date. Date and time that the record was created, in Oracle date datatype

mecfreq Primary and Unique Keys

Key Name	Key Type	Keys
MecFreq_PK	PrimaryKey	mecfreqid

mecfreq Foreign Keys

Parent Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Deferrable

Initially Deferred

Child Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype	Deferrable	Initially Deferred
mecdata	Non-Identifying	Zero or One to Zero or More	MecData_FK02				NO	NO	NO
mecfreqdata	Identifying	One To Zero or More	MecFreqData_FK01				NO	NO	NO

mecfreq Check Constraints

Check Constraint Name	CheckConstraint
MecF01	mecfreqid > 0