| 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. | Yes 1 |
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 |