Show pageOld revisionsBacklinksExport to PDFODT exportBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== Sistema AIOCAP ====== ===== Struttura variabili per controllo qualità ===== {{:cli:franke:aiocap:aiocap-variabili.png|}} ===== Struttura dati dall'OCAP ===== {{:cli:franke:aiocap:aiocap-ocap-tab.png|}} ===== Struttura dati Rete Bayesiana ===== {{:cli:franke:aiocap:aiocap-dbn-db.png|}} <code sql> --Aggiungere i numeratori per bnet, bnrami, bnnodi, bncpt CREATE TABLE bnet ( codice integer NOT NULL, descrizio character varying(201), codubi character varying(51) ); ALTER TABLE ONLY bnet ADD CONSTRAINT ix_bnet_codice PRIMARY KEY (codice); ALTER TABLE ONLY bnet ADD CONSTRAINT ix_bnet_codubi FOREIGN KEY (codubi) REFERENCES ubicaz(codice) ON UPDATE CASCADE ON DELETE CASCADE; CREATE TABLE bnnodi ( codprg integer, codice integer NOT NULL, descrizio character varying(201), id integer, codcau character varying(51), codocap integer, tipo varchar(2), t integer ); ALTER TABLE ONLY bnnodi ADD CONSTRAINT ix_bnnodi_codice PRIMARY KEY (codice); ALTER TABLE ONLY bnnodi ADD CONSTRAINT ix_bnnodi_codcau FOREIGN KEY (codcau) REFERENCES causanc(codice) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE ONLY bnnodi ADD CONSTRAINT ix_bnnodi_codprg FOREIGN KEY (codprg) REFERENCES bnet(codice) ON UPDATE CASCADE ON DELETE CASCADE; CREATE TABLE bnrami ( codprg integer, codice integer NOT NULL, id integer, nodosx integer, nododx integer ); ALTER TABLE ONLY bnrami ADD CONSTRAINT ix_bnrami_codice PRIMARY KEY (codice); ALTER TABLE ONLY bnrami ADD CONSTRAINT ix_bnrami_codprg FOREIGN KEY (codprg) REFERENCES bnet(codice) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE ONLY bnrami ADD CONSTRAINT ix_bnrami_nododx FOREIGN KEY (nododx) REFERENCES bnnodi(codice) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE ONLY bnrami ADD CONSTRAINT ix_bnrami_nodosx FOREIGN KEY (nodosx) REFERENCES bnnodi(codice) ON UPDATE CASCADE ON DELETE CASCADE; CREATE TABLE bncpt ( codice integer NOT NULL, codnodo integer, val character varying(2048), p double precision ); ALTER TABLE ONLY bncpt ADD CONSTRAINT ix_cpt_codice PRIMARY KEY (codice); ALTER TABLE ONLY bncpt ADD CONSTRAINT ix_cpt_codnodo FOREIGN KEY (codnodo) REFERENCES bnnodi(codice) ON UPDATE CASCADE ON DELETE CASCADE; ALTER TABLE ONLY bnrami ADD CONSTRAINT ix_bnrami_sx_dx UNIQUE (nodosx, nododx); </code> cli/franke/aiocap/implementation.txt Last modified: 2017/10/20 15:11(external edit)