mecfreqdata Columns

ColumnName	Domain	Datatype	NULL	Definition
mecfreqid		NUMBER(15, 0)	NO	Frequency information identifier
type		VARCHAR2(15)	NO	What this frequency is (frequency for fit)
freq		NUMBER(15, 6)	NO	Frequency value

mecfreqdata Primary and Unique Keys

Key Name	Key Type	Keys
MecFreqData_PK	PrimaryKey	mecfreqid, type

mecfreqdata Foreign Keys

Parent Relationships:

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

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

mecfreqdata Check Constraints

Check Constraint Name	CheckConstraint
MecFreqData02	mecfreqid > 0
MecFreqData01	type IN ('LP','HP','SF')