POSC Meta Model Specifications Version 2.3 Meta Data Relational Implementation

CREATE TABLE ENUM_TYPE
(
ENUM_TYPE_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
LIST_MEMBERCHAR VARYING (40) NOT NULL,
PARENT_TYPE_DEF_SCHAR VARYING (19) NOT NULL REFERENCES TYPE_DEF (TYPE_DEF_S),
SOURCE_SCHAR VARYING (19) NOT NULL REFERENCES SOURCE (SOURCE_S)
)
ALTER TABLE ENUM_TYPE ADD (CONSTRAINT UNIQUE (parent_type_def_s, list_member))


© Copyright 1997-2001 POSC. All rights reserved.