Geographic map type keys and description

gazetteertype Columns

ColumnName	Domain	Datatype	NULL	Definition
code		NUMBER(3, 0)	NO	A number tag
name		VARCHAR2(32)	NO	A collective geographic type name
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

gazetteertype Primary and Unique Keys

Key Name	Key Type	Keys
gaztype_pk_code	PrimaryKey	code

gazetteertype Foreign Keys

Parent Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Child Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
gazetteerline	Non-Identifying	One To Zero or More	gazline_fk_type				NO
gazetteerpt	Non-Identifying	One To Zero or More	gazpt_fk_type				NO

gazetteertype Check Constraints

Check Constraint Name

CheckConstraint