The abstract supertype of all materials which can be split into various amounts without changing its fundamental nature.
instance_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
identifier (M: CHAR VARYING(80))
material.identifier
The unique name of the material.
instance_create_date (O: TIMESTAMP)
e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
last_updated (O: TIMESTAMP)
e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
r_existence_kind (FNK, M: CHAR VARYING(80))
material.ref_existence_kind
The existence kind of the material e.g. actual, planned, required, or predicted.
Defines a foreign key to table r_existence_kind.
subsurface_rock_segment.base_missing_section
This describes the length of the expected subsurface rock segment that was not encountered at the base of subsurface rock segment. base_missing_section_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
description (O: CHAR VARYING(2000))
e_and_p_data.description
A remark or comment about the instance.
instance_creator (O: CHAR VARYING(80))
e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
last_updated_by (O: CHAR VARYING(80))
e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
occurrence_number (O: INTEGER)
subsurface_rock_segment.occurrence_number
This defines the order of occurrence - in increasing measured depth - for a subsurface rock segment.
quality (O: CHAR VARYING(2000))
rock_thin_section.quality
A textual comment on the suitability of the sample for descriptive or analytical purposes.
rock_thin_section.sample_thickness
The nominal thickness of the wafer of rock mounted on the glass slide. Thicknesses are typically in the range of 20-100 micrometers. sample_thickness_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
source (O: CHAR VARYING(80))
e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
well_test_open_period_recovery.time_to_surface
The time from the initiation of the well test open period for the fluid recovered to reach the surface. time_to_surface_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
subsurface_rock_segment.top_missing_section
This describes the length of the expected subsurface rock segment that was not encountered at the top of subsurface rock segment. top_missing_section_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
combined_to_create_s (FSK, O: CHAR VARYING(19))
fluid_sample.combined_to_create
This designates the resulting, recombined fluid sample that is created when this sample is combined with other fluid samples.
Defines a foreign key to table bulk_material.
drillstring_s (FSK, O: CHAR VARYING(19))
drilling_kick_fluid.drillstring
This describes the drillstring taking fluid from the drilling kick.
Defines a foreign key to table wellbore_tubular.
local_rock_feature.earth_feature
This is the earth_feature that locates this local_rock_feature and can provide part of the identity of this local_rock_feature. For example, for the Viking Graben in the Gullfaks area, Gullfaks is the earth_feature that provides part of the identification. earth_feature_s: Implements a foreign key to a row in one of the tables projected from entity earth_feature depending on the value of the next column (See below). earth_feature_t: Defines the name of the referenced table. Possible values are defined in @earth_feature.
well_test_recovery.fluid_component
This is the fluid component for which this well test recovery is defined. fluid_component_s: Implements a foreign key to a row in one of the tables projected from entity fluid_component depending on the value of the next column (See below). fluid_component_t: Defines the name of the referenced table. Possible values are: bulk_material, r_generic_fluid_component (@fluid_component).
fluid_system_s (FSK, O: CHAR VARYING(19))
fluid_sample.fluid_system
This is the fluid system from which this fluid sample is extracted.
Defines a foreign key to table bulk_material.
kind_s (FSK, O: CHAR VARYING(19))
material.kind
The class which asserts the fundamental nature of the material.
Defines a foreign key to table material_class.
naming_system (FNK, O: CHAR VARYING(80))
material.naming_system
The naming system in which the identifier is specified and determined to be unique.
Defines a foreign key to table naming_system.
core.ref_diameter
The diameter of the cylindrical shape of a core sample. This value is typically derived from the size of core bit used in cutting the sample.
Defines a foreign key to table r_diameter.
rock_material_s (FSK, O: CHAR VARYING(19))
rock_material.rock_material
This is the rock material of which this is a part.
Defines a foreign key to table bulk_material.
wellbore_s (FSK, O: CHAR VARYING(19))
core.wellbore
This is the wellbore from which this core was extracted. drill_cuttings_sample.wellbore
This is the wellbore from which these cuttings were extracted. filter_cake.wellbore
This is the wellbore within whose context this filter cake was extracted. For example, this would be the wellbore which was being circulated at the time that fluids were taken from the mud pit. subsurface_rock_segment.wellbore
Specifies the wellbore through which the material is drilled.
Defines a foreign key to table wellbore.
well_test_recovery_s (FSK, O: CHAR VARYING(19))
filter_cake.well_test_recovery
This designates the well test recovery from which this sample was extracted
Defines a foreign key to table bulk_material.