tbl_locality_age_cache locality_id the internal id number used by MED to identify this locality, used especially when mid-level locality does not have a mindat_id (CAUTION: this number is not permanent, and can change whenever MED is updated with new mindat data) mindat_id the number that mindat uses to identify this locality mineral_id id number that links to rruff.info mineral at_locality value = "1" if mineral exists at the locality according to mindat, i.e. it has not been passed up the locality hierarchy. is_remote value = "1" if age is passed to the minerals' locality from another locality, i.e. the locality is not directly dated age_type letter that represents the "goodness" or confidence of the age assigned to the mineral at the locality. These are the color codes as seen on the MED. is_legit_age value = "1" when the mineral occurs directly at the locality according to mindat or if there exists an age at the locality not originating from a lower level locality. i.e. is_legit_age == "1" WHEN (at_locality == "1") OR (max_age is not blank AND age_type != "P") max_age Oldest possible age (based on available data) for mineral at the locality max_age_excel_id id number that links to the age data used for the oldest possible age max_age_ref_id reference id number for the age used for oldest possible age min_age minimum possible age (based on available data) for the mineral at the locality min_age_excel_id id number that links to the age data used for the youngest possible age min_age_ref_id reference id number for the age used for youngest possible age dated_locality_mindat_id mindat id number for the locality that was directly dated