gazetteertown 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

gazetteertown Primary and Unique Keys

Key Name	Key Type	Keys
gaztown_pk_gazid	PrimaryKey	gazid

gazetteertown Foreign Keys

Parent Relationships:

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

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

gazetteertown Check Constraints

Check Constraint Name	CheckConstraint
gaztown_pop	pop >= 0