 	FOREIGN KEY (ReferenceMaterialID) REFERENCES ReferenceMaterials (ReferenceMaterialID)
 	ON UPDATE NO ACTION ON DELETE NO ACTION;
 
+/* Add Foreign Key: fk_DataLoggerFiles_DataloggerProgramFiles */
+ALTER TABLE DataLoggerFiles ADD CONSTRAINT fk_DataLoggerFiles_DataloggerProgramFiles
+	FOREIGN KEY (ProgramID) REFERENCES DataloggerProgramFiles (ProgramID)
+	ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/* Add Foreign Key: fk_DataloggerFileColumns_DataLoggerFiles */
+ALTER TABLE DataloggerFileColumns ADD CONSTRAINT fk_DataloggerFileColumns_DataLoggerFiles
+	FOREIGN KEY (DataLoggerFileID) REFERENCES DataLoggerFiles (DataLoggerFileID)
+	ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/* Add Foreign Key: fk_DataloggerFileColumns_InstrumentOutputVariables */
+ALTER TABLE DataloggerFileColumns ADD CONSTRAINT fk_DataloggerFileColumns_InstrumentOutputVariables
+	FOREIGN KEY (InstrumentOutputVariableID) REFERENCES InstrumentOutputVariables (InstrumentOutputVariableID)
+	ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/* Add Foreign Key: fk_DataloggerFileColumns_RecordingUnits */
+ALTER TABLE DataloggerFileColumns ADD CONSTRAINT fk_DataloggerFileColumns_RecordingUnits
+	FOREIGN KEY (RecordingIntervalUnitsID) REFERENCES Units (UnitsID)
+	ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/* Add Foreign Key: fk_DataloggerFileColumns_Results */
+ALTER TABLE DataloggerFileColumns ADD CONSTRAINT fk_DataloggerFileColumns_Results
+	FOREIGN KEY (ResultID) REFERENCES Results (ResultID)
+	ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/* Add Foreign Key: fk_DataloggerFileColumns_ScanUnits */
+ALTER TABLE DataloggerFileColumns ADD CONSTRAINT fk_DataloggerFileColumns_ScanUnits
+	FOREIGN KEY (ScanIntervalUnitsID) REFERENCES Units (UnitsID)
+	ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+/* Add Foreign Key: fk_DataloggerProgramFiles_Affiliations */
+ALTER TABLE DataloggerProgramFiles ADD CONSTRAINT fk_DataloggerProgramFiles_Affiliations
+	FOREIGN KEY (AffiliationID) REFERENCES Affiliations (AffiliationID)
+	ON UPDATE NO ACTION ON DELETE NO ACTION;
+
 /* Add Foreign Key: fk_Equipment_EquipmentModels */
 ALTER TABLE Equipment ADD CONSTRAINT fk_Equipment_EquipmentModels
 	FOREIGN KEY (EquipmentModelID) REFERENCES EquipmentModels (EquipmentModelID)

fk_Sites_SpatialReferences may require an index on table: Sites, column: LatLonDatumID
fk_SpecimenTaxonomicClassifiers_Specimens may require an index on table: SpecimenTaxonomicClassifiers, column: SamplingFeatureID
fk_SpecimenTaxonomicClassifiers_TaxonomicClassifiers may require an index on table: SpecimenTaxonomicClassifiers, column: TaxonomicClassifierID
fk_DataLoggerFiles_DataloggerProgramFiles may require an index on table: DataLoggerFiles, column: ProgramID
fk_DataloggerProgramFiles_Affiliations may require an index on table: DataloggerProgramFiles, column: AffiliationID
fk_DeploymentMeasuredVariables_DataLoggerFiles may require an index on table: DeploymentMeasuredVariables, column: DataloggerFileID
fk_DeploymentMeasuredVariables_DeploymentActions may require an index on table: DeploymentMeasuredVariables, column: ActionID
fk_DeploymentMeasuredVariables_InstrumentOutputVariables may require an index on table: DeploymentMeasuredVariables, column: InstrumentOutputVariableID
fk_DeploymentMeasuredVariables_RI_Units may require an index on table: DeploymentMeasuredVariables, column: RecordingIntervalUnitsID
fk_DeploymentMeasuredVariables_SI_Units may require an index on table: DeploymentMeasuredVariables, column: ScanIntervalUnitsID
-----------------------------------------------------------
*/


	FOREIGN KEY (EquipmentOwnerID) REFERENCES People (PersonID)
	ON UPDATE NO ACTION ON DELETE NO ACTION;

/* Add Foreign Key: fk_EquipmentModels_Organizations */
ALTER TABLE EquipmentModels ADD CONSTRAINT fk_EquipmentModels_Organizations
	FOREIGN KEY (ModelManufacturerID) REFERENCES Organizations (OrganizationID)
	ON UPDATE NO ACTION ON DELETE NO ACTION;

/* Add Foreign Key: fk_EquipmentActions_Actions */
ALTER TABLE EquipmentUsed ADD CONSTRAINT fk_EquipmentActions_Actions
	FOREIGN KEY (ActionID) REFERENCES Actions (ActionID)
	ON UPDATE NO ACTION ON DELETE NO ACTION;

/* Add Foreign Key: fk_EquipmentActions_Equipment */
ALTER TABLE EquipmentUsed ADD CONSTRAINT fk_EquipmentActions_Equipment
	FOREIGN KEY (EquipmentID) REFERENCES Equipment (EquipmentID)
	ON UPDATE NO ACTION ON DELETE NO ACTION;

/* Add Foreign Key: fk_InstrumentOutputVariables_EquipmentModels */
ALTER TABLE InstrumentOutputVariables ADD CONSTRAINT fk_InstrumentOutputVariables_EquipmentModels
	FOREIGN KEY (ModelID) REFERENCES EquipmentModels (EquipmentModelID)
