activity.ref_existence_kind
The lifecycle kind of the activity e.g. actual, planned, required or predicted.
Defines a foreign key to table r_existence_kd.
cost (O: FLOAT)
cost_u (FNK, O: CHAR VARYING(15))
activity.cost
The cost of the activity. cost_u: Defines the currency unit. Defines a foreign key to table r_currency_unit.
description (O: CHAR VARYING(2000))
activity.description
A description of the activity.
activity.name
The name or label given to the activity.
start_time (O: TIMESTAMP)
activity.start_time
The start time of the activity.
wellbore_id (O: CHAR VARYING(40))
wellbore.identifier
Identifier used to identify a wellbore within a well. This is often a sequence number or character, such as 1, 2, A, B, C, etc.
This column has been duplicated through attribute wellbore_activity.wellbore, which establishes the relationship between the original and duplicated column(s).
This column is a duplicate of column wellbore.wellbore_id.
activity.containing_activity
Specifies the containing activity. The containing activity indicates the activity for which this activity is a component sub-activity. Constrains the time of the contained activity to be during the containing activity. containing_act_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). containing_act_t: Defines the name of the referenced table. Possible values are defined in @activity.
r_transient_period (FNK, O: CHAR VARYING(40))
activity.ref_transient_period
The type of period over which the property applies, such as day, month, quarter, cumulative, etc.
Defines a foreign key to table r_transient_pd.
typical_act_name (FNK, O: CHAR VARYING(40))
activity.typical_activity
Gives the typical activity which acts as the template or design for this activity.
Defines a foreign key to table typical_act.
utilize_eqp_s (FSK, O: CHAR VARYING(19))
activity.utilize_equipment
Defines a piece of equipment used by the activity without stating the functional usage of the equipment. This is useful for legacy data where there is knowledge about a piece of equipment but there is not enough knowledge to define a facility.
Defines a foreign key to table equipment_item.
wellbore_s (FSK, O: CHAR VARYING(19))
wellbore_activity.wellbore
Specifies the wellbore in which this activity took place.
Defines a foreign key to table wellbore.