====== 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>