assoc_region_group

Logical Entity Name | assoc_region_group
Default Table Name | assoc_region_group
Definition | Table used to associate a group of named region polygons with a network authority

assoc_region_group Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
grpid |  | VARCHAR(4) | NO |
name |  | VARCHAR(24) | NO |
auth |  | VARCHAR(15) | NO |
rg_order |  | NUMERIC(2, 0) | NO |

assoc_region_group Keys

Key Name | Key Type | Keys
pk_assoc_reggrp | PrimaryKey | grpid, name

assoc_region_group Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
gazetteer_region_group | Identifying | One To Zero or More |  |  |  | grpid | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

assoc_region_group Check Constraints

Check Constraint Name | CheckConstraint
chk_rank_assoc_reggrp | rg_order > 0