Defines the topology between two topological objects. For example, a city may be defined to be "inside" a county.

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

Surrogate key of the table.


boundary_overlap (M: CHAR(1))

topological_relationship.boundary_overlap
Boundary overlap qualifies whether or not the two objects have at least partially one of their boundaries in common. True indicates that they overlap. False indicates that they do not even partially overlap.


prim_toplg_obj_s (FSK, M: CHAR VARYING(19))
prim_toplg_obj_t (M: CHAR VARYING(16))

topological_relationship.primary_topological_object
Indicates a topologic object in the role of primary agent. For an object intersection type of "inside" this is the containing object (e.g., if a city is inside a county then the county would be the primary agent). For all other object intersection types the roles are symmetrical and both relationships must be searched for a particular object. For example, if a wellbore and a formation overlap then either could be chosen as the primary agent with the other chosen as the secondary agent.
prim_toplg_obj_s: Implements a foreign key to a row in one of the tables projected from entity topological_object depending on the value of the next column (See below).
prim_toplg_obj_t: Defines the name of the referenced table. Possible values are defined in @topological_object.


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

topological_relationship.ref_object_intersection
Object Intersection qualifies the result of the intersection between two objects primary and secondary. The result could be empty, equal, inside or overlap.
Defines a foreign key to table r_object_ntrs.


sec_toplg_obj_s (FSK, M: CHAR VARYING(19))
sec_toplg_obj_t (M: CHAR VARYING(16))

topological_relationship.secondary_topological_object
Indicates a topologic object in the role of secondary agent in the topological relationship. For an object intersection type of "inside" this is the contained object (e.g., if a city is inside a county then the city would be the secondary agent). For all other object intersection types the roles are symmetrical and both relationships must be searched for a particular object. For example, if a wellbore and a formation overlap then either could be chosen as the secondary agent with the other chosen as the primary agent.
sec_toplg_obj_s: Implements a foreign key to a row in one of the tables projected from entity topological_object depending on the value of the next column (See below).
sec_toplg_obj_t: Defines the name of the referenced table. Possible values are defined in @topological_object.


description (O: CHAR VARYING(2000))

transient_association.description
A description of the transient association.


duration (O: FLOAT)
duration_u (FNK, O: CHAR VARYING(15))

transient_association.duration
Defines the duration of the association expressed in any valid units of time.
duration_u: Defines the unit of measure. Defines a foreign key to table r_uom.


end_time (O: TIMESTAMP)

transient_association.end_time
End time of the association.


start_time (O: TIMESTAMP)

transient_association.start_time
Start time of the association.


caused_by_s (FSK, O: CHAR VARYING(19))
caused_by_t (O: CHAR VARYING(16))

transient_association.caused_by
Specifies the activity which establishes this association.
caused_by_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).
caused_by_t: Defines the name of the referenced table. Possible values are defined in @activity.


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

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


terminated_by_s (FSK, O: CHAR VARYING(19))
terminated_by_t (O: CHAR VARYING(16))

transient_association.terminated_by
Specifies the activity which established the termination of a transient association between two objects.
terminated_by_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).
terminated_by_t: Defines the name of the referenced table. Possible values are defined in @activity.