POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
CREATE TABLE OBJECT_REMARK
(
BUSINESS_ASSOCIATE_S | CHAR VARYING (19) | REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S), |
BUSINESS_OBJECT_S | CHAR VARYING (19) | NOT NULL, |
BUSINESS_OBJECT_T | CHAR VARYING (30) | NOT NULL, |
DESCRIPTION | CHAR VARYING (2000) | , |
INSTANCE_CREATE_DATE | TIMESTAMP | , |
INSTANCE_CREATOR | CHAR VARYING (80) | , |
INSTANCE_S | CHAR VARYING (19) | NOT NULL PRIMARY KEY, |
LAST_UPDATED | TIMESTAMP | , |
LAST_UPDATED_BY | CHAR VARYING (80) | , |
ORIGINAL_DATE | TIMESTAMP | , |
ORIGINAL_DATE_CD | CHAR (1) | , |
ORIGINAL_DATE_DY | INTEGER | , |
ORIGINAL_DATE_HR | INTEGER | , |
ORIGINAL_DATE_MT | INTEGER | , |
ORIGINAL_DATE_OF | FLOAT | , |
ORIGINAL_DATE_ST | FLOAT | , |
ORIGINAL_DATE_YP | INTEGER | , |
ORIGINAL_DATE_YR | FLOAT | , |
R_OBJECT_REMARK | CHAR VARYING (80) | REFERENCES R_OBJECT_REMARK (IDENTIFIER), |
SEQUENCE | INTEGER | NOT NULL, |
SOURCE | CHAR VARYING (80) |