生产设备管理系统

返回总览生产设备管理系统数据表序号表名1ICDeviceAccount2ICDeviceAccessory3ICDeviceAccident4ICDeviceAccImprove5ICDeviceAccReason6ICDeviceChange7ICDeviceDoc8ICDeviceImproveInfo9ICDeviceImproveInfoEntry10ICDeviceInspectPlan11ICDeviceInspectPlanEntry12ICDeviceInspectRecord13ICDeviceInspectRecordEntry14ICDeviceLubePlan15ICDeviceLubePlanEntry16ICDeviceLubeRecord17ICDeviceLubeRecordEntry18ICDeviceMaintainPlan19ICDeviceMaintainPlanEntry20ICDeviceMaintainRecord21ICDeviceMaintainRecordEntry22ICDeviceParam23ICDeviceRepairApply24ICDeviceRepairApplyProject25ICDeviceRepairApplySpare26ICDeviceRepairCheck27ICDeviceRepairCheckEntry28ICDeviceRepairPlan29ICDeviceRepairPlanProject30ICDeviceRepairPlanSpare31ICDeviceRepairRecord32ICDeviceRepairRecordProject33ICDeviceRepairRecordSpare34ICDeviceRepairWO35ICDeviceRepairWOProject36ICDeviceRepairWOSpare37ICDeviceRun38ICDeviceRunEntry39ICDeviceSparePart40ICDeviceRepairData41ICDeviceRepairProject42ICDeviceLubeData43ICDeviceLubeDataEntry44ICDeviceInspectData45ICDeviceInspectDataEntry46ICDeviceMaintainData47ICDeviceMaintainDataEntry48View_ICDeviceAccount49View_ICDeviceRun50View_ICDeviceRepairData51View_ICDeviceLubeData52View_ICDeviceLubePlan53View_ICDeviceLubeRecord54View_ICDeviceAccident55View_ICDeviceImproveInfo56View_ICDeviceInspectData57View_ICDeviceInspectPlan58View_ICDeviceInspectRecord59View_ICDeviceMaintainData60View_ICDeviceMaintainPlan61View_ICDeviceMaintainRecord62View_ICDeviceRepairApply63View_ICDeviceRepairPlan64View_ICDeviceRepairWO65View_ICDeviceRepairRecord66View_ICDeviceRepairCheck表描述设备档案设备档案分录设备事故登记表设备事故登记表分录_改善措施设备事故登记表分录设备档案分录_变动情况设备档案分录_文档管理设备事故改善登记表设备事故改善登记表分录设备点检计划设备点检计划分录设备点检记录设备点检记录分录设备润滑计划设备润滑计划分录设备润滑记录设备润滑记录分录设备保养计划设备保养计划分录设备保养记录设备保养记录分录设备档案分录_技术参数设备请修设备请修分录设备请修分录_备件耗用设备维修验收设备维修验收分录设备维修计划设备维修计划分录设备维修计划分录_备件耗用设备维修记录设备维修记录分录设备维修记录分录_备件耗用设备维修工单设备维修工单分录设备维修工单分录_备件耗用设备运行设备运行分录设备档案分录_设备备件设备维修规程设备维修规程分录设备润滑规程设备润滑规程分录设备点检规程设备点检规程分录设备保养规程设备保养规程分录设备档案视图设备运行视图设备维修规程视图设备润滑规程视图设备润滑计划视图设备润滑记录视图设备事故登记表视图设备事故改善登记表视图设备点检规程视图设备点检计划视图设备点检记录视图设备保养规程视图设备保养计划视图设备保养记录视图设备请修视图设备维修计划视图设备维修工单视图设备维修记录视图设备维修验收视图返回生产设备管理系统目录表结构字段名类型描述FABCTypeINTEGERABC分类FAssetNumberINTEGER资产编码FAttributeINTEGER设备属性FBeginUseDateDATETIME启用日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME确认日期FCheckerIDINTEGER确认人FClassTypeIDINTEGER事务类型FCountrySTRING制造国别FDeptNumberINTEGER使用部门FDeviceClassINTEGER设备类别FDeviceNameSTRING设备名称FDeviceNumberSTRING设备代码FDeviceTypeINTEGER设备类型FDrawingNumberSTRING图号FECoefficientFLOAT电气复杂系数FIDINTEGER内码FItemNumberINTEGER对应物料代码FLeaveFactoryDateDATETIME出厂日期FLeaveFactoryNumberSTRING出厂编号FManufacturerSTRING制造商FMCoefficientFLOAT机械复杂系数FModelSTRING设备型号FNoteSTRING备注FPowerCapFLOAT动力容量(KW)FPurposeINTEGER生产用途FResourceNumberINTEGER对应资源代码FSettingPlaceSTRING安装地点FSpecificationSTRING设备规格FStatusINTEGER设备状态FSupplierINTEGER供应商FTechLevelINTEGER技术水平FWorkTimeFLOAT日制度工作时间(小时)键表键名类型PK__ICDeviceAccount__4D01ECC3主键索引表索引名字段PK__ICDeviceAccount__4D01ECC3FIDIX_FClassFClassTypeIDIX_FNumberFBillID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAccessoryNameSTRING附属设备名称FAccessoryNumberSTRING附属设备代码FCountrySTRING制造国别FDeviceClassINTEGER设备类别FDrawingNumberSTRING图号FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLeaveFactoryDateDATETIME出厂日期FLeaveFactoryNumberSTRING出厂编号FManufacturerSTRING制造商FModelSTRING设备型号FNoteSTRING备注FQtyFLOAT附属设备数量FSpecificationSTRING设备规格FStatusINTEGER设备状态FSupplierINTEGER供应商键表键名类型PK__ICDeviceAccessor__3DBFA933主键索引表索引名字段PK__ICDeviceAccessor__3DBFA933FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAccidentDateDATETIME故障发生日期FAccidentDescribeSTRING故障描述FAccidentFinderINTEGER故障发现人FAccidentIfImproveSTRING是否改善FAccidentManINTEGER故障负责人FAccidentNumberINTEGER故障类别代码FBillDateDATETIME制单日期FBillerINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FIDINTEGER内码键表键名类型PK__ICDeviceAccident__1082EE68主键索引表索引名字段PK__ICDeviceAccident__1082EE68FIDIX_FDeviceIDFClassTypeID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAccImproveDescribeSTRING改善措施描述FAccImproveMeasureSTRING改善措施FAssessDateDATETIME检查日期FAssessorINTEGER检查人FEntryIDINTEGER分录内码FFunctionaryINTEGER责任人FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING故障原因备注键表键名类型PK__ICDeviceAccImpro__126B36DA主键索引表索引名字段PK__ICDeviceAccImpro__126B36DAFEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FAccidentDescribeSTRING故障描述FAccidentReasonINTEGER故障原因FAccManINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FNoteSTRING故障原因备注键表键名类型PK__ICDeviceAccReaso__1A0C58A2主键索引表索引名字段PK__ICDeviceAccReaso__1A0C58A2FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FChangeDateDATETIME设备变更日期FChangeReasonSTRING变更原因FChangeToSTRING变更去向FChangeTypeINTEGER设备变更类型FEntryIDINTEGER分录内码FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING变更备注键表键名类型PK__ICDeviceChange__6D6EBC55主键索引表索引名字段PK__ICDeviceChange__6D6EBC55FEntryIDIX_FIDFID触发器表触发器名描述返回生产设备管理系统目录表结构字段名类型描述FCopyQtyINTEGER份数FDocContentSTRING文档内容FDocNameSTRING文档名称FDocNumberSTRING文档编号FECopyPathSTRING电子文档路径FEntryIDINTEGER分录内码FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING文档备注FStorePlaceSTRING存放地点键表键名类型PK__ICDeviceDoc__741BB9E4主键索引表索引名字段P