POSC Specifications: Epicentre Version 3.0 | Logical Data Model |
Add missing inverse relationships. Eliminate SELF redeclarations which were obviated by conversion from m-m relationships. Add missing verb phrases. Change the "be a property of" relationship from properties to rock_feature to be optional instead of mandatory.
CHANGE ERP2_cleanup (*<REMARK> CHANGE ERP2_cleanup *) (*<CHANGE>Version 2 - Drop some changes which are no longer needed because of syntax fixes in alpha files. This makes change ERP_cleanup_part2 unnecessary. *) (*<DESC> Add missing inverse relationships. Eliminate SELF redeclarations which were obviated by conversion from m-m relationships. Add missing verb phrases. Change the "be a property of" relationship from properties to rock_feature to be optional instead of mandatory. *) ----- Missing inverse. ALTER ENTITY ref_entity; INVERSE ADD common_activity_involvement : SET[0:?] OF common_activity_involvement FOR involved_entity (*<DESC>The common activity involvements which are constrained to this entity.*) (*<VERB>involved with*); END_ENTITY; ALTER ENTITY ref_document_spec_bus_assoc; INVERSE ADD document_spec_business_assoc : SET[0:?] OF document_spec_business_assoc FOR role (*<DESC>These are the instances which utilize the semantics of this instance.*) (*<VERB>be referenced by*); END_ENTITY; ALTER ENTITY geopolitical_feature; INVERSE ADD geopolitical_adjoining_border : SET[0:?] OF geopolitical_border FOR bordering_feature (*<DESC> These are the adjoining borders between this geopolitical feature and another. The borders are defined within the context of the other geopolitical feature.*) (*<VERB>have borders defined by*); END_ENTITY; ALTER ENTITY material_class; INVERSE ADD material_type_composition : SET[0:?] OF material_type_composition FOR component_class (*<DESC>These are the type compositions which assert that a material is composed of of a material of this type.*) (*<VERB>define the type of*); END_ENTITY; ALTER ENTITY ref_object_remark; INVERSE ADD object_remark : SET[0:?] OF object_remark FOR ref_object_remark (*<DESC>These are the instances which utilize the semantics of this instance.*) (*<VERB>be referenced by*); END_ENTITY; ALTER ENTITY pty_effective_porosity; DROP pore (*<CHANGE>Redundant to attribute rock_material.*); END_ENTITY; ALTER ENTITY pty_pore_throat_diameter; DROP pore (*<CHANGE>Redundant to attribute rock_material.*); END_ENTITY; ALTER ENTITY pty_pore_volume_compressibility; DROP pore (*<CHANGE>Redundant to attribute rock_material.*); END_ENTITY; ALTER ENTITY ref_organic_matter_florescence; INVERSE ADD pty_fluid_show_quality : SET[0:?] OF pty_fluid_show_quality FOR ref_organic_matter_florescence (*<DESC>These are the instances which utilize the semantics of this instance.*) (*<VERB>be referenced by*); END_ENTITY; ALTER ENTITY ref_location_status; INVERSE ADD pty_location : SET[0:?] OF pty_location FOR location_status (*<DESC>These are the instances which utilize the semantics of this instance.*) (*<VERB>be referenced by*); END_ENTITY; ALTER ENTITY ref_location_quality; INVERSE ADD pty_location_accuracy : SET[0:?] OF pty_location_accuracy FOR location_quality (*<DESC>These are the instances which utilize the semantics of this instance.*) (*<VERB>be referenced by*); END_ENTITY; ALTER ENTITY fluid_component; INVERSE ADD used_as_denominator : SET[0:?] OF pty_sp_fluid_component_ratio FOR reference_fluid_component (*<DESC>These are the specific fluid component ratios where this fluid component was used as a reference component.*) (*<VERB>be used as denominator in*); ADD used_as_numerator : SET[0:?] OF pty_sp_fluid_component_ratio FOR measured_fluid_component (*<DESC>These are the specific fluid component ratios where this fluid component was the measured component.*) (*<VERB>be used as numerator in*); END_ENTITY; ALTER ENTITY ref_thermal_alteration_index; INVERSE ADD pty_thermal_alteration_index : SET[0:?] OF pty_thermal_alteration_index FOR data_value (*<DESC>These are the instances which utilize the semantics of this instance.*) (*<VERB>be referenced by*); END_ENTITY; ALTER ENTITY ref_water_depth_datum; INVERSE ADD pty_water_depth : SET[0:?] OF pty_water_depth FOR ref_water_depth_datum (*<DESC>These are the instances which utilize the semantics of this instance.*) (*<VERB>be referenced by*); END_ENTITY; ALTER ENTITY seismic_pick; INVERSE ADD seismic_pick_classification : SET[0:?] OF seismic_pick_classification FOR seismic_pick (*<DESC>These are the classifications of the character in the data set.*) (*<VERB>be classified by*); END_ENTITY; ----- Redeclarations. ALTER ENTITY divestment_package; DROP SELF\BUSINESS_OBJECT.subject_of_contract; END_ENTITY; ALTER ENTITY reserves_sale_commitment; DROP SELF\BUSINESS_OBJECT.subject_of_contract; END_ENTITY; ----- verb phrase. ALTER ENTITY material_type_composition; ALTER component_class (*<VERB>be a type of*); END_ENTITY; ALTER ENTITY pty_specific_fluid_component_ratio; ALTER measured_fluid_component (*<VERB>use as the measured component*); ALTER reference_fluid_component (*<VERB>use as the reference component*); END_ENTITY; ALTER ENTITY pty_water_depth; ALTER ref_water_depth_datum (*<VERB>have datum described by*); END_ENTITY; ALTER ENTITY business_associate; INVERSE ALTER document_specification_role (*<VERB>have*); END_ENTITY; ALTER ENTITY document_spec_business_assoc; ALTER document_specification (*<VERB>be defined for*); ALTER business_associate (*<VERB>be defined within*); ALTER role (*<VERB>have the role of*); END_ENTITY; ALTER ENTITY document_specification; INVERSE ALTER business_associate_role (*<VERB>have*); END_ENTITY; ALTER ENTITY business_object; INVERSE ALTER object_remark (*<VERB>be described by*); END_ENTITY; ALTER ENTITY object_remark; ALTER business_object (*<VERB>be a remark for*); ALTER text AS SELF\e_and_p_data.description ; ALTER ref_object_remark (*<VERB>be a type of*); END_ENTITY; ALTER ENTITY surface_cable; INVERSE ALTER pty_length (*<VERB>have a property of*); END_ENTITY; ALTER ENTITY object_of_interest; INVERSE ALTER derived_interest (*<VERB>have interest defined by*); END_ENTITY; ALTER ENTITY recombined_fluid_sample; INVERSE ALTER created_from (*<VERB>be created from*); END_ENTITY; ALTER ENTITY fluid_sample; ALTER combined_to_create (*<VERB>be combined to create*); END_ENTITY; ALTER ENTITY fluid_system; INVERSE ALTER pty_transient_pressure (*<VERB>have a property of*); END_ENTITY; ALTER ENTITY pty_transient_pressure; ALTER fluid_system (*<VERB>be a property of*); END_ENTITY; ALTER ENTITY object_of_interest; INVERSE ALTER derived_interest (*<VERB>be referenced by*); END_ENTITY; ALTER ENTITY pty_geometry_2d_gis; ALTER coordinate_system (*<DESC>This is the coordinate system of the coordinate values defined in attribute data value.*) (*<VERB>define values in*); END_ENTITY; ALTER ENTITY surface_cable; INVERSE ALTER pty_length (*<VERB>have a property of*); END_ENTITY; ALTER ENTITY pty_length; ALTER surface_cable (*<VERB>be a property of*); INVERSE END_ENTITY; ALTER ENTITY pty_location; ALTER location_status (*<VERB>have a status of*); END_ENTITY; ALTER ENTITY pty_productivity_index; ALTER wellbore_point (*<VERB>be a property of*); END_ENTITY; ALTER ENTITY pty_thermal_alteration_index; ALTER data_value (*<VERB>have an index of*); END_ENTITY; ALTER ENTITY rock_feature_material; ALTER rock_feature (*<VERB>be part of*); ALTER rock_material (*<VERB>be composed of*); END_ENTITY; ALTER ENTITY rock_fluid_feature_material; ALTER rock_fluid_feature (*<VERB>be part of*); ALTER rock_material (*<VERB>be composed of*); END_ENTITY; ALTER ENTITY pty_wellbore_curvature; ALTER wellbore_point (*<VERB>be a property of*); ALTER wellbore_interval (*<VERB>be a property of*); END_ENTITY; ALTER ENTITY wellbore_point; INVERSE ALTER pty_wellbore_curvature (*<VERB>have a property of*); END_ENTITY; ALTER ENTITY wellbore_interval; INVERSE ALTER pty_wellbore_curvature (*<VERB>have a property of*); END_ENTITY; ---- optinality ALTER ENTITY pty_absolute_abundance; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_concentration_volume_per_mole; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_concentration_mass_per_mass; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_concentration_mass_per_volume; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_concentration_volume_per_volume; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_concentration_mole_per_volume; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_mass; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_weight; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_poissons_ratio; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_effective_porosity; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_effective_permeability; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_conductance; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_bending_moment_per_length; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_volume; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_electrical_resistance; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_specific_internal_surface_area; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_pyrolysis_oxygen_index; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_bulk_density; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_electric_potential; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_mass_spectrum_abundance; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_wettability_index; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_acoustic_impedance; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_torque; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_spectral_fluorescence_intensity; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_resistivity_index_curve; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_pore_throat_diameter; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_grain_size; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_geologic_age; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_pore_volume_compressibility; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_temperature; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_acoustic_velocity; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_pyrolysis_s1; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_pyrolysis_s0; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_pyrolysis_s3; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_pyrolysis_s2; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_porosity_compaction_point; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_permeability_compaction_point; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_thermal_alteration_index; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_total_organic_matter; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_heat_transfer_coefficient; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_total_organic_carbon; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_cementation_factor; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_permeability_compaction_curve; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_tortuosity; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_interval_transit_time; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_porosity; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_specific_heat_capacity_mass; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_heat_flux; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_transient_temperature; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_mineral_hardness; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_youngs_modulus ; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_permeability_vertical; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_internal_surface_area; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_formation_resistivity_factor; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_resistivity_index ; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_pore_pressure ; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_total_compressibility; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_capacitance; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_lithologic_color; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_area; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_spatial_gamma_radiation_intensity; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_geologic_age_range; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_bulk_modulus; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_surface_area_per_volume; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_pyrolysis_t_max; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_matrix_compressibility; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_linear_thermal_expansion; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_matrix_density; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_formation_factor_curve; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_pyrolysis_hydrogen_index; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_cation_exchange_capacity; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_electric_resistivity; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_density_solid; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_permeability ; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_spectral_gamma_radiation_intensity; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_biot_coefficient; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_compressibility_curve; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_radioactivity; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_acoustic_velocity_curve; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_permeability_horizontal; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_porosity_compaction_curve; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_heat_release_rate; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_overburden_pressure; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_vert_hor_permeability_ratio; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_refractive_index; ALTER rock_feature ADD OPTIONAL; END_ENTITY; ALTER ENTITY pty_shear_modulus; ALTER rock_feature ADD OPTIONAL; END_ENTITY; END_CHANGE;