| POSC Specifications Version 2.2 |
Epicentre Relational Implementation |
A set of property types used to constrain the ref properties that can be associated with a point, element, sparse or sample data types. A data type instance may only reference ref properties which are of the type contained in the ref property set specified for the data type.
- r_property_set_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- r_property_set_nm (M: CHAR VARYING(40))
- ref_property_set.name
A unique name for the property set.
- r_pty_set_ty_name (FNK, M: CHAR(2))
- ref_property_set.ref_property_set_type
Gives the type of the property set.
Defines a foreign key to table r_pty_set_ty.
- source (FNK, M: CHAR VARYING(40))
- reference_behavior.source
The provider of this instance of reference information. If this instance is provided by POSC, then this attribute must be "POSC".
Defines a foreign key to table r_source.
- description (O: CHAR VARYING(2000))
- ref_property_set.description
A description of the purpose of the property set.
- status (O: CHAR VARYING(11))
- reference_behavior.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.
- use_limit (O: INTEGER)
- ref_property_set.use_limit
The number of set members that may be used in a point, element, sparse or sample data type instance. If undefined (null) all members of the set are implied.
- source_reference_s (FSK, O: CHAR VARYING(19))
- reference_behavior.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.
Defines a foreign key to table r_source_ref.
- version (FNK, O: CHAR VARYING(40))
- reference_behavior.version
Describes the version of Epicentre when this status was assigned to this instance of reference behavior
Defines a foreign key to table r_epcnt_version.
Table is related to: r_code_alias
Intersection Tables: reference_data_x, r_property_ty_x
Primary Key Constraint on: R_PROPERTY_SET_S
Fully implemented Unique Constraint on: R_PROPERTY_SET_NM
Generated on Mon Dec 1 10:27:05 1997
© Copyright 1997 POSC. All rights reserved.