Defines the spatial topology between two topological objects. For example, a city may be defined to be "within" a county.
instance_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
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).
spatial_predicate (M: CHAR VARYING(9))
topological_relationship.spatial_predicate
The results of the OpenGis spatial predicate based on the Dimensionally Extended Nine-Intersection Model (DE-9IM). This indicates which mutually exclusive predicate was true.
topological_relationship.primary_topological_object
Indicates a topologic object in the role of primary agent. For a spatial predicate type of "within" this is the containing object (e.g., if a city is within a county then the county would be the primary agent). For all other spatial predicate 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. primary_topological_object_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). primary_topological_object_t: Defines the name of the referenced table. Possible values are defined in @topological_object.
topological_relationship.secondary_topological_object
Indicates a topologic object in the role of secondary agent in the topological relationship. For a spatial predicate type of "within" this is the contained object (e.g., if a city is within a county then the city would be the secondary agent). For all other spatial predicate 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. secondary_topological_object_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). secondary_topological_object_t: Defines the name of the referenced table. Possible values are defined in @topological_object.
de9im (O: CHAR(9))
topological_relationship.de9im
A variation of the OpenGis specification for the Dimensionally Extended Nine-Intersection Model (DE-9IM). Each character in the string represents the maximum dimension (D, 0, 1, 2 or 3) of the intersection of the primary and secondary objects where "D" indicates disjoint, "0" indicates a point, "1" indicates a line, "2" indicates a surface and "3" indicates a volume. The values are in the order of: PI-SI, PI-SB, PI-SE, PB-SI, PB-SB, PB-SE, PE-SI, PE-SB, PE-SE. Where P=Primary_object, S=Secondary_object, I=Interior, B=Boundary, E=exterior.
description (O: CHAR VARYING(2000))
e_and_p_data.description
A remark or comment about the instance.
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_unit_of_measure.
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.
is_current (O: CHAR(1))
transient_association.is_current
When TRUE, this flag indicates that this instance is designated as a current instance. This flag can be used in place of time based attributes or can be used in conjunction with them; however, it should not conflict with them.
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.
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".
transient_association.caused_by
Specifies the activity which establishes this association.
Defines a foreign key to table activity.
r_transient_period (FNK, O: CHAR VARYING(80))
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_period.
terminated_by_s (FSK, O: CHAR VARYING(19))
transient_association.terminated_by
Specifies the activity which established the termination of a transient association between two objects.
Defines a foreign key to table activity.