CREATE TABLE SOFTWARE (
        IdSW    INTEGER         PRIMARY KEY,
        NomeSW  VARCHAR(2000)   NOT NULL,
        Path    VARCHAR(2000)   NOT NULL )

CREATE TABLE CLASSE (
        IdClasse        INTEGER         PRIMARY KEY,
        NomeClasse      VARCHAR(2000)   NOT NULL,
        PathClasse      VARCHAR(2000)   NOT NULL,
        InstrI          VARCHAR(2000)   NOT NULL,
        InstrF          VARCHAR(2000)   NOT NULL,
    Astratta    CHAR(1)     DEFAULT 'F' NOT NULL,
    Visibilità VARCHAR(2000),
    CONSTRAINT C1 CHECK (Astratta IN ('T','F') AND),
    CONSTRAINT C2 CHECK (Visibilità IN (NULL,'private','package','protected','public'))
)

CREATE TABLE PACKAGES (
        IdPKG           INTEGER         PRIMARY KEY,
        NomePKG         VARCHAR(2000)   NOT NULL,
        PathPKG         VARCHAR(2000)   NOT NULL )

CREATE TABLE ATTRIBUTI (
        IdATT           INTEGER         PRIMARY KEY,
        NomeATT         VARCHAR(2000)   NOT NULL,
        ValIniz         VARCHAR(2000)   NOT NULL,
        Tipo            VARCHAR(2000)   NOT NULL,
    Visibilità VARCHAR(2000),
    CONSTRAINT A1 CHECK (Visibilità IN (NULL,'private','package','protected','public'))
 )

CREATE TABLE INTERFACCE (
        IdINT           INTEGER         PRIMARY KEY,
        NomeINT         VARCHAR(2000)   NOT NULL,
        PathINT         VARCHAR(2000)   NOT NULL )

CREATE TABLE METODO (
        IdMetodo        INTEGER         PRIMARY KEY,
        NomeMetodo      VARCHAR(2000)   NOT NULL,
        TipoReturn      VARCHAR(2000)   NOT NULL,
    Astratto    CHAR(1)     DEFAULT 'F' NOT NULL,
    Visibilità VARCHAR(2000),
    CONSTRAINT M1 CHECK (Astratto IN ('T','F') AND),
    CONSTRAINT M2 CHECK (Visibilità IN (NULL,'private','package','protected','public')) )

CREATE TABLE PARAMETRI (
        IdPAR           INTEGER         PRIMARY KEY,
        NomePAR         VARCHAR(2000)   NOT NULL,
        TipoPAR         VARCHAR(2000)   NOT NULL,
        MetodoRif       INTEGER         NOT NULL    FOREIGN KEY REFERENCES TO METODO.IdMetodo   ON DELETE CASCADE )

CREATE TABLE COMPSOFTWARE (
    ClasseRif       INTEGER         NOT NULL        FOREIGN KEY REFERENCES TO CLASSE.IdClasse   ON DELETE CASCADE,
        SWRif           INTEGER         NOT NULL        FOREIGN KEY REFERENCES TO SOFTWARE.IdSW     ON DELETE CASCADE )



CREATE TABLE ATTMETODI (
        MetodoRif       INTEGER         NOT NULL   FOREIGN KEY REFERENCES TO METODO.IdMetodo           ON DELETE CASCADE,
        ATTRif          INTEGER         NOT NULL   UNIQUE  FOREIGN KEY REFERENCES TO ATTRIBUTI.IdATT       ON DELETE CASCADE )

CREATE TABLE ATTCLASSE (
    ClasseRif       INTEGER         NOT NULL   FOREIGN KEY REFERENCES TO CLASSE.IdClasse            ON DELETE CASCADE,
        ATTRif          INTEGER         NOT NULL   UNIQUE  FOREIGN KEY REFERENCES TO ATTRIBUTI.IdATT    ON DELETE CASCADE )

CREATE TABLE COMPINTERFACCE (
    INTRif          INTEGER         NOT NULL   FOREIGN KEY REFERENCES TO INTERFACCE.IdINT       ON DELETE CASCADE,
        METRif          INTEGER         NOT NULL   UNIQUE  FOREIGN KEY REFERENCES TO METODO.IdMetodo    ON DELETE CASCADE )

CREATE TABLE COMPCLASSEMETODI (
    ClasseRif       INTEGER         NOT NULL   FOREIGN KEY REFERENCES TO CLASSE.IdClasse        ON DELETE CASCADE,
        METRif          INTEGER         NOT NULL   UNIQUE  FOREIGN KEY REFERENCES TO METODO.IdMetodo    ON DELETE CASCADE )

CREATE TABLE CLASSEIMPL (
        ClasseRif       INTEGER         NOT NULL  UNIQUE  FOREIGN KEY REFERENCES TO CLASSE.IdClasse    ON DELETE CASCADE,
        INTRif          INTEGER         NOT NULL  UNIQUE  FOREIGN KEY REFERENCES TO INTERFACCE.IdINT       ON DELETE CASCADE )

CREATE TABLE EXTEND (
    ClassePadre     INTEGER         NOT NULL   FOREIGN KEY REFERENCES TO CLASSE.IdClasse        ON DELETE CASCADE,
        ClasseFiglio    INTEGER         NOT NULL   UNIQUE  FOREIGN KEY REFERENCES TO CLASSE.IdClasse    ON DELETE CASCADE )

CREATE TABLE COMPCLASSEPACKAGES (
        ClasseRif       INTEGER     NOT NULL   UNIQUE   FOREIGN KEY REFERENCES TO CLASSE.IdClasse   ON DELETE CASCADE,
    PKGRif          INTEGER         NOT NULL   FOREIGN KEY REFERENCES TO PACKAGES.IdPKG     ON DELETE CASCADE )