POSC Specifications: Epicentre Version 3.0 Relational Implementation

CREATE TABLE TEXT_STYLE
(
CHARACTER_ORIENT_ABSOLUTEFLOAT,
CHARACTER_ORIENT_ABSOLUTE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
CHARACTER_ORIENT_RELATIVEFLOAT,
CHARACTER_ORIENT_RELATIVE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
CHARACTER_SPACINGFLOAT,
CHARACTER_SPACING_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
DESCRIPTIONCHAR VARYING (2000),
INSTANCE_CREATE_DATETIMESTAMP ,
INSTANCE_CREATORCHAR VARYING (80),
INSTANCE_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
LAST_UPDATEDTIMESTAMP ,
LAST_UPDATED_BYCHAR VARYING (80),
R_COLORCHAR VARYING (80) REFERENCES R_COLOR (IDENTIFIER),
R_JUSTIFICATION_HORIZONTALCHAR VARYING (80) REFERENCES R_JUSTIFICATION_HORIZONTAL (IDENTIFIER),
R_JUSTIFICATION_VERTICALCHAR VARYING (80) REFERENCES R_JUSTIFICATION_VERTICAL (IDENTIFIER),
R_TEXT_FONTCHAR VARYING (80) REFERENCES R_TEXT_FONT (IDENTIFIER),
R_TEXT_SLANTCHAR VARYING (80) REFERENCES R_TEXT_SLANT (IDENTIFIER),
R_TEXT_WEIGHTCHAR VARYING (80) REFERENCES R_TEXT_WEIGHT (IDENTIFIER),
SOURCECHAR VARYING (80),
SYMBOL_LIBRARY_SCHAR VARYING (19) NOT NULL REFERENCES SYMBOL_LIBRARY (INSTANCE_S),
TEXT_STYLE_TYPECHAR VARYING (80) NOT NULL REFERENCES R_TEXT_STYLE_TYPE (IDENTIFIER)
)
ALTER TABLE TEXT_STYLE ADD (CONSTRAINT UNIQUE (SYMBOL_LIBRARY_S, TEXT_STYLE_TYPE))


Generated on Tue Jul 10 19:45:11 2001
© Copyright 2001 POSC. All rights reserved.