mecfreqdata 
Logical Entity Name  mecfreqdata 
Default Table Name  mecfreqdata 
Definition  Summary information on frequency data 

mecfreqdata Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
mecfreqid(PK)(FK)    NUMERIC(15, 0)  NO  Frequency information identifier 
type(PK)    VARCHAR(15)  NO  What this frequency is (frequency for fit) 
freq    NUMERIC(15, 6)  NO  Frequency value 

mecfreqdata Keys 
Key Name  Key Type  Keys 
MecFreqData_PK  PrimaryKey  mecfreqid, type 

mecfreqdata Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
mecfreq  Identifying  One To Zero or More        mecfreqid  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

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