The specification of class relationships among material classes.
mtrl_cls_clsn_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
be_classified_as_s (FSK, M: CHAR VARYING(19))
material_class_classification.be_classified_as
Specifies the general class in which specific classes are assigned. 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, via the association material_class_classification.
Defines a foreign key to table material_class.
have_as_a_member_s (FSK, M: CHAR VARYING(19))
material_class_classification.have_as_a_member
Specifies the material class which is a member of a general class. 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 "milk chocolate", the child or more specific class.
Defines a foreign key to table material_class.
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.
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.