POSC Specifications: Epicentre Version 3.0 | Logical Data Model |
Eliminate Material_sample.
CHANGE ERP_material_sample DROP ENTITY material_sample (*<CHANGE>Behavior replicated into former subtypes (where appropriate).*); ALTER ENTITY rock_sample; ADD produced_by_activity : OPTIONAL sample_acquisition (*<DESC>Specifies the activity which acquired the sample.*) (*<VERB>be produced by*); ADD source_activity : OPTIONAL materials_processing (*<DESC>Specifies the activity which produced this sample.*) (*<VERB>be produced by*); (*<REMARK>Well_test_recovery was not considered appropriate.*) WHERE ADD ose : NOT (EXISTS(produced_by_activity) AND EXISTS(source_activity)) (*<DESC>A Rock_sample may be produced by one of produced_by_activity or source_activity.*); END_ENTITY; ALTER ENTITY filter_cake; ADD produced_by_activity : OPTIONAL sample_acquisition (*<DESC>Specifies the activity which acquired the sample.*) (*<VERB>be produced by*); ADD source_activity : OPTIONAL materials_processing (*<DESC>Specifies the activity which produced this sample.*) (*<VERB>be produced by*); ADD well_test_recovery : OPTIONAL well_test_recovery (*<DESC>This designates the well test recovery from which this sample was extracted*) (*<VERB>be extracted from*); WHERE ADD ose : NOT (EXISTS(produced_by_activity) AND EXISTS(source_activity)) (*<DESC>A Filter_cake may be produced by one of produced_by_activity or source_activity.*); END_ENTITY; ALTER ENTITY fluid_sample; ADD produced_by_activity : OPTIONAL sample_acquisition (*<DESC>Specifies the activity which acquired the sample.*) (*<VERB>be produced by*); ADD source_activity : OPTIONAL materials_processing (*<DESC>Specifies the activity which produced this sample.*) (*<VERB>be produced by*); ADD well_test_recovery : OPTIONAL well_test_recovery (*<DESC>This designates the well test recovery from which this sample was extracted*) (*<VERB>be extracted from*); WHERE ADD ose : NOT (EXISTS(produced_by_activity) AND EXISTS(source_activity)) (*<DESC>A Fluid_sample may be produced by one of produced_by_activity or source_activity.*); END_ENTITY; ALTER ENTITY sample_acquisition; INVERSE ALTER produced_sample AS produced_fluid_sample ALTER TYPE AS fluid_sample (*<DESC>Indicates various fluid samples produced by this activity.*); ADD produced_filter_cake : SET [0:?] OF filter_cake FOR produced_by_activity (*<DESC>Indicates various filter cakes produced by this activity.*) (*<VERB>produced*); ADD produced_rock_sample : SET [0:?] OF rock_sample FOR produced_by_activity (*<DESC>Indicates various rock samples produced by this activity.*) (*<VERB>produced*); END_ENTITY; ALTER ENTITY materials_processing; INVERSE ALTER produced_sample AS produced_fluid_sample ALTER TYPE AS fluid_sample (*<DESC>Indicates various fluid samples produced by this activity.*); ADD produced_filter_cake : SET [0:?] OF filter_cake FOR source_activity (*<DESC>Indicates various filter cakes produced by this activity.*) (*<VERB>produced*); ADD produced_rock_sample : SET [0:?] OF rock_sample FOR source_activity (*<DESC>Indicates various rock samples produced by this activity.*) (*<VERB>produced*); END_ENTITY; ALTER ENTITY well_test_recovery; INVERSE ALTER material_sample AS extracted_fluid_sample ALTER TYPE AS fluid_sample (*<DESC>These are the fluid samples extracted from this well test recovery.*); ADD extracted_filter_cake : SET [0:?] OF filter_cake FOR well_test_recovery (*<DESC>These are the filter cakes extracted from this well test recovery.*) (*<VERB>be the source of*); END_ENTITY; END_CHANGE;