CREATE TABLE [KOSTENPLAATS] (
    [KOSTENPLAATS_ID] INT PRIMARY KEY,
    [BTWCODE] VARCHAR(255),
    [BTWOMSCHRIJVING] VARCHAR(80),
    [KOSTENPLAATSSOORTCODE] DECIMAL(10,2),
    [KOSTENPLAATSSOORTOMSCHRIJVING] DECIMAL(10,2),
    [KOSTENPLAATSTYPECODE] DECIMAL(10,2),
    [KOSTENPLAATSTYPEOMSCHRIJVING] DECIMAL(10,2),
    [NAAM] VARCHAR(80),
    [OMSCHRIJVING] VARCHAR(200)
);

CREATE TABLE [CPV_CODE] (
    [CPV_CODE_ID] INT PRIMARY KEY,
    [CODE] VARCHAR(80),
    [OMSCHRIJVING] VARCHAR(255)
);

CREATE TABLE [KP_MDWRKR_ORGNSTRSCHNHD] (
    [KP_MDWRKR_ORGNSTRSCHNHD_ID] INT PRIMARY KEY,
    [MEDEWERKER_ID] INT,
    [ORGANISATORISCHEEENHEID_ID] INT
);

CREATE TABLE [AANBESTEDING] (
    [AANBESTEDING_ID] INT PRIMARY KEY,
    [BETREFT_ZAAK_ID] INT,
    [DATUMPUBLICATIE] DATE,
    [DATUMSTART] DATE,
    [DIGITAAL] BIT,
    [MONDT_UIT_GUNNING_ID] INT,
    [NAAM] VARCHAR(200),
    [PROCEDURE_ENUM_ID] INT,
    [PROCESLEIDER_MEDEWERKER_ID] INT,
    [REFERENTIENUMMER] VARCHAR(80),
    [SCOREMAXIMAAL] INT,
    [STATUS] VARCHAR(80),
    [TENDERNEDKENMERK] VARCHAR(80),
    [TYPE_ENUM_ID] INT,
    [VALT_ONDER_CPV_CODE_ID] INT,
    [VOLGENDESLUITING] VARCHAR(255)
);

CREATE TABLE [KP_INKPPKKT_CPV_CD] (
    [KP_INKPPKKT_CPV_CD_ID] INT PRIMARY KEY,
    [INKOOPPAKKET_ID] INT,
    [CPV_CODE_ID] INT
);

CREATE TABLE [INKOOPROL_ENUM] (
    [INKOOPROL_ENUM_ID] INT PRIMARY KEY,
    VALUE VARCHAR(255)
);

INSERT INTO [INKOOPROL_ENUM] ([INKOOPROL_ENUM_ID], VALUE) VALUES
    (1, 'BEHEERDER'),
    (2, 'EIGENAAR'),
    (3, 'INKOOPADVISEUR');

CREATE TABLE [KP_KSTNPLTS_INKPRDR] (
    [KP_KSTNPLTS_INKPRDR_ID] INT PRIMARY KEY,
    [KOSTENPLAATS_ID] INT,
    [INKOOPORDER_ID] INT
);

CREATE TABLE [OPDRACHTSOORT_ENUM] (
    [OPDRACHTSOORT_ENUM_ID] INT PRIMARY KEY,
    VALUE VARCHAR(255)
);

INSERT INTO [OPDRACHTSOORT_ENUM] ([OPDRACHTSOORT_ENUM_ID], VALUE) VALUES
    (1, 'INHUUR_EXTERN_PERSONEEL'),
    (2, 'OPDRACHT_VOOR_LEVERING_DIENSTEN_OF_WERKEN'),
    (3, 'SUBSIDIES');

CREATE TABLE [INKOOPORDER] (
    [INKOOPORDER_ID] INT PRIMARY KEY,
    [ARTIKELCODE] VARCHAR(80),
    [BETALINGMEERDEREJAREN] BIT,
    [BETREFT] VARCHAR(255),
    [BETREFT_CONTRACT_ID] INT,
    [DATUMEINDE] DATE,
    [DATUMINGEDIEND] DATE,
    [DATUMSTART] DATE,
    [GERELATEERD_INKOOPORDER_ID] INT,
    [GOEDERENCODE] VARCHAR(80),
    [HEEFT_INKOOPPAKKET_ID] INT,
    [OMSCHRIJVING] VARCHAR(255),
    [OORSPRONKELIJK_INKOOPORDER_ID] INT,
    [ORDERNUMMER] VARCHAR(255),
    [SALDO] VARCHAR(255),
    [TOTAALNETTOBEDRAG] DECIMAL(10,2),
    [VERPLICHTING_AAN_LEVERANCIER_ID] INT,
    [WIJZEVANAANBESTEDEN] VARCHAR(255)
);

CREATE TABLE [INKOOPPAKKET] (
    [INKOOPPAKKET_ID] INT PRIMARY KEY,
    [CODE] VARCHAR(80),
    [NAAM] VARCHAR(200),
    [TYPE_ENUM_ID] INT
);

CREATE TABLE [STARTFORMULIERAANBESTEDEN] (
    [STARTFORMULIERAANBESTEDEN_ID] INT PRIMARY KEY,
    [BEOOGDELOOPTIJD] DATETIME2,
    [BEOOGDETOTALEOPDRACHTWAARDE] VARCHAR(255),
    [BETREFT_ZAAK_ID] INT,
    [DIENT_IN_MEDEWERKER_ID] INT,
    [INDICATIEAANVULLENDEOPDRACHTLEVERANCIER] BIT,
    [INDICATIEBEOOGDEAANBESTEDINGONDERHANDS] BIT,
    [INDICATIEBEOOGDEPROCKOMTOVEREEN] BIT,
    [INDICATIEEENMALIGELOS] BIT,
    [INDICATIEMEERJARIGERAAMOVEREENKOMST] BIT,
    [INDICATIEMEERJARIGREPETEREND] BIT,
    [INDICATOROVERKOEPELENDPROJECT] BIT,
    [MONDT_UIT_AANBESTEDING_ID] INT,
    [OMSCHRIJVING] NVARCHAR(MAX),
    [OPDRACHTCATEGORIE_ENUM_ID] INT,
    [OPDRACHTSOORT_ENUM_ID] INT,
    [TOELICHTINGAANVULLENDEOPDRACHT] NVARCHAR(MAX),
    [TOELICHTINGEENMALIGOFREPETEREND] NVARCHAR(MAX)
);

CREATE TABLE [CONTRACT] (
    [CONTRACT_ID] INT PRIMARY KEY,
    [AUTORISATIEGROEP] VARCHAR(200),
    [BESCHRIJVING] NVARCHAR(MAX),
    [BOVENLIGGEND_CONTRACT_ID] INT,
    [CATEGORIE] VARCHAR(80),
    [CLASSIFICATIE] VARCHAR(80),
    [CONTRACTANT_LEVERANCIER_ID] INT,
    [CONTRACTREVISIE] INT,
    [DATUMCREATIE] DATE,
    [DATUMEINDE] DATE,
    [DATUMSTART] DATE,
    [GROEP] VARCHAR(80),
    [INTERNCONTRACTID] VARCHAR(255),
    [INTERNCONTRACTREVISIE] INT,
    [OPMERKINGEN] NVARCHAR(MAX),
    [STATUS] VARCHAR(80),
    [TYPE] VARCHAR(80),
    [VOORWAARDE] VARCHAR(80),
    [ZOEKWOORDEN] VARCHAR(255)
);

CREATE TABLE [MEDEWERKER] (
    [MEDEWERKER_ID] INT PRIMARY KEY,
    [ACHTERNAAM] VARCHAR(200),
    [DATUMINDIENST] DATE,
    [DATUMUITDIENST] DATE,
    [EMAILADRES] VARCHAR(255),
    [EXTERN] BIT,
    [FUNCTIE] VARCHAR(50),
    [GELEVERD_VIA_LEVERANCIER_ID] INT,
    [GESLACHTSAANDUIDING] VARCHAR(255),
    [IS_CONTACTPERSOON_VOOR_ORGANISATORISCHEEENHEID_ID] INT,
    [IS_VERANTWOORDELIJK_VOOR_ORGANISATORISCHEEENHEID_ID] INT,
    [MEDEWERKERIDENTIFICATIE] VARCHAR(255),
    [MEDEWERKERTOELICHTING] VARCHAR(255),
    [ROEPNAAM] VARCHAR(255),
    [TELEFOONNUMMER] VARCHAR(20),
    [VOORLETTERS] VARCHAR(20),
    [VOORVOEGSELACHTERNAAM] VARCHAR(255)
);

CREATE TABLE [DOCUMENT] (
    [DOCUMENT_ID] INT PRIMARY KEY,
    [COCUMENTBESCHRIJVING] VARCHAR(255),
    [DATUMCREATIEDOCUMENT] DATE,
    [DATUMONTVANGSTDOCUMENT] DATE,
    [DATUMVERZENDINGDOCUMENT] DATE,
    [DOCUMENTAUTEUR] VARCHAR(200),
    [DOCUMENTIDENTIFICATIE] VARCHAR(255),
    [DOCUMENTTITEL] VARCHAR(200),
    [VERTROUWELIJKAANDUIDING] VARCHAR(20)
);

CREATE TABLE [KP_ZK_MDWRKR] (
    [KP_ZK_MDWRKR_ID] INT PRIMARY KEY,
    [ZAAK_ID] INT,
    [MEDEWERKER_ID] INT
);

CREATE TABLE [ZAAK] (
    [ZAAK_ID] INT PRIMARY KEY,
    [ARCHIEFNOMINATIE] VARCHAR(255),
    [DATUMEINDE] DATE,
    [DATUMEINDEGEPLAND] DATE,
    [DATUMEINDEUITERLIJKEAFDOENING] DATE,
    [DATUMLAATSTEBETALING] DATE,
    [DATUMPUBLICATIE] DATE,
    [DATUMREGISTRATIE] DATE,
    [DATUMSTART] DATE,
    [DATUMVERNIETIGINGDOSSIER] DATE,
    [DUURVERLENGING] VARCHAR(255),
    [HEEFT_BETREKKING_OP_ANDERE_ZAAK_ID] INT,
    [INDICATIEBETALING] VARCHAR(255),
    [INDICATIEDEELZAKEN] BIT,
    [INDICATIEOPSCHORTING] VARCHAR(255),
    [IS_DEELZAAK_VAN_ZAAK_ID] INT,
    [LEGES] VARCHAR(100),
    [OMSCHRIJVING] VARCHAR(80),
    [OMSCHRIJVINGRESULTAAT] VARCHAR(80),
    [REDENOPSCHORTING] VARCHAR(200),
    [REDENVERLENGING] VARCHAR(200),
    [TOELICHTING] VARCHAR(255),
    [TOELICHTINGRESULTAAT] VARCHAR(255),
    [VERTROUWELIJKHEID] VARCHAR(255),
    [ZAAKIDENTIFICATIE] VARCHAR(255),
    [ZAAKNIVEAU] VARCHAR(255)
);

CREATE TABLE [KP_ANBSTDNG_DCMNT] (
    [KP_ANBSTDNG_DCMNT_ID] INT PRIMARY KEY,
    [AANBESTEDING_ID] INT,
    [DOCUMENT_ID] INT
);

CREATE TABLE [AANKONDIGING] (
    [AANKONDIGING_ID] INT PRIMARY KEY,
    [BESCHRIJVING] NVARCHAR(MAX),
    [CATEGORIE_ENUM_ID] INT,
    [DATUM] DATE,
    [MONDT_UIT_AANBESTEDING_ID] INT,
    [MONDT_UIT_STARTFORMULIERAANBESTEDEN_ID] INT,
    [NAAM] VARCHAR(200),
    [TYPE_ENUM_ID] INT
);

CREATE TABLE [SELECTIETABELAANBESTEDING] (
    [SELECTIETABELAANBESTEDING_ID] INT PRIMARY KEY,
    [AANBESTEDINGSOORT_ENUM_ID] INT,
    [DREMPELBEDRAGTOT] DECIMAL(10,2),
    [DREMPELBEDRAGVANAF] DECIMAL(10,2),
    [OPDRACHTCATEGORIE_ENUM_ID] INT,
    [OPENBAAR] BIT
);

CREATE TABLE [OPDRACHTCATEGORIE_ENUM] (
    [OPDRACHTCATEGORIE_ENUM_ID] INT PRIMARY KEY,
    VALUE VARCHAR(255)
);

INSERT INTO [OPDRACHTCATEGORIE_ENUM] ([OPDRACHTCATEGORIE_ENUM_ID], VALUE) VALUES
    (1, 'DIENSTEN_REGULIER'),
    (2, 'DIENSTEN_SOCIALE_OF_SPECIFIEKE_DIENSTEN'),
    (3, 'LEVERINGEN'),
    (4, 'WERKEN');

CREATE TABLE [INSCHRIJVING] (
    [INSCHRIJVING_ID] INT PRIMARY KEY,
    [BETREFT_AANBESTEDING_ID] INT,
    [DATUM] DATE,
    [HEEFT_LEVERANCIER_ID] INT,
    [PRIJS] DECIMAL(10,2),
    [SCORE] INT
);

CREATE TABLE [LEVERANCIER] (
    [LEVERANCIER_ID] INT PRIMARY KEY,
    [NAAM] VARCHAR(200),
    [NUMMER] VARCHAR(255)
);

CREATE TABLE [GUNNING] (
    [GUNNING_ID] INT PRIMARY KEY,
    [BERICHT] VARCHAR(255),
    [BETREFT_INSCHRIJVING_ID] INT,
    [BETREFT_OFFERTE_ID] INT,
    [DATUMGUNNING] DATE,
    [DATUMPUBLICATIE] DATE,
    [DATUMVOORLOPIGEGUNNING] DATE,
    [GEGUNDEPRIJS] DECIMAL(10,2),
    [INHUUR_MEDEWERKER_ID] INT
);

CREATE TABLE [ORGANISATORISCHEEENHEID] (
    [ORGANISATORISCHEEENHEID_ID] INT PRIMARY KEY,
    [DATUMONTSTAAN] DATE,
    [DATUMOPHEFFING] DATE,
    [EMAILADRES] VARCHAR(255),
    [FAXNUMMER] VARCHAR(20),
    [FORMATIE] VARCHAR(255),
    [HEEFT_KOSTENPLAATS_ID] INT,
    [IS_DEEL_VAN_ORGANISATORISCHEEENHEID_ID] INT,
    [NAAM] VARCHAR(50),
    [NAAMVERKORT] VARCHAR(255),
    [OMSCHRIJVING] VARCHAR(80),
    [ORGANISATIEIDENTIFICATIE] VARCHAR(255),
    [TELEFOONNUMMER] VARCHAR(20),
    [TOELICHTING] VARCHAR(255)
);

CREATE TABLE [OFFERTEAANVRAAG] (
    [OFFERTEAANVRAAG_ID] INT PRIMARY KEY,
    [BETREFT_AANBESTEDING_ID] INT,
    [DATUMAANVRAAG] DATE,
    [DATUMSLUITING] DATE,
    [GERICHT_AAN_LEVERANCIER_ID] INT,
    [NAAM] VARCHAR(80),
    [OMSCHRIJVING] NVARCHAR(MAX)
);

CREATE TABLE [AANBESTEDINGSOORT_ENUM] (
    [AANBESTEDINGSOORT_ENUM_ID] INT PRIMARY KEY,
    VALUE VARCHAR(255)
);

INSERT INTO [AANBESTEDINGSOORT_ENUM] ([AANBESTEDINGSOORT_ENUM_ID], VALUE) VALUES
    (1, 'ENKELVOUDIG_ONDERHANDS'),
    (2, 'EUROPESE_AANBESTEDING'),
    (3, 'MEERVOUDIG_ONDERHANDS'),
    (4, 'NATIONALE_AANBESTEDING');

CREATE TABLE [OFFERTE] (
    [OFFERTE_ID] INT PRIMARY KEY,
    [BETREFT_AANBESTEDING_ID] INT,
    [DATUMOFFERTE] DATE,
    [INGEDIEND_DOOR_LEVERANCIER_ID] INT,
    [NAAM] VARCHAR(200),
    [OMSCHRIJVING] NVARCHAR(MAX),
    [PRIJS] DECIMAL(10,2)
);

CREATE TABLE [KP_CNTRCT_DCMNT] (
    [KP_CNTRCT_DCMNT_ID] INT PRIMARY KEY,
    [CONTRACT_ID] INT,
    [DOCUMENT_ID] INT
);

CREATE TABLE [KWALIFICATIE] (
    [KWALIFICATIE_ID] INT PRIMARY KEY,
    [BETREFT_AANBESTEDING_ID] INT,
    [EINDEGELDIGHEID] DATE,
    [HEEFT_LEVERANCIER_ID] INT,
    [STARTGELDIGHEID] DATE
);

CREATE TABLE [KP_ZK_DCMNT] (
    [KP_ZK_DCMNT_ID] INT PRIMARY KEY,
    [ZAAK_ID] INT,
    [DOCUMENT_ID] INT
);

ALTER TABLE [KP_CNTRCT_DCMNT] ADD CONSTRAINT FK_KP_CNTRCT_DCMNT_1 FOREIGN KEY ([CONTRACT_ID]) REFERENCES [CONTRACT] ([CONTRACT_ID]);
-- CONTRACT (many-to-many junction, Connector_ID: 103)

ALTER TABLE [KP_CNTRCT_DCMNT] ADD CONSTRAINT FK_KP_CNTRCT_DCMNT_2 FOREIGN KEY ([DOCUMENT_ID]) REFERENCES [DOCUMENT] ([DOCUMENT_ID]);
-- DOCUMENT (many-to-many junction, Connector_ID: 103)

ALTER TABLE [KP_ANBSTDNG_DCMNT] ADD CONSTRAINT FK_KP_ANBSTDNG_DCMNT_1 FOREIGN KEY ([AANBESTEDING_ID]) REFERENCES [AANBESTEDING] ([AANBESTEDING_ID]);
-- AANBESTEDING (many-to-many junction, Connector_ID: 106)

ALTER TABLE [KP_ANBSTDNG_DCMNT] ADD CONSTRAINT FK_KP_ANBSTDNG_DCMNT_2 FOREIGN KEY ([DOCUMENT_ID]) REFERENCES [DOCUMENT] ([DOCUMENT_ID]);
-- DOCUMENT (many-to-many junction, Connector_ID: 106)

ALTER TABLE [KP_INKPPKKT_CPV_CD] ADD CONSTRAINT FK_KP_INKPPKKT_CPV_CD_1 FOREIGN KEY ([INKOOPPAKKET_ID]) REFERENCES [INKOOPPAKKET] ([INKOOPPAKKET_ID]);
-- INKOOPPAKKET (many-to-many junction, Connector_ID: 403)

ALTER TABLE [KP_INKPPKKT_CPV_CD] ADD CONSTRAINT FK_KP_INKPPKKT_CPV_CD_2 FOREIGN KEY ([CPV_CODE_ID]) REFERENCES [CPV_CODE] ([CPV_CODE_ID]);
-- CPV_CODE (many-to-many junction, Connector_ID: 403)

ALTER TABLE [KP_KSTNPLTS_INKPRDR] ADD CONSTRAINT FK_KP_KSTNPLTS_INKPRDR_1 FOREIGN KEY ([KOSTENPLAATS_ID]) REFERENCES [KOSTENPLAATS] ([KOSTENPLAATS_ID]);
-- KOSTENPLAATS (many-to-many junction, Connector_ID: 492)

ALTER TABLE [KP_KSTNPLTS_INKPRDR] ADD CONSTRAINT FK_KP_KSTNPLTS_INKPRDR_2 FOREIGN KEY ([INKOOPORDER_ID]) REFERENCES [INKOOPORDER] ([INKOOPORDER_ID]);
-- INKOOPORDER (many-to-many junction, Connector_ID: 492)

ALTER TABLE [KP_ZK_DCMNT] ADD CONSTRAINT FK_KP_ZK_DCMNT_1 FOREIGN KEY ([ZAAK_ID]) REFERENCES [ZAAK] ([ZAAK_ID]);
-- ZAAK (many-to-many junction, Connector_ID: 2132)

ALTER TABLE [KP_ZK_DCMNT] ADD CONSTRAINT FK_KP_ZK_DCMNT_2 FOREIGN KEY ([DOCUMENT_ID]) REFERENCES [DOCUMENT] ([DOCUMENT_ID]);
-- DOCUMENT (many-to-many junction, Connector_ID: 2132)

ALTER TABLE [KP_MDWRKR_ORGNSTRSCHNHD] ADD CONSTRAINT FK_KP_MDWRKR_ORGNSTRSCHNHD_1 FOREIGN KEY ([MEDEWERKER_ID]) REFERENCES [MEDEWERKER] ([MEDEWERKER_ID]);
-- MEDEWERKER (many-to-many junction, Connector_ID: 2175)

ALTER TABLE [KP_MDWRKR_ORGNSTRSCHNHD] ADD CONSTRAINT FK_KP_MDWRKR_ORGNSTRSCHNHD_2 FOREIGN KEY ([ORGANISATORISCHEEENHEID_ID]) REFERENCES [ORGANISATORISCHEEENHEID] ([ORGANISATORISCHEEENHEID_ID]);
-- ORGANISATORISCHEEENHEID (many-to-many junction, Connector_ID: 2175)

ALTER TABLE [KP_ZK_MDWRKR] ADD CONSTRAINT FK_KP_ZK_MDWRKR_1 FOREIGN KEY ([ZAAK_ID]) REFERENCES [ZAAK] ([ZAAK_ID]);
-- ZAAK (many-to-many junction, Connector_ID: 2190)

ALTER TABLE [KP_ZK_MDWRKR] ADD CONSTRAINT FK_KP_ZK_MDWRKR_2 FOREIGN KEY ([MEDEWERKER_ID]) REFERENCES [MEDEWERKER] ([MEDEWERKER_ID]);
-- MEDEWERKER (many-to-many junction, Connector_ID: 2190)

ALTER TABLE [STARTFORMULIERAANBESTEDEN] ADD CONSTRAINT FK_STARTFORMULIERAANBESTEDEN_BETREFT FOREIGN KEY ([BETREFT_ZAAK_ID]) REFERENCES [ZAAK] ([ZAAK_ID]);
-- BETREFT (0..* to 0..1, Connector_ID: 385)

ALTER TABLE [OFFERTE] ADD CONSTRAINT FK_OFFERTE_INGEDIEND_DOOR FOREIGN KEY ([INGEDIEND_DOOR_LEVERANCIER_ID]) REFERENCES [LEVERANCIER] ([LEVERANCIER_ID]);
-- INGEDIEND_DOOR (0..* to 1, Connector_ID: 386)

ALTER TABLE [OFFERTEAANVRAAG] ADD CONSTRAINT FK_OFFERTEAANVRAAG_GERICHT_AAN FOREIGN KEY ([GERICHT_AAN_LEVERANCIER_ID]) REFERENCES [LEVERANCIER] ([LEVERANCIER_ID]);
-- GERICHT_AAN (0..* to 1, Connector_ID: 387)

ALTER TABLE [KWALIFICATIE] ADD CONSTRAINT FK_KWALIFICATIE_HEEFT FOREIGN KEY ([HEEFT_LEVERANCIER_ID]) REFERENCES [LEVERANCIER] ([LEVERANCIER_ID]);
-- HEEFT (1 to 0..*, Connector_ID: 391)

ALTER TABLE [INSCHRIJVING] ADD CONSTRAINT FK_INSCHRIJVING_HEEFT FOREIGN KEY ([HEEFT_LEVERANCIER_ID]) REFERENCES [LEVERANCIER] ([LEVERANCIER_ID]);
-- HEEFT (1 to 0..*, Connector_ID: 394)

ALTER TABLE [GUNNING] ADD CONSTRAINT FK_GUNNING_INHUUR FOREIGN KEY ([INHUUR_MEDEWERKER_ID]) REFERENCES [MEDEWERKER] ([MEDEWERKER_ID]);
-- INHUUR (0..* to 0..1, Connector_ID: 395)

ALTER TABLE [GUNNING] ADD CONSTRAINT FK_GUNNING_BETREFT FOREIGN KEY ([BETREFT_OFFERTE_ID]) REFERENCES [OFFERTE] ([OFFERTE_ID]);
-- BETREFT (0..1 to 0..1, Connector_ID: 396)

ALTER TABLE [GUNNING] ADD CONSTRAINT FK_GUNNING_BETREFT_2 FOREIGN KEY ([BETREFT_INSCHRIJVING_ID]) REFERENCES [INSCHRIJVING] ([INSCHRIJVING_ID]);
-- BETREFT (0..1 to 0..1, Connector_ID: 398)

ALTER TABLE [CONTRACT] ADD CONSTRAINT FK_CONTRACT_CONTRACTANT FOREIGN KEY ([CONTRACTANT_LEVERANCIER_ID]) REFERENCES [LEVERANCIER] ([LEVERANCIER_ID]);
-- CONTRACTANT (1 to 0..*, Connector_ID: 404)

ALTER TABLE [CONTRACT] ADD CONSTRAINT FK_CONTRACT_BOVENLIGGEND FOREIGN KEY ([BOVENLIGGEND_CONTRACT_ID]) REFERENCES [CONTRACT] ([CONTRACT_ID]);
-- BOVENLIGGEND (0..* to 0..1, Connector_ID: 405)

ALTER TABLE [AANKONDIGING] ADD CONSTRAINT FK_AANKONDIGING_MONDT_UIT FOREIGN KEY ([MONDT_UIT_STARTFORMULIERAANBESTEDEN_ID]) REFERENCES [STARTFORMULIERAANBESTEDEN] ([STARTFORMULIERAANBESTEDEN_ID]);
-- MONDT_UIT (0..1 to 0..*, Connector_ID: 413)

ALTER TABLE [AANBESTEDING] ADD CONSTRAINT FK_AANBESTEDING_VALT_ONDER FOREIGN KEY ([VALT_ONDER_CPV_CODE_ID]) REFERENCES [CPV_CODE] ([CPV_CODE_ID]);
-- VALT_ONDER (1 to 0..*, Connector_ID: 421)

ALTER TABLE [INSCHRIJVING] ADD CONSTRAINT FK_INSCHRIJVING_BETREFT FOREIGN KEY ([BETREFT_AANBESTEDING_ID]) REFERENCES [AANBESTEDING] ([AANBESTEDING_ID]);
-- BETREFT (0..* to 1, Connector_ID: 422)

ALTER TABLE [OFFERTE] ADD CONSTRAINT FK_OFFERTE_BETREFT FOREIGN KEY ([BETREFT_AANBESTEDING_ID]) REFERENCES [AANBESTEDING] ([AANBESTEDING_ID]);
-- BETREFT (0..* to 1, Connector_ID: 423)

ALTER TABLE [STARTFORMULIERAANBESTEDEN] ADD CONSTRAINT FK_STARTFORMULIERAANBESTEDEN_MONDT_UIT FOREIGN KEY ([MONDT_UIT_AANBESTEDING_ID]) REFERENCES [AANBESTEDING] ([AANBESTEDING_ID]);
-- MONDT_UIT (0..1 to 0..1, Connector_ID: 424)

ALTER TABLE [AANKONDIGING] ADD CONSTRAINT FK_AANKONDIGING_MONDT_UIT_2 FOREIGN KEY ([MONDT_UIT_AANBESTEDING_ID]) REFERENCES [AANBESTEDING] ([AANBESTEDING_ID]);
-- MONDT_UIT (0..* to 0..1, Connector_ID: 425)

ALTER TABLE [OFFERTEAANVRAAG] ADD CONSTRAINT FK_OFFERTEAANVRAAG_BETREFT FOREIGN KEY ([BETREFT_AANBESTEDING_ID]) REFERENCES [AANBESTEDING] ([AANBESTEDING_ID]);
-- BETREFT (0..* to 1, Connector_ID: 426)

ALTER TABLE [KWALIFICATIE] ADD CONSTRAINT FK_KWALIFICATIE_BETREFT FOREIGN KEY ([BETREFT_AANBESTEDING_ID]) REFERENCES [AANBESTEDING] ([AANBESTEDING_ID]);
-- BETREFT (0..* to 1, Connector_ID: 427)

ALTER TABLE [AANBESTEDING] ADD CONSTRAINT FK_AANBESTEDING_MONDT_UIT FOREIGN KEY ([MONDT_UIT_GUNNING_ID]) REFERENCES [GUNNING] ([GUNNING_ID]);
-- MONDT_UIT (0..1 to 0..1, Connector_ID: 428)

ALTER TABLE [AANBESTEDING] ADD CONSTRAINT FK_AANBESTEDING_BETREFT FOREIGN KEY ([BETREFT_ZAAK_ID]) REFERENCES [ZAAK] ([ZAAK_ID]);
-- BETREFT (0..1 to 0..1, Connector_ID: 429)

ALTER TABLE [AANBESTEDING] ADD CONSTRAINT FK_AANBESTEDING_PROCESLEIDER FOREIGN KEY ([PROCESLEIDER_MEDEWERKER_ID]) REFERENCES [MEDEWERKER] ([MEDEWERKER_ID]);
-- PROCESLEIDER (0..* to 0..1, Connector_ID: 430)

ALTER TABLE [INKOOPORDER] ADD CONSTRAINT FK_INKOOPORDER_OORSPRONKELIJK FOREIGN KEY ([OORSPRONKELIJK_INKOOPORDER_ID]) REFERENCES [INKOOPORDER] ([INKOOPORDER_ID]);
-- OORSPRONKELIJK (0..1 to 0..1, Connector_ID: 493)

ALTER TABLE [INKOOPORDER] ADD CONSTRAINT FK_INKOOPORDER_GERELATEERD FOREIGN KEY ([GERELATEERD_INKOOPORDER_ID]) REFERENCES [INKOOPORDER] ([INKOOPORDER_ID]);
-- GERELATEERD (0..1 to 0..*, Connector_ID: 494)

ALTER TABLE [INKOOPORDER] ADD CONSTRAINT FK_INKOOPORDER_BETREFT FOREIGN KEY ([BETREFT_CONTRACT_ID]) REFERENCES [CONTRACT] ([CONTRACT_ID]);
-- BETREFT (0..1 to 1, Connector_ID: 495)

ALTER TABLE [INKOOPORDER] ADD CONSTRAINT FK_INKOOPORDER_VERPLICHTING_AAN FOREIGN KEY ([VERPLICHTING_AAN_LEVERANCIER_ID]) REFERENCES [LEVERANCIER] ([LEVERANCIER_ID]);
-- VERPLICHTING_AAN (0..* to 1, Connector_ID: 496)

ALTER TABLE [INKOOPORDER] ADD CONSTRAINT FK_INKOOPORDER_HEEFT FOREIGN KEY ([HEEFT_INKOOPPAKKET_ID]) REFERENCES [INKOOPPAKKET] ([INKOOPPAKKET_ID]);
-- HEEFT (0..* to 1, Connector_ID: 497)

ALTER TABLE [ORGANISATORISCHEEENHEID] ADD CONSTRAINT FK_ORGANISATORISCHEEENHEID_IS_DEEL_VAN FOREIGN KEY ([IS_DEEL_VAN_ORGANISATORISCHEEENHEID_ID]) REFERENCES [ORGANISATORISCHEEENHEID] ([ORGANISATORISCHEEENHEID_ID]);
-- IS_DEEL_VAN (1 to 0..1, Connector_ID: 2059)

ALTER TABLE [ORGANISATORISCHEEENHEID] ADD CONSTRAINT FK_ORGANISATORISCHEEENHEID_HEEFT FOREIGN KEY ([HEEFT_KOSTENPLAATS_ID]) REFERENCES [KOSTENPLAATS] ([KOSTENPLAATS_ID]);
-- HEEFT (0..1 to 1, Connector_ID: 2063)

ALTER TABLE [ZAAK] ADD CONSTRAINT FK_ZAAK_HEEFT_BETREKKING_OP_ANDERE FOREIGN KEY ([HEEFT_BETREKKING_OP_ANDERE_ZAAK_ID]) REFERENCES [ZAAK] ([ZAAK_ID]);
-- HEEFT_BETREKKING_OP_ANDERE (1 to 0..*, Connector_ID: 2108)

ALTER TABLE [ZAAK] ADD CONSTRAINT FK_ZAAK_IS_DEELZAAK_VAN FOREIGN KEY ([IS_DEELZAAK_VAN_ZAAK_ID]) REFERENCES [ZAAK] ([ZAAK_ID]);
-- IS_DEELZAAK_VAN (1 to 0..1, Connector_ID: 2121)

ALTER TABLE [MEDEWERKER] ADD CONSTRAINT FK_MEDEWERKER_IS_VERANTWOORDELIJK_VOOR FOREIGN KEY ([IS_VERANTWOORDELIJK_VOOR_ORGANISATORISCHEEENHEID_ID]) REFERENCES [ORGANISATORISCHEEENHEID] ([ORGANISATORISCHEEENHEID_ID]);
-- IS_VERANTWOORDELIJK_VOOR (0..1 to 0..1, Connector_ID: 2166)

ALTER TABLE [MEDEWERKER] ADD CONSTRAINT FK_MEDEWERKER_IS_CONTACTPERSOON_VOOR FOREIGN KEY ([IS_CONTACTPERSOON_VOOR_ORGANISATORISCHEEENHEID_ID]) REFERENCES [ORGANISATORISCHEEENHEID] ([ORGANISATORISCHEEENHEID_ID]);
-- IS_CONTACTPERSOON_VOOR (0..1 to 0..1, Connector_ID: 2185)

ALTER TABLE [STARTFORMULIERAANBESTEDEN] ADD CONSTRAINT FK_STARTFORMULIERAANBESTEDEN_DIENT_IN FOREIGN KEY ([DIENT_IN_MEDEWERKER_ID]) REFERENCES [MEDEWERKER] ([MEDEWERKER_ID]);
-- DIENT_IN (1 to 0..*, Connector_ID: 2192)

ALTER TABLE [MEDEWERKER] ADD CONSTRAINT FK_MEDEWERKER_GELEVERD_VIA FOREIGN KEY ([GELEVERD_VIA_LEVERANCIER_ID]) REFERENCES [LEVERANCIER] ([LEVERANCIER_ID]);
-- GELEVERD_VIA (0..* to 0..1, Connector_ID: 2194)

ALTER TABLE [AANBESTEDING] ADD CONSTRAINT FK_AANBESTEDING_TYPE_ENUM_ID FOREIGN KEY ([TYPE_ENUM_ID_OPDRACHTCATEGORIE_ENUM_ID]) REFERENCES [OPDRACHTCATEGORIE_ENUM] ([OPDRACHTCATEGORIE_ENUM_ID]);
-- TYPE_ENUM_ID (1 to 1, Connector_ID: enum_ref)

ALTER TABLE [AANBESTEDING] ADD CONSTRAINT FK_AANBESTEDING_PROCEDURE_ENUM_ID FOREIGN KEY ([PROCEDURE_ENUM_ID_AANBESTEDINGSOORT_ENUM_ID]) REFERENCES [AANBESTEDINGSOORT_ENUM] ([AANBESTEDINGSOORT_ENUM_ID]);
-- PROCEDURE_ENUM_ID (1 to 1, Connector_ID: enum_ref)

ALTER TABLE [AANKONDIGING] ADD CONSTRAINT FK_AANKONDIGING_TYPE_ENUM_ID FOREIGN KEY ([TYPE_ENUM_ID_AANBESTEDINGSOORT_ENUM_ID]) REFERENCES [AANBESTEDINGSOORT_ENUM] ([AANBESTEDINGSOORT_ENUM_ID]);
-- TYPE_ENUM_ID (1 to 1, Connector_ID: enum_ref)

ALTER TABLE [AANKONDIGING] ADD CONSTRAINT FK_AANKONDIGING_CATEGORIE_ENUM_ID FOREIGN KEY ([CATEGORIE_ENUM_ID_OPDRACHTCATEGORIE_ENUM_ID]) REFERENCES [OPDRACHTCATEGORIE_ENUM] ([OPDRACHTCATEGORIE_ENUM_ID]);
-- CATEGORIE_ENUM_ID (1 to 1, Connector_ID: enum_ref)

ALTER TABLE [INKOOPPAKKET] ADD CONSTRAINT FK_INKOOPPAKKET_TYPE_ENUM_ID FOREIGN KEY ([TYPE_ENUM_ID_OPDRACHTCATEGORIE_ENUM_ID]) REFERENCES [OPDRACHTCATEGORIE_ENUM] ([OPDRACHTCATEGORIE_ENUM_ID]);
-- TYPE_ENUM_ID (1 to 1, Connector_ID: enum_ref)

ALTER TABLE [SELECTIETABELAANBESTEDING] ADD CONSTRAINT FK_SELECTIETABELAANBESTEDING_OPDRACHTCATEGORIE_ENUM_ID FOREIGN KEY ([OPDRACHTCATEGORIE_ENUM_ID_OPDRACHTCATEGORIE_ENUM_ID]) REFERENCES [OPDRACHTCATEGORIE_ENUM] ([OPDRACHTCATEGORIE_ENUM_ID]);
-- OPDRACHTCATEGORIE_ENUM_ID (1 to 1, Connector_ID: enum_ref)

ALTER TABLE [SELECTIETABELAANBESTEDING] ADD CONSTRAINT FK_SELECTIETABELAANBESTEDING_AANBESTEDINGSOORT_ENUM_ID FOREIGN KEY ([AANBESTEDINGSOORT_ENUM_ID_AANBESTEDINGSOORT_ENUM_ID]) REFERENCES [AANBESTEDINGSOORT_ENUM] ([AANBESTEDINGSOORT_ENUM_ID]);
-- AANBESTEDINGSOORT_ENUM_ID (1 to 1, Connector_ID: enum_ref)

ALTER TABLE [STARTFORMULIERAANBESTEDEN] ADD CONSTRAINT FK_STARTFORMULIERAANBESTEDEN_OPDRACHTCATEGORIE_ENUM_ID FOREIGN KEY ([OPDRACHTCATEGORIE_ENUM_ID_OPDRACHTCATEGORIE_ENUM_ID]) REFERENCES [OPDRACHTCATEGORIE_ENUM] ([OPDRACHTCATEGORIE_ENUM_ID]);
-- OPDRACHTCATEGORIE_ENUM_ID (1 to 1, Connector_ID: enum_ref)

ALTER TABLE [STARTFORMULIERAANBESTEDEN] ADD CONSTRAINT FK_STARTFORMULIERAANBESTEDEN_OPDRACHTSOORT_ENUM_ID FOREIGN KEY ([OPDRACHTSOORT_ENUM_ID_OPDRACHTSOORT_ENUM_ID]) REFERENCES [OPDRACHTSOORT_ENUM] ([OPDRACHTSOORT_ENUM_ID]);
-- OPDRACHTSOORT_ENUM_ID (1 to 1, Connector_ID: enum_ref)