POSC Meta Model Specifications Version 2.3 Meta Data Relational Implementation

CREATE TABLE COLUMN_DEF
(
COLUMN_DEF_NMCHAR VARYING (40) NOT NULL,
COLUMN_DEF_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
DUPLICATE_FROM_SCHAR VARYING (19) REFERENCES COLUMN_DEF (COLUMN_DEF_S),
DUPLICATE_THRU_SCHAR VARYING (19) REFERENCES ATTRIBUTE (ATTRIBUTE_S),
FIXED_LENGTHCHAR (1),
MAX_LENGTHINTEGER,
OPTIONALITYCHAR (1) NOT NULL,
PARENT_TABLE_SCHAR VARYING (19) NOT NULL REFERENCES TABLE_DEF (TABLE_DEF_S),
PART_OF_SICHAR (1) NOT NULL,
PROD_VERSN_SCHAR VARYING (19) NOT NULL REFERENCES PROD_VERSN (PROD_VERSN_S),
RELATED_COLUMN_SCHAR VARYING (19) REFERENCES COLUMN_DEF (COLUMN_DEF_S),
RELATED_ENT_SCHAR VARYING (19) REFERENCES ENTITY_DEF (ENTITY_DEF_S),
RELATED_TABLE_SCHAR VARYING (19) REFERENCES TABLE_DEF (TABLE_DEF_S),
SQL_TYPE_NMCHAR VARYING (40) NOT NULL REFERENCES SQL_TYPE (SQL_TYPE_NM),
TYPE_CODECHAR (1) NOT NULL
)
ALTER TABLE COLUMN_DEF ADD (CONSTRAINT UNIQUE (parent_table_s, column_def_nm))
CREATE INDEX index_column_def1 ON column_def (related_ent_s)
CREATE INDEX index_column_def2 ON column_def (related_table_s);


© Copyright 1997-2001 POSC. All rights reserved.