-- Primary keys
alter table datastaging.BarrierComputation add primary key(BarrierComputationID);
alter table datastaging.BarrierComputationVersion add primary key(BarrierComputationVersionID);
alter table datastaging.Nace add primary key(NaceID);
alter table datastaging.Country add primary key(CountryID);
alter table datastaging.Date add primary key(DateID);
alter table datastaging.DisabilityGroup add primary key(DisabilityGroupID);
alter table datastaging.DisabilityGroupRelevance_Fcui add primary key(DisabilityGroupID, BarrierComputationID);
alter table datastaging.Hour add primary key(HourID);
alter table datastaging.Language add primary key(LanguageID);
alter table datastaging.LanguageFamily add primary key(LanguageFamilyID);
alter table datastaging.LanguageUsage add primary key(LanguageID, ResourceVersionID);
alter table datastaging.Minute add primary key(MinuteID);
alter table datastaging.Month add primary key(MonthID);
alter table datastaging.NutsLevel1 add primary key(NutsLevel1ID);
alter table datastaging.NutsLevel2 add primary key(NutsLevel2ID);
alter table datastaging.NutsLevel3 add primary key(NutsLevel3ID);
alter table datastaging.OperatingSystemFamily add primary key(OperatingSystemFamilyID);
alter table datastaging.Resource add primary key(ResourceID);
alter table datastaging.ResourceVersion add primary key(ResourceVersionID);
alter table datastaging.Quarter add primary key(QuarterID);
alter table datastaging.Result add primary key(ResultID);
alter table datastaging.ResultType add primary key(ResultTypeID);
alter table datastaging.Scenario add primary key(ScenarioID);
alter table datastaging.ScenarioCoverage add primary key(ScenarioID, ResourceVersionID);
alter table datastaging.SecondLevelDomain add primary key(SecondLevelDomainID);
alter table datastaging.Server add primary key(ServerID);
alter table datastaging.Site add primary key(SiteID);
alter table datastaging.Subject add primary key(SubjectID);
alter table datastaging.TestResult add primary key(SubjectID, MinuteID, DateID, ResultID, BarrierComputationVersionID, ETLRunID, TestRunID);
alter table datastaging.TestRun add primary key(TestRunID);
alter table datastaging.TopLevelDomain add primary key(TopLevelDomainID);
alter table datastaging.UWEMTest add primary key(UWEMTestID);
alter table datastaging.UWEMTestType add primary key(UWEMTestTypeID);
alter table datastaging.WCAGMajor add primary key(WCAGMajorID);
alter table datastaging.WCAGMinor add primary key(WCAGMinorID);
alter table datastaging.WCAGType add primary key(WCAGTypeID);
alter table datastaging.Week add primary key(WeekID);
alter table datastaging.Year add primary key(YearID);
alter table datastaging.MediaType add primary key(MediaTypeID);
alter table datastaging.MediaTypeUsage add primary key(MediaTypeID, ResourceVersionID);
alter table datastaging.MimeType add primary key(MimeTypeID);
alter table datastaging.InclusionType add primary key(InclusionTypeID);
alter table datastaging.Technique add primary key(TechniqueID);
alter table datastaging.TestMode add primary key(TestModeID);
alter table datastaging.ETLRun add primary key(ETLRunID);
alter table datastaging.ETLVersion add primary key(ETLVersionID);
alter table datastaging.TechnologyFinding add primary key(MimeTypeID, InclusionTypeID, DateID, MinuteID, SubjectID);

-- Foreign keys
alter table datastaging.BarrierComputationVersion add foreign key(BarrierComputationID) references datastaging.BarrierComputation(BarrierComputationID);
alter table datastaging.Date add foreign key(MonthID) references datastaging.Month(MonthID);
alter table datastaging.Date add foreign key(WeekID) references datastaging.Week(WeekID);
alter table datastaging.DisabilityGroupRelevance_Fcui add foreign key(DisabilityGroupID) references datastaging.DisabilityGroup(DisabilityGroupID);
alter table datastaging.DisabilityGroupRelevance_Fcui add foreign key(BarrierComputationID) references datastaging.BarrierComputation(BarrierComputationID);
alter table datastaging.Language add foreign key(LanguageFamilyID) references datastaging.LanguageFamily(LanguageFamilyID);
alter table datastaging.Minute add foreign key(HourID) references datastaging.Hour(HourID);
alter table datastaging.Month add foreign key(QuarterID) references datastaging.Quarter(QuarterID);
alter table datastaging.NutsLevel1 add foreign key(CountryID) references datastaging.Country(CountryID);
alter table datastaging.NutsLevel2 add foreign key(NutsLevel1ID) references datastaging.NutsLevel1(NutsLevel1ID);
alter table datastaging.NutsLevel3 add foreign key(NutsLevel2ID) references datastaging.NutsLevel2(NutsLevel2ID);
alter table datastaging.Resource add foreign key(SiteID) references datastaging.Site(SiteID);
alter table datastaging.ResourceVersion add foreign key(DateID) references datastaging.Date(DateID);
alter table datastaging.ResourceVersion add foreign key(MinuteID) references datastaging.Minute(MinuteID);
alter table datastaging.ResourceVersion add foreign key(ResourceID) references datastaging.Resource(ResourceID);
alter table datastaging.ResourceVersion add foreign key(ServerID) references datastaging.Server(ServerID);
alter table datastaging.ResourceVersion add foreign key(TestRunID) references datastaging.TestRun(TestRunID);
alter table datastaging.Quarter add foreign key(YearID) references datastaging.Year(YearID);
alter table datastaging.Result add foreign key(ResultTypeID) references datastaging.ResultType(ResultTypeID);
alter table datastaging.ScenarioCoverage add foreign key(ScenarioID) references datastaging.Scenario(ScenarioID);
alter table datastaging.ScenarioCoverage add foreign key(ResourceVersionID) references datastaging.ResourceVersion(ResourceVersionID);
alter table datastaging.SecondLevelDomain add foreign key(TopLevelDomainID) references datastaging.TopLevelDomain(TopLevelDomainID);
alter table datastaging.Server add foreign key(OperatingSystemFamilyID) references datastaging.OperatingSystemFamily(OperatingSystemFamilyID);
alter table datastaging.Site add foreign key(NutsLevel3ID) references datastaging.NutsLevel3(NutsLevel3ID);
alter table datastaging.Subject add foreign key(ResourceVersionID) references datastaging.ResourceVersion(ResourceVersionID);
alter table datastaging.TestResult add foreign key(DateID) references datastaging.Date(DateID);
alter table datastaging.TestResult add foreign key(MinuteID) references datastaging.Minute(MinuteID);
alter table datastaging.TestResult add foreign key(ResultID) references datastaging.Result(ResultID);
alter table datastaging.TestResult add foreign key(SubjectID) references datastaging.Subject(SubjectID);
alter table datastaging.TestResult add foreign key(BarrierComputationVersionID) references datastaging.BarrierComputationVersion(BarrierComputationVersionID);
alter table datastaging.TestResult add foreign key(ETLRunID) references datastaging.ETLRun(ETLRunID);
alter table datastaging.TestResult add foreign key(TestRunID) references datastaging.TestRun(TestRunID);
alter table datastaging.UWEMTest add foreign key(UWEMTestTypeID) references datastaging.UWEMTestType(UWEMTestTypeID);
alter table datastaging.WCAGMajor add foreign key(WCAGTypeID) references datastaging.WCAGType(WCAGTypeID);
alter table datastaging.WCAGMinor add foreign key(WCAGMajorID) references datastaging.WCAGMajor(WCAGMajorID);
alter table datastaging.Week add foreign key(YearID) references datastaging.Year(YearID);
alter table datastaging.Scenario add foreign key(TestRunID) references datastaging.TestRun(TestRunID);
alter table datastaging.MediaTypeUsage add foreign key(ResourceVersionID) references datastaging.ResourceVersion(ResourceVersionID);
alter table datastaging.MediaTypeUsage add foreign key(MediaTypeID) references datastaging.MediaType(MediaTypeID);
alter table datastaging.LanguageUsage add foreign key(ResourceVersionID) references datastaging.ResourceVersion(ResourceVersionID);
alter table datastaging.LanguageUsage add foreign key(LanguageID) references datastaging.Language(LanguageID);
alter table datastaging.Site add foreign key(SecondLevelDomainID) references datastaging.SecondLevelDomain(SecondLevelDomainID);
alter table datastaging.Resource add foreign key(SiteID) references datastaging.Site(SiteID);
alter table datastaging.Site add foreign key(NaceID) references datastaging.Nace(NaceID);
alter table datastaging.BarrierComputation add foreign key(TechniqueID) references datastaging.Technique(TechniqueID);
alter table datastaging.BarrierComputation add foreign key(TestModeID) references datastaging.TestMode(TestModeID);
alter table datastaging.UWEMTest add foreign key(BarrierComputationID) references datastaging.BarrierComputation(BarrierComputationID);
alter table datastaging.BarrierComputation add foreign key(WCAGMinorID) references datastaging.WCAGMinor(WCAGMinorID);
alter table datastaging.TechnologyFinding add foreign key(MimeTypeID) references datastaging.MimeType(MimeTypeID);
alter table datastaging.TechnologyFinding add foreign key(InclusionTypeID) references datastaging.InclusionType(InclusionTypeID);
alter table datastaging.TechnologyFinding add foreign key(DateID) references datastaging.Date(DateID);
alter table datastaging.TechnologyFinding add foreign key(MinuteID) references datastaging.Minute(MinuteID);
alter table datastaging.TechnologyFinding add foreign key(SubjectID) references datastaging.Subject(SubjectID);