CREATE TABLE AK_ATTR (
       ent_id               NUMBER(8) NOT NULL,
       attr_ix              NUMBER(6) NOT NULL,
       ak_ix                NUMBER(2) NOT NULL
);


ALTER TABLE AK_ATTR
       ADD  ( PRIMARY KEY (ent_id, attr_ix, ak_ix) ) ;


CREATE TABLE ALT_KEY (
       ent_id               NUMBER(8) NOT NULL,
       ak_ix                NUMBER(2) NOT NULL,
       ak_nr                NUMBER(3) NOT NULL,
       uniq_ind             VARCHAR(2) NOT NULL
                                   CHECK (uniq_ind IN ('AU', 'MU'))
);


ALTER TABLE ALT_KEY
       ADD  ( PRIMARY KEY (ent_id, ak_ix) ) ;


CREATE TABLE ATTR (
       ent_id               NUMBER(8) NOT NULL,
       attr_ix              NUMBER(6) NOT NULL,
       attr_na              VARCHAR(160) NOT NULL,
       col_na               VARCHAR(30) NOT NULL,
       attr_snr             NUMBER(3) NULL,
       pk_ind               VARCHAR(2) NOT NULL
                                   CHECK (pk_ind IN ('NK', 'PK')),
       fk_ind               VARCHAR(2) NOT NULL
                                   CHECK (fk_ind IN ('BA', 'FK')),
       stdn_lvl_co          VARCHAR(4) NOT NULL
);


ALTER TABLE ATTR
       ADD  ( PRIMARY KEY (ent_id, attr_ix) ) ;


CREATE TABLE BASE_ATTR (
       ent_id               NUMBER(8) NOT NULL,
       attr_ix              NUMBER(6) NOT NULL,
       base_def_txt         VARCHAR(255) NOT NULL,
       daty_dsc             VARCHAR(20) NOT NULL,
       dom_id               NUMBER(9) NOT NULL,
       dflt_val_ix          NUMBER(7) NULL
);


ALTER TABLE BASE_ATTR
       ADD  ( PRIMARY KEY (ent_id, attr_ix) ) ;


CREATE TABLE CARD_REL (
       pa_ent_id            NUMBER(8) NOT NULL,
       ch_ent_id            NUMBER(8) NOT NULL,
       rel_ix               NUMBER(2) NOT NULL,
       verb_na              VARCHAR(60) NOT NULL,
       inv_verb_na          VARCHAR(60) NULL,
       def_txt              VARCHAR(255) NULL,
       ident_ind            VARCHAR(2) NOT NULL
                                   CHECK (ident_ind IN ('ID', 'NI')),
       pa_card_co           VARCHAR(2) NOT NULL
                                   CHECK (pa_card_co IN ('OP', 'MA')),
       ch_card_co           VARCHAR(2) NOT NULL
                                   CHECK (ch_card_co IN ('EX', 'PO', 'RA', 'SP', 'ZM', 'ZO')),
       ch_min_card_cnt      NUMBER(3) NULL,
       ch_max_card_cnt      NUMBER(3) NULL
);


ALTER TABLE CARD_REL
       ADD  ( PRIMARY KEY (pa_ent_id, ch_ent_id, rel_ix) ) ;


CREATE TABLE CAT (
       sup_ent_id           NUMBER(8) NOT NULL,
       cat_ix               NUMBER(2) NOT NULL,
       def_txt              VARCHAR(255) NULL,
       discr_ix             NUMBER(6) NOT NULL,
       compl_ind            VARCHAR(2) NOT NULL
                                   CHECK (compl_ind IN ('CC', 'IC'))
);


ALTER TABLE CAT
       ADD  ( PRIMARY KEY (sup_ent_id, cat_ix) ) ;


CREATE TABLE DATA_OWNER (
       data_owner_id        NUMBER(11) NOT NULL,
       data_owner_name      VARCHAR(50) NOT NULL,
       data_owner_type_code VARCHAR(2) NULL
                                   CHECK (data_owner_type_code IN ('RD', 'ND')),
       encl_repl_org_id     NUMBER(12) NULL,
       remark_text          VARCHAR(255) NULL,
       last_update_seqnr    NUMBER(15) NULL
);


ALTER TABLE DATA_OWNER
       ADD  ( PRIMARY KEY (data_owner_id) ) ;


CREATE TABLE DOM (
       dom_id               NUMBER(9) NOT NULL,
       dom_na               VARCHAR(80) NOT NULL,
       def_txt              VARCHAR(255) NOT NULL,
       class_na             VARCHAR(16) NOT NULL,
       restr_ty_co          VARCHAR(2) NULL
                                   CHECK (restr_ty_co IN ('EN', 'FU', 'RA')),
       data_ty_co           VARCHAR(4) NOT NULL
                                   CHECK (data_ty_co IN ('CHAR', 'INT', 'REAL', 'TEXT')),
       data_len_cnt         NUMBER(4) NULL,
       data_dec_cnt         NUMBER(2) NULL,
       data_null_ind        VARCHAR(2) NOT NULL
                                   CHECK (data_null_ind IN ('NA', 'NN')),
       data_patt_dsc        VARCHAR(32) NULL,
       meas_unit_dsc        VARCHAR(32) NULL,
       pa_dom_id            NUMBER(9) NULL,
       stdn_lvl_co          VARCHAR(4) NOT NULL
                                   CHECK (stdn_lvl_co IN ('ATCO', 'ATSF', 'INAT', 'LOC', 'NAT')),
       mod_lvl_co           VARCHAR(4) NOT NULL
                                   CHECK (mod_lvl_co IN ('APPL', 'DICT', 'ARM'))
);


ALTER TABLE DOM
       ADD  ( PRIMARY KEY (dom_id) ) ;


CREATE TABLE DOM_DFLT_VAL (
       dom_id               NUMBER(9) NOT NULL,
       dflt_val_ix          NUMBER(7) NOT NULL
);


ALTER TABLE DOM_DFLT_VAL
       ADD  ( PRIMARY KEY (dom_id) ) ;


CREATE TABLE DOM_VAL (
       dom_id               NUMBER(9) NOT NULL,
       val_ix               NUMBER(7) NOT NULL,
       val_dsc              VARCHAR(32) NOT NULL,
       val_na               VARCHAR(80) NULL,
       def_txt              VARCHAR(255) NULL,
       val_snr              NUMBER(4) NULL,
       ty_co                VARCHAR(6) NOT NULL
                                   CHECK (ty_co IN ('DFLT', 'ELEM', 'EXAM', 'MAX-EX', 'MAX-IN', 'MIN-EX', 'MIN-IN')),
       stdn_lvl_co          VARCHAR(4) NOT NULL
                                   CHECK (stdn_lvl_co IN ('ATCO', 'ATSF', 'INAT', 'LOC', 'NAT'))
);


ALTER TABLE DOM_VAL
       ADD  ( PRIMARY KEY (dom_id, val_ix) ) ;


CREATE TABLE ENT (
       ent_id               NUMBER(8) NOT NULL,
       ent_na               VARCHAR(80) NOT NULL,
       tab_na               VARCHAR(24) NOT NULL,
       def_txt              VARCHAR(255) NOT NULL,
       depen_co             VARCHAR(2) NOT NULL
                                   CHECK (depen_co IN ('DE', 'IE', 'SE')),
       depth_cnt            NUMBER(3) NOT NULL,
       stg_ty_co            VARCHAR(4) NOT NULL
                                   CHECK (stg_ty_co IN ('LOG', 'STD')),
       stdn_lvl_co          VARCHAR(4) NOT NULL
                                   CHECK (stdn_lvl_co IN ('ATCO', 'ATSF', 'INAT', 'LOC', 'NAT')),
       mod_lvl_co           VARCHAR(4) NOT NULL
                                   CHECK (mod_lvl_co IN ('APPL', 'DICT', 'ARM'))
);


ALTER TABLE ENT
       ADD  ( PRIMARY KEY (ent_id) ) ;


CREATE TABLE FILTER_ATTR (
       rdc_id               NUMBER(12) NOT NULL,
       rdc_filter_index     NUMBER(12) NOT NULL,
       ent_id               NUMBER(8) NOT NULL,
       attr_ix              NUMBER(6) NOT NULL,
       vert_filter_effect_code VARCHAR(2) NOT NULL
                                   CHECK (vert_filter_effect_code IN ('NU', 'DF', 'RM'))
);


ALTER TABLE FILTER_ATTR
       ADD  ( PRIMARY KEY (rdc_id, rdc_filter_index, ent_id, attr_ix) ) ;


CREATE TABLE FILTER_ENTITY (
       rdc_id               NUMBER(12) NOT NULL,
       rdc_filter_index     NUMBER(12) NOT NULL,
       ent_id               NUMBER(8) NOT NULL,
       horiz_filter_descr   VARCHAR(255) NULL
);


ALTER TABLE FILTER_ENTITY
       ADD  ( PRIMARY KEY (rdc_id, rdc_filter_index, ent_id) ) ;


CREATE TABLE FILTER_PARAM (
       rdc_id               NUMBER(12) NOT NULL,
       rdc_filter_index     NUMBER(12) NOT NULL,
       filter_param_index   NUMBER(3) NOT NULL,
       param_nr             NUMBER(3) NOT NULL,
       param_name           VARCHAR(20) NOT NULL,
       param_def_text       VARCHAR(255) NULL
);


ALTER TABLE FILTER_PARAM
       ADD  ( PRIMARY KEY (rdc_id, rdc_filter_index, 
              filter_param_index) ) ;


CREATE TABLE FILTER_PARAM_FUNC (
       rdc_id               NUMBER(12) NOT NULL,
       repl_contr_index     NUMBER(12) NOT NULL,
       rdc_filter_index     NUMBER(12) NOT NULL,
       filter_param_index   NUMBER(3) NOT NULL,
       prov_node_id         NUMBER(9) NOT NULL,
       recv_node_id         NUMBER(9) NOT NULL,
       func_code            VARCHAR(4) NOT NULL
                                   CHECK (func_code IN ('BETW', 'DIFF', 'EQ', 'EXCL', 'EXST', 'GEQ', 'GREA', 'IN', 'LEQ', 'LESS', 'LIKE', 'NEQ', 'NULL', 'OUTS'))
);


ALTER TABLE FILTER_PARAM_FUNC
       ADD  ( PRIMARY KEY (rdc_id, repl_contr_index, rdc_filter_index, 
              filter_param_index, prov_node_id, recv_node_id) ) ;


CREATE TABLE FILTER_PARAM_VALUE (
       rdc_id               NUMBER(12) NOT NULL,
       repl_contr_index     NUMBER(12) NOT NULL,
       rdc_filter_index     NUMBER(12) NOT NULL,
       filter_param_index   NUMBER(3) NOT NULL,
       filter_param_value_index NUMBER(2) NOT NULL,
       prov_node_id         NUMBER(9) NOT NULL,
       recv_node_id         NUMBER(9) NOT NULL,
       value_seqnr          NUMBER(2) NOT NULL,
       value_descr          VARCHAR(255) NULL
);


ALTER TABLE FILTER_PARAM_VALUE
       ADD  ( PRIMARY KEY (rdc_id, repl_contr_index, rdc_filter_index, 
              filter_param_index, filter_param_value_index, 
              prov_node_id, recv_node_id) ) ;


CREATE TABLE FK_ATTR (
       host_ent_id          NUMBER(8) NOT NULL,
       attr_ix              NUMBER(6) NOT NULL,
       role_def_txt         VARCHAR(255) NULL,
       rona_ind             VARCHAR(2) NOT NULL
                                   CHECK (rona_ind IN ('MN', 'RN')),
       src_ent_id           NUMBER(8) NOT NULL,
       src_attr_ix          NUMBER(6) NOT NULL,
       migr_rel_ix          NUMBER(2) NOT NULL,
       base_ent_id          NUMBER(8) NOT NULL,
       base_attr_ix         NUMBER(6) NOT NULL,
       unif_attr_ix         NUMBER(6) NULL
);


ALTER TABLE FK_ATTR
       ADD  ( PRIMARY KEY (host_ent_id, attr_ix) ) ;


CREATE TABLE MGT_ERROR (
       src_node_id          NUMBER(9) NOT NULL,
       mgt_error_index      NUMBER(12) NOT NULL,
       creat_time           NUMBER(14) NOT NULL,
       r_data_id_descr      NUMBER(9) NULL,
       reason_code          VARCHAR(3) NOT NULL
                                   CHECK (reason_code IN (010, 020, 030, 040, 050, 070, 100, 110, 111, 113, 114, 120, 121, 122, 123, 124, 125, 130, 131, 210, 220, 221, 230, 231, 240, 241, 242, 243, 244, 250, 251, 252, 260, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 312, 311, 313, 317, 318, 321, 400)),
       severity_code        VARCHAR(2) NOT NULL
                                   CHECK (severity_code IN (1, 2, 3, 4, 5, 6)),
       extra_info_descr     VARCHAR(255) NULL,
       op_type_code         CHAR(1) NOT NULL
                                   CHECK (op_type_code IN ('I', 'U', 'D')),
       ent_id               NUMBER(8) NULL,
       attr_ix              NUMBER(6) NULL,
       primary_key_descr    VARCHAR(255) NULL,
       refd_src_node_id     NUMBER(9) NULL,
       refd_mgt_event_index NUMBER(12) NULL
);


ALTER TABLE MGT_ERROR
       ADD  ( PRIMARY KEY (src_node_id, mgt_error_index) ) ;


CREATE TABLE MGT_EVENT (
       src_node_id          NUMBER(9) NOT NULL,
       mgt_event_index      NUMBER(12) NOT NULL,
       event_type_code      VARCHAR(2) NOT NULL
                                   CHECK (event_type_code IN ('CA', 'CD', 'CP', 'CS', 'EV', 'MR', 'NA', 'NS', 'OA', 'OD', 'OR', 'OS', 'RS', 'SS')),
       event_subtype_code   VARCHAR(4) NULL
                                   CHECK (event_subtype_code IN ('NE', 'PO', 'PC', 'NC')),
       creat_time           NUMBER(14) NOT NULL,
       start_time           NUMBER(14) NULL,
       confirm_indic        CHAR(1) NOT NULL
                                   CHECK (confirm_indic IN ('N', 'Y')),
       extra_info_descr     VARCHAR(255) NULL,
       refd_src_node_id     NUMBER(9) NULL,
       refd_mgt_event_index NUMBER(12) NULL
);


ALTER TABLE MGT_EVENT
       ADD  ( PRIMARY KEY (src_node_id, mgt_event_index) ) ;


CREATE TABLE MGT_UPDATE (
       src_node_id          NUMBER(9) NOT NULL,
       mgt_event_index      NUMBER(12) NOT NULL,
       mgt_update_index     NUMBER(3) NOT NULL,
       mgt_ent_id           NUMBER(8) NOT NULL,
       op_type_code         CHAR(1) NOT NULL
                                   CHECK (op_type_code IN ('I', 'U', 'D')),
       record_descr         VARCHAR(255) NULL
);


ALTER TABLE MGT_UPDATE
       ADD  ( PRIMARY KEY (src_node_id, mgt_event_index, 
              mgt_update_index) ) ;


CREATE TABLE NK_ATTR (
       ent_id               NUMBER(8) NOT NULL,
       attr_ix              NUMBER(6) NOT NULL,
       opt_ind              VARCHAR(2) NOT NULL
                                   CHECK (opt_ind IN ('MA', 'OP'))
);


ALTER TABLE NK_ATTR
       ADD  ( PRIMARY KEY (ent_id, attr_ix) ) ;


CREATE TABLE NODE_ADDR (
       repl_node_id         NUMBER(9) NOT NULL,
       xfer_fac_id          NUMBER(10) NOT NULL,
       node_addr_index      NUMBER(2) NOT NULL,
       addr_descr           VARCHAR(255) NOT NULL
);


ALTER TABLE NODE_ADDR
       ADD  ( PRIMARY KEY (repl_node_id, xfer_fac_id, node_addr_index) ) ;


CREATE TABLE NODE_ADDR_LINK (
       src_node_id          NUMBER(9) NOT NULL,
       dst_node_id          NUMBER(9) NOT NULL,
       xfer_fac_id          NUMBER(10) NOT NULL,
       dst_addr_index       NUMBER(2) NOT NULL,
       src_addr_index       NUMBER(2) NULL,
       prio_seqnr           NUMBER(2) NOT NULL
);


ALTER TABLE NODE_ADDR_LINK
       ADD  ( PRIMARY KEY (src_node_id, dst_node_id, xfer_fac_id, 
              dst_addr_index) ) ;


CREATE TABLE NODE_LINK (
       src_node_id          NUMBER(9) NOT NULL,
       dst_node_id          NUMBER(9) NOT NULL,
       dst_node_link_status_code VARCHAR(2) NOT NULL
                                   CHECK (dst_node_link_status_code IN ('AC', 'IN', 'MA')),
       last_r_data_id_descr NUMBER(9) NULL
);


ALTER TABLE NODE_LINK
       ADD  ( PRIMARY KEY (src_node_id, dst_node_id) ) ;


CREATE TABLE NODE_MGR (
       node_mgr_id          NUMBER(12) NOT NULL,
       contact_descr        VARCHAR(100) NULL
);


ALTER TABLE NODE_MGR
       ADD  ( PRIMARY KEY (node_mgr_id) ) ;


CREATE TABLE NON_REPL_DATA_OWNER (
       non_repl_data_owner_id NUMBER(11) NOT NULL,
       non_repl_data_type_name VARCHAR(50) NULL
);


ALTER TABLE NON_REPL_DATA_OWNER
       ADD  ( PRIMARY KEY (non_repl_data_owner_id) ) ;


CREATE TABLE PK_ATTR (
       ent_id               NUMBER(8) NOT NULL,
       attr_ix              NUMBER(6) NOT NULL
);


ALTER TABLE PK_ATTR
       ADD  ( PRIMARY KEY (ent_id, attr_ix) ) ;


CREATE TABLE RDC (
       rdc_id               NUMBER(12) NOT NULL,
       rdc_name             VARCHAR(50) NOT NULL,
       def_text             VARCHAR(255) NULL
);


ALTER TABLE RDC
       ADD  ( PRIMARY KEY (rdc_id) ) ;


CREATE TABLE RDC_ELEM (
       rdc_id               NUMBER(12) NOT NULL,
       rdt_id               NUMBER(8) NOT NULL
);


ALTER TABLE RDC_ELEM
       ADD  ( PRIMARY KEY (rdc_id, rdt_id) ) ;


CREATE TABLE RDC_FILTER (
       rdc_id               NUMBER(12) NOT NULL,
       rdc_filter_index     NUMBER(12) NOT NULL,
       filter_name          VARCHAR(50) NOT NULL,
       def_text             VARCHAR(255) NULL
);


ALTER TABLE RDC_FILTER
       ADD  ( PRIMARY KEY (rdc_id, rdc_filter_index) ) ;


CREATE TABLE RDT (
       rdt_id               NUMBER(8) NOT NULL,
       rdt_name             VARCHAR(80) NOT NULL
);


ALTER TABLE RDT
       ADD  ( PRIMARY KEY (rdt_id) ) ;


CREATE TABLE RDT_ELEM (
       rdt_id               NUMBER(8) NOT NULL,
       ent_id               NUMBER(8) NOT NULL
);


ALTER TABLE RDT_ELEM
       ADD  ( PRIMARY KEY (rdt_id, ent_id) ) ;


CREATE TABLE REL (
       pa_ent_id            NUMBER(8) NOT NULL,
       ch_ent_id            NUMBER(8) NOT NULL,
       rel_ix               NUMBER(2) NOT NULL,
       ty_co                VARCHAR(2) NOT NULL
                                   CHECK (ty_co IN ('CR', 'SR'))
);


ALTER TABLE REL
       ADD  ( PRIMARY KEY (pa_ent_id, ch_ent_id, rel_ix) ) ;


CREATE TABLE REPL_CONTR (
       prov_node_id         NUMBER(9) NOT NULL,
       rdc_id               NUMBER(12) NOT NULL,
       repl_contr_index     NUMBER(12) NOT NULL,
       recv_node_id         NUMBER(9) NOT NULL,
       contr_name           VARCHAR(50) NOT NULL,
       content_text         VARCHAR(255) NULL,
       cnstrnt_text         VARCHAR(255) NULL,
       remark_text          VARCHAR(255) NULL,
       rdc_filter_index     NUMBER(12) NULL,
       status_code          VARCHAR(2) NOT NULL
                                   CHECK (status_code IN ('AC', 'IN'))
);


ALTER TABLE REPL_CONTR
       ADD  ( PRIMARY KEY (rdc_id, repl_contr_index, prov_node_id, 
              recv_node_id) ) ;


CREATE TABLE REPL_DATA_OWNER (
       repl_data_owner_id   NUMBER(11) NOT NULL,
       resid_node_id        NUMBER(9) NULL
);


ALTER TABLE REPL_DATA_OWNER
       ADD  ( PRIMARY KEY (repl_data_owner_id) ) ;


CREATE TABLE REPL_NODE (
       repl_node_id         NUMBER(9) NOT NULL,
       node_name            VARCHAR(50) NOT NULL,
       func_name            VARCHAR(10) NULL,
       role_name            VARCHAR(10) NULL,
       status_code          VARCHAR(2) NOT NULL
                                   CHECK (status_code IN ('AC', 'IN', 'MA')),
       node_mgr_id          NUMBER(12) NULL,
       encl_repl_org_id     NUMBER(12) NULL,
       ades_version_descr   VARCHAR(10) NOT NULL,
       repl_prot_version_descr VARCHAR(10) NOT NULL,
       remark_text          VARCHAR(255) NULL
);

CREATE INDEX XIE1REPL_NODE ON REPL_NODE
(
       node_name                      ASC,
       repl_node_id                   ASC
);


ALTER TABLE REPL_NODE
       ADD  ( PRIMARY KEY (repl_node_id) ) ;


CREATE TABLE REPL_ORG (
       repl_org_id          NUMBER(12) NOT NULL,
       repl_org_name        VARCHAR(50) NOT NULL,
       org_type_code        VARCHAR(2) NULL
                                   CHECK (org_type_code IN ('NM')),
       similar_org_id_descr NUMBER(15) NULL
);

CREATE INDEX XIE1REPL_ORG ON REPL_ORG
(
       repl_org_name                  ASC,
       repl_org_id                    ASC
);


ALTER TABLE REPL_ORG
       ADD  ( PRIMARY KEY (repl_org_id) ) ;


CREATE TABLE REPL_SUBSCR (
       prov_node_id         NUMBER(9) NOT NULL,
       recv_node_id         NUMBER(9) NOT NULL,
       status_code          VARCHAR(2) NOT NULL
                                   CHECK (status_code IN ('AC', 'IN'))
);


ALTER TABLE REPL_SUBSCR
       ADD  ( PRIMARY KEY (prov_node_id, recv_node_id) ) ;


CREATE TABLE SUBJ_VIEW (
       view_id              NUMBER(6) NULL,
       view_na              VARCHAR(50) NOT NULL,
       def_txt              VARCHAR(255) NULL,
       stdn_lvl_co          VARCHAR(4) NOT NULL
                                   CHECK (stdn_lvl_co IN ('ATCO', 'ATSF', 'INAT', 'LOC', 'NAT')),
       mod_lvl_co           VARCHAR(4) NOT NULL
                                   CHECK (mod_lvl_co IN ('APPL', 'DICT', 'ARM'))
);


ALTER TABLE SUBJ_VIEW
       ADD  ( PRIMARY KEY (view_id) ) ;


CREATE TABLE SUBT_REL (
       sup_ent_id           NUMBER(8) NOT NULL,
       sub_ent_id           NUMBER(8) NOT NULL,
       rel_ix               NUMBER(2) NOT NULL,
       cat_ix               NUMBER(2) NOT NULL
);


ALTER TABLE SUBT_REL
       ADD  ( PRIMARY KEY (sup_ent_id, sub_ent_id, rel_ix) ) ;


CREATE TABLE VIEW_ENT (
       view_id              NUMBER(6) NOT NULL,
       ent_id               NUMBER(8) NOT NULL
);


ALTER TABLE VIEW_ENT
       ADD  ( PRIMARY KEY (view_id, ent_id) ) ;


CREATE TABLE XFER_FAC (
       xfer_fac_id          NUMBER(10) NOT NULL,
       xfer_fac_name        VARCHAR(50) NOT NULL,
       profile_descr        VARCHAR(255) NOT NULL
);


ALTER TABLE XFER_FAC
       ADD  ( PRIMARY KEY (xfer_fac_id) ) ;


ALTER TABLE AK_ATTR
       ADD  ( FOREIGN KEY (ent_id, attr_ix)
                             REFERENCES ATTR ) ;


ALTER TABLE AK_ATTR
       ADD  ( FOREIGN KEY (ent_id, ak_ix)
                             REFERENCES ALT_KEY ) ;


ALTER TABLE ALT_KEY
       ADD  ( FOREIGN KEY (ent_id)
                             REFERENCES ENT ) ;


ALTER TABLE ATTR
       ADD  ( FOREIGN KEY (ent_id)
                             REFERENCES ENT ) ;


ALTER TABLE BASE_ATTR
       ADD  ( FOREIGN KEY (ent_id, attr_ix)
                             REFERENCES ATTR
                             ON DELETE CASCADE ) ;


ALTER TABLE BASE_ATTR
       ADD  ( FOREIGN KEY (dom_id, dflt_val_ix)
                             REFERENCES DOM_VAL ) ;


ALTER TABLE BASE_ATTR
       ADD  ( FOREIGN KEY (dom_id)
                             REFERENCES DOM ) ;


ALTER TABLE CARD_REL
       ADD  ( FOREIGN KEY (pa_ent_id, ch_ent_id, rel_ix)
                             REFERENCES REL
                             ON DELETE CASCADE ) ;


ALTER TABLE CAT
       ADD  ( FOREIGN KEY (sup_ent_id, discr_ix)
                             REFERENCES ATTR ) ;


ALTER TABLE CAT
       ADD  ( FOREIGN KEY (sup_ent_id)
                             REFERENCES ENT ) ;


ALTER TABLE DATA_OWNER
       ADD  ( FOREIGN KEY (encl_repl_org_id)
                             REFERENCES REPL_ORG ) ;


ALTER TABLE DOM
       ADD  ( FOREIGN KEY (pa_dom_id)
                             REFERENCES DOM ) ;


ALTER TABLE DOM_DFLT_VAL
       ADD  ( FOREIGN KEY (dom_id, dflt_val_ix)
                             REFERENCES DOM_VAL ) ;


ALTER TABLE DOM_DFLT_VAL
       ADD  ( FOREIGN KEY (dom_id)
                             REFERENCES DOM ) ;


ALTER TABLE DOM_VAL
       ADD  ( FOREIGN KEY (dom_id)
                             REFERENCES DOM ) ;


ALTER TABLE FILTER_ATTR
       ADD  ( FOREIGN KEY (ent_id, attr_ix)
                             REFERENCES ATTR ) ;


ALTER TABLE FILTER_ATTR
       ADD  ( FOREIGN KEY (rdc_id, rdc_filter_index, ent_id)
                             REFERENCES FILTER_ENTITY ) ;


ALTER TABLE FILTER_ENTITY
       ADD  ( FOREIGN KEY (ent_id)
                             REFERENCES ENT ) ;


ALTER TABLE FILTER_ENTITY
       ADD  ( FOREIGN KEY (rdc_id, rdc_filter_index)
                             REFERENCES RDC_FILTER ) ;


ALTER TABLE FILTER_PARAM
       ADD  ( FOREIGN KEY (rdc_id, rdc_filter_index)
                             REFERENCES RDC_FILTER ) ;


ALTER TABLE FILTER_PARAM_FUNC
       ADD  ( FOREIGN KEY (rdc_id, rdc_filter_index, 
              filter_param_index)
                             REFERENCES FILTER_PARAM ) ;


ALTER TABLE FILTER_PARAM_FUNC
       ADD  ( FOREIGN KEY (rdc_id, repl_contr_index, prov_node_id, 
              recv_node_id)
                             REFERENCES REPL_CONTR ) ;


ALTER TABLE FILTER_PARAM_VALUE
       ADD  ( FOREIGN KEY (rdc_id, repl_contr_index, rdc_filter_index, 
              filter_param_index, prov_node_id, recv_node_id)
                             REFERENCES FILTER_PARAM_FUNC ) ;


ALTER TABLE FK_ATTR
       ADD  ( FOREIGN KEY (src_ent_id, src_attr_ix)
                             REFERENCES PK_ATTR ) ;


ALTER TABLE FK_ATTR
       ADD  ( FOREIGN KEY (host_ent_id, attr_ix)
                             REFERENCES ATTR
                             ON DELETE CASCADE ) ;


ALTER TABLE FK_ATTR
       ADD  ( FOREIGN KEY (src_ent_id, host_ent_id, migr_rel_ix)
                             REFERENCES REL ) ;


ALTER TABLE FK_ATTR
       ADD  ( FOREIGN KEY (base_ent_id, base_attr_ix)
                             REFERENCES BASE_ATTR ) ;


ALTER TABLE FK_ATTR
       ADD  ( FOREIGN KEY (host_ent_id, unif_attr_ix)
                             REFERENCES FK_ATTR ) ;


ALTER TABLE MGT_ERROR
       ADD  ( FOREIGN KEY (ent_id)
                             REFERENCES ENT ) ;


ALTER TABLE MGT_ERROR
       ADD  ( FOREIGN KEY (ent_id, attr_ix)
                             REFERENCES ATTR ) ;


ALTER TABLE MGT_ERROR
       ADD  ( FOREIGN KEY (refd_src_node_id, refd_mgt_event_index)
                             REFERENCES MGT_EVENT ) ;


ALTER TABLE MGT_ERROR
       ADD  ( FOREIGN KEY (src_node_id)
                             REFERENCES REPL_NODE ) ;


ALTER TABLE MGT_EVENT
       ADD  ( FOREIGN KEY (refd_src_node_id, refd_mgt_event_index)
                             REFERENCES MGT_EVENT ) ;


ALTER TABLE MGT_EVENT
       ADD  ( FOREIGN KEY (src_node_id)
                             REFERENCES REPL_NODE ) ;


ALTER TABLE MGT_UPDATE
       ADD  ( FOREIGN KEY (mgt_ent_id)
                             REFERENCES ENT ) ;


ALTER TABLE MGT_UPDATE
       ADD  ( FOREIGN KEY (src_node_id, mgt_event_index)
                             REFERENCES MGT_EVENT ) ;


ALTER TABLE NK_ATTR
       ADD  ( FOREIGN KEY (ent_id, attr_ix)
                             REFERENCES ATTR
                             ON DELETE CASCADE ) ;


ALTER TABLE NODE_ADDR
       ADD  ( FOREIGN KEY (xfer_fac_id)
                             REFERENCES XFER_FAC ) ;


ALTER TABLE NODE_ADDR
       ADD  ( FOREIGN KEY (repl_node_id)
                             REFERENCES REPL_NODE ) ;


ALTER TABLE NODE_ADDR_LINK
       ADD  ( FOREIGN KEY (xfer_fac_id)
                             REFERENCES XFER_FAC ) ;


ALTER TABLE NODE_ADDR_LINK
       ADD  ( FOREIGN KEY (src_node_id, xfer_fac_id, src_addr_index)
                             REFERENCES NODE_ADDR ) ;


ALTER TABLE NODE_ADDR_LINK
       ADD  ( FOREIGN KEY (dst_node_id, xfer_fac_id, dst_addr_index)
                             REFERENCES NODE_ADDR ) ;


ALTER TABLE NODE_ADDR_LINK
       ADD  ( FOREIGN KEY (src_node_id, dst_node_id)
                             REFERENCES NODE_LINK ) ;


ALTER TABLE NODE_LINK
       ADD  ( FOREIGN KEY (dst_node_id)
                             REFERENCES REPL_NODE ) ;


ALTER TABLE NODE_LINK
       ADD  ( FOREIGN KEY (src_node_id)
                             REFERENCES REPL_NODE ) ;


ALTER TABLE NODE_MGR
       ADD  ( FOREIGN KEY (node_mgr_id)
                             REFERENCES REPL_ORG
                             ON DELETE CASCADE ) ;


ALTER TABLE NON_REPL_DATA_OWNER
       ADD  ( FOREIGN KEY (non_repl_data_owner_id)
                             REFERENCES DATA_OWNER
                             ON DELETE CASCADE ) ;


ALTER TABLE PK_ATTR
       ADD  ( FOREIGN KEY (ent_id, attr_ix)
                             REFERENCES ATTR
                             ON DELETE CASCADE ) ;


ALTER TABLE RDC_ELEM
       ADD  ( FOREIGN KEY (rdt_id)
                             REFERENCES RDT ) ;


ALTER TABLE RDC_ELEM
       ADD  ( FOREIGN KEY (rdc_id)
                             REFERENCES RDC ) ;


ALTER TABLE RDC_FILTER
       ADD  ( FOREIGN KEY (rdc_id)
                             REFERENCES RDC ) ;


ALTER TABLE RDT
       ADD  ( FOREIGN KEY (rdt_id)
                             REFERENCES ENT ) ;


ALTER TABLE RDT_ELEM
       ADD  ( FOREIGN KEY (ent_id)
                             REFERENCES ENT ) ;


ALTER TABLE RDT_ELEM
       ADD  ( FOREIGN KEY (rdt_id)
                             REFERENCES RDT ) ;


ALTER TABLE REL
       ADD  ( FOREIGN KEY (pa_ent_id)
                             REFERENCES ENT ) ;


ALTER TABLE REL
       ADD  ( FOREIGN KEY (ch_ent_id)
                             REFERENCES ENT ) ;


ALTER TABLE REPL_CONTR
       ADD  ( FOREIGN KEY (prov_node_id, recv_node_id)
                             REFERENCES REPL_SUBSCR ) ;


ALTER TABLE REPL_CONTR
       ADD  ( FOREIGN KEY (rdc_id, rdc_filter_index)
                             REFERENCES RDC_FILTER ) ;


ALTER TABLE REPL_CONTR
       ADD  ( FOREIGN KEY (rdc_id)
                             REFERENCES RDC ) ;


ALTER TABLE REPL_DATA_OWNER
       ADD  ( FOREIGN KEY (resid_node_id)
                             REFERENCES REPL_NODE ) ;


ALTER TABLE REPL_DATA_OWNER
       ADD  ( FOREIGN KEY (repl_data_owner_id)
                             REFERENCES DATA_OWNER
                             ON DELETE CASCADE ) ;


ALTER TABLE REPL_NODE
       ADD  ( FOREIGN KEY (encl_repl_org_id)
                             REFERENCES REPL_ORG ) ;


ALTER TABLE REPL_NODE
       ADD  ( FOREIGN KEY (node_mgr_id)
                             REFERENCES NODE_MGR ) ;


ALTER TABLE REPL_SUBSCR
       ADD  ( FOREIGN KEY (recv_node_id)
                             REFERENCES REPL_NODE ) ;


ALTER TABLE REPL_SUBSCR
       ADD  ( FOREIGN KEY (prov_node_id)
                             REFERENCES REPL_NODE ) ;


ALTER TABLE SUBT_REL
       ADD  ( FOREIGN KEY (sup_ent_id, cat_ix)
                             REFERENCES CAT ) ;


ALTER TABLE SUBT_REL
       ADD  ( FOREIGN KEY (sup_ent_id, sub_ent_id, rel_ix)
                             REFERENCES REL
                             ON DELETE CASCADE ) ;


ALTER TABLE VIEW_ENT
       ADD  ( FOREIGN KEY (ent_id)
                             REFERENCES ENT ) ;


ALTER TABLE VIEW_ENT
       ADD  ( FOREIGN KEY (view_id)
                             REFERENCES SUBJ_VIEW ) ;