| POSC Specifications Version 2.2 |
Epicentre Relational Implementation |
A reusable specification or design for facilities, for example, a wellhead facility design specification used for all wells in a particular field. Typical facilities may be described in terms of typical materials and catalog equipment.
- typical_fcl_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- typical_fcl_name (M: CHAR VARYING(40))
- typical_facility.name
The name of the typical facility.
- 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.
- entity_type_nm (M: CHAR VARYING(40))
- 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: typical_facility, typical_receiver_element, typical_reference_point, typical_seismic_receiver, typical_seismic_source, typical_source_element.
- description (O: CHAR VARYING(2000))
- typical_facility.description
A description of the typical facility.
- element_weight (O: FLOAT(6))
- typical_source_element.element_weight
The statistical weight of an element in an array, if these differ between elements. This could be determined, for example, by charge size in an array of explosive devices.
- end_date (O: DATE)
- typical_facility.end_date
The end date of the typical facility specification after which it is invalid.
- start_date (O: DATE)
- typical_facility.start_date
The creation date of the typical facility specification.
- 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.
- 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: dae_frame, @facility, @graphical_element, object_ranking, parameter_value, p_element_value, p_equipment_fcl, seis_geom_set, typ_fcl_clsn, typ_fcl_cmps, typ_fcl_eqpspec, typ_fcl_mtrspec
Intersection Tables: coll_cntn_x, subj_gdln_priv_x
Primary Key Constraint on: TYPICAL_FCL_S
Fully implemented Unique Constraint on: TYPICAL_FCL_NAME
Generated on Mon Dec 1 10:21:24 1997
© Copyright 1997 POSC. All rights reserved.