tables.sql

create table bugs (
    libname STRING PRIMARY KEY,
    numberofbugs INTEGER,
    status STRING,
    FOREIGN KEY(libname) REFERENCES releasefreq(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES lastdiscussed(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES pullrequests(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES issueresponse(libname) ON DELETE CASCADE
);

create table releasefreq (
    libname STRING PRIMARY KEY,
    numreleases INTEGER,
    averagedays INTEGER,
    status STRING,
    FOREIGN KEY(libname) REFERENCES bugs(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES lastdiscussed(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES pullrequests(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES issueresponse(libname) ON DELETE CASCADE
);

create table lastdiscussed (
    libname STRING PRIMARY KEY,
    lastdate STRING,
    FOREIGN KEY(libname) REFERENCES bugs(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES releasefreq(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES pullrequests(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES issueresponse(libname) ON DELETE CASCADE
);

create table pullrequests (
    libname STRING PRIMARY KEY,
    percent STRING,
    mergedcount INTEGER,
    contributorprcount INTEGER,
    numPRs INTEGER,
    saveddate STRING,
    status STRING,
    FOREIGN KEY(libname) REFERENCES bugs(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES releasefreq(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES lastdiscussed(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES issueresponse(libname) ON DELETE CASCADE
);

create table users (
    libname STRING PRIMARY KEY,
    userclassification STRING,
    FOREIGN KEY(libname) REFERENCES pullrequests(libname) ON DELETE CASCADE
);

create table issueresponse (
    libname STRING PRIMARY KEY,
    averagedays STRING,
    totalWithComments INTEGER,
    totalIssues INTEGER,
    status STRING,
    FOREIGN KEY(libname) REFERENCES bugs(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES releasefreq(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES lastdiscussed(libname) ON DELETE CASCADE,
    FOREIGN KEY(libname) REFERENCES pullrequests(libname) ON DELETE CASCADE
);