assoc_region

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 (PK)(FK) VARCHAR2(4) NO

name (PK) 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

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

Key Name	Key Type	Keys
pk_assoc_reggrp	PrimaryKey	grpid, name

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

Check Constraint Name	CheckConstraint
chk_rank_assoc_reggrp	rg_order > 0