gazetteerline

Logical Entity Name | GazetteerLine
Default Table Name | gazetteerline
Definition | Graphical line segments are defined by series of binary lat,lon stored as BLOB type (for fault lines)

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 | Initially Deferred
gazetteertype | Non-Identifying | One To Zero or More | gazline_fk_type |  |  | type | NO | NO | NO

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred
gazetteerfault | Identifying | One To Zero or More | gazfault_fk_gazid |  |  |  | NO | 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