POSC Specifications: Epicentre Version 3.0 Relational Implementation

CREATE TABLE CONTRACT
(
DESCRIPTIONCHAR VARYING (2000),
DOCUMENT_DATEDATE,
DURATIONFLOAT,
DURATION_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
EFFECTIVE_DATETIMESTAMP,
EFFECTIVE_DATE_CDCHAR (1),
EFFECTIVE_DATE_DYINTEGER,
EFFECTIVE_DATE_HRINTEGER,
EFFECTIVE_DATE_MTINTEGER,
EFFECTIVE_DATE_OFFLOAT,
EFFECTIVE_DATE_STFLOAT,
EFFECTIVE_DATE_YPINTEGER,
EFFECTIVE_DATE_YRFLOAT,
ENTITY_TYPE_NMCHAR VARYING (30) NOT NULL CHECK (ENTITY_TYPE_NM IN ('CONTRACT_AMENDMENT', 'CO_AND_O_AGREEMENT', 'JOINT_VENTURE_AGREEMENT', 'LICENSE_AGREEMENT', 'MARKETING_AGREEMENT', 'SERVICE_AGREEMENT', 'TITLE_AGREEMENT', 'UNITIZATION_AGREEMENT', 'WELL_OPERATING_AGREEMENT')),
EXECUTION_DATETIMESTAMP,
EXECUTION_DATE_CDCHAR (1),
EXECUTION_DATE_DYINTEGER,
EXECUTION_DATE_HRINTEGER,
EXECUTION_DATE_MTINTEGER,
EXECUTION_DATE_OFFLOAT,
EXECUTION_DATE_STFLOAT,
EXECUTION_DATE_YPINTEGER,
EXECUTION_DATE_YRFLOAT,
EXPIRY_DATETIMESTAMP,
EXPIRY_DATE_CDCHAR (1),
EXPIRY_DATE_DYINTEGER,
EXPIRY_DATE_HRINTEGER,
EXPIRY_DATE_MTINTEGER,
EXPIRY_DATE_OFFLOAT,
EXPIRY_DATE_STFLOAT,
EXPIRY_DATE_YPINTEGER,
EXPIRY_DATE_YRFLOAT,
IDENTIFIERCHAR VARYING (80) NOT NULL,
INSTANCE_CREATE_DATETIMESTAMP ,
INSTANCE_CREATORCHAR VARYING (80),
INSTANCE_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
KIND_SCHAR VARYING (19) REFERENCES DOCUMENT_SPECIFICATION_CLASS (INSTANCE_S),
LAST_UPDATEDTIMESTAMP ,
LAST_UPDATED_BYCHAR VARYING (80),
NAMING_SYSTEMCHAR VARYING (80) REFERENCES NAMING_SYSTEM (IDENTIFIER),
ORIGINAL_EXPIRY_DATETIMESTAMP,
ORIGINAL_EXPIRY_DATE_CDCHAR (1),
ORIGINAL_EXPIRY_DATE_DYINTEGER,
ORIGINAL_EXPIRY_DATE_HRINTEGER,
ORIGINAL_EXPIRY_DATE_MTINTEGER,
ORIGINAL_EXPIRY_DATE_OFFLOAT,
ORIGINAL_EXPIRY_DATE_STFLOAT,
ORIGINAL_EXPIRY_DATE_YPINTEGER,
ORIGINAL_EXPIRY_DATE_YRFLOAT,
RECORDED_DATETIMESTAMP,
RECORDED_DATE_CDCHAR (1),
RECORDED_DATE_DYINTEGER,
RECORDED_DATE_HRINTEGER,
RECORDED_DATE_MTINTEGER,
RECORDED_DATE_OFFLOAT,
RECORDED_DATE_STFLOAT,
RECORDED_DATE_YPINTEGER,
RECORDED_DATE_YRFLOAT,
RECORDED_LINECHAR VARYING (40),
RECORDED_PAGECHAR VARYING (40),
RECORDED_VOLUMECHAR VARYING (40),
SOURCECHAR VARYING (80),
TOTAL_COSTFLOAT,
TOTAL_COST_UCHAR VARYING (15) REFERENCES R_CURRENCY_UNIT (ACRONYM)
)


Generated on Tue Jul 10 19:39:54 2001
© Copyright 2001 POSC. All rights reserved.