表格模板-设备管理系统数据表xls1 精品.xls

《表格模板-设备管理系统数据表xls1 精品.xls》由会员分享，可在线阅读，更多相关《表格模板-设备管理系统数据表xls1 精品.xls（66页珍藏版）》请在第一文库网上搜索。

1、返回总览设备管理系统数据表序序号号表表名名表表描描述述1 View_ICDeviceRepairCheck设备维修验收视图2 ICDeviceAccount设备档案3 ICDeviceAccessory设备档案分录4 ICDeviceRun设备运行5 ICDeviceRunEntry设备运行分录6 ICDeviceRepairData设备维修规程7 ICDeviceRepairProject设备维修规程分录8 ICDeviceLubeData设备润滑规程9 ICDeviceLubeDataEntry设备润滑规程分录10 ICDeviceLubePlan设备润滑计划11 ICDeviceLube

2、PlanEntry设备润滑计划分录12 ICDeviceLubeRecord设备润滑记录13 ICDeviceLubeRecordEntry设备润滑记录分录14 ICDeviceAccident设备事故登记表15 ICDeviceAccReason设备事故登记表分录16 ICDeviceImproveInfo设备事故改善登记表17 ICDeviceImproveInfoEntry设备事故改善登记表分录18 ICDeviceInspectData设备点检规程19 ICDeviceInspectDataEntry设备点检规程分录20 ICDeviceInspectPlan设备点检计划21 ICDe

3、viceInspectPlanEntry设备点检计划分录22 ICDeviceInspectRecord设备点检记录23 ICDeviceInspectRecordEntry设备点检记录分录24 ICDeviceMaintainData设备保养规程25 ICDeviceMaintainDataEntry设备保养规程分录26 ICDeviceMaintainPlan设备保养计划27 ICDeviceMaintainPlanEntry设备保养计划分录28 ICDeviceMaintainRecord设备保养记录29 ICDeviceMaintainRecordEntry设备保养记录分录30 ICD

4、eviceRepairApply设备请修31 ICDeviceRepairApplyProject设备请修分录32 ICDeviceRepairPlan设备维修计划33 ICDeviceRepairPlanProject设备维修计划分录34 ICDeviceRepairWO设备维修工单35 ICDeviceRepairWOProject设备维修工单分录36 ICDeviceRepairRecord设备维修记录37 ICDeviceRepairRecordProject设备维修记录分录38 ICDeviceRepairCheck设备维修验收39 ICDeviceRepairCheckEntry设

5、备维修验收分录40 View_ICDeviceAccount设备档案视图41 View_ICDeviceRun设备运行视图42 View_ICDeviceRepairData设备维修规程视图43 View_ICDeviceLubeData设备润滑规程视图44 View_ICDeviceLubePlan设备润滑计划视图45 View_ICDeviceLubeRecord设备润滑记录视图46 View_ICDeviceAccident设备事故登记表视图47 View_ICDeviceImproveInfo设备事故改善登记表视图48 View_ICDeviceInspectData设备点检规程视图4

6、9 View_ICDeviceInspectPlan设备点检计划视图50 View_ICDeviceInspectRecord设备点检记录视图51 View_ICDeviceMaintainData设备保养规程视图52 View_ICDeviceMaintainPlan设备保养计划视图53 View_ICDeviceMaintainRecord设备保养记录视图54 View_ICDeviceRepairApply设备请修视图55 View_ICDeviceRepairPlan设备维修计划视图56 View_ICDeviceRepairWO设备维修工单视图57 View_ICDeviceRepa

7、irRecord设备维修记录视图返回设备管理系统目录表结构字字段段名名类类型型描描述述FBillDateDATETIME 制单日期FBillStatusINTEGER单据状态FCheckDateDATETIME 审核日期FProjectNameSTRING验收项目名称FRepairCheckDateDATETIME 验收日期FRepairCheckerIDSTRING验收人FRepairCheckResultINTEGER验收结论FUpperDesValueSTRING目标上限FDeviceIDSTRING设备代码FDeviceID32478STRING设备规格FDeviceID32523ST

8、RING使用部门FDeviceID51789STRING设备名称FFactValueSTRING实际值FLowerDesValueSTRING目标下限FNoteSTRING备注FNote_2STRING验收备注FRepairWOBillIDSTRING维修工单号FBillerIDSTRING制单人FBillIDSTRING编号FCheckContentSTRING验收内容FCheckerIDSTRING审核人FDesValueSTRING目标值FDesValueTypeSTRING目标值类型FDeviceID32496STRING设备型号键表键键名名类类型型索引表索索引引名名字字段段触发器表触

9、触发发器器名名描描述述返回设备管理系统目录表结构字字段段名名类类型型描描述述FBeginUseDateDATETIME启用日期FLeaveFactoryDateDATETIME出厂日期FABCTypeINTEGERABC分类FAssetNumberINTEGER资产编码FAttributeINTEGER设备属性FBillStatusINTEGER单据状态FSettingPlaceSTRING安装地点FSpecificationSTRING设备规格FCheckerIDINTEGER确认人FManufacturerSTRING制造商FModelSTRING设备型号FPurposeINTEGER生产

10、用途FBillDateDATETIME制单日期FSupplierINTEGER供应商FCheckDateDATETIME确认日期FTechLevelINTEGER技术水平FECoefficientFLOAT电气复杂系数FPowerCapFLOAT动力容量(KW)FWorkTimeFLOAT日制度工作时间(小时)FMCoefficientFLOAT机械复杂系数FResourceNumberINTEGER对应资源代码FStatusINTEGER设备状态FNoteSTRING备注FBillerIDINTEGER制单人FBillIDSTRING编号FClassTypeIDINTEGER事务类型FCou

11、ntrySTRING制造国别FDeptNumberINTEGER使用部门FDeviceClassINTEGER设备类别FDeviceNameSTRING设备名称FDeviceNumberSTRING设备代码FDeviceTypeINTEGER设备类型FDrawingNumberSTRING图号FIDINTEGER内码FItemNumberINTEGER对应物料代码FLeaveFactoryNumberSTRING出厂编号键表键键名名类类型型PK_ICDeviceAccount_62713F9E主键索引表索索引引名名字字段段PK_ICDeviceAccount_62713F9EFIDIX_FCl

12、assFClassTypeIDIX_FNumberFBillID触发器表触触发发器器名名描描述述返回设备管理系统目录表结构字字段段名名类类型型描描述述FAccessoryNameSTRING附属设备名称FLeaveFactoryNumberSTRING出厂编号FManufacturerSTRING制造商FAccessoryNumberSTRING附属设备代码FCountrySTRING制造国别FDeviceClassINTEGER设备类别FEntryIDINTEGER分录内码FIndexINTEGER行号FLeaveFactoryDateDATETIME 出厂日期FQtyFLOAT附属设备数量

13、FStatusINTEGER设备状态FSupplierINTEGER供应商FDrawingNumberSTRING图号FIDINTEGER内码FModelSTRING设备型号FNoteSTRING备注FSpecificationSTRING设备规格键表键键名名类类型型PK_ICDeviceAccessor_532EFC0E主键索引表索索引引名名字字段段PK_ICDeviceAccessor_532EFC0EFEntryIDIX_FIDFID触发器表触触发发器器名名描描述述返回设备管理系统目录表结构字字段段名名类类型型描描述述FBeginDateDATETIME统计开始日期FBillDateDA

14、TETIME制单日期FCheckDateDATETIME审核日期FEndDateDATETIME统计截止日期FBillerIDINTEGER制单人FBillIDSTRING编号FBillStatusINTEGER单据状态FCheckerIDINTEGER审核人FClassTypeIDINTEGER事务类型FIDINTEGER内码键表键键名名类类型型PK_ICDeviceRun_206E7217主键索引表索索引引名名字字段段PK_ICDeviceRun_206E7217FIDIX_FBeginDateFClassTypeIDIX_FEndDateFBillID触发器表触触发发器器名名描描述述返回

15、设备管理系统目录表结构字字段段名名类类型型描描述述FIndexINTEGER行号FMachineRepairTimeFLOAT机修时间FPowerCutTimeFLOAT停电时间FTimeUnitINTEGER时间单位FBreakDownTimeFLOAT故障停机时间FDeviceIDINTEGER设备代码FEntryIDINTEGER分录内码FIDINTEGER内码FNoteSTRING备注FRunTimeFLOAT运行时间FWaitMaterialTimeFLOAT待料时间FWaitToolTimeFLOAT待具时间键表键键名名类类型型PK_ICDeviceRunEntry_280F93D

16、F主键索引表索索引引名名字字段段PK_ICDeviceRunEntry_280F93DFFEntryIDIX_FDeviceIDFIDIX_FIDFIndex触发器表触触发发器器名名描描述述返回设备管理系统目录表结构字字段段名名类类型型描描述述FPlanRepairManHourFLOAT计划维修工时FClassTypeIDINTEGER事务类型FDeviceIDINTEGER设备代码FDeviceTypeINTEGER设备类型FForbiddenINTEGER禁用状态FIDINTEGER内码FPeriodUnitINTEGER周期单位FPlanStopManHourFLOAT计划停机工时FRepairCatgINTEGER维修类别FTimeUnitINTEGER时间单位FNoteSTRING备注FPeriodFLOAT维修周期FRepairNameSTRING维修名称FRepairNumberSTRING维修代码键表键键名名类类型型PK_ICDeviceRepairDa_3381468B主键索引表索索引引名名字字段段PK_ICDeviceRepairDa_3381468BFIDIX_