生产设备管理系统.xls

《生产设备管理系统.xls》由会员分享，可在线阅读，更多相关《生产设备管理系统.xls（77页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、返回总览生产设备管理系统数据表序序号号表表名名1 ICDeviceAccount2 ICDeviceAccessory3 ICDeviceAccident4 ICDeviceAccImprove5 ICDeviceAccReason6 ICDeviceChange7 ICDeviceDoc8 ICDeviceImproveInfo9 ICDeviceImproveInfoEntry10 ICDeviceInspectPlan11 ICDeviceInspectPlanEntry12 ICDeviceInspectRecord13 ICDeviceInspectRecordEntry14 ICD

2、eviceLubePlan15 ICDeviceLubePlanEntry16 ICDeviceLubeRecord17 ICDeviceLubeRecordEntry18 ICDeviceMaintainPlan19 ICDeviceMaintainPlanEntry20 ICDeviceMaintainRecord21 ICDeviceMaintainRecordEntry22 ICDeviceParam23 ICDeviceRepairApply24 ICDeviceRepairApplyProject25 ICDeviceRepairApplySpare26 ICDeviceRepai

3、rCheck27 ICDeviceRepairCheckEntry28 ICDeviceRepairPlan29 ICDeviceRepairPlanProject30 ICDeviceRepairPlanSpare31 ICDeviceRepairRecord32 ICDeviceRepairRecordProject33 ICDeviceRepairRecordSpare34 ICDeviceRepairWO35 ICDeviceRepairWOProject36 ICDeviceRepairWOSpare37 ICDeviceRun38 ICDeviceRunEntry39 ICDevi

4、ceSparePart40 ICDeviceRepairData41 ICDeviceRepairProject42 ICDeviceLubeData43 ICDeviceLubeDataEntry44 ICDeviceInspectData45 ICDeviceInspectDataEntry46 ICDeviceMaintainData47 ICDeviceMaintainDataEntry48 View_ICDeviceAccount49 View_ICDeviceRun50 View_ICDeviceRepairData51 View_ICDeviceLubeData52 View_I

5、CDeviceLubePlan53 View_ICDeviceLubeRecord54 View_ICDeviceAccident55 View_ICDeviceImproveInfo56 View_ICDeviceInspectData57 View_ICDeviceInspectPlan58 View_ICDeviceInspectRecord59 View_ICDeviceMaintainData60 View_ICDeviceMaintainPlan61 View_ICDeviceMaintainRecord62 View_ICDeviceRepairApply63 View_ICDe

6、viceRepairPlan64 View_ICDeviceRepairWO65 View_ICDeviceRepairRecord66 View_ICDeviceRepairCheck表表描描述述设备档案设备档案分录设备事故登记表设备事故登记表分录_改善措施设备事故登记表分录设备档案分录_变动情况设备档案分录_文档管理设备事故改善登记表设备事故改善登记表分录设备点检计划设备点检计划分录设备点检记录设备点检记录分录设备润滑计划设备润滑计划分录设备润滑记录设备润滑记录分录设备保养计划设备保养计划分录设备保养记录设备保养记录分录设备档案分录_技术参数设备请修设备请修分录设备请修分录_备件耗用设备维

7、修验收设备维修验收分录设备维修计划设备维修计划分录设备维修计划分录_备件耗用设备维修记录设备维修记录分录设备维修记录分录_备件耗用设备维修工单设备维修工单分录设备维修工单分录_备件耗用设备运行设备运行分录设备档案分录_设备备件设备维修规程设备维修规程分录设备润滑规程设备润滑规程分录设备点检规程设备点检规程分录设备保养规程设备保养规程分录设备档案视图设备运行视图设备维修规程视图设备润滑规程视图设备润滑计划视图设备润滑记录视图设备事故登记表视图设备事故改善登记表视图设备点检规程视图设备点检计划视图设备点检记录视图设备保养规程视图设备保养计划视图设备保养记录视图设备请修视图设备维修计划视图设备维修工

8、单视图设备维修记录视图设备维修验收视图返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FABCTypeINTEGERABC分类FAssetNumberINTEGER资产编码FAttributeINTEGER设备属性FBeginUseDateDATETIME启用日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME确认日期FCheckerIDINTEGER确认人FClassTypeIDINTEGER事务类型FCountrySTRING制造国别FDe

9、ptNumberINTEGER使用部门FDeviceClassINTEGER设备类别FDeviceNameSTRING设备名称FDeviceNumberSTRING设备代码FDeviceTypeINTEGER设备类型FDrawingNumberSTRING图号FECoefficientFLOAT电气复杂系数FIDINTEGER内码FItemNumberINTEGER对应物料代码FLeaveFactoryDateDATETIME出厂日期FLeaveFactoryNumberSTRING出厂编号FManufacturerSTRING制造商FMCoefficientFLOAT机械复杂系数FModel

10、STRING设备型号FNoteSTRING备注FPowerCapFLOAT动力容量(KW)FPurposeINTEGER生产用途FResourceNumberINTEGER对应资源代码FSettingPlaceSTRING安装地点FSpecificationSTRING设备规格FStatusINTEGER设备状态FSupplierINTEGER供应商FTechLevelINTEGER技术水平FWorkTimeFLOAT日制度工作时间(小时)键表键键名名类类型型PK_ICDeviceAccount_4D01ECC3主键索引表索索引引名名字字段段PK_ICDeviceAccount_4D01ECC

11、3FIDIX_FClassFClassTypeIDIX_FNumberFBillID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FAccessoryNameSTRING附属设备名称FAccessoryNumberSTRING附属设备代码FCountrySTRING制造国别FDeviceClassINTEGER设备类别FDrawingNumberSTRING图号FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLeaveFactoryDateDATETIME 出厂日期FLeaveFactoryNumberS

12、TRING出厂编号FManufacturerSTRING制造商FModelSTRING设备型号FNoteSTRING备注FQtyFLOAT附属设备数量FSpecificationSTRING设备规格FStatusINTEGER设备状态FSupplierINTEGER供应商键表键键名名类类型型PK_ICDeviceAccessor_3DBFA933主键索引表索索引引名名字字段段PK_ICDeviceAccessor_3DBFA933FEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FAccidentDateDATETIME

13、故障发生日期FAccidentDescribeSTRING故障描述FAccidentFinderINTEGER故障发现人FAccidentIfImproveSTRING是否改善FAccidentManINTEGER故障负责人FAccidentNumberINTEGER故障类别代码FBillDateDATETIME制单日期FBillerINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码

14、FIDINTEGER内码键表键键名名类类型型PK_ICDeviceAccident_1082EE68主键索引表索索引引名名字字段段PK_ICDeviceAccident_1082EE68FIDIX_FDeviceIDFClassTypeID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FAccImproveDescribeSTRING改善措施描述FAccImproveMeasureSTRING改善措施FAssessDateDATETIME 检查日期FAssessorINTEGER检查人FEntryIDINTEGER分录内码FFunctionaryIN

15、TEGER责任人FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING故障原因备注键表键键名名类类型型PK_ICDeviceAccImpro_126B36DA主键索引表索索引引名名字字段段PK_ICDeviceAccImpro_126B36DAFEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FAccidentDescribeSTRING故障描述FAccidentReasonINTEGER故障原因FAccManINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FI

16、ndexINTEGER行号FNoteSTRING故障原因备注键表键键名名类类型型PK_ICDeviceAccReaso_1A0C58A2主键索引表索索引引名名字字段段PK_ICDeviceAccReaso_1A0C58A2FEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FChangeDateDATETIME 设备变更日期FChangeReasonSTRING变更原因FChangeToSTRING变更去向FChangeTypeINTEGER设备变更类型FEntryIDINTEGER分录内码FIDINTEGER单据内码FI

17、ndexINTEGER行号FNoteSTRING变更备注键表键键名名类类型型PK_ICDeviceChange_6D6EBC55主键索引表索索引引名名字字段段PK_ICDeviceChange_6D6EBC55FEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FCopyQtyINTEGER份数FDocContentSTRING文档内容FDocNameSTRING文档名称FDocNumberSTRING文档编号FECopyPathSTRING电子文档路径FEntryIDINTEGER分录内码FIDINTEGER单据内码FI

18、ndexINTEGER行号FNoteSTRING文档备注FStorePlaceSTRING存放地点键表键键名名类类型型PK_ICDeviceDoc_741BB9E4主键索引表索索引引名名字字段段PK_ICDeviceDoc_741BB9E4FEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FAccidentDateDATETIME故障发生日期FAccidentDescribeSTRING故障描述FAccidentNumberINTEGER故障类别代码FBillDateDATETIME制单日期FBillerIDINTEGE

19、R制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceAccidentBillIDSTRING设备事故登记表编号FDeviceAccidentIDINTEGER设备事故登记表IDFDeviceIDINTEGER设备代码FIDINTEGER内码FNoteSTRING备注键表键键名名类类型型PK_ICDeviceImproveI_20B95631主键索引表索索引引名名字字段段PK_ICDeviceImproveI_20B9563

20、1FIDIX_FDeviceIDFClassTypeID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FAccImproveDescribeSTRING改善措施描述FAccImproveMeasureSTRING改善措施FAccManINTEGER责任人FAssessDateDATETIME 检查日期FAssessorINTEGER检查人FCheckInfoSTRING检查记录FDeviceIfImproveSTRING改善是否完成FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FNoteSTRING备注键

21、表键键名名类类型型PK_ICDeviceImproveI_2D1F2D16主键索引表索索引引名名字字段段PK_ICDeviceImproveI_2D1F2D16FEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER

22、设备代码FIDINTEGER内码FInspectIDINTEGER点检规程内码FInspectNameSTRING点检名称FInspectNumberSTRING点检代码FInspectPeriodFLOAT点检周期FLastInspectDateDATETIME最近点检日期FNextInspectDateDATETIME下次点检日期FNoteSTRING备注FPeriodUnitINTEGER周期单位FPlanBeginDateDATETIME计划开始日期FPlanEndDateDATETIME计划截止日期键表键键名名类类型型PK_ICDeviceInspectP_430E6E35主键索引表

23、索索引引名名字字段段PK_ICDeviceInspectP_430E6E35FIDIX_FDeviceIDFClassTypeID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FChargeEmpINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FInspectPositionSTRING点检部位FInspectRequireSTRING具体要求FNoteSTRING备注FProjectNameSTRING点检项目名称键表键键名名类类型型PK_ICDeviceInspectP_515C8D

24、8C主键索引表索索引引名名字字段段PK_ICDeviceInspectP_515C8D8CFEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FBeginDateDATETIME点检开始日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FEndDat

25、eDATETIME点检结束日期FIDINTEGER内码FInspectIDINTEGER点检规程内码FInspectNameSTRING点检名称FInspectNumberSTRING点检代码FInspectPlanBillIDSTRING点检计划编号FInspectPlanIDINTEGER点检计划内码FNoteSTRING备注键表键键名名类类型型PK_ICDeviceInspectR_58FDAF54主键索引表索索引引名名字字段段PK_ICDeviceInspectR_58FDAF54FIDIX_FDeviceIDFClassTypeID触发器表触触发发器器名名描描述述返回生产设备管理系统

26、目录表结构字字段段名名类类型型描描述述FChargeEmpINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FInspectPositionSTRING点检部位FInspectRecordSTRING点检记录FInspectRequireSTRING具体要求FNoteSTRING备注FProjectNameSTRING点检项目名称键表键键名名类类型型PK_ICDeviceInspectR_674BCEAB主键索引表索索引引名名字字段段PK_ICDeviceInspectR_674BCEABFEntryIDIX_FIDFID触发器表触

27、触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FIDINTEGER内码FLastLubricateDateDATETIME最近润滑日期FLubricateIDINTEGER润滑规程内码FLubricateNameSTRING润滑名称FLubr

28、icateNumberSTRING润滑代码FLubricatePeriodFLOAT润滑周期FNextLubricateDateDATETIME下次润滑日期FNoteSTRING备注FPeriodUnitINTEGER周期单位FPlanBeginDateDATETIME计划开始日期FPlanEndDateDATETIME计划截止日期键表键键名名类类型型PK_ICDeviceLubePlan_5C0F2629主键索引表索索引引名名字字段段PK_ICDeviceLubePlan_5C0F2629FIDIX_FDeviceIDFClassTypeID触发器表触触发发器器名名描描述述返回生产设备管理系

29、统目录表结构字字段段名名类类型型描描述述FChargeEmpINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLubeIDINTEGER润滑油代码FLubericatePositionSTRING润滑部位FLubricateExplainSTRING润滑说明FNoteSTRING备注FStdQtyFLOAT标准用量FStdQty_BaseFLOAT基本单位标准用量FUnitINTEGER计量单位键表键键名名类类型型PK_ICDeviceLubePlan_6A5D4580主键索引表索索引引名名字字段段PK_ICDeviceLubeP

30、lan_6A5D4580FEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FBeginDateDATETIME润滑开始日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FEndDateDATETIME润滑结束日期FIDINTEGER内码FLubeP

31、lanBillIDSTRING润滑计划编号FLubePlanIDINTEGER润滑计划内码FLubricateIDINTEGER润滑规程内码FLubricateNameSTRING润滑名称FLubricateNumberSTRING润滑代码FNoteSTRING备注键表键键名名类类型型PK_ICDeviceLubeReco_74DAD3F3主键索引表索索引引名名字字段段PK_ICDeviceLubeReco_74DAD3F3FIDIX_FDeviceIDFClassTypeID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FChargeEmpINTE

32、GER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLubeIDINTEGER润滑油代码FLubeRecordSTRING润滑记录FLubericatePositionSTRING润滑部位FLubricateExplainSTRING润滑说明FNoteSTRING备注FStdQtyFLOAT标准用量FStdQty_BaseFLOAT基本单位标准用量FUnitINTEGER计量单位FUsedQtyFLOAT实际用量FUsedQty_BaseFLOAT基本单位实际用量键表键键名名类类型型PK_ICDeviceLubeReco_0328F34A主

33、键索引表索索引引名名字字段段PK_ICDeviceLubeReco_0328F34AFEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FIDINTEGER内码FLastMaintainDateDATET

34、IME最近保养日期FMaintainIDINTEGER保养规程内码FMaintainNameSTRING保养名称FMaintainNumberSTRING保养代码FMaintainPeriodFLOAT保养周期FMaintainTypeINTEGER保养类别FNextMaintainDateDATETIME下次保养日期FNoteSTRING备注FPeriodUnitINTEGER周期单位FPlanBeginDateDATETIME计划开始日期FPlanEndDateDATETIME计划截止日期键表键键名名类类型型PK_ICDeviceMaintain_0B892F21主键索引表索索引引名名字字

35、段段PK_ICDeviceMaintain_0B892F21FIDIX_FDeviceIDFClassTypeID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FChargeEmpINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FMaintainRequireSTRING具体要求FNoteSTRING备注FProjectNameSTRING保养项目名称键表键键名名类类型型PK_ICDeviceMaintain_1ACB72B1主键索引表索索引引名名字字段段PK_ICDeviceMaint

36、ain_1ACB72B1FEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FBeginDateDATETIME保养开始日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FEndDateDATETIME保养结束日期FIDINTEGER内码FMaint

37、ainIDINTEGER保养规程内码FMaintainNameSTRING保养名称FMaintainNumberSTRING保养代码FMaintainPlanBillIDSTRING保养计划编号FMaintainPlanIDINTEGER保养计划内码FMaintainTypeINTEGER保养类别FNoteSTRING备注键表键键名名类类型型PK_ICDeviceMaintain_29199208主键索引表索索引引名名字字段段PK_ICDeviceMaintain_29199208FIDIX_FDeviceIDFClassTypeID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结

38、构字字段段名名类类型型描描述述FChargeEmpINTEGER负责人FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FMaintainRecordSTRING保养记录FMaintainRequireSTRING具体要求FMaintainTimeFLOAT保养工时FNoteSTRING备注FProjectNameSTRING保养项目名称FStopTimeFLOAT停机工时FTimeUnitINTEGER时间单位键表键键名名类类型型PK_ICDeviceMaintain_385BD598主键索引表索索引引名名字字段段PK_ICDeviceMaintai

39、n_385BD598FEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FEntryIDINTEGER分录内码FIDINTEGER单据内码FIndexINTEGER行号FLowerLimitSTRING下限值FNoteSTRING参数备注FParamExplainSTRING参数说明FParamNameSTRING参数名称FParamNumberSTRING参数代码FParamTypeINTEGER参数值类型FStandardValueSTRING标准值FUpperLimitSTRING上限值键表键键名名类类型型PK_IC

40、DeviceParam_7DA5241E主键索引表索索引引名名字字段段PK_ICDeviceParam_7DA5241EFEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FApplyBeginDateDATETIME申请开始日期FApplyDeptIDINTEGER申请部门FApplyEndDateDATETIME申请截止日期FApplyReasonSTRING申请原因FBeginDateDATETIME实际开始日期FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING

41、编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceAccidentBillIDSTRING事故登记表号FDeviceAccidentIDINTEGER事故登记表内码FDeviceIDINTEGER设备代码FEndDateDATETIME实际结束日期FIDINTEGER内码FNoteSTRING备注FPlanBeginDateDATETIME计划开始日期FPlanEndDateDATETIME计划结束日期FRepairContentSTRING维修内容FR

42、epairIDINTEGER维修规程内码FRepairManHourFLOAT维修工时FRepairNameSTRING维修名称FRepairNumberSTRING维修代码FRequireSTRING维修要求FStopManHourFLOAT停机工时FTimeUnitINTEGER时间单位键表键键名名类类型型PK_ICDeviceRepairAp_4C62CE45主键索引表索索引引名名字字段段PK_ICDeviceRepairAp_4C62CE45FIDIX_FDeviceIDFClassTypeID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述F

43、ChargeEmpINTEGER负责人FCheckEmpINTEGER检查人FDesValueSTRING目标值FDesValueTypeINTEGER目标值类型FEntryIDINTEGER分录内码FIDINTEGER内码FIndexINTEGER行号FLowerDesValueSTRING目标下限FNoteSTRING备注FProjectNameSTRING维修项目名称FRepairRequireSTRING项目维修要求FUpperDesValueSTRING目标上限FWorkDescriptionSTRING维修操作说明键表键键名名类类型型PK_ICDeviceRepairAp_615D

44、EB2B主键索引表索索引引名名字字段段PK_ICDeviceRepairAp_615DEB2BFEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FAuxQtyFLOAT用量FAuxQty_BaseFLOAT基本单位用量FEntryIDINTEGER分录内码FIDINTEGER单据内码FIndexINTEGER行号FNoteSTRING备注FSparePartIDINTEGER基本计量单位FSpaUnitINTEGER计量单位键表键键名名类类型型PK_ICDeviceRepairAp_6DC3C210主键索引表索索引引名名

45、字字段段PK_ICDeviceRepairAp_6DC3C210FEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FIDINTEGER内码FNoteSTRING备注FRepairCheckDateDAT

46、ETIME验收日期FRepairCheckerIDINTEGER验收人FRepairCheckResultINTEGER验收结论FRepairWOBillIDSTRING维修工单号FRepairWOIDINTEGER设备维修工单内码键表键键名名类类型型PK_ICDeviceRepairCh_0842AE22主键索引表索索引引名名字字段段PK_ICDeviceRepairCh_0842AE22FIDIX_FDeviceIDFClassTypeID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FCheckContentSTRING验收内容FDesValu

47、eSTRING目标值FDesValueTypeINTEGER目标值类型FEntryIDINTEGER分录内码FFactValueSTRING实际值FIDINTEGER内码FIndexINTEGER行号FLowerDesValueSTRING目标下限FNoteSTRING备注FProjectNameSTRING验收项目名称FUpperDesValueSTRING目标上限键表键键名名类类型型PK_ICDeviceRepairCh_159CA940主键索引表索索引引名名字字段段PK_ICDeviceRepairCh_159CA940FEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返

48、回生产设备管理系统目录表结构字字段段名名类类型型描描述述FBillDateDATETIME制单日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FCurrencyINTEGER币别FDeviceIDINTEGER设备代码FEntrustINTEGER是否外包FIDINTEGER内码FLastRepairDateDATETIME最近维修日期FNextRepairDateDATETIME下次维修日期FNo

49、teSTRING备注FPeriodFLOAT维修周期FPeriodUnitINTEGER周期单位FPlanBeginDateDATETIME计划开始日期FPlanEndDateDATETIME计划结束日期FPlanRepairFeeFLOAT计划修理费用FPlanRepairManHourFLOAT计划维修工时FPlanStopManHourFLOAT计划停机工时FRepairCatgINTEGER维修类别FRepairContentSTRING维修内容FRepairFeeFLOAT实际修理费用FRepairIDINTEGER维修规程内码FRepairManHourFLOAT实际维修工时FRe

50、pairNameSTRING维修名称FRepairNumberSTRING维修代码FRepairSubcntrINTEGER修理单位FRequireSTRING维修要求FStopManHourFLOAT实际停机工时FTimeUnitINTEGER时间单位键表键键名名类类型型PK_ICDeviceRepairPl_7564E3D8主键索引表索索引引名名字字段段PK_ICDeviceRepairPl_7564E3D8FIDIX_FDeviceIDFClassTypeID触发器表触触发发器器名名描描述述返回生产设备管理系统目录表结构字字段段名名类类型型描描述述FChargeEmpINTEGER负责人