POSC Specifications: Epicentre Version 3.0 Relational Implementation

CREATE TABLE DOCUMENT_SPECIFICATION_PART
(
ANNOTATIONCHAR VARYING (132),
AXIS_ROTATION_ANGLEFLOAT,
AXIS_ROTATION_ANGLE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
CITATIONCHAR VARYING (2000),
DESCRIPTIONCHAR VARYING (2000),
DOCUMENT_REFERENCED_SCHAR VARYING (19),
DOCUMENT_REFERENCED_TCHAR VARYING (30),
DOCUMENT_SCHEMA_PART_SCHAR VARYING (19) REFERENCES DOCUMENT_SCHEMA_PART (INSTANCE_S),
DOCUMENT_SPECIFICATION_SCHAR VARYING (19) NOT NULL,
DOCUMENT_SPECIFICATION_TCHAR VARYING (30) NOT NULL,
ENTITY_TYPE_NMCHAR VARYING (30) NOT NULL CHECK (ENTITY_TYPE_NM IN ('DOCUMENT_GRAPHICAL_CONTENT', 'DOCUMENT_INFORMATION_CONTENT', 'DOCUMENT_SPEC_REFERENCE', 'DOCUMENT_TEXTUAL_CONTENT')),
E_AND_P_DATA_SCHAR VARYING (19),
E_AND_P_DATA_TCHAR VARYING (30),
GRAPHICAL_REPRESENTATION_SCHAR VARYING (19),
GRAPHICAL_REPRESENTATION_TCHAR VARYING (30),
INSTANCE_CREATE_DATETIMESTAMP ,
INSTANCE_CREATORCHAR VARYING (80),
INSTANCE_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
LAST_UPDATEDTIMESTAMP ,
LAST_UPDATED_BYCHAR VARYING (80),
MAXIMUM_SCALEFLOAT,
MAXIMUM_SCALE_QCHAR VARYING (80) REFERENCES R_QUANTITY_TYPE (IDENTIFIER),
MAXIMUM_SCALE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
MINIMUM_SCALEFLOAT,
MINIMUM_SCALE_QCHAR VARYING (80) REFERENCES R_QUANTITY_TYPE (IDENTIFIER),
MINIMUM_SCALE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
REFERENCE_CONTENT_SCHAR VARYING (19) REFERENCES DOCUMENT_SPECIFICATION_PART (INSTANCE_S),
ROLECHAR VARYING (80) REFERENCES R_DOCUMENT_SPEC_REFERENCE (IDENTIFIER),
SEQUENCEINTEGER,
SOURCECHAR VARYING (80),
TEXTCHAR VARYING,
X_OFFSETFLOAT,
X_OFFSET_QCHAR VARYING (80) REFERENCES R_QUANTITY_TYPE (IDENTIFIER),
X_OFFSET_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
X_SCALEFLOAT,
X_SCALE_QCHAR VARYING (80) REFERENCES R_QUANTITY_TYPE (IDENTIFIER),
X_SCALE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
Y_OFFSETFLOAT,
Y_OFFSET_QCHAR VARYING (80) REFERENCES R_QUANTITY_TYPE (IDENTIFIER),
Y_OFFSET_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
Y_SCALEFLOAT,
Y_SCALE_QCHAR VARYING (80) REFERENCES R_QUANTITY_TYPE (IDENTIFIER),
Y_SCALE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM)
)


Generated on Tue Jul 10 19:40:08 2001
© Copyright 2001 POSC. All rights reserved.