gazetteertown

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

gazetteertown Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
gazid |  | NUMERIC(16, 0) | NO |
    References gazetteerpt.gazid
pop |  | NUMERIC(10, 0) | YES |
    Population >= 0
remark |  | VARCHAR(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

gazetteertown Keys

Key Name | Key Type | Keys
gaztown_pk_gazid | PrimaryKey | gazid

gazetteertown Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
gazetteerpt | Identifying | One To Zero or More |  |  |  | gazid | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

gazetteertown Check Constraints

Check Constraint Name | CheckConstraint
gaztown_pop | pop >= 0