gazetteerline Columns

ColumnName	Domain	Datatype	NULL	Definition
gazid		NUMBER	NO	References gazetteerpt.gazid
type		NUMBER(3, 0)	NO	References gazetteertype.code
name		VARCHAR2(80)	NO	Name of line group
line		NUMBER	NO	Line group segment number (>=0)
format		VARCHAR2(16)	YES	Known binary data byte type
points		BLOB	YES	Binary data
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

gazetteerline Primary and Unique Keys

Key Name	Key Type	Keys
gazline_pk_gazid	PrimaryKey	gazid

gazetteerline Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable
gazetteertype	Non-Identifying	One To Zero or More	gazline_fk_type			type	NO	NO

Child Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype	Deferrable
gazetteerfault	Identifying	One To Zero or More	gazfault_fk_gazid				NO	NO

gazetteerline Check Constraints

Check Constraint Name	CheckConstraint
gazline_value_format	format in ('double', 'float', 'int', 'long', 'char', 'byte')
gazline_value_line	line >= 0