POSC Specifications: Epicentre Version 3.0 | Logical Data Model |
The changes to the material model have greatly reduced the significance of "typical" materials. The primary semantics that they might now provide will be any required "point" behavior as opposed to the "range" behavior available to classes. Delete all subtypes of typical material and move the semantics to material class. The new "specialization" capability in class classification will allow, for example, the class "isotype" to be the generalization of the class "C12". That is, classes will need to be created to represent the existing subtypes of typical.
CHANGE ERP_typical_material_subtypes ALTER ENTITY typical_material DROP ABSTRACT; UNIQUE ADD si : identifier; END_ENTITY; DROP ENTITY isotope_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY chemical_element_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY chemical_product_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY fossil_taxon (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY hydrocarbon_mass_fraction (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY lithology_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY mineral_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY molecule_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY solid_organic_matter_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY cement_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY oil_based_mud_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY water_based_mud_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY metallic_compound_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY chemical_compound_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY solid_additive_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY gravel_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY standard_fluid_system (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY solids_free_fluid_type (*<CHANGE>Moved to be an instance of Material_class.*); DROP ENTITY ref_taxonomic_class (*<CHANGE>Move to instances of Material_class.*); ALTER ENTITY pty_equipment_facility; ALTER catalog_equipment AS typical_material ALTER TYPE AS typical_material; END_ENTITY; ALTER ENTITY typical_material; INVERSE ADD pty_equipment_facility : SET[0:?] OF pty_equipment_facility FOR typical_material (*<VERB>have a property of*) (*<CHANGE>Moved from Catalog_equipment.*); END_ENTITY; ADD ENTITY common_facility_material_property SUBTYPE OF (aliasable_technical_reference); (*<DESC>An association which declares a type of property which is commonly associated with a class.*) (*<POPULATION>OPEN*) facility_material_class : facility_material_class (*<DESC>The class whose members may commonly have the property.*) (*<VERB>be associated with*); property_kind : ref_property_kind (*<DESC>The type of property which is commonly associated with the class.*) (*<VERB>commonly have*); UNIQUE si : facility_material_class, property_kind; END_ENTITY; ALTER ENTITY facility_material_class (*<REMARK> Added in another change.*); INVERSE ADD common_properties : SET[0:?] OF common_facility_material_property FOR facility_material_class (*<DESC>The set of property kinds which objects conforming to this class can commonly be expected to have.*) (*<VERB>commonly have*); END_ENTITY; ALTER ENTITY ref_property_kind; INVERSE ADD common_facility_material_property : SET[0:?] OF common_facility_material_property FOR property_kind (*<DESC>The set of associations which assert that this kind of property is commonly associated with members of a class.*) (*<VERB>be common to*); END_ENTITY; ALTER ENTITY land_property_volume; ALTER mineral_type ALTER TYPE AS material_class; END_ENTITY; ALTER ENTITY temporal_period; DROP fossil_taxon (*<CHANGE>This other end of this relationship has been moved to be from Material_class to Geologic_age_classification.*); END_ENTITY; ALTER ENTITY material_class; INVERSE ADD geologic_age_classification : SET[0:?] OF geologic_age_classification for material_class (*<DESC>Indicates the classification of this class as dating to a specified time period*) (*<VERB>be classified by*) (*<CHANGE>Replaces Fossil_taxon.temporal_period.*); END_ENTITY; ALTER ENTITY geologic_age_classification; ADD material_class : OPTIONAL material_class (*<DESC>This is the material class which is being assigned a geologic age.*) (*<VERB>classify*) (*<CHANGE>Replaces Temporal_period.fossil_taxon.*); UNIQUE ALTER si ADD material_class FIRST; WHERE ADD mse : EXISTS(geologic_feature) XOR ( EXISTS(material_class) XOR ( EXISTS(reservoir_fluid_system) XOR exists(rock_material) )) (*<DESC>Each instance must specify either GEOLOGIC_FEATURE, MATERIAL_CLASS, RESERVOIR FLUID SYSTEM or ROCK MATERIAL.*) (*<CHANGE>This is a FIX to clarify the intended use of the entity.*) (*<RULETYPE>MSE*); END_ENTITY; ALTER ENTITY pty_electrical_stability; DROP oil_based_mud_type; UNIQUE ALTER si DROP oil_based_mud_type; END_ENTITY; ALTER ENTITY pty_methylene_blue_capacity; DROP water_based_mud_type; UNIQUE ALTER si DROP water_based_mud_type; END_ENTITY; ALTER ENTITY pty_tensile_strength; DROP chemical_compound_type; UNIQUE ALTER si DROP chemical_compound_type; END_ENTITY; ALTER ENTITY pty_polarized_light_rotation_angle; DROP chemical_compound_type; UNIQUE ALTER si DROP chemical_compound_type; END_ENTITY; ALTER ENTITY pty_thermal_conductivity; DROP solid_additive_type; UNIQUE ALTER si DROP solid_additive_type; END_ENTITY; ALTER ENTITY pty_density_solid; DROP solid_additive_type; UNIQUE ALTER si DROP solid_additive_type; END_ENTITY; ALTER ENTITY pty_redox_potential; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_calorific_value_mass_basis; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_critical_z_factor; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_volumetric_thermal_expansion; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_cloud_point_temperature; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_pour_temperature; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_spectral_fluorescence_intensity; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_crude_oil_characterization_factor; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_molecular_weight; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_boiling_temperature; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_critical_density; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_usbm_crude_oil_base_classification; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_critical_pressure; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_interval_transit_time; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_acentric_factor; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_specific_heat_capacity_mass; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_equation_of_state_omega_b; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_equation_of_state_omega_a; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_calorific_value_gas_volume; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_parachor; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_calorific_value_mole_basis; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_watson_characterization_factor; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_vapor_pressure ; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_critical_temperature; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_density_molar; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_ph; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_melting_temperature; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_usbm_crude_oil_correlation_index; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_calorific_value_solid_liquid_volume; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_liquid_gravity; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_critical_volume; DROP standard_fluid_system; UNIQUE ALTER si DROP standard_fluid_system; END_ENTITY; ALTER ENTITY pty_volume; DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_volume_curve; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_bulk_volume_total; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_matrix_volume; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_hydrocarbon_pore_volume; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_bulk_volume_fraction; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_pore_volume; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_mass_per_length; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_grain_size; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_geologic_age; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_area_per_mass; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_conodont_color; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_temperature; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_plane_angle; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_spore_color; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_length_per_volume; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_area; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_geologic_age_range; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_surface_area_per_volume; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_mass; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_length; DROP fossil_taxon; UNIQUE ALTER si DROP fossil_taxon; END_ENTITY; ALTER ENTITY pty_effective_porosity; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_x_ray_intensity; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_calorific_value_mass_basis; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_bulk_density; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_grain_size; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_magnetic_field_strength; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_total_organic_matter; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_total_organic_carbon; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_cementation_factor; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_interval_transit_time; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_heat_flux; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_youngs_modulus; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_formation_resistivity_factor; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_total_compressibility; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_capacitance; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_lithologic_color; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_calorific_value_mole_basis; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_bulk_modulus; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_matrix_compressibility; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_linear_thermal_expansion; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_matrix_density; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_tensile_strength; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_cation_exchange_capacity; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_density_solid; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_spectral_gamma_radiation_intensity; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_plastic_viscosity; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_biot_coefficient; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_radioactivity; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_magnetic_force; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_conductivity; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_shear_modulus; DROP lithology_type; UNIQUE ALTER si DROP lithology_type; END_ENTITY; ALTER ENTITY pty_x_ray_intensity; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_electrical_resistance; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_bulk_density; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_electric_charge; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_thermal_resistance; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_magnetic_dipole_moment; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_acoustic_impedance; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_seismic_velocity; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_geologic_age; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_magnetic_field_strength; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_thermal_conductivity; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_electric_dipole_moment; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_mass_per_area; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_heat_flux; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_electric_impedance; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_mineral_hardness; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_capacitance; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_lithologic_color; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_electric_polarization; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_solubility_product; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_fluid_contact_angle; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_linear_thermal_expansion; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_tensile_strength; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_density_solid; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_polarized_light_rotation_angle; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_radioactivity; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_magnetic_force; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_refractive_index; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_shear_modulus; DROP mineral_type; UNIQUE ALTER si DROP mineral_type; END_ENTITY; ALTER ENTITY pty_redox_potential; DROP molecule_type; UNIQUE ALTER si DROP molecule_type; END_ENTITY; ALTER ENTITY pty_molecular_weight; DROP molecule_type; UNIQUE ALTER si DROP molecule_type; END_ENTITY; ALTER ENTITY pty_solubility_product; DROP molecule_type; UNIQUE ALTER si DROP molecule_type; END_ENTITY; ALTER ENTITY pty_vitrinite_reflectance; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_pyrolysis_oxygen_index; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_radiant_flux; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_pyrolysis_s1; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_pyrolysis_s0; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_pyrolysis_s3; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_pyrolysis_s2; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_thermal_alteration_index; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_total_organic_matter; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_spore_color; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_total_organic_carbon; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_luminous_intensity; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_lithologic_color; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_melting_temperature; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; ALTER ENTITY pty_pyrolysis_hydrogen_index; DROP solid_organic_matter_type; UNIQUE ALTER si DROP solid_organic_matter_type; END_ENTITY; END_CHANGE;