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 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