{"text_format":"2","workbook":"xlsx","n_sheets":111,"sheets":["目录","码表字典","set_app_edition","set_bill_type","set_code_rule","set_code_rules","set_default_setting","set_default_settings","set_field_setting","set_print_setting","set_system_setting","set_table_filter_plan","set_table_filter_plans","set_table_info","set_table_info_role","set_table_infos","sys_auto_code_part","sys_auto_code_result","sys_auto_code_rule","sys_attachment","base_customer","base_department","base_employee","base_extend","base_extend_class","base_location","base_material","base_material_class","base_package","base_pallet","base_supplier","base_unit","base_warehouse","md_product_bom","md_product_sop","md_workshop","md_workstation","md_workstation_machine","md_workstation_tool","md_workstation_worker","wms_task_change","wms_task_changes","wms_task_check","wms_task_checks","wms_task_in","wms_task_ins","wms_task_move","wms_task_moves","wms_task_out","wms_task_outs","wms_task_user","wms_label","wms_lock","wms_stock_change","wms_stock_changes","wms_stock_check","wms_stock_checks","wms_stock_in","wms_stock_ins","wms_stock_move","wms_stock_moves","wms_stock_out","wms_stock_outs","wms_current_stock","wms_initial_stock","dv_check_machinery","dv_check_plan","dv_check_record","dv_check_subject","dv_machinery","dv_machinery_type","dv_repair","dv_repair_line","dv_subject","tm_tool","tm_tool_type","pro_feedback","pro_process","pro_process_content","pro_route","pro_route_process","pro_route_product","pro_route_product_bom","pro_task","pro_task_issue","pro_trans_consume","pro_trans_order","pro_user_workstation","pro_workorder","pro_workorder_bom","pro_workrecord","qc_defect","qc_defect_photo","qc_defect_record","qc_index","qc_ipqc","qc_ipqc_line","qc_iqc","qc_iqc_line","qc_oqc","qc_oqc_line","qc_template","qc_template_index","qc_template_product","cal_holiday","cal_plan","cal_plan_team","cal_shift","cal_team","cal_teamshift","cal_team_member"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"目录","index":0,"n_rows":111,"n_cols":9,"rows_kept":111,"cut":false,"hidden":false,"merged":[[0,6,0,8]]}
[{"$nulls":6},"PDManer[元数建模]数据表结构"]
["主题域","模块ID","序号","#","表小号","组合序号","数据表代码","显示名称","备注"]
["10-系统设置",10,"001",1,"01",{"$f":"B3&\"_\"&E3&\"_\"&C3","v":"10_01_001"},"set_app_edition","app版本设置",""]
[null,10,"002",2,"02",{"$f":"B4&\"_\"&E4&\"_\"&C4","v":"10_02_002"},"set_bill_type","单据类型设置",""]
[null,10,"003",3,"03","10_03_003","set_code_rule","编号规则设置主",""]
[null,10,"004",4,"04","10_04_004","set_code_rules","编号规则设置子",""]
[null,10,"005",5,"05","10_05_005","set_default_setting","默认值设置主",""]
[null,10,"006",6,"06","10_06_006","set_default_settings","默认值设置子",""]
[null,10,"007",7,"07","10_07_007","set_field_setting","字段设置",""]
[null,10,"008",8,"08","10_08_008","set_print_setting","打印设置",""]
[null,10,"009",9,"09","10_09_009","set_system_setting","参数设置",""]
[null,10,"010",10,"10","10_10_010","set_table_filter_plan","过滤方案主表","高级筛选"]
[null,10,"011",11,"11","10_11_011","set_table_filter_plans","过滤方案子表","高级筛选"]
[null,10,"012",12,"12","10_12_012","set_table_info","表格设计主表","高级筛选"]
[null,10,"013",13,"13","10_13_013","set_table_infos","表格设计子表","高级筛选"]
[null,10,"014",14,"14","10_14_014","set_table_info_role","报表权限设置","高级筛选"]
[null,10,"015",15,"15","10_15_015","sys_auto_code_part","编码生成规则组成表","MES编码规则"]
[null,10,"016",16,"16","10_16_016","sys_auto_code_result","编码生成记录表",""]
[null,10,"017",17,"17","10_17_017","sys_auto_code_rule","编码生成规则表",""]
[null,10,"018",18,"18","10_18_018","sys_attachment","附件表","暂时没有使用，孙一石说，后续可以根据附件服务器做设置"]
["20-基础设置",20,"019",1,"18","20_18_019","base_customer","客户",""]
[null,20,"020",2,"19","20_19_020","base_department","部门",""]
[null,20,"021",3,"20","20_20_021","base_employee","职员",""]
[null,20,"022",4,"21","20_21_022","base_extend","扩展项",""]
[null,20,"023",5,"22","20_22_023","base_extend_class","扩展项分类",""]
[null,20,"024",6,"23","20_23_024","base_location","货位",""]
[null,20,"025",7,"24",{"$f":"B27&\"_\"&E27&\"_\"&C27","v":"20_24_025"},"base_material","物料",""]
[null,20,"026",8,"25","20_25_026","base_material_class","物料分类",""]
[null,20,"027",9,"26","20_26_027","base_package","包装",""]
[null,20,"028",10,"27","20_27_028","base_pallet","托盘",""]
[null,20,"029",11,"28","20_28_029","base_supplier","供应商",""]
[null,20,"030",12,"29","20_29_030","base_unit","计量单位",""]
[null,20,"031",13,"30","20_30_031","base_warehouse","仓库",""]
[null,20,"032",14,"31","20_31_032","md_product_bom","产品BOM关系表",""]
[null,20,"033",15,"32","20_32_033","md_product_sop","产品SOP表",""]
[null,20,"034",16,"33","20_33_034","md_workshop","车间表",""]
[null,20,"035",17,"34","20_34_035","md_workstation","工作站表",""]
[null,20,"036",18,"35","20_35_036","md_workstation_machine","设备资源表",""]
[null,20,"037",19,"36","20_36_037","md_workstation_tool","工装夹具资源表",""]
[null,20,"038",20,"37","20_37_038","md_workstation_worker","人力资源表","暂时没有使用"]
["30-任务管理",30,"039",1,"38","30_38_039","wms_task_change","转换任务主",""]
[null,30,"040",2,"39","30_39_040","wms_task_changes","转换任务子",""]
[null,30,"041",3,"40","30_40_041","wms_task_check","盘点任务主",""]
[null,30,"042",4,"41","30_41_042","wms_task_checks","盘点任务子",""]
[null,30,"043",5,"42","30_42_043","wms_task_in","入库任务主",""]
[null,30,"044",6,"43","30_43_044","wms_task_ins","入库任务子",""]
[null,30,"045",7,"44","30_44_045","wms_task_move","移位任务主",""]
[null,30,"046",8,"45","30_45_046","wms_task_moves","移位任务子",""]
[null,30,"047",9,"46","30_46_047","wms_task_out","出库任务主",""]
[null,30,"048",10,"47","30_47_048","wms_task_outs","出库任务子",""]
[null,30,"049",11,"48","30_48_049","wms_task_user","任务操作者关系表","三友移位任务上指定发货员，并记录在这张表里"]
[null,30,"050",12,"49","30_49_050","wms_label","标签",""]
[null,30,"051",13,"50","30_50_051","wms_lock","冻结",""]
["40-库存管理",40,"052",1,"51","40_51_052","wms_stock_change","转换主",""]
[null,40,"053",2,"52","40_52_053","wms_stock_changes","转换子",""]
[null,40,"054",3,"53","40_53_054","wms_stock_check","盘点主",""]
[null,40,"055",4,"54","40_54_055","wms_stock_checks","盘点子",""]
[null,40,"056",5,"55","40_55_056","wms_stock_in","入库主",""]
[null,40,"057",6,"56","40_56_057","wms_stock_ins","入库子",""]
[null,40,"058",7,"57","40_57_058","wms_stock_move","移位主",""]
[null,40,"059",8,"58","40_58_059","wms_stock_moves","移位子",""]
[null,40,"060",9,"59","40_59_060","wms_stock_out","出库主",""]
[null,40,"061",10,"60","40_60_061","wms_stock_outs","出库子",""]
[null,40,"062",11,"61","40_61_062","wms_current_stock","现存量",""]
[null,40,"063",12,"62","40_62_063","wms_initial_stock","期初",""]
["61-设备管理",61,"064",1,"63","61_63_064","dv_check_machinery","点检设备表",""]
[null,61,"065",2,"64","61_64_065","dv_check_plan","设备点检保养计划头表",""]
[null,61,"066",3,"65",{"$f":"B68&\"_\"&E68&\"_\"&C68","v":"61_65_066"},"dv_check_record","设备点检记录_陈志强",""]
[null,61,"067",4,"66","61_66_067","dv_check_subject","点检项目表",""]
[null,61,"068",5,"67","61_67_068","dv_machinery","设备表",""]
[null,61,"069",6,"68","61_68_069","dv_machinery_type","设备类型表",""]
[null,61,"070",7,"69","61_69_070","dv_repair","设备维修单",""]
[null,61,"071",8,"70","61_70_071","dv_repair_line","设备维修单行",""]
[null,61,"072",9,"71","61_71_072","dv_subject","设备点检保养项目表",""]
["62-工装夹具",62,"073",1,"72","62_72_073","tm_tool","工装夹具清单表",""]
[null,62,"074",2,"73","62_73_074","tm_tool_type","工装夹具类型表",""]
["70-生产管理",70,"075",1,"74","70_74_075","pro_feedback","生产报工记录表",""]
[null,70,"076",2,"75","70_75_076","pro_process","生产工序表",""]
[null,70,"077",3,"76","70_76_077","pro_process_content","生产工序内容表",""]
[null,70,"078",4,"77","70_77_078","pro_route","工艺路线表",""]
[null,70,"079",5,"78","70_78_079","pro_route_process","工艺组成表",""]
[null,70,"080",6,"79","70_79_080","pro_route_product","产品制程",""]
[null,70,"081",7,"80","70_80_081","pro_route_product_bom","产品制程物料BOM表",""]
[null,70,"082",8,"81","70_81_082","pro_task","生产任务表",""]
[null,70,"083",9,"82","70_82_083","pro_task_issue","生产任务投料表",""]
[null,70,"084",10,"83","70_83_084","pro_trans_consume","物料消耗记录表",""]
[null,70,"085",11,"84","70_84_085","pro_trans_order","流转单表",""]
[null,70,"086",12,"85","70_85_086","pro_user_workstation","用户工作站绑定关系",""]
[null,70,"087",13,"86","70_86_087","pro_workorder","生产工单表",""]
[null,70,"088",14,"87","70_87_088","pro_workorder_bom","生产工单BOM组成表",""]
[null,70,"089",15,"88","70_88_089","pro_workrecord","上下工记录表",""]
["71-质量管理",71,"090",1,"89","71_89_090","qc_defect","常见缺陷表",""]
[null,71,"091",2,"90","71_90_091","qc_defect_photo","检测记录照片表",""]
[null,71,"092",3,"91","71_91_092","qc_defect_record","检验单缺陷记录表",""]
[null,71,"093",4,"92","71_92_093","qc_index","检测项表",""]
[null,71,"094",5,"93","71_93_094","qc_ipqc","过程检验单表",""]
[null,71,"095",6,"94","71_94_095","qc_ipqc_line","过程检验单行表",""]
[null,71,"096",7,"95","71_95_096","qc_iqc","来料检验单表",""]
[null,71,"097",8,"96","71_96_097","qc_iqc_line","来料检验单行表",""]
[null,71,"098",9,"97","71_97_098","qc_oqc","出货检验单表",""]
[null,71,"099",10,"98","71_98_099","qc_oqc_line","出货检验单行表",""]
[null,71,"100",11,"99","71_99_100","qc_template","检测模板表",""]
[null,71,"101",12,"100","71_100_101","qc_template_index","检测模板-检测项表",""]
[null,71,"102",13,"101","71_101_102","qc_template_product","检测模板-产品表",""]
["72-排班管理",72,"103",1,"102","72_102_103","cal_holiday","节假日设置",""]
[null,72,"104",2,"103","72_103_104","cal_plan","排班计划表",""]
[null,72,"105",3,"104","72_104_105","cal_plan_team","计划班组表",""]
[null,72,"106",4,"105","72_105_106","cal_shift","计划班次表",""]
[null,72,"107",5,"106","72_106_107","cal_team","班组表",""]
[null,72,"108",6,"107","72_107_108","cal_teamshift","班组排班表",""]
[null,72,"109",7,"108","72_108_109","cal_team_member","班组成员表",""]

{"sheet":"码表字典","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["PDManer[元数建模]码表字典"]
["主题域","字典代码","显示名称","#","条目代码","条目显示名称","排序码","父条目代码","条目描述"]
["10-系统设置"]
["20-基础设置"]
["30-任务管理"]
["40-库存管理"]
["61-设备管理"]
["62-工装夹具"]
["70-生产管理"]
["71-质量管理"]
["72-排班管理"]
["default-默认主题域"]

{"sheet":"set_app_edition","index":2,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_app_edition"]
[null,"显示名称","app版本设置"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"describe","提示信息","VARCHAR",255,null,null,null,"","",""]
[3,"edition_url","apk、wgt包下载地址或者应用市场地址","VARCHAR",255,null,null,null,"","",""]
[4,"edition_force","是否强制更新 0代表否 1代表是","INT",{"$nulls":4},"","",""]
[5,"package_type","0是整包升级（apk或者appstore或者安卓应用市场） 1是wgt升级","INT",{"$nulls":4},"","",""]
[6,"edition_issue","是否发行  0否 1是 为了控制上架应用市场审核时不能弹出热更新框","INT",{"$nulls":4},"","",""]
[7,"edition_number","版本号 最重要的manifest里的版本号 （检查更新主要以服务器返回的edition_number版本号是否大于当前app的版本号来实现是否更新）","INT",{"$nulls":4},"","",""]
[8,"edition_name","版本名称 manifest里的版本名称","VARCHAR",50,null,null,null,"","",""]
[9,"edition_silence","是否静默更新 0代表否 1代表是","INT",{"$nulls":4},"","",""]
[10,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[11,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[12,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[13,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[14,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[15,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"set_bill_type","index":3,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_bill_type"]
[null,"显示名称","单据类型设置"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"bill_code","单据编码","VARCHAR",50,null,null,"√","","",""]
[3,"bill_type_code","单据类型编码","VARCHAR",50,null,null,"√","","",""]
[4,"bill_type_name","单据类型名称","VARCHAR",50,null,null,null,"","",""]
[5,"is_enable_app","是否启用app(0是 1否)","INT",{"$nulls":4},"1","",""]
[6,"is_control_task","保存是否控制任务数量(0是 1否)","INT",{"$nulls":4},"","",""]
[7,"is_control_task_audit","审核是否控制任务数量(0是 1否)","INT",{"$nulls":4},"","",""]
[8,"task_bill_type_code","任务单据类型编码","VARCHAR",50,null,null,null,"","",""]
[9,"back_task_bill_type_code","任务退单据类型编码","VARCHAR",50,null,null,null,"","",""]
[10,"stock_bill_type_code","库存单据类型编码","VARCHAR",50,null,null,null,"","",""]
[11,"interface_name","接口名称","VARCHAR",50,null,null,null,"","",""]
[12,"interface_type","接口类型","VARCHAR",50,null,null,null,"","",""]
[13,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[14,"setting_sort","设置排序","VARCHAR",50,null,null,null,"","",""]
[15,"setting_describe","描述","VARCHAR",255,null,null,null,"","",""]

{"sheet":"set_code_rule","index":4,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_code_rule"]
[null,"显示名称","编号规则设置主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"auto_code","编号规则编码","VARCHAR",20,null,null,null,"","",""]
[3,"prefix_value","前缀值","VARCHAR",100,null,null,null,"","",""]
[4,"sequence_reset","序号重置","CHAR",50,null,null,null,"","",""]
[5,"sequence_length","序号长度","BIGINT",{"$nulls":4},"","",""]
[6,"step_value","步长","BIGINT",{"$nulls":4},"","",""]
[7,"suffix_value","后缀值","VARCHAR",6,null,null,null,"","",""]
[8,"current_value","当前值","DECIMAL",10,null,null,null,"","",""]
[9,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[10,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[11,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[12,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[13,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[14,"remark","备注","VARCHAR",500,null,null,null,"","",""]

{"sheet":"set_code_rules","index":5,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_code_rules"]
[null,"显示名称","编号规则设置子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"code_rule_id","主表标识","INT",null,null,null,"√","","",""]
[3,"perfix_values","前缀值","VARCHAR",100,null,null,null,"","",""]
[4,"entry_values","当前值","BIGINT",{"$nulls":4},"","",""]

{"sheet":"set_default_setting","index":6,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_default_setting"]
[null,"显示名称","默认值设置主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","CHAR",20,null,"√","√","","",""]
[2,"bill_code","单据编码","VARCHAR",50,null,null,null,"","",""]
[3,"bill_type_code","单据类型编码","VARCHAR",50,null,null,null,"","",""]
[4,"userid","用户内码","INT",{"$nulls":4},"","",""]
[5,"setting_class","设置类型(1系统2通用3个人4特殊)","VARCHAR",50,null,null,null,"","",""]
[6,"setting_sort","排序","INT",{"$nulls":4},"","",""]
[7,"setting_describe","描述","VARCHAR",255,null,null,null,"","",""]

{"sheet":"set_default_settings","index":7,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_default_settings"]
[null,"显示名称","默认值设置子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","CHAR",20,null,"√","√","","",""]
[2,"default_setting_id","主表标识","CHAR",20,null,null,null,"","",""]
[3,"setting_flag","设置标志","VARCHAR",50,null,null,null,"","",""]
[4,"setting_code","设置编码","VARCHAR",50,null,null,null,"","",""]
[5,"setting_name","设置名称","VARCHAR",50,null,null,null,"","",""]
[6,"setting_values","设置值列表","VARCHAR",2000,null,null,null,"","",""]

{"sheet":"set_field_setting","index":8,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_field_setting"]
[null,"显示名称","字段设置"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"bill_code","单据编码","VARCHAR",50,null,null,null,"","",""]
[3,"field","字段","VARCHAR",50,null,null,null,"","",""]
[4,"field_name","字段名称","VARCHAR",50,null,null,null,"","",""]
[5,"field_type","字段类型","VARCHAR",50,null,null,null,"","",""]
[6,"multiple","多选(1是 0否)","INT",{"$nulls":4},"","",""]
[7,"width","宽度","VARCHAR",50,null,null,null,"","",""]
[8,"required","必录(1是 0否)","INT",null,null,null,"√","0","",""]
[9,"required_condition","必录条件","VARCHAR",255,null,null,null,"","",""]
[10,"hidden","隐藏(1是 0否)","INT",null,null,null,"√","0","",""]
[11,"hidden_condition","隐藏条件","VARCHAR",255,null,null,null,"","",""]
[12,"setting_sort","排序","VARCHAR",50,null,null,null,"","",""]
[13,"setting_describe","描述","VARCHAR",255,null,null,null,"","",""]
[14,"flag","基础资料标志","VARCHAR",50,null,null,null,"","",""]
[15,"key_name","显示名","VARCHAR",50,null,null,null,"","",""]
[16,"key_code","实际名","VARCHAR",50,null,null,null,"","",""]
[17,"query_data","传参","VARCHAR",255,null,null,null,"","",""]
[18,"defaults","默认值(1是 0否)","INT",{"$nulls":4},"","",""]

{"sheet":"set_print_setting","index":9,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_print_setting"]
[null,"显示名称","打印设置"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"bill_code","单据编码","VARCHAR",50,null,null,null,"","",""]
[3,"print_template","打印模板","VARCHAR",255,null,null,null,"","",""]
[4,"print_interface","打印接口","VARCHAR",255,null,null,null,"","",""]
[5,"setting_sort","设置排序","VARCHAR",50,null,null,null,"","",""]
[6,"setting_describe","描述","VARCHAR",255,null,null,null,"","",""]

{"sheet":"set_system_setting","index":10,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_system_setting"]
[null,"显示名称","系统设置"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"setting_class","设置分类","VARCHAR",50,null,null,null,"","",""]
[3,"setting_code","设置编码","VARCHAR",50,null,null,null,"","",""]
[4,"setting_name","设置名称","VARCHAR",50,null,null,null,"","",""]
[5,"setting_values","设置值","VARCHAR",255,null,null,null,"","",""]
[6,"setting_sort","设置排序","VARCHAR",50,null,null,null,"","",""]
[7,"setting_describe","描述","VARCHAR",255,null,null,null,"","",""]

{"sheet":"set_table_filter_plan","index":11,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_table_filter_plan"]
[null,"显示名称","过滤方案主表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","","CHAR",20,null,"√","√","","",""]
[2,"plan_name","方案名称","VARCHAR",50,null,null,null,"","",""]
[3,"bill_code","vue组件名称","VARCHAR",50,null,null,null,"","",""]
[4,"page_num","每页数量","INT",{"$nulls":4},"","",""]
[5,"page_size","页码","INT",{"$nulls":4},"","",""]
[6,"user_id","关联用户内码","INT",{"$nulls":4},"","",""]
[7,"sort","排序","INT",{"$nulls":4},"","",""]
[8,"status","状态 0生效 10删除","INT",{"$nulls":4},"","",""]
[9,"is_default","是否默认 0是默认","INT",{"$nulls":4},"","",""]

{"sheet":"set_table_filter_plans","index":12,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_table_filter_plans"]
[null,"显示名称","过滤方案子表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","","INT",null,null,"√","√","","",""]
[2,"plan_id","主表id","CHAR",20,null,null,null,"","",""]
[3,"left_bracket","左括弧","CHAR",10,null,null,null,"","",""]
[4,"query_field_name","字段中文名","VARCHAR",255,null,null,null,"","",""]
[5,"query_field_alias","字段别名","VARCHAR",255,null,null,null,"","",""]
[6,"field_type","字段类型","VARCHAR",50,null,null,null,"","",""]
[7,"filter_type","过滤类型","VARCHAR",50,null,null,null,"","",""]
[8,"query_value","值","VARCHAR",255,null,null,null,"","",""]
[9,"query_value2","值2","VARCHAR",255,null,null,null,"","",""]
[10,"right_bracket","右括弧","CHAR",10,null,null,null,"","",""]
[11,"operator_type","操作符类型","CHAR",50,null,null,null,"","",""]
[12,"field_sort","字段排序","INT",{"$nulls":4},"","",""]

{"sheet":"set_table_info","index":13,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_table_info"]
[null,"显示名称","表格设计主表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","主表标识","CHAR",20,null,"√","√","","",""]
[2,"bill_code","单据编码","VARCHAR",50,null,null,null,"","",""]
[3,"bill_name","单据名称","VARCHAR",50,null,null,null,"","",""]
[4,"sql_query","sql","TEXT",{"$nulls":4},"","",""]
[5,"sql_paged_query","分页sql","TEXT",{"$nulls":4},"","",""]
[6,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[7,"report_type","1普通表 0系统表","INT",{"$nulls":4},"","",""]
[8,"dept_alias","部门权限表别名","VARCHAR",50,null,null,null,"","",""]
[9,"user_alias","用户权限表别名","VARCHAR",50,null,null,null,"","",""]

{"sheet":"set_table_info_role","index":14,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_table_info_role"]
[null,"显示名称","报表权限设置"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"table_info_id","用户ID","CHAR",20,null,"√","√","","",""]
[2,"role_id","角色ID","BIGINT",null,null,"√","√","","",""]

{"sheet":"set_table_infos","index":15,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","set_table_infos"]
[null,"显示名称","表格设计子表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","子表标识","INT",null,null,"√","√","","",""]
[2,"info_id","主表标识","CHAR",20,null,null,"√","","",""]
[3,"query_table","查询表","VARCHAR",50,null,null,null,"","",""]
[4,"query_field","查询字段","VARCHAR",500,null,null,null,"","",""]
[5,"query_field_alias","字段别名","VARCHAR",50,null,null,null,"","",""]
[6,"query_field_name","字段中文名","VARCHAR",255,null,null,null,"","",""]
[7,"field_type","字段类型","VARCHAR",50,null,null,null,"","",""]
[8,"column_width","字段宽度","INT",{"$nulls":4},"","",""]
[9,"parameter","存储值对应的where条件","VARCHAR",200,null,null,null,"","",""]
[10,"basic_flag","基础资料标志","VARCHAR",50,null,null,null,"","",""]
[11,"basic_value","基础资料取值字段","VARCHAR",50,null,null,null,"","",""]
[12,"basic_query_data","基础资料传参","VARCHAR",255,null,null,null,"","",""]
[13,"filter_status","筛选状态(0(显示)、1(可选显示)、2(不显示)、10(不筛选))","INT",{"$nulls":4},"","",""]
[14,"is_date_control","0不启用 1启用(列表默认显示最近30天数据)","INT",{"$nulls":4},"","",""]
[15,"status","0生效 1失效","INT",{"$nulls":4},"","",""]

{"sheet":"sys_auto_code_part","index":16,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","sys_auto_code_part"]
[null,"显示名称","编码生成规则组成表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"part_id","分段ID","BIGINT",null,null,"√","√","","",""]
[2,"rule_id","规则ID","BIGINT",null,null,null,"√","","",""]
[3,"part_index","分段序号","INT",null,null,null,"√","","",""]
[4,"part_type","分段类型，INPUTCHAR：输入字符，NOWDATE：当前日期时间，FIXCHAR：固定字符，SERIALNO：流水号","VARCHAR",20,null,null,"√","","",""]
[5,"part_code","分段编号","VARCHAR",64,null,null,null,"","",""]
[6,"part_name","分段名称","VARCHAR",255,null,null,null,"","",""]
[7,"part_length","分段长度","INT",null,null,null,"√","","",""]
[8,"date_format","","VARCHAR",20,null,null,null,"","",""]
[9,"input_character","输入字符","VARCHAR",64,null,null,null,"","",""]
[10,"fix_character","固定字符","VARCHAR",64,null,null,null,"","",""]
[11,"seria_start_no","流水号起始值","INT",{"$nulls":4},"","",""]
[12,"seria_step","流水号步长","INT",{"$nulls":4},"","",""]
[13,"seria_now_no","流水号当前值","INT",{"$nulls":4},"","",""]
[14,"cycle_flag","流水号是否循环","CHAR",1,null,null,null,"","",""]
[15,"cycle_method","循环方式，YEAR：按年，MONTH：按月，DAY：按天，HOUR：按小时，MINITE：按分钟，OTHER：按传入字符变","VARCHAR",20,null,null,null,"","",""]
[16,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[17,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[18,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[19,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[20,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[21,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[22,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[23,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[24,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"sys_auto_code_result","index":17,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","sys_auto_code_result"]
[null,"显示名称","编码生成记录表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"code_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"rule_id","规则ID","BIGINT",null,null,null,"√","","",""]
[3,"gen_date","生成日期时间","VARCHAR",20,null,null,"√","","",""]
[4,"gen_index","最后产生的序号","INT",{"$nulls":4},"","",""]
[5,"last_result","最后产生的值","VARCHAR",64,null,null,null,"","",""]
[6,"last_serial_no","最后产生的流水号","INT",{"$nulls":4},"","",""]
[7,"last_input_char","最后传入的参数","VARCHAR",64,null,null,null,"","",""]
[8,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[9,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[10,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[11,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[12,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[13,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[14,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[15,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[16,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"sys_auto_code_rule","index":18,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","sys_auto_code_rule"]
[null,"显示名称","编码生成规则表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"rule_id","规则ID","BIGINT",null,null,"√","√","","",""]
[2,"rule_code","规则编码","VARCHAR",64,null,null,"√","","",""]
[3,"rule_name","规则名称","VARCHAR",255,null,null,"√","","",""]
[4,"rule_desc","描述","VARCHAR",500,null,null,null,"","",""]
[5,"max_length","最大长度","INT",{"$nulls":4},"","",""]
[6,"is_padded","是否补齐","CHAR",1,null,null,"√","","",""]
[7,"padded_char","补齐字符","VARCHAR",20,null,null,null,"","",""]
[8,"padded_method","补齐方式","CHAR",1,null,null,null,"'L'","",""]
[9,"enable_flag","是否启用","CHAR",1,null,null,"√","'Y'","",""]
[10,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[11,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[12,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[13,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[14,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[15,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[16,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[17,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[18,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"sys_attachment","index":19,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","sys_attachment"]
[null,"显示名称","附件表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"attachment_id","附件ID","BIGINT",null,null,"√","√","","",""]
[2,"source_doc_id","关联的业务单据ID","BIGINT",{"$nulls":4},"","",""]
[3,"source_doc_type","业务单据类型","VARCHAR",64,null,null,null,"","",""]
[4,"file_url","访问URL","VARCHAR",255,null,null,"√","","",""]
[5,"base_path","域名","VARCHAR",64,null,null,null,"","",""]
[6,"file_name","文件名","VARCHAR",255,null,null,null,"","",""]
[7,"orignal_name","原来的文件名","VARCHAR",255,null,null,null,"","",""]
[8,"file_type","文件类型","VARCHAR",64,null,null,null,"","",""]
[9,"file_size","文件大小","DOUBLE",12,2,null,null,"","",""]
[10,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[11,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[12,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[13,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[14,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[15,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[16,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[17,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[18,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"base_customer","index":20,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_customer"]
[null,"显示名称","客户"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"customer_code","客户编码","VARCHAR",50,null,null,null,"","",""]
[3,"customer_name","客户名称","VARCHAR",100,null,null,null,"","",""]
[4,"customer_short_name","客户简称","VARCHAR",100,null,null,null,"","",""]
[5,"customer_describe","描述","VARCHAR",255,null,null,null,"","",""]
[6,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[7,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[8,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[9,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[10,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[11,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[12,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[13,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_department","index":21,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_department"]
[null,"显示名称","部门"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"parent_id","父级标识","INT",{"$nulls":4},"","",""]
[3,"dept_code","部门编码","VARCHAR",50,null,null,null,"","",""]
[4,"dept_name","部门名称","VARCHAR",50,null,null,null,"","",""]
[5,"dept_describe","描述","VARCHAR",255,null,null,null,"","",""]
[6,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[7,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[8,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[9,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[10,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[11,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[12,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[13,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_employee","index":22,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_employee"]
[null,"显示名称","职员"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"dept_code","部门编码","VARCHAR",50,null,null,null,"","",""]
[3,"employee_code","职员编码","VARCHAR",50,null,null,null,"","",""]
[4,"employee_name","职员名称","VARCHAR",50,null,null,null,"","",""]
[5,"employee_describe","描述","VARCHAR",255,null,null,null,"","",""]
[6,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[7,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[8,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[9,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[10,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[11,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[12,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[13,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_extend","index":23,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_extend"]
[null,"显示名称","扩展项"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"extend_class_id","扩展项分类标识","INT",{"$nulls":4},"","",""]
[3,"extend_class_code","扩展项分类编码","VARCHAR",50,null,null,null,"","",""]
[4,"extend_code","扩展项编码","VARCHAR",50,null,null,null,"","",""]
[5,"extend_name","扩展项名称","VARCHAR",50,null,null,null,"","",""]
[6,"extend_describe","描述","VARCHAR",255,null,null,null,"","",""]
[7,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[8,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[9,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[10,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[11,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[12,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[13,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[14,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_extend_class","index":24,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_extend_class"]
[null,"显示名称","扩展项分类"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"parent_id","父级标识","INT",{"$nulls":4},"","",""]
[3,"ancestors","祖级列表","VARCHAR",255,null,null,null,"","",""]
[4,"extend_class_code","扩展项分类编码","VARCHAR",50,null,null,null,"","",""]
[5,"extend_class_name","扩展项分类名称","VARCHAR",50,null,null,null,"","",""]
[6,"extend_class_describe","描述","VARCHAR",255,null,null,null,"","",""]
[7,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[8,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[9,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[10,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[11,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[12,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[13,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[14,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_location","index":25,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_location"]
[null,"显示名称","货位"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"warehouse_code","仓库编码","VARCHAR",50,null,null,null,"","",""]
[3,"location_code","货位编码","VARCHAR",50,null,null,null,"","",""]
[4,"location_name","货位名称","VARCHAR",50,null,null,null,"","",""]
[5,"location_describe","描述","VARCHAR",255,null,null,null,"","",""]
[6,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[7,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[8,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[9,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[10,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[11,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[12,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[13,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_material","index":26,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_material"]
[null,"显示名称","物料"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"material_class_id","物料分类标识","INT",{"$nulls":4},"","",""]
[3,"material_class_code","物料分类编码","VARCHAR",50,null,null,null,"","",""]
[4,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[5,"material_name","物料名称","VARCHAR",255,null,null,null,"","",""]
[6,"material_specification","物料规格","VARCHAR",255,null,null,null,"","",""]
[7,"item_or_product","产品物料标识","VARCHAR",20,null,null,null,"","",""]
[8,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[9,"secondary_unit_code","辅计量单位编码","VARCHAR",50,null,null,null,"","",""]
[10,"secondary_rate","辅计量转换率","DOUBLE",24,6,null,null,"","",""]
[11,"is_batch","批号管理(0是1否)","INT",null,null,null,"√","0","",""]
[12,"is_package","包装管理(0是1否)","INT",null,null,null,"√","1","",""]
[13,"is_pallet","托盘管理(0是1否)","INT",null,null,null,"√","1","",""]
[14,"collect_type","领料类型(1直接 2倒冲)","INT",null,null,null,"√","1","",""]
[15,"quality_day","保质期","DOUBLE",24,6,null,null,"","",""]
[16,"label_standard_quantity","标签标准量","DOUBLE",24,6,null,null,"","",""]
[17,"max_stock_quantity","最高储","DOUBLE",24,6,null,null,"","",""]
[18,"min_stock_quantity","最低储","DOUBLE",24,6,null,null,"","",""]
[19,"excess_ratio_in","超入库比例%","DOUBLE",24,6,null,null,"","",""]
[20,"excess_ratio_out","超出库比例%","DOUBLE",24,6,null,null,"","",""]
[21,"net_weight","净重","DOUBLE",24,6,null,null,"","",""]
[22,"material_quality","材质","VARCHAR",50,null,null,null,"","",""]
[23,"warehouse_code_in","入库仓库编码","VARCHAR",50,null,null,null,"","",""]
[24,"warehouse_code_out","出库仓库编码","VARCHAR",50,null,null,null,"","",""]
[25,"location_code_in","入库货位编码","VARCHAR",50,null,null,null,"","",""]
[26,"location_code_out","出库货位编码","VARCHAR",50,null,null,null,"","",""]
[27,"material_description","描述","VARCHAR",255,null,null,null,"","",""]
[28,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[29,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[30,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[31,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[32,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]
[33,"extend_code06","扩展编码06","VARCHAR",150,null,null,null,"","",""]
[34,"extend_code07","扩展编码07","VARCHAR",150,null,null,null,"","",""]
[35,"extend_code08","扩展编码08","VARCHAR",150,null,null,null,"","",""]
[36,"extend_code09","扩展编码09","VARCHAR",150,null,null,null,"","",""]
[37,"extend_code10","扩展编码10","VARCHAR",150,null,null,null,"","",""]
[38,"extend_code11","扩展编码11","VARCHAR",150,null,null,null,"","",""]
[39,"extend_code12","扩展编码12","VARCHAR",150,null,null,null,"","",""]
[40,"extend_code13","扩展编码13","VARCHAR",150,null,null,null,"","",""]
[41,"extend_code14","扩展编码14","VARCHAR",150,null,null,null,"","",""]
[42,"extend_code15","扩展编码15","VARCHAR",150,null,null,null,"","",""]
[43,"extend_code16","扩展编码16","VARCHAR",150,null,null,null,"","",""]
[44,"extend_code17","扩展编码17","VARCHAR",150,null,null,null,"","",""]
[45,"extend_code18","扩展编码18","VARCHAR",150,null,null,null,"","",""]
[46,"extend_code19","扩展编码19","VARCHAR",150,null,null,null,"","",""]
[47,"extend_code20","扩展编码20","VARCHAR",150,null,null,null,"","",""]
[48,"attachments","附件","VARCHAR",255,null,null,null,"","",""]
[49,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[50,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[51,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[52,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[53,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[54,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[55,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[56,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_material_class","index":27,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_material_class"]
[null,"显示名称","物料分类"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"parent_id","父级标识","INT",{"$nulls":4},"","",""]
[3,"ancestors","祖级列表","VARCHAR",255,null,null,null,"","",""]
[4,"material_class_code","物料分类编码","VARCHAR",50,null,null,null,"","",""]
[5,"material_class_name","物料分类名称","VARCHAR",50,null,null,null,"","",""]
[6,"item_or_product","产品物料标识","VARCHAR",20,null,null,null,"","",""]
[7,"material_level","物料等级","INT",{"$nulls":4},"","",""]
[8,"material_end","物料末级","INT",{"$nulls":4},"","",""]
[9,"material_class_describe","描述","VARCHAR",255,null,null,null,"","",""]
[10,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[11,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[12,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[13,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[14,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[15,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[16,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[17,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_package","index":28,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_package"]
[null,"显示名称","包装"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"package_code","包装编码","VARCHAR",50,null,null,null,"","",""]
[3,"package_name","包装编码","VARCHAR",50,null,null,null,"","",""]
[4,"package_describe","描述","VARCHAR",255,null,null,null,"","",""]
[5,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[6,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[7,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[8,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[9,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[10,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[11,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[12,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_pallet","index":29,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_pallet"]
[null,"显示名称","托盘"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"pallet_code","托盘编码","VARCHAR",50,null,null,null,"","",""]
[3,"pallet_name","托盘名称","VARCHAR",50,null,null,null,"","",""]
[4,"pallet_describe","描述","VARCHAR",255,null,null,null,"","",""]
[5,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[6,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[7,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[8,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[9,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[10,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[11,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[12,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_supplier","index":30,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_supplier"]
[null,"显示名称","供应商"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"supplier_code","供应商编码","VARCHAR",50,null,null,null,"","",""]
[3,"supplier_name","供应商名称","VARCHAR",100,null,null,null,"","",""]
[4,"supplier_short_name","供应商简称","VARCHAR",100,null,null,null,"","",""]
[5,"supplier_describe","描述","VARCHAR",255,null,null,null,"","",""]
[6,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[7,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[8,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[9,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[10,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[11,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[12,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[13,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_unit","index":31,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_unit"]
[null,"显示名称","单位"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[3,"unit_name","单位名称","VARCHAR",50,null,null,null,"","",""]
[4,"unit_description","描述","VARCHAR",255,null,null,null,"","",""]
[5,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[6,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[7,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[8,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[9,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[10,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[11,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[12,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"base_warehouse","index":32,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","base_warehouse"]
[null,"显示名称","仓库"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"parent_id","父级标识","INT",{"$nulls":4},"","",""]
[3,"warehouse_code","仓库编码","VARCHAR",50,null,null,null,"","",""]
[4,"warehouse_name","仓库名称","VARCHAR",50,null,null,null,"","",""]
[5,"warehouse_describe","描述","VARCHAR",255,null,null,null,"","",""]
[6,"is_location","货位管理(0否1是)","INT",null,null,null,"√","0","",""]
[7,"status","状态(0有效 1无效)","INT",null,null,null,"√","0","",""]
[8,"inactive_time","失效时间","DATETIME",{"$nulls":4},"","",""]
[9,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[10,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[11,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[12,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[13,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[14,"remark","备注","VARCHAR",255,null,null,null,"","",""]

{"sheet":"md_product_bom","index":33,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","md_product_bom"]
[null,"显示名称","产品BOM关系表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"bom_id","流水号","BIGINT",null,null,"√","√","","",""]
[2,"item_id","物料产品ID","BIGINT",null,null,null,"√","","",""]
[3,"bom_item_id","BOM物料ID","BIGINT",null,null,null,"√","","",""]
[4,"bom_item_code","BOM物料编码","VARCHAR",64,null,null,"√","","",""]
[5,"bom_item_name","BOM物料名称","VARCHAR",255,null,null,"√","","",""]
[6,"bom_item_spec","BOM物料规格","VARCHAR",500,null,null,null,"","",""]
[7,"unit_of_measure","BOM物料单位","VARCHAR",64,null,null,"√","","",""]
[8,"item_or_product","产品物料标识","VARCHAR",20,null,null,"√","","",""]
[9,"quantity","物料使用比例","DOUBLE",12,4,null,"√","0.0000","",""]
[10,"enable_flag","是否启用","CHAR",1,null,null,"√","'Y'","",""]
[11,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[12,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[13,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[14,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[15,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[16,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[17,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[18,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[19,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"md_product_sop","index":34,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","md_product_sop"]
[null,"显示名称","产品SOP表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"sop_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"item_id","物料产品ID","BIGINT",null,null,null,"√","","",""]
[3,"order_num","排列顺序","INT",{"$nulls":4},"","",""]
[4,"process_id","对应的工序","BIGINT",{"$nulls":4},"","",""]
[5,"process_code","工序编号","VARCHAR",64,null,null,null,"","",""]
[6,"process_name","工序名称","VARCHAR",255,null,null,null,"","",""]
[7,"sop_title","标题","VARCHAR",255,null,null,null,"","",""]
[8,"sop_description","详细描述","VARCHAR",500,null,null,null,"","",""]
[9,"sop_url","图片地址","VARCHAR",255,null,null,null,"","",""]
[10,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[11,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[12,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[13,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[14,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[15,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[16,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[17,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[18,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"md_workshop","index":35,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","md_workshop"]
[null,"显示名称","车间表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"workshop_id","车间ID","BIGINT",null,null,"√","√","","",""]
[2,"workshop_code","车间编码","VARCHAR",64,null,null,"√","","",""]
[3,"workshop_name","车间名称","VARCHAR",255,null,null,"√","","",""]
[4,"area","面积","DOUBLE",12,2,null,null,"","",""]
[5,"charge","负责人","VARCHAR",64,null,null,null,"","",""]
[6,"enable_flag","是否启用","CHAR",1,null,null,"√","'Y'","",""]
[7,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[8,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[9,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[10,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[11,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[12,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[13,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[14,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[15,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"md_workstation","index":36,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","md_workstation"]
[null,"显示名称","工作站表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"workstation_id","工作站ID","BIGINT",null,null,"√","√","","",""]
[2,"workstation_code","工作站编码","VARCHAR",64,null,null,"√","","",""]
[3,"workstation_name","工作站名称","VARCHAR",255,null,null,"√","","",""]
[4,"workstation_address","工作站地点","VARCHAR",255,null,null,null,"","",""]
[5,"workshop_id","所在车间ID","BIGINT",{"$nulls":4},"","",""]
[6,"workshop_code","所在车间编码","VARCHAR",64,null,null,null,"","",""]
[7,"workshop_name","所在车间名称","VARCHAR",255,null,null,null,"","",""]
[8,"process_id","工序ID","BIGINT",{"$nulls":4},"","",""]
[9,"process_code","工序编码","VARCHAR",64,null,null,null,"","",""]
[10,"process_name","工序名称","VARCHAR",255,null,null,null,"","",""]
[11,"warehouse_id","线边库ID","BIGINT",null,null,null,"√","","",""]
[12,"warehouse_code","线边库编码","VARCHAR",64,null,null,null,"","",""]
[13,"warehouse_name","线边库名称","VARCHAR",255,null,null,null,"","",""]
[14,"location_id","库区ID","BIGINT",null,null,null,"√","","",""]
[15,"location_code","库区编码","VARCHAR",64,null,null,null,"","",""]
[16,"location_name","库区名称","VARCHAR",255,null,null,null,"","",""]
[17,"area_id","库位ID","BIGINT",{"$nulls":4},"","",""]
[18,"area_code","库位编码","VARCHAR",64,null,null,null,"","",""]
[19,"area_name","库位名称","VARCHAR",255,null,null,null,"","",""]
[20,"enable_flag","是否启用","CHAR",1,null,null,"√","'Y'","",""]
[21,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[22,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[23,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[24,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[25,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[26,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[27,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[28,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[29,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"md_workstation_machine","index":37,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","md_workstation_machine"]
[null,"显示名称","设备资源表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"workstation_id","工作站ID","BIGINT",null,null,null,"√","","",""]
[3,"machinery_id","设备ID","BIGINT",null,null,null,"√","","",""]
[4,"machinery_code","设备编码","VARCHAR",64,null,null,null,"","",""]
[5,"machinery_name","设备名称","VARCHAR",255,null,null,null,"","",""]
[6,"quantity","数量","INT",{"$nulls":4},"1","",""]
[7,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[8,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[9,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[10,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[11,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[12,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[13,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[14,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[15,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"md_workstation_tool","index":38,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","md_workstation_tool"]
[null,"显示名称","工装夹具资源表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"workstation_id","工作站ID","BIGINT",null,null,null,"√","","",""]
[3,"tool_type_id","工装夹具类型ID","BIGINT",null,null,null,"√","","",""]
[4,"tool_type_code","类型编码","VARCHAR",64,null,null,null,"","",""]
[5,"tool_type_name","类型名称","VARCHAR",255,null,null,null,"","",""]
[6,"quantity","数量","INT",null,null,null,"√","1","",""]
[7,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[8,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[9,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[10,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[11,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[12,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[13,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[14,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[15,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"md_workstation_worker","index":39,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","md_workstation_worker"]
[null,"显示名称","人力资源表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"workstation_id","工作站ID","BIGINT",null,null,null,"√","","",""]
[3,"post_id","岗位ID","BIGINT",null,null,null,"√","","",""]
[4,"post_code","岗位编码","VARCHAR",64,null,null,null,"","",""]
[5,"post_name","岗位名称","VARCHAR",255,null,null,null,"","",""]
[6,"quantity","数量","INT",null,null,null,"√","1","",""]
[7,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[8,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[9,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[10,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[11,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[12,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[13,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[14,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[15,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"wms_task_change","index":40,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_task_change"]
[null,"显示名称","转换任务主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","主表标识","CHAR",20,null,"√","√","","",""]
[2,"task_code","任务编码","VARCHAR",50,null,null,null,"","",""]
[3,"task_date","任务日期","DATE",{"$nulls":4},"","",""]
[4,"bill_type_code","单据类型","VARCHAR",50,null,null,null,"","",""]
[5,"dept_code_out","转出部门编码","VARCHAR",50,null,null,null,"","",""]
[6,"dept_code_in","转入部门编码","VARCHAR",50,null,null,null,"","",""]
[7,"employee_code_out","转出职员编码","VARCHAR",50,null,null,null,"","",""]
[8,"employee_code_in","转入职员编码","VARCHAR",50,null,null,null,"","",""]
[9,"warehouse_code_out","转出仓库编码","VARCHAR",50,null,null,null,"","",""]
[10,"warehouse_code_in","转入仓库编码","VARCHAR",50,null,null,null,"","",""]
[11,"task_describe","描述","VARCHAR",255,null,null,null,"","",""]
[12,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[13,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[14,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[15,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[16,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[17,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[18,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[19,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[20,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[21,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[22,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_task_changes","index":41,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_task_changes"]
[null,"显示名称","转换任务子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","子表标识","CHAR",20,null,"√","√","","",""]
[2,"task_change_id","主表标识","CHAR",20,null,null,"√","","",""]
[3,"row_number","行号","INT",{"$nulls":4},"","",""]
[4,"change_group","转换组别","INT",{"$nulls":4},"","",""]
[5,"change_type","转换类型(1转换前 2转换后)","INT",{"$nulls":4},"","",""]
[6,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[7,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[8,"task_qty","任务数量","DOUBLE",24,6,null,null,"","",""]
[9,"label_qty","已生成标签数量","DOUBLE",24,6,null,null,"","",""]
[10,"stock_qty","已转换数量","DOUBLE",24,6,null,null,"","",""]
[11,"excess_ratio_change","超转换库比例%","DOUBLE",24,6,null,null,"","",""]
[12,"batch1","批号1","VARCHAR",100,null,null,null,"","",""]
[13,"batch2","批号2","VARCHAR",100,null,null,null,"","",""]
[14,"location_code","货位编码","VARCHAR",50,null,null,null,"","",""]
[15,"task_describe","描述","VARCHAR",255,null,null,null,"","",""]
[16,"status","状态(0已审核 1未审核)","INT",null,null,null,"√","1","",""]
[17,"is_close","是否关闭(0是 1否)","INT",null,null,null,"√","1","",""]
[18,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[19,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[20,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[21,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[22,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[23,"audit_by","审核者","VARCHAR",50,null,null,null,"","",""]
[24,"audit_time","审核时间","DATETIME",{"$nulls":4},"","",""]
[25,"close_by","关闭者","VARCHAR",50,null,null,null,"","",""]
[26,"close_time","关闭时间","DATETIME",{"$nulls":4},"","",""]
[27,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[28,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[29,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[30,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[31,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[32,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_task_check","index":42,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_task_check"]
[null,"显示名称","盘点任务主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","主表标识","CHAR",20,null,"√","√","","",""]
[2,"task_type","任务类型(1物料盘点 2标签盘点)","INT",{"$nulls":4},"","",""]
[3,"task_code","任务编码","VARCHAR",50,null,null,null,"","",""]
[4,"task_date","任务日期","DATE",{"$nulls":4},"","",""]
[5,"dept_code","部门编码","VARCHAR",50,null,null,null,"","",""]
[6,"employee_code","职员编码","VARCHAR",50,null,null,null,"","",""]
[7,"warehouse_code","仓库编码","VARCHAR",50,null,null,null,"","",""]
[8,"location_code","货位编码","VARCHAR",50,null,null,null,"","",""]
[9,"pallet_code","托盘编码","VARCHAR",50,null,null,null,"","",""]
[10,"package_code","包装编码","VARCHAR",50,null,null,null,"","",""]
[11,"label_code","标签编码","VARCHAR",50,null,null,null,"","",""]
[12,"material_code","物料编码","VARCHAR",1000,null,null,null,"","",""]
[13,"unit_code","单位编码","VARCHAR",500,null,null,null,"","",""]
[14,"batch","批号","VARCHAR",50,null,null,null,"","",""]
[15,"batch1","批号1","VARCHAR",50,null,null,null,"","",""]
[16,"batch2","批号2","VARCHAR",50,null,null,null,"","",""]
[17,"task_describe","描述","VARCHAR",255,null,null,null,"","",""]
[18,"status","审核状态(0已审核 1未审核)","INT",null,null,null,"√","1","",""]
[19,"is_create","是否生单(0是 1否)","INT",null,null,null,"√","1","",""]
[20,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[21,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[22,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[23,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[24,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[25,"audit_by","审核者","VARCHAR",50,null,null,null,"","",""]
[26,"audit_time","审核时间","DATETIME",{"$nulls":4},"","",""]
[27,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[28,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[29,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[30,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[31,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[32,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_task_checks","index":43,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_task_checks"]
[null,"显示名称","盘点任务子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","子表标识","CHAR",20,null,"√","√","","",""]
[2,"task_check_id","主表标识","CHAR",20,null,null,"√","","",""]
[3,"row_number","行号","INT",{"$nulls":4},"","",""]
[4,"warehouse_code","仓库编码","VARCHAR",50,null,null,null,"","",""]
[5,"location_code","货位编码","VARCHAR",50,null,null,null,"","",""]
[6,"pallet_code","托盘编码","VARCHAR",50,null,null,null,"","",""]
[7,"package_code","包装编码","VARCHAR",50,null,null,null,"","",""]
[8,"label_code","标签编码","VARCHAR",50,null,null,null,"","",""]
[9,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[10,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[11,"batch","批号","VARCHAR",50,null,null,null,"","",""]
[12,"batch1","批号1","VARCHAR",50,null,null,null,"","",""]
[13,"batch2","批号2","VARCHAR",50,null,null,null,"","",""]
[14,"task_qty","任务数量","DOUBLE",24,6,null,null,"","",""]
[15,"task_describe","描述","VARCHAR",255,null,null,null,"","",""]
[16,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[17,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[18,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[19,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[20,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[21,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[22,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[23,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[24,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[25,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[26,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_task_in","index":44,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_task_in"]
[null,"显示名称","入库任务主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","主表标识","CHAR",20,null,"√","√","","",""]
[2,"task_type","任务类型(1入库 -1入库退)","INT",null,null,null,"√","","",""]
[3,"task_code","任务编码","VARCHAR",50,null,null,null,"","",""]
[4,"task_date","任务日期","DATE",{"$nulls":4},"","",""]
[5,"bill_type_code","单据类型","VARCHAR",50,null,null,null,"","",""]
[6,"dept_code","部门编码","VARCHAR",50,null,null,null,"","",""]
[7,"employee_code","职员编码","VARCHAR",50,null,null,null,"","",""]
[8,"supplier_code","供应商编码","VARCHAR",50,null,null,null,"","",""]
[9,"task_describe","描述","VARCHAR",255,null,null,null,"","",""]
[10,"task_in_id","入库任务主表标识（入库任务退选）","CHAR",20,null,null,null,"","",""]
[11,"interface_id","接口标识","INT",{"$nulls":4},"","",""]
[12,"interface_code","接口编码","VARCHAR",50,null,null,null,"","",""]
[13,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[14,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[15,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[16,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[17,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[18,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[19,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[20,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[21,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[22,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[23,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]
[24,"workorder_code","工单编码","VARCHAR",255,null,null,null,"","",""]

{"sheet":"wms_task_ins","index":45,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_task_ins"]
[null,"显示名称","入库任务子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","子表标识","CHAR",20,null,"√","√","","",""]
[2,"task_in_id","主表标识","CHAR",20,null,null,"√","","",""]
[3,"row_number","行号","INT",{"$nulls":4},"","",""]
[4,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[5,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[6,"task_qty","任务数量","DOUBLE",24,6,null,null,"","",""]
[7,"excess_ratio_in","超入库比例%","DOUBLE",24,6,null,null,"","",""]
[8,"back_task_qty","已任务(退)数量","DOUBLE",24,6,null,null,"","",""]
[9,"label_qty","已生成标签数量","DOUBLE",24,6,null,null,"","",""]
[10,"stock_qty","已入库数量","DOUBLE",24,6,null,null,"","",""]
[11,"batch1","批号1","VARCHAR",100,null,null,null,"","",""]
[12,"batch2","批号2","VARCHAR",100,null,null,null,"","",""]
[13,"warehouse_code","仓库编码","VARCHAR",50,null,null,null,"","",""]
[14,"location_code","货位编码","VARCHAR",50,null,null,null,"","",""]
[15,"task_describe","描述","VARCHAR",255,null,null,null,"","",""]
[16,"task_ins_id","入库任务子表标识（入库任务退选）","CHAR",20,null,null,null,"","",""]
[17,"status","状态(0已审核 1未审核)","INT",null,null,null,"√","1","",""]
[18,"is_close","是否关闭(0是 1否)","INT",null,null,null,"√","1","",""]
[19,"interface_id","接口标识","INT",{"$nulls":4},"","",""]
[20,"interface_row","接口行号","INT",{"$nulls":4},"","",""]
[21,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[22,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[23,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[24,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[25,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[26,"audit_by","审核者","VARCHAR",50,null,null,null,"","",""]
[27,"audit_time","审核时间","DATETIME",{"$nulls":4},"","",""]
[28,"close_by","关闭者","VARCHAR",50,null,null,null,"","",""]
[29,"close_time","关闭时间","DATETIME",{"$nulls":4},"","",""]
[30,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[31,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[32,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[33,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[34,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[35,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_task_move","index":46,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_task_move"]
[null,"显示名称","移位任务主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","主表标识","CHAR",20,null,"√","√","","",""]
[2,"task_code","任务编码","VARCHAR",50,null,null,null,"","",""]
[3,"task_date","任务日期","DATE",{"$nulls":4},"","",""]
[4,"bill_type_code","单据类型","VARCHAR",50,null,null,null,"","",""]
[5,"dept_code_out","移出部门编码","VARCHAR",50,null,null,null,"","",""]
[6,"dept_code_in","移入部门编码","VARCHAR",50,null,null,null,"","",""]
[7,"employee_code_out","移出职员编码","VARCHAR",50,null,null,null,"","",""]
[8,"employee_code_in","移入职员编码","VARCHAR",50,null,null,null,"","",""]
[9,"warehouse_code_out","移出仓库编码","VARCHAR",50,null,null,null,"","",""]
[10,"warehouse_code_in","移入仓库编码","VARCHAR",50,null,null,null,"","",""]
[11,"task_describe","描述","VARCHAR",255,null,null,null,"","",""]
[12,"interface_id","接口标识","INT",{"$nulls":4},"","",""]
[13,"interface_code","接口编码","VARCHAR",50,null,null,null,"","",""]
[14,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[15,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[16,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[17,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[18,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[19,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[20,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[21,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[22,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[23,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[24,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]
[25,"customer_code_in","移入客户编码","VARCHAR",50,null,null,null,"","",""]

{"sheet":"wms_task_moves","index":47,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_task_moves"]
[null,"显示名称","移位任务子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","子表标识","CHAR",20,null,"√","√","","",""]
[2,"task_move_id","主表标识","CHAR",20,null,null,"√","","",""]
[3,"row_number","行号","INT",{"$nulls":4},"","",""]
[4,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[5,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[6,"task_qty","任务数量","DOUBLE",24,6,null,null,"","",""]
[7,"stock_qty","已移位数量","DOUBLE",24,6,null,null,"","",""]
[8,"batch1","批号1","VARCHAR",100,null,null,null,"","",""]
[9,"batch2","批号2","VARCHAR",100,null,null,null,"","",""]
[10,"location_code_out","移出货位编码","VARCHAR",50,null,null,null,"","",""]
[11,"location_code_in","移入货位编码","VARCHAR",50,null,null,null,"","",""]
[12,"task_describe","描述","VARCHAR",255,null,null,null,"","",""]
[13,"status","状态(0已审核 1未审核)","INT",null,null,null,"√","1","",""]
[14,"is_close","是否关闭(0是 1否)","INT",null,null,null,"√","1","",""]
[15,"interface_pid","接口产品标识","INT",{"$nulls":4},"","",""]
[16,"interface_id","接口标识","INT",{"$nulls":4},"","",""]
[17,"interface_row","接口行号","INT",{"$nulls":4},"","",""]
[18,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[19,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[20,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[21,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[22,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[23,"audit_by","审核者","VARCHAR",50,null,null,null,"","",""]
[24,"audit_time","审核时间","DATETIME",{"$nulls":4},"","",""]
[25,"close_by","关闭者","VARCHAR",50,null,null,null,"","",""]
[26,"close_time","关闭时间","DATETIME",{"$nulls":4},"","",""]
[27,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[28,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[29,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[30,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[31,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[32,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_task_out","index":48,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_task_out"]
[null,"显示名称","出库任务主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","主表标识","CHAR",20,null,"√","√","","",""]
[2,"task_type","任务类型(-1出库 1出库退)","INT",null,null,null,"√","","",""]
[3,"task_code","任务编码","VARCHAR",50,null,null,null,"","",""]
[4,"task_date","任务日期","DATE",{"$nulls":4},"","",""]
[5,"bill_type_code","单据类型","VARCHAR",50,null,null,null,"","",""]
[6,"dept_code","部门编码","VARCHAR",50,null,null,null,"","",""]
[7,"employee_code","职员编码","VARCHAR",50,null,null,null,"","",""]
[8,"supplier_code","供应商编码","VARCHAR",50,null,null,null,"","",""]
[9,"customer_code","客户编码","VARCHAR",50,null,null,null,"","",""]
[10,"task_describe","描述","VARCHAR",255,null,null,null,"","",""]
[11,"task_out_id","出库任务主表标识（出库任务退选）","CHAR",20,null,null,null,"","",""]
[12,"interface_id","接口标识","INT",{"$nulls":4},"","",""]
[13,"interface_code","接口编码","VARCHAR",50,null,null,null,"","",""]
[14,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[15,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[16,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[17,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[18,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[19,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[20,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[21,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[22,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[23,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[24,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_task_outs","index":49,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_task_outs"]
[null,"显示名称","出库任务子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","子表标识","CHAR",20,null,"√","√","","",""]
[2,"task_out_id","主表标识","CHAR",20,null,null,"√","","",""]
[3,"row_number","行号","INT",{"$nulls":4},"","",""]
[4,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[5,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[6,"task_qty","任务数量","DOUBLE",24,6,null,null,"","",""]
[7,"excess_ratio_out","超出库比例%","DOUBLE",24,6,null,null,"","",""]
[8,"back_task_qty","已任务(退)数量","DOUBLE",24,6,null,null,"","",""]
[9,"stock_qty","已出库数量","DOUBLE",24,6,null,null,"","",""]
[10,"batch1","批号1","VARCHAR",100,null,null,null,"","",""]
[11,"batch2","批号2","VARCHAR",100,null,null,null,"","",""]
[12,"warehouse_code","仓库编码","VARCHAR",50,null,null,null,"","",""]
[13,"location_code","货位编码","VARCHAR",50,null,null,null,"","",""]
[14,"is_back_flush","是否倒冲(0是 1否)","INT",null,null,null,"√","1","",""]
[15,"task_describe","描述","VARCHAR",255,null,null,null,"","",""]
[16,"task_ins_id","入库任务子表标识","CHAR",20,null,null,null,"","",""]
[17,"task_outs_id","出库任务子表标识","CHAR",20,null,null,null,"","",""]
[18,"status","状态(0已审核 1未审核)","INT",null,null,null,"√","1","",""]
[19,"is_close","是否关闭(0是 1否)","INT",null,null,null,"√","1","",""]
[20,"interface_pid","接口产品标识","INT",{"$nulls":4},"","",""]
[21,"interface_id","接口标识","INT",{"$nulls":4},"","",""]
[22,"interface_row","接口行号","INT",{"$nulls":4},"","",""]
[23,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[24,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[25,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[26,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[27,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[28,"audit_by","审核者","VARCHAR",50,null,null,null,"","",""]
[29,"audit_time","审核时间","DATETIME",{"$nulls":4},"","",""]
[30,"close_by","关闭者","VARCHAR",50,null,null,null,"","",""]
[31,"close_time","关闭时间","DATETIME",{"$nulls":4},"","",""]
[32,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[33,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[34,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[35,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[36,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[37,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_task_user","index":50,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_task_user"]
[null,"显示名称","任务操作者关系表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","BIGINT",null,null,"√","√","","",""]
[2,"bill_code","单据编码","VARCHAR",50,null,null,null,"","",""]
[3,"bill_id","单据主键","VARCHAR",50,null,null,null,"","",""]
[4,"user_id","操作者","BIGINT",{"$nulls":4},"","",""]

{"sheet":"wms_label","index":51,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_label"]
[null,"显示名称","标签"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"label_type","标签类型(1一次性 2重复性)","INT",{"$nulls":4},"","",""]
[3,"label_code","标签编码","VARCHAR",50,null,null,null,"","",""]
[4,"supplier_code","供应商编码","VARCHAR",50,null,null,null,"","",""]
[5,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[6,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[7,"batch","批号","VARCHAR",50,null,null,null,"","",""]
[8,"batch1","批号1","VARCHAR",100,null,null,null,"","",""]
[9,"batch2","批号2","VARCHAR",100,null,null,null,"","",""]
[10,"label_qty","标签数量","DOUBLE",24,6,null,null,"","",""]
[11,"in_stock_qty","入库数量","DOUBLE",24,6,null,null,"","",""]
[12,"out_stock_qty","出库数量","DOUBLE",24,6,null,null,"","",""]
[13,"task_ins_id","入库任务子表标识（生成标签来源）","CHAR",20,null,null,null,"","",""]
[14,"task_changes_id","转换任务子表标识（生成标签来源）","CHAR",20,null,null,null,"","",""]
[15,"stock_ins_id","入库子表标识（生成标签来源）","CHAR",20,null,null,null,"","",""]
[16,"stock_changes_id","转换子表标识（生成标签来源）","CHAR",20,null,null,null,"","",""]
[17,"label_describe","描述","VARCHAR",255,null,null,null,"","",""]
[18,"print_count","打印次数","INT",{"$nulls":4},"","",""]
[19,"status","状态(0有效 1无效)","INT",null,null,null,"√","1","",""]
[20,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[21,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[22,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[23,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[24,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[25,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[26,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[27,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[28,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[29,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[30,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_lock","index":52,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_lock"]
[null,"显示名称","冻结"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"lock_code","冻结编码","VARCHAR",50,null,null,null,"","",""]
[3,"warehouse_code","仓库编码","VARCHAR",50,null,null,null,"","",""]
[4,"location_code","货位编码","VARCHAR",50,null,null,null,"","",""]
[5,"pallet_code","托盘编码","VARCHAR",50,null,null,null,"","",""]
[6,"package_code","包装编码","VARCHAR",50,null,null,null,"","",""]
[7,"label_code","标签编码","VARCHAR",50,null,null,null,"","",""]
[8,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[9,"batch","批号","VARCHAR",50,null,null,null,"","",""]
[10,"batch1","批号1","VARCHAR",100,null,null,null,"","",""]
[11,"batch2","批号2","VARCHAR",100,null,null,null,"","",""]
[12,"lock_describe","描述","VARCHAR",255,null,null,null,"","",""]
[13,"status","状态(0已审核 1未审核)","INT",null,null,null,"√","1","",""]
[14,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[15,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[16,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[17,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[18,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[19,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[20,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[21,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[22,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[23,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[24,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_stock_change","index":53,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_stock_change"]
[null,"显示名称","转换主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","主表标识","CHAR",20,null,"√","√","","",""]
[2,"stock_code","转换编码","VARCHAR",50,null,null,null,"","",""]
[3,"stock_date","转换日期","DATE",{"$nulls":4},"","",""]
[4,"bill_type_code","单据类型","VARCHAR",50,null,null,null,"","",""]
[5,"dept_code_out","转出部门编码","VARCHAR",50,null,null,null,"","",""]
[6,"dept_code_in","转入部门编码","VARCHAR",50,null,null,null,"","",""]
[7,"employee_code_out","转出职员编码","VARCHAR",50,null,null,null,"","",""]
[8,"employee_code_in","转入职员编码","VARCHAR",50,null,null,null,"","",""]
[9,"organization_code_out","转出组织编码","VARCHAR",50,null,null,null,"","",""]
[10,"warehouse_code_out","转出仓库编码","VARCHAR",50,null,null,null,"","",""]
[11,"organization_code_in","转入组织编码","VARCHAR",50,null,null,null,"","",""]
[12,"warehouse_code_in","转入仓库编码","VARCHAR",50,null,null,null,"","",""]
[13,"stock_describe","描述","VARCHAR",255,null,null,null,"","",""]
[14,"task_change_id","转换任务主表标识","CHAR",20,null,null,null,"","",""]
[15,"status","状态(0已审核 1未审核)","INT",null,null,null,"√","1","",""]
[16,"interface_read","接口是否读取(0是 1否)","INT",null,null,null,"√","1","",""]
[17,"interface_status","接口读取状态(null无 200成功)","INT",{"$nulls":4},"","",""]
[18,"interface_code","接口读取返回编码","VARCHAR",2000,null,null,null,"","",""]
[19,"interface_message","接口读取返回信息","VARCHAR",255,null,null,null,"","",""]
[20,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[21,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[22,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[23,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[24,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[25,"audit_by","审核者","VARCHAR",50,null,null,null,"","",""]
[26,"audit_time","审核时间","DATETIME",{"$nulls":4},"","",""]
[27,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[28,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[29,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[30,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[31,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[32,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]
[33,"guid","唯一值","VARCHAR",100,null,null,null,"","",""]
[34,"app_group_id","app组id","VARCHAR",50,null,null,null,"","",""]

{"sheet":"wms_stock_changes","index":54,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_stock_changes"]
[null,"显示名称","转换子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","子表标识","CHAR",20,null,"√","√","","",""]
[2,"stock_change_id","主表标识","CHAR",20,null,null,"√","","",""]
[3,"row_number","行号","INT",{"$nulls":4},"","",""]
[4,"change_group","转换组别","INT",{"$nulls":4},"","",""]
[5,"change_type","转换类型(1转出 2转入)","INT",{"$nulls":4},"","",""]
[6,"label_code","标签编码","VARCHAR",50,null,null,null,"","",""]
[7,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[8,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[9,"batch","批号","VARCHAR",50,null,null,null,"","",""]
[10,"batch1","批号1","VARCHAR",100,null,null,null,"","",""]
[11,"batch2","批号2","VARCHAR",100,null,null,null,"","",""]
[12,"stock_qty","转换数量","DOUBLE",24,6,null,null,"","",""]
[13,"location_code","货位编码","VARCHAR",50,null,null,null,"","",""]
[14,"pallet_code","托盘编码","VARCHAR",50,null,null,null,"","",""]
[15,"package_code","包装编码","VARCHAR",50,null,null,null,"","",""]
[16,"stock_describe","描述","VARCHAR",255,null,null,null,"","",""]
[17,"task_changes_id","转换任务子表标识","CHAR",20,null,null,null,"","",""]
[18,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[19,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[20,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[21,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[22,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[23,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[24,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[25,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[26,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[27,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[28,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_stock_check","index":55,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_stock_check"]
[null,"显示名称","盘点主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","主表标识","CHAR",20,null,"√","√","","",""]
[2,"stock_type","盘点类型 (1粗盘 2细盘)","INT",{"$nulls":4},"","",""]
[3,"stock_code","盘点编码","VARCHAR",50,null,null,null,"","",""]
[4,"stock_date","盘点日期","DATE",{"$nulls":4},"","",""]
[5,"dept_code","部门编码","VARCHAR",50,null,null,null,"","",""]
[6,"employee_code","职员编码","VARCHAR",50,null,null,null,"","",""]
[7,"stock_describe","描述","VARCHAR",255,null,null,null,"","",""]
[8,"task_check_id","盘点任务主表标识","CHAR",20,null,null,null,"","",""]
[9,"organization_code","组织编码","VARCHAR",50,null,null,null,"","",""]
[10,"status","审核状态(0已审核 1未审核)","INT",null,null,null,"√","1","",""]
[11,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[12,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[13,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[14,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[15,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[16,"audit_by","审核者","VARCHAR",50,null,null,null,"","",""]
[17,"audit_time","审核时间","DATETIME",{"$nulls":4},"","",""]
[18,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[19,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[20,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[21,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[22,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[23,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]
[24,"guid","唯一值","VARCHAR",100,null,null,null,"","",""]
[25,"app_group_id","app组id","VARCHAR",50,null,null,null,"","",""]

{"sheet":"wms_stock_checks","index":56,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_stock_checks"]
[null,"显示名称","盘点子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","子表标识","CHAR",20,null,"√","√","","",""]
[2,"stock_check_id","主表标识","CHAR",20,null,null,"√","","",""]
[3,"row_number","行号","INT",{"$nulls":4},"","",""]
[4,"warehouse_code","仓库编码","VARCHAR",50,null,null,null,"","",""]
[5,"location_code","货位编码","VARCHAR",50,null,null,null,"","",""]
[6,"pallet_code","托盘编码","VARCHAR",50,null,null,null,"","",""]
[7,"package_code","包装编码","VARCHAR",50,null,null,null,"","",""]
[8,"label_code","标签编码","VARCHAR",50,null,null,null,"","",""]
[9,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[10,"batch","批号","VARCHAR",50,null,null,null,"","",""]
[11,"batch1","批号1","VARCHAR",50,null,null,null,"","",""]
[12,"batch2","批号2","VARCHAR",50,null,null,null,"","",""]
[13,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[14,"stock_qty","盘点数量","DOUBLE",24,6,null,null,"","",""]
[15,"stock_describe","描述","VARCHAR",255,null,null,null,"","",""]
[16,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[17,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[18,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[19,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[20,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[21,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[22,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[23,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[24,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[25,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[26,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_stock_in","index":57,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_stock_in"]
[null,"显示名称","入库主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","主表标识","CHAR",20,null,"√","√","","",""]
[2,"stock_type","入库类型(1入库 -1入库退)","INT",null,null,null,"√","","",""]
[3,"stock_code","入库编码","VARCHAR",50,null,null,null,"","",""]
[4,"stock_date","入库日期","DATE",{"$nulls":4},"","",""]
[5,"bill_type_code","单据类型","VARCHAR",50,null,null,null,"","",""]
[6,"dept_code","部门编码","VARCHAR",50,null,null,null,"","",""]
[7,"employee_code","职员编码","VARCHAR",50,null,null,null,"","",""]
[8,"supplier_code","供应商编码","VARCHAR",50,null,null,null,"","",""]
[9,"organization_code","组织编码","VARCHAR",50,null,null,null,"","",""]
[10,"warehouse_code","仓库编码","VARCHAR",50,null,null,null,"","",""]
[11,"stock_describe","描述","VARCHAR",255,null,null,null,"","",""]
[12,"task_in_id","入库任务主表标识","CHAR",20,null,null,null,"","",""]
[13,"back_task_in_id","入库任务(退)主表标识","CHAR",20,null,null,null,"","",""]
[14,"task_check_id","盘点任务主表标识","CHAR",20,null,null,null,"","",""]
[15,"status","状态(0已审核 1未审核)","INT",null,null,null,"√","1","",""]
[16,"interface_read","接口是否读取(0是 1否)","INT",null,null,null,"√","1","",""]
[17,"interface_status","接口读取状态(null无 200成功)","VARCHAR",20,null,null,null,"","",""]
[18,"interface_code","接口读取返回编码","VARCHAR",2000,null,null,null,"","",""]
[19,"interface_message","接口读取返回信息","VARCHAR",4000,null,null,null,"","",""]
[20,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[21,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[22,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[23,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[24,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[25,"audit_by","审核者","VARCHAR",50,null,null,null,"","",""]
[26,"audit_time","审核时间","DATETIME",{"$nulls":4},"","",""]
[27,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[28,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[29,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[30,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[31,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[32,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]
[33,"guid","唯一值","VARCHAR",100,null,null,null,"","",""]
[34,"app_group_id","app组id","VARCHAR",50,null,null,null,"","",""]

{"sheet":"wms_stock_ins","index":58,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_stock_ins"]
[null,"显示名称","入库子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","子表标识","CHAR",20,null,"√","√","","",""]
[2,"stock_in_id","主表标识","CHAR",20,null,null,"√","","",""]
[3,"row_number","行号","INT",{"$nulls":4},"","",""]
[4,"label_code","标签编码","VARCHAR",50,null,null,null,"","",""]
[5,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[6,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[7,"batch","批号","VARCHAR",50,null,null,null,"","",""]
[8,"batch1","批号1","VARCHAR",100,null,null,null,"","",""]
[9,"batch2","批号2","VARCHAR",100,null,null,null,"","",""]
[10,"stock_qty","入库数量","DOUBLE",24,6,null,null,"","",""]
[11,"back_stock_qty","已入库(退)数量","DOUBLE",24,6,null,null,"","",""]
[12,"location_code","货位编码","VARCHAR",50,null,null,null,"","",""]
[13,"pallet_code","托盘编码","VARCHAR",50,null,null,null,"","",""]
[14,"package_code","包装编码","VARCHAR",50,null,null,null,"","",""]
[15,"stock_describe","描述","VARCHAR",255,null,null,null,"","",""]
[16,"task_ins_id","入库任务子表标识","CHAR",20,null,null,null,"","",""]
[17,"back_task_ins_id","入库任务(退)子表标识","CHAR",20,null,null,null,"","",""]
[18,"stock_ins_id","入库子表标识","CHAR",20,null,null,null,"","",""]
[19,"task_checks_id","盘点任务子表标识","CHAR",20,null,null,null,"","",""]
[20,"stock_checks_id","盘点子表标识","CHAR",20,null,null,null,"","",""]
[21,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[22,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[23,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[24,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[25,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[26,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[27,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[28,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[29,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[30,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[31,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_stock_move","index":59,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_stock_move"]
[null,"显示名称","移位主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","主表标识","CHAR",20,null,"√","√","","",""]
[2,"stock_code","移位编码","VARCHAR",50,null,null,null,"","",""]
[3,"stock_date","移位日期","DATE",{"$nulls":4},"","",""]
[4,"bill_type_code","单据类型","VARCHAR",50,null,null,null,"","",""]
[5,"dept_code_out","移出部门编码","VARCHAR",50,null,null,null,"","",""]
[6,"dept_code_in","移入部门编码","VARCHAR",50,null,null,null,"","",""]
[7,"employee_code_out","移出职员编码","VARCHAR",50,null,null,null,"","",""]
[8,"employee_code_in","移入职员编码","VARCHAR",50,null,null,null,"","",""]
[9,"organization_code_out","移出组织编码","VARCHAR",50,null,null,null,"","",""]
[10,"organization_code_in","移入组织编码","VARCHAR",50,null,null,null,"","",""]
[11,"warehouse_code_out","移出仓库编码","VARCHAR",50,null,null,null,"","",""]
[12,"warehouse_code_in","移入仓库编码","VARCHAR",50,null,null,null,"","",""]
[13,"customer_code_in","移入客户编码","VARCHAR",50,null,null,null,"","",""]
[14,"stock_describe","描述","VARCHAR",255,null,null,null,"","",""]
[15,"task_move_id","移位任务主表标识","CHAR",20,null,null,null,"","",""]
[16,"status","状态(0已审核 1未审核)","INT",null,null,null,"√","1","",""]
[17,"interface_read","接口是否读取(0是 1否)","INT",null,null,null,"√","1","",""]
[18,"interface_status","接口读取状态(null无 200成功)","VARCHAR",11,null,null,null,"","",""]
[19,"interface_code","接口读取返回编码","VARCHAR",2000,null,null,null,"","",""]
[20,"interface_message","接口读取返回信息","VARCHAR",4000,null,null,null,"","",""]
[21,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[22,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[23,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[24,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[25,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[26,"audit_by","审核者","VARCHAR",50,null,null,null,"","",""]
[27,"audit_time","审核时间","DATETIME",{"$nulls":4},"","",""]
[28,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[29,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[30,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[31,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[32,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[33,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]
[34,"guid","唯一值","VARCHAR",100,null,null,null,"","",""]
[35,"app_group_id","app组id","VARCHAR",50,null,null,null,"","",""]

{"sheet":"wms_stock_moves","index":60,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_stock_moves"]
[null,"显示名称","移位子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","子表标识","CHAR",20,null,"√","√","","",""]
[2,"stock_move_id","主表标识","CHAR",20,null,null,"√","","",""]
[3,"row_number","行号","INT",{"$nulls":4},"","",""]
[4,"label_code","标签编码","VARCHAR",50,null,null,null,"","",""]
[5,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[6,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[7,"batch","批号","VARCHAR",50,null,null,null,"","",""]
[8,"batch1","批号1","VARCHAR",100,null,null,null,"","",""]
[9,"batch2","批号2","VARCHAR",100,null,null,null,"","",""]
[10,"stock_qty","移位数量","DOUBLE",24,6,null,null,"","",""]
[11,"location_code_out","移出货位编码","VARCHAR",50,null,null,null,"","",""]
[12,"location_code_in","移入货位编码","VARCHAR",50,null,null,null,"","",""]
[13,"pallet_code_out","移出托盘编码","VARCHAR",50,null,null,null,"","",""]
[14,"pallet_code_in","移入托盘编码","VARCHAR",50,null,null,null,"","",""]
[15,"package_code_out","移出包装编码","VARCHAR",50,null,null,null,"","",""]
[16,"package_code_in","移入包装编码","VARCHAR",50,null,null,null,"","",""]
[17,"stock_describe","描述","VARCHAR",255,null,null,null,"","",""]
[18,"task_moves_id","移位任务子表标识","CHAR",20,null,null,null,"","",""]
[19,"task_outs_id","出库任务子表标识","CHAR",20,null,null,null,"","",""]
[20,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[21,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[22,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[23,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[24,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[25,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[26,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[27,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[28,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[29,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[30,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_stock_out","index":61,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_stock_out"]
[null,"显示名称","出库主"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","主表标识","CHAR",20,null,"√","√","","",""]
[2,"stock_type","出库类型(-1出库 1出库退)","INT",null,null,null,"√","","",""]
[3,"stock_code","出库编码","VARCHAR",50,null,null,null,"","",""]
[4,"stock_date","出库日期","DATE",{"$nulls":4},"","",""]
[5,"bill_type_code","单据类型","VARCHAR",50,null,null,null,"","",""]
[6,"dept_code","部门编码","VARCHAR",50,null,null,null,"","",""]
[7,"employee_code","职员编码","VARCHAR",50,null,null,null,"","",""]
[8,"supplier_code","供应商编码","VARCHAR",50,null,null,null,"","",""]
[9,"customer_code","客户编码","VARCHAR",50,null,null,null,"","",""]
[10,"organization_code","组织编码","VARCHAR",50,null,null,null,"","",""]
[11,"warehouse_code","仓库编码","VARCHAR",50,null,null,null,"","",""]
[12,"is_supplement","是否补料(0是 1否)","INT",null,null,null,"√","1","",""]
[13,"stock_describe","描述","VARCHAR",255,null,null,null,"","",""]
[14,"task_out_id","出库任务主表标识","CHAR",20,null,null,null,"","",""]
[15,"back_task_out_id","出库任务(退)主表标识","CHAR",20,null,null,null,"","",""]
[16,"stock_in_id","入库主表标识(倒冲的入库单)","CHAR",20,null,null,null,"","",""]
[17,"task_check_id","盘点任务主表标识","CHAR",20,null,null,null,"","",""]
[18,"status","状态(0已审核 1未审核)","INT",null,null,null,"√","1","",""]
[19,"interface_read","接口是否读取(0是 1否)","INT",null,null,null,"√","1","",""]
[20,"interface_status","接口读取状态(null无 200成功)","VARCHAR",11,null,null,null,"","",""]
[21,"interface_code","接口读取返回编码","VARCHAR",2000,null,null,null,"","",""]
[22,"interface_message","接口读取返回信息","VARCHAR",4000,null,null,null,"","",""]
[23,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[24,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[25,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[26,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[27,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[28,"audit_by","审核者","VARCHAR",50,null,null,null,"","",""]
[29,"audit_time","审核时间","DATETIME",{"$nulls":4},"","",""]
[30,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[31,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[32,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[33,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[34,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[35,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]
[36,"guid","唯一值","VARCHAR",100,null,null,null,"","",""]
[37,"app_group_id","app组id","VARCHAR",50,null,null,null,"","",""]

{"sheet":"wms_stock_outs","index":62,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_stock_outs"]
[null,"显示名称","出库子"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","子表标识","CHAR",20,null,"√","√","","",""]
[2,"stock_out_id","主表标识","CHAR",20,null,null,"√","","",""]
[3,"row_number","行号","INT",{"$nulls":4},"","",""]
[4,"label_code","标签编码","VARCHAR",50,null,null,null,"","",""]
[5,"material_code","物料编码","VARCHAR",50,null,null,null,"","",""]
[6,"unit_code","单位编码","VARCHAR",50,null,null,null,"","",""]
[7,"batch","批号","VARCHAR",50,null,null,null,"","",""]
[8,"batch1","批号1","VARCHAR",100,null,null,null,"","",""]
[9,"batch2","批号2","VARCHAR",100,null,null,null,"","",""]
[10,"stock_qty","出库数量","DOUBLE",24,6,null,null,"","",""]
[11,"back_stock_qty","已出库(退)数量","DOUBLE",24,6,null,null,"","",""]
[12,"location_code","货位编码","VARCHAR",50,null,null,null,"","",""]
[13,"pallet_code","托盘编码","VARCHAR",50,null,null,null,"","",""]
[14,"package_code","包装编码","VARCHAR",50,null,null,null,"","",""]
[15,"stock_describe","描述","VARCHAR",255,null,null,null,"","",""]
[16,"task_outs_id","出库任务子表标识","CHAR",20,null,null,null,"","",""]
[17,"back_task_outs_id","出库任务(退)子表标识","CHAR",20,null,null,null,"","",""]
[18,"stock_outs_id","出库子表标识","CHAR",20,null,null,null,"","",""]
[19,"stock_ins_id","入库子表标识(倒冲的入库单)","CHAR",20,null,null,null,"","",""]
[20,"task_checks_id","盘点任务子表标识","CHAR",20,null,null,null,"","",""]
[21,"stock_checks_id","盘点子表标识","CHAR",20,null,null,null,"","",""]
[22,"create_id","创建者内码","INT",{"$nulls":4},"","",""]
[23,"create_by","创建者","VARCHAR",50,null,null,null,"","",""]
[24,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[25,"update_by","更新者","VARCHAR",50,null,null,null,"","",""]
[26,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[27,"remark","备注","VARCHAR",255,null,null,null,"","",""]
[28,"extend_code01","扩展编码01","VARCHAR",150,null,null,null,"","",""]
[29,"extend_code02","扩展编码02","VARCHAR",150,null,null,null,"","",""]
[30,"extend_code03","扩展编码03","VARCHAR",150,null,null,null,"","",""]
[31,"extend_code04","扩展编码04","VARCHAR",150,null,null,null,"","",""]
[32,"extend_code05","扩展编码05","VARCHAR",150,null,null,null,"","",""]

{"sheet":"wms_current_stock","index":63,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_current_stock"]
[null,"显示名称","现存量"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"warehouse_code","仓库编码","VARCHAR",50,null,null,"√","","",""]
[3,"location_code","货位编码","VARCHAR",50,null,null,"√","","",""]
[4,"pallet_code","托盘编码","VARCHAR",50,null,null,"√","","",""]
[5,"package_code","包装编码","VARCHAR",50,null,null,"√","","",""]
[6,"label_code","标签编码","VARCHAR",50,null,null,"√","","",""]
[7,"material_code","物料编码","VARCHAR",50,null,null,"√","","",""]
[8,"unit_code","单位编码","VARCHAR",50,null,null,"√","","",""]
[9,"batch","批号","VARCHAR",50,null,null,"√","","",""]
[10,"batch1","批号1","VARCHAR",100,null,null,null,"","",""]
[11,"batch2","批号2","VARCHAR",100,null,null,null,"","",""]
[12,"stock_qty","可用库存数量（入库审核、出库保存）","DOUBLE",24,6,null,null,"","",""]
[13,"set_stock_qty","设置库存数量（根据设置）","DOUBLE",24,6,null,null,"","",""]
[14,"place_stock_qty","位置库存数量（入库保存、出库审核），位置占用量","DOUBLE",24,6,null,null,"","",""]
[15,"version","版本","INT",{"$nulls":4},"0","",""]
[16,"update_timestamp","更新时间","TIMESTAMP",null,null,null,"√","CURRENT_TIMESTAMP","",""]

{"sheet":"wms_initial_stock","index":64,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","wms_initial_stock"]
[null,"显示名称","期初"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"id","标识","INT",null,null,"√","√","","",""]
[2,"warehouse_code","仓库编码","VARCHAR",50,null,null,"√","","",""]
[3,"material_code","物料编码","VARCHAR",50,null,null,"√","","",""]
[4,"stock_date","单据日期","VARCHAR",50,null,null,"√","","",""]
[5,"create_date","创建日期","VARCHAR",50,null,null,"√","","",""]
[6,"audit_date","审核日期","VARCHAR",50,null,null,"√","","",""]
[7,"in_stock_qty","入库数量","DOUBLE",24,6,null,null,"","",""]
[8,"out_stock_qty","出库数量","DOUBLE",24,6,null,null,"","",""]

{"sheet":"dv_check_machinery","index":65,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","dv_check_machinery"]
[null,"显示名称","点检设备表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","流水号","BIGINT",null,null,"√","√","","",""]
[2,"plan_id","计划ID","BIGINT",null,null,null,"√","","",""]
[3,"machinery_id","设备ID","BIGINT",null,null,null,"√","","",""]
[4,"machinery_code","设备编码","VARCHAR",64,null,null,"√","","",""]
[5,"machinery_name","设备名称","VARCHAR",255,null,null,"√","","",""]
[6,"machinery_brand","品牌","VARCHAR",255,null,null,null,"","",""]
[7,"machinery_spec","规格型号","VARCHAR",255,null,null,null,"","",""]
[8,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[9,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[10,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[11,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[12,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[13,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[14,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[15,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[16,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"dv_check_plan","index":66,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","dv_check_plan"]
[null,"显示名称","设备点检保养计划头表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"plan_id","计划ID","BIGINT",null,null,"√","√","","",""]
[2,"plan_code","计划编码","VARCHAR",64,null,null,"√","","",""]
[3,"plan_name","计划名称","VARCHAR",255,null,null,null,"","",""]
[4,"plan_type","计划类型","VARCHAR",64,null,null,"√","","",""]
[5,"start_date","开始日期","DATETIME",{"$nulls":4},"","",""]
[6,"end_date","结束日期","DATETIME",{"$nulls":4},"","",""]
[7,"cycle_type","频率","VARCHAR",64,null,null,null,"","",""]
[8,"cycle_count","次数","INT",{"$nulls":4},"","",""]
[9,"status","状态","VARCHAR",64,null,null,null,"","",""]
[10,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[11,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[12,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[13,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[14,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[15,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[16,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[17,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[18,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"dv_check_record","index":67,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","dv_check_record"]
[null,"显示名称","设备点检记录_陈志强"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"user_id","用户ID","BIGINT",null,null,null,"√","","",""]
[3,"user_name","用户名","VARCHAR",64,null,null,null,"","",""]
[4,"nick_name","名称","VARCHAR",30,null,null,null,"","",""]
[5,"workstation_id","工作站ID","BIGINT",null,null,null,"√","","",""]
[6,"workstation_code","工作站编号","VARCHAR",64,null,null,null,"","",""]
[7,"workstation_name","工作站名称","VARCHAR",125,null,null,null,"","",""]
[8,"machinery_id","设备ID","BIGINT",null,null,null,"√","","",""]
[9,"machinery_code","设备编码","VARCHAR",64,null,null,"√","","",""]
[10,"machinery_name","设备名称","VARCHAR",255,null,null,"√","","",""]
[11,"plan_id","计划ID","BIGINT",null,null,null,"√","","",""]
[12,"subject_id","项目ID","BIGINT",null,null,null,"√","","",""]
[13,"subject_code","项目编码","VARCHAR",64,null,null,"√","","",""]
[14,"subject_name","项目名称","VARCHAR",255,null,null,null,"","",""]
[15,"operation_flag","操作类型","CHAR",1,null,null,"√","","",""]
[16,"operation_name","操作名称","VARCHAR",30,null,null,null,"","",""]
[17,"operation_time","操作时间","DATETIME",{"$nulls":4},"","",""]
[18,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[19,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[20,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[21,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[22,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[23,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[24,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[25,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[26,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"dv_check_subject","index":68,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","dv_check_subject"]
[null,"显示名称","点检项目表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","流水号","BIGINT",null,null,"√","√","","",""]
[2,"plan_id","计划ID","BIGINT",null,null,null,"√","","",""]
[3,"subject_id","项目ID","BIGINT",null,null,null,"√","","",""]
[4,"subject_code","项目编码","VARCHAR",64,null,null,"√","","",""]
[5,"subject_name","项目名称","VARCHAR",255,null,null,null,"","",""]
[6,"subject_type","项目类型","VARCHAR",64,null,null,null,"","",""]
[7,"subject_content","项目内容","VARCHAR",500,null,null,"√","","",""]
[8,"subject_standard","标准","VARCHAR",255,null,null,null,"","",""]
[9,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[10,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[11,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[12,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[13,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[14,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[15,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[16,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[17,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"dv_machinery","index":69,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","dv_machinery"]
[null,"显示名称","设备表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"machinery_id","设备ID","BIGINT",null,null,"√","√","","",""]
[2,"machinery_code","设备编码","VARCHAR",64,null,null,"√","","",""]
[3,"machinery_name","设备名称","VARCHAR",255,null,null,"√","","",""]
[4,"machinery_brand","品牌","VARCHAR",255,null,null,null,"","",""]
[5,"machinery_spec","规格型号","VARCHAR",255,null,null,null,"","",""]
[6,"machinery_type_id","设备类型ID","BIGINT",null,null,null,"√","","",""]
[7,"machinery_type_code","设备类型编码","VARCHAR",64,null,null,null,"","",""]
[8,"machinery_type_name","设备类型名称","VARCHAR",255,null,null,null,"","",""]
[9,"workshop_id","所属车间ID","BIGINT",null,null,null,"√","","",""]
[10,"workshop_code","所属车间编码","VARCHAR",64,null,null,null,"","",""]
[11,"workshop_name","所属车间名称","VARCHAR",255,null,null,null,"","",""]
[12,"status","设备状态","VARCHAR",64,null,null,"√","'STOP'","",""]
[13,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[14,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[15,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[16,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[17,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[18,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[19,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[20,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[21,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"dv_machinery_type","index":70,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","dv_machinery_type"]
[null,"显示名称","设备类型表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"machinery_type_id","设备类型ID","BIGINT",null,null,"√","√","","",""]
[2,"machinery_type_code","设备类型编码","VARCHAR",64,null,null,"√","","",""]
[3,"machinery_type_name","设备类型名称","VARCHAR",255,null,null,"√","","",""]
[4,"parent_type_id","父类型ID","BIGINT",{"$nulls":4},"0","",""]
[5,"ancestors","所有父节点ID","VARCHAR",255,null,null,"√","","",""]
[6,"enable_flag","是否启用","CHAR",1,null,null,"√","'Y'","",""]
[7,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[8,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[9,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[10,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[11,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[12,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[13,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[14,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[15,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"dv_repair","index":71,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","dv_repair"]
[null,"显示名称","设备维修单"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"repair_id","维修单ID","BIGINT",null,null,"√","√","","",""]
[2,"repair_code","维修单编号","VARCHAR",64,null,null,"√","","",""]
[3,"repair_name","维修单名称","VARCHAR",255,null,null,null,"","",""]
[4,"machinery_id","设备ID","BIGINT",null,null,null,"√","","",""]
[5,"machinery_code","设备编码","VARCHAR",64,null,null,"√","","",""]
[6,"machinery_name","设备名称","VARCHAR",255,null,null,"√","","",""]
[7,"machinery_brand","品牌","VARCHAR",255,null,null,null,"","",""]
[8,"machinery_spec","规格型号","VARCHAR",255,null,null,null,"","",""]
[9,"machinery_type_id","设备类型ID","BIGINT",null,null,null,"√","","",""]
[10,"require_date","报修日期","DATETIME",{"$nulls":4},"","",""]
[11,"finish_date","维修完成日期","DATETIME",{"$nulls":4},"","",""]
[12,"confirm_date","验收日期","DATETIME",{"$nulls":4},"","",""]
[13,"repair_result","维修结果","VARCHAR",64,null,null,null,"","",""]
[14,"accepted_by","维修人员","VARCHAR",64,null,null,null,"","",""]
[15,"confirm_by","验收人员","VARCHAR",64,null,null,null,"","",""]
[16,"status","单据状态","VARCHAR",64,null,null,null,"'PREPARE'","",""]
[17,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[18,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[19,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[20,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[21,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[22,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[23,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[24,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[25,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"dv_repair_line","index":72,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","dv_repair_line"]
[null,"显示名称","设备维修单行"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"line_id","行ID","BIGINT",null,null,"√","√","","",""]
[2,"repair_id","维修单ID","BIGINT",null,null,null,"√","","",""]
[3,"subject_id","项目ID","BIGINT",{"$nulls":4},"","",""]
[4,"subject_code","项目编码","VARCHAR",64,null,null,null,"","",""]
[5,"subject_name","项目名称","VARCHAR",255,null,null,null,"","",""]
[6,"subject_type","项目类型","VARCHAR",64,null,null,null,"","",""]
[7,"subject_content","项目内容","VARCHAR",500,null,null,null,"","",""]
[8,"subject_standard","标准","VARCHAR",255,null,null,null,"","",""]
[9,"malfunction","故障描述","VARCHAR",500,null,null,"√","","",""]
[10,"malfunction_url","故障描述资源","VARCHAR",255,null,null,null,"","",""]
[11,"repair_des","维修情况","VARCHAR",500,null,null,null,"","",""]
[12,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[13,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[14,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[15,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[16,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[17,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[18,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[19,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[20,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"dv_subject","index":73,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","dv_subject"]
[null,"显示名称","设备点检保养项目表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"subject_id","项目ID","BIGINT",null,null,"√","√","","",""]
[2,"subject_code","项目编码","VARCHAR",64,null,null,"√","","",""]
[3,"subject_name","项目名称","VARCHAR",255,null,null,null,"","",""]
[4,"subject_type","项目类型","VARCHAR",64,null,null,null,"'0'","",""]
[5,"subject_content","项目内容","VARCHAR",500,null,null,"√","","",""]
[6,"subject_standard","标准","VARCHAR",255,null,null,null,"","",""]
[7,"enable_flag","是否启用","CHAR",1,null,null,"√","'Y'","",""]
[8,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[9,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[10,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[11,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[12,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[13,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[14,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[15,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[16,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"tm_tool","index":74,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","tm_tool"]
[null,"显示名称","工装夹具清单表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"tool_id","工装夹具ID","BIGINT",null,null,"√","√","","",""]
[2,"tool_code","工装夹具编码","VARCHAR",64,null,null,"√","","",""]
[3,"tool_name","工装夹具名称","VARCHAR",255,null,null,"√","","",""]
[4,"brand","品牌","VARCHAR",255,null,null,null,"","",""]
[5,"spec","型号","VARCHAR",255,null,null,null,"","",""]
[6,"tool_type_id","工装夹具类型ID","BIGINT",null,null,null,"√","","",""]
[7,"tool_type_code","工装夹具类型编码","VARCHAR",64,null,null,null,"","",""]
[8,"tool_type_name","工装夹具类型名称","VARCHAR",255,null,null,null,"","",""]
[9,"code_flag","是否单独编码管理","CHAR",1,null,null,"√","'Y'","",""]
[10,"quantity","数量","INT",null,null,null,"√","1","",""]
[11,"quantity_avail","可用数量","INT",{"$nulls":4},"1","",""]
[12,"mainten_type","保养维护类型","VARCHAR",20,null,null,null,"","",""]
[13,"next_mainten_period","下一次保养周期","INT",{"$nulls":4},"","",""]
[14,"next_mainten_date","下一次保养日期","DATETIME",{"$nulls":4},"","",""]
[15,"status","状态[MES_TOOL_STATUS]","VARCHAR",64,null,null,null,"'STORE'","",""]
[16,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[17,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[18,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[19,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[20,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[21,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[22,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[23,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[24,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"tm_tool_type","index":75,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","tm_tool_type"]
[null,"显示名称","工装夹具类型表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"tool_type_id","工装夹具类型ID","BIGINT",null,null,"√","√","","",""]
[2,"tool_type_code","类型编码","VARCHAR",64,null,null,"√","","",""]
[3,"tool_type_name","类型名称","VARCHAR",255,null,null,"√","","",""]
[4,"code_flag","是否编码管理","CHAR",1,null,null,"√","'Y'","",""]
[5,"mainten_type","保养维护类型","VARCHAR",20,null,null,null,"","",""]
[6,"mainten_period","保养周期","INT",{"$nulls":4},"","",""]
[7,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[8,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[9,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[10,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[11,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[12,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[13,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[14,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[15,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_feedback","index":76,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_feedback"]
[null,"显示名称","生产报工记录表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"feedback_type","报工类型","VARCHAR",64,null,null,"√","","",""]
[3,"workstation_id","工作站ID","BIGINT",null,null,null,"√","","",""]
[4,"workstation_code","工作站编号","VARCHAR",64,null,null,null,"","",""]
[5,"workstation_name","工作站名称","VARCHAR",255,null,null,null,"","",""]
[6,"workorder_id","生产工单ID","BIGINT",null,null,null,"√","","",""]
[7,"workorder_code","生产工单编号","VARCHAR",64,null,null,null,"","",""]
[8,"workorder_name","生产工单名称","VARCHAR",255,null,null,null,"","",""]
[9,"process_id","工序ID","BIGINT",null,null,null,"√","","",""]
[10,"process_code","工序编码","VARCHAR",64,null,null,null,"","",""]
[11,"process_name","工序名称","VARCHAR",255,null,null,null,"","",""]
[12,"task_id","生产任务ID","BIGINT",{"$nulls":4},"","",""]
[13,"task_code","生产任务编号","VARCHAR",64,null,null,null,"","",""]
[14,"item_id","产品物料ID","BIGINT",null,null,null,"√","","",""]
[15,"item_code","产品物料编码","VARCHAR",64,null,null,"√","","",""]
[16,"item_name","产品物料名称","VARCHAR",255,null,null,"√","","",""]
[17,"unit_of_measure","单位","VARCHAR",64,null,null,null,"","",""]
[18,"specification","规格型号","VARCHAR",500,null,null,null,"","",""]
[19,"quantity","排产数量","DOUBLE",14,2,null,null,"","",""]
[20,"quantity_feedback","本次报工数量","DOUBLE",14,2,null,null,"","",""]
[21,"quantity_qualified","合格品数量","DOUBLE",14,2,null,null,"","",""]
[22,"quantity_unquanlified","不良品数量","DOUBLE",14,2,null,null,"","",""]
[23,"user_name","报工用户名","VARCHAR",64,null,null,null,"","",""]
[24,"nick_name","昵称","VARCHAR",64,null,null,null,"","",""]
[25,"feedback_channel","报工途径","VARCHAR",64,null,null,null,"","",""]
[26,"feedback_time","报工时间","DATETIME",{"$nulls":4},"","",""]
[27,"record_user","记录人","VARCHAR",64,null,null,null,"","",""]
[28,"record_nick","记录人名称","VARCHAR",64,null,null,null,"","",""]
[29,"status","状态","VARCHAR",64,null,null,null,"'PREPARE'","",""]
[30,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[31,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[32,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[33,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[34,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[35,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[36,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[37,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[38,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_process","index":77,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_process"]
[null,"显示名称","生产工序表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"process_id","工序ID","BIGINT",null,null,"√","√","","",""]
[2,"process_code","工序编码","VARCHAR",64,null,null,"√","","",""]
[3,"process_name","工序名称","VARCHAR",255,null,null,"√","","",""]
[4,"attention","工艺要求","VARCHAR",1000,null,null,null,"","",""]
[5,"enable_flag","是否启用","CHAR",1,null,null,"√","'Y'","",""]
[6,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[7,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[8,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[9,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[10,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[11,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[12,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[13,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[14,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_process_content","index":78,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_process_content"]
[null,"显示名称","生产工序内容表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"content_id","内容ID","BIGINT",null,null,"√","√","","",""]
[2,"process_id","工序ID","BIGINT",null,null,null,"√","","",""]
[3,"order_num","顺序编号","INT",{"$nulls":4},"0","",""]
[4,"content_text","内容说明","VARCHAR",500,null,null,null,"","",""]
[5,"device","辅助设备","VARCHAR",255,null,null,null,"","",""]
[6,"material","辅助材料","VARCHAR",255,null,null,null,"","",""]
[7,"doc_url","材料URL","VARCHAR",255,null,null,null,"","",""]
[8,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[9,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[10,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[11,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[12,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[13,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[14,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[15,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[16,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_route","index":79,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_route"]
[null,"显示名称","工艺路线表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"route_id","工艺路线ID","BIGINT",null,null,"√","√","","",""]
[2,"route_code","工艺路线编号","VARCHAR",64,null,null,"√","","",""]
[3,"route_name","工艺路线名称","VARCHAR",255,null,null,"√","","",""]
[4,"route_desc","工艺路线说明","VARCHAR",500,null,null,null,"","",""]
[5,"enable_flag","是否启用","CHAR",1,null,null,"√","'Y'","",""]
[6,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[7,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[8,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[9,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[10,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[11,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[12,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[13,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[14,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_route_process","index":80,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_route_process"]
[null,"显示名称","工艺组成表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"route_id","工艺路线ID","BIGINT",null,null,null,"√","","",""]
[3,"process_id","工序ID","BIGINT",null,null,null,"√","","",""]
[4,"process_code","工序编码","VARCHAR",64,null,null,null,"","",""]
[5,"process_name","工序名称","VARCHAR",255,null,null,null,"","",""]
[6,"order_num","序号","INT",{"$nulls":4},"1","",""]
[7,"next_process_id","工序ID","BIGINT",null,null,null,"√","","",""]
[8,"next_process_code","工序编码","VARCHAR",64,null,null,null,"","",""]
[9,"next_process_name","工序名称","VARCHAR",255,null,null,null,"","",""]
[10,"link_type","与下一道工序关系","VARCHAR",64,null,null,null,"'SS'","",""]
[11,"default_pre_time","准备时间","INT",{"$nulls":4},"0","",""]
[12,"default_suf_time","等待时间","INT",{"$nulls":4},"0","",""]
[13,"color_code","甘特图显示颜色","CHAR",7,null,null,null,"'#00AEF3'","",""]
[14,"key_flag","关键工序","VARCHAR",64,null,null,null,"'N'","",""]
[15,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[16,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[17,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[18,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[19,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[20,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[21,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[22,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[23,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_route_product","index":81,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_route_product"]
[null,"显示名称","产品制程"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"route_id","工艺路线ID","BIGINT",null,null,null,"√","","",""]
[3,"item_id","产品物料ID","BIGINT",null,null,null,"√","","",""]
[4,"item_code","产品物料编码","VARCHAR",64,null,null,"√","","",""]
[5,"item_name","产品物料名称","VARCHAR",255,null,null,"√","","",""]
[6,"specification","规格型号","VARCHAR",500,null,null,null,"","",""]
[7,"unit_of_measure","单位","VARCHAR",64,null,null,"√","","",""]
[8,"quantity","生产数量","INT",{"$nulls":4},"1","",""]
[9,"production_time","生产用时","DOUBLE",12,2,null,null,"1.00","",""]
[10,"time_unit_type","时间单位","VARCHAR",64,null,null,null,"'MINUTE'","",""]
[11,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[12,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[13,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[14,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[15,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[16,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[17,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[18,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[19,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_route_product_bom","index":82,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_route_product_bom"]
[null,"显示名称","产品制程物料BOM表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"route_id","工艺路线ID","BIGINT",null,null,null,"√","","",""]
[3,"process_id","工序ID","BIGINT",null,null,null,"√","","",""]
[4,"product_id","产品BOM中的唯一ID","BIGINT",null,null,null,"√","","",""]
[5,"item_id","产品物料ID","BIGINT",null,null,null,"√","","",""]
[6,"item_code","产品物料编码","VARCHAR",64,null,null,"√","","",""]
[7,"item_name","产品物料名称","VARCHAR",255,null,null,"√","","",""]
[8,"specification","规格型号","VARCHAR",500,null,null,null,"","",""]
[9,"unit_of_measure","单位","VARCHAR",64,null,null,"√","","",""]
[10,"quantity","用料比例","DOUBLE",12,2,null,null,"1.00","",""]
[11,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[12,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[13,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[14,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[15,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[16,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[17,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[18,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[19,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_task","index":83,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_task"]
[null,"显示名称","生产任务表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"task_id","任务ID","BIGINT",null,null,"√","√","","",""]
[2,"task_code","任务编号","VARCHAR",64,null,null,"√","","",""]
[3,"task_name","任务名称","VARCHAR",255,null,null,"√","","",""]
[4,"workorder_id","生产工单ID","BIGINT",null,null,null,"√","","",""]
[5,"workorder_code","生产工单编号","VARCHAR",64,null,null,"√","","",""]
[6,"workorder_name","工单名称","VARCHAR",255,null,null,"√","","",""]
[7,"workstation_id","工作站ID","BIGINT",null,null,null,"√","","",""]
[8,"workstation_code","工作站编号","VARCHAR",64,null,null,"√","","",""]
[9,"workstation_name","工作站名称","VARCHAR",255,null,null,"√","","",""]
[10,"process_id","工序ID","BIGINT",null,null,null,"√","","",""]
[11,"process_code","工序编码","VARCHAR",64,null,null,null,"","",""]
[12,"process_name","工序名称","VARCHAR",255,null,null,null,"","",""]
[13,"item_id","产品物料ID","BIGINT",null,null,null,"√","","",""]
[14,"item_code","产品物料编码","VARCHAR",64,null,null,"√","","",""]
[15,"item_name","产品物料名称","VARCHAR",255,null,null,"√","","",""]
[16,"specification","规格型号","VARCHAR",500,null,null,null,"","",""]
[17,"unit_of_measure","单位","VARCHAR",64,null,null,"√","","",""]
[18,"quantity","排产数量","DOUBLE",14,2,null,"√","1.00","",""]
[19,"quantity_produced","已生产数量","DOUBLE",14,2,null,null,"0.00","",""]
[20,"quantity_quanlify","合格品数量","DOUBLE",14,2,null,null,"0.00","",""]
[21,"quantity_unquanlify","不良品数量","DOUBLE",14,2,null,null,"0.00","",""]
[22,"quantity_changed","调整数量","DOUBLE",14,2,null,null,"0.00","",""]
[23,"client_id","客户ID","BIGINT",{"$nulls":4},"","",""]
[24,"client_code","客户编码","VARCHAR",64,null,null,null,"","",""]
[25,"client_name","客户名称","VARCHAR",255,null,null,null,"","",""]
[26,"client_nick","客户简称","VARCHAR",255,null,null,null,"","",""]
[27,"start_time","开始生产时间","DATETIME",{"$nulls":4},"CURRENT_TIMESTAMP","",""]
[28,"duration","生产时长","INT",{"$nulls":4},"1","",""]
[29,"end_time","完成生产时间","DATETIME",{"$nulls":4},"","",""]
[30,"color_code","甘特图显示颜色","CHAR",7,null,null,null,"'#00AEF3'","",""]
[31,"request_date","需求日期","DATETIME",{"$nulls":4},"","",""]
[32,"status","生产状态","VARCHAR",64,null,null,null,"'NORMAL'","",""]
[33,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[34,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[35,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[36,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[37,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[38,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[39,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[40,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[41,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_task_issue","index":84,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_task_issue"]
[null,"显示名称","生产任务投料表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"task_id","生产任务ID","BIGINT",null,null,null,"√","","",""]
[3,"workorder_id","生产工单ID","BIGINT",{"$nulls":4},"","",""]
[4,"workstation_id","工作站ID","BIGINT",{"$nulls":4},"","",""]
[5,"source_doc_id","单据ID","BIGINT",null,null,null,"√","","",""]
[6,"source_doc_code","单据编号","VARCHAR",64,null,null,null,"","",""]
[7,"batch_code","投料批次","VARCHAR",64,null,null,null,"","",""]
[8,"source_line_id","行ID","BIGINT",{"$nulls":4},"","",""]
[9,"item_id","产品物料ID","BIGINT",{"$nulls":4},"","",""]
[10,"item_code","产品物料编码","VARCHAR",64,null,null,"√","","",""]
[11,"item_name","产品物料名称","VARCHAR",255,null,null,"√","","",""]
[12,"specification","规格型号","VARCHAR",500,null,null,null,"","",""]
[13,"unit_of_measure","单位","VARCHAR",64,null,null,"√","","",""]
[14,"quantity_issued","总的投料数量","DOUBLE",12,2,null,null,"","",""]
[15,"quantity_available","当前可用数量","DOUBLE",12,2,null,null,"","",""]
[16,"quantity_used","当前使用数量","DOUBLE",12,2,null,null,"","",""]
[17,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[18,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[19,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[20,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[21,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[22,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[23,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[24,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[25,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]
[26,"source_doc_type","","VARCHAR",64,null,null,null,"","",""]

{"sheet":"pro_trans_consume","index":85,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_trans_consume"]
[null,"显示名称","物料消耗记录表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"trans_order_id","流转单ID","BIGINT",{"$nulls":4},"","",""]
[3,"trans_order_code","流转单编号","VARCHAR",64,null,null,null,"","",""]
[4,"task_id","生产任务ID","BIGINT",null,null,null,"√","","",""]
[5,"workstation_id","工作站ID","BIGINT",null,null,null,"√","","",""]
[6,"process_id","工序ID","BIGINT",{"$nulls":4},"","",""]
[7,"workorder_id","生产工单ID","BIGINT",{"$nulls":4},"","",""]
[8,"batch_code","批次号","VARCHAR",64,null,null,null,"","",""]
[9,"source_doc_id","被消耗单据ID","BIGINT",{"$nulls":4},"","",""]
[10,"source_doc_code","被消耗单据编号","VARCHAR",64,null,null,null,"","",""]
[11,"source_doc_type","被消耗单据类型","VARCHAR",64,null,null,null,"","",""]
[12,"source_line_id","被消耗单据行ID","BIGINT",{"$nulls":4},"","",""]
[13,"source_batch_code","被消耗物料批次号","VARCHAR",64,null,null,null,"","",""]
[14,"item_id","被消耗产品物料ID","BIGINT",{"$nulls":4},"","",""]
[15,"item_code","被消耗产品物料编码","VARCHAR",64,null,null,"√","","",""]
[16,"item_name","被消耗产品物料名称","VARCHAR",255,null,null,"√","","",""]
[17,"specification","规格型号","VARCHAR",500,null,null,null,"","",""]
[18,"unit_of_measure","单位","VARCHAR",64,null,null,"√","","",""]
[19,"quantity_consumed","消耗数量","DOUBLE",12,2,null,null,"","",""]
[20,"consume_date","消耗时间","DATETIME",{"$nulls":4},"","",""]
[21,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[22,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[23,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[24,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[25,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[26,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[27,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[28,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[29,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_trans_order","index":86,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_trans_order"]
[null,"显示名称","流转单表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"trans_order_id","流转单ID","BIGINT",null,null,"√","√","","",""]
[2,"trans_order_code","流转单编号","VARCHAR",64,null,null,null,"","",""]
[3,"task_id","生产任务ID","BIGINT",null,null,null,"√","","",""]
[4,"task_code","生产任务编号","VARCHAR",64,null,null,null,"","",""]
[5,"workstation_id","工作站ID","BIGINT",null,null,null,"√","","",""]
[6,"workstation_code","工作站编号","VARCHAR",64,null,null,null,"","",""]
[7,"workstation_name","工作站名称","VARCHAR",255,null,null,null,"","",""]
[8,"process_id","工序ID","BIGINT",{"$nulls":4},"","",""]
[9,"process_code","工序编号","VARCHAR",64,null,null,null,"","",""]
[10,"process_name","工序名称","VARCHAR",255,null,null,null,"","",""]
[11,"workorder_id","生产工单ID","BIGINT",{"$nulls":4},"","",""]
[12,"workorder_code","生产工单编号","VARCHAR",64,null,null,null,"","",""]
[13,"workorder_name","生产工单名称","VARCHAR",255,null,null,null,"","",""]
[14,"batch_code","批次号","VARCHAR",64,null,null,null,"","",""]
[15,"item_id","产品物料ID","BIGINT",{"$nulls":4},"","",""]
[16,"item_code","产品物料编码","VARCHAR",64,null,null,"√","","",""]
[17,"item_name","产品物料名称","VARCHAR",255,null,null,"√","","",""]
[18,"specification","规格型号","VARCHAR",500,null,null,null,"","",""]
[19,"unit_of_measure","单位","VARCHAR",64,null,null,"√","","",""]
[20,"barcode_url","赋码地址","VARCHAR",255,null,null,null,"","",""]
[21,"quantity_transfered","流转数量","DOUBLE",12,2,null,null,"","",""]
[22,"produce_date","生产日期","DATETIME",{"$nulls":4},"","",""]
[23,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[24,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[25,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[26,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[27,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[28,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[29,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[30,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[31,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_user_workstation","index":87,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_user_workstation"]
[null,"显示名称","用户工作站绑定关系"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"user_id","用户ID","BIGINT",null,null,null,"√","","",""]
[3,"user_name","用户名","VARCHAR",64,null,null,null,"","",""]
[4,"nick_name","名称","VARCHAR",30,null,null,null,"","",""]
[5,"workstation_id","工作站ID","BIGINT",null,null,null,"√","","",""]
[6,"workstation_code","工作站编号","VARCHAR",64,null,null,null,"","",""]
[7,"workstation_name","工作站名称","VARCHAR",125,null,null,null,"","",""]
[8,"operation_time","操作时间","DATETIME",{"$nulls":4},"","",""]
[9,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[10,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[11,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[12,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[13,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[14,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[15,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[16,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[17,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_workorder","index":88,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_workorder"]
[null,"显示名称","生产工单表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"workorder_id","工单ID","BIGINT",null,null,"√","√","","",""]
[2,"workorder_code","工单编码","VARCHAR",64,null,null,"√","","",""]
[3,"workorder_name","工单名称","VARCHAR",255,null,null,"√","","",""]
[4,"order_source","来源类型","VARCHAR",64,null,null,"√","","",""]
[5,"source_code","来源单据","VARCHAR",64,null,null,null,"","",""]
[6,"product_id","产品ID","BIGINT",null,null,null,"√","","",""]
[7,"product_code","产品编号","VARCHAR",64,null,null,"√","","",""]
[8,"product_name","产品名称","VARCHAR",255,null,null,"√","","",""]
[9,"product_spc","规格型号","VARCHAR",255,null,null,null,"","",""]
[10,"unit_of_measure","单位","VARCHAR",64,null,null,"√","","",""]
[11,"quantity","生产数量","DOUBLE",14,2,null,"√","0.00","",""]
[12,"quantity_produced","已生产数量","DOUBLE",14,2,null,null,"0.00","",""]
[13,"quantity_changed","调整数量","DOUBLE",14,2,null,null,"0.00","",""]
[14,"quantity_scheduled","已排产数量","DOUBLE",14,2,null,null,"0.00","",""]
[15,"client_id","客户ID","BIGINT",{"$nulls":4},"","",""]
[16,"client_code","客户编码","VARCHAR",64,null,null,null,"","",""]
[17,"client_name","客户名称","VARCHAR",255,null,null,null,"","",""]
[18,"batch_code","批次号","VARCHAR",64,null,null,null,"","",""]
[19,"request_date","需求日期","DATETIME",null,null,null,"√","","",""]
[20,"confirm_date","完成时间","DATETIME",{"$nulls":4},"","",""]
[21,"parent_id","父工单","BIGINT",null,null,null,"√","0","",""]
[22,"ancestors","所有父节点ID","VARCHAR",500,null,null,"√","","",""]
[23,"status","单据状态","VARCHAR",64,null,null,null,"'PREPARE'","",""]
[24,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[25,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[26,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[27,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[28,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[29,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[30,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[31,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[32,"update_time","更新日期","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_workorder_bom","index":89,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_workorder_bom"]
[null,"显示名称","生产工单BOM组成表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"line_id","行ID","BIGINT",null,null,"√","√","","",""]
[2,"workorder_id","生产工单ID","BIGINT",null,null,null,"√","","",""]
[3,"item_id","BOM物料ID","BIGINT",null,null,null,"√","","",""]
[4,"item_code","BOM物料编号","VARCHAR",64,null,null,"√","","",""]
[5,"item_name","BOM物料名称","VARCHAR",255,null,null,"√","","",""]
[6,"item_spc","规格型号","VARCHAR",255,null,null,null,"","",""]
[7,"unit_of_measure","单位","VARCHAR",64,null,null,"√","","",""]
[8,"item_or_product","物料产品标识","VARCHAR",20,null,null,"√","","",""]
[9,"quantity","预计使用量","DOUBLE",14,2,null,"√","0.00","",""]
[10,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[11,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[12,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[13,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[14,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[15,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[16,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[17,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[18,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"pro_workrecord","index":90,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","pro_workrecord"]
[null,"显示名称","上下工记录表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"user_id","用户ID","BIGINT",null,null,null,"√","","",""]
[3,"user_name","用户名","VARCHAR",64,null,null,null,"","",""]
[4,"nick_name","名称","VARCHAR",30,null,null,null,"","",""]
[5,"workstation_id","工作站ID","BIGINT",null,null,null,"√","","",""]
[6,"workstation_code","工作站编号","VARCHAR",64,null,null,null,"","",""]
[7,"workstation_name","工作站名称","VARCHAR",125,null,null,null,"","",""]
[8,"operation_flag","操作类型","CHAR",1,null,null,"√","","",""]
[9,"operation_name","操作名称","VARCHAR",30,null,null,null,"","",""]
[10,"operation_time","操作时间","DATETIME",{"$nulls":4},"","",""]
[11,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[12,"task_id","任务ID","BIGINT",{"$nulls":4},"","",""]
[13,"task_code","任务编码","VARCHAR",64,null,null,null,"","",""]
[14,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[15,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[16,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[17,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[18,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[19,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[20,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[21,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_defect","index":91,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_defect"]
[null,"显示名称","常见缺陷表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"defect_id","缺陷ID","BIGINT",null,null,"√","√","","",""]
[2,"defect_code","缺陷编码","VARCHAR",64,null,null,"√","","",""]
[3,"defect_name","缺陷描述","VARCHAR",500,null,null,"√","","",""]
[4,"index_type","检测项类型","VARCHAR",64,null,null,"√","","",""]
[5,"defect_level","缺陷等级","VARCHAR",64,null,null,"√","","",""]
[6,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[7,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[8,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[9,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[10,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[11,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[12,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[13,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[14,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_defect_photo","index":92,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_defect_photo"]
[null,"显示名称","检测记录照片表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"photo_id","照片主键","INT",null,null,"√","√","","",""]
[2,"photo_path","照片路径","VARCHAR",255,null,null,"√","","",""]
[3,"create_time","创建时间","DATETIME",null,null,null,"√","","",""]
[4,"record_id","记录ID","INT",{"$nulls":4},"","",""]

{"sheet":"qc_defect_record","index":93,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_defect_record"]
[null,"显示名称","检验单缺陷记录表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","缺陷ID","BIGINT",null,null,"√","√","","",""]
[2,"qc_type","检验单类型","VARCHAR",64,null,null,"√","","",""]
[3,"qc_id","检验单ID","BIGINT",null,null,null,"√","","",""]
[4,"line_id","检验单行ID","BIGINT",null,null,null,"√","","",""]
[5,"defect_name","缺陷描述","VARCHAR",500,null,null,"√","","",""]
[6,"defect_level","缺陷等级","VARCHAR",64,null,null,"√","","",""]
[7,"defect_quantity","缺陷数量","INT",{"$nulls":4},"1","",""]
[8,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[9,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[10,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[11,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[12,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[13,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[14,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[15,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[16,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_index","index":94,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_index"]
[null,"显示名称","检测项表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"index_id","检测项ID","BIGINT",null,null,"√","√","","",""]
[2,"index_code","检测项编码","VARCHAR",64,null,null,"√","","",""]
[3,"index_name","检测项名称","VARCHAR",255,null,null,"√","","",""]
[4,"index_type","检测项类型","VARCHAR",64,null,null,"√","","",""]
[5,"qc_tool","检测工具","VARCHAR",255,null,null,null,"","",""]
[6,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[7,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[8,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[9,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[10,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[11,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[12,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[13,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[14,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_ipqc","index":95,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_ipqc"]
[null,"显示名称","过程检验单表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"ipqc_id","检验单ID","BIGINT",null,null,"√","√","","",""]
[2,"ipqc_code","检验单编号","VARCHAR",64,null,null,"√","","",""]
[3,"ipqc_name","检验单名称","VARCHAR",255,null,null,null,"","",""]
[4,"ipqc_type","检验类型","VARCHAR",64,null,null,"√","","",""]
[5,"template_id","检验模板ID","BIGINT",null,null,null,"√","","",""]
[6,"workorder_id","工单ID","BIGINT",null,null,null,"√","","",""]
[7,"workorder_code","工单编码","VARCHAR",64,null,null,null,"","",""]
[8,"workorder_name","工单名称","VARCHAR",255,null,null,null,"","",""]
[9,"task_id","任务ID","BIGINT",{"$nulls":4},"","",""]
[10,"task_code","任务编号","VARCHAR",64,null,null,null,"","",""]
[11,"task_name","任务名称","VARCHAR",255,null,null,null,"","",""]
[12,"workstation_id","工作站ID","BIGINT",null,null,null,"√","","",""]
[13,"workstation_code","工作站编号","VARCHAR",64,null,null,null,"","",""]
[14,"workstation_name","工作站名称","VARCHAR",255,null,null,null,"","",""]
[15,"process_id","工序ID","BIGINT",{"$nulls":4},"","",""]
[16,"process_code","工序编码","VARCHAR",64,null,null,null,"","",""]
[17,"process_name","工序名称","VARCHAR",255,null,null,null,"","",""]
[18,"item_id","产品物料ID","BIGINT",null,null,null,"√","","",""]
[19,"item_code","产品物料编码","VARCHAR",64,null,null,null,"","",""]
[20,"item_name","产品物料名称","VARCHAR",255,null,null,null,"","",""]
[21,"specification","规格型号","VARCHAR",500,null,null,null,"","",""]
[22,"unit_of_measure","单位","VARCHAR",64,null,null,null,"","",""]
[23,"quantity_check","检测数量","DOUBLE",12,4,null,null,"1.0000","",""]
[24,"quantity_unqualified","不合格数","DOUBLE",12,4,null,null,"0.0000","",""]
[25,"quantity_qualified","合格品数量","DOUBLE",12,4,null,null,"","",""]
[26,"cr_rate","致命缺陷率","DOUBLE",12,2,null,null,"0.00","",""]
[27,"maj_rate","严重缺陷率","DOUBLE",12,2,null,null,"0.00","",""]
[28,"min_rate","轻微缺陷率","DOUBLE",12,2,null,null,"0.00","",""]
[29,"cr_quantity","致命缺陷数量","INT",{"$nulls":4},"0","",""]
[30,"maj_quantity","严重缺陷数量","INT",{"$nulls":4},"0","",""]
[31,"min_quantity","轻微缺陷数量","INT",{"$nulls":4},"0","",""]
[32,"check_result","检测结果","VARCHAR",64,null,null,null,"","",""]
[33,"inspect_date","检测日期","DATETIME",{"$nulls":4},"","",""]
[34,"inspector","检测人员","VARCHAR",64,null,null,null,"","",""]
[35,"status","单据状态","VARCHAR",64,null,null,null,"","",""]
[36,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[37,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[38,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[39,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[40,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[41,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[42,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[43,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[44,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_ipqc_line","index":96,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_ipqc_line"]
[null,"显示名称","过程检验单行表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"line_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"ipqc_id","检验单ID","BIGINT",null,null,null,"√","","",""]
[3,"index_id","检测项ID","BIGINT",null,null,null,"√","","",""]
[4,"index_code","检测项编码","VARCHAR",64,null,null,null,"","",""]
[5,"index_name","检测项名称","VARCHAR",255,null,null,null,"","",""]
[6,"index_type","检测项类型","VARCHAR",64,null,null,null,"","",""]
[7,"qc_tool","检测工具","VARCHAR",255,null,null,null,"","",""]
[8,"check_method","检测要求","VARCHAR",500,null,null,null,"","",""]
[9,"stander_val","标准值","DOUBLE",12,4,null,null,"","",""]
[10,"unit_of_measure","单位","VARCHAR",64,null,null,null,"","",""]
[11,"threshold_max","误差上限","DOUBLE",12,4,null,null,"","",""]
[12,"threshold_min","误差下限","DOUBLE",12,4,null,null,"","",""]
[13,"cr_quantity","致命缺陷数量","INT",{"$nulls":4},"0","",""]
[14,"maj_quantity","严重缺陷数量","INT",{"$nulls":4},"0","",""]
[15,"min_quantity","轻微缺陷数量","INT",{"$nulls":4},"0","",""]
[16,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[17,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[18,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[19,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[20,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[21,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[22,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[23,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[24,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_iqc","index":97,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_iqc"]
[null,"显示名称","来料检验单表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"iqc_id","来料检验单ID","BIGINT",null,null,"√","√","","",""]
[2,"iqc_code","来料检验单编号","VARCHAR",64,null,null,"√","","",""]
[3,"iqc_name","来料检验单名称","VARCHAR",500,null,null,"√","","",""]
[4,"template_id","检验模板ID","BIGINT",null,null,null,"√","","",""]
[5,"vendor_id","供应商ID","BIGINT",null,null,null,"√","","",""]
[6,"vendor_code","供应商编码","VARCHAR",64,null,null,"√","","",""]
[7,"vendor_name","供应商名称","VARCHAR",255,null,null,"√","","",""]
[8,"vendor_nick","供应商简称","VARCHAR",255,null,null,null,"","",""]
[9,"vendor_batch","供应商批次号","VARCHAR",64,null,null,null,"","",""]
[10,"item_id","产品物料ID","BIGINT",null,null,null,"√","","",""]
[11,"item_code","产品物料编码","VARCHAR",64,null,null,null,"","",""]
[12,"item_name","产品物料名称","VARCHAR",255,null,null,null,"","",""]
[13,"specification","规格型号","VARCHAR",500,null,null,null,"","",""]
[14,"unit_of_measure","单位","VARCHAR",64,null,null,null,"","",""]
[15,"quantity_min_check","最低检测数","INT",{"$nulls":4},"1","",""]
[16,"quantity_max_unqualified","最大不合格数","INT",{"$nulls":4},"0","",""]
[17,"quantity_recived","本次接收数量","DOUBLE",12,2,null,"√","","",""]
[18,"quantity_check","本次检测数量","INT",null,null,null,"√","","",""]
[19,"quantity_unqualified","不合格数","INT",{"$nulls":4},"0","",""]
[20,"cr_rate","致命缺陷率","DOUBLE",12,2,null,null,"0.00","",""]
[21,"maj_rate","严重缺陷率","DOUBLE",12,2,null,null,"0.00","",""]
[22,"min_rate","轻微缺陷率","DOUBLE",12,2,null,null,"0.00","",""]
[23,"cr_quantity","致命缺陷数量","INT",{"$nulls":4},"0","",""]
[24,"maj_quantity","严重缺陷数量","INT",{"$nulls":4},"0","",""]
[25,"min_quantity","轻微缺陷数量","INT",{"$nulls":4},"0","",""]
[26,"check_result","检测结果","VARCHAR",64,null,null,null,"","",""]
[27,"recive_date","来料日期","DATETIME",{"$nulls":4},"","",""]
[28,"inspect_date","检测日期","DATETIME",{"$nulls":4},"","",""]
[29,"inspector","检测人员","VARCHAR",64,null,null,null,"","",""]
[30,"status","单据状态","VARCHAR",64,null,null,null,"","",""]
[31,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[32,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[33,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[34,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[35,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[36,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[37,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[38,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[39,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_iqc_line","index":98,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_iqc_line"]
[null,"显示名称","来料检验单行表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"line_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"iqc_id","检验单ID","BIGINT",null,null,null,"√","","",""]
[3,"index_id","检测项ID","BIGINT",null,null,null,"√","","",""]
[4,"index_code","检测项编码","VARCHAR",64,null,null,null,"","",""]
[5,"index_name","检测项名称","VARCHAR",255,null,null,null,"","",""]
[6,"index_type","检测项类型","VARCHAR",64,null,null,null,"","",""]
[7,"qc_tool","检测工具","VARCHAR",255,null,null,null,"","",""]
[8,"check_method","检测要求","VARCHAR",500,null,null,null,"","",""]
[9,"stander_val","标准值","DOUBLE",12,4,null,null,"","",""]
[10,"unit_of_measure","单位","VARCHAR",64,null,null,null,"","",""]
[11,"threshold_max","误差上限","DOUBLE",12,4,null,null,"","",""]
[12,"threshold_min","误差下限","DOUBLE",12,4,null,null,"","",""]
[13,"cr_quantity","致命缺陷数量","INT",{"$nulls":4},"0","",""]
[14,"maj_quantity","严重缺陷数量","INT",{"$nulls":4},"0","",""]
[15,"min_quantity","轻微缺陷数量","INT",{"$nulls":4},"0","",""]
[16,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[17,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[18,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[19,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[20,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[21,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[22,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[23,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[24,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_oqc","index":99,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_oqc"]
[null,"显示名称","出货检验单表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"oqc_id","出货检验单ID","BIGINT",null,null,"√","√","","",""]
[2,"oqc_code","出货检验单编号","VARCHAR",64,null,null,"√","","",""]
[3,"oqc_name","出货检验单名称","VARCHAR",500,null,null,null,"","",""]
[4,"template_id","检验模板ID","BIGINT",null,null,null,"√","","",""]
[5,"client_id","客户ID","BIGINT",null,null,null,"√","","",""]
[6,"client_code","客户编码","VARCHAR",64,null,null,"√","","",""]
[7,"client_name","客户名称","VARCHAR",255,null,null,"√","","",""]
[8,"batch_code","批次号","VARCHAR",64,null,null,null,"","",""]
[9,"item_id","产品物料ID","BIGINT",null,null,null,"√","","",""]
[10,"item_code","产品物料编码","VARCHAR",64,null,null,null,"","",""]
[11,"item_name","产品物料名称","VARCHAR",255,null,null,null,"","",""]
[12,"specification","规格型号","VARCHAR",500,null,null,null,"","",""]
[13,"unit_of_measure","单位","VARCHAR",64,null,null,null,"","",""]
[14,"quantity_min_check","最低检测数","DOUBLE",12,4,null,null,"1.0000","",""]
[15,"quantity_max_unqualified","最大不合格数","DOUBLE",12,4,null,null,"0.0000","",""]
[16,"quantity_out","发货数量","DOUBLE",12,4,null,"√","","",""]
[17,"quantity_check","本次检测数量","DOUBLE",12,4,null,"√","","",""]
[18,"quantity_unqualified","不合格数","DOUBLE",12,4,null,null,"0.0000","",""]
[19,"quantity_quanlified","合格数量","DOUBLE",12,4,null,null,"0.0000","",""]
[20,"cr_rate","致命缺陷率","DOUBLE",12,4,null,null,"0.0000","",""]
[21,"maj_rate","严重缺陷率","DOUBLE",12,4,null,null,"0.0000","",""]
[22,"min_rate","轻微缺陷率","DOUBLE",12,4,null,null,"0.0000","",""]
[23,"cr_quantity","致命缺陷数量","DOUBLE",12,4,null,null,"0.0000","",""]
[24,"maj_quantity","严重缺陷数量","DOUBLE",12,4,null,null,"0.0000","",""]
[25,"min_quantity","轻微缺陷数量","DOUBLE",12,4,null,null,"0.0000","",""]
[26,"check_result","检测结果","VARCHAR",64,null,null,null,"","",""]
[27,"out_date","出货日期","DATETIME",{"$nulls":4},"","",""]
[28,"inspect_date","检测日期","DATETIME",{"$nulls":4},"","",""]
[29,"inspector","检测人员","VARCHAR",64,null,null,null,"","",""]
[30,"status","单据状态","VARCHAR",64,null,null,null,"","",""]
[31,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[32,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[33,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[34,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[35,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[36,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[37,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[38,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[39,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_oqc_line","index":100,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_oqc_line"]
[null,"显示名称","出货检验单行表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"line_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"oqc_id","检验单ID","BIGINT",null,null,null,"√","","",""]
[3,"index_id","检测项ID","BIGINT",null,null,null,"√","","",""]
[4,"index_code","检测项编码","VARCHAR",64,null,null,null,"","",""]
[5,"index_name","检测项名称","VARCHAR",255,null,null,null,"","",""]
[6,"index_type","检测项类型","VARCHAR",64,null,null,null,"","",""]
[7,"qc_tool","检测工具","VARCHAR",255,null,null,null,"","",""]
[8,"check_method","检测要求","VARCHAR",500,null,null,null,"","",""]
[9,"stander_val","标准值","DOUBLE",12,4,null,null,"","",""]
[10,"unit_of_measure","单位","VARCHAR",64,null,null,null,"","",""]
[11,"threshold_max","误差上限","DOUBLE",12,4,null,null,"","",""]
[12,"threshold_min","误差下限","DOUBLE",12,4,null,null,"","",""]
[13,"cr_quantity","致命缺陷数量","DOUBLE",12,4,null,null,"0.0000","",""]
[14,"maj_quantity","严重缺陷数量","DOUBLE",12,4,null,null,"0.0000","",""]
[15,"min_quantity","轻微缺陷数量","DOUBLE",12,4,null,null,"0.0000","",""]
[16,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[17,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[18,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[19,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[20,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[21,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[22,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[23,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[24,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_template","index":101,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_template"]
[null,"显示名称","检测模板表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"template_id","检测模板ID","BIGINT",null,null,"√","√","","",""]
[2,"template_code","检测模板编号","VARCHAR",64,null,null,"√","","",""]
[3,"template_name","检测模板名称","VARCHAR",255,null,null,"√","","",""]
[4,"qc_types","检测种类","VARCHAR",255,null,null,"√","","",""]
[5,"enable_flag","是否启用","CHAR",1,null,null,null,"'Y'","",""]
[6,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[7,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[8,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[9,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[10,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[11,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[12,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[13,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[14,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_template_index","index":102,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_template_index"]
[null,"显示名称","检测模板-检测项表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"template_id","检测模板ID","BIGINT",null,null,null,"√","","",""]
[3,"index_id","检测项ID","BIGINT",null,null,null,"√","","",""]
[4,"index_code","检测项编码","VARCHAR",64,null,null,"√","","",""]
[5,"index_name","检测项名称","VARCHAR",255,null,null,"√","","",""]
[6,"index_type","检测项类型","VARCHAR",64,null,null,"√","","",""]
[7,"qc_tool","检测工具","VARCHAR",255,null,null,null,"","",""]
[8,"check_method","检测要求","VARCHAR",500,null,null,null,"","",""]
[9,"stander_val","标准值","DOUBLE",12,4,null,null,"","",""]
[10,"unit_of_measure","单位","VARCHAR",64,null,null,null,"","",""]
[11,"threshold_max","误差上限","DOUBLE",12,4,null,null,"","",""]
[12,"threshold_min","误差下限","DOUBLE",12,4,null,null,"","",""]
[13,"doc_url","说明图","VARCHAR",255,null,null,null,"","",""]
[14,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[15,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[16,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[17,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[18,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[19,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[20,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[21,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[22,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"qc_template_product","index":103,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","qc_template_product"]
[null,"显示名称","检测模板-产品表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","记录ID","BIGINT",null,null,"√","√","","",""]
[2,"template_id","检测模板ID","BIGINT",null,null,null,"√","","",""]
[3,"item_id","产品物料ID","BIGINT",null,null,null,"√","","",""]
[4,"item_code","产品物料编码","VARCHAR",64,null,null,null,"","",""]
[5,"item_name","产品物料名称","VARCHAR",255,null,null,null,"","",""]
[6,"specification","规格型号","VARCHAR",500,null,null,null,"","",""]
[7,"unit_of_measure","单位","VARCHAR",64,null,null,null,"","",""]
[8,"quantity_check","最低检测数","INT",{"$nulls":4},"1","",""]
[9,"quantity_unqualified","最大不合格数","INT",{"$nulls":4},"0","",""]
[10,"cr_rate","最大致命缺陷率","DOUBLE",12,2,null,null,"0.00","",""]
[11,"maj_rate","最大严重缺陷率","DOUBLE",12,2,null,null,"0.00","",""]
[12,"min_rate","最大轻微缺陷率","DOUBLE",12,2,null,null,"100.00","",""]
[13,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[14,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[15,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[16,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[17,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[18,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[19,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[20,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[21,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"cal_holiday","index":104,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","cal_holiday"]
[null,"显示名称","节假日设置"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"holiday_id","流水号","BIGINT",null,null,"√","√","","",""]
[2,"the_day","日期","DATETIME",{"$nulls":4},"","",""]
[3,"holiday_type","日期类型","VARCHAR",64,null,null,null,"","",""]
[4,"start_time","开始时间","DATETIME",{"$nulls":4},"","",""]
[5,"end_time","结束时间","DATETIME",{"$nulls":4},"","",""]
[6,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[7,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[8,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[9,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[10,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[11,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[12,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[13,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[14,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"cal_plan","index":105,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","cal_plan"]
[null,"显示名称","排班计划表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"plan_id","计划ID","BIGINT",null,null,"√","√","","",""]
[2,"plan_code","计划编号","VARCHAR",64,null,null,"√","","",""]
[3,"plan_name","计划名称","VARCHAR",255,null,null,"√","","",""]
[4,"calendar_type","班组类型","VARCHAR",64,null,null,null,"","",""]
[5,"start_date","开始日期","DATETIME",null,null,null,"√","","",""]
[6,"end_date","结束日期","DATETIME",null,null,null,"√","","",""]
[7,"shift_type","轮班方式","VARCHAR",64,null,null,null,"","",""]
[8,"shift_method","倒班方式","VARCHAR",64,null,null,null,"","",""]
[9,"shift_count","数","INT",{"$nulls":4},"","",""]
[10,"status","状态","VARCHAR",64,null,null,null,"'PREPARE'","",""]
[11,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[12,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[13,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[14,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[15,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[16,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[17,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[18,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[19,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"cal_plan_team","index":106,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","cal_plan_team"]
[null,"显示名称","计划班组表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","流水号","BIGINT",null,null,"√","√","","",""]
[2,"plan_id","计划ID","BIGINT",null,null,null,"√","","",""]
[3,"team_id","班组ID","BIGINT",null,null,null,"√","","",""]
[4,"team_code","班组编号","VARCHAR",64,null,null,null,"","",""]
[5,"team_name","班组名称","VARCHAR",64,null,null,null,"","",""]
[6,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[7,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[8,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[9,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[10,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[11,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[12,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[13,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[14,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"cal_shift","index":107,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","cal_shift"]
[null,"显示名称","计划班次表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"shift_id","班次ID","BIGINT",null,null,"√","√","","",""]
[2,"plan_id","计划ID","BIGINT",null,null,null,"√","","",""]
[3,"order_num","序号","INT",null,null,null,"√","","",""]
[4,"shift_name","班次名称","VARCHAR",64,null,null,"√","","",""]
[5,"start_time","开始时间","VARCHAR",10,null,null,"√","","",""]
[6,"end_time","结束时间","VARCHAR",10,null,null,"√","","",""]
[7,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[8,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[9,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[10,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[11,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[12,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[13,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[14,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[15,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"cal_team","index":108,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","cal_team"]
[null,"显示名称","班组表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"team_id","班组ID","BIGINT",null,null,"√","√","","",""]
[2,"team_code","班组编号","VARCHAR",64,null,null,"√","","",""]
[3,"team_name","班组名称","VARCHAR",255,null,null,"√","","",""]
[4,"calendar_type","班组类型","VARCHAR",64,null,null,null,"","",""]
[5,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[6,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[7,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[8,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[9,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[10,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[11,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[12,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[13,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"cal_teamshift","index":109,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","cal_teamshift"]
[null,"显示名称","班组排班表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"record_id","流水号","BIGINT",null,null,"√","√","","",""]
[2,"the_day","日期","VARCHAR",64,null,null,"√","","",""]
[3,"team_id","班组ID","BIGINT",null,null,null,"√","","",""]
[4,"team_name","班组名称","VARCHAR",255,null,null,null,"","",""]
[5,"shift_id","班次ID","BIGINT",null,null,null,"√","","",""]
[6,"shift_name","班次名称","VARCHAR",255,null,null,null,"","",""]
[7,"order_num","序号","INT",{"$nulls":4},"","",""]
[8,"plan_id","计划ID","BIGINT",{"$nulls":4},"","",""]
[9,"calendar_type","班组类型","VARCHAR",64,null,null,null,"","",""]
[10,"shift_type","轮班方式","VARCHAR",64,null,null,null,"","",""]
[11,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[12,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[13,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[14,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[15,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[16,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[17,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[18,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[19,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]

{"sheet":"cal_team_member","index":110,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["目录","数据表代码","cal_team_member"]
[null,"显示名称","班组成员表"]
[]
["#","字段","名称","数据类型","长度","小数位数","主键","非空","默认值","备注说明","属性1"]
[1,"member_id","班组成员ID","BIGINT",null,null,"√","√","","",""]
[2,"team_id","班组ID","BIGINT",null,null,null,"√","","",""]
[3,"user_id","用户ID","BIGINT",null,null,null,"√","","",""]
[4,"user_name","用户名","VARCHAR",64,null,null,"√","","",""]
[5,"nick_name","用户昵称","VARCHAR",64,null,null,null,"","",""]
[6,"tel","电话","VARCHAR",64,null,null,null,"","",""]
[7,"remark","备注","VARCHAR",500,null,null,null,"","",""]
[8,"attr1","预留字段1","VARCHAR",64,null,null,null,"","",""]
[9,"attr2","预留字段2","VARCHAR",255,null,null,null,"","",""]
[10,"attr3","预留字段3","INT",{"$nulls":4},"0","",""]
[11,"attr4","预留字段4","INT",{"$nulls":4},"0","",""]
[12,"create_by","创建者","VARCHAR",64,null,null,null,"","",""]
[13,"create_time","创建时间","DATETIME",{"$nulls":4},"","",""]
[14,"update_by","更新者","VARCHAR",64,null,null,null,"","",""]
[15,"update_time","更新时间","DATETIME",{"$nulls":4},"","",""]