gazetteertype

Logical Entity Name | gazetteertype
Default Table Name | gazetteertype
Definition | 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 | Deferrable | Initially Deferred

Child Relationships:

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

gazetteertype Check Constraints

Check Constraint Name | CheckConstraint