POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
The physical or rendered form of a document specification. Document is intimately associated with a medium, such as paper or transparent film, or a storage medium, such as magnetic tape, disk, or CD ROM.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- material.identifier
The unique name of the material.
- instance_create_date (O: TIMESTAMP)
- 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_specification_s (FSK, M: CHAR VARYING(19))
document_specification_t (M: CHAR VARYING(30))
- document.document_specification
Document specification defines the information content and graphical formatting for a document.
document_specification_s: Implements a foreign key to a row in one of the tables projected from entity document_specification depending on the value of the next column (See below).
document_specification_t: Defines the name of the referenced table. Possible values are defined in @document_specification.
- r_existence_kind (FNK, M: CHAR VARYING(80))
- material.ref_existence_kind
The existence kind of the material e.g. actual, planned, required, or predicted.
Defines a foreign key to table r_existence_kind.
- entity_type_nm (M: CHAR VARYING(30))
- 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: electronic_document, hardcopy_document.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- digital_file (O: BLOB)
- electronic_document.digital_file
This is the digital document itself.
- 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.
- 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.
- 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".
- x_scale_n (O: INTEGER)
x_scale_d (O: INTEGER)
- hardcopy_document.x_scale
Ratio of real world units to horizontal plot units. For example, 50000 mi/in represents 50000 miles per inch on the x axis.
- y_scale_n (O: INTEGER)
y_scale_d (O: INTEGER)
- hardcopy_document.y_scale
Ratio of real world units to vertical plot units. For example, 25000 mi/in represents 25000 miles per inch of the y plot axis.
- kind_s (FSK, O: CHAR VARYING(19))
- material.kind
The class which asserts the fundamental nature of the material.
Defines a foreign key to table material_class.
- naming_system (FNK, O: CHAR VARYING(80))
- material.naming_system
The naming system in which the identifier is specified and determined to be unique.
Defines a foreign key to table naming_system.
- r_digital_file_format (FNK, O: CHAR VARYING(80))
- electronic_document.ref_digital_file_format
The type of file structure in which the depiction rendering is encoded. Examples include, PostScript, ANSI text, GIFF, JPG, Maker Interchange Format (MIF), SGML, HTML.
Defines a foreign key to table r_digital_file_format.
- r_hardcopy_document (FNK, O: CHAR VARYING(80))
- hardcopy_document.ref_hardcopy_document
A type of hard copy document such as a book, over-sized book, map roll, seismic paper section, microfiche, or film.
Defines a foreign key to table r_hardcopy_document.
Table is related to: activity, contract_object_designation, contract_oblig_object_fulfil, data_collection_content, derived_interest_makeup, document_specification_part, coordinate_system, @graphical_element, guideline_compliance, material_alias, material_classification, material_composition, material_fulfillment, material_installation, material_storage, object_activity_involvement, object_remark, object_subject_to_guideline, p_generic_property, space_time_operation, spatial_object, subject_of_contract, topological_relationship
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:15:50 2001
© Copyright 2001 POSC. All rights reserved.