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 Columns

ColumnName | Domain | Datatype | NULL | Definition
region_name |  | VARCHAR2(24) | NO |
datetime_on |  | NUMBER(25, 10) | NO |
datetime_off |  | NUMBER(25, 10) | NO |
priority |  | NUMBER(5, 0) | NO |
type |  | VARCHAR2(2) | YES |
auth |  | VARCHAR2(15) | YES |
subsource |  | VARCHAR2(8) | YES |
algorithm |  | VARCHAR2(15) | YES |
min_obs |  | NUMBER(3, 0) | YES |
max_gap |  | NUMBER(4, 1) | YES |
max_erhor |  | NUMBER(7, 3) | YES |
max_dist |  | NUMBER(7, 3) | YES |
max_depth |  | NUMBER(7, 3) | YES |
max_rms |  | NUMBER(5, 3) | YES |
min_qual |  | NUMBER(3, 2) | YES |
lddate |  | DATE | YES |

orgprefpriority Primary and Unique Keys

Key Name | Key Type | Keys
originpref_pk | PrimaryKey | region_name, datetime_on, priority

orgprefpriority 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

orgprefpriority Check Constraints

Check Constraint Name | CheckConstraint
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
originpref_type_ck | type IN ('H','D')