mecfreq

Logical Entity Name | mecfreq
Default Table Name | mecfreq
Definition | Summary information on frequency data

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 | 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