POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
CREATE TABLE CONTRACT_ASSOC_FACILITY_ASSN
(
BUSINESS_ASSOC_FACILITY_ASSN_S | CHAR VARYING (19) | NOT NULL REFERENCES BUSINESS_ASSOC_FACILITY_INVOLV (INSTANCE_S), |
CONTRACT_S | CHAR VARYING (19) | NOT NULL REFERENCES CONTRACT (INSTANCE_S), |
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) | , |
SOURCE | CHAR VARYING (80) |