gazetteerbigtown

Logical Entity Name | gazetteerbigtown
Default Table Name | gazetteerbigtown
Definition | Ancillary descriptive data for significant town entries in gazetteerpt table

gazetteerbigtown Columns

ColumnName | Domain | Datatype | NULL | Definition
gazid |  | NUMBER(16, 0) | NO | References gazetteerpt.gazid
pop |  | NUMBER(10, 0) | YES | Population >= 0
remark |  | VARCHAR2(80) | YES | Information about town
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

gazetteerbigtown Primary and Unique Keys

Key Name | Key Type | Keys
gazbigtown_pk_gazid | PrimaryKey | gazid

gazetteerbigtown Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable
gazetteerpt | Identifying | One To Zero or More | gazbigtown_fk_gazid |  |  | gazid | NO | NO

Child Relationships:

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

gazetteerbigtown Check Constraints

Check Constraint Name | CheckConstraint
gazbigtown_pop | pop >= 0