 		COMMENT 'Primary key and foreign key idenfier of the Equipment MaintenanceAction' NOT NULL,
 	IsFactoryService BOOLEAN 
 		COMMENT 'Boolean indicator of whether the Action is a factory service' NOT NULL,
-	FactoryServiceCode VARCHAR(50) 
-		COMMENT 'Text code assigned by the factory to the service performed' NULL,
-	FactoryServiceReason VARCHAR(500) 
-		COMMENT 'Text description of why the factory service Action was required' NULL
+	MaintenanceCode VARCHAR(50) 
+		COMMENT 'Text code assigned to the service performed' NULL,
+	MaintenanceReason VARCHAR(500) 
+		COMMENT 'Text description of why the service Action was required' NULL
 ) ENGINE=InnoDB;
 
 /* Add Primary Key */

ALTER TABLE CalibrationStandards COMMENT = 'Bridge table linking field calibrations to the reference materials used';


/******************** Add Table: Equipment ************************/

/* Build Table Structure */
CREATE TABLE Equipment
(
	EquipmentID INTEGER AUTO_INCREMENT PRIMARY KEY 
		COMMENT 'Unique identifier' NOT NULL,
	EquipmentCode VARCHAR(50) 
		COMMENT 'A text code that identifies the piece of equipment' NOT NULL,
	EquipmentName VARCHAR(255) 

fk_ResultNormalizationValues_ReferenceMaterialValues may require an index on table: ResultNormalizationValues, column: NormalizedByReferenceMaterialValueID
fk_ResultsDataQuality_DataQuality may require an index on table: ResultsDataQuality, column: DataQualityID
fk_ResultsDataQuality_Results may require an index on table: ResultsDataQuality, column: ResultID
fk_CalibrationActions_InstrumentOutputVariables may require an index on table: CalibrationActions, column: InstrumentOutputVariableID
fk_CalibrationReferenceEquipment_CalibrationActions may require an index on table: CalibrationReferenceEquipment, column: ActionID
fk_CalibrationReferenceEquipment_Equipment may require an index on table: CalibrationReferenceEquipment, column: EquipmentID
fk_CalibrationStandards_CalibrationActions may require an index on table: CalibrationStandards, column: ActionID
fk_FieldCalibrationStandards_ReferenceMaterials may require an index on table: CalibrationStandards, column: ReferenceMaterialID
fk_DataLoggerFiles_DataloggerProgramFiles may require an index on table: DataLoggerFiles, column: ProgramID
fk_DataloggerFileColumns_DataLoggerFiles may require an index on table: DataloggerFileColumns, column: DataLoggerFileID
fk_DataloggerFileColumns_InstrumentOutputVariables may require an index on table: DataloggerFileColumns, column: InstrumentOutputVariableID
fk_DataloggerFileColumns_RecordingUnits may require an index on table: DataloggerFileColumns, column: RecordingIntervalUnitsID
fk_DataloggerFileColumns_Results may require an index on table: DataloggerFileColumns, column: ResultID
fk_DataloggerFileColumns_ScanUnits may require an index on table: DataloggerFileColumns, column: ScanIntervalUnitsID
fk_DataloggerProgramFiles_Affiliations may require an index on table: DataloggerProgramFiles, column: AffiliationID
fk_Equipment_EquipmentModels may require an index on table: Equipment, column: EquipmentModelID
fk_Equipment_Organizations may require an index on table: Equipment, column: EquipmentVendorID
fk_Equipment_People may require an index on table: Equipment, column: EquipmentOwnerID
fk_EquipmentModels_Organizations may require an index on table: EquipmentModels, column: ModelManufacturerID
fk_EquipmentActions_Actions may require an index on table: EquipmentUsed, column: ActionID
fk_EquipmentActions_Equipment may require an index on table: EquipmentUsed, column: EquipmentID
fk_InstrumentOutputVariables_EquipmentModels may require an index on table: InstrumentOutputVariables, column: ModelID
fk_InstrumentOutputVariables_Methods may require an index on table: InstrumentOutputVariables, column: InstrumentMethodID
fk_InstrumentOutputVariables_Units may require an index on table: InstrumentOutputVariables, column: InstrumentRawOutputUnitsID
