CREATE TABLE public.actionplan (
    codoper character varying(51) NOT NULL,
    codprj integer NOT NULL,
    tm integer NOT NULL,
    problem character varying(1024),
    solution character varying(1024),
    why character varying(1024)
);
COMMENT ON TABLE public.actionplan IS 'Action plan di qualità legato ai quality alarms';
COMMENT ON COLUMN public.actionplan.codoper IS 'Chi';
COMMENT ON COLUMN public.actionplan.codprj IS 'Oggetto di riferimento';
COMMENT ON COLUMN public.actionplan.tm IS 'Quando';
ALTER TABLE ONLY public.actionplan
    ADD CONSTRAINT ix_actionplan_key PRIMARY KEY (codoper, codprj, tm);
ALTER TABLE ONLY public.actionplan
    ADD CONSTRAINT ix_actionplan_codoper FOREIGN KEY (codoper) REFERENCES public.operato(codice) ON UPDATE CASCADE ON DELETE RESTRICT;
ALTER TABLE ONLY public.actionplan
    ADD CONSTRAINT ix_actionplan_codprj FOREIGN KEY (codprj) REFERENCES public.project(codice) ON UPDATE CASCADE ON DELETE CASCADE;
alter table project add column qintext integer default 0;
comment on column project.qintext is '0=quality alarm internal,1=quality alarm external';