|POSC Specifications: Epicentre Version 3.0 ||Relational Implementation|
A classification of material based on specification of a range of characteristics. For example, the classification of rocks into lithologic classes is based on ranges of mineral composition and grain size. Other examples of material class is to classify a fluid system as a crude oil, natural gas or formation water.
Table is related to: common_activity_involvement, common_guideline_or_privilege, common_material_composition, common_material_property, data_collection_content, derived_interest_makeup, document_specification_part, earth_feature_classification, facility_classification, facility_class_classification, fluid_flow_stream_contaminant, geologic_age_classification, @graphical_element, @material, material_class, material_classification, material_class_classification, material_composition, object_activity_involvement, p_generic_property, p_isotope_ratio, technical_reference_alias, typical_facility_clsn, typical_material, typical_material_clsn
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
The name of the instance.
- instance_create_date (O: TIMESTAMP)
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)
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).
- description (O: CHAR VARYING(2000))
A remark or comment about the instance.
- end_date (O: DATE)
The expiration of the class, after which the class is invalid.
- instance_creator (O: CHAR VARYING(80))
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))
This records the person or application making the update to this instance.
- source (O: CHAR VARYING(80))
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))
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))
The reference used by source to provide the standard instance, such as Petroleum Industry Data Dictionary (PIDD), Websters Ninth New Collegiate Dictionary, etc.
- start_date (O: DATE)
The date from which this class is valid.
- status (O: CHAR VARYING(11))
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.
- archetype_feature_s (FSK, O: CHAR VARYING(19))
This the geologic feature that provides the definition for this material class.
Defines a foreign key to table geologic_feature.
- archetype_typical_s (FSK, O: CHAR VARYING(19))
This the typical material that provides definition for this material class.
Defines a foreign key to table typical_material.
- naming_system (FNK, O: CHAR VARYING(80))
The naming system in which the identifier is specified and determined to be unique.
Defines a foreign key to table naming_system.
- parent_class_s (FSK, O: CHAR VARYING(19))
The more general class of which this class is a specialization. The semantics of a child class must be a subset of the semantics of the parent class. That is, the child class must represent a specialization of the parent concept by narrowing the meaning of the parent concept. Conformance to a class where the meaning of the class is not altered should be handled by class classification instead of by parent/child. The naming system of the child class should either be the same as the naming system of the parent class or it should be a specialization of that naming system. For example, the material_class "chocolate" is a general class to which the more specific class "milk chocolate" can be assigned. In this case, this attribute points to "chocolate", the parent or more general class.
Defines a foreign key to table material_class.
- version_s (FSK, O: CHAR VARYING(19))
This describes the version of this instance as defined by the provider.
Defines a foreign key to table r_version.
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:43:47 2001
© Copyright 2001 POSC. All rights reserved.