| orgprefpriority |
| Logical Entity Name | orgprefpriority |
| Default Table Name | orgprefpriority |
| Definition | Used to show rules where which origin type is used as preferred. Used by ORGPREF packages |
| orgprefpriority Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| REGION_NAME |
VARCHAR(24) | NO | ||
| DATETIME_ON |
NUMERIC(25, 10) | NO | ||
| DATETIME_OFF | NUMERIC(25, 10) | NO | ||
| PRIORITY |
NUMERIC(5, 0) | NO | ||
| TYPE | VARCHAR(2) | YES | ||
| AUTH | VARCHAR(15) | YES | ||
| SUBSOURCE | VARCHAR(8) | YES | ||
| ALGORITHM | VARCHAR(15) | YES | ||
| MIN_OBS | NUMERIC(3, 0) | YES | ||
| MAX_GAP | NUMERIC(4, 1) | YES | ||
| MAX_ERHOR | NUMERIC(7, 3) | YES | ||
| MAX_DIST | NUMERIC(7, 3) | YES | ||
| MAX_DEPTH | NUMERIC(7, 3) | YES | ||
| MAX_RMS | NUMERIC(5, 3) | YES | ||
| MIN_QUAL | NUMERIC(3, 2) | YES | ||
| LDDATE | DATE | YES |
| orgprefpriority Keys |
| Key Name | Key Type | Keys |
| ORIGINPREF_PK | PrimaryKey | REGION_NAME, DATETIME_ON, PRIORITY |
| orgprefpriority Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| orgprefpriority Check Constraints |
| Check Constraint Name | CheckConstraint |
| ORIGINPREF_TYPE_CK | type IN ('H','D') |
| ORIGINPREF_MIN_OBS_CK | min_obs >= 0 |
| ORIGINPREF_MAX_GAP_CK | max_gap >= 0. and max_gap <= 360.0 |
| ORIGINPREF_MAX_ERHOR_CK | max_erhor >= 0. |
| ORIGINPREF_MAX_DIST_CK | max_dist >= 0. |
| ORIGINPREF_MAX_RMS_CK | max_rms >= 0. |
| ORIGINPREF_MIN_QUAL_CK | min_qual BETWEEN 0. AND 1.0 |