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