References gazetteerpt.gazid
Ancillary description of fault
Load date. Date and time that the record was created or last modified, in Oracle date datatype
| gazetteerfault |
| Logical Entity Name | gazetteerfault |
| Default Table Name | gazetteerfault |
| Definition | Ancillary descriptive data for fault entries in gazetteerpt table |
| gazetteerfault Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| gazid |
NUMERIC(0, 0) | NO | References gazetteerpt.gazid |
|
| remark | VARCHAR(80) | YES | Ancillary description of fault |
|
| lddate | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype |
| gazetteerfault Keys |
| Key Name | Key Type | Keys |
| gazfault_pk_gazid | PrimaryKey | gazid |
| gazetteerfault Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| GazetteerLine | Identifying | One To Zero or More | gazid | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| gazetteerfault Check Constraints |
| Check Constraint Name | CheckConstraint |