POSC Meta Model Specifications Version 2.3 Meta Data Relational Implementation

CREATE TABLE TYPE_DEF
(
AGGR_NAMECHAR VARYING (15),
EPIC_TYPE_SCHAR VARYING (19) REFERENCES EPIC_TYPE (EPIC_TYPE_S),
FIXED_LENGTHCHAR (1) NOT NULL,
MAX_CARDINTEGER,
MAX_LENGTHINTEGER,
MIN_CARDINTEGER,
PARAM_1CHAR VARYING (40),
PARAM_2CHAR VARYING (40),
PARAM_3CHAR VARYING (40),
PARAM_4CHAR VARYING (40),
PARAM_5CHAR VARYING (40),
PARAM_6CHAR VARYING (40),
SCHEMA_DEF_SCHAR VARYING (19) NOT NULL REFERENCES SCHEMA_DEF (SCHEMA_DEF_S),
SOURCE_SCHAR VARYING (19) NOT NULL REFERENCES SOURCE (SOURCE_S),
TYPE_CODECHAR (3) NOT NULL REFERENCES REF_OBJECT (OBJ_TYPE),
TYPE_DEF_NMCHAR VARYING (40) NOT NULL,
TYPE_DEF_SCHAR VARYING (19) NOT NULL PRIMARY KEY
)
ALTER TABLE TYPE_DEF ADD (CONSTRAINT UNIQUE (type_def_nm, schema_def_s))


© Copyright 1997-2001 POSC. All rights reserved.