Name | R_Mineral |
---|---|

Entity Type | Table |

Description | A reference table that stores valid minerals and their common properties. |

Submodel | Rock_Sample_Description |

Entity Scope | Reference |

Primary Key | Code |

Natural Key | Code |

Generalizations | Reference_Entity , Reference_Entity_Parent |

Specializations |

Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
---|---|---|---|---|---|

Active_Flag | boolean | NA |
1 = use without restriction. 0 = avoid use - the value has been deprecated and may be removed in a later release. | Yes1 |
NUMBER(1) |

Al_Calc | double | Percent % |
Weight % of Aluminum, calculated from formula | No |
NUMBER |

Al_Meas | double | Percent % |
Weight % of Aluminum, measured empirically | No |
NUMBER |

BMod_Calc | double | Pressure kPa |
Bulk Modulus, calculated from formula | No |
NUMBER |

B_Calc | double | Percent % |
Weight % of Boron, calculated from formula | No |
NUMBER |

B_Meas | double | Dimensionless |
Boron concentration (ppm), measured empirically | No |
NUMBER |

Ba_Calc | double | Percent % |
Weight % of Barium, calculated from formula | No |
NUMBER |

C_Calc | double | Percent % |
Weight % of Carbon, calculated from formula | No |
NUMBER |

Ca_Calc | double | Percent % |
Weight % of Calcium, calculated from formula | No |
NUMBER |

Ca_Meas | double | Percent % |
Weight % of Calcium, measured empirically | No |
NUMBER |

Cl_Calc | double | Percent % |
Weight % of Chlorine, calculated from formula | No |
NUMBER |

Code | CODE | NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | Yes |
VARCHAR2(64) |

Cu_Calc | double | Percent % |
Weight % of Copper, calculated from formula | No |
NUMBER |

DTC_Calc | double | Time_Per_Length s/m |
Delta-T Compressional (us/m), calculated from formula | No |
NUMBER |

DTS_Calc | double | Time_Per_Length s/m |
Delta-T Shear (us/m), calculated from formula | No |
NUMBER |

Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |

Epi_Calc | double | Dimensionless |
Epithermal CNL porosity, calculated from formula | No |
NUMBER |

Epi_Meas | double | Dimensionless |
Epithermal CNL porosity, measured empirically | No |
NUMBER |

F_Calc | double | Percent % |
Weight % of Fluorine, calculated from formula | No |
NUMBER |

Fe_Calc | double | Percent % |
Weight % of Iron, calculated from formula | No |
NUMBER |

Fe_Meas | double | Percent % |
Weight % of Iron, measured empirically | No |
NUMBER |

Formula | STRING64 | NA |
Chemical formula | No |
VARCHAR2(64) |

GR_Meas | double | API_Gamma_Ray gAPI |
Gamma Ray, measured empirically | No |
NUMBER |

Gd_Meas | double | Dimensionless |
Gadolinium concentration (ppm), measured empirically | No |
NUMBER |

H_Calc | double | Percent % |
Weight % of Hydrogen, calculated from formula | No |
NUMBER |

H_LOI_Meas | double | Percent % |
Volatile H component of LOI(H2O+), measured empirically | No |
NUMBER |

Insert_Date | DATE | NA |
Date the entity was created in the repository | No |
DATE |

Insert_User | STRING64 | NA |
The name of the user responsible for the creation of this entity in the repository. | No |
VARCHAR2(64) |

K_Calc | double | Percent % |
Weight % of Potassium, calculated from formula | No |
NUMBER |

K_Meas | double | Percent % |
Weight % of Potassium, measured empirically | No |
NUMBER |

LD_Calc | double | Length m |
Neutron diffusion length, calculated from formula | No |
NUMBER |

LOI_Meas | double | Percent % |
Loss on Ignition, % weight, measured empirically | No |
NUMBER |

LS_Calc | double | Length m |
Neutron slowing-down length, calculated from formula | No |
NUMBER |

Mg_Calc | double | Percent % |
Weight % of Magnesium, calculated from formula | No |
NUMBER |

Mg_Meas | double | Percent % |
Weight % of Magnesium, measured empirically | No |
NUMBER |

Mineral_Class | MINERAL_CLASS | NA |
Mineral class name | No |
VARCHAR2(32) |

Mineral_Group | MINERAL_GROUP | NA |
Mineral group name | No |
VARCHAR2(32) |

Mn_Calc | double | Percent % |
Weight % of Manganese, calculated from formula | No |
NUMBER |

Mol_Wt_Calc | double | No_Unit |
Molecular weight, calculated from formula | No |
NUMBER |

N_Calc | double | Percent % |
Weight % of Nitrogen, calculated from formula | No |
NUMBER |

Na_Calc | double | Percent % |
Weight % of Sodium, calculated from formula | No |
NUMBER |

Na_Meas | double | Percent % |
Weight % of Sodium, measured empirically | No |
NUMBER |

Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |

O_Calc | double | Percent % |
Weight % of Oxygen, calculated from formula | No |
NUMBER |

Occurrence | STRING255 | NA |
Occurrence of mineral | No |
VARCHAR2(255) |

PEF_Calc | double | No_Unit |
Photoelectric Factor, calculated from formula | No |
NUMBER |

PEF_Meas | double | No_Unit |
Photoelectric Factor, measured empirically | No |
NUMBER |

PR_Calc | double | No_Unit |
Poissons Ratio, calculated from formula | No |
NUMBER |

P_Calc | double | Percent % |
Weight % of Phosphorus, calculated from formula | No |
NUMBER |

Pb_Calc | double | Percent % |
Weight % of Lead, calculated from formula | No |
NUMBER |

Remarks | REMARKS_STR | NA |
Remarks | No |
VARCHAR2(999) |

Rho_Calc | double | Mass_Per_Volume kg/m3 |
Bulk Density, calculated from formula | No |
NUMBER |

Rhoe_Calc | double | Mass_Per_Volume kg/m3 |
Electron Density, calculated from formula | No |
NUMBER |

Rhol_Calc | double | Mass_Per_Volume kg/m3 |
Litho Density, calculated from formula | No |
NUMBER |

SMod_Calc | double | Pressure kPa |
Shear Modulus, calculated from formula | No |
NUMBER |

S_Calc | double | Percent % |
Weight % of Sulfur, calculated from formula | No |
NUMBER |

S_Meas | double | Percent % |
Weight % of Sulfur, measured empirically | No |
NUMBER |

Si_Calc | double | Percent % |
Weight % of Silicon, calculated from formula | No |
NUMBER |

Si_Meas | double | Percent % |
Weight % of Silicon, measured empirically | No |
NUMBER |

Sigma_Calc | double | Inverse_Length 1/m |
Neutron Cross-section, calculated from formula | No |
NUMBER |

Sigma_Meas | double | Inverse_Length 1/m |
Neutron Cross-section, measured empirically | No |
NUMBER |

Source | CODE | NA |
The person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc.. | No |
VARCHAR2(64) |

Sr_Calc | double | Percent % |
Weight % of Strontium, calculated from formula | No |
NUMBER |

Th_Meas | double | Dimensionless |
Thorium concentration (ppm), measured empirically | No |
NUMBER |

Therm_Calc | double | Dimensionless |
Thermal CNL porosity, calculated from formula | No |
NUMBER |

Therm_Meas | double | Dimensionless |
Thermal CNL porosity, measured empirically | No |
NUMBER |

Ti_Calc | double | Percent % |
Weight % of Titanium, calculated from formula | No |
NUMBER |

Ti_Meas | double | Percent % |
Weight % of Titanium, measured empirically | No |
NUMBER |

Tp_Calc | double | Time_Per_Length s/m |
EPT Propagation time, calculated from formula | No |
NUMBER |

Trace_Elements | STRING255 | NA |
Trace elements, calculated from formula | No |
VARCHAR2(255) |

UMA_Calc | double | No_Unit |
Volumetric Photoelectric Factor, calculated from formula | No |
NUMBER |

U_Meas | double | Dimensionless |
Uranium concentration (ppm), measured empirically | No |
NUMBER |

Update_Date | DATE | NA |
Date of the most-recent modification to the entity. | No |
DATE |

Update_User | STRING64 | NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |

Zn_Calc | double | Percent % |
Weight % of Zinc, calculated from formula | No |
NUMBER |

Zr_Calc | double | Percent % |
Weight % of Zirconium, calculated from formula | No |
NUMBER |

From Entity | Link | Description | Implementation Technique | Required |
---|---|---|---|---|

Lithology_Minerals | Accessory_Mineral | A value that represents the type of accessory mineral in the rock sample. | Restrict | No |

Rock_Sample_Fraction | Mineral_Fraction | A value that represents the type mineral in the rock sample fraction. | Restrict | No |