create.txt

SET SEARCH_PATH TO groep13v2;

CREATE TABLE bijschooling (
    id_bijscholing  int PRIMARY KEY NOT NULL,
    competentie     int,
    personeel       int,
    datum           varchar(45)
);

CREATE TABLE personeel (
    id_personeel    int PRIMARY KEY NOT NULL,
    voornaam        varchar(45),
    achternaam      varchar(45),
    geboortedatum   date,
    geslacht        boolean,
    telefoonnummer  int,
    email           varchar(45)
);

CREATE TABLE team (
    id_team     int PRIMARY KEY NOT NULL,
    naam        varchar(45)
);

CREATE TABLE personeelteam (
    id_personeelteam    int PRIMARY KEY NOT NULL,
    id_team             int references team(id_team),
    id_personeel        int references personeel(id_personeel)
);
CREATE TABLE project (
    id_project      int PRIMARY KEY NOT NULL,
    naam            varchar(45),
    type            varchar(45),
    stratdatum      date,
    einddatum       date
);

CREATE TABLE teamproject (
    id_teamproject  int PRIMARY KEY NOT NULL,
    id_project      int references project(id_project),
    id_team         int references team(id_team)
);

CREATE TABLE personeelproject (
    id_personeelproject int PRIMARY KEY NOT NULL,
    id_project          int references project(id_project),
    id_personeel        int references personeel(id_personeel)
);

CREATE TABLE competentie (
    id_competentie  int PRIMARY KEY NOT NULL,
    naam            varchar(45),
    type            varchar(45),
    graad           int
);

CREATE TABLE personeelcompetentie (
    id_personeelcompetentie int PRIMARY KEY NOT NULL,
    id_competenite          int references competentie(id_competentie),
    id_personeel            int references personeel(id_personeel)
);

CREATE TABLE projectcompetentie (
    id_projectcompetentie   int PRIMARY KEY NOT NULL,
    id_competenite          int references competentie(id_competentie),
    id_project              int references project(id_project)
);
CREATE TABLE vacatures (
    id_vacatures     int PRIMARY KEY NOT NULL,
    id_naam          varchar(45),
    id_beschrijving  varchar(45)
);

CREATE TABLE competentievacatures (
    id_competentievacatures int PRIMARY KEY NOT NULL,
    id_competentie          int references competentie(id_competentie),
    id_vacatures            int references vacatures (id_vacatures)
);
CREATE TABLE temperatuur (
    id_temperatuur  int PRIMARY KEY NOT NULL,
    temperatuur     varchar(45)
);