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