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