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