gazetteerbigtown 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

gazetteerbigtown Primary and Unique Keys

Key Name	Key Type	Keys
gazbigtown_pk_gazid	PrimaryKey	gazid

gazetteerbigtown Foreign Keys

Parent Relationships:

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

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

gazetteerbigtown Check Constraints

Check Constraint Name	CheckConstraint
gazbigtown_pop	pop >= 0