POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
Defines a relationship between two or three objects. The operation (e.g., intersection, addition, subtraction) of a primary object on an intersecting object produces a resulting object. For example, an edge is an object resulting from the intersection between two faces.
- 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).
- projection_vector_1 (M: FLOAT)
projection_vector_1_u (FNK, M: CHAR VARYING(15))
projection_vector_cs_s (FSK, M: CHAR VARYING(19))
- space_time_operation.projection_vector
The angle of projection. Depending upon the dimension of the space, the angle will be defined by one, two or three components.
projection_vector_1_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
projection_vector_cs_s: Defines the coordinate system of the coordinate value(s). Defines a foreign key to table coordinate_system.
- primary_object_s (FSK, M: CHAR VARYING(19))
primary_object_t (M: CHAR VARYING(30))
- space_time_operation.primary_object
Indicates the topological object involved in a space/time operation in the role of primary agent (i.e., the thing we start with). For degeneration, this points to the object which is being degenerated. For projection, this points to the object which is being projected onto another object (the screen). For intersection and addition, this points to one of the objects participating in the relationship (i.e., both relationships must be searched to find a particular object). For proximity, this points to the container object which is near the intersecting object and of which the resulting object is a subset. For subtraction, this points to the object from which we are subtracting the intersection of the intersecting object.
primary_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_object_t: Defines the name of the referenced table. Possible values are defined in @topological_object.
- r_space_time_operation (FNK, M: CHAR VARYING(80))
- space_time_operation.ref_space_time_operation
This describes the kind of operation. Allowable operations include: intersection, proximity, projection, degeneration, addition and subtraction.
Defines a foreign key to table r_space_time_operation.
- resulting_object_s (FSK, M: CHAR VARYING(19))
resulting_object_t (M: CHAR VARYING(30))
- space_time_operation.resulting_object
Indicates the topological object which resulted from a space/time operation. For intersection, this points to the object which represents the intersection of the two objects. For degeneration, this points to the object which is a degenerated form of the primary object. For projection, this points to the object which represents the projection of the primary object onto the intersecting object. For subtraction, this points to the object which is the result of subtracting from the primary object, the intersection between the primary and the intersecting object. For addition, this represents the union of the primary and intersecting objects. For proximity, this points to the object which is a subset of the primary object which is near the intersecting object.
resulting_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).
resulting_object_t: Defines the name of the referenced table. Possible values are defined in @topological_object.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- instance_creator (O: CHAR VARYING(80))
- 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.
- 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.
- projection_vector_1_ma (O: INTEGER)
projection_vector_1_sa (O: FLOAT)
projection_vector_2 (O: FLOAT)
projection_vector_2_ma (O: INTEGER)
projection_vector_2_sa (O: FLOAT)
projection_vector_2_u (FNK, O: CHAR VARYING(15))
projection_vector_3 (O: FLOAT)
projection_vector_3_ma (O: INTEGER)
projection_vector_3_sa (O: FLOAT)
projection_vector_3_u (FNK, O: CHAR VARYING(15))
projection_vector_4 (O: FLOAT)
projection_vector_4_ma (O: INTEGER)
projection_vector_4_sa (O: FLOAT)
projection_vector_4_u (FNK, O: CHAR VARYING(15))
projection_vector_5 (O: FLOAT)
projection_vector_5_ma (O: INTEGER)
projection_vector_5_sa (O: FLOAT)
projection_vector_5_u (FNK, O: CHAR VARYING(15))
projection_vector_o_s (FSK, O: CHAR VARYING(19))
- projection_vector_2_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
projection_vector_3_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
projection_vector_4_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
projection_vector_5_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
projection_vector_o_s: Defines the origin of the coordinate value(s). Defines a foreign key to table spatial_object.
- 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".
- intersecting_object_s (FSK, O: CHAR VARYING(19))
intersecting_object_t (O: CHAR VARYING(30))
- space_time_operation.intersecting_object
Indicates the topological object involved in a space/time operation in the role of intersecting agent. For projection, this points to the screen on which the primary object is being projected. For intersection and addition, this points to one of the objects participating in the relationship (i.e., both relationships must be searched to find a particular object). For subtraction, this points to the object which is subtracted from the primary object. For proximity, this points to the magnet object that the primary object is near.
intersecting_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).
intersecting_object_t: Defines the name of the referenced table. Possible values are defined in @topological_object.
Table is related to: data_collection_content, document_specification_part, @graphical_element
Primary Key Constraint on: INSTANCE_S
Fully implemented Unique Constraint on: R_SPACE_TIME_OPERATION, RESULTING_OBJECT_S, RESULTING_OBJECT_T
Generated on Tue Jul 10 17:02:55 2001
© Copyright 2001 POSC. All rights reserved.