A rock sample collected from a surface location, such as an outcrop.

outcrop_sample_s (PK, M: CHAR VARYING(19))

Surrogate key of the table.


r_existence_kd_nm (FNK, M: CHAR VARYING(40))

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_kd.


description (O: CHAR VARYING(2000))

material.description
A textual description of the material.


inventory_obj_id (O: CHAR VARYING(40))

inventory_object.identifier
An alphanumeric string such as a label or serial number, which acts to identify the object.


produced_by_act_s (FSK, O: CHAR VARYING(19))
produced_by_act_t (O: CHAR VARYING(16))

material_sample.produced_by_activity
Specifies the activity which acquired the sample.
produced_by_act_s: Implements a foreign key to a row in one of the tables projected from entity sample_acquisition depending on the value of the next column (See below).
produced_by_act_t: Defines the name of the referenced table. Possible values are: fluid_sam_acq, rock_sample_acq (@sample_acquisition).


r_naming_system_kd (FNK, O: CHAR VARYING(40))

inventory_object.ref_naming_system
The naming system in which the identifier is defined and unique.
Defines a foreign key to table r_naming_system.


rock_material_s (FSK, O: CHAR VARYING(19))
rock_material_t (O: CHAR VARYING(16))

rock_feature_part.rock_material
This is the rock material of which this is a part.
rock_material_s: Implements a foreign key to a row in one of the tables projected from entity rock_material depending on the value of the next column (See below).
rock_material_t: Defines the name of the referenced table. Possible values are defined in @rock_material.


source_activity_s (FSK, O: CHAR VARYING(19))
source_activity_t (O: CHAR VARYING(16))

material_sample.source_activity
Specifies the activity which produced this sample.
source_activity_s: Implements a foreign key to a row in one of the tables projected from entity materials_processing depending on the value of the next column (See below).
source_activity_t: Defines the name of the referenced table. Possible values are: fluid_proc, rock_processing (@materials_processing).


wtst_recovery_s (FSK, O: CHAR VARYING(19))
wtst_recovery_t (O: CHAR VARYING(16))

material_sample.well_test_recovery
This designates the well test recovery from which this sample was extracted.
wtst_recovery_s: Implements a foreign key to a row in one of the tables projected from entity well_test_recovery depending on the value of the next column (See below).
wtst_recovery_t: Defines the name of the referenced table. Possible values are: dst_recovery, wrln_ftst_recv, wtst_oppd_recv (@well_test_recovery).