FTNO
FOREIGN KEY
FEATURE ID OF THE FAULT ENTITY ARC FROM THE GIS DATA SET
PROPOGATED FROM FT.DAT
N
Number
dbLong
None
ID2
SECONDARY ID FOR THIS FAULT ENTITY
FTCLASS
ATTRIBUTE
GENERAL FAULT TYPE FOR THIS FAULT ENTITY
OBTAINED FROM PICKLIST OR FROM CHOICE BOXS IN DATA ENTRY INTERFACE
FTCLASS.PMT
FTCLASSPT
C
Text
dbText
Combo
FTDISP
DISPLACEMENT SENSE
SELECTED FROM CHOICE BOXES DURING DATA ENTRY
FTDISP.PMT
FTDISPT
TYPESTAT
WHETHER THIS FAULT ENTITY CONTAINS MORE THAN ONE MOVEMENT COMPONENT
OBTAINES FROM CHOICE BOXES ON DATA ENTRY
StringSearch
FTNO-ID2
FTNO_ID2
FAULT ENTITIY KEY
COMPNO
SECONDARY  KEY
COMPONENT NUMBER FOR THIS FAULT ENTITY
ASSIGNED BY DATA ENTERED BY SHOULD BE GENERATEDBY DATA ENTRY UTILITY
PRIORITY
NUMERICAL ORDER OF PRIORITY
INTEGER ASSIGNED BY USER.  A USER FIELD
FTNO-ID2-COMPNO
FTNID2CNO
PRIMARY KEY
PRIMARY KEY CONCATENATED FROM FTNO-ID2 AND COMPNO
DBMS MANAGEMENT SYSTEM ALLOWS ADJACENT FIELDS TO BE REDEFINED AS COMPOUND KEYS