| POSC Specifications Version 2.2 |
Epicentre Relational Implementation |
The assertion that an object of interest is ranked in a ranking system in a position relative to another object of interest. For example, an object may be hotter, colder, lighter, or heavier than another object, based on a comparison of properties.
- object_ranking_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- base_object_s (FSK, M: CHAR VARYING(19))
base_object_t (M: CHAR VARYING(16))
- object_ranking.base_object
Specifies the object whose characteristics serve as the basis of comparison.
base_object_s: Implements a foreign key to a row in one of the tables projected from entity object_of_interest depending on the value of the next column (See below).
base_object_t: Defines the name of the referenced table. Possible values are defined in @object_of_interest.
- ranked_object_s (FSK, M: CHAR VARYING(19))
ranked_object_t (M: CHAR VARYING(16))
- object_ranking.ranked_object
Specifies the object which is being classified based on its relative characteristics.
ranked_object_s: Implements a foreign key to a row in one of the tables projected from entity object_of_interest depending on the value of the next column (See below).
ranked_object_t: Defines the name of the referenced table. Possible values are defined in @object_of_interest.
- relative_rank_s (FSK, M: CHAR VARYING(19))
- object_ranking.relative_rank
Specifies the ranking classification assigned in this relative comparison.
Defines a foreign key to table relative_rank.
- 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.
Table is related to: dae_frame, @graphical_element, parameter_value
Intersection Tables: coll_cntn_x
Primary Key Constraint on: OBJECT_RANKING_S
Generated on Mon Dec 1 10:19:03 1997
© Copyright 1997 POSC. All rights reserved.