POSC Specifications: Epicentre Version 3.0 | Logical Data Model |
Since Catalog_equipment is non-abstract (and has an SI rule), we need to either eliminate its subtypes or we need to eliminate the SI rule from the subtypes. This change deletes them.
CHANGE ERP_catalog_equipment_subtypes DROP ENTITY catalog_anchor; DROP ENTITY catalog_compressor; DROP ENTITY catalog_control_device; DROP ENTITY catalog_core_bit; DROP ENTITY catalog_directional_survey_tool; DROP ENTITY catalog_drill_bit; DROP ENTITY catalog_drill_collar; DROP ENTITY catalog_drill_pipe; DROP ENTITY catalog_electric_generator; DROP ENTITY catalog_fluid_viscometer; DROP ENTITY catalog_motor; DROP ENTITY catalog_nozzle; DROP ENTITY catalog_position_sensor; DROP ENTITY catalog_pressure_vessel; DROP ENTITY catalog_pump; DROP ENTITY catalog_pump_liner; DROP ENTITY catalog_rotary_shouldered_connection; DROP ENTITY catalog_separator; DROP ENTITY catalog_solids_control_equipment; DROP ENTITY catalog_stabilizer; DROP ENTITY catalog_tank; DROP ENTITY catalog_transformer; DROP ENTITY catalog_tubing; DROP ENTITY catalog_tubular_coupling; DROP ENTITY catalog_underreamer; DROP ENTITY catalog_wellhead; END_CHANGE;