{"text_format":"2","workbook":"xlsx","n_sheets":21,"sheets":["总览","系统基础(Sys)","审批流程(Approval)","钉钉集成(DingTalk)","GoView可视化","S0 基础主数据","S1 产销协同","S2 生产计划","S3 物料计划","S4 采购","S5 仓储来料","S6 生产执行","S7 成品管理","S8 预警异常","S9 管理看板KPI","智慧运营(SmartOps)","主数据(MD)","集成(Intg)","移动端(Mobile)","Demo表","其他"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":166,"n_cols":5,"rows_kept":166,"cut":false,"hidden":false,"merged":[]}
["序号","分类","表名","表说明","记录数"]
[1,"系统基础(Sys)","SysAlipayAuthInfo","支付宝授权记录表",0]
[2,"系统基础(Sys)","SysAlipayTransaction","支付宝交易记录表",0]
[3,"系统基础(Sys)","SysCodeGen","代码生成表",0]
[4,"系统基础(Sys)","SysCodeGenConfig","代码生成字段配置表",0]
[5,"系统基础(Sys)","SysConfig","系统配置参数表",17]
[6,"系统基础(Sys)","SysDictData","系统字典值表",493]
[7,"系统基础(Sys)","SysDictDataTenant","系统租户字典值表",0]
[8,"系统基础(Sys)","SysDictType","系统字典类型表",53]
[9,"系统基础(Sys)","SysFile","系统文件表",0]
[10,"系统基础(Sys)","SysFileProvider","系统文件存储提供者表",0]
[11,"系统基础(Sys)","SysJobCluster","系统作业集群表",0]
[12,"系统基础(Sys)","SysJobDetail","系统作业信息表",7]
[13,"系统基础(Sys)","SysJobTrigger","系统作业触发器表",6]
[14,"系统基础(Sys)","SysJobTriggerRecord","系统作业触发器运行记录表",116]
[15,"系统基础(Sys)","SysLang","语言配置",88]
[16,"系统基础(Sys)","SysLangText","翻译表",0]
[17,"系统基础(Sys)","SysLdap","系统域登录信息配置表",0]
[18,"系统基础(Sys)","SysLogDiff","系统差异日志表",0]
[19,"系统基础(Sys)","SysLogEx","系统异常日志表",20]
[20,"系统基础(Sys)","SysLogOp","系统操作日志表",1749]
[21,"系统基础(Sys)","SysLogVis","系统访问日志表",245]
[22,"系统基础(Sys)","SysMenu","系统菜单表",296]
[23,"系统基础(Sys)","SysNotice","系统通知公告表",0]
[24,"系统基础(Sys)","SysNoticeUser","系统通知公告用户表",0]
[25,"系统基础(Sys)","SysOnlineUser","系统在线用户表",0]
[26,"系统基础(Sys)","SysOpenAccess","开放接口身份表",0]
[27,"系统基础(Sys)","SysOrg","系统机构表",11]
[28,"系统基础(Sys)","SysPlugin","系统动态插件表",0]
[29,"系统基础(Sys)","SysPos","系统职位表",17]
[30,"系统基础(Sys)","SysPrint","系统打印模板表",0]
[31,"系统基础(Sys)","SysRegion","系统行政地区表",0]
[32,"系统基础(Sys)","SysRole","系统角色表",7]
[33,"系统基础(Sys)","SysRoleMenu","系统角色菜单表",634]
[34,"系统基础(Sys)","SysRoleOrg","系统角色机构表",0]
[35,"系统基础(Sys)","SysSchedule","系统日程表",0]
[36,"系统基础(Sys)","SysTemplate","系统模板表",0]
[37,"系统基础(Sys)","SysTenant","系统租户表",2]
[38,"系统基础(Sys)","SysTenantConfig","系统租户配置参数表",0]
[39,"系统基础(Sys)","SysTenantConfigData","系统租户配置参数值表",0]
[40,"系统基础(Sys)","SysTenantMenu","系统租户菜单表",396]
[41,"系统基础(Sys)","SysUser","系统用户表",9]
[42,"系统基础(Sys)","SysUserConfig","系统用户配置参数表",0]
[43,"系统基础(Sys)","SysUserConfigData","系统租户配置参数值表",0]
[44,"系统基础(Sys)","SysUserExtOrg","系统用户扩展机构表",2]
[45,"系统基础(Sys)","SysUserLdap","系统用户域配置表",0]
[46,"系统基础(Sys)","SysUserMenu","系统用户菜单快捷导航表",0]
[47,"系统基础(Sys)","SysUserRegWay","系统用户注册方案表",0]
[48,"系统基础(Sys)","SysUserRole","系统用户角色表",7]
[49,"系统基础(Sys)","SysWechatPay","系统微信支付表",0]
[50,"系统基础(Sys)","SysWechatRefund","系统微信支付退款表",0]
[51,"系统基础(Sys)","SysWechatUser","系统微信用户表",0]
[52,"审批流程(Approval)","ApprovalFlow","审批流程信息表",0]
[53,"审批流程(Approval)","ApprovalFlowRecord","审批流流程记录",0]
[54,"审批流程(Approval)","ApprovalForm","审批流表单",0]
[55,"审批流程(Approval)","ApprovalFormRecord","审批流表单记录",0]
[56,"钉钉集成(DingTalk)","DingTalkRoleUser","钉钉角色表",0]
[57,"钉钉集成(DingTalk)","DingTalkUser","钉钉用户表",0]
[58,"钉钉集成(DingTalk)","ding_talk_dept","钉钉部门表",0]
[59,"钉钉集成(DingTalk)","ding_talk_wokerflow_config","审批配置表",0]
[60,"钉钉集成(DingTalk)","ding_talk_wokerflow_log","钉钉审批日志",0]
[61,"GoView可视化","GoViewPro","GoView 项目表",0]
[62,"GoView可视化","GoViewProData","GoView 项目数据表",0]
[63,"S0 基础主数据","ado_s0_mfg_element_param","S0 生产要素参数",0]
[64,"S0 基础主数据","ado_s0_mfg_line_master","生产线主数据表",0]
[65,"S0 基础主数据","ado_s0_mfg_line_material","S0 线边物料",0]
[66,"S0 基础主数据","ado_s0_mfg_line_post","S0 线体岗位",0]
[67,"S0 基础主数据","ado_s0_mfg_line_post_skill","S0 线体岗位技能",0]
[68,"S0 基础主数据","ado_s0_mfg_material_process_element","S0 物料工艺要素",0]
[69,"S0 基础主数据","ado_s0_mfg_material_substitution","S0 物料替代",0]
[70,"S0 基础主数据","ado_s0_mfg_person_skill","S0 人员技能主数据",0]
[71,"S0 基础主数据","ado_s0_mfg_person_skill_assignment","S0 人员技能分配",0]
[72,"S0 基础主数据","ado_s0_mfg_preprocess_element","S0 前处理要素头",0]
[73,"S0 基础主数据","ado_s0_mfg_preprocess_element_param","S0 前处理要素参数行",0]
[74,"S0 基础主数据","ado_s0_mfg_product_structure_master","标准BOM行维护（复刻 ProductStructureMaster）",0]
[75,"S0 基础主数据","ado_s0_mfg_product_structure_op","标准BOM行工序（复刻 ProductStructureOp）",0]
[76,"S0 基础主数据","ado_s0_mfg_production_line","S0 产线",0]
[77,"S0 基础主数据","ado_s0_mfg_routing","S0 工艺路线头",0]
[78,"S0 基础主数据","ado_s0_mfg_routing_op_detail","S0 标准工艺路线明细",0]
[79,"S0 基础主数据","ado_s0_mfg_routing_operation","S0 工艺路线工序行",0]
[80,"S0 基础主数据","ado_s0_mfg_sop_document","S0 SOP 文档",0]
[81,"S0 基础主数据","ado_s0_mfg_sop_file_type","S0 SOP 文件类型",0]
[82,"S0 基础主数据","ado_s0_mfg_standard_operation","S0 标准工序",0]
[83,"S0 基础主数据","ado_s0_mfg_std_op_master","标准工序主数据表",0]
[84,"S0 基础主数据","ado_s0_mfg_work_center","S0 工作中心",0]
[85,"S0 基础主数据","ado_s0_mfg_work_ord_control","S0 工单控制参数设置",0]
[86,"S0 基础主数据","ado_s0_mfg_work_order_control","S0 工单控制参数",0]
[87,"S0 基础主数据","ado_s0_sales_cust_master","客户主数据（复刻 CustMaster）",1]
[88,"S0 基础主数据","ado_s0_sales_item_master","物料主数据（复刻 ItemMaster）",0]
[89,"S0 基础主数据","ado_s0_sales_item_substitute_detail","物料替代关系表",0]
[90,"S0 基础主数据","ado_s0_sales_priority_code","订单优先级配置（复刻 PriorityCode）",0]
[91,"S1 产销协同","ado_s1_delivery_change","交付变更",0]
[92,"S1 产销协同","ado_s1_delivery_promise","交付承诺",0]
[93,"S1 产销协同","ado_s1_sales_order","销售订单头",2]
[94,"S1 产销协同","ado_s1_sales_order_line","销售订单行",2]
[95,"S2 生产计划","ado_s2_capacity_snapshot","产能快照",0]
[96,"S2 生产计划","ado_s2_mps_plan","主生产计划",0]
[97,"S2 生产计划","ado_s2_work_order","工单",2]
[98,"S2 生产计划","ado_s2_work_order_op","工单工序执行",0]
[99,"S3 物料计划","ado_s3_material_kit_status","物料齐套状态",0]
[100,"S3 物料计划","ado_s3_mrp_result","MRP结果",0]
[101,"S3 物料计划","ado_s3_supplier_delivery_perf","供应商准交绩效",0]
[102,"S4 采购","ado_s4_purchase_order","采购订单头",0]
[103,"S4 采购","ado_s4_purchase_order_line","采购订单行",0]
[104,"S4 采购","ado_s4_receipt","收货记录",0]
[105,"S4 采购","ado_s4_return","退货记录",0]
[106,"S5 仓储来料","ado_s5_inventory_balance","库存余额",0]
[107,"S5 仓储来料","ado_s5_inventory_txn","库存流水",0]
[108,"S5 仓储来料","ado_s5_iqc_result","来料检验",0]
[109,"S6 生产执行","ado_s6_equipment_oee","设备OEE快照",0]
[110,"S6 生产执行","ado_s6_ipqc_result","过程检验",0]
[111,"S6 生产执行","ado_s6_report_work","报工记录",0]
[112,"S7 成品管理","ado_s7_fg_inbound","成品入库",0]
[113,"S7 成品管理","ado_s7_fg_outbound","成品出库",0]
[114,"S7 成品管理","ado_s7_oqc_result","成品检验",0]
[115,"S7 成品管理","ado_s7_trace_serial","序列号追溯",0]
[116,"S8 预警异常","ado_s8_alert_channel","S8预警通道",0]
[117,"S8 预警异常","ado_s8_alert_model","S8预警模型",0]
[118,"S8 预警异常","ado_s8_alert_record","S8预警记录",2]
[119,"S8 预警异常","ado_s8_incident","S8异常单",0]
[120,"S8 预警异常","ado_s8_incident_action","S8异常处置",0]
[121,"S8 预警异常","ado_s8_incident_dispatch","S8异常分派",0]
[122,"S8 预警异常","ado_s8_incident_verify","S8异常验证关闭",0]
[123,"S8 预警异常","ado_s8_rule_condition","S8规则条件",0]
[124,"S8 预警异常","ado_s8_rule_eval_log","S8规则评估日志",0]
[125,"S8 预警异常","ado_s8_rule_hit_fact","S8规则命中事实",0]
[126,"S8 预警异常","ado_s8_rule_model","S8监控规则模型",0]
[127,"S8 预警异常","ado_s8_rule_scope","S8规则范围",0]
[128,"S9 管理看板KPI","ado_s9_calc_log","KPI计算日志",0]
[129,"S9 管理看板KPI","ado_s9_calc_task","KPI计算任务",0]
[130,"S9 管理看板KPI","ado_s9_chatbi_query_log","ChatBI查询日志",0]
[131,"S9 管理看板KPI","ado_s9_chatbi_semantic","ChatBI语义模型",0]
[132,"S9 管理看板KPI","ado_s9_dashboard_snapshot","管理看板快照",0]
[133,"S9 管理看板KPI","ado_s9_drilldown_cache","下钻缓存",0]
[134,"S9 管理看板KPI","ado_s9_kpi_def","KPI定义",3]
[135,"S9 管理看板KPI","ado_s9_kpi_formula","KPI公式版本",0]
[136,"S9 管理看板KPI","ado_s9_kpi_page_binding","KPI页面绑定",0]
[137,"S9 管理看板KPI","ado_s9_kpi_relation","KPI父子关系",0]
[138,"S9 管理看板KPI","ado_s9_kpi_value_l1_day","KPI一级日值",13]
[139,"S9 管理看板KPI","ado_s9_kpi_value_l2_day","KPI二级日值",10]
[140,"S9 管理看板KPI","ado_s9_kpi_value_l3_day","KPI三级日值",2]
[141,"智慧运营(SmartOps)","ado_smart_ops_home_module","九宫格模块呈现",0]
[142,"智慧运营(SmartOps)","ado_smart_ops_layout_item","智慧运营布局行",10]
[143,"智慧运营(SmartOps)","ado_smart_ops_metric_catalog","智慧运营指标字典",12]
[144,"主数据(MD)","ado_md_calendar","工作日历",0]
[145,"主数据(MD)","ado_md_customer","客户主数据",0]
[146,"主数据(MD)","ado_md_item","物料主数据",0]
[147,"主数据(MD)","ado_md_process_route","工艺路线",0]
[148,"主数据(MD)","ado_md_process_route_step","工艺步骤",0]
[149,"主数据(MD)","ado_md_supplier","供应商主数据",0]
[150,"主数据(MD)","ado_md_work_center","工作中心",0]
[151,"集成(Intg)","ado_intg_code_mapping","码值映射",0]
[152,"集成(Intg)","ado_intg_connector","连接器配置",0]
[153,"集成(Intg)","ado_intg_event_raw","原始事件落地",0]
[154,"集成(Intg)","ado_intg_field_mapping","字段映射",0]
[155,"集成(Intg)","ado_intg_sync_checkpoint","同步游标",0]
[156,"集成(Intg)","ado_intg_system","外部系统注册",0]
[157,"移动端(Mobile)","ado_mobile_alert_ack","移动端预警签收",0]
[158,"移动端(Mobile)","ado_mobile_incident_action","移动端异常操作轨迹",0]
[159,"移动端(Mobile)","ado_mobile_kpi_snapshot","移动端KPI快照",0]
[160,"移动端(Mobile)","ado_mobile_sync_cursor","移动端同步游标",0]
[161,"Demo表","ado_orders","AiDOP Demo 订单",0]
[162,"Demo表","ado_plans","AiDOP Demo 计划",0]
[163,"Demo表","ado_work_orders","AiDOP Demo 工单",0]
[164,"其他","TestViewSysUser","VIEW"]
[165,"其他","ic_substitute","替代方案（源平台表映射）",0]

{"sheet":"系统基础(Sys)","index":1,"n_rows":997,"n_cols":5,"rows_kept":997,"cut":false,"hidden":false,"merged":[[424,0,424,4],[680,0,680,4],[226,0,226,4],[674,0,674,4],[311,0,311,4],[161,0,161,4],[567,0,567,4],[858,0,858,4],[553,0,553,4],[949,0,949,4],[139,0,139,4],[459,0,459,4],[587,0,587,4],[851,0,851,4],[907,0,907,4],[971,0,971,4],[703,0,703,4],[84,0,84,4],[372,0,372,4],[532,0,532,4],[620,0,620,4],[781,0,781,4],[389,0,389,4],[485,0,485,4],[0,0,0,4],[512,0,512,4],[640,0,640,4],[686,0,686,4],[752,0,752,4],[768,0,768,4],[273,0,273,4],[657,0,657,4],[721,0,721,4],[913,0,913,4],[122,0,122,4],[250,0,250,4],[258,0,258,4],[348,0,348,4],[540,0,540,4],[604,0,604,4],[201,0,201,4],[868,0,868,4],[883,0,883,4],[184,0,184,4],[298,0,298,4],[775,0,775,4],[57,0,57,4],[889,0,889,4],[32,0,32,4],[835,0,835,4],[333,0,333,4]]}
["SysAlipayAuthInfo  —  支付宝授权记录表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["AppId","varchar(64)","YES",null,"商户AppId"]
["OpenId","varchar(64)","YES",null,"开放ID"]
["UserId","varchar(64)","YES",null,"用户ID"]
["Gender","int","NO",null,"性别"]
["Age","int","NO",null,"年龄"]
["Mobile","varchar(32)","NO",null,"手机号"]
["DisplayName","varchar(128)","NO",null,"显示名称"]
["NickName","varchar(64)","NO",null,"昵称"]
["UserName","varchar(64)","NO",null,"用户名"]
["Avatar","varchar(512)","YES",null,"头像"]
["Email","varchar(128)","YES",null,"邮箱"]
["UserNation","varchar(32)","YES",null,"用户民族"]
["TaobaoId","varchar(64)","YES",null,"淘宝ID"]
["Phone","varchar(32)","YES",null,"电话"]
["PersonBirthday","varchar(32)","YES",null,"生日"]
["Profession","varchar(64)","YES",null,"职业"]
["Province","varchar(64)","YES",null,"省份"]
["UserStatus","varchar(32)","YES",null,"用户状态"]
["Degree","varchar(32)","YES",null,"学历"]
["UserType","varchar(32)","YES",null,"用户类型"]
["Zip","varchar(16)","YES",null,"邮编"]
["Address","varchar(256)","YES",null,"地址"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysAlipayTransaction  —  支付宝交易记录表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["UserId","bigint","NO",null,"用户Id"]
["TradeNo","varchar(64)","YES",null,"交易号"]
["OutTradeNo","varchar(64)","NO",null,"商户订单号"]
["TotalAmount","decimal(20,0)","NO",null,"交易金额"]
["TradeStatus","varchar(32)","NO",null,"交易状态"]
["FinishTime","datetime","YES",null,"交易完成时间"]
["Subject","varchar(256)","NO",null,"交易标题"]
["Body","varchar(512)","YES",null,"交易描述"]
["BuyerLogonId","varchar(128)","YES",null,"买家支付宝账号"]
["BuyerUserId","varchar(32)","YES",null,"买家支付宝用户ID"]
["SellerUserId","varchar(32)","YES",null,"卖家支付宝用户ID"]
["AppId","varchar(64)","YES",null,"商户AppId"]
["ExtendInfo","varchar(1024)","YES",null,"交易扩展信息"]
["ErrorInfo","varchar(1024)","YES",null,"交易扩展信息"]
["Remark","varchar(512)","YES",null,"交易备注"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysCodeGen  —  代码生成表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["AuthorName","varchar(32)","YES",null,"作者姓名"]
["TablePrefix","varchar(8)","YES",null,"是否移除表前缀"]
["GenerateType","varchar(32)","YES",null,"生成方式"]
["ConfigId","varchar(64)","YES",null,"库定位器名"]
["DbName","varchar(64)","YES",null,"数据库库名"]
["DbType","varchar(64)","YES",null,"数据库类型"]
["ConnectionString","varchar(256)","YES",null,"数据库链接"]
["TableName","varchar(128)","YES",null,"数据库表名"]
["NameSpace","varchar(128)","YES",null,"命名空间"]
["BusName","varchar(128)","YES",null,"业务名"]
["TableUniqueConfig","varchar(512)","YES",null,"表唯一字段配置"]
["GenerateMenu","tinyint(1)","NO",null,"是否生成菜单"]
["MenuIcon","varchar(32)","YES",null,"菜单图标"]
["MenuPid","bigint","YES",null,"菜单编码"]
["PagePath","varchar(32)","YES",null,"页面目录"]
["PrintType","varchar(32)","YES",null,"支持打印类型"]
["PrintName","varchar(32)","YES",null,"打印模版名称"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysCodeGenConfig  —  代码生成字段配置表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["CodeGenId","bigint","NO",null,"主表Id"]
["ColumnName","varchar(128)","NO",null,"字段名称"]
["ColumnKey","varchar(8)","YES",null,"主键"]
["PropertyName","varchar(128)","NO",null,"属性名称"]
["ColumnLength","int","NO","0","字段数据长度"]
["ColumnComment","varchar(128)","YES",null,"字段描述"]
["DataType","varchar(64)","YES",null,"数据库中类型"]
["NetType","varchar(64)","YES",null,"NET数据类型"]
["DefaultValue","varchar(255)","YES",null,"默认值"]
["EffectType","varchar(64)","YES",null,"作用类型"]
["FkConfigId","varchar(20)","YES",null,"外键库标识"]
["FkEntityName","varchar(64)","YES",null,"外键实体名称"]
["FkTableName","varchar(128)","YES",null,"外键表名称"]
["FkDisplayColumns","varchar(64)","YES",null,"外键显示字段"]
["FkLinkColumnName","varchar(64)","YES",null,"外键链接字段"]
["FkColumnNetType","varchar(64)","YES",null,"外键显示字段.NET类型"]
["PidColumn","varchar(128)","YES",null,"父级字段"]
["DictTypeCode","varchar(64)","YES",null,"字典编码"]
["QueryType","varchar(16)","YES",null,"查询方式"]
["WhetherQuery","varchar(8)","YES",null,"是否是查询条件"]
["WhetherRetract","varchar(8)","YES",null,"列表是否缩进"]
["WhetherRequired","varchar(8)","YES",null,"是否必填"]
["WhetherSortable","varchar(8)","YES",null,"是否可排序"]
["WhetherTable","varchar(8)","YES",null,"列表显示"]
["WhetherAddUpdate","varchar(8)","YES",null,"增改"]
["WhetherImport","varchar(8)","YES",null,"导入"]
["WhetherCommon","varchar(8)","YES",null,"是否通用字段"]
["OrderNo","int","NO",null,"排序"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysConfig  —  系统配置参数表  (约17行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Name","varchar(64)","NO",null,"名称"]
["Code","varchar(64)","YES",null,"编码"]
["Value","varchar(512)","YES",null,"参数值"]
["SysFlag","int","NO","1","是否是内置参数"]
["GroupCode","varchar(64)","YES",null,"分组编码"]
["OrderNo","int","NO","100","排序"]
["Remark","varchar(256)","YES",null,"备注"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysDictData  —  系统字典值表  (约493行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["DictTypeId","bigint","NO",null,"字典类型Id"]
["Label","varchar(256)","NO",null,"显示文本"]
["Value","varchar(256)","NO",null,"值"]
["Code","varchar(256)","YES",null,"编码"]
["Name","varchar(256)","YES",null,"名称"]
["TagType","varchar(16)","YES",null,"显示样式-标签颜色"]
["StyleSetting","varchar(512)","YES",null,"显示样式-Style"]
["ClassSetting","varchar(512)","YES",null,"显示样式-Class"]
["OrderNo","int","NO","100","排序"]
["Remark","varchar(2048)","YES",null,"备注"]
["ExtData","longtext","YES",null,"拓展数据(保存业务功能的配置项)"]
["Status","int","NO","1","状态"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysDictDataTenant  —  系统租户字典值表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["TenantId","bigint","YES",null,"租户Id"]
["DictTypeId","bigint","NO",null,"字典类型Id"]
["Label","varchar(256)","NO",null,"显示文本"]
["Value","varchar(256)","NO",null,"值"]
["Code","varchar(256)","YES",null,"编码"]
["Name","varchar(256)","YES",null,"名称"]
["TagType","varchar(16)","YES",null,"显示样式-标签颜色"]
["StyleSetting","varchar(512)","YES",null,"显示样式-Style"]
["ClassSetting","varchar(512)","YES",null,"显示样式-Class"]
["OrderNo","int","NO","100","排序"]
["Remark","varchar(2048)","YES",null,"备注"]
["ExtData","longtext","YES",null,"拓展数据(保存业务功能的配置项)"]
["Status","int","NO","1","状态"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysDictType  —  系统字典类型表  (约53行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Name","varchar(64)","NO",null,"名称"]
["Code","varchar(64)","NO",null,"编码"]
["OrderNo","int","NO","100","排序"]
["Remark","varchar(256)","YES",null,"备注"]
["Status","int","NO","1","状态"]
["SysFlag","int","NO","1","是否是内置字典"]
["IsTenant","int","NO","2","是否是租户字典"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysFile  —  系统文件表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Provider","varchar(128)","YES",null,"提供者"]
["BucketName","varchar(128)","YES",null,"仓储名称"]
["FileName","varchar(128)","YES",null,"文件名称"]
["Suffix","varchar(16)","YES",null,"文件后缀"]
["FilePath","varchar(512)","YES",null,"存储路径"]
["SizeKb","bigint","NO",null,"文件大小KB"]
["SizeInfo","varchar(64)","YES",null,"文件大小信息"]
["Url","varchar(512)","YES",null,"外链地址"]
["FileMd5","varchar(128)","YES",null,"文件MD5"]
["FileType","varchar(128)","YES",null,"文件类别"]
["FileAlias","varchar(128)","YES",null,"文件别名"]
["IsPublic","tinyint(1)","NO",null,"是否公开"]
["DataId","bigint","YES",null,"业务数据Id"]
["TenantId","bigint","YES",null,"租户Id"]
["OrgId","bigint","YES",null,"机构Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysFileProvider  —  系统文件存储提供者表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Provider","varchar(16)","NO",null,"存储提供者"]
["BucketName","varchar(32)","NO",null,"存储桶名称"]
["AccessKey","varchar(128)","YES",null,"访问密钥"]
["SecretKey","varchar(128)","YES",null,"密钥"]
["Region","varchar(64)","YES",null,"地域"]
["Endpoint","varchar(256)","YES",null,"端点地址"]
["IsEnableHttps","tinyint(1)","YES",null,"是否启用HTTPS"]
["IsEnableCache","tinyint(1)","YES",null,"是否启用缓存"]
["IsEnable","tinyint(1)","YES",null,"是否启用"]
["IsDefault","tinyint(1)","YES",null,"是否默认提供者"]
["SinceDomain","varchar(256)","YES",null,"自定义域名"]
["OrderNo","int","YES",null,"排序号"]
["Remark","varchar(512)","YES",null,"备注"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysJobCluster  —  系统作业集群表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["ClusterId","varchar(64)","NO",null,"作业集群Id"]
["Description","varchar(128)","YES",null,"描述信息"]
["Status","int","NO",null,"状态"]
["UpdatedTime","datetime","YES",null,"更新时间"]
[]
["SysJobDetail  —  系统作业信息表  (约7行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["JobId","varchar(64)","NO",null,"作业Id"]
["GroupName","varchar(128)","YES",null,"组名称"]
["JobType","varchar(128)","YES",null,"作业类型"]
["AssemblyName","varchar(128)","YES",null,"程序集"]
["Description","varchar(128)","YES",null,"描述信息"]
["Concurrent","tinyint(1)","NO",null,"是否并行执行"]
["annotation","tinyint(1)","NO",null,"是否扫描特性触发器"]
["Properties","longtext","YES",null,"额外数据"]
["UpdatedTime","datetime","YES",null,"更新时间"]
["CreateType","int","NO",null,"作业创建类型"]
["ScriptCode","longtext","YES",null,"脚本代码"]
[]
["SysJobTrigger  —  系统作业触发器表  (约6行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["TriggerId","varchar(64)","NO",null,"触发器Id"]
["JobId","varchar(64)","NO",null,"作业Id"]
["TriggerType","varchar(128)","YES",null,"触发器类型"]
["AssemblyName","varchar(128)","YES",null,"程序集"]
["Args","varchar(128)","YES",null,"参数"]
["Description","varchar(128)","YES",null,"描述信息"]
["Status","int","NO",null,"状态"]
["StartTime","datetime","YES",null,"起始时间"]
["EndTime","datetime","YES",null,"结束时间"]
["LastRunTime","datetime","YES",null,"最近运行时间"]
["NextRunTime","datetime","YES",null,"下一次运行时间"]
["NumberOfRuns","bigint","NO",null,"触发次数"]
["MaxNumberOfRuns","bigint","NO",null,"最大触发次数"]
["NumberOfErrors","bigint","NO",null,"出错次数"]
["MaxNumberOfErrors","bigint","NO",null,"最大出错次数"]
["NumRetries","int","NO",null,"重试次数"]
["RetryTimeout","int","NO",null,"重试间隔时间(ms)"]
["StartNow","tinyint(1)","NO",null,"是否立即启动"]
["RunOnStart","tinyint(1)","NO",null,"是否启动时执行一次"]
["ResetOnlyOnce","tinyint(1)","NO",null,"是否重置触发次数"]
["UpdatedTime","datetime","YES",null,"更新时间"]
[]
["SysJobTriggerRecord  —  系统作业触发器运行记录表  (约116行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["JobId","varchar(64)","NO",null,"作业Id"]
["TriggerId","varchar(64)","NO",null,"触发器Id"]
["NumberOfRuns","bigint","NO",null,"当前运行次数"]
["LastRunTime","datetime","YES",null,"最近运行时间"]
["NextRunTime","datetime","YES",null,"下一次运行时间"]
["Status","int","NO",null,"触发器状态"]
["Result","varchar(128)","YES",null,"本次执行结果"]
["ElapsedTime","bigint","NO",null,"本次执行耗时"]
["CreatedTime","datetime","YES",null,"创建时间"]
[]
["SysLang  —  语言配置  (约88行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Name","varchar(255)","NO",null,"语言名称"]
["Code","varchar(255)","NO",null,"语言代码"]
["IsoCode","varchar(255)","NO",null,"ISO 语言代码"]
["UrlCode","varchar(255)","NO",null,"URL 语言代码"]
["Direction","int","NO","1","书写方向"]
["DateFormat","varchar(255)","NO",null,"日期格式"]
["TimeFormat","varchar(255)","NO",null,"时间格式"]
["WeekStart","int","NO","7","每周起始日"]
["Grouping","varchar(255)","NO",null,"分组符号"]
["DecimalPoint","varchar(255)","NO",null,"小数点符号"]
["ThousandsSep","varchar(255)","YES",null,"千分位分隔符"]
["Active","tinyint(1)","NO",null,"是否启用"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysLangText  —  翻译表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["EntityName","varchar(255)","NO",null,"所属实体名"]
["EntityId","bigint","NO",null,"所属实体ID"]
["FieldName","varchar(255)","NO",null,"字段名"]
["LangCode","varchar(255)","NO",null,"语言代码"]
["Content","varchar(255)","NO",null,"翻译内容"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysLdap  —  系统域登录信息配置表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Host","varchar(128)","NO",null,"主机"]
["Port","int","NO",null,"端口"]
["BaseDn","varchar(128)","NO",null,"用户搜索基准"]
["BindDn","varchar(128)","NO",null,"绑定DN"]
["BindPass","varchar(512)","NO",null,"绑定密码"]
["AuthFilter","varchar(128)","NO",null,"用户过滤规则"]
["Version","int","NO",null,"Ldap版本"]
["BindAttrAccount","varchar(32)","NO",null,"绑定域账号字段属性值"]
["BindAttrEmployeeId","varchar(32)","NO",null,"绑定用户EmployeeId属性值"]
["BindAttrCode","varchar(64)","NO",null,"绑定对象Code属性值"]
["Status","int","NO",null,"状态"]
["TenantId","bigint","YES",null,"租户Id"]
["IsDelete","tinyint(1)","NO",null,"软删除"]
["DeleteTime","datetime","YES",null,"软删除时间"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysLogDiff  —  系统差异日志表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["DiffData","longtext","YES",null,"差异数据"]
["Sql","longtext","YES",null,"Sql"]
["Parameters","longtext","YES",null,"参数"]
["BusinessData","longtext","YES",null,"业务对象"]
["DiffType","longtext","YES",null,"差异操作"]
["Elapsed","bigint","YES",null,"耗时"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysLogEx  —  系统异常日志表  (约20行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["HttpMethod","varchar(32)","YES",null,"请求方式"]
["RequestUrl","longtext","YES",null,"请求地址"]
["RequestParam","longtext","YES",null,"请求参数"]
["ReturnResult","longtext","YES",null,"返回结果"]
["EventId","int","YES",null,"事件Id"]
["ThreadId","int","YES",null,"线程Id"]
["TraceId","varchar(128)","YES",null,"请求跟踪Id"]
["Exception","longtext","YES",null,"异常信息"]
["Message","longtext","YES",null,"日志消息Json"]
["ControllerName","varchar(256)","YES",null,"模块名称"]
["ActionName","varchar(256)","YES",null,"方法名称"]
["DisplayTitle","varchar(256)","YES",null,"显示名称"]
["Status","varchar(32)","YES",null,"执行状态"]
["RemoteIp","varchar(256)","YES",null,"IP地址"]
["Location","varchar(128)","YES",null,"登录地点"]
["Longitude","decimal(18,4)","YES",null,"经度"]
["Latitude","decimal(18,4)","YES",null,"维度"]
["Browser","varchar(1024)","YES",null,"浏览器"]
["Os","varchar(256)","YES",null,"操作系统"]
["Elapsed","bigint","YES",null,"操作用时"]
["LogDateTime","datetime","YES",null,"日志时间"]
["LogLevel","int","YES",null,"日志级别"]
["Account","varchar(32)","YES",null,"账号"]
["RealName","varchar(32)","YES",null,"真实姓名"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysLogOp  —  系统操作日志表  (约1749行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["HttpMethod","varchar(32)","YES",null,"请求方式"]
["RequestUrl","longtext","YES",null,"请求地址"]
["RequestParam","longtext","YES",null,"请求参数"]
["ReturnResult","longtext","YES",null,"返回结果"]
["EventId","int","YES",null,"事件Id"]
["ThreadId","int","YES",null,"线程Id"]
["TraceId","varchar(128)","YES",null,"请求跟踪Id"]
["Exception","longtext","YES",null,"异常信息"]
["Message","longtext","YES",null,"日志消息Json"]
["ControllerName","varchar(256)","YES",null,"模块名称"]
["ActionName","varchar(256)","YES",null,"方法名称"]
["DisplayTitle","varchar(256)","YES",null,"显示名称"]
["Status","varchar(32)","YES",null,"执行状态"]
["RemoteIp","varchar(256)","YES",null,"IP地址"]
["Location","varchar(128)","YES",null,"登录地点"]
["Longitude","decimal(18,4)","YES",null,"经度"]
["Latitude","decimal(18,4)","YES",null,"维度"]
["Browser","varchar(1024)","YES",null,"浏览器"]
["Os","varchar(256)","YES",null,"操作系统"]
["Elapsed","bigint","YES",null,"操作用时"]
["LogDateTime","datetime","YES",null,"日志时间"]
["LogLevel","int","YES",null,"日志级别"]
["Account","varchar(32)","YES",null,"账号"]
["RealName","varchar(32)","YES",null,"真实姓名"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysLogVis  —  系统访问日志表  (约245行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["ControllerName","varchar(256)","YES",null,"模块名称"]
["ActionName","varchar(256)","YES",null,"方法名称"]
["DisplayTitle","varchar(256)","YES",null,"显示名称"]
["Status","varchar(32)","YES",null,"执行状态"]
["RemoteIp","varchar(256)","YES",null,"IP地址"]
["Location","varchar(128)","YES",null,"登录地点"]
["Longitude","decimal(18,4)","YES",null,"经度"]
["Latitude","decimal(18,4)","YES",null,"维度"]
["Browser","varchar(1024)","YES",null,"浏览器"]
["Os","varchar(256)","YES",null,"操作系统"]
["Elapsed","bigint","YES",null,"操作用时"]
["LogDateTime","datetime","YES",null,"日志时间"]
["LogLevel","int","YES",null,"日志级别"]
["Account","varchar(32)","YES",null,"账号"]
["RealName","varchar(32)","YES",null,"真实姓名"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysMenu  —  系统菜单表  (约296行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Pid","bigint","NO",null,"父Id"]
["Type","int","NO",null,"菜单类型"]
["Name","varchar(64)","YES",null,"路由名称"]
["Path","varchar(128)","YES",null,"路由地址"]
["Component","varchar(128)","YES",null,"组件路径"]
["Redirect","varchar(128)","YES",null,"重定向"]
["Permission","varchar(128)","YES",null,"权限标识"]
["Title","varchar(64)","NO",null,"菜单名称"]
["Icon","varchar(128)","YES",null,"图标"]
["IsIframe","tinyint(1)","NO",null,"是否内嵌"]
["OutLink","varchar(256)","YES",null,"外链链接"]
["IsHide","tinyint(1)","NO",null,"是否隐藏"]
["IsKeepAlive","tinyint(1)","NO",null,"是否缓存"]
["IsAffix","tinyint(1)","NO",null,"是否固定"]
["OrderNo","int","NO",null,"排序"]
["Status","int","NO",null,"状态"]
["Remark","varchar(256)","YES",null,"备注"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysNotice  —  系统通知公告表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Title","varchar(32)","NO",null,"标题"]
["Content","longtext","NO",null,"内容"]
["Type","int","NO",null,"类型（1通知 2公告）"]
["PublicUserId","bigint","NO",null,"发布人Id"]
["PublicUserName","varchar(32)","YES",null,"发布人姓名"]
["PublicOrgId","bigint","NO",null,"发布机构Id"]
["PublicOrgName","varchar(64)","YES",null,"发布机构名称"]
["PublicTime","datetime","YES",null,"发布时间"]
["CancelTime","datetime","YES",null,"撤回时间"]
["Status","int","NO",null,"状态（0草稿 1发布 2撤回 3删除）"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysNoticeUser  —  系统通知公告用户表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["NoticeId","bigint","NO",null,"通知公告Id"]
["UserId","bigint","NO",null,"用户Id"]
["ReadTime","datetime","YES",null,"阅读时间"]
["ReadStatus","int","NO",null,"状态（0未读 1已读）"]
[]
["SysOnlineUser  —  系统在线用户表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["ConnectionId","varchar(255)","YES",null,"连接Id"]
["UserId","bigint","NO",null,"用户Id"]
["UserName","varchar(32)","NO",null,"账号"]
["RealName","varchar(32)","YES",null,"真实姓名"]
["Time","datetime","YES",null,"连接时间"]
["Ip","varchar(256)","YES",null,"连接IP"]
["Browser","varchar(128)","YES",null,"浏览器"]
["Os","varchar(128)","YES",null,"操作系统"]
["TenantId","bigint","YES",null,"租户Id"]
[]
["SysOpenAccess  —  开放接口身份表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["AccessKey","varchar(128)","NO",null,"身份标识"]
["AccessSecret","varchar(256)","NO",null,"密钥"]
["BindTenantId","bigint","NO",null,"绑定租户Id"]
["BindUserId","bigint","NO",null,"绑定用户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysOrg  —  系统机构表  (约11行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Pid","bigint","NO",null,"父Id"]
["Name","varchar(64)","NO",null,"名称"]
["Code","varchar(64)","YES",null,"编码"]
["Level","int","YES",null,"级别"]
["Type","varchar(64)","YES",null,"机构类型"]
["DirectorId","bigint","YES",null,"负责人Id"]
["OrderNo","int","NO",null,"排序"]
["Status","int","NO",null,"状态"]
["Remark","varchar(128)","YES",null,"备注"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysPlugin  —  系统动态插件表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Name","varchar(64)","NO",null,"名称"]
["CsharpCode","longtext","NO",null,"C#代码"]
["AssemblyName","varchar(512)","YES",null,"程序集名称"]
["OrderNo","int","NO",null,"排序"]
["Status","int","NO",null,"状态"]
["Remark","varchar(128)","YES",null,"备注"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysPos  —  系统职位表  (约17行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Name","varchar(64)","NO",null,"名称"]
["Code","varchar(64)","YES",null,"编码"]
["OrderNo","int","NO",null,"排序"]
["Remark","varchar(128)","YES",null,"备注"]
["Status","int","NO",null,"状态"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysPrint  —  系统打印模板表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Name","varchar(64)","NO",null,"名称"]
["Template","longtext","NO",null,"打印模板"]
["PrintType","int","YES",null,"打印类型"]
["ClientServiceAddress","varchar(128)","YES",null,"客户端服务地址"]
["PrintParam","longtext","YES",null,"打印参数"]
["OrderNo","int","NO",null,"排序"]
["Status","int","NO",null,"状态"]
["Remark","varchar(128)","YES",null,"备注"]
["PrintDataDemo","longtext","YES",null,"打印预览测试数据"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysRegion  —  系统行政地区表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Pid","bigint","NO",null,"父Id"]
["Name","varchar(128)","NO",null,"名称"]
["ShortName","varchar(32)","YES",null,"简称"]
["MergerName","varchar(64)","YES",null,"组合名"]
["Code","varchar(32)","YES",null,"行政代码"]
["ZipCode","varchar(6)","YES",null,"邮政编码"]
["CityCode","varchar(6)","YES",null,"区号"]
["Level","int","NO",null,"层级"]
["PinYin","varchar(128)","YES",null,"拼音"]
["Lng","float","NO",null,"经度"]
["Lat","float","NO",null,"维度"]
["OrderNo","int","NO",null,"排序"]
["Remark","varchar(128)","YES",null,"备注"]
[]
["SysRole  —  系统角色表  (约7行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Name","varchar(64)","NO",null,"名称"]
["Code","varchar(64)","YES",null,"编码"]
["OrderNo","int","NO",null,"排序"]
["DataScope","int","NO",null,"数据范围"]
["Remark","varchar(128)","YES",null,"备注"]
["Status","int","NO",null,"状态"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysRoleMenu  —  系统角色菜单表  (约634行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["RoleId","bigint","NO",null,"角色Id"]
["MenuId","bigint","NO",null,"菜单Id"]
[]
["SysRoleOrg  —  系统角色机构表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["RoleId","bigint","NO",null,"角色Id"]
["OrgId","bigint","NO",null,"机构Id"]
[]
["SysSchedule  —  系统日程表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["UserId","bigint","NO",null,"用户Id"]
["ScheduleTime","datetime","YES",null,"日程日期"]
["StartTime","varchar(10)","YES",null,"开始时间"]
["EndTime","varchar(10)","YES",null,"结束时间"]
["Content","varchar(256)","NO",null,"日程内容"]
["Status","int","NO",null,"完成状态"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysTemplate  —  系统模板表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Name","varchar(128)","NO",null,"名称"]
["Type","int","NO",null,"分组名称"]
["Code","varchar(128)","NO",null,"编码"]
["GroupName","varchar(32)","NO",null,"分组名称"]
["Content","longtext","NO",null,"模板内容"]
["Remark","varchar(128)","YES",null,"备注"]
["OrderNo","int","NO",null,"排序"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysTenant  —  系统租户表  (约2行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["UserId","bigint","NO",null,"租管用户Id"]
["OrgId","bigint","NO",null,"机构Id"]
["Host","varchar(128)","YES",null,"域名"]
["TenantType","int","NO",null,"租户类型"]
["DbType","int","NO",null,"数据库类型"]
["Connection","varchar(256)","YES",null,"数据库连接"]
["ConfigId","varchar(64)","YES",null,"数据库标识"]
["SlaveConnections","longtext","YES",null,"从库连接/读写分离"]
["EnableReg","int","YES",null,"启用注册功能"]
["RegWayId","bigint","YES",null,"默认注册方案"]
["Logo","varchar(256)","YES",null,"图标"]
["Title","varchar(32)","YES",null,"标题"]
["ViceTitle","varchar(32)","YES",null,"副标题"]
["ViceDesc","varchar(64)","YES",null,"副描述"]
["Watermark","varchar(32)","YES",null,"水印"]
["Copyright","varchar(64)","YES",null,"版权信息"]
["Icp","varchar(32)","YES",null,"ICP备案号"]
["IcpUrl","varchar(32)","YES",null,"ICP地址"]
["OrderNo","int","NO",null,"排序"]
["Remark","varchar(128)","YES",null,"备注"]
["Status","int","NO",null,"状态"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysTenantConfig  —  系统租户配置参数表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Name","varchar(64)","NO",null,"名称"]
["Code","varchar(64)","YES",null,"编码"]
["SysFlag","int","NO","1","是否是内置参数"]
["GroupCode","varchar(64)","YES",null,"分组编码"]
["OrderNo","int","NO","100","排序"]
["Remark","varchar(256)","YES",null,"备注"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysTenantConfigData  —  系统租户配置参数值表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["ConfigId","bigint","NO",null,"配置项Id"]
["Value","varchar(512)","YES",null,"参数值"]
["TenantId","bigint","YES",null,"租户Id"]
[]
["SysTenantMenu  —  系统租户菜单表  (约396行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["TenantId","bigint","NO",null,"租户Id"]
["MenuId","bigint","NO",null,"菜单Id"]
[]
["SysUser  —  系统用户表  (约9行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Account","varchar(32)","NO",null,"账号"]
["Password","varchar(512)","NO",null,"密码"]
["RealName","varchar(32)","NO",null,"真实姓名"]
["NickName","varchar(32)","YES",null,"昵称"]
["Avatar","varchar(512)","YES",null,"头像"]
["Sex","int","NO",null,"性别"]
["Age","int","NO",null,"年龄"]
["Birthday","datetime","YES",null,"出生日期"]
["Nation","varchar(32)","YES",null,"民族"]
["Phone","varchar(16)","YES",null,"手机号码"]
["CardType","int","NO",null,"证件类型"]
["IdCardNum","varchar(32)","YES",null,"身份证号"]
["Email","varchar(64)","YES",null,"邮箱"]
["Address","varchar(256)","YES",null,"地址"]
["CultureLevel","int","NO",null,"文化程度"]
["PoliticalOutlook","varchar(16)","YES",null,"政治面貌"]
["College","varchar(128)","YES",null,"毕业院校"]
["OfficePhone","varchar(16)","YES",null,"办公电话"]
["EmergencyContact","varchar(32)","YES",null,"紧急联系人"]
["EmergencyPhone","varchar(16)","YES",null,"紧急联系人电话"]
["EmergencyAddress","varchar(256)","YES",null,"紧急联系人地址"]
["Introduction","varchar(512)","YES",null,"个人简介"]
["OrderNo","int","NO",null,"排序"]
["Status","int","NO",null,"状态"]
["Remark","varchar(256)","YES",null,"备注"]
["AccountType","int","NO",null,"账号类型"]
["ManagerUserId","bigint","YES",null,"直属主管Id"]
["PosId","bigint","NO",null,"职位Id"]
["JobNum","varchar(32)","YES",null,"工号"]
["PosLevel","varchar(32)","YES",null,"职级"]
["PosTitle","varchar(32)","YES",null,"职称"]
["Expertise","varchar(32)","YES",null,"擅长领域"]
["OfficeZone","varchar(32)","YES",null,"办公区域"]
["Office","varchar(32)","YES",null,"办公室"]
["JoinDate","datetime","YES",null,"入职日期"]
["LastLoginIp","varchar(256)","YES",null,"最新登录Ip"]
["LastLoginAddress","varchar(128)","YES",null,"最新登录地点"]
["LastLoginTime","datetime","YES",null,"最新登录时间"]
["LastLoginDevice","varchar(128)","YES",null,"最新登录设备"]
["Signature","varchar(512)","YES",null,"电子签名"]
["LangCode","varchar(255)","NO",null,"语言代码"]
["Homepage","varchar(512)","YES",null,"个性化首页地址"]
["TenantId","bigint","YES",null,"租户Id"]
["OrgId","bigint","YES",null,"机构Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysUserConfig  —  系统用户配置参数表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Name","varchar(64)","NO",null,"名称"]
["Code","varchar(64)","YES",null,"编码"]
["SysFlag","int","NO","1","是否是内置参数"]
["GroupCode","varchar(64)","YES",null,"分组编码"]
["OrderNo","int","NO","100","排序"]
["Remark","varchar(256)","YES",null,"备注"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysUserConfigData  —  系统租户配置参数值表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["UserId","bigint","NO",null,"用户Id"]
["ConfigId","bigint","NO",null,"配置项Id"]
["Value","varchar(512)","YES",null,"参数值"]
[]
["SysUserExtOrg  —  系统用户扩展机构表  (约2行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["UserId","bigint","NO",null,"用户Id"]
["OrgId","bigint","NO",null,"机构Id"]
["PosId","bigint","NO",null,"职位Id"]
["JobNum","varchar(32)","YES",null,"工号"]
["PosLevel","varchar(32)","YES",null,"职级"]
["JoinDate","datetime","YES",null,"入职日期"]
[]
["SysUserLdap  —  系统用户域配置表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["UserId","bigint","NO",null,"用户Id"]
["Account","varchar(32)","NO",null,"域账号"]
["UserName","varchar(32)","NO",null,"域用户名"]
["EmployeeId","varchar(32)","YES",null,"对应EmployeeId"]
["DeptCode","varchar(64)","YES",null,"组织代码"]
["PwdLastSetTime","datetime","YES",null,"最后设置密码时间"]
["Mail","varchar(64)","YES",null,"组织代码"]
["AccountExpiresFlag","tinyint(1)","NO",null,"检查账户是否已过期"]
["DontExpiresFlag","tinyint(1)","NO",null,"密码设置是否永不过期"]
["Dn","varchar(512)","NO",null,"DN"]
["TenantId","bigint","YES",null,"租户Id"]
[]
["SysUserMenu  —  系统用户菜单快捷导航表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["UserId","bigint","NO",null,"用户Id"]
["MenuId","bigint","NO",null,"菜单Id"]
[]
["SysUserRegWay  —  系统用户注册方案表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Name","varchar(32)","NO",null,"方案名称"]
["AccountType","int","NO",null,"账号类型"]
["RoleId","bigint","NO",null,"角色"]
["OrgId","bigint","NO",null,"机构"]
["PosId","bigint","NO",null,"职位"]
["OrderNo","int","NO",null,"排序"]
["Remark","varchar(128)","YES",null,"备注"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysUserRole  —  系统用户角色表  (约7行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["UserId","bigint","NO",null,"用户Id"]
["RoleId","bigint","NO",null,"角色Id"]
[]
["SysWechatPay  —  系统微信支付表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["MerchantId","varchar(255)","NO",null,"微信商户号"]
["AppId","varchar(255)","NO",null,"服务商AppId"]
["OutTradeNumber","varchar(255)","NO",null,"商户订单号"]
["TransactionId","varchar(255)","NO",null,"支付订单号"]
["TradeType","varchar(255)","YES",null,"交易类型"]
["TradeState","varchar(255)","YES",null,"交易状态"]
["TradeStateDescription","varchar(255)","YES",null,"交易状态描述"]
["BankType","varchar(255)","YES",null,"付款银行类型"]
["Total","int","NO",null,"订单总金额"]
["PayerTotal","int","YES",null,"用户支付金额"]
["SuccessTime","datetime","YES",null,"支付完成时间"]
["ExpireTime","datetime","YES",null,"交易结束时间"]
["Description","varchar(255)","YES",null,"商品描述"]
["Scene","varchar(255)","YES",null,"场景信息"]
["Attachment","varchar(255)","YES",null,"附加数据"]
["GoodsTag","varchar(255)","YES",null,"优惠标记"]
["Settlement","varchar(255)","YES",null,"结算信息"]
["NotifyUrl","varchar(255)","YES",null,"回调通知地址"]
["Remark","varchar(255)","YES",null,"备注"]
["OpenId","varchar(255)","YES",null,"微信OpenId标识"]
["Tags","varchar(64)","YES",null,"业务标签，用来区分做什么业务"]
["BusinessId","bigint","NO",null,"对应业务的主键"]
["QrcodeContent","varchar(255)","YES",null,"付款二维码内容"]
["SubMerchantId","varchar(255)","YES",null,"子商户号"]
["SubAppId","varchar(255)","YES",null,"回调通知地址"]
["SubOpenId","varchar(255)","YES",null,"子商户唯一标识"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysWechatRefund  —  系统微信支付退款表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["WechatPayId","bigint","NO",null,"定单主键"]
["OutRefundNumber","varchar(255)","NO",null,"商户退款号"]
["TransactionId","varchar(255)","NO",null,"退款订单号"]
["Reason","varchar(255)","YES",null,"退款原因"]
["Channel","varchar(255)","YES",null,"退款渠道"]
["UserReceivedAccount","varchar(255)","YES",null,"退款入账账户"]
["TradeState","varchar(255)","YES",null,"退款状态"]
["TradeStateDescription","varchar(255)","YES",null,"交易状态描述"]
["Refund","int","NO",null,"退款金额"]
["SuccessTime","datetime","YES",null,"完成时间"]
["NotifyUrl","varchar(255)","YES",null,"回调通知地址"]
["Remark","varchar(255)","YES",null,"备注"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["SysWechatUser  —  系统微信用户表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["UserId","bigint","NO",null,"系统用户Id"]
["PlatformType","int","NO",null,"平台类型"]
["OpenId","varchar(64)","NO",null,"OpenId"]
["SessionKey","varchar(256)","YES",null,"会话密钥"]
["UnionId","varchar(64)","YES",null,"UnionId"]
["NickName","varchar(64)","YES",null,"昵称"]
["Avatar","varchar(256)","YES",null,"头像"]
["Mobile","varchar(16)","YES",null,"手机号码"]
["Sex","int","YES",null,"性别"]
["Language","varchar(64)","YES",null,"语言"]
["City","varchar(64)","YES",null,"城市"]
["Province","varchar(64)","YES",null,"省"]
["Country","varchar(64)","YES",null,"国家"]
["AccessToken","longtext","YES",null,"AccessToken"]
["RefreshToken","longtext","YES",null,"RefreshToken"]
["ExpiresIn","int","YES",null,"ExpiresIn"]
["Scope","varchar(64)","YES",null,"授权作用域"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]

{"sheet":"审批流程(Approval)","index":2,"n_rows":72,"n_cols":5,"rows_kept":72,"cut":false,"hidden":false,"merged":[[36,0,36,4],[0,0,0,4],[19,0,19,4],[55,0,55,4]]}
["ApprovalFlow  —  审批流程信息表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Code","varchar(32)","YES",null,"编号"]
["Name","varchar(32)","NO",null,"名称"]
["FormJson","longtext","YES",null,"表单"]
["FlowJson","longtext","YES",null,"流程"]
["Status","int","YES",null,"状态"]
["Remark","varchar(256)","YES",null,"备注"]
["OrgId","bigint","YES",null,"机构Id"]
["IsDelete","tinyint(1)","NO",null,"软删除"]
["DeleteTime","datetime","YES",null,"软删除时间"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["ApprovalFlowRecord  —  审批流流程记录  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["FormName","varchar(255)","YES",null,"表单名称"]
["FormStatus","varchar(32)","YES",null,"表单状态"]
["FormJson","longtext","YES",null,"表单触发"]
["FormResult","longtext","YES",null,"表单结果"]
["FlowJson","longtext","YES",null,"流程结构"]
["FlowResult","longtext","YES",null,"流程结果"]
["OrgId","bigint","YES",null,"机构Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["ApprovalForm  —  审批流表单  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Code","varchar(32)","YES",null,"编号"]
["Name","varchar(32)","YES",null,"名称"]
["FormName","varchar(32)","YES",null,"表单名称"]
["FormType","varchar(32)","YES",null,"表单属性"]
["FormStatus","int","YES",null,"表单状态"]
["FormResult","longtext","YES",null,"表单结果"]
["Status","int","YES",null,"状态"]
["Remark","varchar(255)","YES",null,"备注"]
["OrgId","bigint","YES",null,"机构Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["ApprovalFormRecord  —  审批流表单记录  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["FlowId","bigint","YES",null,"流程Id"]
["FormName","varchar(32)","YES",null,"表单名称"]
["FormType","varchar(32)","YES",null,"表单类型"]
["FormStatus","varchar(11)","YES",null,"表单状态"]
["FormBefore","longtext","YES",null,"修改前"]
["FormAfter","longtext","YES",null,"修改后"]
["FormResult","longtext","YES",null,"表单结果"]
["OrgId","bigint","YES",null,"机构Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]

{"sheet":"钉钉集成(DingTalk)","index":3,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":false,"merged":[[38,0,38,4],[46,0,46,4],[0,0,0,4],[51,0,51,4],[17,0,17,4]]}
["DingTalkRoleUser  —  钉钉角色表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["DingTalkUserId","varchar(64)","YES",null,"钉钉用户id"]
["groupId","bigint","NO",null,"角色组id"]
["groupName","varchar(64)","YES",null,"角色组名"]
["roleId","bigint","NO",null,"角色id"]
["roleName","varchar(64)","YES",null,"角色名"]
["IsDelete","tinyint(1)","NO",null,"软删除"]
["DeleteTime","datetime","YES",null,"软删除时间"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["DingTalkUser  —  钉钉用户表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["SysUserId","bigint","NO",null,"系统用户Id"]
["DingTalkUserId","varchar(64)","YES",null,"钉钉用户id"]
["UnionId","varchar(64)","YES",null,"UnionId"]
["Name","varchar(64)","YES",null,"用户名"]
["Mobile","varchar(16)","YES",null,"手机号码"]
["Sex","int","YES",null,"性别"]
["Avatar","varchar(256)","YES",null,"头像"]
["JobNumber","varchar(16)","YES",null,"工号"]
["DeptId","varchar(16)","YES",null,"主部门Id"]
["Dept","varchar(16)","YES",null,"主部门"]
["Position","varchar(16)","YES",null,"职位"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["ding_talk_dept  —  钉钉部门表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"部门id"]
["parent_id","bigint","NO",null,"上级部门id"]
["name","varchar(64)","YES",null,"部门名"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
[]
["ding_talk_wokerflow_config  —  审批配置表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["WorkflowName","varchar(255)","NO",null,"审批名"]
["ProcessCode","varchar(255)","NO",null,"审批单Id"]
[]
["ding_talk_wokerflow_log  —  钉钉审批日志  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["instanceId","varchar(255)","NO",null,"审批实例ID"]
["WorkflowId","varchar(255)","YES",null,"审批单号"]
["SourceDocument","varchar(255)","NO",null,"来源单据"]
["EndTime","datetime","YES",null,"审批完成时间"]
["other_info","varchar(4000)","YES",null,"其他信息"]
["isReturn","tinyint(1)","YES",null,"是否回传结果"]
["Status","varchar(255)","NO",null,"审批状态"]
["taskId","bigint","YES",null,"任务ID"]
["Result","varchar(255)","YES",null,"审批结果"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]

{"sheet":"GoView可视化","index":4,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,4],[15,0,15,4]]}
["GoViewPro  —  GoView 项目表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["ProjectName","varchar(64)","NO",null,"项目名称"]
["StateEnum","int","NO",null,"项目状态"]
["IndexImage","varchar(1024)","YES",null,"预览图片Url"]
["Remarks","varchar(512)","YES",null,"项目备注"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]
[]
["GoViewProData  —  GoView 项目数据表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Content","longtext","YES",null,"项目内容"]
["IndexImageData","longtext","YES",null,"预览图片"]
["BackGroundImageData","longtext","YES",null,"背景图片"]
["TenantId","bigint","YES",null,"租户Id"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateTime","datetime","YES",null,"更新时间"]
["CreateUserId","bigint","YES",null,"创建者Id"]
["CreateUserName","varchar(64)","YES",null,"创建者姓名"]
["UpdateUserId","bigint","YES",null,"修改者Id"]
["UpdateUserName","varchar(64)","YES",null,"修改者姓名"]

{"sheet":"S0 基础主数据","index":5,"n_rows":539,"n_cols":5,"rows_kept":539,"cut":false,"hidden":false,"merged":[[154,0,154,4],[346,0,346,4],[183,0,183,4],[169,0,169,4],[233,0,233,4],[361,0,361,4],[139,0,139,4],[216,0,216,4],[408,0,408,4],[518,0,518,4],[44,0,44,4],[204,0,204,4],[389,0,389,4],[0,0,0,4],[315,0,315,4],[285,0,285,4],[445,0,445,4],[374,0,374,4],[92,0,92,4],[21,0,21,4],[111,0,111,4],[248,0,248,4],[422,0,422,4],[504,0,504,4],[78,0,78,4],[126,0,126,4],[334,0,334,4],[65,0,65,4]]}
["ado_s0_mfg_element_param  —  S0 生产要素参数  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["ElementCode","varchar(100)","YES",null,"要素编码"]
["ElementName","varchar(200)","YES",null,"要素名称"]
["ElementCategory","varchar(50)","YES",null,"要素分类"]
["Code","varchar(100)","NO",null,"参数编码"]
["Name","varchar(200)","NO",null,"参数名称"]
["ParamType","varchar(50)","YES",null,"值类型"]
["Unit","varchar(50)","YES",null,"单位"]
["StdValue","varchar(200)","YES",null,"标准值"]
["UpperLimit","decimal(18,6)","YES",null,"上限"]
["LowerLimit","decimal(18,6)","YES",null,"下限"]
["EnumOptions","varchar(2000)","YES",null,"枚举选项"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_line_master  —  生产线主数据表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"生产线主键"]
["company_ref_id","bigint","NO",null,"关联公司 ID"]
["factory_ref_id","bigint","NO",null,"关联工厂 ID"]
["domain","varchar(50)","NO",null,"工厂域编码"]
["line","varchar(100)","NO",null,"生产线编码"]
["line_describe","varchar(255)","YES",null,"生产线描述"]
["line_type","varchar(50)","YES",null,"产线类型"]
["line_category","varchar(50)","YES",null,"产线类别"]
["location","varchar(50)","YES",null,"主库位"]
["workshop","varchar(50)","YES",null,"车间编码"]
["v_location","varchar(50)","YES",null,"虚拟库位"]
["location2","varchar(50)","YES",null,"辅助库位2"]
["location3","varchar(50)","YES",null,"辅助库位3"]
["picking_location","varchar(50)","YES",null,"拣料库位"]
["mid_location","varchar(50)","YES",null,"中间库位"]
["is_active","tinyint(1)","NO",null,"是否启用"]
["create_user","varchar(64)","YES",null,"创建人"]
["create_time","datetime","YES",null,"创建时间"]
["update_user","varchar(64)","YES",null,"更新人"]
["update_time","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_line_material  —  S0 线边物料  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["ProductionLineId","bigint","YES",null,"产线"]
["MaterialId","bigint","NO",null,"物料"]
["OperationId","bigint","YES",null,"工序"]
["WorkCenterId","bigint","YES",null,"工作中心"]
["EquipmentCode","varchar(100)","YES",null,"设备编码"]
["StdCapacityPerUnit","decimal(18,5)","YES",null,"标准产能"]
["ChangeoverTime","decimal(18,5)","YES",null,"换型时间"]
["EquipmentTypeCode","varchar(50)","YES",null,"设备类型"]
["MoldTypeCode","varchar(50)","YES",null,"模具类型"]
["RequiredSkillCode","varchar(100)","YES",null,"要求技能编码"]
["MaterialRole","varchar(50)","YES",null,"物料角色"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_line_post  —  S0 线体岗位  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["Code","varchar(100)","NO",null,"编码"]
["Name","varchar(200)","NO",null,"名称"]
["ProductionLineId","bigint","YES",null,"产线"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_line_post_skill  —  S0 线体岗位技能  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["LinePostId","bigint","NO",null,"岗位"]
["PersonSkillId","bigint","NO",null,"人员技能"]
["RequiredLevel","varchar(50)","YES",null,"要求等级"]
["Remark","varchar(500)","YES",null,"备注"]
["EffectiveDate","datetime","YES",null,"生效日期"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_material_process_element  —  S0 物料工艺要素  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["MaterialId","bigint","NO",null,"物料"]
["OperationId","bigint","NO",null,"工序"]
["ProductionLineId","bigint","YES",null,"产线"]
["ElementType","varchar(50)","YES",null,"要素类型"]
["ElementCode","varchar(100)","YES",null,"要素编码"]
["ElementName","varchar(200)","YES",null,"要素名称"]
["ElementParamId","bigint","NO",null,"要素参数"]
["ParamValue","varchar(500)","YES",null,"参数值"]
["IsKeyElement","tinyint(1)","NO",null,"关键要素"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_material_substitution  —  S0 物料替代  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["MaterialId","bigint","NO",null,"物料"]
["SubstituteMaterialId","bigint","NO",null,"替代物料"]
["SubstituteRatio","decimal(18,5)","NO",null,"替代比例"]
["Priority","int","NO",null,"优先级"]
["ParentMaterialId","bigint","YES",null,"父物料"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_person_skill  —  S0 人员技能主数据  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["Code","varchar(100)","NO",null,"编码"]
["Name","varchar(200)","NO",null,"名称"]
["SkillLevel","varchar(50)","YES",null,"技能等级"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_person_skill_assignment  —  S0 人员技能分配  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["PersonCode","varchar(100)","NO",null,"人员编码"]
["WorkGroup","varchar(100)","YES",null,"工作组"]
["SkillId","bigint","NO",null,"技能"]
["SkillLevel","int","NO",null,"技能等级"]
["ProductionEfficiency","decimal(18,5)","NO",null,"生产效率"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_preprocess_element  —  S0 前处理要素头  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["Code","varchar(100)","NO",null,"编码"]
["Name","varchar(200)","NO",null,"名称"]
["MaterialId","bigint","YES",null,"物料"]
["OperationId","bigint","YES",null,"工序"]
["IsKeyElement","tinyint(1)","NO",null,"关键要素"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_preprocess_element_param  —  S0 前处理要素参数行  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["PreprocessElementId","bigint","NO",null,"前处理要素"]
["ElementParamId","bigint","NO",null,"要素参数"]
["ParamValue","varchar(500)","YES",null,"参数值"]
["SortNo","int","NO",null,"排序"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_product_structure_master  —  标准BOM行维护（复刻 ProductStructureMaster）  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["ParentMaterialId","bigint","NO",null,"父项物料"]
["ComponentMaterialId","bigint","NO",null,"子项物料"]
["Qty","decimal(18,5)","NO",null,"标准用量"]
["UM","varchar(50)","YES",null,"单位"]
["Scrap","decimal(18,5)","NO",null,"损耗率"]
["QtyConsumed","decimal(18,5)","NO",null,"固定损耗量"]
["LineOp","int","YES",null,"行工序号"]
["Refs","varchar(200)","YES",null,"参考"]
["Remark","varchar(500)","YES",null,"备注"]
["StartEff","datetime","YES",null,"生效开始"]
["EndEff","datetime","YES",null,"生效结束"]
["StructureType","varchar(10)","YES",null,"结构类型"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_product_structure_op  —  标准BOM行工序（复刻 ProductStructureOp）  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["ProductStructureMasterId","bigint","NO",null,"标准BOM行"]
["ParentMaterialId","bigint","NO",null,"父项物料"]
["ComponentMaterialId","bigint","NO",null,"子项物料"]
["Op","int","NO",null,"工序号"]
["SortNo","int","NO",null,"排序"]
["CreatedAt","datetime","NO",null,"创建时间"]
[]
["ado_s0_mfg_production_line  —  S0 产线  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["Code","varchar(100)","NO",null,"编码"]
["Name","varchar(200)","NO",null,"名称"]
["LineType","varchar(50)","YES",null,"线体类型"]
["LineCategory","varchar(50)","YES",null,"线体分类"]
["LocationId","bigint","YES",null,"库位"]
["WorkshopId","bigint","YES",null,"车间"]
["Capacity","decimal(18,5)","YES",null,"产能"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_routing  —  S0 工艺路线头  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["Code","varchar(100)","NO",null,"编码"]
["Name","varchar(200)","NO",null,"名称"]
["MaterialId","bigint","YES",null,"物料"]
["BizVersion","varchar(50)","NO",null,"业务版本"]
["DocStatus","varchar(50)","NO",null,"文档状态"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_routing_op_detail  —  S0 标准工艺路线明细  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["RouteCode","varchar(100)","NO",null,"工艺路线编码(Ufld11)"]
["RouteName","varchar(200)","NO",null,"工艺路线名称(Ufld12)"]
["MaterialCode","varchar(100)","NO",null,"物料编码(RoutingCode)"]
["OperationCode","varchar(100)","NO",null,"工序编码(Op)"]
["OperationDescription","varchar(200)","NO",null,"工序名称(Descr)"]
["WorkCenterCode","varchar(100)","NO",null,"工作中心编码(WorkCtr)"]
["MilestoneOperation","varchar(100)","YES",null,"报工工序(MilestoneOp)"]
["Ufld1","varchar(200)","YES",null,"自定义字段Ufld1"]
["Ufld2","varchar(200)","YES",null,"活动一(Ufld2)"]
["UDeci1","decimal(18,5)","YES",null,"数量一(UDeci1)"]
["Ufld3","varchar(50)","YES",null,"单位一(Ufld3)"]
["Ufld4","varchar(200)","YES",null,"自定义字段Ufld4"]
["Ufld5","varchar(200)","YES",null,"活动二(Ufld5)"]
["UDeci2","decimal(18,5)","YES",null,"数量二(UDeci2)"]
["Ufld6","varchar(50)","YES",null,"单位二(Ufld6)"]
["Ufld7","varchar(200)","YES",null,"自定义字段Ufld7"]
["Ufld8","varchar(200)","YES",null,"活动三(Ufld8)"]
["UDeci3","decimal(18,5)","YES",null,"数量三(UDeci3)"]
["Ufld9","varchar(50)","YES",null,"单位三(Ufld9)"]
["UDeci4","decimal(18,5)","YES",null,"基本批量(UDeci4)"]
["UDeci5","decimal(18,5)","YES",null,"工序委外(UDeci5)"]
["SupplierCode","varchar(100)","YES",null,"供应商代码(Supp)"]
["OutsourcedLeadTime","int","NO",null,"委外提前期(SetupTime)"]
["SortNo","int","NO",null,"行排序"]
["IsEnabled","tinyint(1)","NO",null,"启用(IsActive)"]
["IsConfirm","tinyint(1)","NO",null,"是否确认(IsConfirm)"]
["CommentIndex","int","YES",null,"批注索引(CommentIndex)"]
["CreateUser","varchar(100)","YES",null,"创建人"]
["UpdateUser","varchar(100)","YES",null,"更新人"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_routing_operation  —  S0 工艺路线工序行  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["RoutingId","bigint","NO",null,"路线"]
["OperationId","bigint","NO",null,"工序"]
["SortNo","int","NO",null,"排序"]
["WorkCenterId","bigint","YES",null,"工作中心"]
["ProductionLineId","bigint","YES",null,"产线"]
["StdTime","decimal(18,5)","YES",null,"标准工时"]
["Remark","varchar(500)","YES",null,"备注"]
["IsReportOperation","tinyint(1)","NO",null,"报工工序"]
["Activity1","varchar(100)","YES",null,"活动1"]
["Activity1Qty","decimal(18,5)","YES",null,"活动1数量"]
["Activity1Unit","varchar(50)","YES",null,"活动1单位"]
["Activity2","varchar(100)","YES",null,"活动2"]
["Activity2Qty","decimal(18,5)","YES",null,"活动2数量"]
["Activity2Unit","varchar(50)","YES",null,"活动2单位"]
["Activity3","varchar(100)","YES",null,"活动3"]
["Activity3Qty","decimal(18,5)","YES",null,"活动3数量"]
["Activity3Unit","varchar(50)","YES",null,"活动3单位"]
["BaseQty","decimal(18,5)","NO",null,"基准数量"]
["IsOutsourced","tinyint(1)","NO",null,"委外"]
["SupplierId","bigint","YES",null,"供应商"]
["OutsourcedLeadTime","int","NO",null,"委外提前期"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_sop_document  —  S0 SOP 文档  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["Code","varchar(100)","NO",null,"编码"]
["Name","varchar(200)","NO",null,"名称"]
["ProductionLineId","bigint","YES",null,"产线"]
["SopFileTypeId","bigint","NO",null,"SOP 类型"]
["MaterialId","bigint","YES",null,"物料"]
["OperationId","bigint","YES",null,"工序"]
["FileVersion","varchar(50)","YES",null,"文件版本"]
["FileId","bigint","YES",null,"文件 ID"]
["DocStatus","varchar(50)","NO",null,"文档状态"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_sop_file_type  —  S0 SOP 文件类型  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["Code","varchar(100)","NO",null,"编码"]
["Name","varchar(200)","NO",null,"名称"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_standard_operation  —  S0 标准工序  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["Code","varchar(100)","NO",null,"编码"]
["Name","varchar(200)","NO",null,"名称"]
["IsKeyOperation","tinyint(1)","NO",null,"关键工序"]
["OperationType","varchar(50)","YES",null,"工序类型"]
["StdTime","decimal(18,5)","YES",null,"标准工时"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_std_op_master  —  标准工序主数据表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"标准工序主键"]
["company_ref_id","bigint","NO",null,"关联公司 ID"]
["factory_ref_id","bigint","NO",null,"关联工厂 ID"]
["domain","varchar(50)","NO",null,"工厂域编码"]
["std_op","varchar(100)","NO",null,"标准工序名称"]
["milestone_op","varchar(20)","YES",null,"是否关键工序"]
["create_user","varchar(64)","YES",null,"创建人"]
["create_time","datetime","YES",null,"创建时间"]
["update_user","varchar(64)","YES",null,"更新人"]
["update_time","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_work_center  —  S0 工作中心  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["Code","varchar(100)","NO",null,"编码"]
["Name","varchar(200)","NO",null,"名称"]
["CenterType","varchar(50)","YES",null,"中心类型"]
["Capacity","decimal(18,5)","YES",null,"产能"]
["DepartmentId","bigint","YES",null,"部门"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_work_ord_control  —  S0 工单控制参数设置  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"工单控制参数主键"]
["EnteringPer","decimal(18,6)","YES",null,"工单超报百分比(%)"]
["PaintingPer","decimal(18,6)","YES",null,"计划超报百分比(%)"]
["IssuedInterval","decimal(18,6)","YES",null,"领料间隔时间(H)"]
["PostVarsatSFC","tinyint(1)","NO",null,"完成数量是否包含不良"]
["IsIssued","tinyint(1)","NO",null,"是否发料出库模式"]
["IsPrintRejectBarcode","tinyint(1)","NO",null,"是否产生不良品标签"]
["IsPrintScrapBarcode","tinyint(1)","NO",null,"是否产生废品标签"]
["IsQualityConfirm","tinyint(1)","NO",null,"不良品需要品保人员确认"]
["Domain","varchar(50)","NO",null,"工厂域编码"]
["IsActive","tinyint(1)","NO",null,"是否启用"]
["IsConfirm","tinyint(1)","NO",null,"是否确认"]
["CreateUser","varchar(64)","YES",null,"创建人"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateUser","varchar(64)","YES",null,"更新人"]
["UpdateTime","datetime","YES",null,"更新时间"]
[]
["ado_s0_mfg_work_order_control  —  S0 工单控制参数  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["CompanyRefId","bigint","NO",null,"公司"]
["FactoryRefId","bigint","NO",null,"工厂"]
["Code","varchar(100)","NO",null,"编码"]
["Name","varchar(200)","NO",null,"名称"]
["ControlType","varchar(50)","YES",null,"控制类型"]
["ParamValue","varchar(500)","YES",null,"参数值"]
["Remark","varchar(500)","YES",null,"备注"]
["IsEnabled","tinyint(1)","NO",null,"启用"]
["CreatedAt","datetime","NO",null,"创建时间"]
["UpdatedAt","datetime","YES",null,"更新时间"]
[]
["ado_s0_sales_cust_master  —  客户主数据（复刻 CustMaster）  (约1行)"]
["字段名","类型","可空","默认值","说明"]
["rec_id","bigint","NO",null,"主键"]
["company_ref_id","bigint","NO",null,"关联公司 ID"]
["factory_ref_id","bigint","NO",null,"关联工厂 ID"]
["domain_code","varchar(50)","YES",null,"工厂域编码"]
["cust","varchar(100)","NO",null,"客户编码"]
["sort_name","varchar(200)","YES",null,"客户简称"]
["curr","varchar(20)","YES",null,"币种"]
["slspsn1","varchar(100)","YES",null,"主销售员"]
["slspsn2","varchar(100)","YES",null,"备用销售员"]
["ship_to","varchar(200)","YES",null,"发至"]
["tax_class","varchar(50)","YES",null,"税类型"]
["tax_in","tinyint(1)","NO",null,"是否含税"]
["cust_class","varchar(50)","YES",null,"客户级别"]
["remarks","varchar(1000)","YES",null,"备注"]
["is_active","tinyint(1)","NO",null,"是否启用"]
["is_confirm","tinyint(1)","NO",null,"是否确认"]
["create_user","varchar(100)","YES",null,"创建人"]
["create_time","datetime","NO",null,"创建时间"]
["update_user","varchar(100)","YES",null,"更新人"]
["update_time","datetime","YES",null,"更新时间"]
[]
["ado_s0_sales_item_master  —  物料主数据（复刻 ItemMaster）  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["rec_id","bigint","NO",null,"主键"]
["company_ref_id","bigint","NO",null,"关联公司 ID"]
["factory_ref_id","bigint","NO",null,"关联工厂 ID"]
["domain_code","varchar(50)","YES",null,"工厂域编码"]
["item_num","varchar(100)","NO",null,"物料编码"]
["descr","varchar(200)","NO",null,"物料名称"]
["descr1","varchar(200)","YES",null,"规格型号"]
["pkg_code","varchar(50)","YES",null,"语种"]
["um","varchar(50)","YES",null,"单位"]
["pur_mfg","varchar(100)","YES",null,"P/L件"]
["drawing","varchar(100)","YES",null,"图号"]
["item_type","varchar(100)","YES",null,"物料类型"]
["location","varchar(100)","YES",null,"默认库位"]
["default_shelf","varchar(100)","YES",null,"默认货架"]
["key_item","tinyint(1)","NO",null,"关键物料"]
["net_weight","decimal(18,5)","YES",null,"净重"]
["net_weight_um","varchar(50)","YES",null,"净重单位"]
["inspect","tinyint(1)","NO",null,"检验"]
["pur_lt","int","YES",null,"供应提前期"]
["ins_lt","int","YES",null,"检验天数"]
["mfg_lt","int","YES",null,"备料提前期"]
["length","decimal(18,5)","YES",null,"长度"]
["size","decimal(18,5)","YES",null,"尺寸"]
["size_um","varchar(50)","YES",null,"尺寸单位"]
["issue_policy","tinyint(1)","NO",null,"是否前处理"]
["mfgmttr","int","YES",null,"备料提前期(天)"]
["location_type","varchar(50)","YES",null,"库存类型"]
["commodity_code","varchar(100)","YES",null,"商品代码"]
["rev","varchar(50)","YES",null,"版本"]
["max_ord","decimal(18,5)","YES",null,"最大订单"]
["min_ord","decimal(18,5)","YES",null,"最小订单"]
["ord_mult","decimal(18,5)","YES",null,"订单倍数"]
["min_ord_sales","decimal(18,5)","YES",null,"起订量"]
["auto_lot_nums","tinyint(1)","NO",null,"自动批次号"]
["install","tinyint(1)","NO",null,"是否打标"]
["safety_stk","decimal(18,5)","YES",null,"安全库存"]
["days_between_pm","int","YES",null,"保质期(天)"]
["expire_alarm_day","int","YES",null,"过期预警天数"]
["stock_turn_over","decimal(18,5)","YES",null,"存货周转率"]
["lot_serial_control","tinyint(1)","NO",null,"批次先进先出提醒"]
["allocate_single_lot","tinyint(1)","NO",null,"批次先进先出强控"]
["status","varchar(50)","NO",null,"状态"]
["planner","varchar(100)","YES",null,"计划员"]
["trace_detail","tinyint(1)","NO",null,"按需发料"]
["is_main_mas","tinyint(1)","NO",null,"是否主材"]
["remark","varchar(1000)","YES",null,"备注"]
["emt_type","varchar(50)","YES",null,"特殊采购类型"]
["owner_application","varchar(100)","YES",null,"物料属性"]
["bom_design","int","YES",null,"BOM设计周期(天)"]
["routing_des","int","YES",null,"工艺设计周期(天)"]
["is_active","tinyint(1)","NO",null,"是否生效"]
["is_confirm","tinyint(1)","NO",null,"是否确认"]
["create_user","varchar(100)","YES",null,"创建人"]
["create_time","datetime","NO",null,"创建时间"]
["update_user","varchar(100)","YES",null,"更新人"]
["update_time","datetime","YES",null,"更新时间"]
[]
["ado_s0_sales_item_substitute_detail  —  物料替代关系表  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"物料替代关系主键"]
["ParentItem","varchar(100)","NO",null,"父级物料编码"]
["ItemNum","varchar(100)","NO",null,"物料编码"]
["SubstituteItem","varchar(100)","NO",null,"替代物料编码"]
["SubstituteQty","decimal(18,6)","YES",null,"替代数量"]
["Remark","varchar(255)","YES",null,"备注"]
["Domain","varchar(50)","NO",null,"工厂域编码"]
["CreateUser","varchar(64)","YES",null,"创建人"]
["CreateTime","datetime","YES",null,"创建时间"]
["UpdateUser","varchar(64)","YES",null,"更新人"]
["UpdateTime","datetime","YES",null,"更新时间"]
[]
["ado_s0_sales_priority_code  —  订单优先级配置（复刻 PriorityCode）  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["rec_id","bigint","NO",null,"主键"]
["company_ref_id","bigint","NO",null,"关联公司 ID"]
["factory_ref_id","bigint","NO",null,"关联工厂 ID"]
["domain_code","varchar(50)","YES",null,"工厂域编码"]
["descr","varchar(200)","NO",null,"名称"]
["value","varchar(200)","YES",null,"工单表字段"]
["priority","int","NO",null,"优先级"]
["order_by_code","int","NO",null,"排序方式编码"]
["source_table","varchar(200)","YES",null,"来源表"]
["source_column","varchar(200)","YES",null,"来源表字段"]
["source_type","varchar(100)","YES",null,"来源表字段类型"]
["source_id","varchar(200)","YES",null,"来源表关联字段"]
["value_type","varchar(100)","YES",null,"工单表字段类型"]
["value_id","varchar(200)","YES",null,"工单表关联字段"]
["is_active","tinyint(1)","NO",null,"是否生效"]
["create_user","varchar(100)","YES",null,"创建人"]
["create_time","datetime","NO",null,"创建时间"]
["update_user","varchar(100)","YES",null,"更新人"]
["update_time","datetime","YES",null,"更新时间"]

{"sheet":"S1 产销协同","index":6,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[28,0,28,4],[0,0,0,4],[42,0,42,4],[14,0,14,4]]}
["ado_s1_delivery_change  —  交付变更  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s1_delivery_promise  —  交付承诺  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s1_sales_order  —  销售订单头  (约2行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s1_sales_order_line  —  销售订单行  (约2行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]

{"sheet":"S2 生产计划","index":7,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[28,0,28,4],[0,0,0,4],[42,0,42,4],[14,0,14,4]]}
["ado_s2_capacity_snapshot  —  产能快照  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s2_mps_plan  —  主生产计划  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s2_work_order  —  工单  (约2行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s2_work_order_op  —  工单工序执行  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]

{"sheet":"S3 物料计划","index":8,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[28,0,28,4],[0,0,0,4],[14,0,14,4]]}
["ado_s3_material_kit_status  —  物料齐套状态  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s3_mrp_result  —  MRP结果  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s3_supplier_delivery_perf  —  供应商准交绩效  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]

{"sheet":"S4 采购","index":9,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[28,0,28,4],[0,0,0,4],[42,0,42,4],[14,0,14,4]]}
["ado_s4_purchase_order  —  采购订单头  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s4_purchase_order_line  —  采购订单行  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s4_receipt  —  收货记录  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s4_return  —  退货记录  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]

{"sheet":"S5 仓储来料","index":10,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[28,0,28,4],[0,0,0,4],[14,0,14,4]]}
["ado_s5_inventory_balance  —  库存余额  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s5_inventory_txn  —  库存流水  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s5_iqc_result  —  来料检验  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]

{"sheet":"S6 生产执行","index":11,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[28,0,28,4],[0,0,0,4],[14,0,14,4]]}
["ado_s6_equipment_oee  —  设备OEE快照  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s6_ipqc_result  —  过程检验  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s6_report_work  —  报工记录  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]

{"sheet":"S7 成品管理","index":12,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[28,0,28,4],[0,0,0,4],[42,0,42,4],[14,0,14,4]]}
["ado_s7_fg_inbound  —  成品入库  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s7_fg_outbound  —  成品出库  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s7_oqc_result  —  成品检验  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s7_trace_serial  —  序列号追溯  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]

{"sheet":"S8 预警异常","index":13,"n_rows":175,"n_cols":5,"rows_kept":175,"cut":false,"hidden":false,"merged":[[120,0,120,4],[134,0,134,4],[28,0,28,4],[50,0,50,4],[92,0,92,4],[106,0,106,4],[148,0,148,4],[162,0,162,4],[0,0,0,4],[14,0,14,4],[64,0,64,4],[78,0,78,4]]}
["ado_s8_alert_channel  —  S8预警通道  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s8_alert_model  —  S8预警模型  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s8_alert_record  —  S8预警记录  (约2行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
["alert_code","varchar(64)","YES",null,"预警编码"]
["rule_code","varchar(64)","YES",null,"规则编码"]
["metric_code","varchar(64)","YES",null,"指标编码"]
["metric_value","decimal(18,4)","YES",null,"指标值"]
["target_value","decimal(18,4)","YES",null,"目标值"]
["level_code","varchar(16)","YES",null,"预警等级"]
["alert_time","datetime(3)","YES",null,"预警时间"]
["message","varchar(500)","YES",null,"预警信息"]
[]
["ado_s8_incident  —  S8异常单  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s8_incident_action  —  S8异常处置  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s8_incident_dispatch  —  S8异常分派  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s8_incident_verify  —  S8异常验证关闭  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s8_rule_condition  —  S8规则条件  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s8_rule_eval_log  —  S8规则评估日志  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s8_rule_hit_fact  —  S8规则命中事实  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s8_rule_model  —  S8监控规则模型  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s8_rule_scope  —  S8规则范围  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]

{"sheet":"S9 管理看板KPI","index":14,"n_rows":210,"n_cols":5,"rows_kept":210,"cut":false,"hidden":false,"merged":[[56,0,56,4],[70,0,70,4],[120,0,120,4],[134,0,134,4],[28,0,28,4],[42,0,42,4],[84,0,84,4],[106,0,106,4],[148,0,148,4],[169,0,169,4],[0,0,0,4],[14,0,14,4],[190,0,190,4]]}
["ado_s9_calc_log  —  KPI计算日志  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s9_calc_task  —  KPI计算任务  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s9_chatbi_query_log  —  ChatBI查询日志  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s9_chatbi_semantic  —  ChatBI语义模型  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s9_dashboard_snapshot  —  管理看板快照  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s9_drilldown_cache  —  下钻缓存  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s9_kpi_def  —  KPI定义  (约3行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
["metric_code","varchar(64)","YES",null,"指标编码"]
["metric_name","varchar(128)","YES",null,"指标名称"]
["module_code","varchar(8)","YES",null,"模块编码"]
["metric_level","tinyint","YES",null,"层级"]
["unit","varchar(16)","YES",null,"单位"]
["target_value","decimal(18,4)","YES",null,"目标值"]
["warn_threshold","decimal(18,4)","YES",null,"预警阈值"]
["danger_threshold","decimal(18,4)","YES",null,"告警阈值"]
[]
["ado_s9_kpi_formula  —  KPI公式版本  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s9_kpi_page_binding  —  KPI页面绑定  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s9_kpi_relation  —  KPI父子关系  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_s9_kpi_value_l1_day  —  KPI一级日值  (约13行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
["module_code","varchar(8)","YES",null,"模块编码"]
["metric_code","varchar(64)","YES",null,"指标编码"]
["metric_value","decimal(18,4)","YES",null,"指标值"]
["target_value","decimal(18,4)","YES",null,"目标值"]
["status_color","varchar(16)","YES",null,"状态色"]
["trend_flag","varchar(8)","YES",null,"趋势"]
["calc_time","datetime(3)","YES",null,"计算时间"]
[]
["ado_s9_kpi_value_l2_day  —  KPI二级日值  (约10行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
["module_code","varchar(8)","YES",null,"模块编码"]
["metric_code","varchar(64)","YES",null,"指标编码"]
["metric_value","decimal(18,4)","YES",null,"指标值"]
["target_value","decimal(18,4)","YES",null,"目标值"]
["status_color","varchar(16)","YES",null,"状态色"]
["trend_flag","varchar(8)","YES",null,"趋势"]
["calc_time","datetime(3)","YES",null,"计算时间"]
[]
["ado_s9_kpi_value_l3_day  —  KPI三级日值  (约2行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
["module_code","varchar(8)","YES",null,"模块编码"]
["metric_code","varchar(64)","YES",null,"指标编码"]
["metric_value","decimal(18,4)","YES",null,"指标值"]
["target_value","decimal(18,4)","YES",null,"目标值"]
["status_color","varchar(16)","YES",null,"状态色"]
["trend_flag","varchar(8)","YES",null,"趋势"]
["calc_time","datetime(3)","YES",null,"计算时间"]

{"sheet":"智慧运营(SmartOps)","index":15,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,4],[26,0,26,4],[9,0,9,4]]}
["ado_smart_ops_home_module  —  九宫格模块呈现  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["TenantId","bigint","NO",null,"租户"]
["FactoryId","bigint","NO",null,"工厂"]
["ModuleCode","varchar(8)","NO",null,"模块"]
["LayoutPattern","varchar(32)","NO",null,"布局 card_grid|table_list"]
["UpdateTime","datetime","NO",null,"更新时间"]
[]
["ado_smart_ops_layout_item  —  智慧运营布局行  (约10行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["TenantId","bigint","NO",null,"租户"]
["FactoryId","bigint","NO",null,"工厂"]
["ModuleCode","varchar(8)","NO",null,"模块"]
["RowId","varchar(96)","NO",null,"行ID"]
["MetricLevel","int","NO",null,"1=L1 2=L2"]
["MetricCode","varchar(64)","NO",null,"指标编码"]
["DisplayName","varchar(256)","YES",null,"展示名覆盖"]
["SortNo","int","NO",null,"排序"]
["ParentRowId","varchar(96)","YES",null,"L2 父行 RowId"]
["FormulaText","text","YES",null,"公式说明"]
["PanelZone","varchar(16)","YES",null,"详情分区"]
["IsEnabled","int","NO",null,"启用 0/1"]
["UpdateTime","datetime","NO",null,"更新时间"]
[]
["ado_smart_ops_metric_catalog  —  智慧运营指标字典  (约12行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键"]
["MetricCode","varchar(64)","NO",null,"指标编码"]
["ModuleCode","varchar(8)","NO",null,"模块 S1-S9"]
["MetricLevel","int","NO",null,"层级 1=L1 2=L2"]
["DefaultName","varchar(256)","NO",null,"默认中文名"]
["Unit","varchar(32)","YES",null,"单位"]
["Direction","varchar(32)","NO",null,"优劣方向"]
["SortHint","int","NO",null,"排序提示"]
["IsActive","int","NO",null,"启用 0/1"]

{"sheet":"主数据(MD)","index":16,"n_rows":97,"n_cols":5,"rows_kept":97,"cut":false,"hidden":false,"merged":[[56,0,56,4],[70,0,70,4],[28,0,28,4],[42,0,42,4],[84,0,84,4],[0,0,0,4],[14,0,14,4]]}
["ado_md_calendar  —  工作日历  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_md_customer  —  客户主数据  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_md_item  —  物料主数据  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_md_process_route  —  工艺路线  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_md_process_route_step  —  工艺步骤  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_md_supplier  —  供应商主数据  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_md_work_center  —  工作中心  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]

{"sheet":"集成(Intg)","index":17,"n_rows":83,"n_cols":5,"rows_kept":83,"cut":false,"hidden":false,"merged":[[56,0,56,4],[70,0,70,4],[28,0,28,4],[42,0,42,4],[0,0,0,4],[14,0,14,4]]}
["ado_intg_code_mapping  —  码值映射  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_intg_connector  —  连接器配置  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_intg_event_raw  —  原始事件落地  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_intg_field_mapping  —  字段映射  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_intg_sync_checkpoint  —  同步游标  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_intg_system  —  外部系统注册  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]

{"sheet":"移动端(Mobile)","index":18,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[28,0,28,4],[0,0,0,4],[42,0,42,4],[14,0,14,4]]}
["ado_mobile_alert_ack  —  移动端预警签收  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_mobile_incident_action  —  移动端异常操作轨迹  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_mobile_kpi_snapshot  —  移动端KPI快照  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]
[]
["ado_mobile_sync_cursor  —  移动端同步游标  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["tenant_id","bigint","NO",null,"租户ID"]
["org_id","bigint","YES",null,"集团ID"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","NO",null,"工厂ID"]
["status","varchar(32)","YES",null,"状态"]
["biz_date","date","YES",null,"业务日期"]
["create_time","datetime(3)","NO","CURRENT_TIMESTAMP(3)","创建时间"]
["update_time","datetime(3)","YES",null,"更新时间"]
["is_deleted","tinyint","NO","0","删除标识"]
["is_active","tinyint","NO","1","有效标识"]

{"sheet":"Demo表","index":19,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[[36,0,36,4],[0,0,0,4],[18,0,18,4]]}
["ado_orders  —  AiDOP Demo 订单  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","int","NO",null,"主键"]
["OrderNo","varchar(50)","NO",null,"订单号"]
["CustomerId","bigint","YES",null,"客户Id"]
["CustomerName","varchar(200)","NO",null,"客户名称"]
["ProductId","bigint","YES",null,"产品Id"]
["Product","varchar(200)","NO",null,"产品名称"]
["Quantity","int","NO",null,"数量"]
["UnitPrice","decimal(10,4)","NO",null,"单价"]
["Amount","decimal(10,4)","NO",null,"金额"]
["Status","varchar(50)","NO",null,"状态"]
["DeliveryDate","datetime","YES",null,"交货日期"]
["Remark","varchar(1000)","YES",null,"备注"]
["CreatedTime","datetime","NO",null,"创建时间"]
["UpdatedTime","datetime","YES",null,"更新时间"]
["CreatedBy","varchar(100)","YES",null,"创建人"]
[]
["ado_plans  —  AiDOP Demo 计划  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","int","NO",null,"主键"]
["PlanNo","varchar(50)","NO",null,"计划号"]
["PlanType","varchar(50)","NO",null,"计划类型"]
["ProductId","bigint","YES",null,"产品Id"]
["ProductName","varchar(200)","NO",null,"产品名称"]
["Quantity","int","NO",null,"计划数量"]
["CompletedQuantity","int","NO",null,"已完成数量"]
["StartDate","datetime","YES",null,"开始日期"]
["EndDate","datetime","YES",null,"结束日期"]
["Status","varchar(50)","NO",null,"状态"]
["Priority","varchar(50)","NO",null,"优先级"]
["Remark","varchar(1000)","YES",null,"备注"]
["CreatedTime","datetime","NO",null,"创建时间"]
["UpdatedTime","datetime","YES",null,"更新时间"]
["CreatedBy","varchar(100)","YES",null,"创建人"]
[]
["ado_work_orders  —  AiDOP Demo 工单  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","int","NO",null,"主键"]
["WorkOrderNo","varchar(50)","NO",null,"工单号"]
["PlanId","bigint","YES",null,"计划Id"]
["PlanNo","varchar(50)","YES",null,"计划号"]
["ProductId","bigint","YES",null,"产品Id"]
["Product","varchar(200)","NO",null,"产品"]
["Quantity","int","NO",null,"数量"]
["CompletedQuantity","int","NO",null,"已完成数量"]
["WorkCenter","varchar(100)","NO",null,"工作中心"]
["Team","varchar(100)","YES",null,"班组"]
["Owner","varchar(100)","YES",null,"负责人"]
["StartDate","datetime","YES",null,"开始日期"]
["PlanEndDate","datetime","YES",null,"计划完工"]
["ActualEndDate","datetime","YES",null,"实际完工"]
["Status","varchar(50)","NO",null,"状态"]
["Priority","varchar(50)","NO",null,"优先级"]
["Remark","varchar(1000)","YES",null,"备注"]
["CreatedTime","datetime","NO",null,"创建时间"]
["UpdatedTime","datetime","YES",null,"更新时间"]
["CreatedBy","varchar(100)","YES",null,"创建人"]

{"sheet":"其他","index":20,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,4],[9,0,9,4]]}
["TestViewSysUser  —  VIEW  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["Id","bigint","NO",null,"主键Id"]
["Account","varchar(32)","NO",null,"账号"]
["RealName","varchar(32)","NO",null,"真实姓名"]
["NickName","varchar(32)","YES",null,"昵称"]
["OrgName","varchar(64)","YES",null,"名称"]
["PosName","varchar(64)","YES",null,"名称"]
[]
["ic_substitute  —  替代方案（源平台表映射）  (约0行)"]
["字段名","类型","可空","默认值","说明"]
["id","bigint","NO",null,"主键"]
["substitute_code","varchar(100)","YES",null,"替代方案编码"]
["substitute_strategy","varchar(100)","YES",null,"替代策略"]
["substitute_mode","varchar(100)","YES",null,"替代方式"]
["create_time","datetime","YES",null,"创建时间"]
["company_id","bigint","YES",null,"公司ID"]
["factory_id","bigint","YES",null,"工厂ID"]
["IsDeleted","int","YES",null,"逻辑删除标记"]