Graphical line segments are defined by series of binary lat,lon stored as BLOB type (for fault lines)

GazetteerLine Attributes

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

GazetteerLine Keys

Key Name	Key Type	Keys
gazline_pk_gazid	PrimaryKey	gazid

GazetteerLine Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
gazetteertype	Non-Identifying	One To Zero or More				type	NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
gazetteerfault	Identifying	One To Zero or More					NO

GazetteerLine Check Constraints

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