| magprefpriority |
| Logical Entity Name | magprefpriority |
| Default Table Name | magprefpriority |
| Definition | Used to show rules where which magnitude type is used as preferred. Used by MAGPREF packages |
| magprefpriority Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| region_name |
VARCHAR2(24) | NO | ||
| datetime_on |
NUMBER | NO | ||
| datetime_off | NUMBER | NO | ||
| priority |
NUMBER | NO | ||
| magtype | VARCHAR2(6) | YES | ||
| auth | VARCHAR2(15) | YES | ||
| subsource | VARCHAR2(8) | YES | ||
| magalgo | VARCHAR2(15) | YES | ||
| minmag | NUMBER | YES | ||
| maxmag | NUMBER | YES | ||
| minreadings | NUMBER | YES | ||
| maxuncertainty | NUMBER | YES | ||
| quality | NUMBER | YES | ||
| lddate | DATE | YES |
| magprefpriority Primary and Unique Keys |
| Key Name | Key Type | Keys |
| magpref_pk | PrimaryKey | region_name, datetime_on, priority |
| magprefpriority 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 |
| magprefpriority Check Constraints |
| Check Constraint Name | CheckConstraint |
| magpref_minmag_ck | minmag >= -10.0 and minmag <= 10.0 |
| magpref_maxmag_ck | maxmag >= -10.0 and maxmag <= 10.0 |
| magpref_magtype_ck | magtype IN ('a','b','e','l','l1','l2','lg','c','s','w','z','B','un','d','h','n') |