RUNO
FOREIGN KEY
FEATURE ID OF THE ROCKUNIT ENTITY AREA OR VOLUME FROM THE GIS DATA SET
PROPOGATED FROM RU.DAT AND/OR RUTYPE.DAT
N
Number
dbLong
None
ID2
SECONDARY KEY
SECONDARY ID FOR THIS ROCKUNIT ENTITY
AGEMA
ATTRIBUTE
AGE IN MILLIONS OF ANNUMS: MA
ENTERED BY COMPILER FROM THE DATA SOURCE
dbDouble
StringSearch
PLUSERR
PLUS ERROR ON AGE IN MA
MINUSERR
MINUS ERROR IN MA
ENTERED BY COMPILER FRO THE DATA SOURCE
ERRLEVEL
ONE OR 2 SIGMA ERROR
IN FUTURE FROM PICKLIST
C
Text
dbText
METHOD
ANALYTICAL DATING METHOD
IN FUTURE FROM PICK LIST
CONCENTRAT
TYPE OF MINERAL OR ROCK CONCENTRATE USED
SOURCEROCK
SOURCE ROCK USED AS SAMPLE
RUNO-ID2
RUNO_ID2
ROCKUNIT ENTITY KEY
PROPOGATED FROM RUTYPE.DAT
COMPNO
COMPONENT NUMBER FOR THIS ROCK TYPE COMPONENT OF THE ROCKUNIT ENTITY
REFNO
REFERENCE NUMBER FROM REFERENCE LIST REFMAIN.DAT
SELECTED FROM EXISTING NUMBERS IN REFMAIN.DAT
RUNO-ID2-COMPNO
RUNID2CNO
PRIMARY KEY
PRIMARY KEY CONCATENATED FROM RUNO-ID2 AND COMPNO
DBMS MANAGEMENT SYSTEM ALLOWS ADJACENT FIELDS TO BE REDEFINED AS COMPOUND KEYS