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