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 Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
REGION_NAME |  | VARCHAR(24) | NO |
DATETIME_ON |  | NUMERIC(0, 0) | NO |
DATETIME_OFF |  | NUMERIC(0, 0) | NO |
PRIORITY |  | NUMERIC(0, 0) | NO |
MAGTYPE |  | VARCHAR(6) | YES |
AUTH |  | VARCHAR(15) | YES |
SUBSOURCE |  | VARCHAR(8) | YES |
MAGALGO |  | VARCHAR(15) | YES |
MINMAG |  | NUMERIC(0, 0) | YES |
MAXMAG |  | NUMERIC(0, 0) | YES |
MINREADINGS |  | NUMERIC(0, 0) | YES |
MAXUNCERTAINTY |  | NUMERIC(0, 0) | YES |
QUALITY |  | NUMERIC(0, 0) | YES |
LDDATE |  | DATE | YES |

magprefpriority Keys

Key Name | Key Type | Keys
MAGPREF_PK | PrimaryKey | REGION_NAME, DATETIME_ON, PRIORITY

magprefpriority 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

magprefpriority Check Constraints

Check Constraint Name | CheckConstraint
MAGPREF_MAGTYPE_CK | magtype IN ('a','b','e','l','l1','l2','lg','c','s','w','z','B','un','d','h','n')
MAGPREF_MINMAG_CK | minmag >= -10.0 and minmag <= 10.0
MAGPREF_MAXMAG_CK | maxmag >= -10.0 and maxmag <= 10.0