References gazetteerpt.gazid
Population >= 0
Information about town
Load date. Date and time that the record was created or last modified, in Oracle date datatype
| 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 |
| gazetteerpt | Identifying | One To Zero or More | gazbigtown_fk_gazid | gazid | NO |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| gazetteerbigtown Check Constraints |
| Check Constraint Name | CheckConstraint |
| gazbigtown_pop | pop >= 0 |