DROP TABLE ANA; CREATE TABLE ANA ( nr_indi NUMBER(10,0) NOT NULL, cognome CHAR(30), nome CHAR(35), pat_cog CHAR(30), pat_nom CHAR(35), mat_cog CHAR(30), mat_nom CHAR(35), nr_fami NUMBER(10,0), nr_conv NUMBER(5,0), loc_nas NUMBER(10,0), dt_nas DATE, ann_nas NUMBER(5,0), ora_nas NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), atn_ann NUMBER(5,0), atn_ltr NUMBER(10,0), atn_ntr NUMBER(10,0), atn_atr NUMBER(5,0), sesso CHAR(1), cod_fis CHAR(16), rap_par CHAR(2), profess NUMBER(10,0), tit_stu NUMBER(5,0), sta_civ CHAR(2), ind_via NUMBER(5,0), ind_num NUMBER(5,0), ind_let CHAR(6), ind_sca CHAR(1), ind_int NUMBER(5,0), cit_pos NUMBER(5,0), fl_sogg CHAR(1), fl_iscr NUMBER(5,0), fl_canc NUMBER(5,0), dt_iscr DATE, dt_canc DATE, prg_mor NUMBER(5,0), prg_con NUMBER(5,0), prg_div NUMBER(5,0), prg_cid NUMBER(5,0), prg_lav NUMBER(5,0), prg_pen NUMBER(5,0), prg_ct1 NUMBER(5,0), prg_ct2 NUMBER(5,0), prg_emi NUMBER(5,0), prg_res NUMBER(5,0), prg_air NUMBER(5,0), prg_imm NUMBER(5,0), prg_irr NUMBER(5,0), prg_sog NUMBER(5,0), prg_tem NUMBER(5,0), prg_est NUMBER(5,0), prg_pra NUMBER(5,0), prg_ann NUMBER(5,0), prg_gen NUMBER(5,0), fl_ele CHAR(1), fl_cf CHAR(1), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ana1 ON ANA (nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_ana2 ON ANA (cognome,nome,dt_nas) TABLESPACE WORKINGINDEX; CREATE INDEX i_ana3 ON ANA (atn_nr,atn_par,atn_ser,atn_ann) TABLESPACE WORKINGINDEX; CREATE INDEX i_ana4 ON ANA (nr_fami,fl_sogg) TABLESPACE WORKINGINDEX; CREATE INDEX i_ana5 ON ANA (cod_fis) TABLESPACE WORKINGINDEX; CREATE INDEX i_ana6 ON ANA (ind_via,ind_num,ind_let,ind_sca,ind_int) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE MOR; CREATE TABLE MOR ( nr_indi NUMBER(10,0), prg NUMBER(5,0), loc_mor NUMBER(10,0), dt_mor DATE, atm_nr NUMBER(10,0), atm_par CHAR(1), atm_ser CHAR(1), atm_uff NUMBER(5,0), atm_vol CHAR(1), atm_ann NUMBER(5,0), atm_ltr NUMBER(10,0), atm_ntr NUMBER(10,0), atm_atr NUMBER(5,0), causa CHAR(40) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_mor1 ON MOR (nr_indi,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_mor2 ON MOR (atm_nr,atm_par,atm_ser,atm_ann) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE MO1; CREATE TABLE MO1 ( nr_indi NUMBER(10,0), prg NUMBER(5,0), loc_mor NUMBER(10,0), dt_mor DATE, atm_nr NUMBER(10,0), atm_par CHAR(1), atm_ser CHAR(1), atm_uff NUMBER(5,0), atm_vol CHAR(1), atm_ann NUMBER(5,0), atm_ltr NUMBER(10,0), atm_ntr NUMBER(10,0), atm_atr NUMBER(5,0), causa CHAR(40) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_mo11 ON MO1 (nr_indi,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_mo12 ON MO1 (atm_nr,atm_par,atm_ser,atm_ann) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CON; CREATE TABLE CON ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_indc NUMBER(10,0), loc_mat NUMBER(10,0), dt_mat DATE, ann_mat NUMBER(5,0), atm_nr NUMBER(10,0), atm_par CHAR(1), atm_ser CHAR(1), atm_uff NUMBER(5,0), atm_vol CHAR(1), atm_ann NUMBER(5,0), atm_ltr NUMBER(10,0), atm_ntr NUMBER(10,0), atm_atr NUMBER(5,0), reg_pat CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_con1 ON CON (nr_indi,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_con2 ON CON (atm_nr,atm_par,atm_ser,atm_ann) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CO1; CREATE TABLE CO1 ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_indc NUMBER(10,0), loc_mat NUMBER(10,0), dt_mat DATE, ann_mat NUMBER(5,0), atm_nr NUMBER(10,0), atm_par CHAR(1), atm_ser CHAR(1), atm_uff NUMBER(5,0), atm_vol CHAR(1), atm_ann NUMBER(5,0), atm_ltr NUMBER(10,0), atm_ntr NUMBER(10,0), atm_atr NUMBER(5,0), reg_pat CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_co11 ON CO1 (nr_indi,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_co12 ON CO1 (atm_nr,atm_par,atm_ser,atm_ann) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE DIV; CREATE TABLE DIV ( nr_indi NUMBER(10,0), prg NUMBER(5,0), dt_div DATE, atd_nr NUMBER(10,0), atd_par CHAR(1), atd_ser CHAR(1), atd_uff NUMBER(5,0), atd_vol CHAR(1), atd_ann NUMBER(5,0), atd_ltr NUMBER(10,0), nr_sen1 NUMBER(10,0), dt_sen1 DATE, tri_est NUMBER(10,0), nr_sen2 NUMBER(10,0), dt_sen2 DATE, cap_tri NUMBER(10,0), tp_asc CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_div1 ON DIV (nr_indi,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_div2 ON DIV (atd_nr,atd_par,atd_ser,atd_ann) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CID; CREATE TABLE CID ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_cid CHAR(12), loc_ril NUMBER(10,0), dt_ril DATE, fl_espa CHAR(1), dt_vali DATE, dt_pror DATE, mot_emi NUMBER(5,0), fl_stm CHAR(1), fl_dupl CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cid1 ON CID (nr_indi,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_cid2 ON CID (nr_cid) TABLESPACE WORKINGINDEX; CREATE INDEX i_cid3 ON CID (dt_ril) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE C15; CREATE TABLE C15 ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_cid NUMBER(10,0), dt_ril DATE, dt_scad DATE, loc_ril NUMBER(10,0), tp CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_c15_1 ON C15 (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE LAV; CREATE TABLE LAV ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_llav NUMBER(10,0), dt_lav DATE, loc_lav NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_lav1 ON LAV (nr_indi,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_lav2 ON LAV (dt_lav) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PEN; CREATE TABLE PEN ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_lpe1 CHAR(12), catego1 CHAR(30), ent_er1 NUMBER(5,0), qua_pe1 CHAR(30), dt_ril DATE, note1 CHAR(62), note2 CHAR(62), note3 CHAR(62), note4 CHAR(62), note5 CHAR(62) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_pen1 ON PEN (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CT1; CREATE TABLE CT1 ( nr_indi NUMBER(10,0), prg NUMBER(5,0), cit_di1 NUMBER(5,0), cit_di2 NUMBER(5,0), cit_di3 NUMBER(5,0), con_arp NUMBER(5,0), dt_scad DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ct11 ON CT1 (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CT2; CREATE TABLE CT2 ( nr_indi NUMBER(10,0), prg NUMBER(5,0), dt_arp DATE, mt_arp NUMBER(5,0), atc_nr NUMBER(10,0), atc_uff NUMBER(5,0), atc_vol CHAR(1), atc_ann NUMBER(5,0), atc_loc NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ct21 ON CT2 (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE EMI; CREATE TABLE EMI ( nr_indi NUMBER(10,0), prg NUMBER(5,0), dt_emi DATE, loc_emi NUMBER(10,0), nr_prat NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_emi1 ON EMI (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE RES; CREATE TABLE RES ( nr_indi NUMBER(10,0), prg NUMBER(5,0), loc_res NUMBER(10,0), ind_res CHAR(60), consola NUMBER(10,0), cap CHAR(20) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_res1 ON RES (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE AIR; CREATE TABLE AIR ( nr_indi NUMBER(10,0), prg NUMBER(5,0), dt_isca DATE, mt_isca NUMBER(5,0), loc_pd NUMBER(10,0), nr_dist NUMBER(10,0), nr_prot NUMBER(10,0), com_isc NUMBER(5,0), in_isca NUMBER(5,0), dt_var DATE, mt_var NUMBER(5,0), nr_prot_v NUMBER(10,0), in_var NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_air1 ON AIR (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE IMM; CREATE TABLE IMM ( nr_indi NUMBER(10,0), prg NUMBER(5,0), dt_imm DATE, loc_pro NUMBER(10,0), nr_prat NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_imm1 ON IMM (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE IRR; CREATE TABLE IRR ( nr_indi NUMBER(10,0), prg NUMBER(5,0), dt_irr DATE, nr_prac NUMBER(10,0), loc_can NUMBER(10,0), dt_ric DATE, nr_prai NUMBER(10,0), loc_isc NUMBER(10,0), loc_ric NUMBER(10,0), tp_irr CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_irr1 ON IRR (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE SOG; CREATE TABLE SOG ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_doc CHAR(9), tp_doc CHAR(1), tp_ril CHAR(1), dt_ril DATE, dt_val DATE, loc_ril NUMBER(10,0), dt_scad DATE, dt_val_ini DATE, dt_invio DATE, dt_rinn DATE, dt_perm DATE, dt_tras DATE, nr_prot NUMBER(10,0), dt_ope DATE, stato CHAR(1), evento NUMBER(5,0), nr_indt NUMBER(10,0), prg_sogt NUMBER(5,0), nr_indf NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_sog1 ON SOG (nr_indi,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_sog2 ON SOG (nr_indt,prg_sogt) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE RIC; CREATE TABLE RIC ( nr_indi NUMBER(10,0), tp_ric CHAR(1), dt_ril DATE, note CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ric_1 ON RIC (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ARS; CREATE TABLE ARS ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_doc NUMBER(10,0), dt_ril DATE, loc_ril NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ars_1 ON ARS (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ASP; CREATE TABLE ASP ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_doc NUMBER(10,0), dt_ril DATE, loc_ril NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_asp_1 ON ASP (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TEM; CREATE TABLE TEM ( nr_indi NUMBER(10,0), prg NUMBER(5,0), cod_seg NUMBER(5,0), dt DATE, fl_fam CHAR(1), note CHAR(60), note2 CHAR(60), note3 CHAR(60), note4 CHAR(60), note5 CHAR(60) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_tem1 ON TEM (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE LEV; CREATE TABLE LEV ( nr_indi NUMBER(10,0), fl_corr CHAR(1), nr_defi NUMBER(10,0), ann_isc NUMBER(5,0), com_isc NUMBER(10,0), esi_vis NUMBER(5,0), dt_esiv DATE, loc_uml NUMBER(10,0), mt_canc NUMBER(5,0), dt_canc DATE, mt_aggi NUMBER(5,0), dt_aggi DATE, nr_aggi NUMBER(5,0), ann_agg NUMBER(5,0), nr_matr CHAR(20), corpo CHAR(40), categor CHAR(40), grado CHAR(40), dt_armi DATE, dt_cong DATE, mt_disp CHAR(40), dt_disp DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_lev1 ON LEV (nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_lev2 ON LEV (nr_defi,ann_isc) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE EST; CREATE TABLE EST ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_dese NUMBER(5,0), dt_dese DATE, loc_tri NUMBER(10,0), atv_nr NUMBER(10,0), atv_par CHAR(1), atv_ser CHAR(1), atv_uff NUMBER(5,0), atv_vol CHAR(1), atv_ann NUMBER(5,0), atv_ltr NUMBER(10,0), fl_vari CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_est1 ON EST (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ANN; CREATE TABLE ANN ( nr_indi NUMBER(10,0), prg NUMBER(5,0), dt_anno DATE, dt_att1 DATE, cn_not1 CHAR(40), loc_no1 NUMBER(10,0), dt_att2 DATE, cn_not2 CHAR(40), loc_no2 NUMBER(10,0), loc_tri NUMBER(10,0), dt_trib DATE, nr_sent NUMBER(5,0), dt_altr DATE, nr_indc NUMBER(10,0), fl_anno NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ann1 ON ANN (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRA; CREATE TABLE PRA ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_pram NUMBER(10,0), dt_pram DATE, fl_dich CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_pra1 ON PRA (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE GEN; CREATE TABLE GEN ( nr_indi NUMBER(10,0), prg NUMBER(5,0), cognome CHAR(60), nome CHAR(60), nom_suc CHAR(60), pat_cog CHAR(60), pat_nom CHAR(60), mat_cog CHAR(60), mat_nom CHAR(60) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_gen1 ON GEN (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PER; CREATE TABLE PER ( nr_indi NUMBER(10,0), statura NUMBER(3,2), capelli CHAR(15), occhi CHAR(15), seg_par CHAR(50) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_per1 ON PER (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CEN; CREATE TABLE CEN ( nr_indi NUMBER(10,0), ann_cen NUMBER(5,0), nr_famc NUMBER(10,0), nr_sezc NUMBER(5,0), fl_cens CHAR(1), prg NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cen1 ON CEN (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE AGG; CREATE TABLE AGG ( agg_tipo NUMBER(5,0), nr_indi1 NUMBER(10,0), nr_indi2 NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_agg1 ON AGG (agg_tipo) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELF; CREATE TABLE ELF ( nr_fami NUMBER(10,0) NOT NULL, nr_elif NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_elf1 ON ELF (nr_fami) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PTN; CREATE TABLE PTN ( nr_indi NUMBER(10,0), prg NUMBER(5,0), cod_eve NUMBER(5,0), dt_var DATE, dt_reg DATE, dt_tra DATE, nr_prot NUMBER(10,0), sg_ptn CHAR(2), nr_ptn CHAR(7), ct_ptn CHAR(1), catego CHAR(2), dt_ril DATE, tip_ve1 CHAR(1), tar_ve1 CHAR(8), tip_ve2 CHAR(1), tar_ve2 CHAR(8), tip_ve3 CHAR(1), tar_ve3 CHAR(8), tip_ve4 CHAR(1), tar_ve4 CHAR(8), tip_ve5 CHAR(1), tar_ve5 CHAR(8), tip_ve6 CHAR(1), tar_ve6 CHAR(8), tip_ve7 CHAR(1), tar_ve7 CHAR(8), tip_ve8 CHAR(1), tar_ve8 CHAR(8), tip_ve9 CHAR(1), tar_ve9 CHAR(8), tip_v10 CHAR(1), tar_v10 CHAR(8), tip_v11 CHAR(1), tar_v11 CHAR(8), tip_v12 CHAR(1), tar_v12 CHAR(8), tip_v13 CHAR(1), tar_v13 CHAR(8), tip_v14 CHAR(1), tar_v14 CHAR(8), tip_v15 CHAR(1), tar_v15 CHAR(8), tip_v16 CHAR(1), tar_v16 CHAR(8), tip_v17 CHAR(1), tar_v17 CHAR(8), tip_v18 CHAR(1), tar_v18 CHAR(8), tip_v19 CHAR(1), tar_v19 CHAR(8), tip_v20 CHAR(1), tar_v20 CHAR(8) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ptn1 ON PTN (nr_indi,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_ptn2 ON PTN (dt_tra) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE AP4; CREATE TABLE AP4 ( nr_indi NUMBER(10,0), nr_prat NUMBER(10,0), nr_ord NUMBER(5,0), dt_prat DATE, fl_cont CHAR(1), dt_deco DATE, istanza CHAR(1), motivo NUMBER(5,0), loc_pc NUMBER(10,0), com_pro NUMBER(10,0), dt_canc DATE, tp_irr CHAR(1), pos_pro CHAR(1), set_att CHAR(1), con_pro CHAR(1), tit_stu CHAR(1), dt_defi DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ap41 ON AP4 (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE AP42; CREATE TABLE AP42 ( nr_indi NUMBER(10,0), rap_par CHAR(2), nr_fami NUMBER(10,0), nr_conv NUMBER(10,0), ind_via NUMBER(5,0), ind_num NUMBER(5,0), ind_let CHAR(6), ind_sca CHAR(1), ind_int NUMBER(5,0), loc_res NUMBER(10,0), ind_res CHAR(60), consola NUMBER(10,0), cap CHAR(20), nr_indd NUMBER(10,0), mod_ric CHAR(72) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ap42_1 ON AP42 (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE NA2; CREATE TABLE NA2 ( nr_indi NUMBER(10,0), nr_indi_f NUMBER(10,0), dt_nas_f DATE, fl_tra CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_na2_1 ON NA2 (nr_indi,nr_indi_f) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE IP4; CREATE TABLE IP4 ( nr_indi NUMBER(10,0), nr_comp NUMBER(5,0), nr_sezc NUMBER(10,0), m_dt_nas DATE, m_sta_civ CHAR(2), m_cit_pos NUMBER(5,0), m_loc_res NUMBER(10,0), p_dt_nas DATE, p_sta_civ CHAR(2), p_cit_pos NUMBER(5,0), p_loc_res NUMBER(10,0), nr_comp_min NUMBER(5,0), m_cod_fis CHAR(16) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ip4 ON IP4 (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE NTG; CREATE TABLE NTG ( cod NUMBER(10,0), nr_indi NUMBER(10,0), cod_eve NUMBER(5,0), dt_even DATE, dt_tras DATE, nr_prot CHAR(3), esi_tra CHAR(1), ris_inp CHAR(1), pro_inp CHAR(12), dt_rinp DATE, ris_mct CHAR(1), pro_mct CHAR(12), dt_rmct DATE, ris_at CHAR(1), pro_at CHAR(12), dt_rat DATE, err_tra CHAR(100), pro_saia CHAR(12) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ntg1 ON NTG (cod) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ntg2 ON NTG (nr_indi,cod_eve,dt_even) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE SAE; CREATE TABLE SAE ( cod NUMBER(10,0), fl_ente CHAR(1), ente CHAR(6), dt_inol DATE, dt_pc DATE, pro_risp CHAR(20), cod_fis CHAR(16), msg_tipo CHAR(20), msg_cod CHAR(10), msg_testo CHAR(200), note CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_sae1 ON SAE (cod,fl_ente,ente) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE SAS; CREATE TABLE SAS ( cod NUMBER(10,0), fl_ente CHAR(1), ente CHAR(6), stato CHAR(1), dt_stato DATE, dt_inol DATE, pro_inol CHAR(20), dt_pc DATE, msg_tipo CHAR(20), msg_cod CHAR(10), msg_testo CHAR(200) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_sas1 ON SAS (cod,fl_ente,ente) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STL; CREATE TABLE STL ( cod NUMBER(10,0), nr_indi NUMBER(10,0), cod_eve NUMBER(5,0), dt_even DATE, dt_tras DATE, esi_tra CHAR(1), err_tra CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_stl1 ON STL (cod) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_stl2 ON STL (nr_indi,cod_eve,dt_even) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ST1; CREATE TABLE ST1 ( row_id NUMBER(10,0), nr_indi NUMBER(10,0) NOT NULL, dt_even DATE NOT NULL, nr_fami NUMBER(10,0), nr_conv NUMBER(5,0), rap_par CHAR(2), profess NUMBER(10,0), tit_stu NUMBER(5,0), sta_civ CHAR(2), ind_via NUMBER(5,0), ind_num NUMBER(5,0), ind_let CHAR(6), ind_sca CHAR(1), ind_int NUMBER(5,0), cit_pos NUMBER(5,0), fl_sogg CHAR(1), fl_iscr NUMBER(5,0), fl_canc NUMBER(5,0), dt_iscr DATE, dt_canc DATE, prg_mor NUMBER(5,0), prg_con NUMBER(5,0), prg_div NUMBER(5,0), prg_pen NUMBER(5,0), prg_ct1 NUMBER(5,0), prg_ct2 NUMBER(5,0), prg_emi NUMBER(5,0), prg_res NUMBER(5,0), prg_air NUMBER(5,0), prg_imm NUMBER(5,0), prg_irr NUMBER(5,0), prg_sog NUMBER(5,0), prg_tem NUMBER(5,0), prg_est NUMBER(5,0), prg_pra NUMBER(5,0), prg_ann NUMBER(5,0), fl_ele CHAR(1), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_st11 ON ST1 (nr_indi,dt_even) TABLESPACE WORKINGINDEX; CREATE INDEX i_st12 ON ST1 (nr_fami,fl_sogg,dt_even) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_st13 ON ST1 (row_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_st14 ON ST1 (fl_ele) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ST2; CREATE TABLE ST2 ( row_id NUMBER(10,0), nr_indi NUMBER(10,0) NOT NULL, dt_even DATE NOT NULL, cognome CHAR(30), nome CHAR(35), pat_cog CHAR(30), pat_nom CHAR(35), mat_cog CHAR(30), mat_nom CHAR(35), loc_nas NUMBER(10,0), dt_nas DATE, ann_nas NUMBER(5,0), ora_nas NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), atn_ann NUMBER(5,0), atn_ltr NUMBER(10,0), atn_ntr NUMBER(10,0), atn_atr NUMBER(5,0), sesso CHAR(1), cod_fis CHAR(16), fl_ele CHAR(1), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_st21 ON ST2 (nr_indi,dt_even) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_st22 ON ST2 (row_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_st23 ON ST2 (fl_ele) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ST3; CREATE TABLE ST3 ( tp CHAR(1), row_id NUMBER(10,0), nr_indi NUMBER(10,0), dt_even DATE, cod_eve NUMBER(5,0), cod_ute CHAR(30) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_st31 ON ST3 (tp,row_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE FA2; CREATE TABLE FA2 ( nr_fami NUMBER(10,0), fl_sogg CHAR(1), nr_indi NUMBER(10,0), ordine NUMBER(5,0), dt_ini DATE, dt_fin DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_fa21 ON FA2 (nr_fami,fl_sogg,nr_indi,dt_ini) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PSW; CREATE TABLE PSW ( proced CHAR(2) NOT NULL, utente CHAR(8), str CHAR(400) NOT NULL ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_psw ON PSW (proced,utente) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ERR; CREATE TABLE ERR ( nr NUMBER(5,0), des CHAR(65), grav NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_err1 ON ERR (nr) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE MES; CREATE TABLE MES ( nr NUMBER(5,0), des CHAR(78) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_mes1 ON MES (nr) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE COM; CREATE TABLE COM ( nr_prov NUMBER(5,0), nr_comu NUMBER(5,0), cap CHAR(5), des CHAR(33), sg_prov CHAR(2), trib CHAR(33), cod_cf CHAR(4) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_com1 ON COM (nr_prov,nr_comu) TABLESPACE WORKINGINDEX; CREATE INDEX i_com2 ON COM (des) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRV; CREATE TABLE PRV ( cod NUMBER(5,0), des CHAR(20) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prv1 ON PRV (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CST; CREATE TABLE CST ( nr_stat NUMBER(5,0), nr_comu NUMBER(5,0), des CHAR(33), cap CHAR(8), cod_ter NUMBER(5,0), cod_cns NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cst1 ON CST (nr_stat,nr_comu) TABLESPACE WORKINGINDEX; CREATE INDEX i_cst2 ON CST (des) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE NAZ; CREATE TABLE NAZ ( nr_stat NUMBER(5,0), sg_stat CHAR(3), fl_ex CHAR(1), des_sta CHAR(25), des_cit CHAR(20), cod_cf CHAR(4), nr_cons NUMBER(5,0), cod_mct CHAR(3), cod_ist NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_naz1 ON NAZ (nr_stat) TABLESPACE WORKINGINDEX; CREATE INDEX i_naz2 ON NAZ (des_sta) TABLESPACE WORKINGINDEX; CREATE INDEX i_naz3 ON NAZ (des_cit) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TER; CREATE TABLE TER ( cod NUMBER(5,0), des CHAR(60), nr_stat NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ter1 ON TER (cod) TABLESPACE WORKINGINDEX; CREATE INDEX i_ter2 ON TER (nr_stat) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STR; CREATE TABLE STR ( cod NUMBER(5,0), tp CHAR(6), des CHAR(50) ) TABLESPACE WORKINGAREA; CREATE INDEX i_str1 ON STR (des) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_str2 ON STR (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STR_MCT; CREATE TABLE STR_MCT ( cod NUMBER(5,0), des CHAR(25) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_str_mct1 ON STR_MCT (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRO; CREATE TABLE PRO ( cod_cat NUMBER(5,0), cod_pro NUMBER(5,0), fl_fm CHAR(1), des CHAR(20) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_pro1 ON PRO (cod_cat,cod_pro,fl_fm) TABLESPACE WORKINGINDEX; CREATE INDEX i_pro2 ON PRO (fl_fm,des) TABLESPACE WORKINGINDEX; CREATE INDEX i_pro3 ON PRO (des) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CAT; CREATE TABLE CAT ( cod NUMBER(5,0), des CHAR(100), pos_pro CHAR(1), set_att CHAR(1), con_pro CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cat1 ON CAT (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TSR; CREATE TABLE TSR ( tp CHAR(1), cod CHAR(2), fl_fm CHAR(1), des CHAR(20), fl_ord NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_tsr1 ON TSR (tp,cod,fl_fm) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TSD; CREATE TABLE TSD ( cod NUMBER(5,0), des CHAR(25), cod_cat NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_tsd1 ON TSD (cod) TABLESPACE WORKINGINDEX; CREATE INDEX i_tsd2 ON TSD (des) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CNS; CREATE TABLE CNS ( cod NUMBER(10,0), des CHAR(30) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cns1 ON CNS (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CNV; CREATE TABLE CNV ( nr NUMBER(5,0), des CHAR(30), nr_fami NUMBER(10,0), ind_via NUMBER(5,0), ind_num NUMBER(5,0), ind_let CHAR(6), ind_sca CHAR(1), ind_int NUMBER(5,0), cognome CHAR(30), nome CHAR(35) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cnv1 ON CNV (nr) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ZON; CREATE TABLE ZON ( cod NUMBER(5,0), des CHAR(30), cod_sec NUMBER(5,0), des_loc CHAR(30), ind_via NUMBER(5,0), ind_num NUMBER(5,0), ind_let CHAR(6), ind_sca CHAR(1), ind_int NUMBER(5,0), cod_col NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_zon1 ON ZON (cod,cod_sec) TABLESPACE WORKINGINDEX; CREATE INDEX i_zon2 ON ZON (des) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE RAG; CREATE TABLE RAG ( cod_tip NUMBER(5,0), cod_zon NUMBER(5,0), cod_rag NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_rag1 ON RAG (cod_tip,cod_zon,cod_rag) TABLESPACE WORKINGINDEX; CREATE INDEX i_rag2 ON RAG (cod_tip,cod_rag) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE EBS; CREATE TABLE EBS ( cod_tip NUMBER(5,0), cod_zon NUMBER(5,0), cod_str NUMBER(5,0), civ_ini NUMBER(5,0), civ_fin NUMBER(5,0), ind_let CHAR(6), fl_pd CHAR(1) ) TABLESPACE WORKINGAREA; CREATE INDEX i_ebs1 ON EBS (cod_tip,cod_zon,cod_str) TABLESPACE WORKINGINDEX; CREATE INDEX i_ebs2 ON EBS (cod_tip,cod_str,civ_ini,fl_pd) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ebs3 ON EBS (cod_tip,cod_zon,cod_str,civ_ini,ind_let,fl_pd) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE DIR; CREATE TABLE DIR ( cod NUMBER(5,0), des CHAR(40), com_uso CHAR(40), bol_vir CHAR(60), uso CHAR(300), imp_dir NUMBER(10,0), imp_bol NUMBER(10,0), imp_spe NUMBER(10,0), imp_ric NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_dir1 ON DIR (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE DIR_EUR; CREATE TABLE DIR_EUR ( cod NUMBER(5,0), des CHAR(40), com_uso CHAR(40), bol_vir CHAR(60), uso CHAR(300), imp_dir NUMBER(8,2), imp_bol NUMBER(8,2), imp_spe NUMBER(8,2), imp_ric NUMBER(8,2) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_dir_eur1 ON DIR_EUR (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CAS; CREATE TABLE CAS ( cassa CHAR(8), fl_tp CHAR(1), prg NUMBER(10,0), tip_arc CHAR(1), cod_rep CHAR(8), cod_dir NUMBER(5,0), nr_movi NUMBER(5,0), dat DATE, ora NUMBER(5,0), ide NUMBER(10,0), imp_dir NUMBER(10,0), imp_bol NUMBER(10,0), imp_spe NUMBER(10,0), imp_ric NUMBER(10,0), fl_ws CHAR(6) ) TABLESPACE WORKINGAREA; CREATE INDEX i_cas1 ON CAS (cassa,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CAS_EUR; CREATE TABLE CAS_EUR ( cassa CHAR(8), fl_tp CHAR(1), prg NUMBER(10,0), tip_arc CHAR(1), cod_rep CHAR(8), cod_dir NUMBER(5,0), nr_movi NUMBER(5,0), dat DATE, ora NUMBER(5,0), ide NUMBER(10,0), imp_dir NUMBER(8,2), imp_bol NUMBER(8,2), imp_spe NUMBER(8,2), imp_ric NUMBER(8,2), fl_ws CHAR(6), des_frm CHAR(40) ) TABLESPACE WORKINGAREA; CREATE INDEX i_cas_eur1 ON CAS_EUR (cassa,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRC; CREATE TABLE PRC ( cassa CHAR(8), prg NUMBER(10,0), dat DATE, ora NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prc1 ON PRC (cassa,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRC_EUR; CREATE TABLE PRC_EUR ( cassa CHAR(8), prg NUMBER(10,0), dat DATE, ora NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prc_eur1 ON PRC_EUR (cassa,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE MCT; CREATE TABLE MCT ( cod NUMBER(5,0), fl_ap CHAR(1), art CHAR(37), des CHAR(320) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE VAR; CREATE TABLE VAR ( tp CHAR(1), cod NUMBER(5,0), des CHAR(30), cod_sec NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_var1 ON VAR (tp,cod,cod_sec) TABLESPACE WORKINGINDEX; CREATE INDEX i_var2 ON VAR (tp,des) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE DEC; CREATE TABLE DEC ( tp CHAR(1), cod CHAR(10), des CHAR(80) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_dec1 ON DEC (tp,cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE RPR; CREATE TABLE RPR ( cod NUMBER(10,0), des CHAR(50), nr_prat NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_rpr1 ON RPR (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE REV; CREATE TABLE REV ( cod_reg NUMBER(10,0), cod_eve NUMBER(5,0), cod_itr NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_rev ON REV (cod_eve) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_rev1 ON REV (cod_reg,cod_eve) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE APE; CREATE TABLE APE ( cod_ape CHAR(10), partita NUMBER(10,0), foglio CHAR(5), mappale CHAR(5), subalt CHAR(4), ind_via NUMBER(5,0), ind_num NUMBER(5,0), ind_let CHAR(6), ind_pia CHAR(3), ind_sca CHAR(1), ind_int NUMBER(5,0), uso CHAR(30), tp_cons CHAR(1), consist CHAR(10), superf CHAR(10), ordine NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ape1 ON APE (cod_ape) TABLESPACE WORKINGINDEX; CREATE INDEX i_ape2 ON APE (ind_via,ind_num,ind_let,ind_sca,ind_int) TABLESPACE WORKINGINDEX; CREATE INDEX i_ape3 ON APE (ordine) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE AST; CREATE TABLE AST ( nr_indi NUMBER(10,0), fl_sogg NUMBER(5,0), p_iva CHAR(11), dt_ope DATE, note1 CHAR(60), note2 CHAR(60), note3 CHAR(60), note4 CHAR(60), note5 CHAR(60), prg NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ast1 ON AST (nr_indi,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_ast2 ON AST (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CSO; CREATE TABLE CSO ( fl_sog CHAR(1), cod_sog NUMBER(10,0), fl_ogg CHAR(1), cod_ogg CHAR(10), fl_coll CHAR(1), quota NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_cso1 ON CSO (cod_ogg,fl_coll) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE FAM; CREATE TABLE FAM ( cod_ape NUMBER(10,0), nr_fami NUMBER(10,0), fl_sogg CHAR(1), dt_cost DATE ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE BLC; CREATE TABLE BLC ( nr_ini CHAR(12), nr_fin CHAR(12), nr_tot NUMBER(10,0), dt_ins DATE, fl_tp CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_blc1 ON BLC (nr_ini,fl_tp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE IST; CREATE TABLE IST ( mas_res NUMBER(10,0), fem_res NUMBER(10,0), mas_air NUMBER(10,0), fem_air NUMBER(10,0), fam_res NUMBER(10,0), fam_air NUMBER(10,0) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE AN2; CREATE TABLE AN2 ( nr_indi NUMBER(10,0), row_id NUMBER(10,0), flag CHAR(1) ) TABLESPACE WORKINGAREA; CREATE INDEX i_an2 ON AN2 (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE AN3; CREATE TABLE AN3 ( nr_indi NUMBER(10,0), row_id NUMBER(10,0), flag CHAR(1) ) TABLESPACE WORKINGAREA; CREATE INDEX i_an3 ON AN3 (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE AN4; CREATE TABLE AN4 ( row_id NUMBER(10,0), dt_even DATE NOT NULL, nr_indi NUMBER(10,0) NOT NULL, cognome CHAR(30), nome CHAR(35), pat_cog CHAR(30), pat_nom CHAR(35), mat_cog CHAR(30), mat_nom CHAR(35), nr_fami NUMBER(10,0), nr_conv NUMBER(5,0), loc_nas NUMBER(10,0), dt_nas DATE, ann_nas NUMBER(5,0), ora_nas NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), atn_ann NUMBER(5,0), atn_ltr NUMBER(10,0), atn_ntr NUMBER(10,0), atn_atr NUMBER(5,0), sesso CHAR(1), cod_fis CHAR(16), fl_cf CHAR(1), rap_par CHAR(2), profess NUMBER(10,0), tit_stu NUMBER(5,0), sta_civ CHAR(2), ind_via NUMBER(5,0), ind_num NUMBER(5,0), ind_let CHAR(6), ind_sca CHAR(1), ind_int NUMBER(5,0), cit_pos NUMBER(5,0), fl_sogg CHAR(1), fl_iscr NUMBER(5,0), fl_canc NUMBER(5,0), dt_iscr DATE, dt_canc DATE, prg_mor NUMBER(5,0), prg_con NUMBER(5,0), prg_div NUMBER(5,0), prg_pen NUMBER(5,0), prg_ct2 NUMBER(5,0), prg_emi NUMBER(5,0), prg_res NUMBER(5,0), prg_air NUMBER(5,0), prg_imm NUMBER(5,0), prg_irr NUMBER(5,0), prg_sog NUMBER(5,0), prg_tem NUMBER(5,0), prg_est NUMBER(5,0), prg_pra NUMBER(5,0), prg_ann NUMBER(5,0), row_id1 NUMBER(10,0), row_id2 NUMBER(10,0), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_an4 ON AN4 (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE QRY; CREATE TABLE QRY ( row_id NUMBER(10,0), tp CHAR(1), des CHAR(60), testo CHAR(1000) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_qry1 ON QRY (row_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRG; CREATE TABLE PRG ( pri NUMBER(10,0), pfr NUMBER(10,0), pfa NUMBER(10,0), pda NUMBER(10,0), pft NUMBER(10,0), elf NUMBER(10,0), att NUMBER(10,0) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE NRP; CREATE TABLE NRP ( tip CHAR(1), cod CHAR(8), des CHAR(60), lun_pag NUMBER(5,0), dir NUMBER(5,0), fl_cert CHAR(1), fl_cont CHAR(1), fl_rico CHAR(1), fl_cumu CHAR(1), fl_stor CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_nrp1 ON NRP (tip,cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE NRP_VIS; CREATE TABLE NRP_VIS ( tip CHAR(1), cod CHAR(8), fl_vis CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_nrp_vis1 ON NRP_VIS (tip,cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE NRP_BCK; CREATE TABLE NRP_BCK ( tip CHAR(1), cod CHAR(8), des CHAR(60), lun_pag NUMBER(5,0), dir NUMBER(5,0), fl_cert CHAR(1), fl_cont CHAR(1), fl_rico CHAR(1), fl_cumu CHAR(1), fl_stor CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_nrp_bck1 ON NRP_BCK (tip,cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE BUF; CREATE TABLE BUF ( cod NUMBER(5,0), tip CHAR(2), des CHAR(40), nr_help NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_buf1 ON BUF (cod) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_buf2 ON BUF (tip,des) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ETB; CREATE TABLE ETB ( tip CHAR(1), prg CHAR(3), des CHAR(80) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_etb1 ON ETB (tip,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE HBF; CREATE TABLE HBF ( nr_help NUMBER(5,0), nr_row NUMBER(5,0), des CHAR(75) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_hbf1 ON HBF (nr_help,nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PAK; CREATE TABLE PAK ( tpm CHAR(1) NOT NULL, cod CHAR(8) NOT NULL, pag CHAR(1) NOT NULL, prg CHAR(3) NOT NULL, tpr CHAR(2) NOT NULL, rig CHAR(3), col CHAR(3), lun CHAR(3), var CHAR(4), nrg CHAR(2), des CHAR(100) NOT NULL ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_pak1 ON PAK (tpm,cod,pag,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_pak2 ON PAK (tpm,cod,tpr,des) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PAK_BCK; CREATE TABLE PAK_BCK ( tpm CHAR(1) NOT NULL, cod CHAR(8) NOT NULL, pag CHAR(1) NOT NULL, prg CHAR(3) NOT NULL, tpr CHAR(2) NOT NULL, rig CHAR(3), col CHAR(3), lun CHAR(3), var CHAR(4), nrg CHAR(2), des CHAR(100) NOT NULL ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_pak_bck1 ON PAK_BCK (tpm,cod,pag,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_pak_bck2 ON PAK_BCK (tpm,cod,tpr,des) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE SEV; CREATE TABLE SEV ( fl_even NUMBER(5,0), cod_rep CHAR(8), fl_ad CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_sev1 ON SEV (fl_even,cod_rep) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE EVE; CREATE TABLE EVE ( cod NUMBER(5,0), des CHAR(80) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE OPE; CREATE TABLE OPE ( utente CHAR(8), evento NUMBER(5,0), stazione CHAR(6), nr_indi NUMBER(10,0), dt DATE, ora CHAR(8) ) TABLESPACE WORKINGAREA; CREATE INDEX i_ope1 ON OPE (utente,dt) TABLESPACE WORKINGINDEX; CREATE INDEX i_ope2 ON OPE (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STM; CREATE TABLE STM ( row_id NUMBER(10,0), nr_indi NUMBER(10,0), cod_rep CHAR(8), cod_eve NUMBER(5,0), nr_ragr NUMBER(10,0), dt_even DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_stm1 ON STM (nr_indi,cod_rep) TABLESPACE WORKINGINDEX; CREATE INDEX i_stm2 ON STM (cod_rep,cod_eve,dt_even) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_stm3 ON STM (row_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STM2; CREATE TABLE STM2 ( row_id NUMBER(10,0), nr_indi NUMBER(10,0), cod_rep CHAR(8), cod_eve NUMBER(5,0), nr_ragr NUMBER(10,0), dt_even DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_stm21 ON STM2 (nr_indi,cod_rep) TABLESPACE WORKINGINDEX; CREATE INDEX i_stm22 ON STM2 (cod_rep,cod_eve,dt_even) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_stm23 ON STM2 (row_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STC; CREATE TABLE STC ( row_id NUMBER(10,0), cit_pos NUMBER(5,0), sesso CHAR(1), prg_imm NUMBER(5,0), prg_emi NUMBER(5,0), loc_nas NUMBER(10,0), prg_mor NUMBER(5,0), nr_fami NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_stc1 ON STC (row_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE IS3; CREATE TABLE IS3 ( anno NUMBER(5,0), mese NUMBER(5,0), model CHAR(5) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_is3_1 ON IS3 (anno,mese,model) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE IP3; CREATE TABLE IP3 ( anno NUMBER(5,0), nr_stat NUMBER(5,0), res_stra_m NUMBER(10,0), res_stra_f NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ip3_1 ON IP3 (anno,nr_stat) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRT; CREATE TABLE PRT ( row_id NUMBER(10,0), nr_prot NUMBER(10,0), dt_prot DATE, nr_prot_ana NUMBER(10,0), cod_reg NUMBER(10,0), nr_prat NUMBER(10,0), cod_eve NUMBER(10,0), dt_ini DATE, dt_fin DATE, nr_indi NUMBER(10,0), fl_pra CHAR(1), esi_pra CHAR(1), dt_scad DATE, note CHAR(365), fl_itr CHAR(1), dt_deco DATE, mod_ric CHAR(72) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prt_1 ON PRT (row_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRS; CREATE TABLE PRS ( row_id NUMBER(10,0), nr_step NUMBER(5,0), cod_itr NUMBER(5,0), cod_pas NUMBER(5,0), dt_ini DATE, dt_scad DATE, dt_fin DATE, operatore CHAR(30), esito NUMBER(5,0), uff_ope NUMBER(5,0), note CHAR(292) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prs_1 ON PRS (row_id,nr_step) TABLESPACE WORKINGINDEX; CREATE INDEX i_prs_2 ON PRS (row_id,cod_itr,cod_pas) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRR; CREATE TABLE PRR ( row_id NUMBER(10,0), ind_via NUMBER(5,0), ind_num NUMBER(5,0), ind_let CHAR(6), ind_sca CHAR(1), ind_int NUMBER(5,0), loc_res NUMBER(10,0), ind_res CHAR(60), consola NUMBER(10,0), cap CHAR(20), nr_fami NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prr_1 ON PRR (row_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE UFF; CREATE TABLE UFF ( cod NUMBER(5,0), des CHAR(50) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_uff_1 ON UFF (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRI; CREATE TABLE PRI ( row_id NUMBER(10,0), nr_indi NUMBER(10,0), rap_par CHAR(2), prg NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_pri_1 ON PRI (row_id,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_pri_2 ON PRI (row_id,rap_par) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRE; CREATE TABLE PRE ( cod_eve NUMBER(10,0), cod_itr NUMBER(5,0), cod_pas NUMBER(5,0), cod_rep CHAR(8) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_pre_1 ON PRE (cod_eve,cod_itr,cod_pas,cod_rep) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRU; CREATE TABLE PRU ( prg NUMBER(10,0), row_id NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_pru_1 ON PRU (prg,row_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ITR; CREATE TABLE ITR ( cod_itr NUMBER(5,0), cod_pas NUMBER(5,0), des CHAR(40), durata NUMBER(5,0), esi_01 NUMBER(5,0), pas_01 NUMBER(5,0), esi_02 NUMBER(5,0), pas_02 NUMBER(5,0), esi_03 NUMBER(5,0), pas_03 NUMBER(5,0), esi_04 NUMBER(5,0), pas_04 NUMBER(5,0), esi_05 NUMBER(5,0), pas_05 NUMBER(5,0), esi_06 NUMBER(5,0), pas_06 NUMBER(5,0), esi_07 NUMBER(5,0), pas_07 NUMBER(5,0), esi_08 NUMBER(5,0), pas_08 NUMBER(5,0), esi_09 NUMBER(5,0), pas_09 NUMBER(5,0), esi_10 NUMBER(5,0), pas_10 NUMBER(5,0), dip_1 NUMBER(5,0), dip_2 NUMBER(5,0), dip_3 NUMBER(5,0), cod_uff NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_itr_1 ON ITR (cod_itr,cod_pas) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ITL; CREATE TABLE ITL ( cod_pas NUMBER(5,0), des CHAR(40), durata NUMBER(5,0), cod_uff NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_itl_1 ON ITL (cod_pas) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRM; CREATE TABLE PRM ( cod NUMBER(10,0), des CHAR(50) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prm_1 ON PRM (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE UFO; CREATE TABLE UFO ( cod_uff NUMBER(5,0), cod_ope NUMBER(5,0), des CHAR(30), fl_vali CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ufo_1 ON UFO (cod_uff,cod_ope) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRW; CREATE TABLE PRW ( row_id NUMBER(10,0), nr_prat NUMBER(10,0), prt_row_id NUMBER(10,0), cod_eve NUMBER(10,0), cod_fis_dic CHAR(16), cognome_dic CHAR(30), nome_dic CHAR(35), loc_nas_dic CHAR(100), dt_nas_dic DATE, nr_fami_old NUMBER(10,0), ind_via_new NUMBER(5,0), ind_num_new NUMBER(5,0), ind_let_new CHAR(6), ind_sca_new CHAR(1), ind_int_new NUMBER(5,0), nr_fami_new NUMBER(10,0), note CHAR(200) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prw_1 ON PRW (row_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PIW; CREATE TABLE PIW ( row_id NUMBER(10,0), prg NUMBER(5,0), cod_fis CHAR(16), cognome CHAR(30), nome CHAR(35), loc_nas CHAR(100), dt_nas DATE, rap_par CHAR(20), nr_ptn CHAR(10), catego CHAR(2), dt_ril DATE, tar_auto CHAR(500), tar_rimor CHAR(500), tar_moto CHAR(500), tar_cicli CHAR(500) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_piw_1 ON PIW (row_id,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PCW; CREATE TABLE PCW ( row_id NUMBER(10,0), prg NUMBER(5,0), fl_fam CHAR(1), cod_fis CHAR(16), cognome CHAR(30), nome CHAR(35), loc_nas CHAR(100), dt_nas DATE, rap_par CHAR(20) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_pcw_1 ON PCW (row_id,prg,fl_fam) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE NOTE; CREATE TABLE NOTE ( nr_indi NUMBER(10,0), testo CHAR(730) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_note_1 ON NOTE (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE FRM; CREATE TABLE FRM ( row_id NUMBER(10,0), tp NUMBER(5,0), ws CHAR(6), des CHAR(40) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_frm0 ON FRM (row_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_frm1 ON FRM (tp,ws,des) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE DOC; CREATE TABLE DOC ( nr_indi NUMBER(10,0), tip_doc CHAR(3), cod_doc CHAR(16) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_doc1 ON DOC (nr_indi,tip_doc,cod_doc) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE EXD; CREATE TABLE EXD ( tp_exp CHAR(1), codice NUMBER(5,0), des CHAR(60) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_exd1 ON EXD (tp_exp,codice) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE EXI; CREATE TABLE EXI ( tp_exp CHAR(1), codice NUMBER(5,0), batch CHAR(20) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_exi1 ON EXI (tp_exp,codice) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE MSD; CREATE TABLE MSD ( cod NUMBER(10,0), des CHAR(200) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_msd1 ON MSD (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE COM_CSI; CREATE TABLE COM_CSI ( cod NUMBER(10,0), m_sg_com CHAR(2), m_cod_com NUMBER(10,0), m_des_com CHAR(40), i_sg_com CHAR(2), i_cod_com NUMBER(10,0), i_des_com CHAR(40), fl_new CHAR(1), fl_norm CHAR(2) ) TABLESPACE WORKINGAREA; CREATE INDEX i_com_csi1 ON COM_CSI (m_cod_com) TABLESPACE WORKINGINDEX; CREATE INDEX i_com_csi2 ON COM_CSI (i_cod_com) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STMEN; CREATE TABLE STMEN ( tip_men CHAR(1), nr_menu NUMBER(5,0), tip_sel CHAR(2), sce_vel CHAR(2), x_coord NUMBER(5,0), y_coord NUMBER(5,0), tot_opz NUMBER(5,0), nr_rows NUMBER(5,0), nr_cols NUMBER(5,0), nr_vers NUMBER(5,0), nr_hors NUMBER(5,0), nr_wide NUMBER(5,0), sec_lev NUMBER(5,0), bck_col CHAR(1), for_col CHAR(1), tit_col CHAR(1), fl_tito CHAR(1), fl_tend CHAR(1), fl_bord CHAR(1), des_voc CHAR(40), tip_prc CHAR(1), nom_prg CHAR(12), des_par CHAR(40), cod_msd NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_stmen1 ON STMEN (tip_men,nr_menu,tip_sel) TABLESPACE WORKINGINDEX; CREATE INDEX i_stmen2 ON STMEN (tip_prc,nom_prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STHWD; CREATE TABLE STHWD ( cod_hwd NUMBER(5,0), id_term CHAR(15), cod_ide CHAR(10), tip_per CHAR(1), des_per CHAR(64), cod_rif NUMBER(5,0), has_col CHAR(1), dev_fis CHAR(64), nr_salt NUMBER(5,0), nr_strp NUMBER(5,0), mar_inf NUMBER(5,0), stp_def NUMBER(5,0), tip_con CHAR(1), seq_ini CHAR(16), seq_fin CHAR(16), tip_ali CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_sthwd1 ON STHWD (cod_hwd) TABLESPACE WORKINGINDEX; CREATE INDEX i_sthwd2 ON STHWD (id_term,cod_ide) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STCTR; CREATE TABLE STCTR ( cod_ccs NUMBER(5,0), des_fam CHAR(40), reset CHAR(24), set_len CHAR(24), set_int CHAR(24), set_10 CHAR(24), set_12 CHAR(24), set_15 CHAR(24), set_cmp CHAR(24), set_nrm CHAR(24), set_nlq CHAR(24), set_drf CHAR(24), set_pca CHAR(24), set_elt CHAR(24), set_bld CHAR(24), res_bld CHAR(24), set_wde CHAR(24), res_wde CHAR(24), set_cor CHAR(24), res_cor CHAR(24), set_und CHAR(24), res_und CHAR(24), seq_sal CHAR(24), nr_salt NUMBER(5,0), nr_strp NUMBER(5,0), tip_sal NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_stctr1 ON STCTR (cod_ccs) TABLESPACE WORKINGINDEX; CREATE INDEX i_stctr2 ON STCTR (des_fam) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STUTE; CREATE TABLE STUTE ( row_id NUMBER(10,0), cod_ute CHAR(8), nom_ute CHAR(30), pwd_crp CHAR(176), tab_acc CHAR(100), tab_acl CHAR(100), tab_ace CHAR(100), tab_acd CHAR(100), tab_acs CHAR(100), cod_sta NUMBER(5,0), ute_dt_acc DATE, ute_gg_vali NUMBER(5,0), psw_dt_ins DATE, psw_dt_scad DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_stute1 ON STUTE (cod_ute) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_stute2 ON STUTE (row_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE VDUTE; CREATE TABLE VDUTE ( row_id NUMBER(10,0), tab_acv CHAR(20) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_rowid_1 ON VDUTE (row_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STTAB; CREATE TABLE STTAB ( cod_tab CHAR(6), id_term CHAR(15), cod_ide CHAR(10), nom_tab CHAR(30), tip_mod CHAR(4), nr_copi NUMBER(5,0), sx_marg NUMBER(5,0), pag_len NUMBER(5,0), pausa CHAR(1), interln NUMBER(5,0), stm_mod CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_sttab1 ON STTAB (cod_tab) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STSPO; CREATE TABLE STSPO ( nr_prog CHAR(8), dt_stam DATE, ora_sta CHAR(5), cod_ute CHAR(8), nom_stp CHAR(30), cod_hwd NUMBER(5,0), lun_pag NUMBER(5,0), tip_mod CHAR(4), nr_pagi NUMBER(10,0), nr_copi NUMBER(5,0), nr_pags NUMBER(10,0), nr_cops NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_stspo1 ON STSPO (nr_prog) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STLCK; CREATE TABLE STLCK ( ses_id NUMBER(10,0), tabella CHAR(6), row_id NUMBER(10,0), ws_id CHAR(6) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_stlck_1 ON STLCK (tabella,row_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_stlck_2 ON STLCK (ses_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STROW; CREATE TABLE STROW ( tmp_tab NUMBER(10,0), row_id1 NUMBER(10,0), row_id2 NUMBER(10,0), row_id3 NUMBER(10,0), ses_lck NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_strow1 ON STROW (tmp_tab) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE STTMP; CREATE TABLE STTMP ( id_tmp NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_sttmp1 ON STTMP (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PAR; CREATE TABLE PAR ( nr_indi NUMBER(10,0), des CHAR(50) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_par1 ON PAR (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CNT; CREATE TABLE CNT ( row_id NUMBER(10,0), fl_cnt CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cnt1 ON CNT (row_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_cnt2 ON CNT (fl_cnt) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELELE; CREATE TABLE ELELE ( nr_indi NUMBER(10,0), nr_lgen NUMBER(10,0), nr_fasc NUMBER(10,0), sezione NUMBER(5,0), nr_lsez NUMBER(10,0), fl_stat CHAR(2), motivo CHAR(3), dt_iscr DATE, nr_iscr NUMBER(10,0), dt_canc DATE, nr_canc NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ele1 ON ELELE (nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_ele2 ON ELELE (nr_lgen,nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_ele3 ON ELELE (nr_fasc,nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_ele4 ON ELELE (sezione,nr_lsez,nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_ele5 ON ELELE (fl_stat) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELESQ; CREATE TABLE ELESQ ( nr_indi NUMBER(10,0), tipo CHAR(1), dt_scad DATE, com_isc NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_elesq1 ON ELESQ (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELRES; CREATE TABLE ELRES ( nr_indi NUMBER(10,0), motivo CHAR(1), dt_scad DATE, com_isc NUMBER(10,0), tip_rev CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_elres1 ON ELRES (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELLAG; CREATE TABLE ELLAG ( nr_indi NUMBER(10,0), fl_lag CHAR(1), motivo CHAR(3), sezione NUMBER(5,0), nr_lsez NUMBER(10,0), nr_fasc NUMBER(10,0), nr_lgen NUMBER(10,0), dt_iscr DATE, nr_iscr NUMBER(10,0), dt_canc DATE, nr_canc NUMBER(10,0), com_ele NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_lag1 ON ELLAG (nr_indi,fl_lag) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSER; CREATE TABLE ELSER ( nr_indi NUMBER(10,0), fl_tbl CHAR(3), fl_ser CHAR(1), dt DATE, note CHAR(120) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ser1 ON ELSER (nr_indi,fl_ser) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELMAX; CREATE TABLE ELMAX ( nr_prim NUMBER(10,0), nr_prog NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_max1 ON ELMAX (nr_prim) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELMOT; CREATE TABLE ELMOT ( fl_tp CHAR(1), tp_cod CHAR(1), nr_cod NUMBER(5,0), fl_rev CHAR(3), fl_seco CHAR(4), fl_tipo CHAR(3), fl_temp CHAR(1), des CHAR(50) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_mot1 ON ELMOT (fl_tp,tp_cod,nr_cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSEM; CREATE TABLE ELSEM ( nr_indi NUMBER(10,0), motivo CHAR(3), nr_lgen NUMBER(10,0), nr_fasc NUMBER(10,0), sezione NUMBER(5,0), nr_lsez NUMBER(10,0), fl_prep CHAR(2), fl_elps CHAR(2) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_sem1 ON ELSEM (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSZS; CREATE TABLE ELSZS ( nr_indi NUMBER(10,0), new_sez NUMBER(5,0), nr_lsez NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_szs1 ON ELSZS (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELDIN; CREATE TABLE ELDIN ( nr_indi NUMBER(10,0), fl_din CHAR(1), nr_lgen NUMBER(10,0), nr_fasc NUMBER(10,0), sezione NUMBER(5,0), nr_lsez NUMBER(10,0), motivo CHAR(3) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_din1 ON ELDIN (nr_indi,fl_din) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSZD; CREATE TABLE ELSZD ( nr_indi NUMBER(10,0), new_sez NUMBER(5,0), nr_lsez NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_szd1 ON ELSZD (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSTA; CREATE TABLE ELSTA ( nr_indi NUMBER(10,0), dt_movi DATE, motivo CHAR(3), sezione NUMBER(5,0), sesso CHAR(1), nr_lsez NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_sta1 ON ELSTA (dt_movi,motivo,sezione) TABLESPACE WORKINGINDEX; CREATE INDEX i_sta2 ON ELSTA (sesso,sezione,nr_lsez) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELPRE; CREATE TABLE ELPRE ( nr_indi NUMBER(10,0), fl_isca CHAR(1), nr_iscr NUMBER(10,0), dt_iscr DATE, nr_canc NUMBER(10,0), dt_canc DATE, fl_canc NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_pre1 ON ELPRE (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELPRR; CREATE TABLE ELPRR ( nr_indi NUMBER(10,0), fl_isca CHAR(1), nr_isca NUMBER(10,0), dt_isca DATE, fl_canc NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prr1 ON ELPRR (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSCS; CREATE TABLE ELSCS ( nr_indi NUMBER(10,0), fl_albo CHAR(1), nr_albo NUMBER(10,0), nr_iscr NUMBER(10,0), dt_iscr DATE, nr_canc NUMBER(10,0), dt_canc DATE, fl_canc NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_scs1 ON ELSCS (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSCD; CREATE TABLE ELSCD ( nr_indi NUMBER(10,0), fl_albo CHAR(1), nr_albo NUMBER(10,0), nr_iscr NUMBER(10,0), dt_iscr DATE, nr_canc NUMBER(10,0), dt_canc DATE, fl_canc NUMBER(5,0), note CHAR(60) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_scd1 ON ELSCD (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELGIU; CREATE TABLE ELGIU ( nr_indi NUMBER(10,0), fl_capp CHAR(1), nr_iscr NUMBER(10,0), dt_iscr DATE, nr_canc NUMBER(10,0), dt_canc DATE, fl_canc NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_giu1 ON ELGIU (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELGIU_CSI; CREATE TABLE ELGIU_CSI ( nr_indi NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_giu_csi1 ON ELGIU_CSI (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELPAR; CREATE TABLE ELPAR ( cod NUMBER(10,0), sig CHAR(10), des CHAR(50), pri NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_elpar1 ON ELPAR (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELPDL2; CREATE TABLE ELPDL2 ( nr_indi NUMBER(10,0), prg_ins NUMBER(10,0), cod_par NUMBER(10,0), fl_vali CHAR(1), nr_fasc NUMBER(10,0), dt_vidi DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_elpdl2_1 ON ELPDL2 (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELZON; CREATE TABLE ELZON ( cod NUMBER(10,0), cod_com CHAR(4), cod_zon CHAR(4), cod_sec NUMBER(5,0), des CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_elzon_1 ON ELZON (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELRGP; CREATE TABLE ELRGP ( nr_indi NUMBER(10,0), fl_isca CHAR(1), fl_capp CHAR(1), nr_iscr NUMBER(10,0), dt_iscr DATE, fl_canc NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_rgp1 ON ELRGP (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELDOM; CREATE TABLE ELDOM ( nr_indi NUMBER(10,0), fl_isca CHAR(1), nr_isca NUMBER(10,0), dt_isca DATE, fl_canc NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_dom1 ON ELDOM (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSEG; CREATE TABLE ELSEG ( seggio NUMBER(5,0), nr_scr NUMBER(5,0), presid NUMBER(10,0), scr_1 NUMBER(10,0), fl_scr1 CHAR(1), scr_2 NUMBER(10,0), fl_scr2 CHAR(1), scr_3 NUMBER(10,0), fl_scr3 CHAR(1), scr_4 NUMBER(10,0), fl_scr4 CHAR(1), scr_5 NUMBER(10,0), fl_scr5 CHAR(1), pre_sup NUMBER(10,0), scr_su1 NUMBER(10,0), scr_su2 NUMBER(10,0), scr_su3 NUMBER(10,0), scr_su4 NUMBER(10,0), scr_su5 NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_seg1 ON ELSEG (seggio) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELPDL; CREATE TABLE ELPDL ( nr_indi NUMBER(10,0), dt_elez DATE, fl_elez NUMBER(5,0), nr_list NUMBER(5,0), nr_fogl NUMBER(5,0), pr_fogl NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_pdl1 ON ELPDL (nr_indi,dt_elez,fl_elez) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELCEC; CREATE TABLE ELCEC ( preside CHAR(30), fl_pres CHAR(12), segreta CHAR(30), fl_segr CHAR(12), membro1 CHAR(30), fl_mem1 CHAR(12), membro2 CHAR(30), fl_mem2 CHAR(12), membro3 CHAR(30), fl_mem3 CHAR(12), membro4 CHAR(30), fl_mem4 CHAR(12), membro5 CHAR(30), fl_mem5 CHAR(12), membro6 CHAR(30), fl_mem6 CHAR(12), membro7 CHAR(30), fl_mem7 CHAR(12), membro8 CHAR(30), fl_mem8 CHAR(12) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE ELCOL; CREATE TABLE ELCOL ( cod NUMBER(5,0), des1 CHAR(50), des2 CHAR(50), des3 CHAR(50), des4 CHAR(50), des5 CHAR(50), des6 CHAR(50), col1 CHAR(20), col2 CHAR(20), col3 CHAR(20), col4 CHAR(20), col5 CHAR(20), col6 CHAR(20) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_col1 ON ELCOL (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSGR; CREATE TABLE ELSGR ( prg NUMBER(10,0), nr_indi NUMBER(10,0), fl_uso CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_elsgr1 ON ELSGR (prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELTES; CREATE TABLE ELTES ( nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_tess NUMBER(10,0), dt_ril DATE, dt_agg DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_eltes1 ON ELTES (nr_indi,prg) TABLESPACE WORKINGINDEX; CREATE INDEX i_eltes2 ON ELTES (nr_tess) TABLESPACE WORKINGINDEX; CREATE INDEX i_eltes3 ON ELTES (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELPTE; CREATE TABLE ELPTE ( cod NUMBER(10,0), nr_ini NUMBER(10,0), nr_fin NUMBER(10,0), nr_last NUMBER(10,0), fl_fine CHAR(1), stazione CHAR(6) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_elpte1 ON ELPTE (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELTAN; CREATE TABLE ELTAN ( nr_tess NUMBER(10,0), nr_indi NUMBER(10,0), dt_ann DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_eltan1 ON ELTAN (nr_tess) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELOPT; CREATE TABLE ELOPT ( nr_indi NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_opt1 ON ELOPT (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELNAZ; CREATE TABLE ELNAZ ( nr_stat NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_elnaz1 ON ELNAZ (nr_stat) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELREV; CREATE TABLE ELREV ( cod NUMBER(5,0), des CHAR(80), fl_att CHAR(1), fl_ord CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_elrev1 ON ELREV (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELDIN2; CREATE TABLE ELDIN2 ( cod_rev NUMBER(5,0), nr_indi NUMBER(10,0), fl_din CHAR(1), nr_lgen NUMBER(10,0), nr_fasc NUMBER(10,0), sezione NUMBER(5,0), nr_lsez NUMBER(10,0), motivo CHAR(3) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_eldin2 ON ELDIN2 (cod_rev,nr_indi,fl_din) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSZD2; CREATE TABLE ELSZD2 ( cod_rev NUMBER(5,0), nr_indi NUMBER(10,0), new_sez NUMBER(5,0), nr_lsez NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_elszd2 ON ELSZD2 (cod_rev,nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELPSW2; CREATE TABLE ELPSW2 ( cod_rev NUMBER(5,0), str CHAR(400) NOT NULL ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_elpsw2 ON ELPSW2 (cod_rev) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELTEM; CREATE TABLE ELTEM ( nr_indi NUMBER(10,0), loc_res NUMBER(10,0), ind_res CHAR(60), consola NUMBER(10,0), cap CHAR(20) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_eltem1 ON ELTEM (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSCD2; CREATE TABLE ELSCD2 ( nr_indi NUMBER(10,0), fl_albo CHAR(1), nr_albo NUMBER(10,0), nr_iscr NUMBER(10,0), dt_iscr DATE, nr_canc NUMBER(10,0), dt_canc DATE, fl_canc NUMBER(5,0), note CHAR(60) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_scd21 ON ELSCD2 (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELRLA; CREATE TABLE ELRLA ( nr_indi NUMBER(10,0), fl_lag CHAR(1), motivo CHAR(3), sezione NUMBER(5,0), nr_lsez NUMBER(10,0), nr_fasc NUMBER(10,0), nr_lgen NUMBER(10,0), com_ele NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_rla1 ON ELRLA (nr_indi,fl_lag) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELSZA; CREATE TABLE ELSZA ( nr_indi NUMBER(10,0), fl_lag CHAR(1), new_sez NUMBER(5,0), nr_lsez NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_sza1 ON ELSZA (nr_indi,fl_lag) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ELLAP; CREATE TABLE ELLAP ( fl_lag CHAR(1), fase CHAR(1), fl_stm CHAR(50), anni NUMBER(5,0) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE ELLAM; CREATE TABLE ELLAM ( fl_lag CHAR(1), nr_prim NUMBER(10,0), nr_prog NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_lam1 ON ELLAM (fl_lag,nr_prim) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVGEN; CREATE TABLE CVGEN ( cod NUMBER(10,0), att_tip CHAR(1), att_luilei CHAR(1), cognome CHAR(30), nome CHAR(35) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvgen1 ON CVGEN (cod,att_tip,att_luilei) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvgen2 ON CVGEN (att_tip) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVCIT; CREATE TABLE CVCIT ( cod NUMBER(10,0), atc_ann NUMBER(5,0), atc_nr NUMBER(10,0), atc_par CHAR(1), atc_ser CHAR(1), atc_uff NUMBER(5,0), atc_vol CHAR(1), cognome CHAR(30), nome CHAR(35), sesso CHAR(1), nr_indi NUMBER(10,0), dt_nas DATE, dt_eve DATE, dt_eve1 DATE, tribunale CHAR(33), fl_sogg CHAR(1), statociv CHAR(20), hl_code CHAR(8), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvcit0 ON CVCIT (cod) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_cvcit1 ON CVCIT (atc_ann,atc_nr,atc_par,atc_ser,atc_uff,atc_vol) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvcit2 ON CVCIT (cognome,nome) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvcit3 ON CVCIT (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVNOTCI; CREATE TABLE CVNOTCI ( cod NUMBER(10,0), num_not NUMBER(5,0), rig_not NUMBER(5,0), certif CHAR(1), testo CHAR(71) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvnotci ON CVNOTCI (cod,num_not,rig_not) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVINTCI; CREATE TABLE CVINTCI ( cod NUMBER(10,0), offs1 NUMBER(10,0), offs2 NUMBER(10,0), offs3 NUMBER(10,0), offs4 NUMBER(10,0), utente CHAR(8), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvintci ON CVINTCI (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVNAS; CREATE TABLE CVNAS ( cod NUMBER(10,0), atn_ann NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), cognome CHAR(30), nome CHAR(35), sesso CHAR(1), nr_indi NUMBER(10,0), dt_nas DATE, ora_nas NUMBER(5,0), loc_nas CHAR(33), cod_loc_nas NUMBER(10,0), fl_sogg CHAR(1), cit_pos CHAR(20), cod_cit_pos NUMBER(5,0), pat_cog CHAR(30), dt_nas_p DATE, prof_p CHAR(20), cod_prof_p NUMBER(10,0), mat_cog CHAR(50), dt_nas_m DATE, prof_m CHAR(20), cod_prof_m NUMBER(10,0), loc_tras CHAR(33), cod_loc_tras NUMBER(10,0), att_ann NUMBER(5,0), att_nr NUMBER(10,0), att_par CHAR(1), att_ser CHAR(1), att_uff NUMBER(5,0), att_vol CHAR(1), nato_morto CHAR(1), hl_code CHAR(8), certif CHAR(1), tipo_fil CHAR(1), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvnas0 ON CVNAS (cod) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_cvnas1 ON CVNAS (atn_ann,atn_nr,atn_par,atn_ser,atn_uff,atn_vol) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvnas2 ON CVNAS (cognome,nome) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvnas3 ON CVNAS (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVNAS1; CREATE TABLE CVNAS1 ( cod NUMBER(10,0), nomisucc CHAR(50) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvnas11 ON CVNAS1 (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVNOTNA; CREATE TABLE CVNOTNA ( cod NUMBER(10,0), num_not NUMBER(5,0), rig_not NUMBER(5,0), certif CHAR(1), testo CHAR(71) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvnotna ON CVNOTNA (cod,num_not,rig_not) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVINTNA; CREATE TABLE CVINTNA ( cod NUMBER(10,0), offs1 NUMBER(10,0), offs2 NUMBER(10,0), offs3 NUMBER(10,0), offs4 NUMBER(10,0), utente CHAR(8), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvintna ON CVINTNA (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVISTNA; CREATE TABLE CVISTNA ( cod NUMBER(10,0), tip_dich CHAR(1), ordnasvm NUMBER(5,0), maordnas NUMBER(5,0), nativivi NUMBER(5,0), natimort NUMBER(5,0), aborti NUMBER(5,0), precnato DATE, genere_par CHAR(1), n_masch NUMBER(5,0), n_femmi NUMBER(5,0), at1_nr NUMBER(10,0), at1_par CHAR(1), at1_ser CHAR(1), tipo_par CHAR(1), neonatot CHAR(1), matrgeni DATE, luogopar CHAR(1), fl_resm CHAR(1), cod_com_res NUMBER(10,0), istruzpa CHAR(1), istruzma CHAR(1), duratags NUMBER(5,0), conpropa CHAR(1), conproma CHAR(1), pospropa CHAR(1), posproma CHAR(1), attecopa CHAR(1), attecoma CHAR(1), consagui CHAR(1), cittpadr NUMBER(5,0), cittmadr NUMBER(5,0), fl_citp CHAR(1), fl_citm CHAR(1), cod_fisp CHAR(16), cod_fism CHAR(16), cod_fis CHAR(16), nscheda NUMBER(10,0), pesoneo NUMBER(5,0), malform CHAR(1), tp_malf CHAR(2), fe_mal1 CHAR(60), fe_mal2 CHAR(60), ma_mal1 CHAR(60), ma_mal2 CHAR(60), alt_cir CHAR(60) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvistna ON CVISTNA (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVPUB; CREATE TABLE CVPUB ( cod NUMBER(10,0), atp_ann NUMBER(5,0), atp_nr NUMBER(10,0), atp_par CHAR(1), atp_ser CHAR(1), atp_uff NUMBER(5,0), atp_vol CHAR(1), atp_luilei CHAR(1), cognome CHAR(30), nome CHAR(35), nr_indi NUMBER(10,0), dt_nas DATE, loc_nas CHAR(33), cod_loc_nas NUMBER(10,0), fl_sogg CHAR(1), cit_pos CHAR(20), cod_cit_pos NUMBER(5,0), profess CHAR(30), cod_profes NUMBER(10,0), statociv CHAR(20), cod_statociv CHAR(2), loc_res CHAR(33), cod_loc_res NUMBER(10,0), atn_ann NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), hl_code CHAR(8), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvpub0 ON CVPUB (cod,atp_luilei) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_cvpub1 ON CVPUB (atp_ann,atp_nr,atp_par,atp_ser,atp_uff,atp_vol,atp_luilei) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvpub2 ON CVPUB (cognome,nome) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvpub3 ON CVPUB (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVINTPU; CREATE TABLE CVINTPU ( cod NUMBER(10,0), offs1 NUMBER(10,0), offs2 NUMBER(10,0), offs3 NUMBER(10,0), offs4 NUMBER(10,0), utente CHAR(8), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvintpu ON CVINTPU (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVMAT; CREATE TABLE CVMAT ( cod NUMBER(10,0), atm_luilei CHAR(1), cognome CHAR(30), nome CHAR(35), nr_indi NUMBER(10,0), dt_nas DATE, loc_nas CHAR(33), cod_loc_nas NUMBER(10,0), fl_sogg CHAR(1), cit_pos CHAR(20), cod_cit_pos NUMBER(5,0), profess CHAR(30), cod_profes NUMBER(10,0), statociv CHAR(20), cod_statociv CHAR(2), loc_res CHAR(33), cod_loc_res NUMBER(10,0), atn_ann NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), hl_code CHAR(8) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvmat ON CVMAT (cod,atm_luilei) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvmat1 ON CVMAT (cognome,nome) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvmat2 ON CVMAT (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVMAT1; CREATE TABLE CVMAT1 ( cod NUMBER(10,0), atm_ann NUMBER(5,0), atm_nr NUMBER(10,0), atm_par CHAR(1), atm_ser CHAR(1), atm_uff NUMBER(5,0), atm_vol CHAR(1), loc_mat CHAR(33), cod_loc_mat NUMBER(10,0), stato CHAR(33), dt_mat DATE, ora_mat NUMBER(5,0), separ CHAR(1), rito CHAR(3), att_ann NUMBER(5,0), att_nr NUMBER(10,0), att_par CHAR(1), att_ser CHAR(1), att_uff NUMBER(5,0), att_vol CHAR(1), certif CHAR(1), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvmat11 ON CVMAT1 (cod) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_cvmat12 ON CVMAT1 (atm_ann,atm_nr,atm_par,atm_ser,atm_uff,atm_vol) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVISTMA; CREATE TABLE CVISTMA ( cod NUMBER(10,0), prematso DATE, prematsa DATE, istruzso CHAR(1), istruzsa CHAR(1), conproso CHAR(1), conprosa CHAR(1), posproso CHAR(1), posprosa CHAR(1), attecoso CHAR(1), attecosa CHAR(1), fl_citto CHAR(1), fl_citta CHAR(1), cod_fiso CHAR(16), cod_fisa CHAR(16), fl_reso CHAR(1), loc_reso NUMBER(10,0), fl_resa CHAR(1), loc_resa NUMBER(10,0), nscheda NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvistma ON CVISTMA (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVNOTMA; CREATE TABLE CVNOTMA ( cod NUMBER(10,0), num_not NUMBER(5,0), rig_not NUMBER(5,0), certif CHAR(1), testo CHAR(71) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvnotma ON CVNOTMA (cod,num_not,rig_not) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVINTMA; CREATE TABLE CVINTMA ( cod NUMBER(10,0), offs1 NUMBER(10,0), offs2 NUMBER(10,0), offs3 NUMBER(10,0), offs4 NUMBER(10,0), utente CHAR(8), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvintma ON CVINTMA (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVMOR; CREATE TABLE CVMOR ( cod NUMBER(10,0), atm_ann NUMBER(5,0), atm_nr NUMBER(10,0), atm_par CHAR(1), atm_ser CHAR(1), atm_uff NUMBER(5,0), atm_vol CHAR(1), cognome CHAR(30), nome CHAR(35), sesso CHAR(1), nr_indi NUMBER(10,0), dt_mor DATE, ora_mor NUMBER(5,0), loc_mor CHAR(33), cod_loc_mor NUMBER(10,0), dt_nas DATE, loc_nas CHAR(33), cod_loc_nas NUMBER(10,0), loc_res CHAR(33), cod_loc_res NUMBER(10,0), fl_sogg CHAR(1), cit_pos CHAR(20), cod_citt NUMBER(5,0), profes CHAR(30), cod_profes NUMBER(10,0), statociv CHAR(20), cod_statociv CHAR(2), coniuge CHAR(60), pat_cog CHAR(30), mat_cog CHAR(50), loc_tras CHAR(33), cod_loc_tra NUMBER(10,0), atn_ann NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), hl_code CHAR(8), certif CHAR(1), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvmor0 ON CVMOR (cod) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_cvmor1 ON CVMOR (atm_ann,atm_nr,atm_par,atm_ser,atm_uff,atm_vol) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvmor2 ON CVMOR (cognome,nome) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvmor3 ON CVMOR (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVISTMO1; CREATE TABLE CVISTMO1 ( cod NUMBER(10,0), loc_mor CHAR(1), ris_diag CHAR(1), cau_ini CHAR(60), nr_cau_ini NUMBER(5,0), dur_cau_ini NUMBER(10,0), cau_int CHAR(40), nr_cau_int NUMBER(5,0), dur_cau_int NUMBER(10,0), cau_ter CHAR(40), nr_cau_ter NUMBER(5,0), dur_cau_ter NUMBER(10,0), cau_morb CHAR(60), nr_cau_morb NUMBER(5,0), dur_morb NUMBER(10,0), cau_viol CHAR(1), lesione CHAR(40), malattia CHAR(40), morbo CHAR(40), mezzo CHAR(60), ora_inc NUMBER(5,0), dt_inc DATE, dur_inc NUMBER(10,0), loc_inc CHAR(30), ora_nas NUMBER(5,0), malform CHAR(58), nscheda NUMBER(10,0), dur_vita NUMBER(10,0), genere_par CHAR(1), tipo_par CHAR(1), loc_par CHAR(1), duratags NUMBER(5,0), present CHAR(1), pesoneo NUMBER(5,0), consagui CHAR(1), dt_nas_ma DATE, fl_resm CHAR(1), cod_com_res NUMBER(10,0), tipo_fil CHAR(1), maordnas NUMBER(5,0), mortalita NUMBER(5,0), nativivi NUMBER(5,0), natimort NUMBER(5,0), aborti NUMBER(5,0), precnato DATE, istruzpa CHAR(1), istruzma CHAR(1), profespa NUMBER(10,0), profesma NUMBER(10,0), conpropa CHAR(1), conproma CHAR(1), pospropa CHAR(1), posproma CHAR(1), attecopa CHAR(1), attecoma CHAR(1), fl_citp CHAR(1), fl_citm CHAR(1), cittpadr NUMBER(5,0), cittmadr NUMBER(5,0), cod_fis CHAR(16), cod_fisp CHAR(16), cod_fism CHAR(16) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvistmo1 ON CVISTMO1 (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVISTMO2; CREATE TABLE CVISTMO2 ( cod NUMBER(10,0), loc_mor CHAR(1), ris_diag CHAR(1), cau_ini CHAR(80), nr_cau_ini NUMBER(5,0), dur_cau_ini NUMBER(10,0), cau_int CHAR(40), nr_cau_int NUMBER(5,0), dur_cau_int NUMBER(10,0), cau_ter CHAR(40), nr_cau_ter NUMBER(5,0), dur_cau_ter NUMBER(10,0), cau_morb CHAR(60), nr_cau_morb NUMBER(5,0), dur_morb NUMBER(10,0), cau_viol CHAR(1), lesione CHAR(40), malattia CHAR(40), morbo CHAR(40), mezzo CHAR(60), ora_inc NUMBER(5,0), dt_inc DATE, dur_inc NUMBER(10,0), loc_inc CHAR(30), nscheda NUMBER(10,0), ann_nas_con NUMBER(5,0), ann_mat NUMBER(5,0), istruzione CHAR(1), con_pro CHAR(1), pos_pro CHAR(1), att_eco CHAR(1), fl_citt CHAR(1), cod_fis CHAR(16) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvistmo2 ON CVISTMO2 (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVMOR1; CREATE TABLE CVMOR1 ( per_ann NUMBER(5,0), per_nr NUMBER(10,0), cognome CHAR(30), nome CHAR(35), sesso CHAR(1), nr_indi NUMBER(10,0), dt_mor DATE, ora_mor NUMBER(5,0), loc_mor CHAR(33), cod_loc_mor NUMBER(10,0), dt_nas DATE, loc_nas CHAR(33), cod_loc_nas NUMBER(10,0), loc_res CHAR(33), cod_loc_res NUMBER(10,0), fl_sogg CHAR(1), cit_pos CHAR(20), cod_citt NUMBER(5,0), profes CHAR(30), cod_profes NUMBER(10,0), statociv CHAR(20), coniuge CHAR(60), pat_cog CHAR(30), mat_cog CHAR(50), loc_tras CHAR(33), cod_loc_tra NUMBER(10,0), atn_ann NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), causa_morte CHAR(200), luogo CHAR(100), hl_code CHAR(8), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvmor11 ON CVMOR1 (per_ann,per_nr) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvmor12 ON CVMOR1 (cognome,nome) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVNOTMO; CREATE TABLE CVNOTMO ( cod NUMBER(10,0), num_not NUMBER(5,0), rig_not NUMBER(5,0), certif CHAR(1), testo CHAR(71) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvnotmo ON CVNOTMO (cod,num_not,rig_not) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVINTMO; CREATE TABLE CVINTMO ( cod NUMBER(10,0), offs1 NUMBER(10,0), offs2 NUMBER(10,0), offs3 NUMBER(10,0), offs4 NUMBER(10,0), utente CHAR(8), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvintmo ON CVINTMO (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVUFF; CREATE TABLE CVUFF ( codice CHAR(4) NOT NULL, nome CHAR(60), titolo CHAR(72) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvuff ON CVUFF (codice) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvuff1 ON CVUFF (nome) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVTES; CREATE TABLE CVTES ( codice CHAR(4) NOT NULL, nome CHAR(40), sesso CHAR(1), loc_nas CHAR(33), dt_nas DATE, prof CHAR(20), loc_res CHAR(33) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvtes ON CVTES (codice) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvtes1 ON CVTES (nome) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVFOR; CREATE TABLE CVFOR ( tipo CHAR(1), codice CHAR(4) NOT NULL, commento CHAR(60), testo CHAR(621) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvfor ON CVFOR (tipo,codice) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvfor1 ON CVFOR (tipo,commento) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVTAN; CREATE TABLE CVTAN ( tipo CHAR(1), codice CHAR(4) NOT NULL, commento CHAR(60), titolo CHAR(300), articolo CHAR(150), testo CHAR(621) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvtan ON CVTAN (tipo,codice) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvtan1 ON CVTAN (tipo,commento) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVTAN_OLD; CREATE TABLE CVTAN_OLD ( tipo CHAR(1), codice CHAR(4) NOT NULL, commento CHAR(60), titolo CHAR(300), articolo CHAR(150), testo CHAR(621) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvtan_old ON CVTAN_OLD (tipo,codice) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvtan_old1 ON CVTAN_OLD (tipo,commento) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVPAR; CREATE TABLE CVPAR ( codice CHAR(4) NOT NULL, chiesa CHAR(120), ministro CHAR(50), celebrante CHAR(50), qualita CHAR(60), il CHAR(2), rito CHAR(110), loc_celebr CHAR(33) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvpar ON CVPAR (codice) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvpar1 ON CVPAR (chiesa) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVDCT; CREATE TABLE CVDCT ( tipo_atto CHAR(1) NOT NULL, tipo_oggetto CHAR(1) NOT NULL, nome_oggetto CHAR(8) NOT NULL, offset NUMBER(10,0), lunghezza NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvdct ON CVDCT (tipo_atto,tipo_oggetto,nome_oggetto) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVDCT20; CREATE TABLE CVDCT20 ( tipo_atto CHAR(1) NOT NULL, tipo_oggetto CHAR(1) NOT NULL, nome_oggetto CHAR(8) NOT NULL, offset NUMBER(10,0), lunghezza NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvdct20 ON CVDCT20 (tipo_atto,tipo_oggetto,nome_oggetto) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVSPO; CREATE TABLE CVSPO ( cod NUMBER(10,0), tipo_atto CHAR(1), prog_rep CHAR(1), descrizione CHAR(30), tipo_mod CHAR(5), nome_file CHAR(8), data_op DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvspo ON CVSPO (tipo_atto,cod,prog_rep) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvspo1 ON CVSPO (tipo_mod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVJRN; CREATE TABLE CVJRN ( utente CHAR(8), stazione CHAR(6), data_op DATE, ora_op NUMBER(5,0), cod NUMBER(10,0), atj_tip CHAR(1), atj_ope CHAR(1) ) TABLESPACE WORKINGAREA; CREATE INDEX i_cvjrn ON CVJRN (utente,data_op) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVNTR; CREATE TABLE CVNTR ( cod NUMBER(10,0), cognome CHAR(30), nome CHAR(35), sesso CHAR(1), dt_nas DATE, loc_isc NUMBER(10,0), atn_ann NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvntr0 ON CVNTR (cod) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvntr1 ON CVNTR (atn_nr,atn_par,atn_ser,atn_uff,atn_vol) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvntr2 ON CVNTR (cognome,nome) TABLESPACE WORKINGINDEX; CREATE INDEX i_cvntr3 ON CVNTR (dt_nas) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVPROG; CREATE TABLE CVPROG ( tipo_atto CHAR(1), registro CHAR(1), prog1 NUMBER(5,0), prog2 NUMBER(5,0), prog3 NUMBER(5,0), prog4 NUMBER(5,0), fl_p1 NUMBER(5,0), fl_p2 NUMBER(5,0), fl_p3 NUMBER(5,0), fl_p4 NUMBER(5,0), ufficio NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_cvprog ON CVPROG (tipo_atto,registro) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_cvprog1 ON CVPROG (tipo_atto,registro,ufficio) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVNOTE; CREATE TABLE CVNOTE ( tipo_atto CHAR(1) NOT NULL, cod_atto NUMBER(10,0), note CHAR(500) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvnote1 ON CVNOTE (tipo_atto,cod_atto) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVNOT; CREATE TABLE CVNOT ( tipo_atto CHAR(1) NOT NULL, cod_atto NUMBER(10,0), num_not NUMBER(5,0), dt_ins DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvnot1 ON CVNOT (tipo_atto,cod_atto,num_not) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVGES; CREATE TABLE CVGES ( utente CHAR(8), anno NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvges1 ON CVGES (utente,anno) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVDOC; CREATE TABLE CVDOC ( cod_pra CHAR(8), cod_doc CHAR(8), fl_stm CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvdoc1 ON CVDOC (cod_pra,cod_doc) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVTRA; CREATE TABLE CVTRA ( att_tip CHAR(1), cod NUMBER(10,0), att_luilei CHAR(1), att_ann NUMBER(5,0), att_nr NUMBER(10,0), att_par CHAR(1), att_ser CHAR(1), att_uff NUMBER(5,0), att_vol CHAR(1), loc_tra CHAR(33), cod_loc_tra NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvtra_1 ON CVTRA (att_tip,cod,att_luilei) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CVTEM; CREATE TABLE CVTEM ( att_tip CHAR(1), cod NUMBER(10,0), fl_bloc CHAR(1), note1 CHAR(60), note2 CHAR(60), note3 CHAR(60), note4 CHAR(60), note5 CHAR(60) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cvtem1 ON CVTEM (att_tip,cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE ANPSW; CREATE TABLE ANPSW ( comune CHAR(33) NOT NULL, nr_com CHAR(6) NOT NULL, cod_int CHAR(2) NOT NULL, com_nas CHAR(7), com_mat CHAR(7), com_mor CHAR(7), cit_pos CHAR(3), sta_cvm CHAR(2), sta_cvf CHAR(2), cen_ann CHAR(4) NOT NULL, air_ann CHAR(4) NOT NULL, uff_ana CHAR(40), sindaco CHAR(40), fl_ctrl CHAR(1) NOT NULL, com_pdr CHAR(6), com_trm CHAR(6), com_pre CHAR(6), com_inp CHAR(6), com_dis CHAR(6), com_uml CHAR(6), com_cap CHAR(6), fl_tras CHAR(1), fl_sndx CHAR(1), cod_inc CHAR(2), cod_mog CHAR(2), cod_mar CHAR(2), cod_fgf CHAR(2), cod_fgm CHAR(2), cod_sor CHAR(2), cod_fra CHAR(2), cod_mad CHAR(2), cod_pad CHAR(2), com_prf CHAR(6), sta_cdm CHAR(2) NOT NULL, sta_cdf CHAR(2) NOT NULL, fl_gape CHAR(1), fl_cmor CHAR(1), dt_cost CHAR(10), dt_stor CHAR(10), com_old CHAR(6), filler CHAR(46), fl_sicurezza CHAR(1) NOT NULL, fl_keyb CHAR(1) NOT NULL, fl_colore CHAR(1) NOT NULL, delimit CHAR(2) NOT NULL, lung_mod CHAR(2) NOT NULL, larg_mod CHAR(3) NOT NULL, fl_0012 CHAR(1), fl_0013 CHAR(1), fl_0014 CHAR(1), fl_0015 CHAR(1), fl_0016 CHAR(1), cod_cvf CHAR(2), cod_cvm CHAR(2), fl_apr4 CHAR(1), fl_cert CHAR(1), fl_cass CHAR(1), fl_rctf CHAR(1), cod_nna CHAR(2), cod_nno CHAR(2), cod_scf CHAR(2), cod_scm CHAR(2), cod_mtr CHAR(2), cod_ptr CHAR(2), fl_comu CHAR(1), tip_ap5 CHAR(1), fl_0001 CHAR(1), fl_0002 CHAR(1), fl_0003 CHAR(1), fl_0004 CHAR(1), fl_0005 CHAR(1), fl_0006 CHAR(1), fl_0007 CHAR(1), fl_0008 CHAR(1), fl_0009 CHAR(1), mic_cid CHAR(3), mic_apr CHAR(3), mic_ind CHAR(3), mic_ptn CHAR(3), mic_c15 CHAR(3), col_cid CHAR(3), col_apr CHAR(3), col_ind CHAR(3), col_ptn CHAR(3), col_c15 CHAR(3), lit_eur CHAR(9), dt_val_ute CHAR(3), fl_0020 CHAR(1), fl_0021 CHAR(1), dt_val_psw CHAR(3), fl_0025 CHAR(1), fl_euro CHAR(1), fl_0010 CHAR(1), fl_0011 CHAR(1), c15pers CHAR(1), c15rich CHAR(1), fl_0026 CHAR(1), fl_0027 CHAR(1), fl_0028 CHAR(1), fl_0029 CHAR(1), fl_0030 CHAR(1), fl_0031 CHAR(1), fl_0032 CHAR(1), fl_0033 CHAR(1) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE ELPSW; CREATE TABLE ELPSW ( comune CHAR(33) NOT NULL, nr_com CHAR(6) NOT NULL, cod_sez CHAR(3), sez_prior CHAR(1), sez_aire CHAR(3), min_sez CHAR(4), max_sez CHAR(4), ann_aggiunte CHAR(1), eta_magg CHAR(2), eta_magg2 CHAR(2), sem1_per_ini CHAR(4), sem1_per_fin CHAR(4), sem1_prep CHAR(4), sem1_prim CHAR(4), sem2_per_ini CHAR(4), sem2_per_fin CHAR(4), sem2_prep CHAR(4), sem2_prim CHAR(4), din1_per_ini CHAR(4), din1_per_fin CHAR(4), din1_1tr_ini CHAR(4), din1_1tr_fin CHAR(4), din1_2tr_ini CHAR(4), din1_2tr_fin CHAR(4), din2_per_ini CHAR(4), din2_per_fin CHAR(4), din2_1tr_ini CHAR(4), din2_1tr_fin CHAR(4), din2_2tr_ini CHAR(4), din2_2tr_fin CHAR(4), dt_elez CHAR(10), gg_pmcc CHAR(2), din3_per_ini CHAR(2), din3_1tr_ini CHAR(2), din3_1tr_fin CHAR(2), din3_2tr_ini CHAR(2), din3_2tr_fin CHAR(2), din3_iscriz CHAR(2), din3_cancel CHAR(2), fl_rv_din CHAR(1) NOT NULL, fl_an_din CHAR(4) NOT NULL, fl_sp_din CHAR(1) NOT NULL, fl_sp_str CHAR(1) NOT NULL, fl_rv_sem CHAR(1) NOT NULL, fl_an_sem CHAR(4) NOT NULL, fl_sp_sem CHAR(1) NOT NULL, fl_nr_fasc CHAR(1), nr_fascm_ini CHAR(8), nr_fascf_ini CHAR(8), fl_st_sem CHAR(15), fl_st_din CHAR(25), fl_sp_par CHAR(1) NOT NULL, fl_st_par CHAR(10), fl_sp_lag CHAR(1) NOT NULL, fl_st_lag CHAR(10), cod_cecirc CHAR(6), fl_sche_fem CHAR(1), fl_fasc_fem CHAR(1), fl_sp_vri CHAR(1), fill_int CHAR(9), fl_recup_fs CHAR(1), filler CHAR(31), fl_sicurezza CHAR(1) NOT NULL, fl_keyb CHAR(1) NOT NULL, fl_colore CHAR(1) NOT NULL, delimit CHAR(2) NOT NULL, tes_ric_dup CHAR(1), fl_0001 CHAR(1), lung_mod CHAR(2) NOT NULL, larg_mod CHAR(3) NOT NULL, tp_mod_lgen CHAR(1), tp_mod_lsez CHAR(1), tp_mod_comu CHAR(1), tp_fl_00001 CHAR(1), fl_ballott CHAR(1), nr_verb_scr CHAR(6), dt_verb_scr CHAR(10), fabb_scs CHAR(6), filler1 CHAR(56) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE CVPSW; CREATE TABLE CVPSW ( autorita CHAR(70), eve_nel CHAR(2), eve_loc CHAR(101), comu_un CHAR(1), comu_avv CHAR(16), comu_mun CHAR(1), nr_com CHAR(6), provincia CHAR(20), usl CHAR(25), fl_obbli CHAR(1), fl_chrid CHAR(1), pres_com CHAR(1), fl_profe CHAR(1), pres_pro CHAR(1), fl_vie CHAR(1), fl_posti CHAR(1), fl_spazi CHAR(1), fl_capo CHAR(1), fl_stand CHAR(1), fl_intes CHAR(1), tip_mod CHAR(1), fl_pag_2 CHAR(1), att_int CHAR(1), agg_ana CHAR(1), fl_aggnr CHAR(1), fl_ope CHAR(1), pre_bia CHAR(1), fl_dtpub CHAR(1), uff_cit CHAR(4), uff_nas CHAR(4), uff_pub CHAR(4), uff_mat CHAR(4), uff_mor CHAR(4), fl_test_n CHAR(1), tes_nas_1 CHAR(4), tes_nas_2 CHAR(4), delegato CHAR(4), fl_test_m CHAR(1), tes_mor_1 CHAR(4), tes_mor_2 CHAR(4), dichiaran CHAR(4), fl_pubmat CHAR(1), fl_permor CHAR(1), chiesa_2a CHAR(4), chiesa_2b CHAR(4), cit_1a CHAR(1), nas_1a CHAR(1), nas_1b CHAR(1), nas_2a CHAR(1), nas_2b CHAR(1), pub_1 CHAR(1), pub_2a CHAR(1), pub_2b CHAR(1), mat_1 CHAR(1), mat_2a CHAR(1), mat_2b CHAR(1), mat_2c CHAR(1), mor_1 CHAR(1), mor_2a CHAR(1), mor_2b CHAR(1), mor_2c CHAR(1), cod_uff CHAR(1), ann_arc CHAR(1), agg_stm CHAR(1), fl_pra CHAR(1) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE TMP_ROV; CREATE TABLE TMP_ROV ( id_tmp NUMBER(10,0), cognome CHAR(30), nome CHAR(35), dt_nas DATE, sesso CHAR(1), ind_res CHAR(50), loc_res NUMBER(10,0), cat_pen CHAR(1), fas_pen CHAR(2), cod_fis CHAR(16) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_rov1 ON TMP_ROV (id_tmp) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_rov2 ON TMP_ROV (cognome,nome,dt_nas) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_LOC; CREATE TABLE PRN_LOC ( cod_loc NUMBER(10,0), des_old CHAR(100), des_new CHAR(100), ins_log CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_loc_00 ON PRN_LOC (cod_loc) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_prn_loc_01 ON PRN_LOC (des_old) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP; CREATE TABLE TTMP ( cod_id NUMBER(10,0), ordine NUMBER(10,0), nr_indi NUMBER(10,0), evento CHAR(50), dt_even DATE, dt_ope DATE, dt_finoa DATE, nr_fami NUMBER(10,0), nr_fami_dt DATE, cognome CHAR(45), nome CHAR(45), nom_suc CHAR(45), sesso CHAR(1), loc_nas CHAR(50), dt_nas DATE, ann_nas NUMBER(5,0), ora_min CHAR(5), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), atn_ann NUMBER(5,0), atn_ntr NUMBER(10,0), atn_ptr CHAR(1), atn_str CHAR(1), atn_utr NUMBER(5,0), atn_vtr CHAR(1), atn_atr NUMBER(5,0), atn_ltr CHAR(50), atto_par CHAR(50), ind_cod NUMBER(5,0), ind_via CHAR(50), ind_num NUMBER(5,0), ind_let CHAR(6), ind_int NUMBER(5,0), ind_sca CHAR(1), indir_dt DATE, fl_sogg CHAR(1), fl_iscr NUMBER(5,0), fl_canc NUMBER(5,0), dt_iscr DATE, dt_canc DATE, fl_cert CHAR(1), cert_note CHAR(300), fl_espa CHAR(1), pat_cog CHAR(45), pat_nom CHAR(45), mat_cog CHAR(45), mat_nom CHAR(45), nr_conv NUMBER(10,0), conviv CHAR(80), rap_par CHAR(20), rap_par_dt DATE, cit_pos CHAR(40), profess CHAR(30), pro_pos CHAR(1), pro_set CHAR(1), pro_con CHAR(1), profess_dt DATE, tit_stu CHAR(25), tit_stu_dt DATE, cod_fis CHAR(16), fl_cf CHAR(1), sta_civ CHAR(20), con_cognome CHAR(45), con_nome CHAR(45), con_nr_indc NUMBER(10,0), con_loc_nas CHAR(50), con_dt_nas DATE, con_loc_mat CHAR(50), con_dt_mat DATE, con_atm_nr NUMBER(10,0), con_atm_par CHAR(1), con_atm_ser CHAR(1), con_atm_uff NUMBER(5,0), con_atm_vol CHAR(1), con_atm_ann NUMBER(5,0), con_atm_ntr NUMBER(10,0), con_atm_ptr CHAR(1), con_atm_str CHAR(1), con_atm_utr NUMBER(5,0), con_atm_vtr CHAR(1), con_atm_atr NUMBER(5,0), con_atm_ltr CHAR(50), imm_loc_pro CHAR(50), imm_dt_imm DATE, imm_nr_prat NUMBER(10,0), emi_loc_emi CHAR(50), emi_dt_emi DATE, emi_nr_prat NUMBER(10,0), irr_loc_can CHAR(50), irr_dt_can DATE, irr_nr_prac NUMBER(10,0), irr_loc_ric CHAR(50), irr_loc_isc CHAR(50), irr_dt_ric DATE, irr_nr_prai NUMBER(10,0), ved_loc_mor CHAR(50), ved_dt_mor DATE, ved_atm_nr NUMBER(10,0), ved_atm_par CHAR(1), ved_atm_ser CHAR(1), ved_atm_uff NUMBER(5,0), ved_atm_vol CHAR(1), ved_atm_ann NUMBER(5,0), ved_atm_ntr NUMBER(10,0), ved_atm_ptr CHAR(1), ved_atm_str CHAR(1), ved_atm_utr NUMBER(5,0), ved_atm_vtr CHAR(1), ved_atm_atr NUMBER(5,0), ved_atm_ltr CHAR(50), mor_loc_mor CHAR(50), mor_dt_mor DATE, mor_atm_nr NUMBER(10,0), mor_atm_par CHAR(1), mor_atm_ser CHAR(1), mor_atm_uff NUMBER(5,0), mor_atm_vol CHAR(1), mor_atm_ann NUMBER(5,0), mor_atm_ntr NUMBER(10,0), mor_atm_ptr CHAR(1), mor_atm_str CHAR(1), mor_atm_utr NUMBER(5,0), mor_atm_vtr CHAR(1), mor_atm_atr NUMBER(5,0), mor_atm_ltr CHAR(50), mor_causa CHAR(60), div_cap_tri CHAR(50), div_nr_sen2 NUMBER(10,0), div_dt_sen2 DATE, div_dt_div DATE, div_atd_nr NUMBER(10,0), div_atd_par CHAR(1), div_atd_ser CHAR(1), div_atd_uff NUMBER(5,0), div_atd_vol CHAR(1), div_atd_ann NUMBER(5,0), div_atd_ltr CHAR(50), res_ind_res CHAR(60), res_loc_res CHAR(50), res_cap CHAR(20), res_consola CHAR(50), resid_dt DATE, air_nr_fami CHAR(15), air_fami_dt DATE, air_nr_dist CHAR(15), air_dt_isca DATE, air_loc_pro CHAR(50), air_mt_isca NUMBER(5,0), air_nrproti NUMBER(10,0), air_in_isca NUMBER(5,0), air_com_isc NUMBER(5,0), air_dt_canc DATE, air_loc_des CHAR(50), air_mt_canc NUMBER(5,0), air_nrprotc NUMBER(10,0), air_in_canc NUMBER(5,0), air_dt_var DATE, air_mt_var NUMBER(5,0), air_nrprotv NUMBER(10,0), air_in_var NUMBER(5,0), ct1_cit_pos CHAR(40), cit_dt_acq DATE, cit_loc_acq CHAR(50), cit_atca_ann NUMBER(5,0), cit_atca_nr NUMBER(10,0), cit_atca_uff NUMBER(5,0), cit_atca_vol CHAR(1), cit_dt_perd DATE, cit_loc_perd CHAR(50), cit_atcp_ann NUMBER(5,0), cit_atcp_nr NUMBER(10,0), cit_atcp_uff NUMBER(5,0), cit_atcp_vol CHAR(1), fl_ok CHAR(1), prg_mor NUMBER(5,0), prg_con NUMBER(5,0), prg_div NUMBER(5,0), prg_pen NUMBER(5,0), prg_ct1 NUMBER(5,0), prg_ct2 NUMBER(5,0), prg_emi NUMBER(5,0), prg_res NUMBER(5,0), prg_air NUMBER(5,0), prg_imm NUMBER(5,0), prg_irr NUMBER(5,0), prg_sog NUMBER(5,0), prg_tem NUMBER(5,0), prg_est NUMBER(5,0), prg_pra NUMBER(5,0), prg_ann NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_00 ON TTMP (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_02 ON TTMP (nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_03 ON TTMP (dt_even) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_04 ON TTMP (dt_finoa) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_05 ON TTMP (nr_indi,dt_even,dt_finoa,dt_ope,cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_06 ON TTMP (nr_indi,dt_finoa,dt_even,dt_ope,cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_TBL; CREATE TABLE PRN_TBL ( codice CHAR(20), tabella CHAR(20), tab_sg CHAR(5), campo CHAR(20), des CHAR(22), tipo CHAR(1), fl_loc CHAR(1), visual CHAR(1), err_prn CHAR(1), err_tmp CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_tbl_01 ON PRN_TBL (codice) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_tbl_02 ON PRN_TBL (tabella) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_tbl_03 ON PRN_TBL (tab_sg) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_tbl_04 ON PRN_TBL (campo) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_tbl_05 ON PRN_TBL (fl_loc) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_tbl_06 ON PRN_TBL (visual) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_tbl_07 ON PRN_TBL (err_prn) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_tbl_08 ON PRN_TBL (err_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_ERR; CREATE TABLE PRN_ERR ( cod_err NUMBER(10,0), cod_id NUMBER(10,0), campo CHAR(20), valore CHAR(60), correg CHAR(1), des_agg CHAR(20) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_err_01 ON PRN_ERR (cod_err) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_err_02 ON PRN_ERR (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_err_03 ON PRN_ERR (campo) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_err_04 ON PRN_ERR (valore) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_err_05 ON PRN_ERR (correg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_ERR; CREATE TABLE TTMP_ERR ( cod_err NUMBER(10,0), cod_id NUMBER(10,0), campo CHAR(20), valore CHAR(60), correg CHAR(1), des_agg CHAR(20) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_err_01 ON TTMP_ERR (cod_err) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_err_02 ON TTMP_ERR (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_err_03 ON TTMP_ERR (campo) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_err_04 ON TTMP_ERR (valore) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_err_05 ON TTMP_ERR (correg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_LOG; CREATE TABLE TTMP_LOG ( cod_err NUMBER(10,0), cod_id NUMBER(10,0), campo CHAR(20), des_old CHAR(60), des_new CHAR(60), azione CHAR(5), fase CHAR(4), dt_cor DATE, ora CHAR(8) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_log_00 ON TTMP_LOG (cod_err) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_STODT; CREATE TABLE TTMP_STODT ( nr_indi NUMBER(10,0), dt_even DATE, dt_finoa DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_stodt_01 ON TTMP_STODT (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_GEN; CREATE TABLE TTMP_GEN ( nr_indi NUMBER(10,0), cognome CHAR(45), nome CHAR(45), nom_suc CHAR(45), pat_cog CHAR(45), pat_nom CHAR(45), mat_cog CHAR(45), mat_nom CHAR(45), con_cognome CHAR(45), con_nome CHAR(45), tbl CHAR(5), ins_gen CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_gen_02 ON TTMP_GEN (nr_indi,tbl) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_INDC; CREATE TABLE TTMP_INDC ( nr_indi NUMBER(10,0), nr_indc NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_indc_01 ON TTMP_INDC (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_SCV; CREATE TABLE TTMP_SCV ( tipo CHAR(3), cod_tmp NUMBER(10,0), cod_cv NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_scv_01 ON TTMP_SCV (tipo,cod_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_STO; CREATE TABLE PRN_STO ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), evento CHAR(50), dt_even CHAR(10), dt_ope CHAR(10), dt_finoa CHAR(10), nr_fami CHAR(10), nr_fami_dt CHAR(10), cognome CHAR(45), nome CHAR(45), nom_suc CHAR(45), sesso CHAR(1), loc_nas CHAR(50), dt_nas CHAR(10), ann_nas CHAR(4), ora_min CHAR(5), atn_nr CHAR(10), atn_par CHAR(1), atn_ser CHAR(1), atn_uff CHAR(10), atn_vol CHAR(1), atn_ann CHAR(10), atn_ntr CHAR(10), atn_ptr CHAR(1), atn_str CHAR(1), atn_utr CHAR(10), atn_vtr CHAR(1), atn_atr CHAR(10), atn_ltr CHAR(50), atto_par CHAR(50), ind_cod CHAR(10), ind_via CHAR(50), ind_num CHAR(10), ind_let CHAR(6), ind_int CHAR(10), ind_sca CHAR(1), indir_dt CHAR(10), fl_sogg CHAR(1), fl_iscr CHAR(10), fl_canc CHAR(10), dt_iscr CHAR(10), dt_canc CHAR(10), fl_cert CHAR(1), cert_note CHAR(300), fl_espa CHAR(1), pat_cog CHAR(45), pat_nom CHAR(45), mat_cog CHAR(45), mat_nom CHAR(45), nr_conv CHAR(10), conviv CHAR(80), rap_par CHAR(20), rap_par_dt CHAR(10), cit_pos CHAR(40), profess CHAR(30), pro_pos CHAR(1), pro_set CHAR(1), pro_con CHAR(1), profess_dt CHAR(10), tit_stu CHAR(25), tit_stu_dt CHAR(10), cod_fis CHAR(16), fl_cf CHAR(1), sta_civ CHAR(20), con_cognome CHAR(45), con_nome CHAR(45), con_nr_indc CHAR(10), con_loc_nas CHAR(50), con_dt_nas CHAR(10), con_loc_mat CHAR(50), con_dt_mat CHAR(10), con_atm_nr CHAR(10), con_atm_par CHAR(1), con_atm_ser CHAR(1), con_atm_uff CHAR(10), con_atm_vol CHAR(1), con_atm_ann CHAR(10), con_atm_ntr CHAR(10), con_atm_ptr CHAR(1), con_atm_str CHAR(1), con_atm_utr CHAR(10), con_atm_vtr CHAR(1), con_atm_atr CHAR(10), con_atm_ltr CHAR(50), imm_loc_pro CHAR(50), imm_dt_imm CHAR(10), imm_nr_prat CHAR(10), emi_loc_emi CHAR(50), emi_dt_emi CHAR(10), emi_nr_prat CHAR(10), irr_loc_can CHAR(50), irr_dt_can CHAR(10), irr_nr_prac CHAR(10), irr_loc_ric CHAR(50), irr_loc_isc CHAR(50), irr_dt_ric CHAR(10), irr_nr_prai CHAR(10), ved_loc_mor CHAR(50), ved_dt_mor CHAR(10), ved_atm_nr CHAR(10), ved_atm_par CHAR(1), ved_atm_ser CHAR(1), ved_atm_uff CHAR(10), ved_atm_vol CHAR(1), ved_atm_ann CHAR(10), ved_atm_ntr CHAR(10), ved_atm_ptr CHAR(1), ved_atm_str CHAR(1), ved_atm_utr CHAR(10), ved_atm_vtr CHAR(1), ved_atm_atr CHAR(10), ved_atm_ltr CHAR(50), mor_loc_mor CHAR(50), mor_dt_mor CHAR(10), mor_atm_nr CHAR(10), mor_atm_par CHAR(1), mor_atm_ser CHAR(1), mor_atm_uff CHAR(10), mor_atm_vol CHAR(1), mor_atm_ann CHAR(10), mor_atm_ntr CHAR(10), mor_atm_ptr CHAR(1), mor_atm_str CHAR(1), mor_atm_utr CHAR(10), mor_atm_vtr CHAR(1), mor_atm_atr CHAR(10), mor_atm_ltr CHAR(50), mor_causa CHAR(60), div_cap_tri CHAR(50), div_nr_sen2 CHAR(10), div_dt_sen2 CHAR(10), div_dt_div CHAR(10), div_atd_nr CHAR(10), div_atd_par CHAR(1), div_atd_ser CHAR(1), div_atd_uff CHAR(10), div_atd_vol CHAR(1), div_atd_ann CHAR(10), div_atd_ltr CHAR(50), res_ind_res CHAR(60), res_loc_res CHAR(50), res_cap CHAR(20), res_consola CHAR(50), resid_dt CHAR(10), air_nr_fami CHAR(15), air_fami_dt CHAR(10), air_nr_dist CHAR(15), air_dt_isca CHAR(10), air_loc_pro CHAR(50), air_mt_isca CHAR(30), air_nrproti CHAR(10), air_in_isca CHAR(10), air_com_isc CHAR(10), air_dt_canc CHAR(10), air_loc_des CHAR(50), air_mt_canc CHAR(30), air_nrprotc CHAR(10), air_in_canc CHAR(10), air_dt_var CHAR(10), air_mt_var CHAR(30), air_nrprotv CHAR(10), air_in_var CHAR(10), ct1_cit_pos CHAR(40), cit_dt_acq CHAR(10), cit_loc_acq CHAR(50), cit_atca_ann CHAR(10), cit_atca_nr CHAR(10), cit_atca_uff CHAR(10), cit_atca_vol CHAR(1), cit_dt_perd CHAR(10), cit_loc_perd CHAR(50), cit_atcp_ann CHAR(10), cit_atcp_nr CHAR(10), cit_atcp_uff CHAR(10), cit_atcp_vol CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_sto_00 ON PRN_STO (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_ANA; CREATE TABLE PRN_ANA ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), nr_fami CHAR(10), nr_fami_dt CHAR(10), cognome CHAR(45), nome CHAR(45), nom_suc CHAR(45), sesso CHAR(1), loc_nas CHAR(50), dt_nas CHAR(10), ann_nas CHAR(4), ora_min CHAR(5), atn_nr CHAR(10), atn_par CHAR(1), atn_ser CHAR(1), atn_uff CHAR(10), atn_vol CHAR(1), atn_ann CHAR(10), atn_ntr CHAR(10), atn_ptr CHAR(1), atn_str CHAR(1), atn_utr CHAR(10), atn_vtr CHAR(1), atn_atr CHAR(10), atn_ltr CHAR(50), atto_par CHAR(50), ind_cod CHAR(10), ind_via CHAR(50), ind_num CHAR(10), ind_let CHAR(6), ind_int CHAR(10), ind_sca CHAR(1), indir_dt CHAR(10), fl_sogg CHAR(1), fl_iscr CHAR(10), fl_canc CHAR(10), dt_iscr CHAR(10), dt_canc CHAR(10), fl_cert CHAR(1), cert_note CHAR(300), fl_espa CHAR(1), pat_cog CHAR(45), pat_nom CHAR(45), mat_cog CHAR(45), mat_nom CHAR(45), nr_conv CHAR(10), conviv CHAR(80), rap_par CHAR(20), rap_par_dt CHAR(10), cit_pos CHAR(40), profess CHAR(30), pro_pos CHAR(1), pro_set CHAR(1), pro_con CHAR(1), profess_dt CHAR(10), tit_stu CHAR(25), tit_stu_dt CHAR(10), cod_fis CHAR(16), fl_cf CHAR(1), sta_civ CHAR(20), con_cognome CHAR(45), con_nome CHAR(45), con_nr_indc CHAR(10), con_loc_nas CHAR(50), con_dt_nas CHAR(10), con_loc_mat CHAR(50), con_dt_mat CHAR(10), con_atm_nr CHAR(10), con_atm_par CHAR(1), con_atm_ser CHAR(1), con_atm_uff CHAR(10), con_atm_vol CHAR(1), con_atm_ann CHAR(10), con_atm_ntr CHAR(10), con_atm_ptr CHAR(1), con_atm_str CHAR(1), con_atm_utr CHAR(10), con_atm_vtr CHAR(1), con_atm_atr CHAR(10), con_atm_ltr CHAR(50), imm_loc_pro CHAR(50), imm_dt_imm CHAR(10), imm_nr_prat CHAR(10), emi_loc_emi CHAR(50), emi_dt_emi CHAR(10), emi_nr_prat CHAR(10), irr_loc_can CHAR(50), irr_dt_can CHAR(10), irr_nr_prac CHAR(10), irr_loc_ric CHAR(50), irr_loc_isc CHAR(50), irr_dt_ric CHAR(10), irr_nr_prai CHAR(10), ved_loc_mor CHAR(50), ved_dt_mor CHAR(10), ved_atm_nr CHAR(10), ved_atm_par CHAR(1), ved_atm_ser CHAR(1), ved_atm_uff CHAR(10), ved_atm_vol CHAR(1), ved_atm_ann CHAR(10), ved_atm_ntr CHAR(10), ved_atm_ptr CHAR(1), ved_atm_str CHAR(1), ved_atm_utr CHAR(10), ved_atm_vtr CHAR(1), ved_atm_atr CHAR(10), ved_atm_ltr CHAR(50), mor_loc_mor CHAR(50), mor_dt_mor CHAR(10), mor_atm_nr CHAR(10), mor_atm_par CHAR(1), mor_atm_ser CHAR(1), mor_atm_uff CHAR(10), mor_atm_vol CHAR(1), mor_atm_ann CHAR(10), mor_atm_ntr CHAR(10), mor_atm_ptr CHAR(1), mor_atm_str CHAR(1), mor_atm_utr CHAR(10), mor_atm_vtr CHAR(1), mor_atm_atr CHAR(10), mor_atm_ltr CHAR(50), mor_causa CHAR(60), div_cap_tri CHAR(50), div_nr_sen2 CHAR(10), div_dt_sen2 CHAR(10), div_dt_div CHAR(10), div_atd_nr CHAR(10), div_atd_par CHAR(1), div_atd_ser CHAR(1), div_atd_uff CHAR(10), div_atd_vol CHAR(1), div_atd_ann CHAR(10), div_atd_ltr CHAR(50), res_ind_res CHAR(60), res_loc_res CHAR(50), res_cap CHAR(20), res_consola CHAR(50), resid_dt CHAR(10), air_nr_fami CHAR(15), air_fami_dt CHAR(10), air_nr_dist CHAR(15), air_dt_isca CHAR(10), air_loc_pro CHAR(50), air_mt_isca CHAR(30), air_nrproti CHAR(10), air_in_isca CHAR(10), air_com_isc CHAR(10), air_dt_canc CHAR(10), air_loc_des CHAR(50), air_mt_canc CHAR(30), air_nrprotc CHAR(10), air_in_canc CHAR(10), air_dt_var CHAR(10), air_mt_var CHAR(30), air_nrprotv CHAR(10), air_in_var CHAR(10), ct1_cit_pos CHAR(40), cit_dt_acq CHAR(10), cit_loc_acq CHAR(50), cit_atca_ann CHAR(10), cit_atca_nr CHAR(10), cit_atca_uff CHAR(10), cit_atca_vol CHAR(1), cit_dt_perd CHAR(10), cit_loc_perd CHAR(50), cit_atcp_ann CHAR(10), cit_atcp_nr CHAR(10), cit_atcp_uff CHAR(10), cit_atcp_vol CHAR(1), note1 CHAR(365), note2 CHAR(365), evento CHAR(50), dt_even CHAR(10), dt_ope CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_ana_00 ON PRN_ANA (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_prn_ana_01 ON PRN_ANA (nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_ana_02 ON PRN_ANA (cognome,nome) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_ana_03 ON PRN_ANA (cognome,nome,dt_nas) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_CID; CREATE TABLE PRN_CID ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg CHAR(10), nr_cid CHAR(12), loc_ril CHAR(50), dt_ril CHAR(10), dt_scad CHAR(10), fl_espa CHAR(1), fl_dupl CHAR(1), statura CHAR(20), capelli CHAR(30), occhi CHAR(30), seg_par CHAR(50) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_cid_00 ON PRN_CID (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_cid_01 ON PRN_CID (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_C15; CREATE TABLE PRN_C15 ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg CHAR(10), nr_cid CHAR(10), loc_ril CHAR(50), dt_ril CHAR(10), dt_scad CHAR(10), tp_cert CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_c15_00 ON PRN_C15 (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_c15_01 ON PRN_C15 (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_CEN; CREATE TABLE PRN_CEN ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg CHAR(10), anno CHAR(4), sez CHAR(5), nr_fami CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_cen_00 ON PRN_CEN (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_cen_01 ON PRN_CEN (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_PEN; CREATE TABLE PRN_PEN ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg CHAR(10), nr_pen CHAR(12), ent_err CHAR(30), dt_ril CHAR(10), catego CHAR(30), qualita CHAR(30), note CHAR(310) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_pen_00 ON PRN_PEN (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_pen_01 ON PRN_PEN (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_LAV; CREATE TABLE PRN_LAV ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg CHAR(10), nr_llav CHAR(10), dt_lav CHAR(10), loc_ril CHAR(50) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_lav_00 ON PRN_LAV (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_lav_01 ON PRN_LAV (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_SOG; CREATE TABLE PRN_SOG ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg CHAR(10), nr_doc CHAR(10), tp_doc CHAR(1), tp_ril CHAR(1), loc_ril CHAR(50), dt_ril_ini CHAR(10), dt_sca_ini CHAR(10), dt_ini_val CHAR(10), dt_rinnovo CHAR(10), dt_sca_ult CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_sog_00 ON PRN_SOG (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_sog_01 ON PRN_SOG (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_PTN; CREATE TABLE PRN_PTN ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg CHAR(10), sg_ptn CHAR(2), nr_ptn CHAR(7), ct_ptn CHAR(1), catego CHAR(2), dt_ril CHAR(10), tip_ve1 CHAR(1), tar_ve1 CHAR(8), tip_ve2 CHAR(1), tar_ve2 CHAR(8), tip_ve3 CHAR(1), tar_ve3 CHAR(8), tip_ve4 CHAR(1), tar_ve4 CHAR(8), tip_ve5 CHAR(1), tar_ve5 CHAR(8), tip_ve6 CHAR(1), tar_ve6 CHAR(8), tip_ve7 CHAR(1), tar_ve7 CHAR(8), tip_ve8 CHAR(1), tar_ve8 CHAR(8), tip_ve9 CHAR(1), tar_ve9 CHAR(8), tip_v10 CHAR(1), tar_v10 CHAR(8), tip_v11 CHAR(1), tar_v11 CHAR(8), tip_v12 CHAR(1), tar_v12 CHAR(8), tip_v13 CHAR(1), tar_v13 CHAR(8), tip_v14 CHAR(1), tar_v14 CHAR(8), tip_v15 CHAR(1), tar_v15 CHAR(8), tip_v16 CHAR(1), tar_v16 CHAR(8), tip_v17 CHAR(1), tar_v17 CHAR(8), tip_v18 CHAR(1), tar_v18 CHAR(8), tip_v19 CHAR(1), tar_v19 CHAR(8), tip_v20 CHAR(1), tar_v20 CHAR(8) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_ptn_00 ON PRN_PTN (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_ptn_01 ON PRN_PTN (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_SUD; CREATE TABLE PRN_SUD ( cod_id NUMBER(10,0), tip_sud CHAR(5), tip_zon CHAR(5), des CHAR(30), ind_cod CHAR(10), ind_via CHAR(50), ind_num CHAR(5), ind_let CHAR(6), des_loc CHAR(30), cod_via CHAR(10), des_via CHAR(50), civ_ini CHAR(5), civ_fin CHAR(5), ecc_let CHAR(6), fl_pd CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_sud_00 ON PRN_SUD (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_LEV; CREATE TABLE PRN_LEV ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), nr_defi CHAR(10), ann_isc CHAR(10), com_isc CHAR(50), fl_corr CHAR(1), esi_vis CHAR(30), dt_esit CHAR(10), mt_canc CHAR(30), dt_canc CHAR(10), mt_aggi CHAR(30), dt_aggi CHAR(10), nr_matr CHAR(30), corpo CHAR(30), catego CHAR(30), grado CHAR(30), dt_armi CHAR(10), dt_cong CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_lev_00 ON PRN_LEV (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_prn_lev_01 ON PRN_LEV (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_ELE; CREATE TABLE PRN_ELE ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), sit_ele CHAR(2), nr_fasc CHAR(10), nr_lgen CHAR(10), ann_isc CHAR(10), sezione CHAR(10), nr_lsez CHAR(10), mot_isc CHAR(30), dt_iscr CHAR(10), nr_iscr CHAR(10), mot_can CHAR(30), dt_canc CHAR(10), nr_canc CHAR(10), fl_dir_pol CHAR(1), ser_dt_scad CHAR(10), scr_fl_ele CHAR(1), scr_fl_albo CHAR(1), scr_nr_albo CHAR(10), scr_nr_iscr CHAR(10), scr_dt_iscr CHAR(10), scr_nr_canc CHAR(10), scr_dt_canc CHAR(10), scr_fl_canc CHAR(30), pre_fl_ele CHAR(1), pre_fl_isca CHAR(1), pre_nr_iscr CHAR(10), pre_dt_iscr CHAR(10), pre_nr_canc CHAR(10), pre_dt_canc CHAR(10), pre_fl_canc CHAR(30), giu_fl_ele CHAR(1), giu_fl_capp CHAR(1), giu_nr_iscr CHAR(10), giu_dt_iscr CHAR(10), giu_nr_canc CHAR(10), giu_dt_canc CHAR(10), giu_fl_canc CHAR(30) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_ele_00 ON PRN_ELE (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_prn_ele_01 ON PRN_ELE (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_ETESS; CREATE TABLE PRN_ETESS ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg CHAR(10), nr_tess CHAR(12), dt_ril CHAR(10), dt_agg CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_etess_00 ON PRN_ETESS (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_etess_01 ON PRN_ETESS (nr_indi,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_CIT; CREATE TABLE PRN_CIT ( cod_id NUMBER(10,0), atc_ann CHAR(10), atc_nr CHAR(10), atc_par CHAR(1), atc_ser CHAR(1), atc_uff CHAR(10), atc_vol CHAR(1), nr_indi CHAR(10), cognome CHAR(30), nome CHAR(35), sesso CHAR(1), dt_nas CHAR(10), dt_eve CHAR(10), tribun CHAR(50), sta_civ CHAR(30), fl_sogg CHAR(1), dt_ope CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_cit_00 ON PRN_CIT (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_NAS; CREATE TABLE PRN_NAS ( cod_id NUMBER(10,0), atn_ann CHAR(10), atn_nr CHAR(10), atn_par CHAR(1), atn_ser CHAR(1), atn_uff CHAR(10), atn_vol CHAR(1), nr_indi CHAR(10), cognome CHAR(45), nome CHAR(45), nom_suc CHAR(80), sesso CHAR(1), dt_nas CHAR(10), ora_nas CHAR(5), loc_nas CHAR(50), cit_pos CHAR(50), pat_nom CHAR(50), dt_nas_p CHAR(10), prof_p CHAR(50), mat_cog_nom CHAR(50), dt_nas_m CHAR(10), prof_m CHAR(50), residenza CHAR(50), nato_mor CHAR(1), fl_sogg CHAR(1), certif CHAR(1), dt_ope CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_nas_00 ON PRN_NAS (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_NOTNA; CREATE TABLE PRN_NOTNA ( cod_id NUMBER(10,0), cod_att NUMBER(10,0), atn_ann CHAR(10), atn_nr CHAR(10), atn_par CHAR(1), atn_ser CHAR(1), atn_uff CHAR(10), atn_vol CHAR(1), num_not CHAR(10), certif CHAR(1), titolo CHAR(71), testo CHAR(500) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_notna_00 ON PRN_NOTNA (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_PUB; CREATE TABLE PRN_PUB ( cod_id NUMBER(10,0), atp_ann CHAR(10), atp_nr CHAR(10), atp_par CHAR(1), atp_ser CHAR(1), atp_uff CHAR(10), atp_vol CHAR(1), o_nr_indi CHAR(10), o_cognome CHAR(45), o_nome CHAR(45), o_dt_nas CHAR(10), o_loc_nas CHAR(50), o_cit_pos CHAR(50), o_profess CHAR(50), o_sta_civ CHAR(50), o_loc_res CHAR(50), o_atn_ann CHAR(10), o_atn_nr CHAR(10), o_atn_par CHAR(1), o_atn_ser CHAR(1), o_atn_uff CHAR(10), o_atn_vol CHAR(1), o_fl_sogg CHAR(1), a_nr_indi CHAR(10), a_cognome CHAR(45), a_nome CHAR(45), a_dt_nas CHAR(10), a_loc_nas CHAR(50), a_cit_pos CHAR(50), a_profess CHAR(50), a_sta_civ CHAR(50), a_loc_res CHAR(50), a_atn_ann CHAR(10), a_atn_nr CHAR(10), a_atn_par CHAR(1), a_atn_ser CHAR(1), a_atn_uff CHAR(10), a_atn_vol CHAR(1), a_fl_sogg CHAR(1), dt_ope CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_pub_00 ON PRN_PUB (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_MAT; CREATE TABLE PRN_MAT ( cod_id NUMBER(10,0), atm_ann CHAR(10), atm_nr CHAR(10), atm_par CHAR(1), atm_ser CHAR(1), atm_uff CHAR(10), atm_vol CHAR(1), o_nr_indi CHAR(10), o_cognome CHAR(45), o_nome CHAR(45), o_dt_nas CHAR(10), o_loc_nas CHAR(50), o_cit_pos CHAR(50), o_profess CHAR(50), o_sta_civ CHAR(50), o_loc_res CHAR(50), o_atn_ann CHAR(10), o_atn_nr CHAR(10), o_atn_par CHAR(1), o_atn_ser CHAR(1), o_atn_uff CHAR(10), o_atn_vol CHAR(1), o_fl_sogg CHAR(1), a_nr_indi CHAR(10), a_cognome CHAR(45), a_nome CHAR(45), a_dt_nas CHAR(10), a_loc_nas CHAR(50), a_cit_pos CHAR(50), a_profess CHAR(50), a_sta_civ CHAR(50), a_loc_res CHAR(50), a_atn_ann CHAR(10), a_atn_nr CHAR(10), a_atn_par CHAR(1), a_atn_ser CHAR(1), a_atn_uff CHAR(10), a_atn_vol CHAR(1), a_fl_sogg CHAR(1), loc_mat CHAR(50), dt_mat CHAR(10), ora_mat CHAR(5), separ CHAR(1), rito CHAR(20), certif CHAR(1), dt_ope CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_mat_00 ON PRN_MAT (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_MOR; CREATE TABLE PRN_MOR ( cod_id NUMBER(10,0), atm_ann CHAR(10), atm_nr CHAR(10), atm_par CHAR(1), atm_ser CHAR(1), atm_uff CHAR(10), atm_vol CHAR(1), nr_indi CHAR(10), cognome CHAR(45), nome CHAR(45), sesso CHAR(1), dt_mor CHAR(10), ora_mor CHAR(5), loc_mor CHAR(50), dt_nas CHAR(10), loc_nas CHAR(50), loc_res CHAR(50), cit_pos CHAR(50), profess CHAR(50), sta_civ CHAR(20), coniuge CHAR(50), pat_nom CHAR(50), mat_cog_nom CHAR(50), atn_ann CHAR(10), atn_nr CHAR(10), atn_par CHAR(1), atn_ser CHAR(1), atn_uff CHAR(10), atn_vol CHAR(1), fl_sogg CHAR(1), certif CHAR(1), dt_ope CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_mor_00 ON PRN_MOR (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_PAR; CREATE TABLE PRN_PAR ( cod_id NUMBER(10,0), codice CHAR(4), chiesa CHAR(120), ministro CHAR(50), celebrante CHAR(50), qualita CHAR(60), articolo CHAR(2), rito CHAR(110), luogo CHAR(33) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_par_00 ON PRN_PAR (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_TES; CREATE TABLE PRN_TES ( cod_id NUMBER(10,0), codice CHAR(4), nome CHAR(40), sesso CHAR(1), loc_nas CHAR(33), dt_nas CHAR(10), profess CHAR(20), loc_res CHAR(33) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_tes_00 ON PRN_TES (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_UFF; CREATE TABLE PRN_UFF ( cod_id NUMBER(10,0), codice CHAR(4), nome CHAR(60), titolo CHAR(72) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_uff_00 ON PRN_UFF (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_ANA; CREATE TABLE TTMP_ANA ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), nr_fami NUMBER(10,0), nr_fami_dt DATE, cognome CHAR(45), nome CHAR(45), nom_suc CHAR(45), sesso CHAR(1), loc_nas CHAR(50), dt_nas DATE, ann_nas NUMBER(5,0), ora_min CHAR(5), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), atn_ann NUMBER(5,0), atn_ntr NUMBER(10,0), atn_ptr CHAR(1), atn_str CHAR(1), atn_utr NUMBER(5,0), atn_vtr CHAR(1), atn_atr NUMBER(5,0), atn_ltr CHAR(50), atto_par CHAR(50), ind_cod NUMBER(5,0), ind_via CHAR(50), ind_num NUMBER(5,0), ind_let CHAR(6), ind_int NUMBER(5,0), ind_sca CHAR(1), indir_dt DATE, fl_sogg CHAR(1), fl_iscr NUMBER(5,0), fl_canc NUMBER(5,0), dt_iscr DATE, dt_canc DATE, fl_cert CHAR(1), cert_note CHAR(300), fl_espa CHAR(1), pat_cog CHAR(45), pat_nom CHAR(45), mat_cog CHAR(45), mat_nom CHAR(45), nr_conv NUMBER(10,0), conviv CHAR(80), rap_par CHAR(20), rap_par_dt DATE, cit_pos CHAR(40), profess CHAR(30), pro_pos CHAR(1), pro_set CHAR(1), pro_con CHAR(1), profess_dt DATE, tit_stu CHAR(25), tit_stu_dt DATE, cod_fis CHAR(16), fl_cf CHAR(1), sta_civ CHAR(20), con_cognome CHAR(45), con_nome CHAR(45), con_nr_indc NUMBER(10,0), con_loc_nas CHAR(50), con_dt_nas DATE, con_loc_mat CHAR(50), con_dt_mat DATE, con_atm_nr NUMBER(10,0), con_atm_par CHAR(1), con_atm_ser CHAR(1), con_atm_uff NUMBER(5,0), con_atm_vol CHAR(1), con_atm_ann NUMBER(5,0), con_atm_ntr NUMBER(10,0), con_atm_ptr CHAR(1), con_atm_str CHAR(1), con_atm_utr NUMBER(5,0), con_atm_vtr CHAR(1), con_atm_atr NUMBER(5,0), con_atm_ltr CHAR(50), imm_loc_pro CHAR(50), imm_dt_imm DATE, imm_nr_prat NUMBER(10,0), emi_loc_emi CHAR(50), emi_dt_emi DATE, emi_nr_prat NUMBER(10,0), irr_loc_can CHAR(50), irr_dt_can DATE, irr_nr_prac NUMBER(10,0), irr_loc_ric CHAR(50), irr_loc_isc CHAR(50), irr_dt_ric DATE, irr_nr_prai NUMBER(10,0), ved_loc_mor CHAR(50), ved_dt_mor DATE, ved_atm_nr NUMBER(10,0), ved_atm_par CHAR(1), ved_atm_ser CHAR(1), ved_atm_uff NUMBER(5,0), ved_atm_vol CHAR(1), ved_atm_ann NUMBER(5,0), ved_atm_ntr NUMBER(10,0), ved_atm_ptr CHAR(1), ved_atm_str CHAR(1), ved_atm_utr NUMBER(5,0), ved_atm_vtr CHAR(1), ved_atm_atr NUMBER(5,0), ved_atm_ltr CHAR(50), mor_loc_mor CHAR(50), mor_dt_mor DATE, mor_atm_nr NUMBER(10,0), mor_atm_par CHAR(1), mor_atm_ser CHAR(1), mor_atm_uff NUMBER(5,0), mor_atm_vol CHAR(1), mor_atm_ann NUMBER(5,0), mor_atm_ntr NUMBER(10,0), mor_atm_ptr CHAR(1), mor_atm_str CHAR(1), mor_atm_utr NUMBER(5,0), mor_atm_vtr CHAR(1), mor_atm_atr NUMBER(5,0), mor_atm_ltr CHAR(50), mor_causa CHAR(60), div_cap_tri CHAR(50), div_nr_sen2 NUMBER(10,0), div_dt_sen2 DATE, div_dt_div DATE, div_atd_nr NUMBER(10,0), div_atd_par CHAR(1), div_atd_ser CHAR(1), div_atd_uff NUMBER(5,0), div_atd_vol CHAR(1), div_atd_ann NUMBER(5,0), div_atd_ltr CHAR(50), res_ind_res CHAR(60), res_loc_res CHAR(50), res_cap CHAR(20), res_consola CHAR(50), resid_dt DATE, air_nr_fami CHAR(15), air_fami_dt DATE, air_nr_dist CHAR(15), air_dt_isca DATE, air_loc_pro CHAR(50), air_mt_isca NUMBER(5,0), air_nrproti NUMBER(10,0), air_in_isca NUMBER(5,0), air_com_isc NUMBER(5,0), air_dt_canc DATE, air_loc_des CHAR(50), air_mt_canc NUMBER(5,0), air_nrprotc NUMBER(10,0), air_in_canc NUMBER(5,0), air_dt_var DATE, air_mt_var NUMBER(5,0), air_nrprotv NUMBER(10,0), air_in_var NUMBER(5,0), ct1_cit_pos CHAR(40), cit_dt_acq DATE, cit_loc_acq CHAR(50), cit_atca_ann NUMBER(5,0), cit_atca_nr NUMBER(10,0), cit_atca_uff NUMBER(5,0), cit_atca_vol CHAR(1), cit_dt_perd DATE, cit_loc_perd CHAR(50), cit_atcp_ann NUMBER(5,0), cit_atcp_nr NUMBER(10,0), cit_atcp_uff NUMBER(5,0), cit_atcp_vol CHAR(1), note1 CHAR(365), note2 CHAR(365), evento CHAR(50), dt_even DATE, dt_ope DATE, fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_ana_00 ON TTMP_ANA (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_ana_01 ON TTMP_ANA (nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_ana_02 ON TTMP_ANA (cognome,nome) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_ana_03 ON TTMP_ANA (cognome,nome,dt_nas) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_ana_04 ON TTMP_ANA (cognome,nome,con_dt_mat) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_ana_05 ON TTMP_ANA (cognome,nome,div_dt_div) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_ana_06 ON TTMP_ANA (cognome,nome,ved_dt_mor,sta_civ) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_ana_07 ON TTMP_ANA (cognome,nome,mor_dt_mor) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_ana_08 ON TTMP_ANA (ind_cod,ind_via) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_CID; CREATE TABLE TTMP_CID ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_cid CHAR(12), loc_ril CHAR(50), dt_ril DATE, dt_scad DATE, fl_espa CHAR(1), fl_dupl CHAR(1), statura CHAR(4), capelli CHAR(30), occhi CHAR(30), seg_par CHAR(50), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_cid_00 ON TTMP_CID (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_cid_01 ON TTMP_CID (nr_indi,prg,dt_ril) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_C15; CREATE TABLE TTMP_C15 ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_cid NUMBER(10,0), dt_ril DATE, dt_scad DATE, loc_ril CHAR(50), tp_cert CHAR(1), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_c15_00 ON TTMP_C15 (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_c15_01 ON TTMP_C15 (nr_indi,prg,dt_ril) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_CEN; CREATE TABLE TTMP_CEN ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg NUMBER(5,0), anno NUMBER(5,0), sez NUMBER(5,0), nr_fami NUMBER(10,0), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_cen_00 ON TTMP_CEN (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_cen_01 ON TTMP_CEN (nr_indi,prg,anno) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_PEN; CREATE TABLE TTMP_PEN ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_pen CHAR(12), ent_err CHAR(30), dt_ril DATE, catego CHAR(30), qualita CHAR(30), note CHAR(310), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_pen_00 ON TTMP_PEN (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_pen_01 ON TTMP_PEN (nr_indi,prg,dt_ril) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_LAV; CREATE TABLE TTMP_LAV ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_llav NUMBER(10,0), dt_lav DATE, loc_ril CHAR(50), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_lav_00 ON TTMP_LAV (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_lav_01 ON TTMP_LAV (nr_indi,prg,dt_lav) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_SOG; CREATE TABLE TTMP_SOG ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_doc CHAR(10), tp_doc CHAR(1), tp_ril CHAR(1), loc_ril CHAR(50), dt_ril_ini DATE, dt_sca_ini DATE, dt_ini_val DATE, dt_rinnovo DATE, dt_sca_ult DATE, fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_sog_00 ON TTMP_SOG (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_sog_01 ON TTMP_SOG (nr_indi,prg,dt_ril_ini) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_PTN; CREATE TABLE TTMP_PTN ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg NUMBER(5,0), sg_ptn CHAR(2), nr_ptn CHAR(7), ct_ptn CHAR(1), catego CHAR(2), dt_ril DATE, tip_ve1 CHAR(1), tar_ve1 CHAR(8), tip_ve2 CHAR(1), tar_ve2 CHAR(8), tip_ve3 CHAR(1), tar_ve3 CHAR(8), tip_ve4 CHAR(1), tar_ve4 CHAR(8), tip_ve5 CHAR(1), tar_ve5 CHAR(8), tip_ve6 CHAR(1), tar_ve6 CHAR(8), tip_ve7 CHAR(1), tar_ve7 CHAR(8), tip_ve8 CHAR(1), tar_ve8 CHAR(8), tip_ve9 CHAR(1), tar_ve9 CHAR(8), tip_v10 CHAR(1), tar_v10 CHAR(8), tip_v11 CHAR(1), tar_v11 CHAR(8), tip_v12 CHAR(1), tar_v12 CHAR(8), tip_v13 CHAR(1), tar_v13 CHAR(8), tip_v14 CHAR(1), tar_v14 CHAR(8), tip_v15 CHAR(1), tar_v15 CHAR(8), tip_v16 CHAR(1), tar_v16 CHAR(8), tip_v17 CHAR(1), tar_v17 CHAR(8), tip_v18 CHAR(1), tar_v18 CHAR(8), tip_v19 CHAR(1), tar_v19 CHAR(8), tip_v20 CHAR(1), tar_v20 CHAR(8), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_ptn_00 ON TTMP_PTN (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_ptn_01 ON TTMP_PTN (nr_indi,prg,dt_ril) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_SUD; CREATE TABLE TTMP_SUD ( cod_id NUMBER(10,0), tip_sud NUMBER(5,0), tip_zon NUMBER(5,0), des CHAR(30), ind_cod NUMBER(5,0), ind_via CHAR(50), ind_num NUMBER(5,0), ind_let CHAR(6), des_loc CHAR(30), cod_via NUMBER(5,0), des_via CHAR(50), civ_ini NUMBER(5,0), civ_fin NUMBER(5,0), ecc_let CHAR(6), fl_pd CHAR(1), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_sud_00 ON TTMP_SUD (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_sud_01 ON TTMP_SUD (tip_sud,tip_zon) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_LEV; CREATE TABLE TTMP_LEV ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), nr_defi NUMBER(10,0), ann_isc NUMBER(5,0), com_isc CHAR(50), fl_corr CHAR(1), esi_vis CHAR(30), dt_esit DATE, mt_canc NUMBER(5,0), dt_canc DATE, mt_aggi NUMBER(5,0), dt_aggi DATE, nr_matr CHAR(30), corpo CHAR(30), catego CHAR(30), grado CHAR(30), dt_armi DATE, dt_cong DATE, fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_lev_00 ON TTMP_LEV (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_lev_01 ON TTMP_LEV (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_ELE; CREATE TABLE TTMP_ELE ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), sit_ele CHAR(2), nr_fasc NUMBER(10,0), nr_lgen NUMBER(10,0), ann_isc NUMBER(5,0), sezione NUMBER(5,0), nr_lsez NUMBER(10,0), mot_isc CHAR(3), dt_iscr DATE, nr_iscr NUMBER(10,0), mot_can CHAR(3), dt_canc DATE, nr_canc NUMBER(10,0), fl_dir_pol CHAR(1), ser_dt_scad DATE, scr_fl_ele CHAR(1), scr_fl_albo CHAR(1), scr_nr_albo NUMBER(10,0), scr_nr_iscr NUMBER(10,0), scr_dt_iscr DATE, scr_nr_canc NUMBER(10,0), scr_dt_canc DATE, scr_fl_canc NUMBER(5,0), pre_fl_ele CHAR(1), pre_fl_isca CHAR(1), pre_nr_iscr NUMBER(10,0), pre_dt_iscr DATE, pre_nr_canc NUMBER(10,0), pre_dt_canc DATE, pre_fl_canc NUMBER(5,0), giu_fl_ele CHAR(1), giu_fl_capp CHAR(1), giu_nr_iscr NUMBER(10,0), giu_dt_iscr DATE, giu_nr_canc NUMBER(10,0), giu_dt_canc DATE, giu_fl_canc NUMBER(5,0), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_ele_00 ON TTMP_ELE (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_ele_01 ON TTMP_ELE (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_ETESS; CREATE TABLE TTMP_ETESS ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), prg NUMBER(5,0), nr_tess NUMBER(10,0), dt_ril DATE, dt_agg DATE, fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_etess_00 ON TTMP_ETESS (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_etess_01 ON TTMP_ETESS (nr_indi,prg,dt_ril) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_STO; CREATE TABLE TTMP_STO ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), evento CHAR(50), dt_even DATE, dt_ope DATE, dt_finoa DATE, nr_fami NUMBER(10,0), nr_fami_dt DATE, cognome CHAR(45), nome CHAR(45), nom_suc CHAR(45), sesso CHAR(1), loc_nas CHAR(50), dt_nas DATE, ann_nas NUMBER(5,0), ora_min CHAR(5), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), atn_ann NUMBER(5,0), atn_ntr NUMBER(10,0), atn_ptr CHAR(1), atn_str CHAR(1), atn_utr NUMBER(5,0), atn_vtr CHAR(1), atn_atr NUMBER(5,0), atn_ltr CHAR(50), atto_par CHAR(50), ind_cod NUMBER(5,0), ind_via CHAR(50), ind_num NUMBER(5,0), ind_let CHAR(6), ind_int NUMBER(5,0), ind_sca CHAR(1), indir_dt DATE, fl_sogg CHAR(1), fl_iscr NUMBER(5,0), fl_canc NUMBER(5,0), dt_iscr DATE, dt_canc DATE, fl_cert CHAR(1), cert_note CHAR(300), fl_espa CHAR(1), pat_cog CHAR(45), pat_nom CHAR(45), mat_cog CHAR(45), mat_nom CHAR(45), nr_conv NUMBER(10,0), conviv CHAR(80), rap_par CHAR(20), rap_par_dt DATE, cit_pos CHAR(40), profess CHAR(30), pro_pos CHAR(1), pro_set CHAR(1), pro_con CHAR(1), profess_dt DATE, tit_stu CHAR(25), tit_stu_dt DATE, cod_fis CHAR(16), fl_cf CHAR(1), sta_civ CHAR(20), con_cognome CHAR(45), con_nome CHAR(45), con_nr_indc NUMBER(10,0), con_loc_nas CHAR(50), con_dt_nas DATE, con_loc_mat CHAR(50), con_dt_mat DATE, con_atm_nr NUMBER(10,0), con_atm_par CHAR(1), con_atm_ser CHAR(1), con_atm_uff NUMBER(5,0), con_atm_vol CHAR(1), con_atm_ann NUMBER(5,0), con_atm_ntr NUMBER(10,0), con_atm_ptr CHAR(1), con_atm_str CHAR(1), con_atm_utr NUMBER(5,0), con_atm_vtr CHAR(1), con_atm_atr NUMBER(5,0), con_atm_ltr CHAR(50), imm_loc_pro CHAR(50), imm_dt_imm DATE, imm_nr_prat NUMBER(10,0), emi_loc_emi CHAR(50), emi_dt_emi DATE, emi_nr_prat NUMBER(10,0), irr_loc_can CHAR(50), irr_dt_can DATE, irr_nr_prac NUMBER(10,0), irr_loc_ric CHAR(50), irr_loc_isc CHAR(50), irr_dt_ric DATE, irr_nr_prai NUMBER(10,0), ved_loc_mor CHAR(50), ved_dt_mor DATE, ved_atm_nr NUMBER(10,0), ved_atm_par CHAR(1), ved_atm_ser CHAR(1), ved_atm_uff NUMBER(5,0), ved_atm_vol CHAR(1), ved_atm_ann NUMBER(5,0), ved_atm_ntr NUMBER(10,0), ved_atm_ptr CHAR(1), ved_atm_str CHAR(1), ved_atm_utr NUMBER(5,0), ved_atm_vtr CHAR(1), ved_atm_atr NUMBER(5,0), ved_atm_ltr CHAR(50), mor_loc_mor CHAR(50), mor_dt_mor DATE, mor_atm_nr NUMBER(10,0), mor_atm_par CHAR(1), mor_atm_ser CHAR(1), mor_atm_uff NUMBER(5,0), mor_atm_vol CHAR(1), mor_atm_ann NUMBER(5,0), mor_atm_ntr NUMBER(10,0), mor_atm_ptr CHAR(1), mor_atm_str CHAR(1), mor_atm_utr NUMBER(5,0), mor_atm_vtr CHAR(1), mor_atm_atr NUMBER(5,0), mor_atm_ltr CHAR(50), mor_causa CHAR(60), div_cap_tri CHAR(50), div_nr_sen2 NUMBER(10,0), div_dt_sen2 DATE, div_dt_div DATE, div_atd_nr NUMBER(10,0), div_atd_par CHAR(1), div_atd_ser CHAR(1), div_atd_uff NUMBER(5,0), div_atd_vol CHAR(1), div_atd_ann NUMBER(5,0), div_atd_ltr CHAR(50), res_ind_res CHAR(60), res_loc_res CHAR(50), res_cap CHAR(20), res_consola CHAR(50), resid_dt DATE, air_nr_fami CHAR(15), air_fami_dt DATE, air_nr_dist CHAR(15), air_dt_isca DATE, air_loc_pro CHAR(50), air_mt_isca NUMBER(5,0), air_nrproti NUMBER(10,0), air_in_isca NUMBER(5,0), air_com_isc NUMBER(5,0), air_dt_canc DATE, air_loc_des CHAR(50), air_mt_canc NUMBER(5,0), air_nrprotc NUMBER(10,0), air_in_canc NUMBER(5,0), air_dt_var DATE, air_mt_var NUMBER(5,0), air_nrprotv NUMBER(10,0), air_in_var NUMBER(5,0), ct1_cit_pos CHAR(40), cit_dt_acq DATE, cit_loc_acq CHAR(50), cit_atca_ann NUMBER(5,0), cit_atca_nr NUMBER(10,0), cit_atca_uff NUMBER(5,0), cit_atca_vol CHAR(1), cit_dt_perd DATE, cit_loc_perd CHAR(50), cit_atcp_ann NUMBER(5,0), cit_atcp_nr NUMBER(10,0), cit_atcp_uff NUMBER(5,0), cit_atcp_vol CHAR(1), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_sto_00 ON TTMP_STO (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_sto_01 ON TTMP_STO (nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_sto_02 ON TTMP_STO (cognome,nome) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_sto_03 ON TTMP_STO (cognome,nome,dt_nas) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_sto_04 ON TTMP_STO (cognome,nome,con_dt_mat) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_sto_05 ON TTMP_STO (cognome,nome,div_dt_div) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_sto_06 ON TTMP_STO (cognome,nome,ved_dt_mor,sta_civ) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_sto_07 ON TTMP_STO (cognome,nome,mor_dt_mor) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_sto_08 ON TTMP_STO (ind_cod,ind_via) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_CIT; CREATE TABLE TTMP_CIT ( cod_id NUMBER(10,0), atc_ann NUMBER(5,0), atc_nr NUMBER(10,0), atc_par CHAR(1), atc_ser CHAR(1), atc_uff NUMBER(5,0), atc_vol CHAR(1), nr_indi NUMBER(10,0), cognome CHAR(30), nome CHAR(35), sesso CHAR(1), dt_nas DATE, dt_eve DATE, tribun CHAR(50), sta_civ CHAR(30), fl_sogg CHAR(1), dt_ope DATE, fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_cit_00 ON TTMP_CIT (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_cit_01 ON TTMP_CIT (atc_ann,atc_nr,atc_par,atc_ser,atc_uff,atc_vol) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_NAS; CREATE TABLE TTMP_NAS ( cod_id NUMBER(10,0), atn_ann NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), nr_indi NUMBER(10,0), cognome CHAR(45), nome CHAR(45), nom_suc CHAR(80), sesso CHAR(1), dt_nas DATE, ora_nas CHAR(5), loc_nas CHAR(50), cit_pos CHAR(50), pat_nom CHAR(50), dt_nas_p DATE, prof_p CHAR(50), mat_cog_nom CHAR(50), dt_nas_m DATE, prof_m CHAR(50), residenza CHAR(50), nato_mor CHAR(1), fl_sogg CHAR(1), certif CHAR(1), dt_ope DATE, fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_nas_00 ON TTMP_NAS (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_nas_01 ON TTMP_NAS (atn_ann,atn_nr,atn_par,atn_ser,atn_uff,atn_vol) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_NOTNA; CREATE TABLE TTMP_NOTNA ( cod_id NUMBER(10,0), cod_att NUMBER(10,0), atn_ann NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), num_not NUMBER(5,0), certif CHAR(1), titolo CHAR(71), testo CHAR(500), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_notna_00 ON TTMP_NOTNA (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_notna_01 ON TTMP_NOTNA (cod_att) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_notna_02 ON TTMP_NOTNA (atn_ann,atn_nr,atn_par,atn_ser,atn_uff,atn_vol,num_not) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_PUB; CREATE TABLE TTMP_PUB ( cod_id NUMBER(10,0), atp_ann NUMBER(5,0), atp_nr NUMBER(10,0), atp_par CHAR(1), atp_ser CHAR(1), atp_uff NUMBER(5,0), atp_vol CHAR(1), o_nr_indi NUMBER(10,0), o_cognome CHAR(45), o_nome CHAR(45), o_dt_nas DATE, o_loc_nas CHAR(50), o_cit_pos CHAR(50), o_profess CHAR(50), o_sta_civ CHAR(50), o_loc_res CHAR(50), o_atn_ann NUMBER(5,0), o_atn_nr NUMBER(10,0), o_atn_par CHAR(1), o_atn_ser CHAR(1), o_atn_uff NUMBER(5,0), o_atn_vol CHAR(1), o_fl_sogg CHAR(1), a_nr_indi NUMBER(10,0), a_cognome CHAR(45), a_nome CHAR(45), a_dt_nas DATE, a_loc_nas CHAR(50), a_cit_pos CHAR(50), a_profess CHAR(50), a_sta_civ CHAR(50), a_loc_res CHAR(50), a_atn_ann NUMBER(5,0), a_atn_nr NUMBER(10,0), a_atn_par CHAR(1), a_atn_ser CHAR(1), a_atn_uff NUMBER(5,0), a_atn_vol CHAR(1), a_fl_sogg CHAR(1), dt_ope DATE, fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_pub_00 ON TTMP_PUB (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_pub_01 ON TTMP_PUB (atp_ann,atp_nr,atp_par,atp_ser,atp_uff,atp_vol) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_MAT; CREATE TABLE TTMP_MAT ( cod_id NUMBER(10,0), atm_ann NUMBER(5,0), atm_nr NUMBER(10,0), atm_par CHAR(1), atm_ser CHAR(1), atm_uff NUMBER(5,0), atm_vol CHAR(1), o_nr_indi NUMBER(10,0), o_cognome CHAR(45), o_nome CHAR(45), o_dt_nas DATE, o_loc_nas CHAR(50), o_cit_pos CHAR(50), o_profess CHAR(50), o_sta_civ CHAR(50), o_loc_res CHAR(50), o_atn_ann NUMBER(5,0), o_atn_nr NUMBER(10,0), o_atn_par CHAR(1), o_atn_ser CHAR(1), o_atn_uff NUMBER(5,0), o_atn_vol CHAR(1), o_fl_sogg CHAR(1), a_nr_indi NUMBER(10,0), a_cognome CHAR(45), a_nome CHAR(45), a_dt_nas DATE, a_loc_nas CHAR(50), a_cit_pos CHAR(50), a_profess CHAR(50), a_sta_civ CHAR(50), a_loc_res CHAR(50), a_atn_ann NUMBER(5,0), a_atn_nr NUMBER(10,0), a_atn_par CHAR(1), a_atn_ser CHAR(1), a_atn_uff NUMBER(5,0), a_atn_vol CHAR(1), a_fl_sogg CHAR(1), loc_mat CHAR(50), dt_mat DATE, ora_mat CHAR(5), separ CHAR(1), rito CHAR(20), certif CHAR(1), dt_ope DATE, fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_mat_00 ON TTMP_MAT (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_mat_01 ON TTMP_MAT (atm_ann,atm_nr,atm_par,atm_ser,atm_uff,atm_vol) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_NOTMA; CREATE TABLE TTMP_NOTMA ( cod_id NUMBER(10,0), cod_att NUMBER(10,0), atm_ann NUMBER(5,0), atm_nr NUMBER(10,0), atm_par CHAR(1), atm_ser CHAR(1), atm_uff NUMBER(5,0), atm_vol CHAR(1), num_not NUMBER(5,0), certif CHAR(1), titolo CHAR(71), testo CHAR(500), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_notma_00 ON TTMP_NOTMA (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_notma_01 ON TTMP_NOTMA (cod_att) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_notma_02 ON TTMP_NOTMA (atm_ann,atm_nr,atm_par,atm_ser,atm_uff,atm_vol,num_not) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_MOR; CREATE TABLE TTMP_MOR ( cod_id NUMBER(10,0), atm_ann NUMBER(5,0), atm_nr NUMBER(10,0), atm_par CHAR(1), atm_ser CHAR(1), atm_uff NUMBER(5,0), atm_vol CHAR(1), nr_indi NUMBER(10,0), cognome CHAR(45), nome CHAR(45), sesso CHAR(1), dt_mor DATE, ora_mor CHAR(5), loc_mor CHAR(50), dt_nas DATE, loc_nas CHAR(50), loc_res CHAR(50), cit_pos CHAR(50), profess CHAR(50), sta_civ CHAR(20), coniuge CHAR(50), pat_nom CHAR(50), mat_cog_nom CHAR(50), atn_ann NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), fl_sogg CHAR(1), certif CHAR(1), dt_ope DATE, fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_mor_00 ON TTMP_MOR (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_mor_01 ON TTMP_MOR (atm_ann,atm_nr,atm_par,atm_ser,atm_uff,atm_vol) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_NOTMO; CREATE TABLE TTMP_NOTMO ( cod_id NUMBER(10,0), cod_att NUMBER(10,0), atm_ann NUMBER(5,0), atm_nr NUMBER(10,0), atm_par CHAR(1), atm_ser CHAR(1), atm_uff NUMBER(5,0), atm_vol CHAR(1), num_not NUMBER(5,0), certif CHAR(1), titolo CHAR(71), testo CHAR(500), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_notmo_00 ON TTMP_NOTMO (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_notmo_01 ON TTMP_NOTMO (cod_att) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_notmo_02 ON TTMP_NOTMO (atm_ann,atm_nr,atm_par,atm_ser,atm_uff,atm_vol,num_not) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_PAR; CREATE TABLE TTMP_PAR ( cod_id NUMBER(10,0), codice CHAR(4), chiesa CHAR(120), ministro CHAR(50), celebrante CHAR(50), qualita CHAR(60), articolo CHAR(2), rito CHAR(110), luogo CHAR(33), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_par_00 ON TTMP_PAR (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_par_01 ON TTMP_PAR (codice) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_par_02 ON TTMP_PAR (chiesa) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_TES; CREATE TABLE TTMP_TES ( cod_id NUMBER(10,0), codice CHAR(4), nome CHAR(40), sesso CHAR(1), loc_nas CHAR(33), dt_nas DATE, profess CHAR(20), loc_res CHAR(33), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_tes_00 ON TTMP_TES (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_tes_01 ON TTMP_TES (codice) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_tes_02 ON TTMP_TES (nome) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TTMP_UFF; CREATE TABLE TTMP_UFF ( cod_id NUMBER(10,0), codice CHAR(4), nome CHAR(60), titolo CHAR(72), fl_ok CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ttmp_uff_00 ON TTMP_UFF (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_ttmp_uff_01 ON TTMP_UFF (codice) TABLESPACE WORKINGINDEX; CREATE INDEX i_ttmp_uff_02 ON TTMP_UFF (nome) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_NOTMA; CREATE TABLE PRN_NOTMA ( cod_id NUMBER(10,0), cod_att NUMBER(10,0), atm_ann CHAR(10), atm_nr CHAR(10), atm_par CHAR(1), atm_ser CHAR(1), atm_uff CHAR(10), atm_vol CHAR(1), num_not CHAR(10), certif CHAR(1), titolo CHAR(71), testo CHAR(500) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_notma_00 ON PRN_NOTMA (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_NOTMO; CREATE TABLE PRN_NOTMO ( cod_id NUMBER(10,0), cod_att NUMBER(10,0), atm_ann CHAR(10), atm_nr CHAR(10), atm_par CHAR(1), atm_ser CHAR(1), atm_uff CHAR(10), atm_vol CHAR(1), num_not CHAR(10), certif CHAR(1), titolo CHAR(71), testo CHAR(500) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_notmo_00 ON PRN_NOTMO (cod_id) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_FAM; CREATE TABLE TMP_FAM ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), fl_ord NUMBER(5,0), dt_nas DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_fam ON TMP_FAM (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_CARI; CREATE TABLE TMP_CARI ( id_tmp NUMBER(10,0), tp CHAR(1), mese NUMBER(5,0), evento NUMBER(5,0), cnt NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_cari ON TMP_CARI (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_PUB; CREATE TABLE TMP_PUB ( id_tmp NUMBER(10,0), cod NUMBER(10,0), atp_ann NUMBER(5,0), atp_nr NUMBER(10,0), atp_par CHAR(1), atp_ser CHAR(1), atp_uff NUMBER(5,0), atp_vol CHAR(1), atp_luilei CHAR(1), cognome CHAR(30), nome CHAR(35), nr_indi NUMBER(10,0), dt_nas DATE, loc_nas CHAR(33), cod_loc_nas NUMBER(10,0), fl_sogg CHAR(1), cit_pos CHAR(20), cod_cit_pos NUMBER(5,0), profess CHAR(30), cod_profes NUMBER(10,0), statociv CHAR(20), cod_statociv CHAR(2), loc_res CHAR(33), cod_loc_res NUMBER(10,0), atn_ann NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), hl_code CHAR(8), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_pub ON TMP_PUB (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_PEN; CREATE TABLE TMP_PEN ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), prg_pen NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_pen ON TMP_PEN (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_DOC; CREATE TABLE TMP_DOC ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), tip_doc CHAR(3), cod_doc CHAR(16) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_doc ON TMP_DOC (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_AP4; CREATE TABLE TMP_AP4 ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_ap4 ON TMP_AP4 (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_STM; CREATE TABLE TMP_STM ( id_tmp NUMBER(10,0), row_id NUMBER(10,0), nr_indi NUMBER(10,0), cognome CHAR(30), nome CHAR(35), dt_nas DATE, cod_eve NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_stm ON TMP_STM (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_VAR; CREATE TABLE TMP_VAR ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cognome CHAR(30), nome CHAR(30), dt_nas DATE, loc_nas CHAR(100), sesso CHAR(1), fl_sogg CHAR(1), nr_fami NUMBER(10,0), cognome_is CHAR(30), nome_is CHAR(30), des_via CHAR(50), ind_res CHAR(100), nr_ragr NUMBER(5,0), evento1 CHAR(60), evento2 CHAR(60), evento3 CHAR(60), evento4 CHAR(60), evento5 CHAR(60), dt_even DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_var ON TMP_VAR (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_NTG; CREATE TABLE TMP_NTG ( id_tmp NUMBER(10,0), nr_row NUMBER(10,0), tp_rec CHAR(4), dt_ris CHAR(20), cod_err CHAR(4), des_err CHAR(100), pro_tra CHAR(12), pro_ris CHAR(12), cod_fis CHAR(16), cod_ris CHAR(4), des_ris CHAR(40) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_ntg ON TMP_NTG (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_CIV; CREATE TABLE TMP_CIV ( id_tmp NUMBER(10,0), cod_zon NUMBER(5,0), ind_via NUMBER(5,0), sta_civ CHAR(2) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_civ ON TMP_CIV (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_ETA; CREATE TABLE TMP_ETA ( id_tmp NUMBER(10,0), cod_zon NUMBER(5,0), ind_via NUMBER(5,0), ann_nas NUMBER(5,0), sesso CHAR(1) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_eta ON TMP_ETA (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_FA2; CREATE TABLE TMP_FA2 ( id_tmp NUMBER(10,0), cod_zon NUMBER(5,0), ind_via NUMBER(5,0), nr_comp NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_fa2 ON TMP_FA2 (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_POP_IM2; CREATE TABLE TMP_POP_IM2 ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cod_eve NUMBER(5,0), dt_even DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_pop_im2 ON TMP_POP_IM2 (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_POP_NA2; CREATE TABLE TMP_POP_NA2 ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cod_eve NUMBER(5,0), dt_even DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_pop_na2 ON TMP_POP_NA2 (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_MOV_IM2; CREATE TABLE TMP_MOV_IM2 ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cod_eve NUMBER(5,0), dt_even DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_mov_im2 ON TMP_MOV_IM2 (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_MOV_NA2; CREATE TABLE TMP_MOV_NA2 ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cod_eve NUMBER(5,0), dt_even DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_mov_na2 ON TMP_MOV_NA2 (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_MIN_IM2; CREATE TABLE TMP_MIN_IM2 ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cod_eve NUMBER(5,0), dt_even DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_min_im2 ON TMP_MIN_IM2 (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_MIN_NA2; CREATE TABLE TMP_MIN_NA2 ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cod_eve NUMBER(5,0), dt_even DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_min_na2 ON TMP_MIN_NA2 (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_POP; CREATE TABLE TMP_POP ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), dt_even DATE, cit_pos NUMBER(10,0), fl_sogg CHAR(1), dt_iscr DATE, sesso CHAR(1), dt_nas DATE, dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_pop_1 ON TMP_POP (id_tmp) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_pop_2 ON TMP_POP (nr_indi,dt_ope) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_pop_3 ON TMP_POP (id_tmp,nr_indi,dt_ope) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_pop_4 ON TMP_POP (id_tmp,nr_indi,dt_even) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_POP2; CREATE TABLE TMP_POP2 ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), dt_even DATE, cit_pos NUMBER(10,0), fl_sogg CHAR(1), dt_iscr DATE, sesso CHAR(1), dt_nas DATE, dt_ope DATE, dt_reg DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_pop2_1 ON TMP_POP2 (id_tmp) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_pop2_2 ON TMP_POP2 (nr_indi,dt_reg) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_pop2_3 ON TMP_POP2 (id_tmp,nr_indi,dt_ope) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_pop2_4 ON TMP_POP2 (id_tmp,nr_indi,dt_even) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_P3; CREATE TABLE TMP_P3 ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), nr_fami NUMBER(10,0), rap_par CHAR(2) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_p3_1 ON TMP_P3 (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_FIN; CREATE TABLE TMP_FIN ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_fin_1 ON TMP_FIN (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_INI; CREATE TABLE TMP_INI ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_ini_1 ON TMP_INI (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_MAS; CREATE TABLE TMP_MAS ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), prg_cas NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_mas ON TMP_MAS (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_IND; CREATE TABLE TMP_IND ( id_tmp NUMBER(10,0), cod_zon NUMBER(5,0), ind_via NUMBER(5,0), ind_num NUMBER(5,0), ind_let CHAR(6), ind_sca CHAR(1), ind_int NUMBER(5,0), sesso CHAR(1) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_ind ON TMP_IND (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_STC; CREATE TABLE TMP_STC ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cod NUMBER(10,0), an1_eve NUMBER(5,0), row_id NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_stc_1 ON TMP_STC (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_CNT; CREATE TABLE TMP_CNT ( id_tmp NUMBER(10,0), tp CHAR(1), cnt NUMBER(10,0), sesso CHAR(1), sezione NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_cnt1 ON TMP_CNT (id_tmp) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_cnt2 ON TMP_CNT (sezione) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_CNT_SEZ; CREATE TABLE TMP_CNT_SEZ ( id_tmp NUMBER(10,0), nr_sez NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_cnt_sez1 ON TMP_CNT_SEZ (id_tmp) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_cnt_sez2 ON TMP_CNT_SEZ (nr_sez) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_APP; CREATE TABLE TMP_APP ( id_tmp NUMBER(10,0), nr_sez NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_app ON TMP_APP (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_VIA; CREATE TABLE TMP_VIA ( id_tmp NUMBER(10,0), cod_zon NUMBER(5,0), ind_via NUMBER(5,0), fl_sogg CHAR(1), sesso CHAR(1) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_via ON TMP_VIA (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_PRO; CREATE TABLE TMP_PRO ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cognome CHAR(30), nome CHAR(35), sesso CHAR(1), fl_sogg CHAR(1), indiriz CHAR(100), old_sez NUMBER(5,0), new_sez NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_pro1 ON TMP_PRO (id_tmp) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_pro2 ON TMP_PRO (new_sez,cognome,nome) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_SIN; CREATE TABLE TMP_SIN ( id_tmp NUMBER(10,0), motivo CHAR(3), mas NUMBER(10,0), fem NUMBER(10,0), dt_movi DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_sin ON TMP_SIN (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_SCR; CREATE TABLE TMP_SCR ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), nr_grad NUMBER(10,0), cognome CHAR(30), nome CHAR(35), dt_nas DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_scr1 ON TMP_SCR (nr_grad) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_scr2 ON TMP_SCR (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_SCA; CREATE TABLE TMP_SCA ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), nr_grad NUMBER(10,0), cognome CHAR(30), nome CHAR(35), dt_nas DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_sca1 ON TMP_SCA (cognome,nome,dt_nas) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_sca2 ON TMP_SCA (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_DIN; CREATE TABLE TMP_DIN ( id_tmp NUMBER(10,0), fl_tipo CHAR(1), motivo CHAR(3), nr_indi NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_din ON TMP_DIN (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_CAN_D; CREATE TABLE TMP_CAN_D ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), sesso CHAR(1), dt_nas DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_can_d ON TMP_CAN_D (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_CAN; CREATE TABLE TMP_CAN ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), sezione NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_can ON TMP_CAN (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_SZD; CREATE TABLE TMP_SZD ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), new_sez NUMBER(5,0), sesso CHAR(1), cognome CHAR(30), nome CHAR(35), dt_nas DATE ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_szd ON TMP_SZD (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_SER; CREATE TABLE TMP_SER ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), nr_lgen NUMBER(10,0), sezione NUMBER(5,0), nr_lsez NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_ser ON TMP_SER (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_M4D; CREATE TABLE TMP_M4D ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cognome CHAR(30), nome CHAR(35), dt_nas DATE, loc_res NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_m4d ON TMP_M4D (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_RGF; CREATE TABLE TMP_RGF ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cognome CHAR(30), nome CHAR(35), dt_nas DATE, sesso CHAR(1) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_rgf1 ON TMP_RGF (cognome,nome,dt_nas) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_rgf2 ON TMP_RGF (id_tmp) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_rgf3 ON TMP_RGF (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_RSZ; CREATE TABLE TMP_RSZ ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cognome CHAR(30), nome CHAR(35), dt_nas DATE, sesso CHAR(1), sezione NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_rsz1 ON TMP_RSZ (sezione,cognome,nome,dt_nas) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_rsz2 ON TMP_RSZ (id_tmp) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_rsz3 ON TMP_RSZ (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_SEM; CREATE TABLE TMP_SEM ( id_tmp NUMBER(10,0), fl_tipo CHAR(1), motivo CHAR(3), fl_prep CHAR(2), fl_elps CHAR(2), nr_indi NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_sem ON TMP_SEM (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_RSZ_SEM; CREATE TABLE TMP_RSZ_SEM ( id_tmp NUMBER(10,0), fl_rev CHAR(1), nr_indi NUMBER(10,0), cognome CHAR(30), nome CHAR(35), dt_nas DATE, sesso CHAR(1), sezione NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_rsz_sem1 ON TMP_RSZ_SEM (sezione,cognome,nome,dt_nas) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_rsz_sem2 ON TMP_RSZ_SEM (nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_tmp_rsz_sem3 ON TMP_RSZ_SEM (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_CAN_S; CREATE TABLE TMP_CAN_S ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), sesso CHAR(1) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_can_s ON TMP_CAN_S (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_CEN; CREATE TABLE TMP_CEN ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), nr_sezc NUMBER(5,0), nr_fami NUMBER(10,0), ind_via CHAR(50), ind_num NUMBER(5,0), ind_let CHAR(6), ind_sca CHAR(1), ind_int NUMBER(5,0), fl_ord NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_cen1 ON TMP_CEN (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_TOP; CREATE TABLE TMP_TOP ( tp_var CHAR(1), nr_fami NUMBER(10,0), o_ind_tp CHAR(6), o_ind_via CHAR(50), o_ind_num NUMBER(5,0), o_ind_let CHAR(6), o_ind_sca CHAR(1), o_ind_int NUMBER(5,0), n_ind_tp CHAR(6), n_ind_via CHAR(50), n_ind_num NUMBER(5,0), n_ind_let CHAR(6), n_ind_sca CHAR(1), n_ind_int NUMBER(5,0) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE TMP_ERR; CREATE TABLE TMP_ERR ( id_tmp NUMBER(10,0), tp CHAR(1), des CHAR(100) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_err1 ON TMP_ERR (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_LSZ; CREATE TABLE TMP_LSZ ( id_tmp NUMBER(10,0), nr_indi NUMBER(10,0), cognome CHAR(30), nome CHAR(35), dt_nas DATE, sesso CHAR(1), sezione NUMBER(5,0), nr_lsez NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_lsz1 ON TMP_LSZ (id_tmp) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_VIS; CREATE TABLE TMP_VIS ( id_tmp NUMBER(10,0), nr_fami NUMBER(10,0), fl_sogg CHAR(1), nr_indi NUMBER(10,0), ordine NUMBER(5,0), dt_ini DATE, dt_fin DATE, fl_canc NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_vis1 ON TMP_VIS (id_tmp,nr_fami,fl_sogg,nr_indi,dt_fin) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TMP_REV; CREATE TABLE TMP_REV ( id_tmp NUMBER(10,0), cod_eve NUMBER(5,0), des CHAR(100) ) TABLESPACE WORKINGAREA; CREATE INDEX i_tmp_rev1 ON TMP_REV (id_tmp,cod_eve) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE AN1; CREATE TABLE AN1 ( cod NUMBER(10,0), dt_even DATE, nr_indi NUMBER(10,0), cognome CHAR(30), nome CHAR(35), pat_cog CHAR(30), pat_nom CHAR(35), mat_cog CHAR(30), mat_nom CHAR(35), nr_fami NUMBER(10,0), nr_conv NUMBER(5,0), loc_nas NUMBER(10,0), dt_nas DATE, ann_nas NUMBER(5,0), ora_nas NUMBER(5,0), atn_nr NUMBER(10,0), atn_par CHAR(1), atn_ser CHAR(1), atn_uff NUMBER(5,0), atn_vol CHAR(1), atn_ann NUMBER(5,0), atn_ltr NUMBER(10,0), atn_ntr NUMBER(10,0), atn_atr NUMBER(5,0), sesso CHAR(1), cod_fis CHAR(16), rap_par CHAR(2), profess NUMBER(10,0), tit_stu NUMBER(5,0), sta_civ CHAR(2), ind_via NUMBER(5,0), ind_num NUMBER(5,0), ind_let CHAR(6), ind_sca CHAR(1), ind_int NUMBER(5,0), cit_pos NUMBER(5,0), fl_sogg CHAR(1), fl_iscr NUMBER(5,0), fl_canc NUMBER(5,0), dt_iscr DATE, dt_canc DATE, res_loc_res NUMBER(10,0), res_ind_res CHAR(60), res_consola NUMBER(10,0), res_cap CHAR(20), pra_nr_pram NUMBER(10,0), pra_dt_pram DATE, pra_fl_dich CHAR(1), con_nr_indi NUMBER(10,0), con_cognome CHAR(30), con_nome CHAR(35), con_loc_mat NUMBER(10,0), con_dt_mat DATE, con_ann_mat NUMBER(5,0), con_atm_nr NUMBER(10,0), con_atm_par CHAR(1), con_atm_ser CHAR(1), con_atm_uff NUMBER(5,0), con_atm_vol CHAR(1), con_atm_ann NUMBER(5,0), con_atm_ltr NUMBER(10,0), con_atm_ntr NUMBER(10,0), con_atm_atr NUMBER(5,0), con_reg_pat CHAR(1), div_dt_div DATE, div_atd_nr NUMBER(10,0), div_atd_par CHAR(1), div_atd_ser CHAR(1), div_atd_uff NUMBER(5,0), div_atd_vol CHAR(1), div_atd_ann NUMBER(5,0), div_atd_ltr NUMBER(10,0), div_nr_sen1 NUMBER(10,0), div_dt_sen1 DATE, div_tri_est NUMBER(10,0), div_nr_sen2 NUMBER(10,0), div_dt_sen2 DATE, div_cap_tri NUMBER(10,0), div_tp_asc CHAR(1), imm_dt_imm DATE, imm_loc_pro NUMBER(10,0), imm_nr_prat NUMBER(10,0), emi_dt_emi DATE, emi_loc_emi NUMBER(10,0), emi_nr_prat NUMBER(10,0), irr_dt_irr DATE, irr_nr_prac NUMBER(10,0), irr_loc_can NUMBER(10,0), irr_dt_ric DATE, irr_nr_prai NUMBER(10,0), irr_loc_isc NUMBER(10,0), irr_loc_ric NUMBER(10,0), irr_tp_irr CHAR(1), air_dt_isca DATE, air_mt_isca NUMBER(5,0), air_loc_pd NUMBER(10,0), air_nr_dist NUMBER(10,0), air_nr_prot NUMBER(10,0), ct2_dt_arp DATE, ct2_mt_arp NUMBER(5,0), ct2_atc_nr NUMBER(10,0), ct2_atc_uff NUMBER(5,0), ct2_atc_vol CHAR(1), ct2_atc_ann NUMBER(5,0), ct2_atc_loc NUMBER(10,0), prog NUMBER(5,0), row_id1 NUMBER(10,0), row_id2 NUMBER(10,0), prg_mor NUMBER(5,0), prg_con NUMBER(5,0), prg_div NUMBER(5,0), prg_ct2 NUMBER(5,0), prg_emi NUMBER(5,0), prg_res NUMBER(5,0), prg_air NUMBER(5,0), prg_imm NUMBER(5,0), prg_irr NUMBER(5,0), prg_pra NUMBER(5,0), dt_ope DATE ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_an11 ON AN1 (cod,nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE NAZ_BCK; CREATE TABLE NAZ_BCK ( nr_stat NUMBER(5,0), sg_stat CHAR(3), fl_ex CHAR(1), des_sta CHAR(25), des_cit CHAR(20), cod_cf CHAR(4), nr_cons NUMBER(5,0), cod_mct CHAR(3), cod_ist NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_naz_b1 ON NAZ_BCK (nr_stat) TABLESPACE WORKINGINDEX; CREATE INDEX i_naz_b2 ON NAZ_BCK (des_sta) TABLESPACE WORKINGINDEX; CREATE INDEX i_naz_b3 ON NAZ_BCK (des_cit) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE CNS_BCK; CREATE TABLE CNS_BCK ( cod NUMBER(10,0), des CHAR(30) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_cns_b1 ON CNS_BCK (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE TER_BCK; CREATE TABLE TER_BCK ( cod NUMBER(5,0), des CHAR(60), nr_stat NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ter_b1 ON TER_BCK (cod) TABLESPACE WORKINGINDEX; CREATE INDEX i_ter_b2 ON TER_BCK (nr_stat) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE MOT; CREATE TABLE MOT ( cod NUMBER(5,0), des CHAR(90), des_breve CHAR(30), cod_ap4 NUMBER(5,0), cod_itr NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_mot_1 ON MOT (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE SAC; CREATE TABLE SAC ( cod NUMBER(10,0), nr_indi NUMBER(10,0), dt_even DATE, cod_eve NUMBER(5,0), causale NUMBER(5,0), fl_acce CHAR(1), fl_ignora CHAR(1), dt_tras DATE, nr_prot NUMBER(10,0), prg NUMBER(5,0), pro_saia CHAR(20), msg_tipo CHAR(20), msg_cod CHAR(10), msg_testo CHAR(300), campo_err CHAR(80) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_sac1 ON SAC (cod) TABLESPACE WORKINGINDEX; CREATE INDEX i_sac2 ON SAC (nr_indi,dt_even,causale) TABLESPACE WORKINGINDEX; CREATE INDEX i_sac3 ON SAC (nr_prot,prg) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE SAIA; CREATE TABLE SAIA ( login CHAR(30), password CHAR(30), cod_fis CHAR(16), versione CHAR(20), versione_xml CHAR(20), stringa1 CHAR(100), stringa2 CHAR(350), dt_ini DATE, dt_invio DATE, nr_prot NUMBER(10,0) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE INA; CREATE TABLE INA ( nr_indi NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_ina_01 ON INA (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE IS2; CREATE TABLE IS2 ( anno NUMBER(5,0), mese NUMBER(5,0), res_m NUMBER(10,0), res_f NUMBER(10,0), res_fam_m NUMBER(10,0), res_fam_f NUMBER(10,0), res_cnv_m NUMBER(10,0), res_cnv_f NUMBER(10,0), fam_res NUMBER(10,0), cnv_res NUMBER(10,0), res_stra_m NUMBER(10,0), res_stra_f NUMBER(10,0), res_stra_min_m NUMBER(10,0), res_stra_min_f NUMBER(10,0), res_stra_nat_m NUMBER(10,0), res_stra_nat_f NUMBER(10,0), fam_stra NUMBER(10,0), fam_stra_is NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_is2_1 ON IS2 (anno,mese) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANAGRA; CREATE TABLE PRN_XANAGRA ( nr_row NUMBER(10,0), str CHAR(2000) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xanagra ON PRN_XANAGRA (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANESTE; CREATE TABLE PRN_XANESTE ( nr_row NUMBER(10,0), str CHAR(300) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xaneste ON PRN_XANESTE (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANFAMI; CREATE TABLE PRN_XANFAMI ( nr_row NUMBER(10,0), str CHAR(150) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xanfami ON PRN_XANFAMI (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANIMMI; CREATE TABLE PRN_XANIMMI ( nr_row NUMBER(10,0), str CHAR(200) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xanimmi ON PRN_XANIMMI (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANLEVA; CREATE TABLE PRN_XANLEVA ( nr_row NUMBER(10,0), str CHAR(250) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xanleva ON PRN_XANLEVA (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANMATR; CREATE TABLE PRN_XANMATR ( nr_row NUMBER(10,0), str CHAR(300) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xanmatr ON PRN_XANMATR (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANPEDS; CREATE TABLE PRN_XANPEDS ( nr_row NUMBER(10,0), str CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xanpeds ON PRN_XANPEDS (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANPRO; CREATE TABLE PRN_XANPRO ( nr_row NUMBER(10,0), str CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xanpro ON PRN_XANPRO (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANSTOR; CREATE TABLE PRN_XANSTOR ( nr_row NUMBER(10,0), str CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xanstor ON PRN_XANSTOR (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANTERR; CREATE TABLE PRN_XANTERR ( nr_row NUMBER(10,0), str CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xanterr ON PRN_XANTERR (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANTIT; CREATE TABLE PRN_XANTIT ( nr_row NUMBER(10,0), str CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xantit ON PRN_XANTIT (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANVEIC; CREATE TABLE PRN_XANVEIC ( nr_row NUMBER(10,0), str CHAR(200) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xanveic ON PRN_XANVEIC (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XGTCIRC; CREATE TABLE PRN_XGTCIRC ( nr_row NUMBER(10,0), str CHAR(150) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xgtcirc ON PRN_XGTCIRC (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XGTCITT; CREATE TABLE PRN_XGTCITT ( nr_row NUMBER(10,0), str CHAR(150) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xgtcitt ON PRN_XGTCITT (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XGTNAZI; CREATE TABLE PRN_XGTNAZI ( nr_row NUMBER(10,0), str CHAR(200) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xgtnazi ON PRN_XGTNAZI (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XGTNUME; CREATE TABLE PRN_XGTNUME ( nr_row NUMBER(10,0), str CHAR(150) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xgtnume ON PRN_XGTNUME (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XGTTOPO; CREATE TABLE PRN_XGTTOPO ( nr_row NUMBER(10,0), str CHAR(50) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xgttopo ON PRN_XGTTOPO (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XGTUNIT; CREATE TABLE PRN_XGTUNIT ( nr_row NUMBER(10,0), str CHAR(300) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xgtunit ON PRN_XGTUNIT (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XSCANNO; CREATE TABLE PRN_XSCANNO ( nr_row NUMBER(10,0), str CHAR(700) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xscanno ON PRN_XSCANNO (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XSCCAUS; CREATE TABLE PRN_XSCCAUS ( nr_row NUMBER(10,0), str CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xsccaus ON PRN_XSCCAUS (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XSCMOVI; CREATE TABLE PRN_XSCMOVI ( nr_row NUMBER(10,0), str CHAR(1200) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xscmovi ON PRN_XSCMOVI (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XSCTEST; CREATE TABLE PRN_XSCTEST ( nr_row NUMBER(10,0), str CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xsctest ON PRN_XSCTEST (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XSCUFSC; CREATE TABLE PRN_XSCUFSC ( nr_row NUMBER(10,0), str CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xscufsc ON PRN_XSCUFSC (nr_row) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANAAPP; CREATE TABLE PRN_XANAAPP ( nr_indi NUMBER(10,0), codfami CHAR(10), codresi CHAR(10), codmatr CHAR(10), codvedo CHAR(10), coddivo CHAR(10), codimmi CHAR(10), codemig CHAR(10), codairi CHAR(10), codairc CHAR(10), codmort CHAR(10), codcitt CHAR(10), codcert CHAR(10), codleva CHAR(10), coddpen CHAR(10), coddlav CHAR(10), coddsog CHAR(10), coddptn CHAR(10), coddvei CHAR(10), coddcen CHAR(10), coddtes CHAR(10), cid_sta CHAR(10), cid_cap CHAR(10), cid_occ CHAR(10), cid_seg CHAR(30), cen_sez CHAR(10), cen_ann CHAR(10), cen_fam CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX prn_xanaapp ON PRN_XANAAPP (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XSTOGEN; CREATE TABLE PRN_XSTOGEN ( cod_id NUMBER(10,0), ord_cres NUMBER(10,0), fl_fami CHAR(1), nr_indi NUMBER(10,0), nr_fami NUMBER(10,0), dt_even CHAR(8), dt_ope CHAR(8), dt_ins CHAR(8), movim_cod CHAR(2), movim_des CHAR(30), rec_tp CHAR(5), rec_nr NUMBER(10,0), dati CHAR(5), fl_ordi NUMBER(10,0), fl_tipo CHAR(1), fl_prec CHAR(1), fl_ok NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xstogen_01 ON PRN_XSTOGEN (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_xstogen_02 ON PRN_XSTOGEN (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XSTOEVE; CREATE TABLE PRN_XSTOEVE ( cod_id NUMBER(10,0), cod_sto NUMBER(10,0), ord_cres NUMBER(10,0), nr_indi NUMBER(10,0), dt_even CHAR(8), dt_ope CHAR(8), rec_tp CHAR(5), dati CHAR(5), fl_ordi NUMBER(10,0), fl_tipo CHAR(1), evento CHAR(50), fl_prec CHAR(1), rec_str CHAR(300), fl_app NUMBER(5,0) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xstoeve_01 ON PRN_XSTOEVE (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_xstoeve_02 ON PRN_XSTOEVE (nr_indi) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_xstoeve_10 ON PRN_XSTOEVE (ord_cres) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XSTOPRE; CREATE TABLE PRN_XSTOPRE ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), nr_fami CHAR(10), nr_fami_dt CHAR(10), cognome CHAR(45), nome CHAR(45), nom_suc CHAR(45), sesso CHAR(1), loc_nas CHAR(50), dt_nas CHAR(10), ann_nas CHAR(4), ora_min CHAR(5), atn_nr CHAR(10), atn_par CHAR(1), atn_ser CHAR(1), atn_uff CHAR(10), atn_vol CHAR(1), atn_ann CHAR(10), atn_ntr CHAR(10), atn_ptr CHAR(1), atn_str CHAR(1), atn_utr CHAR(10), atn_vtr CHAR(1), atn_atr CHAR(10), atn_ltr CHAR(50), atto_par CHAR(50), ind_cod CHAR(10), ind_via CHAR(50), ind_num CHAR(10), ind_let CHAR(6), ind_int CHAR(10), ind_sca CHAR(1), indir_dt CHAR(10), fl_sogg CHAR(1), fl_iscr CHAR(10), fl_canc CHAR(10), dt_iscr CHAR(10), dt_canc CHAR(10), fl_cert CHAR(1), cert_note CHAR(300), fl_espa CHAR(1), pat_cog CHAR(45), pat_nom CHAR(45), mat_cog CHAR(45), mat_nom CHAR(45), nr_conv CHAR(10), conviv CHAR(80), rap_par CHAR(20), rap_par_dt CHAR(10), cit_pos CHAR(40), profess CHAR(30), pro_pos CHAR(1), pro_set CHAR(1), pro_con CHAR(1), profess_dt CHAR(10), tit_stu CHAR(25), tit_stu_dt CHAR(10), cod_fis CHAR(16), fl_cf CHAR(1), sta_civ CHAR(20), con_cognome CHAR(45), con_nome CHAR(45), con_nr_indc CHAR(10), con_loc_nas CHAR(50), con_dt_nas CHAR(10), con_loc_mat CHAR(50), con_dt_mat CHAR(10), con_atm_nr CHAR(10), con_atm_par CHAR(1), con_atm_ser CHAR(1), con_atm_uff CHAR(10), con_atm_vol CHAR(1), con_atm_ann CHAR(10), con_atm_ntr CHAR(10), con_atm_ptr CHAR(1), con_atm_str CHAR(1), con_atm_utr CHAR(10), con_atm_vtr CHAR(1), con_atm_atr CHAR(10), con_atm_ltr CHAR(50), imm_loc_pro CHAR(50), imm_dt_imm CHAR(10), imm_nr_prat CHAR(10), emi_loc_emi CHAR(50), emi_dt_emi CHAR(10), emi_nr_prat CHAR(10), irr_loc_can CHAR(50), irr_dt_can CHAR(10), irr_nr_prac CHAR(10), irr_loc_ric CHAR(50), irr_loc_isc CHAR(50), irr_dt_ric CHAR(10), irr_nr_prai CHAR(10), ved_loc_mor CHAR(50), ved_dt_mor CHAR(10), ved_atm_nr CHAR(10), ved_atm_par CHAR(1), ved_atm_ser CHAR(1), ved_atm_uff CHAR(10), ved_atm_vol CHAR(1), ved_atm_ann CHAR(10), ved_atm_ntr CHAR(10), ved_atm_ptr CHAR(1), ved_atm_str CHAR(1), ved_atm_utr CHAR(10), ved_atm_vtr CHAR(1), ved_atm_atr CHAR(10), ved_atm_ltr CHAR(50), mor_loc_mor CHAR(50), mor_dt_mor CHAR(10), mor_atm_nr CHAR(10), mor_atm_par CHAR(1), mor_atm_ser CHAR(1), mor_atm_uff CHAR(10), mor_atm_vol CHAR(1), mor_atm_ann CHAR(10), mor_atm_ntr CHAR(10), mor_atm_ptr CHAR(1), mor_atm_str CHAR(1), mor_atm_utr CHAR(10), mor_atm_vtr CHAR(1), mor_atm_atr CHAR(10), mor_atm_ltr CHAR(50), mor_causa CHAR(60), div_cap_tri CHAR(50), div_nr_sen2 CHAR(10), div_dt_sen2 CHAR(10), div_dt_div CHAR(10), div_atd_nr CHAR(10), div_atd_par CHAR(1), div_atd_ser CHAR(1), div_atd_uff CHAR(10), div_atd_vol CHAR(1), div_atd_ann CHAR(10), div_atd_ltr CHAR(50), res_ind_res CHAR(60), res_loc_res CHAR(50), res_cap CHAR(20), res_consola CHAR(50), resid_dt CHAR(10), air_nr_fami CHAR(15), air_fami_dt CHAR(10), air_nr_dist CHAR(15), air_dt_isca CHAR(10), air_loc_pro CHAR(50), air_mt_isca CHAR(30), air_nrproti CHAR(10), air_in_isca CHAR(10), air_com_isc CHAR(10), air_dt_canc CHAR(10), air_loc_des CHAR(50), air_mt_canc CHAR(30), air_nrprotc CHAR(10), air_in_canc CHAR(10), air_dt_var CHAR(10), air_mt_var CHAR(30), air_nrprotv CHAR(10), air_in_var CHAR(10), ct1_cit_pos CHAR(40), cit_dt_acq CHAR(10), cit_loc_acq CHAR(50), cit_atca_ann CHAR(10), cit_atca_nr CHAR(10), cit_atca_uff CHAR(10), cit_atca_vol CHAR(1), cit_dt_perd CHAR(10), cit_loc_perd CHAR(50), cit_atcp_ann CHAR(10), cit_atcp_nr CHAR(10), cit_atcp_uff CHAR(10), cit_atcp_vol CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xstopre_0 ON PRN_XSTOPRE (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_xstopre_1 ON PRN_XSTOPRE (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XSTODAT; CREATE TABLE PRN_XSTODAT ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), nr_fami CHAR(10), nr_fami_dt CHAR(10), cognome CHAR(45), nome CHAR(45), nom_suc CHAR(45), sesso CHAR(1), loc_nas CHAR(50), dt_nas CHAR(10), ann_nas CHAR(4), ora_min CHAR(5), atn_nr CHAR(10), atn_par CHAR(1), atn_ser CHAR(1), atn_uff CHAR(10), atn_vol CHAR(1), atn_ann CHAR(10), atn_ntr CHAR(10), atn_ptr CHAR(1), atn_str CHAR(1), atn_utr CHAR(10), atn_vtr CHAR(1), atn_atr CHAR(10), atn_ltr CHAR(50), atto_par CHAR(50), ind_cod CHAR(10), ind_via CHAR(50), ind_num CHAR(10), ind_let CHAR(6), ind_int CHAR(10), ind_sca CHAR(1), indir_dt CHAR(10), fl_sogg CHAR(1), fl_iscr CHAR(10), fl_canc CHAR(10), dt_iscr CHAR(10), dt_canc CHAR(10), fl_cert CHAR(1), cert_note CHAR(300), fl_espa CHAR(1), pat_cog CHAR(45), pat_nom CHAR(45), mat_cog CHAR(45), mat_nom CHAR(45), nr_conv CHAR(10), conviv CHAR(80), rap_par CHAR(20), rap_par_dt CHAR(10), cit_pos CHAR(40), profess CHAR(30), pro_pos CHAR(1), pro_set CHAR(1), pro_con CHAR(1), profess_dt CHAR(10), tit_stu CHAR(25), tit_stu_dt CHAR(10), cod_fis CHAR(16), fl_cf CHAR(1), sta_civ CHAR(20), con_cognome CHAR(45), con_nome CHAR(45), con_nr_indc CHAR(10), con_loc_nas CHAR(50), con_dt_nas CHAR(10), con_loc_mat CHAR(50), con_dt_mat CHAR(10), con_atm_nr CHAR(10), con_atm_par CHAR(1), con_atm_ser CHAR(1), con_atm_uff CHAR(10), con_atm_vol CHAR(1), con_atm_ann CHAR(10), con_atm_ntr CHAR(10), con_atm_ptr CHAR(1), con_atm_str CHAR(1), con_atm_utr CHAR(10), con_atm_vtr CHAR(1), con_atm_atr CHAR(10), con_atm_ltr CHAR(50), imm_loc_pro CHAR(50), imm_dt_imm CHAR(10), imm_nr_prat CHAR(10), emi_loc_emi CHAR(50), emi_dt_emi CHAR(10), emi_nr_prat CHAR(10), irr_loc_can CHAR(50), irr_dt_can CHAR(10), irr_nr_prac CHAR(10), irr_loc_ric CHAR(50), irr_loc_isc CHAR(50), irr_dt_ric CHAR(10), irr_nr_prai CHAR(10), ved_loc_mor CHAR(50), ved_dt_mor CHAR(10), ved_atm_nr CHAR(10), ved_atm_par CHAR(1), ved_atm_ser CHAR(1), ved_atm_uff CHAR(10), ved_atm_vol CHAR(1), ved_atm_ann CHAR(10), ved_atm_ntr CHAR(10), ved_atm_ptr CHAR(1), ved_atm_str CHAR(1), ved_atm_utr CHAR(10), ved_atm_vtr CHAR(1), ved_atm_atr CHAR(10), ved_atm_ltr CHAR(50), mor_loc_mor CHAR(50), mor_dt_mor CHAR(10), mor_atm_nr CHAR(10), mor_atm_par CHAR(1), mor_atm_ser CHAR(1), mor_atm_uff CHAR(10), mor_atm_vol CHAR(1), mor_atm_ann CHAR(10), mor_atm_ntr CHAR(10), mor_atm_ptr CHAR(1), mor_atm_str CHAR(1), mor_atm_utr CHAR(10), mor_atm_vtr CHAR(1), mor_atm_atr CHAR(10), mor_atm_ltr CHAR(50), mor_causa CHAR(60), div_cap_tri CHAR(50), div_nr_sen2 CHAR(10), div_dt_sen2 CHAR(10), div_dt_div CHAR(10), div_atd_nr CHAR(10), div_atd_par CHAR(1), div_atd_ser CHAR(1), div_atd_uff CHAR(10), div_atd_vol CHAR(1), div_atd_ann CHAR(10), div_atd_ltr CHAR(50), res_ind_res CHAR(60), res_loc_res CHAR(50), res_cap CHAR(20), res_consola CHAR(50), resid_dt CHAR(10), air_nr_fami CHAR(15), air_fami_dt CHAR(10), air_nr_dist CHAR(15), air_dt_isca CHAR(10), air_loc_pro CHAR(50), air_mt_isca CHAR(30), air_nrproti CHAR(10), air_in_isca CHAR(10), air_com_isc CHAR(10), air_dt_canc CHAR(10), air_loc_des CHAR(50), air_mt_canc CHAR(30), air_nrprotc CHAR(10), air_in_canc CHAR(10), air_dt_var CHAR(10), air_mt_var CHAR(30), air_nrprotv CHAR(10), air_in_var CHAR(10), ct1_cit_pos CHAR(40), cit_dt_acq CHAR(10), cit_loc_acq CHAR(50), cit_atca_ann CHAR(10), cit_atca_nr CHAR(10), cit_atca_uff CHAR(10), cit_atca_vol CHAR(1), cit_dt_perd CHAR(10), cit_loc_perd CHAR(50), cit_atcp_ann CHAR(10), cit_atcp_nr CHAR(10), cit_atcp_uff CHAR(10), cit_atcp_vol CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xstodat_0 ON PRN_XSTODAT (cod_id) TABLESPACE WORKINGINDEX; CREATE INDEX i_xstodat_1 ON PRN_XSTODAT (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XSTOAPP; CREATE TABLE PRN_XSTOAPP ( cod_id NUMBER(10,0), ord_cres NUMBER(10,0), dati CHAR(5), nr_indi NUMBER(10,0), fl_sogg CHAR(1), sesso CHAR(1), sta_civ CHAR(20) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xstoapp_0 ON PRN_XSTOAPP (ord_cres) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_xstoapp_1 ON PRN_XSTOAPP (nr_indi,ord_cres) TABLESPACE WORKINGINDEX; CREATE INDEX i_xstoapp_2 ON PRN_XSTOAPP (dati) TABLESPACE WORKINGINDEX; CREATE INDEX i_xstoapp_3 ON PRN_XSTOAPP (fl_sogg) TABLESPACE WORKINGINDEX; CREATE INDEX i_xstoapp_4 ON PRN_XSTOAPP (sta_civ) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XRICCOMOK; CREATE TABLE PRN_XRICCOMOK ( naz_prov NUMBER(5,0), fl_cont CHAR(1) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xriccomok_1 ON PRN_XRICCOMOK (naz_prov) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XGTKLOC; CREATE TABLE PRN_XGTKLOC ( nr_row NUMBER(10,0), cod CHAR(7), str CHAR(200) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xgtkloc_0 ON PRN_XGTKLOC (nr_row) TABLESPACE WORKINGINDEX; CREATE INDEX i_xgtkloc_1 ON PRN_XGTKLOC (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANCODI; CREATE TABLE PRN_XANCODI ( nr_row NUMBER(10,0), cod CHAR(5), str CHAR(200) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xancodi_0 ON PRN_XANCODI (nr_row) TABLESPACE WORKINGINDEX; CREATE INDEX i_xancodi_1 ON PRN_XANCODI (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANCONS; CREATE TABLE PRN_XANCONS ( nr_row NUMBER(10,0), cod CHAR(7), str CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xancons_0 ON PRN_XANCONS (nr_row) TABLESPACE WORKINGINDEX; CREATE INDEX i_xancons_1 ON PRN_XANCONS (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XPESEZI; CREATE TABLE PRN_XPESEZI ( nr_row NUMBER(10,0), cod CHAR(4), str CHAR(100) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xpesezi_0 ON PRN_XPESEZI (nr_row) TABLESPACE WORKINGINDEX; CREATE INDEX i_xpesezi_1 ON PRN_XPESEZI (cod) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XANMOVI; CREATE TABLE PRN_XANMOVI ( nr_row NUMBER(10,0), cod CHAR(2), fam CHAR(7), str CHAR(150) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_xanmovi ON PRN_XANMOVI (nr_row) TABLESPACE WORKINGINDEX; CREATE INDEX i_xanmovi_1 ON PRN_XANMOVI (cod) TABLESPACE WORKINGINDEX; CREATE INDEX i_xanmovi_2 ON PRN_XANMOVI (cod,fam) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_APP; CREATE TABLE PRN_APP ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), nr_fami CHAR(10), nr_fami_dt CHAR(10), cognome CHAR(45), nome CHAR(45), nom_suc CHAR(45), sesso CHAR(1), loc_nas CHAR(50), dt_nas CHAR(10), ann_nas CHAR(4), ora_min CHAR(5), atn_nr CHAR(10), atn_par CHAR(1), atn_ser CHAR(1), atn_uff CHAR(10), atn_vol CHAR(1), atn_ann CHAR(10), atn_ntr CHAR(10), atn_ptr CHAR(1), atn_str CHAR(1), atn_utr CHAR(10), atn_vtr CHAR(1), atn_atr CHAR(10), atn_ltr CHAR(50), atto_par CHAR(50), ind_cod CHAR(10), ind_via CHAR(50), ind_num CHAR(10), ind_let CHAR(6), ind_int CHAR(10), ind_sca CHAR(1), indir_dt CHAR(10), fl_sogg CHAR(1), fl_iscr CHAR(10), fl_canc CHAR(10), dt_iscr CHAR(10), dt_canc CHAR(10), fl_cert CHAR(1), cert_note CHAR(300), fl_espa CHAR(1), pat_cog CHAR(45), pat_nom CHAR(45), mat_cog CHAR(45), mat_nom CHAR(45), nr_conv CHAR(10), conviv CHAR(80), rap_par CHAR(20), rap_par_dt CHAR(10), cit_pos CHAR(40), profess CHAR(30), pro_pos CHAR(1), pro_set CHAR(1), pro_con CHAR(1), profess_dt CHAR(10), tit_stu CHAR(25), tit_stu_dt CHAR(10), cod_fis CHAR(16), fl_cf CHAR(1), sta_civ CHAR(20), con_cognome CHAR(45), con_nome CHAR(45), con_nr_indc CHAR(10), con_loc_nas CHAR(50), con_dt_nas CHAR(10), con_loc_mat CHAR(50), con_dt_mat CHAR(10), con_atm_nr CHAR(10), con_atm_par CHAR(1), con_atm_ser CHAR(1), con_atm_uff CHAR(10), con_atm_vol CHAR(1), con_atm_ann CHAR(10), con_atm_ntr CHAR(10), con_atm_ptr CHAR(1), con_atm_str CHAR(1), con_atm_utr CHAR(10), con_atm_vtr CHAR(1), con_atm_atr CHAR(10), con_atm_ltr CHAR(50), imm_loc_pro CHAR(50), imm_dt_imm CHAR(10), imm_nr_prat CHAR(10), emi_loc_emi CHAR(50), emi_dt_emi CHAR(10), emi_nr_prat CHAR(10), irr_loc_can CHAR(50), irr_dt_can CHAR(10), irr_nr_prac CHAR(10), irr_loc_ric CHAR(50), irr_loc_isc CHAR(50), irr_dt_ric CHAR(10), irr_nr_prai CHAR(10), ved_loc_mor CHAR(50), ved_dt_mor CHAR(10), ved_atm_nr CHAR(10), ved_atm_par CHAR(1), ved_atm_ser CHAR(1), ved_atm_uff CHAR(10), ved_atm_vol CHAR(1), ved_atm_ann CHAR(10), ved_atm_ntr CHAR(10), ved_atm_ptr CHAR(1), ved_atm_str CHAR(1), ved_atm_utr CHAR(10), ved_atm_vtr CHAR(1), ved_atm_atr CHAR(10), ved_atm_ltr CHAR(50), mor_loc_mor CHAR(50), mor_dt_mor CHAR(10), mor_atm_nr CHAR(10), mor_atm_par CHAR(1), mor_atm_ser CHAR(1), mor_atm_uff CHAR(10), mor_atm_vol CHAR(1), mor_atm_ann CHAR(10), mor_atm_ntr CHAR(10), mor_atm_ptr CHAR(1), mor_atm_str CHAR(1), mor_atm_utr CHAR(10), mor_atm_vtr CHAR(1), mor_atm_atr CHAR(10), mor_atm_ltr CHAR(50), mor_causa CHAR(60), div_cap_tri CHAR(50), div_nr_sen2 CHAR(10), div_dt_sen2 CHAR(10), div_dt_div CHAR(10), div_atd_nr CHAR(10), div_atd_par CHAR(1), div_atd_ser CHAR(1), div_atd_uff CHAR(10), div_atd_vol CHAR(1), div_atd_ann CHAR(10), div_atd_ltr CHAR(50), res_ind_res CHAR(60), res_loc_res CHAR(50), res_cap CHAR(20), res_consola CHAR(50), resid_dt CHAR(10), air_nr_fami CHAR(15), air_fami_dt CHAR(10), air_nr_dist CHAR(15), air_dt_isca CHAR(10), air_loc_pro CHAR(50), air_mt_isca CHAR(30), air_nrproti CHAR(10), air_in_isca CHAR(10), air_com_isc CHAR(10), air_dt_canc CHAR(10), air_loc_des CHAR(50), air_mt_canc CHAR(30), air_nrprotc CHAR(10), air_in_canc CHAR(10), air_dt_var CHAR(10), air_mt_var CHAR(30), air_nrprotv CHAR(10), air_in_var CHAR(10), ct1_cit_pos CHAR(40), cit_dt_acq CHAR(10), cit_loc_acq CHAR(50), cit_atca_ann CHAR(10), cit_atca_nr CHAR(10), cit_atca_uff CHAR(10), cit_atca_vol CHAR(1), cit_dt_perd CHAR(10), cit_loc_perd CHAR(50), cit_atcp_ann CHAR(10), cit_atcp_nr CHAR(10), cit_atcp_uff CHAR(10), cit_atcp_vol CHAR(1), note1 CHAR(365), note2 CHAR(365), evento CHAR(50), dt_even CHAR(10), dt_ope CHAR(10) ) TABLESPACE WORKINGAREA; CREATE UNIQUE INDEX i_prn_app_00 ON PRN_APP (cod_id) TABLESPACE WORKINGINDEX; CREATE UNIQUE INDEX i_prn_app_01 ON PRN_APP (nr_indi) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_app_02 ON PRN_APP (cognome,nome) TABLESPACE WORKINGINDEX; CREATE INDEX i_prn_app_03 ON PRN_APP (cognome,nome,dt_nas) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XAAISC; CREATE TABLE PRN_XAAISC ( fgins CHAR(1), fgmod CHAR(1), idnum_prog NUMBER(10,0), cogn_pers CHAR(36), nome_pers CHAR(36), data_nasc CHAR(8), cod_iscr CHAR(12), cod_fam CHAR(9), comu_nasc CHAR(6), luog_nasc CHAR(38), terr_nasc CHAR(3), stat_civi CHAR(1), sesso CHAR(1), cod_rela CHAR(2), comu_iscr CHAR(6), data_reg CHAR(8), cod_moti_iscr CHAR(3), cod_moti_iniziat CHAR(1), cod_moti_iniz_agg CHAR(1), cod_individcom_isc CHAR(1), comu_prov CHAR(6), terr_prov CHAR(3), cogn_con CHAR(36), data_arrivo CHAR(8), anno_espatrio CHAR(4), comu_regis CHAR(6), anno_regis CHAR(4), serie_regis CHAR(1), parte_regis CHAR(1), numero_regis CHAR(5), cittadin_est1 CHAR(3), cittadin_est2 CHAR(3), data_matr CHAR(8), comu_matr CHAR(6), terr_matr CHAR(3), luog_matr CHAR(38), comu_regis_matr CHAR(6), anno_regis_matr CHAR(4), serie_regis_matr CHAR(1), parte_regis_matr CHAR(1), numero_regis_matr CHAR(5), comu_leva CHAR(6), cod_tit_studio CHAR(1), disoccupato CHAR(1), cod_profes CHAR(1), cod_attivita CHAR(1), cod_fiscale CHAR(16), ente_pens1 CHAR(2), ente_pens2 CHAR(2), ente_pens3 CHAR(2), data_ult_mod CHAR(8), elettore CHAR(1), cod_elettore CHAR(1), flag_tipo CHAR(1), data_sist_agg CHAR(8), progressivo_mae CHAR(10), cod_fis_validato CHAR(1) ) TABLESPACE WORKINGAREA; COMMIT; DROP TABLE PRN_XAAFAM; CREATE TABLE PRN_XAAFAM ( fginsfam CHAR(1), fgmodfam CHAR(1), idcod_fam CHAR(9), cod_terr CHAR(3), cod_cons CHAR(7), prov_cont CHAR(28), cod_cap CHAR(10), desc_loca CHAR(40), desc_indi CHAR(60), nume_civi CHAR(9), presso CHAR(50), datamodind CHAR(8) ) TABLESPACE WORKINGAREA; CREATE INDEX i_prn_xaafam_0 ON PRN_XAAFAM (idcod_fam) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XAAAIR; CREATE TABLE PRN_XAAAIR ( cod_id NUMBER(10,0), nr_indi NUMBER(10,0), nr_fami CHAR(10), nr_fami_dt CHAR(10), cognome CHAR(45), nome CHAR(45), nom_suc CHAR(45), sesso CHAR(1), loc_nas CHAR(50), dt_nas CHAR(10), ann_nas CHAR(4), ora_min CHAR(5), atn_nr CHAR(10), atn_par CHAR(1), atn_ser CHAR(1), atn_uff CHAR(10), atn_vol CHAR(1), atn_ann CHAR(10), atn_ntr CHAR(10), atn_ptr CHAR(1), atn_str CHAR(1), atn_utr CHAR(10), atn_vtr CHAR(1), atn_atr CHAR(10), atn_ltr CHAR(50), atto_par CHAR(50), ind_cod CHAR(10), ind_via CHAR(50), ind_num CHAR(10), ind_let CHAR(6), ind_int CHAR(10), ind_sca CHAR(1), indir_dt CHAR(10), fl_sogg CHAR(1), fl_iscr CHAR(10), fl_canc CHAR(10), dt_iscr CHAR(10), dt_canc CHAR(10), fl_cert CHAR(1), cert_note CHAR(300), fl_espa CHAR(1), pat_cog CHAR(45), pat_nom CHAR(45), mat_cog CHAR(45), mat_nom CHAR(45), nr_conv CHAR(10), conviv CHAR(80), rap_par CHAR(20), rap_par_dt CHAR(10), cit_pos CHAR(40), profess CHAR(30), pro_pos CHAR(1), pro_set CHAR(1), pro_con CHAR(1), profess_dt CHAR(10), tit_stu CHAR(25), tit_stu_dt CHAR(10), cod_fis CHAR(16), fl_cf CHAR(1), sta_civ CHAR(20), con_cognome CHAR(45), con_nome CHAR(45), con_nr_indc CHAR(10), con_loc_nas CHAR(50), con_dt_nas CHAR(10), con_loc_mat CHAR(50), con_dt_mat CHAR(10), con_atm_nr CHAR(10), con_atm_par CHAR(1), con_atm_ser CHAR(1), con_atm_uff CHAR(10), con_atm_vol CHAR(1), con_atm_ann CHAR(10), con_atm_ntr CHAR(10), con_atm_ptr CHAR(1), con_atm_str CHAR(1), con_atm_utr CHAR(10), con_atm_vtr CHAR(1), con_atm_atr CHAR(10), con_atm_ltr CHAR(50), imm_loc_pro CHAR(50), imm_dt_imm CHAR(10), imm_nr_prat CHAR(10), emi_loc_emi CHAR(50), emi_dt_emi CHAR(10), emi_nr_prat CHAR(10), irr_loc_can CHAR(50), irr_dt_can CHAR(10), irr_nr_prac CHAR(10), irr_loc_ric CHAR(50), irr_loc_isc CHAR(50), irr_dt_ric CHAR(10), irr_nr_prai CHAR(10), ved_loc_mor CHAR(50), ved_dt_mor CHAR(10), ved_atm_nr CHAR(10), ved_atm_par CHAR(1), ved_atm_ser CHAR(1), ved_atm_uff CHAR(10), ved_atm_vol CHAR(1), ved_atm_ann CHAR(10), ved_atm_ntr CHAR(10), ved_atm_ptr CHAR(1), ved_atm_str CHAR(1), ved_atm_utr CHAR(10), ved_atm_vtr CHAR(1), ved_atm_atr CHAR(10), ved_atm_ltr CHAR(50), mor_loc_mor CHAR(50), mor_dt_mor CHAR(10), mor_atm_nr CHAR(10), mor_atm_par CHAR(1), mor_atm_ser CHAR(1), mor_atm_uff CHAR(10), mor_atm_vol CHAR(1), mor_atm_ann CHAR(10), mor_atm_ntr CHAR(10), mor_atm_ptr CHAR(1), mor_atm_str CHAR(1), mor_atm_utr CHAR(10), mor_atm_vtr CHAR(1), mor_atm_atr CHAR(10), mor_atm_ltr CHAR(50), mor_causa CHAR(60), div_cap_tri CHAR(50), div_nr_sen2 CHAR(10), div_dt_sen2 CHAR(10), div_dt_div CHAR(10), div_atd_nr CHAR(10), div_atd_par CHAR(1), div_atd_ser CHAR(1), div_atd_uff CHAR(10), div_atd_vol CHAR(1), div_atd_ann CHAR(10), div_atd_ltr CHAR(50), res_ind_res CHAR(60), res_loc_res CHAR(50), res_cap CHAR(20), res_consola CHAR(50), resid_dt CHAR(10), air_nr_fami CHAR(15), air_fami_dt CHAR(10), air_nr_dist CHAR(15), air_dt_isca CHAR(10), air_loc_pro CHAR(50), air_mt_isca CHAR(30), air_nrproti CHAR(10), air_in_isca CHAR(10), air_com_isc CHAR(10), air_dt_canc CHAR(10), air_loc_des CHAR(50), air_mt_canc CHAR(30), air_nrprotc CHAR(10), air_in_canc CHAR(10), air_dt_var CHAR(10), air_mt_var CHAR(30), air_nrprotv CHAR(10), air_in_var CHAR(10), ct1_cit_pos CHAR(40), cit_dt_acq CHAR(10), cit_loc_acq CHAR(50), cit_atca_ann CHAR(10), cit_atca_nr CHAR(10), cit_atca_uff CHAR(10), cit_atca_vol CHAR(1), cit_dt_perd CHAR(10), cit_loc_perd CHAR(50), cit_atcp_ann CHAR(10), cit_atcp_nr CHAR(10), cit_atcp_uff CHAR(10), cit_atcp_vol CHAR(1), note1 CHAR(365), note2 CHAR(365), evento CHAR(50), dt_even CHAR(10), dt_ope CHAR(10) ) TABLESPACE WORKINGAREA; CREATE INDEX i_prn_xaaair_1 ON PRN_XAAAIR (nr_indi) TABLESPACE WORKINGINDEX; COMMIT; DROP TABLE PRN_XAAIND; CREATE TABLE PRN_XAAIND ( row_id NUMBER(10,0), nr_indi NUMBER(10,0) ) TABLESPACE WORKINGAREA; CREATE INDEX i_prn_xaaind_0 ON PRN_XAAIND (nr_indi) TABLESPACE WORKINGINDEX; COMMIT;