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

Child Relationships:

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

gazetteerline Check Constraints

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