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).
document_schema_s (FSK, M: CHAR VARYING(19))
document_schema_part.document_schema
This is the document schema that this component is a part of
Defines a foreign key to table document_schema.
document_schema_attribute.cardinality
This specifies the maximum number of attributes of this type that may be included in a document_schema_element. If NULL, the maximum number is unrestricted. document_schema_element.cardinality
This specifies the maximum number of elements of this type that may be included in a document specification using this document type definition. If NULL, the number of elements is unrestricted.
component_sequence (O: INTEGER)
document_schema_part.component_sequence
This is the sequence number of this part within the document schema. This defines the order of this part within the document. A NULL or a value of zero ('0') states that the part has no order. Multiple parts with the same sequence value means that these parts may appear in any order relative to each other but they appear at the same place within the document.
compositor (O: CHAR VARYING(27))
document_schema_element.compositor
This specifies the behavior of the part elements for this element. This defines if a sequence of the part elements is permitted or required, if a choice is permitted or required, if choices are repeated, and if elements are required.
description (O: CHAR VARYING(2000))
e_and_p_data.description
A remark or comment about the instance.
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.
kind (O: CHAR VARYING(132))
document_schema_element.kind
This specifies the type of the element as defined in the XML Schema, describing either the simple or complex type to which this element is constrained.
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.
optionality (O: CHAR(1))
document_schema_attribute.optionality
This defines the optionality of this attribute within the document_schema_element. If FALSE, this attribute must be included in a document_schema_element. If TRUE or NULL, this attribute may be omitted. document_schema_element.optionality
This defines the optionality of this element within the document type definition. If FALSE, this element must be included in a document specification conforming to this document schema. If TRUE or NULL, this element may be omitted.
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.
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.
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.
whole_attribute_s (FSK, O: CHAR VARYING(19))
document_schema_attribute.whole_attribute
This defines the attribute that this attribute is a part of, used when the related attribute is an attribute group.
Defines a foreign key to table document_schema_part.
whole_element_s (FSK, O: CHAR VARYING(19))
document_schema_element.whole_element
This defines the element that this element is a part of, used when the related element is an element group.
Defines a foreign key to table document_schema_part.