POSC Specifications: Epicentre Version 3.0 | Logical Data Model |
This applies miscellaneous cleanup changes to the beta version. Move relationship from the subtypes of pty_azimuth up to pty_azimuth so that the relationship can participate in the uniqueness. Make data_value mandatory in properties when that is the only attibute. Add the description back to ndt_acceleration_linear. Drop ref_element_kind since it is redundant to the new ndt_element_type. Add missing rule types. Drop unused NDTs.
CHANGE ERP3_cleanup (*<REMARK> CHANGE ERP3_cleanup *) (*<CHANGE> Version2 - Eliminate some changes which are no longer needed because of syntax fixes in alpha files.*) (*<DESC> This applies miscellaneous cleanup changes to the beta version. Move relationship from the subtypes of pty_azimuth up to pty_azimuth so that the relationship can participate in the uniqueness. Make data_value mandatory in properties when that is the only attibute. Add the description back to ndt_acceleration_linear. Drop ref_element_kind since it is redundant to the new ndt_element_type. Add missing rule types. Drop unused NDTs. *) ----- Rename attribute which is an ORACLE reserved word. ALTER ENTITY transient_association; ALTER current AS is_current; END_ENTITY; ----- fix rules ALTER ENTITY potential_field_geometry_set; WHERE ALTER val2: (EXISTS(measurement_seismic_station) AND EXISTS(uid_definition)) OR (NOT (EXISTS(measurement_seismic_station) OR EXISTS(uid_definition))) (*<DESC>For each instance, if either UID DEFINITION or MEASUREMENT SEISMIC STATION is defined then both must be defined.*) (*<CHANGE>The wrong attribute name was used.*); END_ENTITY; ALTER ENTITY material_composition; WHERE ALTER val2: (NOT EXISTS(sequence)) OR (composition_type.identifier = 'linear assembly') (*<CHANGE>Remove underscore from value.*); END_ENTITY; ----- drop duplicate si rules. ALTER ENTITY property_kind; UNIQUE DROP si (*<CHANGE> The same rule was specified two times. *); END_ENTITY; ----- fix description. ALTER ENTITY material_storage (*<DESC> The transient association that documents the storage of an object, such as equipment, in a general facility. *); END_ENTITY; ----- fix property version. ALTER ENTITY pty_directional_mobility; UNIQUE ALTER si ADD activity LAST; END_ENTITY; ----- fix si rule ALTER ENTITY pty_strike; DROP fracture; END_ENTITY; ALTER ENTITY pty_dip_azimuth; DROP fracture; END_ENTITY; ALTER ENTITY pty_azimuth; ADD fracture : OPTIONAL fracture (*<VERB>be a property of*); UNIQUE ALTER si ADD fracture LAST; END_ENTITY; ALTER ENTITY fracture; INVERSE DROP pty_strike; ALTER pty_dip_azimuth AS pty_azimuth ALTER TYPE AS pty_azimuth; END_ENTITY; ALTER ENTITY coordinate_transformation; UNIQUE DROP si (*<CHANGE>Use the SI rule in the subtypes.*); END_ENTITY; ALTER ENTITY regulation_clause_amendment; UNIQUE DROP si (*<CHANGE>Redundant to the SI rule in the supertype.*); END_ENTITY; ALTER ENTITY pty_generic_element; UNIQUE DROP si (*<CHANGE>Redundant to the SI rule in the supertype.*); END_ENTITY; ----- optional data value ALTER ENTITY pty_avg_earth_surface_elev; ALTER data_value DROP OPTIONAL; END_ENTITY; ALTER ENTITY pty_descriptive_text; ALTER data_value DROP OPTIONAL; END_ENTITY; ALTER ENTITY pty_elevation_difference; ALTER data_value DROP OPTIONAL; END_ENTITY; ALTER ENTITY pty_general_weather_desc; ALTER data_value DROP OPTIONAL; END_ENTITY; ALTER ENTITY pty_pressure_gradient; ALTER data_value DROP OPTIONAL; END_ENTITY; ----- missing description. ALTER TYPE ndt_acceleration_linear (*<DESC> This defines the domain for acceleration linear.*); END_TYPE; ----- redundant ref entity. ALTER ENTITY grid_modification; ALTER ref_element_kind AS element_kind ALTER TYPE AS ndt_element_type; END_ENTITY; DROP ENTITY ref_element_kind (*<CHANGE>Redundant to ndt_element_type.*); ------- bad name ALTER ENTITY leaseable_earth_feature; ALTER apty_geothermal_gradient AS pty_geothermal_gradient; END_ENTITY; ------- add misssing rule types ALTER ENTITY common_activity_involvement; WHERE ALTER val (*<RULETYPE>val*); END_ENTITY; ALTER ENTITY composite_spatial_object; WHERE ALTER val (*<RULETYPE>val*); END_ENTITY; ALTER ENTITY concatenated_transformation; WHERE ALTER dri (*<RULETYPE>dri*); END_ENTITY; ALTER ENTITY face; WHERE ALTER val (*<RULETYPE>val*); END_ENTITY; ALTER ENTITY field; WHERE ALTER val1 (*<RULETYPE>val*); END_ENTITY; ALTER ENTITY fluid_flow_stream_contaminant; WHERE ALTER mse (*<RULETYPE>mse*); END_ENTITY; ALTER ENTITY geodetic_transformation; WHERE ALTER dri (*<RULETYPE>dri*); END_ENTITY; ALTER ENTITY ref_postal_code; WHERE ALTER val1 (*<RULETYPE>val*); END_ENTITY; ------------------------------ (*<CHANGE> Make the documentation match the the name of attributes Geophysical_facility.facility_uid and Geophysical_geometry_set.utilized_facility.*) ALTER ENTITY potential_field_geometry_set; ALTER measurement_sensor_facility (*<DESC>Captures the sensor facility used for each measurement by specifying a "user unique identifier" value at each node of the grid defined by attribute measurement uid. The grid used must match the grid defined by attribute measurement uid. Each "user unique identifier" value must match the value of attribute facility uid in one of the sensor facilities referenced in attribute utilized facility. This enables the use of different or multiple sensors within the acquisition of a geometry set.*); END_ENTITY; ALTER ENTITY seismic_geometry_set; ALTER channel_facility (*<DESC>Defines the sensor (i.e., receiver, uphole sensor, etc.) connected to each channel by specifying a "seismic facility uid" value at each node of the grid defined by channel uid. This asserts that the channel to receiver association was not transient (e.g., marine). The grid used must match the grid defined by channel uid. Each "seismic facility uid" value must match the value of attribute facility uid in one of the facilities referenced in utilized facility.*); ALTER channel_seismograph (*<DESC>Defines the seismograph associated with each channel by specifying a "seismic facility uid" value at each node of the grid defined by channel uid. The grid used must match the grid used by channel uid. Each "seismic facility uid" value must match the value of attribute facility uid in one of the facilities referenced in utilized facility.*); ALTER receiver_facility (*<DESC>Defines the receiver facility representing each receiver by specifying a "seismic facility uid" at each node of the grid defined by receiver uid. This asserts that fixed cable multi-component recording occurred. For fixed cable single component recording the facility can be defined by the relationship to typical seismic receiver. The grid used must match the grid defined by receiver uid. Each "seismic facility uid" value must match the value of attribute facility uid in one of the facilities referenced in utilized facility.*); ALTER source_facility (*<DESC>Defines the source facility activated by each source event by specifying a "seismic facility uid" value at each node of the grid defined by source event uid. The grid used must match the grid used by source event uid. Each "seismic facility uid" value must match the value of attribute facility uid in one of the facilities referenced in utilized facility.*); WHERE ALTER val11 : EXISTS(utilized_facility) OR (NOT (EXISTS(utilized_facility) OR (EXISTS(channel_facility) OR (EXISTS(channel_seismograph) OR (EXISTS(receiver_facility) OR EXISTS(source_facility)))))) (*<DESC>For each instance, UTILIZED FACILITY must be defined if any of the following are defined: CHANNEL FACILITY, CHANNEL SEISMOGRAPH, RECEIVER FACILITY, SOURCE FACILITY.*); END_ENTITY; (*<CHANGE> Drop unused Named Defined Types. *) DROP TYPE ndt_cum_tank_vol_with_height (*<CHANGE> Not used. *); DROP TYPE ndt_density_molar (*<CHANGE> Not used. *); DROP TYPE ndt_dry_gas_fvf_curve (*<CHANGE> Not used. *); DROP TYPE ndt_dry_gas_fvf_point (*<CHANGE> Not used. *); DROP TYPE ndt_dry_gas_pressure_curve (*<CHANGE> Not used. *); DROP TYPE ndt_dry_gas_pressure_point (*<CHANGE> Not used. *); DROP TYPE ndt_dry_gas_viscosity_curve (*<CHANGE> Not used. *); DROP TYPE ndt_dry_gas_viscosity_point (*<CHANGE> Not used. *); DROP TYPE ndt_dry_gas_z_factor_curve (*<CHANGE> Not used. *); DROP TYPE ndt_dry_gas_z_factor_point (*<CHANGE> Not used. *); DROP TYPE ndt_flow_rate_per_area_mole_basis (*<CHANGE> Not used. *); DROP TYPE ndt_geoidal_undulation (*<CHANGE> Not used. *); DROP TYPE ndt_gor_curve (*<CHANGE> Not used. *); DROP TYPE ndt_magnetic_flux_density (*<CHANGE> Not used. *); DROP TYPE ndt_measured_depth (*<CHANGE> Not used. *); DROP TYPE ndt_saturated_liquid_density_curve (*<CHANGE> Not used. *); DROP TYPE ndt_saturated_liquid_density_point (*<CHANGE> Not used. *); DROP TYPE ndt_saturated_viscosity_curve (*<CHANGE> Not used. *); DROP TYPE ndt_saturated_viscosity_point (*<CHANGE> Not used. *); DROP TYPE ndt_undersaturated_compressibility_curve (*<CHANGE> Not used. *); DROP TYPE ndt_undersaturated_compressibility_point (*<CHANGE> Not used. *); DROP TYPE ndt_undersaturated_fvf_curve (*<CHANGE> Not used. *); DROP TYPE ndt_undersaturated_fvf_point (*<CHANGE> Not used. *); DROP TYPE ndt_undersaturated_viscosity_curve (*<CHANGE> Not used. *); DROP TYPE ndt_wet_gas_density_curve (*<CHANGE> Not used. *); DROP TYPE ndt_wet_gas_density_point (*<CHANGE> Not used. *); DROP TYPE ndt_wet_gas_pressure_curve (*<CHANGE> Not used. *); DROP TYPE ndt_wet_gas_pressure_point (*<CHANGE> Not used. *); DROP TYPE ndt_wet_gas_z_factor_curve (*<CHANGE> Not used. *); DROP TYPE ndt_yearmonthinterval (*<CHANGE> Not used. *); END_CHANGE;