Ancillary descriptive data for fault entries in gazetteerpt table

gazetteerfault Columns

ColumnName	Domain	Datatype	NULL	Definition
gazid		NUMBER	NO	References gazetteerpt.gazid
remark		VARCHAR2(80)	YES	Ancillary description of fault
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

gazetteerfault Primary and Unique Keys

Key Name	Key Type	Keys
gazfault_pk_gazid	PrimaryKey	gazid

gazetteerfault Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
gazetteerline	Identifying	One To Zero or More	gazfault_fk_gazid			gazid	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

gazetteerfault Check Constraints

Check Constraint Name

CheckConstraint