POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
The type or kind of property. Each kind of property may be realized using any representation type (e.g., string, quantity, logical, etc). For each kind of property, a constraint may be defined for different representations.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- technical_reference.identifier
The name of the instance.
- 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).
- data_precision (O: INTEGER)
- property_kind.data_precision
This is the minimum precision which must be maintained in the data. If not specified then there is no constraint on the precision.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- element_type (O: CHAR VARYING(12))
- property_kind.element_type
If the data type is an ELEMENT then it is constrained to this element type. If not specified then there is no constraint on the element type.
- fixed_length (O: CHAR(1))
- property_kind.fixed_length
If the data type is a STRING then TRUE indicates that it should be a FIXED length string.
- grid_type (O: CHAR VARYING(17))
- property_kind.grid_type
If the data type is an ELEMENT then it is constrained to this grid type. If not specified then there is no constraint on the grid type.
- 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.
- max_value (O: FLOAT(6))
- property_kind.max_value
If the data type is an INTEGER or REAL then it is constrained to this maximum value. If not specified then there is no constraint on the value.
- min_value (O: FLOAT(6))
- property_kind.min_value
If the data type is an INTEGER or REAL then it is constrained to this minimum value. If not specified then there is no constraint on the value.
- ndt_data_type (O: CHAR VARYING(29))
- property_kind.ndt_data_type
If this property kind was specified in a named defined type (ndt) specification then this is the data type that was declared in that specification.
- 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".
- source_content (O: CHAR VARYING(80))
- technical_reference.source_content
This is the original source of the data. This is the person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc. This may be the same as or different from the provider of the instance (e.g., POSC).
- source_reference (O: CHAR VARYING(2000))
- technical_reference.source_reference
The reference used by source to provide the standard instance, such as Petroleum Industry Data Dictionary (PIDD), Websters Ninth New Collegiate Dictionary, etc.
- status (O: CHAR VARYING(11))
- technical_reference.status
The status of this instance in the version of Epicentre running in a data store. This is an enumerated datatype for which the following are the possible values: current, provisional, deprecated. Current - use without restriction. Provisional - use with caution, this value is for comment and may not appear in future releases of Epicentre. Deprecated - avoid use if possible, it is planned to remove this value in the next major release of Epicentre.
- string_length (O: INTEGER)
- property_kind.string_length
If the data type is a STRING then this it is constrained to this maximum string length. If not specified then there is no constraint on the string length.
- surface_type (O: CHAR VARYING(12))
- property_kind.surface_type
If the data type is a SURFACE then it is constrained to this surface type. If not specified then there is no constraint on the surface type.
- enumeration_constraint (FNK, O: CHAR VARYING(80))
- property_kind.enumeration_constraint
Specifies the required coordinate system constraint of this property if it is instantiated as a generic enumeration. Any enumeration values must be selected from this naming system. If not specified then there is no constraint on the naming system.
Defines a foreign key to table naming_system.
- geometry_constraint (FNK, O: CHAR VARYING(80))
- property_kind.geometry_constraint
Specifies the required coordinate system constraint of this property if it is instantiated as a geometry. This is semantically equivalent to the constraint type on a LOCATION, LINE, SURFACE, VOLUME or POINT data type specification. If not specified then there is no constraint on the coordinate system.
Defines a foreign key to table r_coordinate_sys_constraint.
- money_constraint (FNK, O: CHAR VARYING(15))
- property_kind.money_constraint
Specifies the required currency unit of this property if it is instantiated as a quantity. This is semantically equivalent to the currency type on a MONEY data type specification. If not specified then there is no constraint on the currency unit.
Defines a foreign key to table r_currency_unit.
- naming_system (FNK, O: CHAR VARYING(80))
- aliasable_technical_reference.naming_system
The naming system in which the identifier is specified and determined to be unique.
Defines a foreign key to table naming_system.
- parent_kind_s (FSK, O: CHAR VARYING(19))
- property_kind.parent_kind
The more general property of which this property is a specialization. The semantics of a child property must be a subset of the semantics of the parent property. That is, the child property must represent a specialization of the parent concept by narrowing the meaning of the parent concept.
Defines a foreign key to table property_kind.
- property_constraint (FNK, O: CHAR VARYING(80))
- property_kind.property_constraint
Specifies the required property set of this property if it is instantiated as a geometry. Any instantiated properties must be selected from this set. This is semantically equivalent to the constraint type on a POINT, ELEMENT or SAMPLE data type specification. If not specified then there is no constraint on the properties.
Defines a foreign key to table r_property_set.
- quantity_constraint (FNK, O: CHAR VARYING(80))
- property_kind.quantity_constraint
Specifies the required quantity type of this property if it is instantiated as a quantity. This is semantically equivalent to the quantity type on a QUANTITY data type specification.
Defines a foreign key to table r_quantity_type.
- version_s (FSK, O: CHAR VARYING(19))
- technical_reference.version
This describes the version of this instance as defined by the provider.
Defines a foreign key to table r_version.
Table is related to: axis_type_alternative, common_activity_property, common_facility_property, common_material_property, coordinate_system_axis, data_collection_content, derived_interest_makeup, document_specification_part, @graphical_element, grid_1d, isoline_set, object_activity_involvement, property_classification, property_kind, property_set_composition, p_descriptive_text, p_generic_property, representation_type, technical_reference_alias, well_log_trace_mnemonic
Primary Key Constraint on: INSTANCE_S
Fully implemented Unique Constraint on: IDENTIFIER
Generated on Tue Jul 10 16:54:14 2001
© Copyright 2001 POSC. All rights reserved.