POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
This is the pre-defined content of a document schema entity. This may be either locally defined as text (unlimited characters) or as a reference to existing content in an existing document (if already defined). If more than one content specification is made for the document schema entity, the sequence attribute should be used to determine their relative ordering.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- 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_schema_entity_s (FSK, M: CHAR VARYING(19))
- document_schema_entity_content.document_schema_entity
This is the document schema entity that is being described.
Defines a foreign key to table document_schema_part.
- 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.
- 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.
- sequence (O: INTEGER)
- document_schema_entity_content.sequence
This is the sequence number of this text of document content within the document schema entity. A NULL or a value of zero ('0') states that this content specification has no order. Multiple parts with the same sequence value means that these content specifications may appear in any order relative to each other but they appear at the same place within the document schema entity.
- 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".
- text (O: CHAR VARYING)
- document_schema_entity_content.text
This is a block of text that is part of a document schema entity.
- document_content_s (FSK, O: CHAR VARYING(19))
- document_schema_entity_content.document_content
This references parts of existing document specifications as part of this document schema entity.
Defines a foreign key to table document_specification_part.
Table is related to: data_collection_content, document_specification_part, @graphical_element
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:16:14 2001
© Copyright 2001 POSC. All rights reserved.