POSC Meta Model Specifications Version 2.3 Meta Data Relational Implementation

CREATE TABLE SELECT_TYPE
(
ENT_OR_TYPE_CODECHAR (3) NOT NULL REFERENCES REF_OBJECT (OBJ_TYPE),
ENT_OR_TYPE_SCHAR VARYING (19) NOT NULL,
PARENT_TYPE_DEF_SCHAR VARYING (19) NOT NULL REFERENCES TYPE_DEF (TYPE_DEF_S),
SELECT_TYPE_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
SOURCE_SCHAR VARYING (19) NOT NULL REFERENCES SOURCE (SOURCE_S)
)
ALTER TABLE SELECT_TYPE ADD (CONSTRAINT UNIQUE (parent_type_def_s, ent_or_type_code, ent_or_type_s))


© Copyright 1997-2001 POSC. All rights reserved.