Geology

Geology Attributes

Geology Attributes attach geology information to Locality. Each locality may contain any number of geology attributes, each with a determiner and method.

Structure

UAM@ARCTOS> desc geology_attributes

Name                                   Null?    Type
GEOLOGY_ATTRIBUTE_ID                   NOT NULL NUMBER
LOCALITY_ID                           NOT NULL NUMBER
GEOLOGY_ATTRIBUTE                      NOT NULL VARCHAR2(255)
GEO_ATT_VALUE                          NOT NULL VARCHAR2(255)
GEO_ATT_DETERMINER_ID                       NUMBER
GEO_ATT_DETERMINED_DATE                           DATE
GEO_ATT_DETERMINED_METHOD                          VARCHAR2(255)
GEO_ATT_REMARK                                 VARCHAR2(4000)

 

Searching

While individual geology attributes are asserted, the hierachical code table structure allows locating specimens attributed to geology which is more specific than the search term.