POSC Specifications: Epicentre Version 3.0 Relational Implementation

CREATE TABLE SPACE_TIME_OPERATION
(
DESCRIPTIONCHAR VARYING (2000),
INSTANCE_CREATE_DATETIMESTAMP ,
INSTANCE_CREATORCHAR VARYING (80),
INSTANCE_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
INTERSECTING_OBJECT_SCHAR VARYING (19),
INTERSECTING_OBJECT_TCHAR VARYING (30),
LAST_UPDATEDTIMESTAMP ,
LAST_UPDATED_BYCHAR VARYING (80),
PRIMARY_OBJECT_SCHAR VARYING (19) NOT NULL,
PRIMARY_OBJECT_TCHAR VARYING (30) NOT NULL,
PROJECTION_VECTOR_1FLOAT NOT NULL,
PROJECTION_VECTOR_1_MAINTEGER,
PROJECTION_VECTOR_1_SAFLOAT,
PROJECTION_VECTOR_1_UCHAR VARYING (15) NOT NULL REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
PROJECTION_VECTOR_2FLOAT,
PROJECTION_VECTOR_2_MAINTEGER,
PROJECTION_VECTOR_2_SAFLOAT,
PROJECTION_VECTOR_2_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
PROJECTION_VECTOR_3FLOAT,
PROJECTION_VECTOR_3_MAINTEGER,
PROJECTION_VECTOR_3_SAFLOAT,
PROJECTION_VECTOR_3_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
PROJECTION_VECTOR_4FLOAT,
PROJECTION_VECTOR_4_MAINTEGER,
PROJECTION_VECTOR_4_SAFLOAT,
PROJECTION_VECTOR_4_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
PROJECTION_VECTOR_5FLOAT,
PROJECTION_VECTOR_5_MAINTEGER,
PROJECTION_VECTOR_5_SAFLOAT,
PROJECTION_VECTOR_5_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
PROJECTION_VECTOR_CS_SCHAR VARYING (19) NOT NULL REFERENCES COORDINATE_SYSTEM (INSTANCE_S),
PROJECTION_VECTOR_O_SCHAR VARYING (19) REFERENCES SPATIAL_OBJECT (INSTANCE_S),
RESULTING_OBJECT_SCHAR VARYING (19) NOT NULL,
RESULTING_OBJECT_TCHAR VARYING (30) NOT NULL,
R_SPACE_TIME_OPERATIONCHAR VARYING (80) NOT NULL REFERENCES R_SPACE_TIME_OPERATION (IDENTIFIER),
SOURCECHAR VARYING (80)
)
ALTER TABLE SPACE_TIME_OPERATION ADD (CONSTRAINT UNIQUE (R_SPACE_TIME_OPERATION, RESULTING_OBJECT_S, RESULTING_OBJECT_T))


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