 ) ENGINE=InnoDB;
 
 
-/******************** Add Table: CalibratedDeploymentVariables ************************/
-
-/* Build Table Structure */
-CREATE TABLE CalibratedDeploymentVariables
+/******************** Add Table: CalibrationActions ************************/
+
+/* Build Table Structure */
+CREATE TABLE CalibrationActions
+(
+	ActionID INTEGER NOT NULL,
+	CalibrationCheckValue FLOAT NULL,
+	InstrumentOutputVariableID INTEGER NOT NULL,
+	CalibrationEquation VARCHAR(255) NULL
+) ENGINE=InnoDB;
+
+/* Add Primary Key */
+ALTER TABLE CalibrationActions ADD CONSTRAINT pkCalibrationActions
+	PRIMARY KEY (ActionID);
+
+/* Add Comments */
+ALTER TABLE CalibrationActions COMMENT = 'Information about calibration Actions';
+
+
+/******************** Add Table: CalibrationReferenceEquipment ************************/
+
+/* Build Table Structure */
+CREATE TABLE CalibrationReferenceEquipment
 (
 	BridgeID INTEGER AUTO_INCREMENT PRIMARY KEY 
-		COMMENT 'Primary key identifier' NOT NULL,
+		COMMENT 'Primary key identifier ' NOT NULL,
 	ActionID INTEGER 
-		COMMENT 'Foreign key identifier of the calibration Action' NOT NULL,
-	DeploymentMeasuredVariableID INTEGER 
-		COMMENT 'Foreign key identifier of the DeploymentMeasuredVariable to which the calibration was applied' NOT NULL,
-	CalibrationCheckValue FLOAT 
-		COMMENT 'A numeric value for the DeploymentMeasuredVariable measued using the ReferenceMaterial prior to calibration' NULL
-) ENGINE=InnoDB;
-
-/* Add Comments */
-ALTER TABLE CalibratedDeploymentVariables COMMENT = 'Information about which deployment measured variable a calibration Action is associated with';
-
-
-/******************** Add Table: CalibrationEquations ************************/
-
-/* Build Table Structure */
-CREATE TABLE CalibrationEquations
-(
-	CalibrationEquationID INTEGER AUTO_INCREMENT PRIMARY KEY 
-		COMMENT 'Primary key identifier' NOT NULL,
-	ActionID INTEGER 
-		COMMENT 'Foreign key identifier of the calibration Action' NOT NULL,
-	InstrumentOutputVariableID INTEGER 
-		COMMENT 'Foreign key identifier for the InstrumentOutputVariableID to which the calibration equation applies' NOT NULL,
-	OutputVariableEquation VARCHAR(255) 
-		COMMENT 'Text string that encodes the calibration equation' NOT NULL
-) ENGINE=InnoDB;
-
-/* Add Comments */
-ALTER TABLE CalibrationEquations COMMENT = 'Information about instrument calibration equations';
+		COMMENT 'Foreign key identifier of the Calibration Action' NOT NULL,
+	EquipmentID INTEGER 
+		COMMENT 'Foreign key identifier of the Equipment used in the Calibration Action' NOT NULL
+) ENGINE=InnoDB;
+
+/* Add Comments */
+ALTER TABLE CalibrationReferenceEquipment COMMENT = 'Information about equipment used as referenece for a calibration';
 
 
 /******************** Add Table: CalibrationStandards ************************/

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

/* Add Foreign Key: fk_EquipmentActions_Actions */
ALTER TABLE EquipmentActions 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 EquipmentActions ADD CONSTRAINT fk_EquipmentActions_Equipment
	FOREIGN KEY (EquipmentID) REFERENCES Equipment (EquipmentID)
	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_InstrumentOutputVariables_EquipmentModels */
ALTER TABLE InstrumentOutputVariables ADD CONSTRAINT fk_InstrumentOutputVariables_EquipmentModels
	FOREIGN KEY (ModelID) REFERENCES EquipmentModels (EquipmentModelID)

	EquipmentID INTEGER 
		COMMENT 'Foreign key identifier for a piece of Equipment' NOT NULL,
	RelationshipTypeCV VARCHAR(255) 
		COMMENT 'Controlled Vocabulary term indicating the type of relationship between two pieces of equipment' NOT NULL,
	RelatedEquipmentID INTEGER 
		COMMENT 'Foreign key identifier of the related piece of equipment' NOT NULL,
	RelationshipStartDateTime DATETIME 
		COMMENT 'Beginning date/time of the relationship between the two pieces of equipment' NOT NULL,
	RelationshipStartDateTimeUTCOffset INTEGER 
		COMMENT 'UTCOffset of the beginning date/time' NOT NULL,
	RelationshipEndDateTime DATETIME 
		COMMENT 'Ending date/time of the relationship between two pieces of equipment' NULL,
	RelationshipEndDateTimeUTCOffset INTEGER 
		COMMENT 'UTCOffset of the ending date/time' NULL
) ENGINE=InnoDB;

/* Add Comments */
