POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A generic property characteristic. The characteristic is defined by a property kind, a value representation, and a time defining when the property is associated with the object.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- location_value_1 (M: FLOAT)
location_value_1_u (FNK, M: CHAR VARYING(15))
location_value_cs_s (FSK, M: CHAR VARYING(19))
- pty_generic_location.data_value
A location representation of a property value.
location_value_1_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
location_value_cs_s: Defines the coordinate system of the coordinate value(s). Defines a foreign key to table coordinate_system.
- 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).
- property_kind_s (FSK, M: CHAR VARYING(19))
- pty_generic_property.property_kind
Specifies the type of property. This is the role the data value with respect to the object which has this property.
Defines a foreign key to table property_kind.
- entity_type_nm (M: CHAR VARYING(30))
- Column that contains the name of the entity that this row is an instance of in case a table represents multiple entities. Possible values are: pty_generic_angle, pty_generic_binary, pty_generic_boolean, pty_generic_date, pty_generic_daytimeinterval, pty_generic_element, pty_generic_enumeration, pty_generic_integer, pty_generic_line, pty_generic_location, pty_generic_logical, pty_generic_money, pty_generic_point, pty_generic_probability, pty_generic_quantity, pty_generic_ratio, pty_generic_rational, pty_generic_real, pty_generic_string, pty_generic_surface, pty_generic_time, pty_generic_volume.
- time_value (O: FLOAT)
time_value_u (FNK, O: CHAR VARYING(15))
- pty_generic_time.data_value
A time representation of a property value.
time_value_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- date_value (O: TIMESTAMP)
date_value_cd (O: CHAR(1))
date_value_yr (O: FLOAT)
date_value_yp (O: INTEGER)
date_value_dy (O: INTEGER)
date_value_hr (O: INTEGER)
date_value_mt (O: INTEGER)
date_value_st (O: FLOAT)
date_value_of (O: FLOAT)
- pty_generic_date.data_value
A timestamp representation of a property value.
- real_value (O: FLOAT(14))
- pty_generic_real.data_value
A real representation of a property value.
- logical_value (O: CHAR(1))
- pty_generic_logical.data_value
A logical representation of a property value.
- surface_value_sl (O: CHAR VARYING(16))
- pty_generic_surface.data_value
A surface representation of a property value.
- element_value_sl (O: CHAR VARYING(16))
- pty_generic_element.data_value
Array of values carrying the property attached to a complex element such as a grid or a mesh.
- ratio_value_n (O: FLOAT)
ratio_value_d (O: FLOAT)
- pty_generic_ratio.data_value
A ratio representation of a property value.
- rational_value_n (O: INTEGER)
rational_value_d (O: INTEGER)
- pty_generic_rational.data_value
A rational representation of a property value.
- angle_value (O: FLOAT)
angle_value_ma (O: INTEGER)
angle_value_sa (O: FLOAT)
angle_value_u (FNK, O: CHAR VARYING(15))
- pty_generic_angle.data_value
A angle representation of a property value.
angle_value_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- quantity_value (O: FLOAT)
quantity_value_u (FNK, O: CHAR VARYING(15))
quantity_value_q (FNK, O: CHAR VARYING(80))
- pty_generic_quantity.data_value
The value of a quantity representation of a general property.
quantity_value_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
quantity_value_q: Specifies the type of quantity. Defines a foreign key to table r_quantity_type.
- daytimeinterval_value (O: DAYTIMEINTERVAL)
- pty_generic_daytimeinterval.data_value
A daytimeinterval representation of a property value.
- volume_value_sl (O: CHAR VARYING(16))
- pty_generic_volume.data_value
A volume representation of a property value.
- binary_value (O: BLOB)
- pty_generic_binary.data_value
A binary representation of a property value.
- location_value_1_ma (O: INTEGER)
location_value_1_sa (O: FLOAT)
location_value_2 (O: FLOAT)
location_value_2_ma (O: INTEGER)
location_value_2_sa (O: FLOAT)
location_value_2_u (FNK, O: CHAR VARYING(15))
location_value_3 (O: FLOAT)
location_value_3_ma (O: INTEGER)
location_value_3_sa (O: FLOAT)
location_value_3_u (FNK, O: CHAR VARYING(15))
location_value_4 (O: FLOAT)
location_value_4_ma (O: INTEGER)
location_value_4_sa (O: FLOAT)
location_value_4_u (FNK, O: CHAR VARYING(15))
location_value_5 (O: FLOAT)
location_value_5_ma (O: INTEGER)
location_value_5_sa (O: FLOAT)
location_value_5_u (FNK, O: CHAR VARYING(15))
location_value_o_s (FSK, O: CHAR VARYING(19))
- location_value_2_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
location_value_3_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
location_value_4_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
location_value_5_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
location_value_o_s: Defines the origin of the coordinate value(s). Defines a foreign key to table spatial_object.
- integer_value (O: INTEGER)
- pty_generic_integer.data_value
An integer representation of a property value.
- line_value_sl (O: CHAR VARYING(16))
- pty_generic_line.data_value
A line representation of a general property.
- money_value (O: FLOAT)
money_value_u (FNK, O: CHAR VARYING(15))
- pty_generic_money.data_value
A pty_money representation of a property value.
money_value_u: Defines the currency unit. Defines a foreign key to table r_currency_unit.
- point_value_sl (O: CHAR VARYING(16))
- pty_generic_point.data_value
A point representation of a general property.
- boolean_value (O: CHAR(1))
- pty_generic_boolean.data_value
A boolean representation of a property value.
- string_value (O: CHAR VARYING(255))
- pty_generic_string.data_value
A character representation of a property value.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- distribution_sl (O: CHAR VARYING(16))
- pty_generic_probability.distribution
This is the description of the value of this property as a function of probability. The conventional representation of this property is recorded in the data value attribute.
- distribution_type (O: CHAR VARYING(14))
- pty_generic_probability.distribution_type
This describes the shape of the probability distribution. This shape should be used to interpolate between values.
- end_time (O: TIMESTAMP)
end_time_cd (O: CHAR(1))
end_time_yr (O: FLOAT)
end_time_yp (O: INTEGER)
end_time_dy (O: INTEGER)
end_time_hr (O: INTEGER)
end_time_mt (O: INTEGER)
end_time_st (O: FLOAT)
end_time_of (O: FLOAT)
- pty_transient_property.end_time
The date and time of day designated as the end of the valid or effective time interval over which the property applies.
- 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.
- maximum_value (O: FLOAT(6))
- pty_generic_probability.maximum_value
The maximum value of the probability distribution. This value is in the same units of measure as the data_value.
- minimum_value (O: FLOAT(6))
- pty_generic_probability.minimum_value
The minimum value of the probability distribution. This value is in the same units of measure as the data_value.
- mode_value (O: FLOAT(6))
- pty_generic_probability.mode_value
The mode value of the probability distribution. This value is in the same units of measure as the data_value.
- preferred_flag (O: CHAR(1))
- property.preferred_flag
The flag is set to True if this instance of property is the preferred value in this data store of this type of property for the object which this property describes.
- 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".
- standard_deviation (O: FLOAT(6))
- pty_generic_probability.standard_deviation
The standard deviation of the probability distribution.
- start_time (O: TIMESTAMP)
start_time_cd (O: CHAR(1))
start_time_yr (O: FLOAT)
start_time_yp (O: INTEGER)
start_time_dy (O: INTEGER)
start_time_hr (O: INTEGER)
start_time_mt (O: INTEGER)
start_time_st (O: FLOAT)
start_time_of (O: FLOAT)
- pty_transient_property.start_time
The date and time of day that designated the start of the valid or effective time interval over which the property applies.
- activity_s (FSK, O: CHAR VARYING(19))
- process_data.activity
Defines the activity which created this instance.
Defines a foreign key to table activity.
- classification_class_s (FSK, O: CHAR VARYING(19))
classification_class_t (O: CHAR VARYING(30))
- pty_generic_property.classification_class
classification_class_s: Implements a foreign key to a row in one of the tables projected from entity classification_class depending on the value of the next column (See below).
classification_class_t: Defines the name of the referenced table. Possible values are defined in @classification_class.
- enumeration_value_s (FSK, O: CHAR VARYING(19))
- pty_generic_enumeration.data_value
A real representation of a property value.
Defines a foreign key to table generic_enumeration.
- described_activity_s (FSK, O: CHAR VARYING(19))
- pty_generic_property.described_activity
Defines a foreign key to table activity.
- facility_s (FSK, O: CHAR VARYING(19))
facility_t (O: CHAR VARYING(30))
- pty_generic_property.facility
facility_s: Implements a foreign key to a row in one of the tables projected from entity facility depending on the value of the next column (See below).
facility_t: Defines the name of the referenced table. Possible values are defined in @facility.
- grid_geometry_behavior_s (FSK, O: CHAR VARYING(19))
grid_geometry_behavior_t (O: CHAR VARYING(30))
- grid_element_behavior.grid_geometry_behavior
This is the description of grid geometry for which this set of grid element properties are defined.
grid_geometry_behavior_s: Implements a foreign key to a row in one of the tables projected from entity grid_geometry_behavior depending on the value of the next column (See below).
grid_geometry_behavior_t: Defines the name of the referenced table. Possible values are defined in @grid_geometry_behavior.
- material_s (FSK, O: CHAR VARYING(19))
material_t (O: CHAR VARYING(30))
- pty_generic_property.material
material_s: Implements a foreign key to a row in one of the tables projected from entity material depending on the value of the next column (See below).
material_t: Defines the name of the referenced table. Possible values are: bulk_material, document, equipment_item (@material).
- r_transient_period (FNK, O: CHAR VARYING(80))
- pty_transient_property.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.
- represent_s (FSK, O: CHAR VARYING(19))
represent_t (O: CHAR VARYING(30))
- property.represent
This is the property that is the original for which this representation is an equivalent representation.
represent_s: Implements a foreign key to a row in one of the tables projected from entity property depending on the value of the next column (See below).
represent_t: Defines the name of the referenced table. Possible values are defined in @property.
- typical_facility_s (FSK, O: CHAR VARYING(19))
- pty_generic_property.typical_facility
Defines a foreign key to table typical_facility.
- typical_material_s (FSK, O: CHAR VARYING(19))
- pty_generic_property.typical_material
Defines a foreign key to table typical_material.
Table is related to: data_collection_content, document_specification_part, @graphical_element, @grid_element_behavior, process_data_item, @property
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 17:58:06 2001
© Copyright 2001 POSC. All rights reserved.