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