gazetteerquarry

Logical Entity Name | gazetteerquarry
Default Table Name | gazetteerquarry
Definition |
    Ancillary descriptive data for quarry entries in gazetteerpt table

gazetteerquarry Columns

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

gazetteerquarry Primary and Unique Keys

Key Name | Key Type | Keys
gazqry_pk_gazid | PrimaryKey | gazid

gazetteerquarry Foreign Keys

Parent Relationships:

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

Child Relationships:

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

gazetteerquarry Check Constraints

Check Constraint Name | CheckConstraint