-- Primary keys
alter table eiaodw.ETLRun_T add primary key(ETLRunID);
alter table eiaodw.MediaType_T add primary key(MediaTypeID);
alter table eiaodw.MimeType_T add primary key(MimeTypeID);
alter table eiaodw.InclusionType_T add primary key(InclusionTypeID);
alter table eiaodw.TechnologyFinding_T add primary key(SubjectID, MimeTypeID, InclusionTypeID, DateID, MinuteID, TestRunID);
alter table eiaodw.Date_T add primary key(DateID);
alter table eiaodw.DisabilityGroupRelevance_Fcui_T add primary key(DisabilityGroupID, BarrierComputationID);
alter table eiaodw.DisabilityGroup_T add primary key(DisabilityGroupID);
alter table eiaodw.Result_T add primary key(ResultID);
alter table eiaodw.ScenarioCoverage_T add primary key(ResourceVersionID, ScenarioID);
alter table eiaodw.Scenario_T add primary key(ScenarioID);
alter table eiaodw.Subject_T add primary key(SubjectID);
-- This order for TestResult_T to make C-WAM impl. more efficient
alter table eiaodw.TestResult_T add primary key(SubjectID, BarrierComputationVersionID, MinuteID, DateID, ResultID, ETLRunID, TestRunID, Probability); 
alter table eiaodw.Time_T add primary key(MinuteID);
alter table eiaodw.UWEMTest_T add primary key(UWEMTestID);
alter table eiaodw.BarrierComputationVersion_T add primary key(BarrierComputationVersionID);
alter table eiaodw.ResourceMediaTypeUsage_T add primary key(ResourceVersionID, MediaTypeID);
alter table eiaodw.ScenarioMediaTypeUsage_T add primary key(ScenarioID, MediaTypeID);
alter table eiaodw.Language_T add primary key(LanguageID);
alter table eiaodw.LanguageUsage_T add primary key(ResourceVersionID, LanguageID);

-- Foreign keys
alter table eiaodw.TestResult_T add foreign key(SubjectID) references eiaodw.Subject_T(SubjectID);
alter table eiaodw.TestResult_T add foreign key(MinuteID) references eiaodw.Time_T(MinuteID);
alter table eiaodw.TestResult_T add foreign key(DateID) references eiaodw.Date_T(DateID);
alter table eiaodw.TestResult_T add foreign key(BarrierComputationVersionID) references eiaodw.BarrierComputationVersion_T(BarrierComputationVersionID);
alter table eiaodw.TestResult_T add foreign key(ResultID) references eiaodw.Result_T(ResultID);
alter table eiaodw.TestResult_T add foreign key(ETLRunID) references eiaodw.ETLRun_T(ETLRunID);
alter table eiaodw.Subject_T add foreign key(LastModifiedDate) references eiaodw.Date_T(DateID);
alter table eiaodw.Subject_T add foreign key(LastModifiedTime) references eiaodw.Time_T(MinuteID);
--alter table eiaodw.ScenarioCoverage_T add foreign key(ResourceVersionID) references eiaodw.Subject_T(ResourceVersionID);
alter table eiaodw.ScenarioCoverage_T add foreign key(ScenarioID) references eiaodw.Scenario_T(ScenarioID);
alter table eiaodw.DisabilityGroupRelevance_Fcui_T add foreign key(DisabilityGroupID) references eiaodw.DisabilityGroup_T(DisabilityGroupID);
alter table eiaodw.ETLRun_T add foreign key(MinuteID) references eiaodw.Time_T(MinuteID);
alter table eiaodw.ETLRun_T add foreign key(DateID) references eiaodw.Date_T(DateID);
alter table eiaodw.TechnologyFinding_T add foreign key(SubjectID) references eiaodw.Subject_T(SubjectID);
alter table eiaodw.TechnologyFinding_T add foreign key(MimeTypeID) references eiaodw.MimeType_T(MimeTypeID);
alter table eiaodw.TechnologyFinding_T add foreign key(InclusionTypeID) references eiaodw.InclusionType_T(InclusionTypeID);
alter table eiaodw.TechnologyFinding_T add foreign key(MinuteID) references eiaodw.Time_T(MinuteID);
alter table eiaodw.TechnologyFinding_T add foreign key(DateID) references eiaodw.Date_T(DateID);
--alter table eiaodw.LanguageUsage_T add foreign key(ResourceVersionID) references eiaodw.Subject_T(ResourceVersionID); no unique on subject_t(ResourceVerisonID)
alter table eiaodw.LanguageUsage_T add foreign key(LanguageID) references eiaodw.Language_T(LanguageID);
--alter table eiaodw.ResourceMediaTypeUsage_T add foreign key(ResourceVersionID) references eiaodw.Subject_T(ResourceVersionID);
--alter table eiaodw.ScenarioMediaTypeUsage_T add foreign key(ScenarioID) references eiaodw.Subject_T(ScenarioID);
alter table eiaodw.ResourceMediaTypeUsage_T add foreign key(MediaTypeID) references eiaodw.MediaType_T(MediaTypeID);
alter table eiaodw.ScenarioMediaTypeUsage_T add foreign key(MediaTypeID) references eiaodw.MediaType_T(MediaTypeID);