This is a descriptive text that is versionable for the object it describes, that is, several different opinions about an object can be recorded, together with information about the activities that lead to the forming of these opinions, and the geoscientist/engineer concerned.

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

Surrogate key of the table.


data_value (O: CHAR VARYING(2000))

pty_descriptive_text.data_value
This contains the text that is the value in the versionable property.


preferred_flag (O: CHAR(1))

property.preferred_flag
The flag is set to True if this instance of property is the preferred value in this data store of this type of property for the object which this property describes.


activity_s (FSK, O: CHAR VARYING(19))
activity_t (O: CHAR VARYING(16))

process_data.activity
Defines the activity which created this instance.
activity_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
activity_t: Defines the name of the referenced table. Possible values are defined in @activity.


kind_s (FSK, O: CHAR VARYING(19))

pty_descriptive_text.kind
This give the kind of descriptive property this is, by pointing to the reference entity ref_descriptive_property.
Defines a foreign key to table r_dsc_pty.


material_sample_s (FSK, O: CHAR VARYING(19))
material_sample_t (O: CHAR VARYING(16))

pty_descriptive_text.material_sample
Where the descriptive text is describing a material_sample, this points to the instance of material_sample being described.
material_sample_s: Implements a foreign key to a row in one of the tables projected from entity material_sample depending on the value of the next column (See below).
material_sample_t: Defines the name of the referenced table. Possible values are defined in @material_sample.


other_sptl_obj_s (FSK, O: CHAR VARYING(19))
other_sptl_obj_t (O: CHAR VARYING(16))

property.other_spatial_object

other_sptl_obj_s: Implements a foreign key to a row in one of the tables projected from entity other_spatial_object depending on the value of the next column (See below).
other_sptl_obj_t: Defines the name of the referenced table. Possible values are defined in @other_spatial_object.


wellbore_intv_s (FSK, O: CHAR VARYING(19))

pty_descriptive_text.wellbore_interval
Where the descriptive text is describing a wellbore_interval, this points to the instance of wellbore_interval being described.
Defines a foreign key to table wellbore_intv.


wellbore_point_s (FSK, O: CHAR VARYING(19))
wellbore_point_t (O: CHAR VARYING(16))

pty_descriptive_text.wellbore_point
Where the descriptive text is describing a wellbore_point, this points to the instance of wellbore_point being described.
wellbore_point_s: Implements a foreign key to a row in one of the tables projected from entity wellbore_point depending on the value of the next column (See below).
wellbore_point_t: Defines the name of the referenced table. Possible values are: general_wb_pt, wb_aligned_pt (@wellbore_point).