CREATE TABLE [KP_ALMNTT_PRMR_INKMSTNCMPNNT] ( [KP_ALMNTT_PRMR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [ALIMENTATIE_ID] INT, [PRIMAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [INKOMSTENVERHOUDING] ( [INKOMSTENVERHOUDING_ID] INT PRIMARY KEY, [CATEGORIE_INKOMSTEN] VARCHAR(255), [INKOMSTENVERHOUDING_BEVAT_PRIMAIR_INKOMSTENCOMPONENT_INKOMSTENCOMPONENT_ID] INT, [PERIODE_EINDDATUM] DATE, [PERIODE_STARTDATUM] DATE ); CREATE TABLE [KP_VRLGNG_DR_BT_INKMSTNVRMNDRNG] ( [KP_VRLGNG_DR_BT_INKMSTNVRMNDRNG_ID] INT PRIMARY KEY, [VERLAGING_DOOR_BOETE_ID] INT, [INKOMSTENVERMINDERING_ID] INT ); CREATE TABLE [DERTIENDE_MAAND_EINDEJAARSUITKERING] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [PENSIOEN] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY, [BESLAG_OP_PENSIOEN] BIT, [INKOMSTENSOORT_PENSIOEN] VARCHAR(255), [LOONHEFFINGSKORTING] BIT, [PENSIOEN_HEEFT_LOONBESLAG_INKOMSTENCOMPONENT_ID] INT, [PENSIOEN_HEEFT_VAKANTIEGELD_INKOMSTENCOMPONENT_ID] INT, [PERIODICITEIT_UITBETALING_PENSIOEN] VARCHAR(255), [UITBETALING_VAKANTIEGELD_PENSIOEN] VARCHAR(255) ); CREATE TABLE [KP_VRLGNG_DR_MTRGL_INKMSTNVRMNDRNG] ( [KP_VRLGNG_DR_MTRGL_INKMSTNVRMNDRNG_ID] INT PRIMARY KEY, [VERLAGING_DOOR_MAATREGEL_ID] INT, [INKOMSTENVERMINDERING_ID] INT ); CREATE TABLE [KP_TE_BTLN_ALMNTT_KSTNCMPNNT] ( [KP_TE_BTLN_ALMNTT_KSTNCMPNNT_ID] INT PRIMARY KEY, [TE_BETALEN_ALIMENTATIE_ID] INT, [KOSTENCOMPONENT_ID] INT ); CREATE TABLE [VERGOEDING_IN_NATURA] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [VERLAGING_DOOR_MAATREGEL] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [KP_SCNDR_INKMSTNCMPNNT_INKMSTNCMPNNT] ( [KP_SCNDR_INKMSTNCMPNNT_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [SECUNDAIR_INKOMSTENCOMPONENT_ID] INT, [INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [KP_RSKSTN_NR_HET_WRK__KSTNCMPNNT] ( [KP_RSKSTN_NR_HET_WRK__KSTNCMPNNT_ID] INT PRIMARY KEY, [REISKOSTEN_NAAR_HET_WERK__ID] INT, [KOSTENCOMPONENT_ID] INT ); CREATE TABLE [STUDIEFINANCIERING] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY, [DAADWERKELIJK_GENOTEN] BIT, [INKOMSTENSOORT_STUDIEFINANCIERING] VARCHAR(255) ); CREATE TABLE [KP_UTKRNG_PRMR_INKMSTNCMPNNT] ( [KP_UTKRNG_PRMR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [UITKERING_ID] INT, [PRIMAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [INKOMSTENCOMPONENT] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY, [BIJGEVOEGD_BEWIJS] BIT, [BOEKINGSDATUM] DATE, [BRUTO_NETTO] VARCHAR(255), [INKOMSTEN] VARCHAR(255), [INKOMSTENCOMPONENTTYPE] VARCHAR(255), [LINK_NAAR_BEWIJS] VARCHAR(255), [PEILMOMENT] DATE, [PERIODE_EINDDATUM] DATE, [PERIODE_STARTDATUM] DATE ); CREATE TABLE [INKOMSTENVERMINDERING] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [SECUNDAIR_INKOMSTENCOMPONENT] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [EIGEN_BEDRIJF] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY, [AANTAL_UREN_PER_WEEK_BESTEED_AAN_WERK] VARCHAR(255), [INGESCHREVEN_BIJ_KVK] BIT, [RECHT_OP_ZELFSTANDIGENAFTREK] BIT, [SOORT_BEDRIJF] VARCHAR(255), [TOESTEMMING_GEMEENTE_PARTTIME_ONDERNEMEN] BIT ); CREATE TABLE [ONDERHOUDSVERHOUDING] ( [ONDERHOUDSVERHOUDING_ID] INT PRIMARY KEY, [ONDERHOUDSVERHOUDINGTYPE] VARCHAR(255), [ONDERHOUDSVERHOUDING_BEVAT_ONDERHOUDSPLICHT_ONDERHOUDSPLICHT_ID] INT, [PERIODE_EINDDATUM] DATE, [PERIODE_STARTDATUM] DATE ); CREATE TABLE [UITKERING] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY, [BESLAG_OP_UITKERING] BIT, [INKOMSTENSOORT_UITKERING] VARCHAR(255), [LOONHEFFINGSKORTING] BIT, [PERIODICITEIT_UITBETALING_UITKERING] VARCHAR(255), [TOESLAG_OP_UITKERING] BIT, [UITKERING_HEEFT_LOONBESLAG_INKOMSTENCOMPONENT_ID] INT, [UITKERING_HEEFT_VAKANTIEGELD_INKOMSTENCOMPONENT_ID] INT, [UITKERING_HEEFT_VERLAGING_DOOR_BOETE_INKOMSTENCOMPONENT_ID] INT, [UITKERING_HEEFT_VERLAGING_DOOR_MAATREGEL_INKOMSTENCOMPONENT_ID] INT, [UITKERING_VERLAAGD_DOOR_BOETE] BIT, [UITKERING_VERLAAGD_DOOR_MAATREGEL] BIT, [VAKANTIEGELD_JAARLIJKS_ONTVANGEN] BIT ); CREATE TABLE [STAGE] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY, [MAALTIJDVERGOEDING] DATETIME2, [ONKOSTENVERGOEDING] DECIMAL(10,2), [PERIODICITEIT_UITBETALING_LOON] VARCHAR(255), [REISKOSTENVERGOEDING] DECIMAL(10,2), [STAGE_HEEFT_MAALTIJDVERGOEDING_INKOMSTENCOMPONENT_ID] INT, [STAGE_HEEFT_ONKOSTENVERGOEDING_INKOMSTENCOMPONENT_ID] INT, [STAGE_HEEFT_REISKOSTENVERGOEDING_INKOMSTENCOMPONENT_ID] INT, [STAGE_HEEFT_VERGOEDING_IN_NATURA_INKOMSTENCOMPONENT_ID] INT, [VERGOEDING_IN_NATURA] BIT ); CREATE TABLE [EIGEN_BIJDRAGE] ( [KOSTENCOMPONENT_ID] INT PRIMARY KEY, [SOORT] VARCHAR(255) ); CREATE TABLE [BESLAG_OP_INKOMEN] ( [KOSTENCOMPONENT_ID] INT PRIMARY KEY, [SOORT] VARCHAR(255) ); CREATE TABLE [DRAAGKRACHT] ( [DRAAGKRACHT_ID] INT PRIMARY KEY, [DRAAGKRACHT_HEEFT_DRAAGKRACHTREGIME_DRAAGKRACHTREGIME_ID] INT, [EINDDATUM] DATE, [STARTDATUM] DATE ); CREATE TABLE [VERLAGING_DOOR_BOETE] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [KP_STG_PRMR_INKMSTNCMPNNT] ( [KP_STG_PRMR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [STAGE_ID] INT, [PRIMAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [KP_PNSN_PRMR_INKMSTNCMPNNT] ( [KP_PNSN_PRMR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [PENSIOEN_ID] INT, [PRIMAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [KP_VRGDNG_IN_NTR_VRGDNG] ( [KP_VRGDNG_IN_NTR_VRGDNG_ID] INT PRIMARY KEY, [VERGOEDING_IN_NATURA_ID] INT, [VERGOEDING_ID] INT ); CREATE TABLE [HOBBY] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY, [AANTAL_UREN_PER_WEEK_BESTEED_AAN_HOBBY] VARCHAR(255), [BESCHRIJVING_HOBBY] VARCHAR(255) ); CREATE TABLE [REISKOSTENVERGOEDING] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [KP_STDFNNCRNG_PRMR_INKMSTNCMPNNT] ( [KP_STDFNNCRNG_PRMR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [STUDIEFINANCIERING_ID] INT, [PRIMAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [KP_LNBSLG_INKMSTNVRMNDRNG] ( [KP_LNBSLG_INKMSTNVRMNDRNG_ID] INT PRIMARY KEY, [LOONBESLAG_ID] INT, [INKOMSTENVERMINDERING_ID] INT ); CREATE TABLE [KP_EGN_BJDRG_KSTNCMPNNT] ( [KP_EGN_BJDRG_KSTNCMPNNT_ID] INT PRIMARY KEY, [EIGEN_BIJDRAGE_ID] INT, [KOSTENCOMPONENT_ID] INT ); CREATE TABLE [PRIMAIR_INKOMSTENCOMPONENT] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [ONDERHOUDSPLICHT] ( [ONDERHOUDSPLICHT_ID] INT PRIMARY KEY, [BIJDRAGE] VARCHAR(255), [BOEKINGSDATUM] DATE, [ONDERHOUDSPLICHTTYPE] VARCHAR(255), [PEILMOMENT] DATE, [PERIODE_EINDDATUM] DATE, [PERIODE_STARTDATUM] DATE ); CREATE TABLE [KP_HBBY_PRMR_INKMSTNCMPNNT] ( [KP_HBBY_PRMR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [HOBBY_ID] INT, [PRIMAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [KP_BTLD_WRK_PRMR_INKMSTNCMPNNT] ( [KP_BTLD_WRK_PRMR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [BETAALD_WERK_ID] INT, [PRIMAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [TE_BETALEN_ALIMENTATIE] ( [KOSTENCOMPONENT_ID] INT PRIMARY KEY, [SOORT] VARCHAR(255) ); CREATE TABLE [KP_VKNTGLD_SCNDR_INKMSTNCMPNNT] ( [KP_VKNTGLD_SCNDR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [VAKANTIEGELD_ID] INT, [SECUNDAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [KP_HFFNGSKRTNG_SCNDR_INKMSTNCMPNNT] ( [KP_HFFNGSKRTNG_SCNDR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [HEFFINGSKORTING_ID] INT, [SECUNDAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [MAALTIJDVERGOEDING] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [VERGOEDING] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [KP_ANDR_INKMN_PRMR_INKMSTNCMPNNT] ( [KP_ANDR_INKMN_PRMR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [ANDER_INKOMEN_ID] INT, [PRIMAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [KP_BSLG_OP_INKMN_KSTNCMPNNT] ( [KP_BSLG_OP_INKMN_KSTNCMPNNT_ID] INT PRIMARY KEY, [BESLAG_OP_INKOMEN_ID] INT, [KOSTENCOMPONENT_ID] INT ); CREATE TABLE [KOSTENCOMPONENT] ( [KOSTENCOMPONENT_ID] INT PRIMARY KEY, [BEDRAG] DECIMAL(10,2) ); CREATE TABLE [ANDER_INKOMEN] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY, [BESCHRIJVING_ANDER_INKOMEN] VARCHAR(255), [CATEGORIE] VARCHAR(255) ); CREATE TABLE [BETAALD_WERK] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY, [ARBEIDSCONTRACT] BIT, [BEGINDATUM_CONTRACT] DATE, [BETAALD_WERK_HEEFT_DERTIENDE_MAAND_EINDEJAARSUITKERING_INKOMSTENCOMPONENT_ID] INT, [BETAALD_WERK_HEEFT_HEFFINGSKORTING_INKOMSTENCOMPONENT_ID] INT, [BETAALD_WERK_HEEFT_LOONBESLAG_INKOMSTENCOMPONENT_ID] INT, [BETAALD_WERK_HEEFT_MAALTIJDVERGOEDING_INKOMSTENCOMPONENT_ID] INT, [BETAALD_WERK_HEEFT_ONKOSTENVERGOEDING_INKOMSTENCOMPONENT_ID] INT, [BETAALD_WERK_HEEFT_REISKOSTENVERGOEDING_INKOMSTENCOMPONENT_ID] INT, [BETAALD_WERK_HEEFT_VAKANTIEGELD_INKOMSTENCOMPONENT_ID] INT, [EINDDATUM_CONTRACT] DATE, [INKOMSTENSOORT_BETAALD_WERK] VARCHAR(255), [INKOMSTEN_UIT_IKB_REGELING] BIT, [LOONDIENST] BIT, [LOONHEFFINGSNUMMER] VARCHAR(255), [PERIODICITEIT_UITBETALING_LOON] VARCHAR(255), [SOORT_CONTRACT] VARCHAR(255), [URENVERMINDERING] VARCHAR(255) ); CREATE TABLE [KP_INKMSTNVRMNDRNG_SCNDR_INKMSTNCMPNNT] ( [KP_INKMSTNVRMNDRNG_SCNDR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [INKOMSTENVERMINDERING_ID] INT, [SECUNDAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [KP_MLTJDVRGDNG_VRGDNG] ( [KP_MLTJDVRGDNG_VRGDNG_ID] INT PRIMARY KEY, [MAALTIJDVERGOEDING_ID] INT, [VERGOEDING_ID] INT ); CREATE TABLE [KP_VRGDNG_SCNDR_INKMSTNCMPNNT] ( [KP_VRGDNG_SCNDR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [VERGOEDING_ID] INT, [SECUNDAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [ALIMENTATIE] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY, [BEDRAG_AAN_ANDERE_REKENINGEN] DECIMAL(10,2), [BEDRAG_IN_CONVENANT] DECIMAL(10,2), [BIJDRAGEEXPARTNERANDEREREKENINGEN] BIT, [INKOMSTENSOORT_ALIMENTATIE] VARCHAR(255), [JUISTE_BEDRAG_BETAALD_DOOR_EX_PARTNER] DECIMAL(10,2), [LBIO_INGESCHAKELD] BIT ); CREATE TABLE [KP_DRTND_MND_ENDJRSTKRNG_SCNDR_INKMSTNCMPNNT] ( [KP_DRTND_MND_ENDJRSTKRNG_SCNDR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [DERTIENDE_MAAND_EINDEJAARSUITKERING_ID] INT, [SECUNDAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [KP_EGN_BDRJF_PRMR_INKMSTNCMPNNT] ( [KP_EGN_BDRJF_PRMR_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [EIGEN_BEDRIJF_ID] INT, [PRIMAIR_INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [ONKOSTENVERGOEDING] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [HEFFINGSKORTING] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY, [ALGEMENE_HEFFINGSKORTING] BIT, [INKOMENSAFHANKELIJKE_COMBINATIEKORTING] BIT ); CREATE TABLE [LOONBESLAG] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [REISKOSTEN_NAAR_HET_WERK_] ( [KOSTENCOMPONENT_ID] INT PRIMARY KEY, [SOORT] VARCHAR(255) ); CREATE TABLE [VAKANTIEGELD] ( [INKOMSTENCOMPONENT_ID] INT PRIMARY KEY ); CREATE TABLE [VRIJLATING_INKOMSTEN] ( [VRIJLATING_INKOMSTEN_ID] INT PRIMARY KEY, [DOELGROEP] VARCHAR(255), [MEDISCH] BIT, [PERIODE_EINDDATUM] DATE, [PERIODE_STARTDATUM] DATE, [SOORT_VRIJLATING] VARCHAR(255), [VRIJGELATEN_BEDRAG] DECIMAL(10,2) ); CREATE TABLE [KP_PRMR_INKMSTNCMPNNT_INKMSTNCMPNNT] ( [KP_PRMR_INKMSTNCMPNNT_INKMSTNCMPNNT_ID] INT PRIMARY KEY, [PRIMAIR_INKOMSTENCOMPONENT_ID] INT, [INKOMSTENCOMPONENT_ID] INT ); CREATE TABLE [KP_ONKSTNVRGDNG_VRGDNG] ( [KP_ONKSTNVRGDNG_VRGDNG_ID] INT PRIMARY KEY, [ONKOSTENVERGOEDING_ID] INT, [VERGOEDING_ID] INT ); CREATE TABLE [KP_RSKSTNVRGDNG_VRGDNG] ( [KP_RSKSTNVRGDNG_VRGDNG_ID] INT PRIMARY KEY, [REISKOSTENVERGOEDING_ID] INT, [VERGOEDING_ID] INT ); CREATE TABLE [DRAAGKRACHTREGIME] ( [DRAAGKRACHTREGIME_ID] INT PRIMARY KEY, [INITIELE_DRAAGKRACHT] VARCHAR(255), [NAAM] VARCHAR(255), [PEILDATUM] DATE, [RESTERENDE_DRAAGKRACHT] VARCHAR(255) ); ALTER TABLE [ALIMENTATIE] ADD CONSTRAINT FK_ALIMENTATIE_GEN_PRIMAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to PRIMAIR_INKOMSTENCOMPONENT ALTER TABLE [ANDER_INKOMEN] ADD CONSTRAINT FK_ANDER_INKOMEN_GEN_PRIMAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to PRIMAIR_INKOMSTENCOMPONENT ALTER TABLE [BESLAG_OP_INKOMEN] ADD CONSTRAINT FK_BESLAG_OP_INKOMEN_GEN_KOSTENCOMPONENT FOREIGN KEY ([KOSTENCOMPONENT_ID]) REFERENCES [KOSTENCOMPONENT] ([KOSTENCOMPONENT_ID]); -- Generalization to KOSTENCOMPONENT ALTER TABLE [BETAALD_WERK] ADD CONSTRAINT FK_BETAALD_WERK_GEN_PRIMAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to PRIMAIR_INKOMSTENCOMPONENT ALTER TABLE [DERTIENDE_MAAND_EINDEJAARSUITKERING] ADD CONSTRAINT FK_DERTIENDE_MAAND_EINDEJAARSUITKERING_GEN_SECUNDAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [SECUNDAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to SECUNDAIR_INKOMSTENCOMPONENT ALTER TABLE [EIGEN_BEDRIJF] ADD CONSTRAINT FK_EIGEN_BEDRIJF_GEN_PRIMAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to PRIMAIR_INKOMSTENCOMPONENT ALTER TABLE [EIGEN_BIJDRAGE] ADD CONSTRAINT FK_EIGEN_BIJDRAGE_GEN_KOSTENCOMPONENT FOREIGN KEY ([KOSTENCOMPONENT_ID]) REFERENCES [KOSTENCOMPONENT] ([KOSTENCOMPONENT_ID]); -- Generalization to KOSTENCOMPONENT ALTER TABLE [HEFFINGSKORTING] ADD CONSTRAINT FK_HEFFINGSKORTING_GEN_SECUNDAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [SECUNDAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to SECUNDAIR_INKOMSTENCOMPONENT ALTER TABLE [HOBBY] ADD CONSTRAINT FK_HOBBY_GEN_PRIMAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to PRIMAIR_INKOMSTENCOMPONENT ALTER TABLE [INKOMSTENVERMINDERING] ADD CONSTRAINT FK_INKOMSTENVERMINDERING_GEN_SECUNDAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [SECUNDAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to SECUNDAIR_INKOMSTENCOMPONENT ALTER TABLE [LOONBESLAG] ADD CONSTRAINT FK_LOONBESLAG_GEN_INKOMSTENVERMINDERING FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENVERMINDERING] ([INKOMSTENCOMPONENT_ID]); -- Generalization to INKOMSTENVERMINDERING ALTER TABLE [MAALTIJDVERGOEDING] ADD CONSTRAINT FK_MAALTIJDVERGOEDING_GEN_VERGOEDING FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [VERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- Generalization to VERGOEDING ALTER TABLE [ONKOSTENVERGOEDING] ADD CONSTRAINT FK_ONKOSTENVERGOEDING_GEN_VERGOEDING FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [VERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- Generalization to VERGOEDING ALTER TABLE [PENSIOEN] ADD CONSTRAINT FK_PENSIOEN_GEN_PRIMAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to PRIMAIR_INKOMSTENCOMPONENT ALTER TABLE [PRIMAIR_INKOMSTENCOMPONENT] ADD CONSTRAINT FK_PRIMAIR_INKOMSTENCOMPONENT_GEN_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to INKOMSTENCOMPONENT ALTER TABLE [REISKOSTEN_NAAR_HET_WERK_] ADD CONSTRAINT FK_REISKOSTEN_NAAR_HET_WERK__GEN_KOSTENCOMPONENT FOREIGN KEY ([KOSTENCOMPONENT_ID]) REFERENCES [KOSTENCOMPONENT] ([KOSTENCOMPONENT_ID]); -- Generalization to KOSTENCOMPONENT ALTER TABLE [REISKOSTENVERGOEDING] ADD CONSTRAINT FK_REISKOSTENVERGOEDING_GEN_VERGOEDING FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [VERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- Generalization to VERGOEDING ALTER TABLE [SECUNDAIR_INKOMSTENCOMPONENT] ADD CONSTRAINT FK_SECUNDAIR_INKOMSTENCOMPONENT_GEN_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to INKOMSTENCOMPONENT ALTER TABLE [STAGE] ADD CONSTRAINT FK_STAGE_GEN_PRIMAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to PRIMAIR_INKOMSTENCOMPONENT ALTER TABLE [STUDIEFINANCIERING] ADD CONSTRAINT FK_STUDIEFINANCIERING_GEN_PRIMAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to PRIMAIR_INKOMSTENCOMPONENT ALTER TABLE [TE_BETALEN_ALIMENTATIE] ADD CONSTRAINT FK_TE_BETALEN_ALIMENTATIE_GEN_KOSTENCOMPONENT FOREIGN KEY ([KOSTENCOMPONENT_ID]) REFERENCES [KOSTENCOMPONENT] ([KOSTENCOMPONENT_ID]); -- Generalization to KOSTENCOMPONENT ALTER TABLE [UITKERING] ADD CONSTRAINT FK_UITKERING_GEN_PRIMAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to PRIMAIR_INKOMSTENCOMPONENT ALTER TABLE [VAKANTIEGELD] ADD CONSTRAINT FK_VAKANTIEGELD_GEN_SECUNDAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [SECUNDAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to SECUNDAIR_INKOMSTENCOMPONENT ALTER TABLE [VERGOEDING] ADD CONSTRAINT FK_VERGOEDING_GEN_SECUNDAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [SECUNDAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- Generalization to SECUNDAIR_INKOMSTENCOMPONENT ALTER TABLE [VERGOEDING_IN_NATURA] ADD CONSTRAINT FK_VERGOEDING_IN_NATURA_GEN_VERGOEDING FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [VERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- Generalization to VERGOEDING ALTER TABLE [VERLAGING_DOOR_BOETE] ADD CONSTRAINT FK_VERLAGING_DOOR_BOETE_GEN_INKOMSTENVERMINDERING FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENVERMINDERING] ([INKOMSTENCOMPONENT_ID]); -- Generalization to INKOMSTENVERMINDERING ALTER TABLE [VERLAGING_DOOR_MAATREGEL] ADD CONSTRAINT FK_VERLAGING_DOOR_MAATREGEL_GEN_INKOMSTENVERMINDERING FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENVERMINDERING] ([INKOMSTENCOMPONENT_ID]); -- Generalization to INKOMSTENVERMINDERING ALTER TABLE [KP_VRLGNG_DR_MTRGL_INKMSTNVRMNDRNG] ADD CONSTRAINT FK_KP_VRLGNG_DR_MTRGL_INKMSTNVRMNDRNG_1 FOREIGN KEY ([VERLAGING_DOOR_MAATREGEL_ID]) REFERENCES [VERLAGING_DOOR_MAATREGEL] ([INKOMSTENCOMPONENT_ID]); -- VERLAGING_DOOR_MAATREGEL (many-to-many junction, Connector_ID: 872) ALTER TABLE [KP_VRLGNG_DR_MTRGL_INKMSTNVRMNDRNG] ADD CONSTRAINT FK_KP_VRLGNG_DR_MTRGL_INKMSTNVRMNDRNG_2 FOREIGN KEY ([INKOMSTENVERMINDERING_ID]) REFERENCES [INKOMSTENVERMINDERING] ([INKOMSTENCOMPONENT_ID]); -- INKOMSTENVERMINDERING (many-to-many junction, Connector_ID: 872) ALTER TABLE [KP_VRLGNG_DR_BT_INKMSTNVRMNDRNG] ADD CONSTRAINT FK_KP_VRLGNG_DR_BT_INKMSTNVRMNDRNG_1 FOREIGN KEY ([VERLAGING_DOOR_BOETE_ID]) REFERENCES [VERLAGING_DOOR_BOETE] ([INKOMSTENCOMPONENT_ID]); -- VERLAGING_DOOR_BOETE (many-to-many junction, Connector_ID: 873) ALTER TABLE [KP_VRLGNG_DR_BT_INKMSTNVRMNDRNG] ADD CONSTRAINT FK_KP_VRLGNG_DR_BT_INKMSTNVRMNDRNG_2 FOREIGN KEY ([INKOMSTENVERMINDERING_ID]) REFERENCES [INKOMSTENVERMINDERING] ([INKOMSTENCOMPONENT_ID]); -- INKOMSTENVERMINDERING (many-to-many junction, Connector_ID: 873) ALTER TABLE [KP_VRGDNG_IN_NTR_VRGDNG] ADD CONSTRAINT FK_KP_VRGDNG_IN_NTR_VRGDNG_1 FOREIGN KEY ([VERGOEDING_IN_NATURA_ID]) REFERENCES [VERGOEDING_IN_NATURA] ([INKOMSTENCOMPONENT_ID]); -- VERGOEDING_IN_NATURA (many-to-many junction, Connector_ID: 874) ALTER TABLE [KP_VRGDNG_IN_NTR_VRGDNG] ADD CONSTRAINT FK_KP_VRGDNG_IN_NTR_VRGDNG_2 FOREIGN KEY ([VERGOEDING_ID]) REFERENCES [VERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- VERGOEDING (many-to-many junction, Connector_ID: 874) ALTER TABLE [KP_VRGDNG_SCNDR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_VRGDNG_SCNDR_INKMSTNCMPNNT_1 FOREIGN KEY ([VERGOEDING_ID]) REFERENCES [VERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- VERGOEDING (many-to-many junction, Connector_ID: 875) ALTER TABLE [KP_VRGDNG_SCNDR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_VRGDNG_SCNDR_INKMSTNCMPNNT_2 FOREIGN KEY ([SECUNDAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [SECUNDAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- SECUNDAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 875) ALTER TABLE [KP_VKNTGLD_SCNDR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_VKNTGLD_SCNDR_INKMSTNCMPNNT_1 FOREIGN KEY ([VAKANTIEGELD_ID]) REFERENCES [VAKANTIEGELD] ([INKOMSTENCOMPONENT_ID]); -- VAKANTIEGELD (many-to-many junction, Connector_ID: 876) ALTER TABLE [KP_VKNTGLD_SCNDR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_VKNTGLD_SCNDR_INKMSTNCMPNNT_2 FOREIGN KEY ([SECUNDAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [SECUNDAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- SECUNDAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 876) ALTER TABLE [KP_UTKRNG_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_UTKRNG_PRMR_INKMSTNCMPNNT_1 FOREIGN KEY ([UITKERING_ID]) REFERENCES [UITKERING] ([INKOMSTENCOMPONENT_ID]); -- UITKERING (many-to-many junction, Connector_ID: 880) ALTER TABLE [KP_UTKRNG_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_UTKRNG_PRMR_INKMSTNCMPNNT_2 FOREIGN KEY ([PRIMAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PRIMAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 880) ALTER TABLE [KP_TE_BTLN_ALMNTT_KSTNCMPNNT] ADD CONSTRAINT FK_KP_TE_BTLN_ALMNTT_KSTNCMPNNT_1 FOREIGN KEY ([TE_BETALEN_ALIMENTATIE_ID]) REFERENCES [TE_BETALEN_ALIMENTATIE] ([KOSTENCOMPONENT_ID]); -- TE_BETALEN_ALIMENTATIE (many-to-many junction, Connector_ID: 881) ALTER TABLE [KP_TE_BTLN_ALMNTT_KSTNCMPNNT] ADD CONSTRAINT FK_KP_TE_BTLN_ALMNTT_KSTNCMPNNT_2 FOREIGN KEY ([KOSTENCOMPONENT_ID]) REFERENCES [KOSTENCOMPONENT] ([KOSTENCOMPONENT_ID]); -- KOSTENCOMPONENT (many-to-many junction, Connector_ID: 881) ALTER TABLE [KP_STDFNNCRNG_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_STDFNNCRNG_PRMR_INKMSTNCMPNNT_1 FOREIGN KEY ([STUDIEFINANCIERING_ID]) REFERENCES [STUDIEFINANCIERING] ([INKOMSTENCOMPONENT_ID]); -- STUDIEFINANCIERING (many-to-many junction, Connector_ID: 882) ALTER TABLE [KP_STDFNNCRNG_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_STDFNNCRNG_PRMR_INKMSTNCMPNNT_2 FOREIGN KEY ([PRIMAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PRIMAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 882) ALTER TABLE [KP_STG_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_STG_PRMR_INKMSTNCMPNNT_1 FOREIGN KEY ([STAGE_ID]) REFERENCES [STAGE] ([INKOMSTENCOMPONENT_ID]); -- STAGE (many-to-many junction, Connector_ID: 884) ALTER TABLE [KP_STG_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_STG_PRMR_INKMSTNCMPNNT_2 FOREIGN KEY ([PRIMAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PRIMAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 884) ALTER TABLE [KP_SCNDR_INKMSTNCMPNNT_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_SCNDR_INKMSTNCMPNNT_INKMSTNCMPNNT_1 FOREIGN KEY ([SECUNDAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [SECUNDAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- SECUNDAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 885) ALTER TABLE [KP_SCNDR_INKMSTNCMPNNT_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_SCNDR_INKMSTNCMPNNT_INKMSTNCMPNNT_2 FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 885) ALTER TABLE [KP_RSKSTNVRGDNG_VRGDNG] ADD CONSTRAINT FK_KP_RSKSTNVRGDNG_VRGDNG_1 FOREIGN KEY ([REISKOSTENVERGOEDING_ID]) REFERENCES [REISKOSTENVERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- REISKOSTENVERGOEDING (many-to-many junction, Connector_ID: 887) ALTER TABLE [KP_RSKSTNVRGDNG_VRGDNG] ADD CONSTRAINT FK_KP_RSKSTNVRGDNG_VRGDNG_2 FOREIGN KEY ([VERGOEDING_ID]) REFERENCES [VERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- VERGOEDING (many-to-many junction, Connector_ID: 887) ALTER TABLE [KP_RSKSTN_NR_HET_WRK__KSTNCMPNNT] ADD CONSTRAINT FK_KP_RSKSTN_NR_HET_WRK__KSTNCMPNNT_1 FOREIGN KEY ([REISKOSTEN_NAAR_HET_WERK__ID]) REFERENCES [REISKOSTEN_NAAR_HET_WERK_] ([KOSTENCOMPONENT_ID]); -- REISKOSTEN_NAAR_HET_WERK_ (many-to-many junction, Connector_ID: 888) ALTER TABLE [KP_RSKSTN_NR_HET_WRK__KSTNCMPNNT] ADD CONSTRAINT FK_KP_RSKSTN_NR_HET_WRK__KSTNCMPNNT_2 FOREIGN KEY ([KOSTENCOMPONENT_ID]) REFERENCES [KOSTENCOMPONENT] ([KOSTENCOMPONENT_ID]); -- KOSTENCOMPONENT (many-to-many junction, Connector_ID: 888) ALTER TABLE [KP_PRMR_INKMSTNCMPNNT_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_PRMR_INKMSTNCMPNNT_INKMSTNCMPNNT_1 FOREIGN KEY ([PRIMAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PRIMAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 889) ALTER TABLE [KP_PRMR_INKMSTNCMPNNT_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_PRMR_INKMSTNCMPNNT_INKMSTNCMPNNT_2 FOREIGN KEY ([INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 889) ALTER TABLE [KP_PNSN_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_PNSN_PRMR_INKMSTNCMPNNT_1 FOREIGN KEY ([PENSIOEN_ID]) REFERENCES [PENSIOEN] ([INKOMSTENCOMPONENT_ID]); -- PENSIOEN (many-to-many junction, Connector_ID: 891) ALTER TABLE [KP_PNSN_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_PNSN_PRMR_INKMSTNCMPNNT_2 FOREIGN KEY ([PRIMAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PRIMAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 891) ALTER TABLE [KP_ONKSTNVRGDNG_VRGDNG] ADD CONSTRAINT FK_KP_ONKSTNVRGDNG_VRGDNG_1 FOREIGN KEY ([ONKOSTENVERGOEDING_ID]) REFERENCES [ONKOSTENVERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- ONKOSTENVERGOEDING (many-to-many junction, Connector_ID: 893) ALTER TABLE [KP_ONKSTNVRGDNG_VRGDNG] ADD CONSTRAINT FK_KP_ONKSTNVRGDNG_VRGDNG_2 FOREIGN KEY ([VERGOEDING_ID]) REFERENCES [VERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- VERGOEDING (many-to-many junction, Connector_ID: 893) ALTER TABLE [KP_MLTJDVRGDNG_VRGDNG] ADD CONSTRAINT FK_KP_MLTJDVRGDNG_VRGDNG_1 FOREIGN KEY ([MAALTIJDVERGOEDING_ID]) REFERENCES [MAALTIJDVERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- MAALTIJDVERGOEDING (many-to-many junction, Connector_ID: 896) ALTER TABLE [KP_MLTJDVRGDNG_VRGDNG] ADD CONSTRAINT FK_KP_MLTJDVRGDNG_VRGDNG_2 FOREIGN KEY ([VERGOEDING_ID]) REFERENCES [VERGOEDING] ([INKOMSTENCOMPONENT_ID]); -- VERGOEDING (many-to-many junction, Connector_ID: 896) ALTER TABLE [KP_LNBSLG_INKMSTNVRMNDRNG] ADD CONSTRAINT FK_KP_LNBSLG_INKMSTNVRMNDRNG_1 FOREIGN KEY ([LOONBESLAG_ID]) REFERENCES [LOONBESLAG] ([INKOMSTENCOMPONENT_ID]); -- LOONBESLAG (many-to-many junction, Connector_ID: 899) ALTER TABLE [KP_LNBSLG_INKMSTNVRMNDRNG] ADD CONSTRAINT FK_KP_LNBSLG_INKMSTNVRMNDRNG_2 FOREIGN KEY ([INKOMSTENVERMINDERING_ID]) REFERENCES [INKOMSTENVERMINDERING] ([INKOMSTENCOMPONENT_ID]); -- INKOMSTENVERMINDERING (many-to-many junction, Connector_ID: 899) ALTER TABLE [KP_INKMSTNVRMNDRNG_SCNDR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_INKMSTNVRMNDRNG_SCNDR_INKMSTNCMPNNT_1 FOREIGN KEY ([INKOMSTENVERMINDERING_ID]) REFERENCES [INKOMSTENVERMINDERING] ([INKOMSTENCOMPONENT_ID]); -- INKOMSTENVERMINDERING (many-to-many junction, Connector_ID: 900) ALTER TABLE [KP_INKMSTNVRMNDRNG_SCNDR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_INKMSTNVRMNDRNG_SCNDR_INKMSTNCMPNNT_2 FOREIGN KEY ([SECUNDAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [SECUNDAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- SECUNDAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 900) ALTER TABLE [KP_HBBY_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_HBBY_PRMR_INKMSTNCMPNNT_1 FOREIGN KEY ([HOBBY_ID]) REFERENCES [HOBBY] ([INKOMSTENCOMPONENT_ID]); -- HOBBY (many-to-many junction, Connector_ID: 902) ALTER TABLE [KP_HBBY_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_HBBY_PRMR_INKMSTNCMPNNT_2 FOREIGN KEY ([PRIMAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PRIMAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 902) ALTER TABLE [KP_HFFNGSKRTNG_SCNDR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_HFFNGSKRTNG_SCNDR_INKMSTNCMPNNT_1 FOREIGN KEY ([HEFFINGSKORTING_ID]) REFERENCES [HEFFINGSKORTING] ([INKOMSTENCOMPONENT_ID]); -- HEFFINGSKORTING (many-to-many junction, Connector_ID: 903) ALTER TABLE [KP_HFFNGSKRTNG_SCNDR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_HFFNGSKRTNG_SCNDR_INKMSTNCMPNNT_2 FOREIGN KEY ([SECUNDAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [SECUNDAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- SECUNDAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 903) ALTER TABLE [KP_EGN_BJDRG_KSTNCMPNNT] ADD CONSTRAINT FK_KP_EGN_BJDRG_KSTNCMPNNT_1 FOREIGN KEY ([EIGEN_BIJDRAGE_ID]) REFERENCES [EIGEN_BIJDRAGE] ([KOSTENCOMPONENT_ID]); -- EIGEN_BIJDRAGE (many-to-many junction, Connector_ID: 904) ALTER TABLE [KP_EGN_BJDRG_KSTNCMPNNT] ADD CONSTRAINT FK_KP_EGN_BJDRG_KSTNCMPNNT_2 FOREIGN KEY ([KOSTENCOMPONENT_ID]) REFERENCES [KOSTENCOMPONENT] ([KOSTENCOMPONENT_ID]); -- KOSTENCOMPONENT (many-to-many junction, Connector_ID: 904) ALTER TABLE [KP_EGN_BDRJF_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_EGN_BDRJF_PRMR_INKMSTNCMPNNT_1 FOREIGN KEY ([EIGEN_BEDRIJF_ID]) REFERENCES [EIGEN_BEDRIJF] ([INKOMSTENCOMPONENT_ID]); -- EIGEN_BEDRIJF (many-to-many junction, Connector_ID: 905) ALTER TABLE [KP_EGN_BDRJF_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_EGN_BDRJF_PRMR_INKMSTNCMPNNT_2 FOREIGN KEY ([PRIMAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PRIMAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 905) ALTER TABLE [KP_DRTND_MND_ENDJRSTKRNG_SCNDR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_DRTND_MND_ENDJRSTKRNG_SCNDR_INKMSTNCMPNNT_1 FOREIGN KEY ([DERTIENDE_MAAND_EINDEJAARSUITKERING_ID]) REFERENCES [DERTIENDE_MAAND_EINDEJAARSUITKERING] ([INKOMSTENCOMPONENT_ID]); -- DERTIENDE_MAAND_EINDEJAARSUITKERING (many-to-many junction, Connector_ID: 907) ALTER TABLE [KP_DRTND_MND_ENDJRSTKRNG_SCNDR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_DRTND_MND_ENDJRSTKRNG_SCNDR_INKMSTNCMPNNT_2 FOREIGN KEY ([SECUNDAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [SECUNDAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- SECUNDAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 907) ALTER TABLE [KP_BTLD_WRK_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_BTLD_WRK_PRMR_INKMSTNCMPNNT_1 FOREIGN KEY ([BETAALD_WERK_ID]) REFERENCES [BETAALD_WERK] ([INKOMSTENCOMPONENT_ID]); -- BETAALD_WERK (many-to-many junction, Connector_ID: 915) ALTER TABLE [KP_BTLD_WRK_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_BTLD_WRK_PRMR_INKMSTNCMPNNT_2 FOREIGN KEY ([PRIMAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PRIMAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 915) ALTER TABLE [KP_BSLG_OP_INKMN_KSTNCMPNNT] ADD CONSTRAINT FK_KP_BSLG_OP_INKMN_KSTNCMPNNT_1 FOREIGN KEY ([BESLAG_OP_INKOMEN_ID]) REFERENCES [BESLAG_OP_INKOMEN] ([KOSTENCOMPONENT_ID]); -- BESLAG_OP_INKOMEN (many-to-many junction, Connector_ID: 916) ALTER TABLE [KP_BSLG_OP_INKMN_KSTNCMPNNT] ADD CONSTRAINT FK_KP_BSLG_OP_INKMN_KSTNCMPNNT_2 FOREIGN KEY ([KOSTENCOMPONENT_ID]) REFERENCES [KOSTENCOMPONENT] ([KOSTENCOMPONENT_ID]); -- KOSTENCOMPONENT (many-to-many junction, Connector_ID: 916) ALTER TABLE [KP_ANDR_INKMN_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_ANDR_INKMN_PRMR_INKMSTNCMPNNT_1 FOREIGN KEY ([ANDER_INKOMEN_ID]) REFERENCES [ANDER_INKOMEN] ([INKOMSTENCOMPONENT_ID]); -- ANDER_INKOMEN (many-to-many junction, Connector_ID: 917) ALTER TABLE [KP_ANDR_INKMN_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_ANDR_INKMN_PRMR_INKMSTNCMPNNT_2 FOREIGN KEY ([PRIMAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PRIMAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 917) ALTER TABLE [KP_ALMNTT_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_ALMNTT_PRMR_INKMSTNCMPNNT_1 FOREIGN KEY ([ALIMENTATIE_ID]) REFERENCES [ALIMENTATIE] ([INKOMSTENCOMPONENT_ID]); -- ALIMENTATIE (many-to-many junction, Connector_ID: 918) ALTER TABLE [KP_ALMNTT_PRMR_INKMSTNCMPNNT] ADD CONSTRAINT FK_KP_ALMNTT_PRMR_INKMSTNCMPNNT_2 FOREIGN KEY ([PRIMAIR_INKOMSTENCOMPONENT_ID]) REFERENCES [PRIMAIR_INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PRIMAIR_INKOMSTENCOMPONENT (many-to-many junction, Connector_ID: 918) ALTER TABLE [UITKERING] ADD CONSTRAINT FK_UITKERING_UITKERING_HEEFT_VERLAGING_DOOR_BOETE FOREIGN KEY ([UITKERING_HEEFT_VERLAGING_DOOR_BOETE_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- UITKERING_HEEFT_VERLAGING_DOOR_BOETE (0..* to 1..1, Connector_ID: 877) ALTER TABLE [UITKERING] ADD CONSTRAINT FK_UITKERING_UITKERING_HEEFT_VAKANTIEGELD FOREIGN KEY ([UITKERING_HEEFT_VAKANTIEGELD_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- UITKERING_HEEFT_VAKANTIEGELD (0..* to 1..1, Connector_ID: 878) ALTER TABLE [UITKERING] ADD CONSTRAINT FK_UITKERING_UITKERING_HEEFT_VERLAGING_DOOR_MAATREGEL FOREIGN KEY ([UITKERING_HEEFT_VERLAGING_DOOR_MAATREGEL_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- UITKERING_HEEFT_VERLAGING_DOOR_MAATREGEL (0..* to 1..1, Connector_ID: 879) ALTER TABLE [STAGE] ADD CONSTRAINT FK_STAGE_STAGE_HEEFT_VERGOEDING_IN_NATURA FOREIGN KEY ([STAGE_HEEFT_VERGOEDING_IN_NATURA_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- STAGE_HEEFT_VERGOEDING_IN_NATURA (0..* to 1..1, Connector_ID: 883) ALTER TABLE [STAGE] ADD CONSTRAINT FK_STAGE_STAGE_HEEFT_REISKOSTENVERGOEDING FOREIGN KEY ([STAGE_HEEFT_REISKOSTENVERGOEDING_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- STAGE_HEEFT_REISKOSTENVERGOEDING (0..* to 1..1, Connector_ID: 886) ALTER TABLE [PENSIOEN] ADD CONSTRAINT FK_PENSIOEN_PENSIOEN_HEEFT_VAKANTIEGELD FOREIGN KEY ([PENSIOEN_HEEFT_VAKANTIEGELD_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PENSIOEN_HEEFT_VAKANTIEGELD (0..* to 1..1, Connector_ID: 890) ALTER TABLE [STAGE] ADD CONSTRAINT FK_STAGE_STAGE_HEEFT_ONKOSTENVERGOEDING FOREIGN KEY ([STAGE_HEEFT_ONKOSTENVERGOEDING_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- STAGE_HEEFT_ONKOSTENVERGOEDING (0..* to 1..1, Connector_ID: 892) ALTER TABLE [ONDERHOUDSVERHOUDING] ADD CONSTRAINT FK_ONDERHOUDSVERHOUDING_ONDERHOUDSVERHOUDING_BEVAT_ONDERHOUDSPLICHT FOREIGN KEY ([ONDERHOUDSVERHOUDING_BEVAT_ONDERHOUDSPLICHT_ONDERHOUDSPLICHT_ID]) REFERENCES [ONDERHOUDSPLICHT] ([ONDERHOUDSPLICHT_ID]); -- ONDERHOUDSVERHOUDING_BEVAT_ONDERHOUDSPLICHT (0..* to 1..1, Connector_ID: 894) ALTER TABLE [STAGE] ADD CONSTRAINT FK_STAGE_STAGE_HEEFT_MAALTIJDVERGOEDING FOREIGN KEY ([STAGE_HEEFT_MAALTIJDVERGOEDING_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- STAGE_HEEFT_MAALTIJDVERGOEDING (0..* to 1..1, Connector_ID: 895) ALTER TABLE [UITKERING] ADD CONSTRAINT FK_UITKERING_UITKERING_HEEFT_LOONBESLAG FOREIGN KEY ([UITKERING_HEEFT_LOONBESLAG_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- UITKERING_HEEFT_LOONBESLAG (0..* to 1..1, Connector_ID: 897) ALTER TABLE [PENSIOEN] ADD CONSTRAINT FK_PENSIOEN_PENSIOEN_HEEFT_LOONBESLAG FOREIGN KEY ([PENSIOEN_HEEFT_LOONBESLAG_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- PENSIOEN_HEEFT_LOONBESLAG (0..* to 1..1, Connector_ID: 898) ALTER TABLE [INKOMSTENVERHOUDING] ADD CONSTRAINT FK_INKOMSTENVERHOUDING_INKOMSTENVERHOUDING_BEVAT_PRIMAIR_INKOMSTENCOMPONENT FOREIGN KEY ([INKOMSTENVERHOUDING_BEVAT_PRIMAIR_INKOMSTENCOMPONENT_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- INKOMSTENVERHOUDING_BEVAT_PRIMAIR_INKOMSTENCOMPONENT (1..* to 0..1, Connector_ID: 901) ALTER TABLE [DRAAGKRACHT] ADD CONSTRAINT FK_DRAAGKRACHT_DRAAGKRACHT_HEEFT_DRAAGKRACHTREGIME FOREIGN KEY ([DRAAGKRACHT_HEEFT_DRAAGKRACHTREGIME_DRAAGKRACHTREGIME_ID]) REFERENCES [DRAAGKRACHTREGIME] ([DRAAGKRACHTREGIME_ID]); -- DRAAGKRACHT_HEEFT_DRAAGKRACHTREGIME (1..* to 1..1, Connector_ID: 906) ALTER TABLE [BETAALD_WERK] ADD CONSTRAINT FK_BETAALD_WERK_BETAALD_WERK_HEEFT_MAALTIJDVERGOEDING FOREIGN KEY ([BETAALD_WERK_HEEFT_MAALTIJDVERGOEDING_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- BETAALD_WERK_HEEFT_MAALTIJDVERGOEDING (0..* to 1..1, Connector_ID: 908) ALTER TABLE [BETAALD_WERK] ADD CONSTRAINT FK_BETAALD_WERK_BETAALD_WERK_HEEFT_DERTIENDE_MAAND_EINDEJAARSUITKERING FOREIGN KEY ([BETAALD_WERK_HEEFT_DERTIENDE_MAAND_EINDEJAARSUITKERING_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- BETAALD_WERK_HEEFT_DERTIENDE_MAAND_EINDEJAARSUITKERING (0..* to 1..1, Connector_ID: 909) ALTER TABLE [BETAALD_WERK] ADD CONSTRAINT FK_BETAALD_WERK_BETAALD_WERK_HEEFT_REISKOSTENVERGOEDING FOREIGN KEY ([BETAALD_WERK_HEEFT_REISKOSTENVERGOEDING_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- BETAALD_WERK_HEEFT_REISKOSTENVERGOEDING (0..* to 1..1, Connector_ID: 910) ALTER TABLE [BETAALD_WERK] ADD CONSTRAINT FK_BETAALD_WERK_BETAALD_WERK_HEEFT_ONKOSTENVERGOEDING FOREIGN KEY ([BETAALD_WERK_HEEFT_ONKOSTENVERGOEDING_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- BETAALD_WERK_HEEFT_ONKOSTENVERGOEDING (0..* to 1..1, Connector_ID: 911) ALTER TABLE [BETAALD_WERK] ADD CONSTRAINT FK_BETAALD_WERK_BETAALD_WERK_HEEFT_LOONBESLAG FOREIGN KEY ([BETAALD_WERK_HEEFT_LOONBESLAG_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- BETAALD_WERK_HEEFT_LOONBESLAG (0..* to 1..1, Connector_ID: 912) ALTER TABLE [BETAALD_WERK] ADD CONSTRAINT FK_BETAALD_WERK_BETAALD_WERK_HEEFT_HEFFINGSKORTING FOREIGN KEY ([BETAALD_WERK_HEEFT_HEFFINGSKORTING_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- BETAALD_WERK_HEEFT_HEFFINGSKORTING (0..* to 1..1, Connector_ID: 913) ALTER TABLE [BETAALD_WERK] ADD CONSTRAINT FK_BETAALD_WERK_BETAALD_WERK_HEEFT_VAKANTIEGELD FOREIGN KEY ([BETAALD_WERK_HEEFT_VAKANTIEGELD_INKOMSTENCOMPONENT_ID]) REFERENCES [INKOMSTENCOMPONENT] ([INKOMSTENCOMPONENT_ID]); -- BETAALD_WERK_HEEFT_VAKANTIEGELD (0..* to 1..1, Connector_ID: 914)