POSC Specifications: Epicentre Version 3.0 | Logical Data Model |
These are a series of new properties that are needed for geochemical analysis.
CHANGE ESM_geochemical_properties ADD ENTITY pty_pyrolysis_petroleum_potential (*<desc> This is the petroleum potential = (S1+S2).*) (*<projmeth>tab*) SUBTYPE OF (property); data_value : ndt_concentration_mass_per_mass (*<desc> This is the petroleum potential of the sample.*); fluid_sample : fluid_sample (*<desc> This is the fluid sample for which this petroleum potential is being described.*) (*<verb>be a property of*); UNIQUE si: fluid_sample, activity; END_ENTITY; ADD ENTITY pty_pyrolysis_petroleum_index (*<desc> This is the petroleum index = S1/(S1+S2).*) (*<projmeth>tab*) SUBTYPE OF (property); data_value : ndt_real4 (*<desc> This is the petroleum index of the sample.*); fluid_sample : fluid_sample (*<desc> This is the fluid sample for which this petroleum index is being described.*) (*<verb>be a property of*); UNIQUE si: fluid_sample, activity; END_ENTITY; ADD ENTITY pty_total_organic_carbon_mass (*<desc> This is the total organic carbon measured in mass.*) (*<projmeth>tab*) SUBTYPE OF (property); data_value : ndt_concentration_mass_per_mass (*<desc> This is the total organic carbon by mass.*); fluid_sample : fluid_sample (*<desc> The fluid sample that is being described.*) (*<verb>be a property of*); UNIQUE si: fluid_sample, activity; END_ENTITY; ADD ENTITY pty_gas_oil_generation_index (*<desc> This is the gas/oil generation index = (PC1+PC2-C5)/(PC6-C14+PC15+).*) (*<projmeth>tab*) SUBTYPE OF (property); data_value : ndt_real4 (*<desc> This is the gas/oil generation index of the sample.*); fluid_sample : fluid_sample (*<desc> This is the fluid sample for which this gas/oil generation index is being described.*) (*<verb>be a property of*); UNIQUE si: fluid_sample, activity; END_ENTITY; ALTER ENTITY pty_thermal_alteration_index; ALTER data_value ALTER TYPE AS ref_thermal_alteration_index; END_ENTITY; ADD ENTITY ref_thermal_alteration_index (*<projmeth>tab*) (*<population>local*) (*<desc> These are the values of thermal alteration index.*) SUBTYPE OF (ref_code); UNIQUE si: identifier; END_ENTITY; ALTER ENTITY pty_vitrinite_reflectance; ADD standard_deviation : OPTIONAL ndt_real4 (*<desc> The standard deviation.*); ADD count : OPTIONAL ndt_int4 (*<desc> The count.*); ADD effect_different_vitrinite : OPTIONAL ndt_text_132 (*<desc> The effect of different kind of vitrinite.*); END_ENTITY; ALTER ENTITY pty_fluid_show_quality; ADD ref_organic_matter_florescence : OPTIONAL ref_organic_matter_florescence (*<desc> The color of organic matter upon exposure to florescent light.*); END_ENTITY; ADD ENTITY ref_organic_matter_florescence (*<population>local*) (*<desc> The color emitted by organic matter when exposed to florescent light.*) SUBTYPE OF (ref_code); UNIQUE si: identifier; END_ENTITY; ADD ENTITY pty_concentration_volume_per_mass (*<desc> A concentration given as a volume per mass.*) (*<projmeth>tab*) SUBTYPE OF (pty_transient_property); typical_material_composition : OPTIONAL typical_material_composition (*<desc>This is the typical material composition being described.*) (*<verb>be a property of*); data_value : ndt_concentration_mass_per_volume (*<desc>This is the concentration value.*); bulk_material : OPTIONAL bulk_material (*<desc>This is the bulk material this concentration describes.*) (*<verb>be a property of*); UNIQUE si: typical_material_composition, bulk_material, activity, start_time, end_time; END_ENTITY; ALTER ENTITY typical_material_composition; INVERSE ADD pty_concentration_volume_per_mass : SET[0:?] of pty_concentration_volume_per_mass FOR typical_material_composition (*<verb>have a property of*); END_ENTITY; ALTER ENTITY bulk_material; INVERSE ADD pty_concentration_volume_per_mass : SET[0:?] of pty_concentration_volume_per_mass FOR bulk_material (*<verb>have a property of*); END_ENTITY; ADD ENTITY pty_peak_area_height (*<desc> This is the description of the shape of a spectrographic peak as either a peak or an area under the peak.*) (*<projmeth>tab*) SUBTYPE OF (property); fluid_sample : fluid_sample (*<desc> The fluid sample that is being described.*) (*<verb>be a property of*); data_value : ndt_real4 (*<desc> This is the height of the peak or area under the curve.*); value_type: ndt_type_of_curve_value (*<desc> This explains the type of value used in data_value*); peak_id : OPTIONAL ndt_name (*<desc> The identification of the peak being described.*); UNIQUE si: peak_id, fluid_sample, activity; END_ENTITY; ADD TYPE ndt_type_of_curve_value = ENUMERATION OF ( curve_peak, curve_area) (*<desc> These describe the type of spectrographic curve metrics.*); END_TYPE; ADD ENTITY pty_specific_fluid_component_ratio (*<desc>A property that describes the ratio of a measured fluid component with respect to a reference fluid component in a fluid sample.*) (*<projmeth>tab*) SUBTYPE OF (property); data_value : ndt_real4 (*<desc> The ratio of the measured fluid component to the reference fluid component.*); measured_fluid_component : OPTIONAL fluid_component (*<desc> When only one component (or pseudo-component) is being measured with respect to another fluid component, this is the fluid component being measured (numerator).*); reference_fluid_component : OPTIONAL fluid_component (*<desc> When only one component (or pseudo-component) is being measured with respect to another fluid component, this is the fluid component being referenced (denominator).*); fluid_sample : fluid_sample (*<desc> The fluid sample that is being described.*) (*<verb>be a property of*); UNIQUE si: fluid_sample, measured_fluid_component, reference_fluid_component, activity; END_ENTITY; ADD ENTITY pty_normalized_saturate_concentration (*<desc>A property that describes the ratio of saturates with respect to total organic carbon for a fluid sample.*) (*<projmeth>tab*) SUBTYPE OF (property); data_value : ndt_real4 (*<desc> The ratio of saturates with respect to total organic carbon.*); fluid_sample : fluid_sample (*<desc> The fluid sample that is being described.*) (*<verb>be a property of*); UNIQUE si: fluid_sample, activity; END_ENTITY; ALTER ENTITY fluid_sample; INVERSE ADD pty_pyrolysis_petroleum_potential : SET[0:?] OF pty_pyrolysis_petroleum_potential FOR fluid_sample (*<desc> This is the petroleum potential = (S1+S2).*) (*<verb>have a property of*); ADD pty_pyrolysis_petroleum_index : SET[0:?] OF pty_pyrolysis_petroleum_index FOR fluid_sample (*<desc> This is the petroleum index = (S1/(S1+S2)).*) (*<verb>have a property of*); ADD pty_total_organic_carbon_mass : SET[0:?] OF pty_total_organic_carbon_mass FOR fluid_sample (*<desc> This is the total organic carbon measured in mass.*) (*<verb>have a property of*); ADD pty_gas_oil_generation_index : SET[0:?] OF pty_gas_oil_generation_index FOR fluid_sample (*<desc> This is the gas/oil generation index = (PC1+PC2-C5)/(PC6-C14+PC15+).*) (*<verb>have a property of*); ADD pty_peak_area_height : SET[0:?] OF pty_peak_area_height FOR fluid_sample (*<desc> This is the description of the shape of a spectrographic peak as either a peak or an area under the peak.*) (*<verb>have a property of*); ADD pty_specific_fluid_component_ratio : SET[0:?] OF pty_specific_fluid_component_ratio FOR fluid_sample (*<desc>A property that describes the ratio of a measured fluid component with respect to a reference fluid component in a fluid sample.*) (*<verb>have a property of*); ADD pty_normalized_saturate_concentration : SET[0:?] OF pty_normalized_saturate_concentration FOR fluid_sample (*<desc>A property that describes the ratio of saturates with respect to total organic carbon for a fluid sample.*) (*<verb>have a property of*); END_ENTITY; END_CHANGE;