gmDevi

CREATE INDEX icdw6_i05
ON dbacd1cdb.tcdw6_tk_ticket
USING BTREE (dbacd1cdb.immutable_to_char_date(cdw6_aprt_tck_dta, 'DD/MM/RRRR') ASC);

CREATE UNIQUE INDEX pkx_batch
ON dbacd1cdb.ds_pending_job
USING BTREE (batch_id ASC);

CREATE UNIQUE INDEX pkx_user_list
ON dbacd1cdb.ds_user_list

gmDevi

-- ------------ Write CREATE-FOREIGN-KEY-CONSTRAINT-stage scripts -----------

ALTER TABLE dbacd1cdb.tcd09_lc_cont_sede
ADD CONSTRAINT tcd01_tcd09 FOREIGN KEY (cd01_sede_cod) 
REFERENCES dbacd1cdb.tcd01_lc_sede (cd01_sede_cod)
ON DELETE NO ACTION;

ALTER TABLE dbacd1cdb.tcd09_lc_cont_sede
ADD CONSTRAINT tcd07_tcd09 FOREIGN KEY (cd07_cont_num) 
REFERENCES dbacd1cdb.tcd07_lc_contatto (cd07_cont_num)

gmDevi

-- Missing FOREIGN KEY
-- Generated by DDL Checker

-- Source: 21. create-foreign-key-constraint.sql
-- Table: tcdh9_ss_sede_pdr
ALTER TABLE dbacd1cdb.tcdh9_ss_sede_pdr
ADD CONSTRAINT tcd01_tcdh9 FOREIGN KEY (cd01_sede_cod)
REFERENCES dbacd1cdb.tcd01_lc_sede (cd01_sede_cod)
ON DELETE NO ACTION;

gmDevi

-- Missing FOREIGN KEY
-- Generated by DDL Checker

-- Source: 21. create-foreign-key-constraint.sql
-- Table: tcdh9_ss_sede_pdr
ALTER TABLE dbacd1cdb.tcdh9_ss_sede_pdr
ADD CONSTRAINT tcd01_tcdh9 FOREIGN KEY (cd01_sede_cod)
REFERENCES dbacd1cdb.tcd01_lc_sede (cd01_sede_cod)
ON DELETE NO ACTION;

gmDevi

-- FOREIGN KEY DDL statements
-- Total: 255
-- Generated by DDL Checker
-- Filter: missing

--------------------------------------------------------------------------------

-- dbacd1cdb.tcd00_tcdr1 [missing] (from 21. create-foreign-key-constraint.sql)
ALTER TABLE dbacd1cdb.tcdr1_ti_sede
ADD CONSTRAINT tcd00_tcdr1 FOREIGN KEY (cd00_cust_cod)