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 Columns

ColumnName | Domain | Datatype | NULL | Definition
grpid |  | VARCHAR2(4) | NO |
name |  | VARCHAR2(24) | NO |
auth |  | VARCHAR2(15) | NO |
rg_order |  | NUMBER(2, 0) | NO |

assoc_region_group Primary and Unique Keys

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

assoc_region_group Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred
gazetteer_region_group | Identifying | One To Zero or More | fk_reg_grpid |  |  | grpid | NO | NO | NO

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred

assoc_region_group Check Constraints

Check Constraint Name | CheckConstraint
chk_rank_assoc_reggrp | rg_order > 0