{"text_format":"2","workbook":"xlsx","n_sheets":42,"sheets":["字典表","行政区划代码","行政区划","分组信息","组织信息","菜单信息","角色表","系统参数表","分组菜单关系信息","分组按钮关系信息","画面按钮信息","角色菜单关系信息","角色按钮关系信息","用户信息表","用户基础信息表","大字段表","分组用户关系信息","系统日志表","应急专家库","应急预案","危险货物品名表","管理制度","危险货物港口作业申请","港口危险货物作业\"附证\" 办理或换证申请表","附证关联的子表记录","港口危险货物作业办理或换证申请表附证","应急物资子表（应急设施分类信息）","附件表","经营人的人员信息","人员情况汇总表子表——证书表","经营人基础信息","码头信息","港区","港口设施设备","堆场","仓库信息","储罐信息","泊位","AQ_BASIC_FRAME_WF_PROP","工作信息表","AQ_BASIC_FRAME_IDENTITYLINK","危险物品名称"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"字典表","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,7],[21,0,21,9],[22,0,22,9],[23,0,23,9],[24,0,24,9]]}
["实体名","AQ_BASIC_FRAME_CODE"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识","VARCHAR2(40 char)",40,0,true,false,true]
["PID","上级ID","VARCHAR2(40 char)",40,0,false,false,false]
["PCODE","上级编码","VARCHAR2(40 char)",40,0,false,false,false]
["TEXT","字典名称","VARCHAR2(100 char)",100,0,false,false,false]
["CODE","字典编码","VARCHAR2(100 char)",100,0,false,false,false]
["VAL","编码值","VARCHAR2(100 char)",100,0,false,false,false]
["LEAF","是否末级","CHAR(1 char)",1,0,false,false,false]
["SORTNO","排序号","NUMBER(11)",11,0,false,false,false]
["REMARK","备注","VARCHAR2(120 char)",120,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","更新时间","TIMESTAMP(0)",0,0,false,false,false]
["STATE","记录状态","CHAR(1 char)",1,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
[]
["yxd"]
["1、去掉val列，不保存老系统ID，在数据割接时老数据全部转换为新代码"]
["2、增加更新人、插入人列"]
["3、增加索引设计：pid、pcode"]
["4、增加表空间设计"]
["5、pcode长度与code长度保持一致"]
["6、增加group分组编码，默认是PCODE，可以修改，如果上级是有编码的就修改为上上级的"]

{"sheet":"行政区划代码","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,7],[13,0,13,13],[14,0,14,13],[16,0,16,13],[15,0,15,17],[17,0,17,13],[18,0,18,13],[19,0,19,13],[20,0,20,13],[21,0,21,13]]}
["实体名","AQ_BASIC_DM_XZQHDM"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识","VARCHAR2(40)",40,0,true,false,true]
["NAME","名称","VARCHAR2(50)",50,0,false,false,false]
["CODE","代码","VARCHAR2(10)",10,0,false,false,false]
["XH","排序号","NUMBER",0,0,false,false,false]
["FBSJ","发布时间","TIMESTAMP",0,0,false,false,false]
["STATE","记录状态","CHAR",0,0,false,false,false]
[]
[]
[]
[]
[]
["YXD"]
["没用请删除，表重复"]

{"sheet":"行政区划","index":2,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,24,13],[19,0,19,13],[0,1,0,7],[20,0,20,13],[21,0,21,17],[22,0,22,13],[23,0,23,13]]}
["实体名","AQ_BASIC_FRAME_XZQHDM"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["CODE","编码","VARCHAR2(10)",10,0,false,false,false]
["NAME","名称","VARCHAR2(50)",50,0,false,false,false]
["XH","序号","NUMBER",0,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(7)",7,0,false,false,false]
["UPDATE_TIME","插入时间","TIMESTAMP(7)",7,0,false,false,false]
["STATE","记录状态","CHAR(1 char)",1,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(40)",40,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(40)",40,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
[]
[]
[]
["yxd"]
["1、补全注释"]
["2、增加索引设计"]
["3、增加表空间设计"]
["4、排序号名称一致"]
["5、增加发布时间字段（fbsj）。比如2017年发布新版会把2016年的数据设置为无效，2017设置为有效。而关联检索时可以显示无效记录的名称。"]

{"sheet":"分组信息","index":3,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[27,0,27,11],[26,0,26,11],[0,1,0,7],[22,0,22,11],[23,0,23,11]]}
["实体名","AQ_BASIC_FRAME_GROUP"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识UUID","VARCHAR2(40)",40,0,true,false,true]
["ORG_ID","组织ID","VARCHAR2(40)",40,0,false,false,false]
["ROLE_ID","角色ID","VARCHAR2(40)",40,0,false,false,false]
["REMARK","备注","VARCHAR2(255)",255,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","更新时间","TIMESTAMP(0)",0,0,false,false,false]
["STATE","记录状态（无效：0，有效：1，过期：2）","CHAR",0,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(40)",40,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(40)",40,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
[]
[]
[]
[]
[]
[]
["yxd"]
["1、增加索引设计，建议org_id、role_id"]

{"sheet":"组织信息","index":4,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,0,33,11],[34,0,34,11],[35,0,35,11],[0,1,0,7],[29,0,29,11],[30,0,30,11],[31,0,31,11],[32,0,32,11]]}
["实体名","AQ_BASIC_FRAME_ORG"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识","VARCHAR2(40)",40,0,true,false,true]
["NAME","组织名称","VARCHAR2(100 char)",100,0,false,false,false]
["CODE","组织编码（系统内部like用）","VARCHAR2(255)",255,0,false,false,false]
["ORG_TYPE","组织类型（所在地1、部门2、科室3）","VARCHAR2(40)",40,0,false,false,false]
["REMARK","备注","VARCHAR2(200 char)",200,0,false,false,false]
["PID","上级组织","VARCHAR2(40)",40,0,false,false,false]
["SORTNO","排序","NUMBER",0,0,false,false,false]
["SZD","所在地编码","VARCHAR2(255)",255,0,false,false,false]
["SZD_NAME","所在地名称","VARCHAR2(255)",255,0,false,false,false]
["STATE","记录状态（无效：0，有效：1，过期：2）","CHAR",0,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","更新时间","TIMESTAMP(0)",0,0,false,false,false]
["XZQH","行政区划","VARCHAR2(50)",50,0,false,false,false]
["LEVEL","级别","VARCHAR2(255)",255,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(40)",40,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(40)",40,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
[]
[]
[]
[]
[]
[]
["yxd"]
["1、级别是什么用"]
["2、所在地名称可以去掉，有编码就可以"]
["3、行政区划存code，长度为10，与行政区划表一致"]
["4、增加索引设计，建议code、name、szd、ORG_TYPE"]

{"sheet":"菜单信息","index":5,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[30,0,30,11],[31,0,31,11],[32,0,32,11],[33,0,33,11],[0,1,0,7],[26,0,26,11],[27,0,27,11],[28,0,28,11],[29,0,29,11]]}
["实体名","AQ_BASIC_FRAME_MENU"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识","VARCHAR2(40 char)",40,0,true,false,true]
["PID","上级菜单","VARCHAR2(40 char)",40,0,false,false,false]
["NAME","菜单名称","VARCHAR2(100 char)",100,0,false,false,false]
["CODE","菜单编码","VARCHAR2(40 char)",40,0,false,false,false]
["ICON","显示图标","VARCHAR2(40 char)",40,0,false,false,false]
["URL","菜单路径","VARCHAR2(150 char)",150,0,false,false,false]
["LEAF","是否末级菜单","CHAR(1 char)",1,0,false,false,false]
["OUT_LINK","是否外部链接","CHAR(1 char)",1,0,false,false,false]
["REMARK","备注","VARCHAR2(1000 char)",1000,0,false,false,false]
["SORTNO","排序号","NUMBER(11)",11,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(7)",7,0,false,false,false]
["UPDATE_TIME","插入时间","TIMESTAMP(7)",7,0,false,false,false]
["STATE","记录状态","CHAR(1 char)",1,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(40)",40,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(40)",40,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
[]
[]
[]
[]
["yxd"]
["1、增加上级菜单编码字段"]
["2、增加索引，建议PID、pcode，code"]

{"sheet":"角色表","index":6,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[26,0,26,11],[27,0,27,11],[28,0,28,11],[29,0,29,11],[22,0,22,11],[23,0,23,11],[24,0,24,11],[25,0,25,11]]}
["实体名","AQ_BASIC_FRAME_ROLE"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","UUID","VARCHAR2(40)",40,0,true,false,true]
["NAME","角色名称","VARCHAR2(100)",100,0,false,false,false]
["CODE","角色编码","VARCHAR2(255)",255,0,false,false,false]
["REMARK","备注","VARCHAR2(255)",255,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","更新时间","TIMESTAMP(0)",0,0,false,false,false]
["STATE","记录状态（无效：0，有效：1，过期：2）","CHAR",0,0,false,false,false]
["SORTNO","排序号","NUMBER",0,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(40)",40,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(40)",40,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
[]
[]
[]
[]
[]
["yxd"]
["1、增加索引：name、code、remark"]

{"sheet":"系统参数表","index":7,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[23,0,23,11],[24,0,24,11],[26,0,26,11],[25,0,25,11],[0,1,0,7],[19,0,19,11],[20,0,20,11],[21,0,21,11],[22,0,22,11]]}
["实体名","AQ_BASIC_FRAME_PARAM"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识","VARCHAR2(40 char)",40,0,true,false,true]
["KEY","参数主键","VARCHAR2(100 char)",100,0,false,false,false]
["VALUE","参数值","VARCHAR2(100 char)",100,0,false,false,true]
["CLAZZ","所属类","VARCHAR2(40 char)",40,0,false,false,false]
["DISP","属性描述","VARCHAR2(200 char)",200,0,false,false,false]
["STATE","是否有效","CHAR(1 char)",1,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","更新时间","TIMESTAMP(0)",0,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(40)",40,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(40)",40,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
[]
[]
[]
["yxd"]
["此功能在系统启动时全表查询一次初始化至全局变量，后面建议增加参数重新加载功能，管理员调用可实时修改全局参数"]

{"sheet":"分组菜单关系信息","index":8,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,7],[15,0,15,11],[16,0,16,11]]}
["实体名","AQ_BASIC_FRAME_GROUP_MENU"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识","VARCHAR2(40 char)",40,0,true,false,true]
["GROUP_ID","角色ID","VARCHAR2(40 char)",40,0,false,false,false]
["MENU_ID","菜单ID","VARCHAR2(40 char)",40,0,false,false,false]
["STATE","记录状态","CHAR(1 char)",1,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","插入时间","TIMESTAMP(0)",0,0,false,false,false]
{"$rows_empty":7}
["yxd"]
["角色ID和菜单ID增加索引"]

{"sheet":"分组按钮关系信息","index":9,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_FRAME_GROUP_BUTTON"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识","VARCHAR2(40 char)",40,0,true,false,true]
["GROUP_ID","用户ID","VARCHAR2(40 char)",40,0,false,false,false]
["BUTTON_ID","按钮ID","VARCHAR2(40 char)",40,0,false,false,false]
["STATE","记录状态","CHAR(1 char)",1,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","插入时间","TIMESTAMP(0)",0,0,false,false,false]
{"$rows_empty":8}
["yxd"]
["加索引"]

{"sheet":"画面按钮信息","index":10,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_FRAME_BUTTON"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识","VARCHAR2(40 char)",40,0,true,false,true]
["NAME","功能名称","VARCHAR2(100 char)",100,0,false,false,false]
["CODE","功能编码","VARCHAR2(40 char)",40,0,false,false,false]
["MENU","所属菜单","VARCHAR2(40 char)",40,0,false,false,false]
["ICON","显示图标","VARCHAR2(40 char)",40,0,false,false,false]
["REMARK","备注","VARCHAR2(1000 char)",1000,0,false,false,false]
["SORTNO","排序号","NUMBER(11)",11,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(7)",7,0,false,false,false]
["UPDATE_TIME","插入时间","TIMESTAMP(7)",7,0,false,false,false]
["STATE","记录状态","CHAR(1 char)",1,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
[]
[]
[]
[]
[]
[]
["yxd"]
["公共字段补全：创建人、更新人；"]
["备注“插入时间”改为“更新时间”"]
["增加索引：所属菜单等"]

{"sheet":"角色菜单关系信息","index":11,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_FRAME_ROLE_MENU"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识","VARCHAR2(40 char)",40,0,true,false,true]
["ROLE_ID","角色ID","VARCHAR2(40 char)",40,0,false,false,false]
["MENU_ID","菜单ID","VARCHAR2(40 char)",40,0,false,false,false]
["STATE","记录状态","CHAR(1 char)",1,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","插入时间","TIMESTAMP(0)",0,0,false,false,false]
{"$rows_empty":10}
["yxd"]
["增加索引"]
["公共字段补全：创建人、更新人；"]

{"sheet":"角色按钮关系信息","index":12,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_FRAME_ROLE_BUTTON"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识","VARCHAR2(40 char)",40,0,true,false,true]
["ROLE_ID","角色ID","VARCHAR2(40 char)",40,0,false,false,false]
["BUTTON_ID","按钮ID","VARCHAR2(40 char)",40,0,false,false,false]
["STATE","记录状态","CHAR(1 char)",1,0,false,false,false]
{"$rows_empty":8}
["yxd"]
["加索引"]

{"sheet":"用户信息表","index":13,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_FRAME_USER"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["REAL_NAME","真实姓名","VARCHAR2(100)",100,0,false,false,false]
["LOGIN_NAME","登录账号","VARCHAR2(255)",255,0,false,false,false]
["LOGIN_PASSWORD","登录密码","VARCHAR2(255)",255,0,false,false,false]
["ORGID","所在组织ID（行政人员所在管理部门，企业所属管理部门）","VARCHAR2(40)",40,0,false,false,false]
["SEX","性别","CHAR",0,0,false,false,false]
["PHONE","联系电话","VARCHAR2(20)",20,0,false,false,false]
["EMAIL","电子邮箱","VARCHAR2(255)",255,0,false,false,false]
["STATE","记录状态（无效：0，有效：1，过期：2）","CHAR",0,0,false,false,false]
["RYLX","人员类型（行政人员 1、经营人2、船代3等）","CHAR",0,0,false,false,false]
["SXSJ","账号失效时间","TIMESTAMP(0)",0,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","更新时间","TIMESTAMP(0)",0,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(40)",40,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(40)",40,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
[]
[]
["yxd"]
["1、性别放到扩展表中，不在此表维护"]
["2、增加微信号字段，以后可能要管理微信登录"]
["3、增加索引"]
["4、此表备用字段只留1个，表字段尽量少，表要小，只留与登录相关的必要信息"]

{"sheet":"用户基础信息表","index":14,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_FRAME_USERINFO"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","ID","VARCHAR2(64)",64,0,true,false,true]
["REAL_NAME","真实姓名","VARCHAR2(128)",128,0,false,false,false]
["LOGIN_NAME","登录账号","VARCHAR2(256)",256,0,false,false,false]
["ORGID","所在组织ID（行政人员所在管理部门，企业所属管理部门）","VARCHAR2(64)",64,0,false,false,false]
["IF_SAFTEY","是否安全负责人","CHAR",0,0,false,false,false]
["IF_LOGIN","是否允许登录","CHAR",0,0,false,false,false]
["IF_MAPVIEW","是否允许查看地图","CHAR",0,0,false,false,false]
["IF_OVERSEER","是否监察人员","CHAR",0,0,false,false,false]
["IF_OPERATOR","是否经营人（反之行政人员）","CHAR",0,0,false,false,false]
["IF_ADMIN","是否行政人员（略）","CHAR",0,0,false,false,false]
["IF_APPROVE","是否自动审批人员","CHAR",0,0,false,false,false]
["IF_SHIP","是否船代","CHAR",0,0,false,false,false]
["IF_JOB","是否允许作业申请","CHAR",0,0,false,false,false]
["BELONGS_ORG","所属机构/所属船代","VARCHAR2(128)",128,0,false,false,false]
["BELONGS_SHIP","所属船代（略）","VARCHAR2(128)",128,0,false,false,false]
["APPROVE_SET","审批设置","VARCHAR2(256)",256,0,false,false,false]
["DECLARER_CID","申报员证书编号","VARCHAR2(128)",128,0,false,false,false]
["BELONGS_OPERATOR","所属经营人","VARCHAR2(64)",64,0,false,false,false]
["SAFETY_ASSESS_ORG","安全评价机构","VARCHAR2(64)",64,0,false,false,false]
["DEVELOPMENT_ORG","建设单位","VARCHAR2(64)",64,0,false,false,false]
["BIRTHDAY","出生年月","DATE",0,0,false,false,false]
["SEX","性别","CHAR",0,0,false,false,false]
["POLITICS_STATUS","政治面貌","CHAR(2)",2,0,false,false,false]
["EDUCATION_BACKGROUND","学历","CHAR(2)",2,0,false,false,false]
["DUTY","职务","CHAR(2)",2,0,false,false,false]
["PLANNING","编制","CHAR(2)",2,0,false,false,false]
["USER_STATE","人员状态","CHAR(2)",2,0,false,false,false]
["PHONE","联系电话","VARCHAR2(32)",32,0,false,false,false]
["EMAIL","电子邮箱","VARCHAR2(128)",128,0,false,false,false]
["FAX","传真","VARCHAR2(16)",16,0,false,false,false]
["ADDRESS","办公地址","VARCHAR2(256)",256,0,false,false,false]
["STATE","记录状态（无效：0，有效：1，过期：2）","CHAR",0,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_TIME","更新时间","TIMESTAMP",0,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(64)",64,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(64)",64,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
[]
[]
[]
["yxd"]
["1、此表应该是用户表的扩展表，用户表已有信息此处要删掉，不做冗余。用户登录后详细信息在此表查询"]
["2、增加与用户表的关联关系"]

{"sheet":"大字段表","index":15,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_BLOB"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["VALUE",null,"BLOB",0,0,false,false,false]
["ADD_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","修改时间","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","删除状态","NUMBER",0,0,false,false,false]
["TBZT","同步状态 已同步Y， 未同步N","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["QYLB","区域类别，省级还是市级","CHAR",0,0,false,false,false]
["SSQY","所属区域，关联组织架构表的主键","VARCHAR2(200)",200,0,false,false,false]
["SFTB","是否同步 Y或者N","CHAR",0,0,false,false,false]
["RECORD_CODE",null,"VARCHAR2(30)",30,0,false,false,false]
["BYZD1",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD2",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD3",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD4",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD5",null,"VARCHAR2(100)",100,0,false,false,false]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["SZD",null,"VARCHAR2(40)",40,0,false,false,false]
[]
[]
[]
[]
["yxd"]
["1、ssqy已管理组织id，区域类别可查询出，看是否必要"]
["2、同步接口规范统一设计，同步相关字段统计修改。"]

{"sheet":"分组用户关系信息","index":16,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_FRAME_USER_GROUP"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","唯一标识","VARCHAR2(40 char)",40,0,true,false,true]
["GROUP_ID","分组ID","VARCHAR2(40 char)",40,0,false,false,false]
["USER_ID","用户ID","VARCHAR2(40 char)",40,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","更新时间","TIMESTAMP(0)",0,0,false,false,false]
["STATE","记录状态（无效：0，有效：1，过期：2）","CHAR",0,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(40)",40,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(40)",40,0,false,false,false]
[]
[]
[]
[]
[]
[]
["yxd"]
["加索引"]

{"sheet":"系统日志表","index":17,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_FRAME_SYSLOG"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","ID","VARCHAR2(64)",64,0,true,false,true]
["LOG_TYPE","日志类型（0、普通，1、异常，2、业务，3、登入，4、登出）","CHAR",0,0,false,false,false]
["LOG_PATH","日志路径","VARCHAR2(512)",512,0,false,false,false]
["LOG_PARAM","日志参数","VARCHAR2(4000)",4000,0,false,false,false]
["LOG_MSG","日志消息","VARCHAR2(4000)",4000,0,false,false,false]
["CLIENT_IP","客户端IP","VARCHAR2(32)",32,0,false,false,false]
["STATE","记录状态（无效：9）","CHAR",0,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_TIME","更新时间","TIMESTAMP",0,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(64)",64,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(64)",64,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
[]
[]
[]
[]
[]
[]
["yxd"]
["1、记录当前操作人"]

{"sheet":"应急专家库","index":18,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_YJZJK"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","ID","VARCHAR2(40)",40,0,true,false,true]
["SZGQ","所在港区","VARCHAR2(100)",100,0,false,false,false]
["SZD","所在地","VARCHAR2(100)",100,0,false,false,false]
["XM","姓名","VARCHAR2(10)",10,0,false,false,false]
["XB","性别","VARCHAR2(10)",10,0,false,false,false]
["MZ","民族","VARCHAR2(10)",10,0,false,false,false]
["SFZH","身份证号","VARCHAR2(20)",20,0,false,false,false]
["CSNY","出生年月","TIMESTAMP",0,0,false,false,false]
["XJZD","现居住地","VARCHAR2(100)",100,0,false,false,false]
["JTDH","家庭电话","VARCHAR2(20)",20,0,false,false,false]
["GZDW","工作单位","VARCHAR2(100)",100,0,false,false,false]
["GZDH","工作电话","VARCHAR2(20)",20,0,false,false,false]
["DWDZ","单位地址","VARCHAR2(100)",100,0,false,false,false]
["SZBM","所在部门","VARCHAR2(100)",100,0,false,false,false]
["ZW","职务","VARCHAR2(50)",50,0,false,false,false]
["JSZC","技术职称","VARCHAR2(50)",50,0,false,false,false]
["ZGXL","最高学历","VARCHAR2(50)",50,0,false,false,false]
["SXZY1","所学专业1","VARCHAR2(50)",50,0,false,false,false]
["SXZY2","所学专业2","VARCHAR2(50)",50,0,false,false,false]
["BYYX","毕业院校","VARCHAR2(100)",100,0,false,false,false]
["XCSZY","现从事专业","VARCHAR2(50)",50,0,false,false,false]
["ZCLB","专长类别","VARCHAR2(50)",50,0,false,false,false]
["GZJL","工作简历","VARCHAR2(1000)",1000,0,false,false,false]
["ZYYJ","主要业绩","VARCHAR2(1000)",1000,0,false,false,false]
["STATE","记录状态","CHAR",0,0,false,false,false]
["SFTB","是否同步","CHAR",0,0,false,false,false]
["TBZT","同步状态","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER(22)",22,0,false,false,false]
["QYLB","区域类别","CHAR",0,0,false,false,false]
["SSQY","所属区域","VARCHAR2(100)",100,0,false,false,false]
["ORG_CODE","记录代码","VARCHAR2(30)",30,0,false,false,false]
["SCJYHZ","擅长救援货种","VARCHAR2(100)",100,0,false,false,false]
["SFSYGKJ","是否属于港口局","CHAR",0,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_TIME","修改时间","TIMESTAMP",0,0,false,false,false]
[]
[]
["yxd"]
["增加必要的索引，比如姓名"]

{"sheet":"应急预案","index":19,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[[60,0,60,13],[62,0,62,13],[63,0,63,13],[0,1,0,7],[56,0,56,13],[57,0,57,13],[58,0,58,13],[59,0,59,13]]}
["实体名","AQ_YJYA"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["YAMC","预案名称","VARCHAR2(100)",100,0,false,false,false]
["YAJB","预案级别","VARCHAR2(40)",40,0,false,false,false]
["ZZDW","制作单位","VARCHAR2(40)",40,0,false,false,false]
["ZDSJ","制定时间","DATE",0,0,false,false,false]
["XDSJ","修订时间","DATE",0,0,false,false,false]
["YAGS","预案概述","VARCHAR2(1000)",1000,0,false,false,false]
["STATE","删除状态","CHAR",0,0,false,false,false]
["SFTB","是否同步 Y或者N","CHAR",0,0,false,false,false]
["TBZT","同步状态 已同步Y， 未同步N","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","VARCHAR2(40)",40,0,false,false,false]
["QYLB","区域类别，省级还是市级","CHAR",0,0,false,false,false]
["SSQY","所属区域，关联组织架构表的主键","VARCHAR2(40)",40,0,false,false,false]
["GQ","港区","VARCHAR2(40)",40,0,false,false,false]
["SZD","所在地","VARCHAR2(40)",40,0,false,false,false]
["SFXD","是否根据实际情况进行预案的修订Y/N","CHAR",0,0,false,false,false]
["SFBA","是否已在上级主管部门备案Y/N","CHAR",0,0,false,false,false]
["SFPX","是否组织从业人员进行预案的培训Y/N","CHAR",0,0,false,false,false]
["SFPXJL","是否有相关的培训计划及记录Y/N","CHAR",0,0,false,false,false]
["SFYL","是否对预案进行演练Y/N","CHAR",0,0,false,false,false]
["SFYLJL","是否有演练计划及记录Y/N","CHAR",0,0,false,false,false]
["ORG_CODE","记录代码","VARCHAR2(30)",30,0,false,false,false]
["WH","文号","VARCHAR2(100)",100,0,false,false,false]
["ZYFZ_ID","作业附证Id","VARCHAR2(40)",40,0,false,false,false]
["QYMC","企业名称","VARCHAR2(40)",40,0,false,false,false]
["FBSJ","发布时间","TIMESTAMP",0,0,false,false,false]
["TBR","填表人","VARCHAR2(50)",50,0,false,false,false]
["TBRLXDH","填表人联系电话","VARCHAR2(20)",20,0,false,false,false]
["GKDW","港口单位","VARCHAR2(200)",200,0,false,false,false]
["DWADDRESS","单位地址","VARCHAR2(100)",100,0,false,false,false]
["JJTYPE","经济类型","VARCHAR2(40)",40,0,false,false,false]
["CYRYRS","从业人员人数","VARCHAR2(100)",100,0,false,false,false]
["YZBM","邮政编码","VARCHAR2(100)",100,0,false,false,false]
["ZCZJ","注册资金","NUMBER",0,0,false,false,false]
["ZYFZR","主要负责人","VARCHAR2(100)",100,0,false,false,false]
["DH","电话","VARCHAR2(100)",100,0,false,false,false]
["DZEMAIL","电子信箱","VARCHAR2(100)",100,0,false,false,false]
["BZDATE","编制日期","TIMESTAMP",0,0,false,false,false]
["VERSIONNO","版本号","VARCHAR2(100)",100,0,false,false,false]
["FAX","传真","VARCHAR2(30)",30,0,false,false,false]
["CYRY","从业人员","VARCHAR2(30)",30,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_TIME","修改时间","TIMESTAMP",0,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(2000)",2000,0,false,false,false]
[]
[]
[]
["yxd"]
["1、“预案级别”由目前的“综合预案、专项预案、现场处置方案”修改为“1-省级；2-市级；3-县级；4-企业级；9-其它”"]
["2、“所在地”应随预案单位带出，不需要选择"]
["3、“港区”应随预案单位带出，不需要选择"]
["4、“预案类别（港口单位预案、港口经营人预案）”改为“应急预案类型”，包括“1-综合预案；2-专项预案”"]
["5、 “单位/港口经营人名称”改为“预案编制单位”"]
["6、“单位地址”、“经济类型”、“邮政编码”、“从业人员”、“注册资金万元”、“主要负责人”、“传真”、“电子信箱”这些字段可关联经营人基本信息显示，无需填写（如果是经营人预案）。"]
["7、增加“应急预案事件类型”，包括“1-生产安全事故；2-危险货物（危险化学品）事故；3-自然灾害；4-人员疏散；5-社会安全；9-其它”"]
["8、增加“应急预案备案时间”"]

{"sheet":"危险货物品名表","index":20,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,0,7],[33,0,33,10]]}
["实体名","AQ_WXHWPMB"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","ID","VARCHAR2(40)",40,0,true,false,true]
["BH","编号","VARCHAR2(10)",10,0,false,false,false]
["MCHSM","名称和说明","VARCHAR2(200)",200,0,false,false,false]
["YWMC","英文名称","VARCHAR2(500)",500,0,false,false,false]
["LBHXB","类别和项别","VARCHAR2(100)",100,0,false,false,false]
["CYWXX","次要危险性","VARCHAR2(100)",100,0,false,false,false]
["BZLB","包装类别","VARCHAR2(50)",50,0,false,false,false]
["BZ","备注","VARCHAR2(200)",200,0,false,false,false]
["STATE","删除状态","CHAR",0,0,false,false,false]
["TBZT","同步状态 已同步Y， 未同步N","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["QYLB","区域类别，省级还是市级","CHAR",0,0,false,false,false]
["SFTB","是否同步 Y或者N","CHAR",0,0,false,false,false]
["ORG_CODE",null,"VARCHAR2(30)",30,0,false,false,false]
["BHUN","编号(UN号)","VARCHAR2(100)",100,0,false,false,false]
["LBBH","类别编号","VARCHAR2(100)",100,0,false,false,false]
["MCHSMBY","名称和说明备用","VARCHAR2(200)",200,0,false,false,false]
["LHXZ","理化性质","VARCHAR2(512)",512,0,false,false,false]
["AQFFCS","防范措施","VARCHAR2(1000)",1000,0,false,false,false]
["SZD","SZD","VARCHAR2(100)",100,0,false,false,false]
["HZWXX","火灾危险性","VARCHAR2(20)",20,0,false,false,false]
["DXDJ","毒性等级","VARCHAR2(20)",20,0,false,false,false]
["WRLB","污染类别","VARCHAR2(20)",20,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_TIME","修改时间","TIMESTAMP",0,0,false,false,false]
["SSQY",null,"VARCHAR2(200)",200,0,false,false,false]
[]
[]
["yxd"]
["危险品名表要换成海事危险品库，全库更新，老库数据要保留，因为历史申报单上关联的是老库"]
["本库不需要org_code"]

{"sheet":"管理制度","index":21,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_GLZD"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","ID","VARCHAR2(40)",40,0,true,false,true]
["BXDW","编写单位","VARCHAR2(100)",100,0,false,false,false]
["SZD","所在地","VARCHAR2(100)",100,0,false,false,false]
["SZGQ","所在港区","VARCHAR2(100)",100,0,false,false,false]
["ZDMC","制度名称","VARCHAR2(200)",200,0,false,false,false]
["ZDFL","制度分类","VARCHAR2(100)",100,0,false,false,false]
["TXSJ","填写时间","TIMESTAMP",0,0,false,false,false]
["TBR","填表人","VARCHAR2(100)",100,0,false,false,false]
["LXDH","联系电话","VARCHAR2(100)",100,0,false,false,false]
["QYMC","企业名称","VARCHAR2(40)",40,0,false,false,false]
["SSGQ","所属港区","VARCHAR2(40)",40,0,false,false,false]
["STATE","删除状态","CHAR",0,0,false,false,false]
["SFTB","SFTB","CHAR",0,0,false,false,false]
["TBZT","TBZT","CHAR",0,0,false,false,false]
["TBDYID","TBDYID","VARCHAR2(40)",40,0,false,false,false]
["QYLB","QYLB","CHAR",0,0,false,false,false]
["SSQY","SSQY","VARCHAR2(40)",40,0,false,false,false]
["ORG_CODE","ORG_CODE","VARCHAR2(30)",30,0,false,false,false]
["ZDWH","制度文号","VARCHAR2(200)",200,0,false,false,false]
["FBRQ","发布日期","TIMESTAMP",0,0,false,false,false]
["XDRQ","修订日期","TIMESTAMP",0,0,false,false,false]
["SFCZGC","是否操作规程","VARCHAR2(50)",50,0,false,false,false]
["ZYFZ_ID","作业附证Id","VARCHAR2(40)",40,0,false,false,false]
["LXR","联系人","VARCHAR2(100)",100,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_TIME","修改时间","TIMESTAMP",0,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(2000)",2000,0,false,false,false]
[]
[]
[]
["yxd"]
["省市两级同步方式考虑"]
["补充注释"]

{"sheet":"危险货物港口作业申请","index":22,"n_rows":82,"n_cols":8,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_DWXX_WXHWGKZYSBD"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ZYWTR","作业委托人","VARCHAR2(100)",100,0,false,false,false]
["XCGLFZR","现场管理负责人","VARCHAR2(20)",20,0,false,false,false]
["ADD_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","修改时间","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","删除状态","NUMBER",0,0,false,false,false]
["SFTB","是否同步 Y或者N","CHAR",0,0,false,false,false]
["TBZT","同步状态 已同步Y， 未同步N","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["QYLB","区域类别，省级还是市级","CHAR",0,0,false,false,false]
["RECORD_CODE",null,"VARCHAR2(30)",30,0,false,false,false]
["BYZD1",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD2",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD3",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD4",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD5",null,"VARCHAR2(100)",100,0,false,false,false]
["BH","编号","VARCHAR2(50)",50,0,false,false,false]
["CM","船名","VARCHAR2(200)",200,0,false,false,false]
["WXPLB","危险品类别","VARCHAR2(200)",200,0,false,false,false]
["WXWPMC","危险物品名称","VARCHAR2(200)",200,0,false,false,false]
["WPBH","物品编号","VARCHAR2(200)",200,0,false,false,false]
["JSPM","技术品名","VARCHAR2(200)",200,0,false,false,false]
["ZYSL","作业数量（吨）","NUMBER",0,0,false,false,false]
["LHXZ","理化性质","VARCHAR2(2000)",2000,0,false,false,false]
["ZYSJ","作业时间","TIMESTAMP",0,0,false,false,false]
["ZYDD","作业地点","VARCHAR2(20)",20,0,false,false,false]
["AQFFCS","安全防范措施","VARCHAR2(2000)",2000,0,false,false,false]
["BGR","报告人","VARCHAR2(100)",100,0,false,false,false]
["LXFS","联系方式","VARCHAR2(400)",400,0,false,false,false]
["BGSJ","报告时间","TIMESTAMP",0,0,false,false,false]
["ZYDDQYBH","作业场所选择企业内部编号","VARCHAR2(20)",20,0,false,false,false]
["KPSJ","靠泊时间","TIMESTAMP",0,0,false,false,false]
["ZYLX","作业类型","VARCHAR2(100)",100,0,false,false,false]
["SG","上港","VARCHAR2(100)",100,0,false,false,false]
["XG","下港","VARCHAR2(100)",100,0,false,false,false]
["KGSJ","开工时间","TIMESTAMP",0,0,false,false,false]
["WGSJ","完工时间","TIMESTAMP",0,0,false,false,false]
["KGZT","开工状态","CHAR",0,0,false,false,false]
["WGZT","完工状态","CHAR",0,0,false,false,false]
["GJBH","国际编号","VARCHAR2(100)",100,0,false,false,false]
["ZYSJQ","作业时间起","TIMESTAMP",0,0,false,false,false]
["ZYSJZ","作业时间止","TIMESTAMP",0,0,false,false,false]
["QXZYSJ","取消作业时间","TIMESTAMP",0,0,false,false,false]
["ZYDDQT","作业地点其他的选项","VARCHAR2(50)",50,0,false,false,false]
["WXHWMCBH","危险货物品种编号","VARCHAR2(200)",200,0,false,false,false]
["INOROUT","进或者出港","CHAR",0,0,false,false,false]
["MAO","内贸外贸","VARCHAR2(10)",10,0,false,false,false]
["JZXSL","集装箱数量","VARCHAR2(15)",15,0,false,false,false]
["HWXS","货物形式","VARCHAR2(100)",100,0,false,false,false]
["HC","航次","VARCHAR2(40)",40,0,false,false,false]
["CBBH","船舶编号","VARCHAR2(20)",20,0,false,false,false]
["MERGE","比对结果","VARCHAR2(10)",10,0,false,false,false]
["CNNO","物品CN编码","VARCHAR2(100)",100,0,false,false,false]
["SL20C","20'集装箱数量","NUMBER",0,0,false,false,false]
["SL40C","40'集装箱数量","NUMBER",0,0,false,false,false]
["SL45C","45'集装箱数量","NUMBER",0,0,false,false,false]
["SLSPC","特种集装箱数量","NUMBER",0,0,false,false,false]
["SL20T","20'罐柜数量","NUMBER",0,0,false,false,false]
["SL40T","40'罐柜数量","NUMBER",0,0,false,false,false]
["TEU","TEU","NUMBER",0,0,false,false,false]
["BZ","包装","VARCHAR2(20)",20,0,false,false,false]
["JZXXH","集装箱箱号","VARCHAR2(2000)",2000,0,false,false,false]
["SR","开工报填报人","VARCHAR2(100)",100,0,false,false,false]
["FR","完工报填报人","VARCHAR2(100)",100,0,false,false,false]
["ZYDW",null,"VARCHAR2(40)",40,0,false,false,false]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["SSQY","所属区域","VARCHAR2(200)",200,0,false,false,false]
["GQ","港区","VARCHAR2(200)",200,0,false,false,false]
["SZD","所在地","VARCHAR2(200)",200,0,false,false,false]
["SZGQ","所在港区","VARCHAR2(200)",200,0,false,false,false]
["ZYDDSSJYR","作业地点所属经营人","VARCHAR2(200)",200,0,false,false,false]
["HZWXX","火灾危险性","VARCHAR2(200)",200,0,false,false,false]
["DXDJ","毒性等级","VARCHAR2(200)",200,0,false,false,false]
["WRLB","污染类别","VARCHAR2(200)",200,0,false,false,false]
["HWZL","货物种类","VARCHAR2(200)",200,0,false,false,false]
[]
[]
["yxd"]
["1、需要新增字段：进出口标记、CAS编号、安全技术说明书、作业委托人联系人、作业委托人联系人联系电话。"]

{"sheet":"港口危险货物作业\"附证\" 办理或换证申请表","index":23,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_GKWXHWZYFZBLHHZ"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["QYMC","企业名称","VARCHAR2(200)",200,0,false,false,false]
["SZD","所在地","VARCHAR2(40)",40,0,false,false,false]
["SSGQ","所属港区","VARCHAR2(40)",40,0,false,false,false]
["DZ","地址","VARCHAR2(2000)",2000,0,false,false,false]
["FDDBR","法定代表人","VARCHAR2(200)",200,0,false,false,false]
["AQGLJG","安全管理机构","VARCHAR2(200)",200,0,false,false,false]
["AQFZ","安全副总","VARCHAR2(200)",200,0,false,false,false]
["GQGLJGFZRXM","安全管理机构负责人信息  姓名","VARCHAR2(200)",200,0,false,false,false]
["GQGLJGFZRZC","安全管理机构负责人信息  职称","VARCHAR2(200)",200,0,false,false,false]
["GQGLJGFZRLXDH","安全管理机构负责人信息  联系电话","VARCHAR2(20)",20,0,false,false,false]
["GQGLJGFZRDZYX","安全管理机构负责人信息  电子邮箱","VARCHAR2(200)",200,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_TIME","修改时间","TIMESTAMP",0,0,false,false,false]
["STATE","记录状态","CHAR",0,0,false,false,false]
["SFTB","是否同步 Y或者N","CHAR",0,0,false,false,false]
["TBZT","同步状态 已同步Y， 未同步N","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["QYLB","区域类别，省级还是市级","CHAR",0,0,false,false,false]
["SSQY","所属区域，关联组织架构表的主键","VARCHAR2(40)",40,0,false,false,false]
["ORG_CODE","所属组织","VARCHAR2(30)",30,0,false,false,false]
["BLBH",null,"VARCHAR2(100)",100,0,false,false,false]
["WXHWPM",null,"VARCHAR2(4000)",4000,0,false,false,false]
["ZYCS","作业场所","VARCHAR2(40)",40,0,false,false,false]
["CQ","产权","VARCHAR2(40)",40,0,false,false,false]
["ZYFS","作业方式","VARCHAR2(200)",200,0,false,false,false]
["WHDJ","危货等级","VARCHAR2(40)",40,0,false,false,false]
["ZYWXHWPM","作业危险货物品名","VARCHAR2(4000)",4000,0,false,false,false]
["BH","编号","VARCHAR2(2000)",2000,0,false,false,false]
["SQTBRQ","填报日期","TIMESTAMP",0,0,false,false,false]
["FZSJ","发证时间","TIMESTAMP",0,0,false,false,false]
["FZFZRQ","发证日期","TIMESTAMP",0,0,false,false,false]
["FZGKJYXKZH","港口经营许可证号","VARCHAR2(20)",20,0,false,false,false]
["FZZYCS","作业场所","VARCHAR2(20)",20,0,false,false,false]
["FZCSBH","附证场所编号","VARCHAR2(50)",50,0,false,false,false]
["FZQYNBBH","企业内部编号","VARCHAR2(20)",20,0,false,false,false]
["FZJG","发证机关","VARCHAR2(100)",100,0,false,false,false]
["YXQKSSJ","有效期开始时间","TIMESTAMP",0,0,false,false,false]
["YXQJSSJ","有效期结束时间","TIMESTAMP",0,0,false,false,false]
["QYNBBH","企业内部编号","VARCHAR2(50)",50,0,false,false,false]
["GKJYXKZ","港口经营许可证号","VARCHAR2(400)",400,0,false,false,false]
["JYR",null,"VARCHAR2(40)",40,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(2000)",2000,0,false,false,false]

{"sheet":"附证关联的子表记录","index":24,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_GKWXHWZYFZBLHHZZB"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["FZZY_ID",null,"VARCHAR2(40)",40,0,false,false,false]
["RYID",null,"VARCHAR2(40)",40,0,false,false,false]
["ZDID",null,"VARCHAR2(40)",40,0,false,false,false]
["SSID",null,"VARCHAR2(40)",40,0,false,false,false]
["YAID",null,"VARCHAR2(40)",40,0,false,false,false]
["SZD","所在地","VARCHAR2(40)",40,0,false,false,false]
["STATE","删除状态","CHAR",0,0,false,false,false]
["SFTB","是否同步 Y或者N","CHAR",0,0,false,false,false]
["TBZT","同步状态 已同步Y， 未同步N","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","VARCHAR2(40)",40,0,false,false,false]
["QYLB","区域类别，省级还是市级","CHAR",0,0,false,false,false]
["SSQY","所属区域，关联组织架构表的主键","VARCHAR2(40)",40,0,false,false,false]
["ORG_CODE",null,"VARCHAR2(30)",30,0,false,false,false]
["FLAG",null,"VARCHAR2(200)",200,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_TIME","修改时间","TIMESTAMP",0,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(2000)",2000,0,false,false,false]

{"sheet":"港口危险货物作业办理或换证申请表附证","index":25,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_GKWXHWZYFZBL_FZ"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["ZYCS","作业场所id","VARCHAR2(40)",40,0,false,false,false]
["FZCSBH","附证场所编号","VARCHAR2(100)",100,0,false,false,false]
["QYNBBH","企业内部编号","VARCHAR2(100)",100,0,false,false,false]
["FZZY_ID","附证申请id","VARCHAR2(40)",40,0,false,false,false]
["STATE",null,"CHAR",0,0,false,false,false]
["SFTB",null,"CHAR",0,0,false,false,false]
["TBZT",null,"CHAR",0,0,false,false,false]
["TBDYID",null,"VARCHAR2(40)",40,0,false,false,false]
["QYLB",null,"CHAR",0,0,false,false,false]
["SSQY",null,"VARCHAR2(40)",40,0,false,false,false]
["ORG_CODE",null,"VARCHAR2(30)",30,0,false,false,false]
["FZHZ","附证变更id","VARCHAR2(40)",40,0,false,false,false]
["QYNBMC",null,"VARCHAR2(100)",100,0,false,false,false]
["JYR","关联的经营人","VARCHAR2(40)",40,0,false,false,false]
["WXHWM","允许作业的危险货物品名","VARCHAR2(1000)",1000,0,false,false,false]
["WXHWM_BZ",null,"VARCHAR2(1000)",1000,0,false,false,false]
["SZD",null,"VARCHAR2(40)",40,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_TIME","修改时间","TIMESTAMP",0,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(2000)",2000,0,false,false,false]

{"sheet":"应急物资子表（应急设施分类信息）","index":26,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,1,0,7],[44,0,44,14],[45,0,45,14]]}
["实体名","AQ_YJWZ_FLXX"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","ID","VARCHAR2(40)",40,0,true,false,true]
["WZID","物资信息ID","VARCHAR2(40)",40,0,false,false,false]
["SSFL","所属分类","VARCHAR2(40)",40,0,false,false,false]
["WZFL","物资分类","VARCHAR2(40)",40,0,false,false,false]
["SSMC","设施名称","VARCHAR2(400)",400,0,false,false,false]
["SL","数量","NUMBER",0,0,false,false,false]
["GGXH","规格型号","VARCHAR2(50)",50,0,false,false,false]
["DJ","单价","NUMBER",0,0,false,false,false]
["SCCJ","生产厂家","VARCHAR2(50)",50,0,false,false,false]
["SYNX","使用年限","NUMBER",0,0,false,false,false]
["CCRQ","出厂日期","DATE",0,0,false,false,false]
["GMRQ","购买日期","DATE",0,0,false,false,false]
["GLDW","管理单位","VARCHAR2(50)",50,0,false,false,false]
["CFCS","存放场所","VARCHAR2(50)",50,0,false,false,false]
["SFTB","是否同步","CHAR",0,0,false,false,false]
["TBZT","同步状态","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","VARCHAR2(40)",40,0,false,false,false]
["QYLB","区域类别","CHAR",0,0,false,false,false]
["SSQY","所属区域","VARCHAR2(40)",40,0,false,false,false]
["STATE",null,"CHAR",0,0,false,false,false]
["ORG_CODE",null,"VARCHAR2(30)",30,0,false,false,false]
["ZYFZ_ID","作业附证id","VARCHAR2(40)",40,0,false,false,false]
["YXQ","有效期","TIMESTAMP",0,0,false,false,false]
["SLDW","数量单位","VARCHAR2(10)",10,0,false,false,false]
["BZ","备注","VARCHAR2(50)",50,0,false,false,false]
["GKDW","港口单位","VARCHAR2(40)",40,0,false,false,false]
["SZD",null,"VARCHAR2(40)",40,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_TIME","修改时间","TIMESTAMP",0,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(2000)",2000,0,false,false,false]
[]
[]
[]
[]
[]
[]
["1、目前系统中应急物资包括“港口经营人物资、单位物资、共建物资”，指南中应急物资仅港口经营人物资"]
["2、明细信息修改为“物资名称,物资储备点名称,物资储备点位置,物资类别,规格型号,物资数量,计量单位,技术状况,备注”"]

{"sheet":"附件表","index":27,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_FJB"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["WJM","文件名","VARCHAR2(400)",400,0,false,false,false]
["WJHZM","文件后缀名","VARCHAR2(400)",400,0,false,false,false]
["BZ","备注","VARCHAR2(1000)",1000,0,false,false,false]
["WJCFLJ","文件存放路径","VARCHAR2(4000)",4000,0,false,false,false]
["WJNR","文件内容","VARCHAR2(40)",40,0,false,false,false]
["WJDX","文件大小","NUMBER",0,0,false,false,false]
["SSID","所属ID","VARCHAR2(40)",40,0,false,false,false]
["ADD_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","修改时间","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","删除状态","NUMBER",0,0,false,false,false]
["TBZT","同步状态 已同步Y， 未同步N","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["SFTB","是否同步 Y或者N","CHAR",0,0,false,false,false]
["QYLB","区域类别，省级还是市级","CHAR",0,0,false,false,false]
["RECORD_CODE",null,"VARCHAR2(30)",30,0,false,false,false]
["BYZD1",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD2",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD3",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD4",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD5",null,"VARCHAR2(100)",100,0,false,false,false]
["SZD",null,"VARCHAR2(40)",40,0,false,false,false]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["SSLX",null,"VARCHAR2(200)",200,0,false,false,false]
["LX",null,"VARCHAR2(200)",200,0,false,false,false]
["SSQY",null,"VARCHAR2(200)",200,0,false,false,false]
["GQ",null,"VARCHAR2(200)",200,0,false,false,false]
[]
[]
[]
["yxd"]
["补充注释"]
["补充索引，如SSID"]

{"sheet":"经营人的人员信息","index":28,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,1,0,7],[49,0,49,6]]}
["实体名","AQ_DWXX_JYRDRYXX"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["XM","姓名","VARCHAR2(400)",400,0,false,false,false]
["XB","性别　男0　女1","CHAR",0,0,false,false,false]
["ZWHZC","职务或职称","VARCHAR2(400)",400,0,false,false,false]
["LXDH","联系电话","VARCHAR2(400)",400,0,false,false,false]
["SJHM","手机号码","VARCHAR2(400)",400,0,false,false,false]
["CSRQ","出生日期","DATE",0,0,false,false,false]
["SFKDL","是否可登陆 , 是0　否1","CHAR",0,0,false,false,false]
["SFTB","是否同步 Y或者N","CHAR",0,0,false,false,false]
["ADD_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","修改时间","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","删除状态","NUMBER",0,0,false,false,false]
["TBZT","同步状态 已同步Y， 未同步N","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["QYLB","区域类别，省级还是市级","CHAR",0,0,false,false,false]
["RECORD_CODE",null,"VARCHAR2(30)",30,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]
["SFZH","身份证号","VARCHAR2(30)",30,0,false,false,false]
["ZSMC","证书名称","VARCHAR2(100)",100,0,false,false,false]
["ZSBH","证书编号","VARCHAR2(100)",100,0,false,false,false]
["FZBM","发证部门","VARCHAR2(100)",100,0,false,false,false]
["YXQ","有效期","TIMESTAMP",0,0,false,false,false]
["BZ","备注","VARCHAR2(2000)",2000,0,false,false,false]
["SSJYR","港口经营人","VARCHAR2(40)",40,0,false,false,false]
["ZJLX",null,"VARCHAR2(40)",40,0,false,false,false]
["SZD",null,"VARCHAR2(40)",40,0,false,false,false]
["RYLX",null,"VARCHAR2(40)",40,0,false,false,false]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["SSQY","所属区域","VARCHAR2(40)",40,0,false,false,false]
["ZYFZ_ID","附证id","VARCHAR2(40)",40,0,false,false,false]
["ZSZL","证书种类","VARCHAR2(40)",40,0,false,false,false]
["SSGQ","所属港区","VARCHAR2(40)",40,0,false,false,false]
[]
[]
[]
[]
[]
["yxd"]
["1、联系电话改为移动电话，增加办公电话字段"]
["2、是否可登录删除"]
["3、增加学历、专业、是否获得危险化学品水路运输从业资格证、安全生产知识和管理能力考核情况"]
[]
["4、培训情况单独建表："]
["参加培训名称"]
["参加培训时间"]
["培训组织单位"]
["培训内容"]

{"sheet":"人员情况汇总表子表——证书表","index":29,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_DWXX_RYZSB"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["RYID","身份证号","VARCHAR2(40)",40,0,false,false,false]
["ZSMC","证书名称","VARCHAR2(100)",100,0,false,false,false]
["ZSZL","证书种类","VARCHAR2(40)",40,0,false,false,false]
["ZSBH","证书编号","VARCHAR2(40)",40,0,false,false,false]
["YXQ","有效期","DATE",0,0,false,false,false]
["BZ","备注","VARCHAR2(400)",400,0,false,false,false]
["ADD_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","修改时间","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","删除状态","NUMBER",0,0,false,false,false]
["SFTB","SFTB","CHAR",0,0,false,false,false]
["TBZT","TBZT","CHAR",0,0,false,false,false]
["TBDYID","TBDYID","NUMBER",0,0,false,false,false]
["QYLB","QYLB","CHAR",0,0,false,false,false]
["SSQY","SSQY","VARCHAR2(200)",200,0,false,false,false]
["RECORD_CODE","RECORD_CODE","VARCHAR2(30)",30,0,false,false,false]
["BYZD1","BYZD1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","BYZD2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","BYZD3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","BYZD4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","BYZD5","VARCHAR2(100)",100,0,false,false,false]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["SZD",null,"VARCHAR2(40)",40,0,false,false,false]
["ZSNR","证书内容（关联的大字段表的id）","VARCHAR2(40)",40,0,false,false,false]
[]
[]
[]
["yxd"]
["1、ryid应该是人员表的ID，不是身份证号"]
["2、证书种类改为证书类型：1-装卸管理人员；2-申报人员；3-集装箱装箱现场检查员"]
["3、增加“证书颁发机构”varchar2（100）"]
["4、有效期改为“有效期至”YYYYMMDD，含义明确"]

{"sheet":"经营人基础信息","index":30,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,1,0,7],[66,0,66,12]]}
["实体名","AQ_DWXX_JYRJCXX"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","ID","VARCHAR2(40)",40,0,true,false,true]
["SZD","所在地","VARCHAR2(200)",200,0,false,false,false]
["GKJYR","港口经营人名称","VARCHAR2(200)",200,0,false,false,false]
["QYXZ","企业性质","VARCHAR2(20)",20,0,false,false,false]
["YZBM","邮政编码","VARCHAR2(400)",400,0,false,false,false]
["BGDZ","办公地址","VARCHAR2(1000)",1000,0,false,false,false]
["GKJYXKZH","港口经营许可证号","VARCHAR2(400)",400,0,false,false,false]
["FZRQ","发证日期","TIMESTAMP",0,0,false,false,false]
["FZJG","发证机关","VARCHAR2(400)",400,0,false,false,false]
["JYFW","经营范围","VARCHAR2(4000)",4000,0,false,false,false]
["JYQY","经营区域","VARCHAR2(2000)",2000,0,false,false,false]
["ZYHZ","主营货种","VARCHAR2(200)",200,0,false,false,false]
["FDDBR","法定代表人","VARCHAR2(400)",400,0,false,false,false]
["LXDH","联系电话","VARCHAR2(400)",400,0,false,false,false]
["CZ","传真","VARCHAR2(400)",400,0,false,false,false]
["AQBMFZR","安全部门负责人","VARCHAR2(400)",400,0,false,false,false]
["AQFZRLXDH","安全部门负责人联系电话","VARCHAR2(400)",400,0,false,false,false]
["AQFZRSJ","安全部门负责人手机","VARCHAR2(400)",400,0,false,false,false]
["GSYYZZBH","工商营业执照编号","VARCHAR2(400)",400,0,false,false,false]
["TZZE","投资总额","NUMBER",0,0,false,false,false]
["ZCZB","注册资本","NUMBER",0,0,false,false,false]
["GKWXHWZYFZBH","港口危险货物作业附证编号","VARCHAR2(400)",400,0,false,false,false]
["GKSSBAFHZSBH","港口设施保安符合证书编号\t 港口设施保安符合证书编号","VARCHAR2(400)",400,0,false,false,false]
["BAFZJG","保安符合证书发证机关","VARCHAR2(400)",400,0,false,false,false]
["BAFZRQ","保安符合证书发证日期","TIMESTAMP",0,0,false,false,false]
["BAYXQ","保安符合证书有效期至","TIMESTAMP",0,0,false,false,false]
["ZYWXHWPM","作业危险货物品名","VARCHAR2(2000)",2000,0,false,false,false]
["QYLB","区域类别","CHAR",0,0,false,false,false]
["RECORD_CODE","RECORD_CODE","VARCHAR2(30)",30,0,false,false,false]
["BYZD1","BYZD1","VARCHAR2(200)",200,0,false,false,false]
["BYZD2","BYZD2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","BYZD3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","BYZD4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","BYZD5","VARCHAR2(100)",100,0,false,false,false]
["SFWHQY","是否危货企业","CHAR",0,0,false,false,false]
["QYLX","企业类型","CHAR",0,0,false,false,false]
["FZYXQ","附证有效期","TIMESTAMP",0,0,false,false,false]
["QYZZJGDM","企业组织机构代码","VARCHAR2(50)",50,0,false,false,false]
["QYAQDJ","企业安全等级","CHAR",0,0,false,false,false]
["RS","人数","NUMBER",0,0,false,false,false]
["AQZGBM","安全主管部门","VARCHAR2(50)",50,0,false,false,false]
["AQGLJG","安全管理机构","VARCHAR2(50)",50,0,false,false,false]
["ZZAGRYSL","专职安管人员数量","NUMBER",0,0,false,false,false]
["ZCZE","资产总额","VARCHAR2(20)",20,0,false,false,false]
["XSJE","销售金额","VARCHAR2(20)",20,0,false,false,false]
["AQFZRZBDH","安全负责人值班电话","VARCHAR2(20)",20,0,false,false,false]
["GJJGDM","国际机构代码","VARCHAR2(20)",20,0,false,false,false]
["SFZDSP","是否自动审批","CHAR",0,0,false,false,true]
["CREATE_TIME","创建时间","TIMESTAMP(7)",7,0,false,false,false]
["UPDATE_TIME","插入时间","TIMESTAMP(7)",7,0,false,false,false]
["STATE","记录状态","CHAR(1 char)",1,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(40)",40,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(40)",40,0,false,false,false]
["SZGQ","所在港区","VARCHAR2(40)",40,0,false,false,false]
["SSQY","所在区域","VARCHAR2(200)",200,0,false,false,false]
["SSHYDL","所属行业大类","VARCHAR2(200)",200,0,false,false,false]
["SSHYZ","所属行业中类","VARCHAR2(200)",200,0,false,false,false]
["PARENT_JYR_ID","上级港口经营人","VARCHAR2(200)",200,0,false,false,false]
["XZQH","行政区划","VARCHAR2(200)",200,0,false,false,false]
["LB","类别","VARCHAR2(200)",200,0,false,false,false]
["LBMC","类别名称","VARCHAR2(200)",200,0,false,false,false]
[]
[]
["yxd"]
["1、新增：所在地港口行政管理部门、统一社会信用代码、行业类别代码、港口经营人主要负责人姓名、主要负责人联系电话、港口经营人联系人姓名、电子邮箱、经济类型代码、职工总数"]
["2、去掉组织结构代码、工商营业执照编号、附证相关、经营许可证相关信息，从附证和经营许可证关联显示"]

{"sheet":"码头信息","index":31,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_DWXX_GQ_MT"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["MTMC","码头名称","VARCHAR2(100)",100,0,false,false,false]
["NHWTGNL","年货物通过能力","NUMBER",0,0,false,false,false]
["SJHWTTL","设计货物吞吐量","NUMBER",0,0,false,false,false]
["SJLKTTL","设计旅客吞吐量","NUMBER",0,0,false,false,false]
["NLKTGNL","年旅客通过能力","NUMBER",0,0,false,false,false]
["NJZXTGNL","年集装箱通过能力","NUMBER",0,0,false,false,false]
["MTSJQYSS","码头设计前沿水深","NUMBER",0,0,false,false,false]
["SNDTTL","上年度吞吐量","NUMBER",0,0,false,false,false]
["GISID","GISID","NUMBER",0,0,false,false,false]
["ZYHL","主要货类","VARCHAR2(17)",17,0,false,false,false]
["MTYT","码头用途","VARCHAR2(14)",14,0,false,false,false]
["ADD_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","修改时间","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","删除状态","NUMBER",0,0,false,false,false]
["SFTB","是否同步","CHAR",0,0,false,false,false]
["TBZT","同步状态","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["QYLB","区域类别","CHAR",0,0,false,false,false]
["SSQY","所属区域","VARCHAR2(200)",200,0,false,false,false]
["RECORD_CODE","RECORD_CODE","VARCHAR2(30)",30,0,false,false,false]
["BYZD1","BYZD1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","BYZD2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","BYZD3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","BYZD4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","BYZD5","VARCHAR2(100)",100,0,false,false,false]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["SZD",null,"VARCHAR2(40)",40,0,false,false,false]
["GQ",null,"VARCHAR2(40)",40,0,false,false,false]
["JYR",null,"VARCHAR2(40)",40,0,false,false,false]
[]
["yxd"]
["1、去掉gisid"]
["2、增加码头靠泊能力、码头形式代码、码头前沿实际测量水深"]

{"sheet":"港区","index":32,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_DWXX_GQ"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["SSGK","所属港口","VARCHAR2(200)",200,0,false,false,false]
["GQMC","港区名称","VARCHAR2(400)",400,0,false,false,false]
["GQSZSYLX","港区所在水域类型　字典表　沿海 河流 湖泊 水库","VARCHAR2(400)",400,0,false,false,false]
["GQMJ","港区面积(万平方米)","VARCHAR2(400)",400,0,false,false,false]
["LYMJ","陆域面积(万平方米)","VARCHAR2(400)",400,0,false,false,false]
["SYFW","水域范围","VARCHAR2(400)",400,0,false,false,false]
["SYMJ","水域面积(万平方米)","VARCHAR2(400)",400,0,false,false,false]
["GQGHMJ","港区规划面积(万平方米)","VARCHAR2(400)",400,0,false,false,false]
["GHLYMJ","规划陆域面积(万平方米)","VARCHAR2(400)",400,0,false,false,false]
["FGYSCYDGHMJ","非工业生产用地规划面积(万平方米)","VARCHAR2(400)",400,0,false,false,false]
["GHSYMJ","规划水域面积(万平方米)","VARCHAR2(400)",400,0,false,false,false]
["GQZRAXCD","港区自然岸线长度(米)","VARCHAR2(400)",400,0,false,false,false]
["GYMTAXCD","公用码头岸线长度(米)","VARCHAR2(400)",400,0,false,false,false]
["GQGKAXCD","港区港口岸线长度(米)","VARCHAR2(400)",400,0,false,false,false]
["GKSSYSYAXCD","港口设施已使用岸线长度(米)","VARCHAR2(400)",400,0,false,false,false]
["GQDMBDZDZ","港区地面坡度最大值","VARCHAR2(400)",400,0,false,false,false]
["BZ","备注","VARCHAR2(400)",400,0,false,false,false]
["ADD_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","修改时间","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","删除状态","NUMBER",0,0,false,false,false]
["SFTB","是否同步 Y或者N","CHAR",0,0,false,false,false]
["TBZT","同步状态 已同步Y， 未同步N","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["QYLB","区域类别，省级还是市级","CHAR",0,0,false,false,false]
["SSQY","所属区域，关联组织架构表的主键","VARCHAR2(200)",200,0,false,false,false]
["RECORD_CODE",null,"VARCHAR2(30)",30,0,false,false,false]
["BYZD1",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD2",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD3",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD4",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD5",null,"VARCHAR2(100)",100,0,false,false,false]
["SZSX",null,"NUMBER",0,0,false,false,false]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["SZD",null,"VARCHAR2(40)",40,0,false,false,false]

{"sheet":"港口设施设备","index":33,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_DWXX_GKSSSB"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["SSMC","设施名称","VARCHAR2(80)",80,0,false,false,false]
["QYMC","企业名称","VARCHAR2(40)",40,0,false,false,false]
["TBR","填表人","VARCHAR2(100)",100,0,false,false,false]
["LXDH","联系电话","VARCHAR2(40)",40,0,false,false,false]
["SZD","所在地","VARCHAR2(40)",40,0,false,false,false]
["SZGQ","所在港区","VARCHAR2(40)",40,0,false,false,false]
["GGXH","规格型号","VARCHAR2(100)",100,0,false,false,false]
["SL","数量","NUMBER",0,0,false,false,false]
["YXQ","有效期","DATE",0,0,false,false,false]
["CFCS","存放场所","VARCHAR2(4000)",4000,0,false,false,false]
["BZ","备注","VARCHAR2(4000)",4000,0,false,false,false]
["ADD_USER",null,"VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE",null,"TIMESTAMP",0,0,false,false,false]
["UPDATE_USER",null,"VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE",null,"TIMESTAMP",0,0,false,false,true]
["RECORD_STATUS",null,"NUMBER",0,0,false,false,false]
["SFTB",null,"CHAR",0,0,false,false,false]
["TBZT",null,"CHAR",0,0,false,false,false]
["TBDYID",null,"NUMBER",0,0,false,false,false]
["QYLB",null,"CHAR",0,0,false,false,false]
["SSQY",null,"VARCHAR2(200)",200,0,false,false,false]
["RECORD_CODE",null,"VARCHAR2(30)",30,0,false,false,false]
["BYZD1",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD2",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD3",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD4",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD5",null,"VARCHAR2(100)",100,0,false,false,false]
["SLDW","数量单位","VARCHAR2(10)",10,0,false,false,false]
["YJFL","一级分类","VARCHAR2(40)",40,0,false,false,false]
["EJFL","二级分类","VARCHAR2(40)",40,0,false,false,false]

{"sheet":"堆场","index":34,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":false,"merged":[[40,8,41,8],[40,9,41,9],[40,10,41,10],[0,1,0,7],[40,0,41,0],[40,1,41,1],[40,2,41,2],[40,5,41,5],[40,6,41,6],[40,7,41,7]]}
["实体名","AQ_DWXX_DC"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["SZD","所在地","VARCHAR2(100)",100,0,false,false,false]
["QYMC","企业名称","VARCHAR2(200)",200,0,false,false,false]
["DCMC","堆场名称","VARCHAR2(100)",100,0,false,false,false]
["SCYDCYT","堆场用途","VARCHAR2(100)",100,0,false,false,false]
["DCZMJ","堆场总面积（平方米）","NUMBER",0,0,false,false,false]
["DCZRL","堆场总容量（吨）","NUMBER",0,0,false,false,false]
["JZXMJ","集装箱堆场面积（平方米）","NUMBER",0,0,false,false,false]
["JZXDCDCNL","集装箱堆场堆存面积（平方米）","NUMBER",0,0,false,false,false]
["WXPXDCMJ","危险品堆场面积（平方米）","NUMBER",0,0,false,false,false]
["WXPXDCDCNL","危险品堆场堆存能力（TEU）","NUMBER",0,0,false,false,false]
["JD","经度","VARCHAR2(30)",30,0,false,false,false]
["WD","纬度","VARCHAR2(30)",30,0,false,false,false]
["JTJGISDYIDH","交通局GIS对应ID号","VARCHAR2(100)",100,0,false,false,false]
["ADD_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","修改时间","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","删除状态","NUMBER",0,0,false,false,false]
["SFTB","是否同步","CHAR",0,0,false,false,false]
["TBZT","同步状态","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["QYLB","区域类别","CHAR",0,0,false,false,false]
["RECORD_CODE","RECORD_CODE","VARCHAR2(30)",30,0,false,false,false]
["BYZD1","BYZD1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","BYZD2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","BYZD3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","BYZD4","VARCHAR2(100)",100,0,false,false,false]
["WXPDC","危险品堆场","CHAR",0,0,false,false,false]
["BYZD5","BYZD5","VARCHAR2(100)",100,0,false,false,false]
["ZWDCYT","堆场用途显示","VARCHAR2(200)",200,0,false,false,false]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["SZGQ",null,"VARCHAR2(40)",40,0,false,false,false]
["MTMC",null,"VARCHAR2(40)",40,0,false,false,false]
["SSQY",null,"VARCHAR2(40)",40,0,false,false,false]
[]
[]
["yxd"]
["参考下表修改数据项"]
["序号","指标名称","指标说明","指标","指标","值域","计量单位","指标约束","出现次数","引用","备注"]
[null,null,null,"类型","格式"]
[1,"港口经营人名称","堆场所属港口经营人的名称","字符型","an..100",null,null,"M","1..1","按照JT/T697.3的堆场仓库所属企业"]
[2,"堆场名称","堆场的名称或编号","字符型","an..100",null,null,"M","1..1","按照JT/T697.3的堆场名称"]
[3,"设计单位名称","堆场的设计单位名称","字符型","an..100",null,null,"O","0..1"]
[4,"设计单位资质","堆场的设计单位资质","字符型","an..1000",null,null,"O","0..1"]
[5,"设计存储的危险货物类别","堆场设计存储的危险货物类别","字符型","an..1000","按照3.5",null,"O","0..1"]
[6,"许可堆存的危险货物类别","堆场许可堆存的危险货物类别","字符型","an..1000","按照3.5",null,"M","1..n"]
[7,"堆场火灾危险性","堆场的火灾危险性描述","字符型","an..1000",null,null,"O","0..1"]
[8,"消防许可的火灾危险性","消防许可的火灾危险性描述","字符型","an..1000",null,null,"O","0..1"]
[9,"堆场位置类型","堆场所处的位置类型","字符型","n2","按照JT/T697.3中库场位置类型",null,"O","0..1"]
[10,"堆场用途代码","堆场的用途代码","字符型","n2","按照JT/T697.3中堆场用途代码",null,"M","1..1"]
[11,"堆场分类代码","堆场的分类代码","字符型","n2","按照JT/T697.3中堆场分类代码",null,"M","1..1"]
[12,"港口危险货物作业附证编号","堆场对应的港口危险货物作业附证编号","字符型","an..30",null,null,"M","1..1"]
[13,"危险货物苫盖方式","堆场危险货物苫盖方式","字符型","an..100",null,null,"O","0..n",null,"每个许可堆存的危险货物类别下的数据"]
[14,"危险货物包装方式","堆场危险货物包装方式","字符型","n1",null,null,"O","0..n","按照GB/T 15098","每个许可存储危险货物类别下的数据"]
[15,"堆场面积","堆场的面积","数值型","n..18",null,"㎡","M","1..1","按照JT/T697.3的堆场面积"]
[16,"堆场容量","堆场安全堆存货物的最大容量","数值型","n..18",null,"t","M","1..1","按照JT/T697.3的堆场容量"]
[17,"集装箱堆场堆存能力","集装箱堆场的最大堆存能力","数值型","n..18",null,"TEU","M","1..1","按照JT/T697.3的集装箱堆场堆存能力"]
[18,"投用时间","堆场投入使用的时间","日期型","YYYYMMDD",null,null,"M","1..1"]
[19,"备注","关于堆场其它情况说明","字符型","..ul",null,null,"O","0..1"]

{"sheet":"仓库信息","index":35,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[46,8,47,8],[46,9,47,9],[46,10,47,10],[0,1,0,7],[46,0,47,0],[46,1,47,1],[46,2,47,2],[46,5,47,5],[46,6,47,6],[46,7,47,7]]}
["实体名","AQ_DWXX_CK"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["SSJYR","所属经营人","VARCHAR2(200)",200,0,false,false,false]
["SZD","所在地(港口)","VARCHAR2(100)",100,0,false,false,false]
["QYMC","企业名称","VARCHAR2(200)",200,0,false,false,false]
["CKMC","仓库名称","VARCHAR2(200)",200,0,false,false,false]
["WXPCK","危险品仓库","VARCHAR2(1)",1,0,false,false,false]
["CKYT","仓库用途","VARCHAR2(7)",7,0,false,false,false]
["CKGS","仓库个数","NUMBER",0,0,false,false,false]
["YTHGCGRJ","液体化工储罐容积","NUMBER",0,0,false,false,false]
["SCYCKMJ","生产用仓库面积","NUMBER",0,0,false,false,false]
["WXPCKMJ","危险品仓库面积","NUMBER",0,0,false,false,false]
["SCYCKRJ","生产用仓库容积","NUMBER",0,0,false,false,false]
["YKRJ","油库容积","NUMBER",0,0,false,false,false]
["CPYRJ","成品油容积","NUMBER",0,0,false,false,false]
["JD","经度","VARCHAR2(20)",20,0,false,false,false]
["WD","纬度","VARCHAR2(20)",20,0,false,false,false]
["ADD_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","修改时间","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","删除状态","NUMBER",0,0,false,false,false]
["SFTB","是否同步","CHAR",0,0,false,false,false]
["TBZT","同步状态","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["QYLB","区域类别","CHAR",0,0,false,false,false]
["RECORD_CODE","RECORD_CODE","VARCHAR2(30)",30,0,false,false,false]
["BYZD1","BYZD1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","BYZD2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","BYZD3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","BYZD4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","BYZD5","VARCHAR2(100)",100,0,false,false,false]
["ZWCKYT","仓库用途显示","VARCHAR2(200)",200,0,false,false,false]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["GQ",null,"VARCHAR2(40)",40,0,false,false,false]
["MT",null,"VARCHAR2(40)",40,0,false,false,false]
["GISID",null,"VARCHAR2(40)",40,0,false,false,false]
["SSQY",null,"VARCHAR2(40)",40,0,false,false,false]
[]
[]
[]
[]
[]
[]
["yxd"]
["参考下面修改数据项"]
["序号","指标名称","指标说明","指标","指标","值域","计量单位","指标约束","出现次数","引用","备注"]
[null,null,null,"类型","格式"]
[1,"港口经营人名称","仓库所属的港口经营人的名称","字符型","an..100",null,null,"M","1..1"]
[2,"仓库名称","仓库的名称或编号","字符型","an..100",null,null,"M","1..1","按照JT/T697.3中的仓库名称"]
[3,"设计单位名称","仓库的设计单位名称","字符型","an..100",null,null,"O","0..1"]
[4,"设计单位资质","仓库的设计单位资质","字符型","an..1000",null,null,"O","0..1"]
[5,"设计存储的危险货物类别","仓库设计存储的危险货物类别","字符型","an..1000","按照3.5",null,"O","1..1"]
[6,"许可存储的危险货物类别","仓库许可存储的危险货物类别","字符型","an..1000","按照3.5",null,"M","1..n"]
[7,"仓库火灾危险性","仓库火灾危险性情况描述描述","字符型","an..1000",null,null,"O","0..1"]
[8,"消防许可的火灾危险性","消防许可的火灾危险性情况描述","字符型","an..1000",null,null,"O","0..1"]
[9,"仓库位置类型","仓库所处的位置类型","字符型","n2","按照JT/T697.3中库场位置类型",null,"O","0..1"]
[10,"仓库分类代码","仓库的分类代码","字符型","n2","按照JT/T697.3中仓库分类代码",null,"O","0..1"]
[11,"仓库用途代码","仓库的用途代码","字符型","n2","按照JT/T697.3中仓库用途代码",null,"O","0..1"]
[12,"作业附证编号","仓库对应的危险货物作业附证编号","字符型","an..30",null,null,"M","1..1"]
[13,"保管形态","仓库的保管货物的形态","字符型","an..30",null,null,"O","0..1"]
[14,"仓库建筑形式代码","仓库的建筑形式代码","字符型","n1","按照JT/T697.3中仓库建筑形式代码",null,"O","0..1"]
[15,"仓库结构形式代码","仓库的结构形式代码","字符型","n3","按照JT/T697.3中仓库结构形式代码",null,"O","0..1"]
[16,"仓库面积","仓库内部实际使用面积","数值型","n..18",null,"㎡","O","0..1","按照JT/T697.3中的仓库面积　"]
[17,"建筑面积","仓库的建筑面积","数值型","n..18",null,"㎡","O","0..1"]
[18,"仓库容积","仓库的最大容积","数值型","n..18",null,"m³","M","1..1"]
[19,"仓库容量","仓库的最大容量","数值型","n..18",null,"t","M","1..1","按照JT/T697.3中的库场容量　"]
[20,"危险货物包装方式","仓库存储危险货物的包装方式","字符型","n1",null,null,"O","0..n","按照GB/T 15098","每个许可存储的危险货物类别下的数据"]
[21,"投入使用时间","仓库投入使用的日期","日期型","YYYYMMDD",null,null,"M","1..1"]
[22,"检测周期","检测本仓库的周期","数值型","n..2",null,"月","M","1..1"]
[23,"上次检测时间","上次检测本仓库的日期","日期型","YYYYMMDD",null,null,"M","1..1"]
[24,"备注","关于仓库其它情况说明","字符型","..ul",null,null,"O","0..1"]

{"sheet":"储罐信息","index":36,"n_rows":118,"n_cols":11,"rows_kept":118,"cut":false,"hidden":false,"merged":[[82,8,83,8],[82,9,83,9],[82,10,83,10],[0,1,0,7],[82,0,83,0],[82,1,83,1],[82,2,83,2],[82,5,83,5],[82,6,83,6],[82,7,83,7]]}
["实体名","AQ_DWXX_CG"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["DWMC","单位名称","VARCHAR2(40)",40,0,false,false,false]
["WHZYFZBH","危货作业附证编号","VARCHAR2(4000)",4000,0,false,false,false]
["QYCCBH","企业存储编号","VARCHAR2(4000)",4000,0,false,false,false]
["SCJYHDLX","生产经营活动类型","VARCHAR2(10)",10,0,false,false,false]
["CCHXPPZSL","储存化学品品种数量","VARCHAR2(40)",40,0,false,false,false]
["ZXGYJZYSB","装卸工艺及主要设备","VARCHAR2(100)",100,0,false,false,false]
["CCCSCQ","储存场所产权","VARCHAR2(10)",10,0,false,false,false]
["GKZDWXYBH","港口重大危险源编号","VARCHAR2(40)",40,0,false,false,false]
["GKZDWXYBABH","港口重大危险源备案编号","VARCHAR2(40)",40,0,false,false,false]
["CGQMC","储罐区名称","VARCHAR2(40)",40,0,false,false,false]
["JTWZ","具体位置","VARCHAR2(40)",40,0,false,false,false]
["CGZB","储罐坐标","VARCHAR2(40)",40,0,false,false,false]
["CGQMJ","储罐区面积","NUMBER",0,0,false,false,false]
["CGGS","储罐个数","NUMBER",0,0,false,false,false]
["CGMC","储罐名称","VARCHAR2(40)",40,0,false,false,false]
["CGXH","储罐序号","VARCHAR2(40)",40,0,false,false,false]
["YWFHD","有无防护堤","VARCHAR2(40)",40,0,false,false,false]
["GJZXJL","罐间最小距离","NUMBER",0,0,false,false,false]
["CGCZ","储罐材质","VARCHAR2(40)",40,0,false,false,false]
["CGRJ","储罐容积","NUMBER",0,0,false,false,false]
["CGXS","储罐形式","VARCHAR2(10)",10,0,false,false,false]
["CGAZXS","储罐安装形式","VARCHAR2(10)",10,0,false,false,false]
["WZZT","物质状态","VARCHAR2(10)",10,0,false,false,false]
["CGWX","储罐外形","VARCHAR2(10)",10,0,false,false,false]
["SJYL","设计压力","NUMBER",0,0,false,false,false]
["SJGZYL","实际工作压力","NUMBER",0,0,false,false,false]
["SJWD","设计温度","VARCHAR2(50)",50,0,false,false,false]
["SJGZWD","实际工作温度","VARCHAR2(50)",50,0,false,false,false]
["TCSJ","投产时间","DATE",0,0,false,false,false]
["SJSYNX","设计使用年限","NUMBER",0,0,false,false,false]
["JLFS","进料方式","VARCHAR2(10)",10,0,false,false,false]
["CLFS","出料方式","VARCHAR2(10)",10,0,false,false,false]
["FJDSSSFNJJZS","防静电设施是否年检及证书","VARCHAR2(10)",10,0,false,false,false]
["ZSBH","证书编号","VARCHAR2(40)",40,0,false,false,false]
["TBR","填表人","VARCHAR2(100)",100,0,false,false,false]
["LXDH","联系电话","VARCHAR2(40)",40,0,false,false,false]
["TBSJ","填表时间","DATE",0,0,false,false,false]
["HYSL","火源数量","NUMBER",0,0,false,false,false]
["HYSM","火源说明","VARCHAR2(100)",100,0,false,false,false]
["BDZZSL","变电装置数量","NUMBER",0,0,false,false,false]
["BDZZSM","变电装置说明","VARCHAR2(100)",100,0,false,false,false]
["QTSL","其他数量","NUMBER",0,0,false,false,false]
["QTSM","其他说明","VARCHAR2(100)",100,0,false,false,false]
["HXPMC","化学品名称","VARCHAR2(2000)",2000,0,false,false,false]
["HXPPZ","化学品品种","VARCHAR2(40)",40,0,false,false,false]
["HXPSL","化学品数量","NUMBER",0,0,false,false,false]
["ADD_USER","ADD_USER","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","ADD_DATE","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","UPDATE_USER","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","UPDATE_DATE","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","RECORD_STATUS","NUMBER",0,0,false,false,false]
["SFTB","SFTB","CHAR",0,0,false,false,false]
["TBZT","TBZT","CHAR",0,0,false,false,false]
["TBDYID","TBDYID","NUMBER",0,0,false,false,false]
["QYLB","QYLB","CHAR",0,0,false,false,false]
["RECORD_CODE","RECORD_CODE","VARCHAR2(30)",30,0,false,false,false]
["BYZD1","BYZD1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","BYZD2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","BYZD3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","BYZD4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","BYZD5","VARCHAR2(100)",100,0,false,false,false]
["ZDWXYCGGS","重大危险源储罐个数","NUMBER",0,0,false,false,false]
["ZDWXYCGRL","重大危险源储罐容量","NUMBER",0,0,false,false,false]
["AQGD","安全高度（米）","NUMBER",0,0,false,false,false]
["ZJ","储罐直径（米）","NUMBER",0,0,false,false,false]
["WXYDJ","危险源等级","VARCHAR2(200)",200,0,false,false,false]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["MAPID",null,"VARCHAR2(40)",40,0,false,false,false]
["SSQY",null,"VARCHAR2(40)",40,0,false,false,false]
["SZD",null,"VARCHAR2(40)",40,0,false,false,false]
["GQ",null,"VARCHAR2(40)",40,0,false,false,false]
[]
[]
[]
[]
[]
[]
["yxd"]
["1、危货作业附证编号去掉，关联查询即可"]
["参考下表修改数据项"]
["序号","指标名称","指标说明","指标","指标","值域","计量单位","指标约束","出现次数","引用","备注"]
[null,null,null,"类型","格式"]
[1,"港口经营人名称","储罐所属港口经营人名称","字符型","an..100",null,null,"M","1..1"]
[2,"罐区名称","储罐所属罐区名称","字符型","an..100",null,null,"O","0..1"]
[3,"罐组名称","储罐所属罐组名称","字符型","an..100",null,null,"O","0..1"]
[4,"储罐名称","储罐的名称或编号","字符型","an..30",null,null,"M","1..1"]
[5,"许可储存介质","储罐许可储存介质类别","字符型","an..500","按照3.5",null,"M","1..n"]
[6,"港口危险货物作业附证编号","储罐的港口危险货物作业附证编号","字符型","an..30",null,null,"M","1..1"]
[7,"设计使用年限","储罐的设计使用年限","数值型","n..2",null,"年","M","1..1"]
[8,"设计单位名称","储罐的设计单位名称","字符型","an..100",null,null,"O","0..1"]
[9,"设计单位资质","储罐的设计单位资质","字符型","an..1000",null,null,"O","0..1"]
[10,"设计储存介质","储罐设计储存介质类别","字符型","an..500","按照3.5",null,"M","1..1"]
[11,"制造单位名称","储罐的制造单位名称","字符型","an..100",null,null,"O","0..1"]
[12,"制造单位资质","储罐的制造单位资质","字符型","an..1000",null,null,"O","0..1"]
[13,"制造日期","储罐的制造日期","日期型","YYYYMMDD",null,null,"O","0..1"]
[14,"安装单位名称","储罐的安装单位的名称","字符型","an..100",null,null,"O","0..1"]
[15,"安装单位资质","储罐的安装单位的资质","字符型","an..1000",null,null,"O","0..1"]
[16,"使用登记证编号","储罐的使用登记证编号","字符型","an..50",null,null,"O","0..1"]
[17,"储罐安装形式","储罐的安装形式分类","字符型","n1","1-地上储罐；2-半地上储罐；3-地下储罐",null,"O","0..1"]
[18,"储罐材料","储罐的材料分类","字符型","n1","1-金属储罐；2-非金属储罐",null,"O","0..1"]
[19,"储罐几何形式","储罐几何形式分类","字符型","n2","按照3.1",null,"O","0..1"]
[20,"储罐容积","储罐的最大容积","数值型","n..7",null,"立方米","M","1..1"]
[21,"公称直径","储罐罐体的公称直径","数值型","n..7,2",null,"米","O","0..1"]
[22,"设计压力","储罐设计最大承受压力","数值型","n..7,2",null,"兆帕","O","0..1"]
[23,"工作压力","储罐的当前工作压力","数值型","n..7,2",null,"兆帕","O","0..1"]
[24,"设计温度","储罐设计最大承受温度","数值型","n..2",null,"摄氏度","O","0..1"]
[25,"最高工作温度","储罐的实际最高工作温度","数值型","n..2",null,"摄氏度","O","0..1"]
[26,"设计液位","储罐的设计最高液位","数值型","n..7,2",null,"米","O","0..1"]
[27,"最高试验液位","储罐的最高试验液位","数值型","n..7,2",null,"米","O","0..1"]
[28,"投入使用日期","储罐的投入使用日期","日期型","YYYYMMDD",null,null,"O","0..1"]
[29,"检测周期","储罐的检测周期","数值型","n..2",null,"月","M","1..1"]
[30,"检测日期","储罐的检测日期","日期型","YYYYMMDD",null,null,"M","1..1",null,"30-33均为检测信息，可以有多组数据　　"]
[31,"检测单位名称","储罐的检测单位名称","字符型","an..100",null,null,"O","0..1"]
[32,"检测单位资质","储罐的检测单位的资质","字符型","an..1000",null,null,"O","0..1"]
[33,"储罐维护情况","储罐的储罐维护情况","字符型","..ul",null,null,"M","1..1"]
[34,"备注","关于储罐其它情况说明","字符型","..ul",null,null,"O","0..1"]

{"sheet":"泊位","index":37,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_DWXX_BW"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["SZD","所在地","VARCHAR2(200)",200,0,false,false,false]
["QYMC","企业名称","VARCHAR2(200)",200,0,false,false,false]
["BWMC","泊位名称","VARCHAR2(100)",100,0,false,false,false]
["TCNF","投产年份","NUMBER",0,0,false,false,false]
["JGYSNF","竣工验收年份","NUMBER",0,0,false,false,false]
["QYSJSH","前沿设计水深","VARCHAR2(100)",100,0,false,false,false]
["QYSJSS","前沿实际水深","VARCHAR2(100)",100,0,false,false,false]
["BWCD","泊位长度","VARCHAR2(100)",100,0,false,false,false]
["WXPBW","危险品泊位","CHAR",0,0,false,false,false]
["SJTGNL","设计通过能力","VARCHAR2(100)",100,0,false,false,false]
["SJKPNL","设计靠泊能力（吨级）","VARCHAR2(100)",100,0,false,false,false]
["NHWTGML","年货物通过能力","VARCHAR2(100)",100,0,false,false,false]
["NWXHWTTL","年危险货物吞吐量","VARCHAR2(100)",100,0,false,false,false]
["JD","经度","VARCHAR2(30)",30,0,false,false,false]
["WD","纬度","VARCHAR2(30)",30,0,false,false,false]
["SFFZ","是否发证","CHAR",0,0,false,false,false]
["BWYT","泊位用途","VARCHAR2(30)",30,0,false,false,false]
["ZYRKFW","作业认可范围","VARCHAR2(400)",400,0,false,false,false]
["ADD_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","修改时间","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","删除状态","NUMBER",0,0,false,false,false]
["SFTB","是否同步","CHAR",0,0,false,false,false]
["TBZT","同步状态","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["QYLB","区域类别","CHAR",0,0,false,false,false]
["RECORD_CODE","RECORD_CODE","VARCHAR2(30)",30,0,false,false,false]
["BYZD1","BYZD1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","BYZD2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","BYZD3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","BYZD4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5",null,"VARCHAR2(100)",100,0,false,false,false]
["JTJGISDYIDH",null,"VARCHAR2(30)",30,0,false,false,false]
["HCKPNL","核查靠泊能力","VARCHAR2(100)",100,0,false,false,false]
["ZWBWYT","泊位用途显示","VARCHAR2(250)",250,0,false,false,false]
["SMID","地图ID","VARCHAR2(32)",32,0,false,false,false]
["BWDM",null,"VARCHAR2(10)",10,0,false,false,false]
["JGXS2",null,"VARCHAR2(200)",200,0,false,false,false]
["ID","主键id","VARCHAR2(40)",40,0,false,false,false]
["SZGQ","所在港区","VARCHAR2(200)",200,0,false,false,false]
["MTMC","码头名称","VARCHAR2(200)",200,0,false,false,false]
["BWSX","泊位属性","VARCHAR2(200)",200,0,false,false,false]
["BWSZSX","泊位所在水系","VARCHAR2(200)",200,0,false,false,false]
["FWLX","服务类型","VARCHAR2(200)",200,0,false,false,false]
["JGXS","结构型式","VARCHAR2(200)",200,0,false,false,false]
["SCLX","生产类型","VARCHAR2(200)",200,0,false,false,false]
["ZYHBWFL","专业化泊位分类","VARCHAR2(200)",200,0,false,false,false]
["SSQY","所属区域","VARCHAR2(200)",200,0,false,false,false]
[]
["yxd"]
["1、增加泊位拥有形式代码，按照JT/T 697.3中的泊位拥有形式"]

{"sheet":"AQ_BASIC_FRAME_WF_PROP","index":38,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_FRAME_WF_PROP"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","ID","NUMBER",0,0,true,false,true]
["WF_KEY","流程主键","VARCHAR2(50)",50,0,false,false,false]
["WF_NAME","流程名称","VARCHAR2(50)",50,0,false,false,false]
["ACITIVTY","活动","VARCHAR2(50)",50,0,false,false,false]
["ACITIVTY_NAME","活动名称","VARCHAR2(100)",100,0,false,false,false]
["NAME","属性名称","VARCHAR2(100)",100,0,false,false,false]
["VALUE","属性值","VARCHAR2(100)",100,0,false,false,false]
["DISP","描述","VARCHAR2(200)",200,0,false,false,false]
["QYLB",null,"CHAR",0,0,false,false,false]
["SSQY",null,"NUMBER",0,0,false,false,false]
["BYZD1",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD2",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD3",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD4",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD5",null,"VARCHAR2(100)",100,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","更新时间","TIMESTAMP(0)",0,0,false,false,false]
["STATE","记录状态（无效：0，有效：1，过期：2）","CHAR",0,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(40)",40,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(40)",40,0,false,false,false]
[]
[]
["yxd"]
["确认无用后删除"]

{"sheet":"工作信息表","index":39,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_FRAME_TASK"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID",null,"VARCHAR2(40)",40,0,true,false,true]
["TASK_ID",null,"VARCHAR2(100)",100,0,false,false,false]
["BUS_ID",null,"VARCHAR2(100)",100,0,false,false,false]
["STEP",null,"VARCHAR2(10)",10,0,false,false,false]
["START_TIME",null,"TIMESTAMP",0,0,false,false,false]
["START_USER",null,"VARCHAR2(30)",30,0,false,false,false]
["CURR_NAME",null,"VARCHAR2(100)",100,0,false,false,false]
["RUNNER",null,"VARCHAR2(100)",100,0,false,false,false]
["RUN_TIME",null,"TIMESTAMP",0,0,false,false,false]
["AUDIT_TIME",null,"TIMESTAMP",0,0,false,false,false]
["AUDIT_MSG",null,"VARCHAR2(2000)",2000,0,false,false,false]
["AUDIT_RESULT",null,"VARCHAR2(100)",100,0,false,false,false]
["QYLB",null,"CHAR",0,0,false,false,false]
["SSQY",null,"NUMBER",0,0,false,false,false]
["BUS_KEY",null,"VARCHAR2(100)",100,0,false,false,false]
["AUDIT_USER",null,"VARCHAR2(100)",100,0,false,false,false]
["TASK_KEY",null,"VARCHAR2(100)",100,0,false,false,false]
["ROLE_CODE",null,"VARCHAR2(60)",60,0,false,false,false]
["AUDIT_USERNAME",null,"VARCHAR2(100)",100,0,false,false,false]
["SZD",null,"NUMBER",0,0,false,false,false]
["CREATE_TIME","创建时间","TIMESTAMP(0)",0,0,false,false,false]
["UPDATE_TIME","更新时间","TIMESTAMP(0)",0,0,false,false,false]
["CREATE_USER","创建人","VARCHAR2(40)",40,0,false,false,false]
["UPDATE_USER","更新人","VARCHAR2(40)",40,0,false,false,false]
["STATE","记录状态（无效：0，有效：1，过期：2）","CHAR",0,0,false,false,false]
["BYZD1","备用字段1","VARCHAR2(100)",100,0,false,false,false]
["BYZD2","备用字段2","VARCHAR2(100)",100,0,false,false,false]
["BYZD3","备用字段3","VARCHAR2(100)",100,0,false,false,false]
["BYZD4","备用字段4","VARCHAR2(100)",100,0,false,false,false]
["BYZD5","备用字段5","VARCHAR2(100)",100,0,false,false,false]

{"sheet":"AQ_BASIC_FRAME_IDENTITYLINK","index":40,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_FRAME_IDENTITYLINK"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID_",null,"NVARCHAR2(64)",64,0,true,false,true]
["REV_",null,"NUMBER",0,0,false,false,false]
["GROUP_ID_",null,"NVARCHAR2(255)",255,0,false,false,false]
["TYPE_",null,"NVARCHAR2(255)",255,0,false,false,false]
["USER_ID_",null,"NVARCHAR2(255)",255,0,false,false,false]
["TASK_ID_",null,"NVARCHAR2(64)",64,0,false,false,false]
["PROC_INST_ID_",null,"NVARCHAR2(64)",64,0,false,false,false]
["PROC_DEF_ID_",null,"NVARCHAR2(64)",64,0,false,false,false]
[]
[]
[]
[]
["yxd"]
["确认无用后删除"]

{"sheet":"危险物品名称","index":41,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["实体名","AQ_BASIC_DWXX_WXHWPMB"]
["名称","注释","类型","长度","精度","主键","外键","必填"]
["ID","ID","NUMBER",0,0,true,false,true]
["BH","编号","VARCHAR2(10)",10,0,false,false,false]
["MCHSM","名称和说明","VARCHAR2(200)",200,0,false,false,false]
["YWMC","英文名称","VARCHAR2(500)",500,0,false,false,false]
["LBHXB","类别和项别","VARCHAR2(100)",100,0,false,false,false]
["CYWXX","次要危险性","VARCHAR2(100)",100,0,false,false,false]
["BZLB","包装类别","VARCHAR2(50)",50,0,false,false,false]
["BZ","备注","VARCHAR2(200)",200,0,false,false,false]
["ADD_USER","创建人","VARCHAR2(50)",50,0,false,false,false]
["ADD_DATE","创建时间","TIMESTAMP",0,0,false,false,false]
["UPDATE_USER","修改人","VARCHAR2(50)",50,0,false,false,false]
["UPDATE_DATE","修改时间","TIMESTAMP",0,0,false,false,false]
["RECORD_STATUS","删除状态","VARCHAR2(10)",10,0,false,false,false]
["TBZT","同步状态 已同步Y， 未同步N","CHAR",0,0,false,false,false]
["TBDYID","同步对应ID","NUMBER",0,0,false,false,false]
["QYLB","区域类别，省级还是市级","CHAR",0,0,false,false,false]
["SSQY","所属区域，关联组织架构表的主键","NUMBER",0,0,false,false,false]
["SFTB","是否同步 Y或者N","CHAR",0,0,false,false,false]
["RECORD_CODE",null,"VARCHAR2(30)",30,0,false,false,false]
["BYZD1",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD2",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD3",null,"VARCHAR2(200)",200,0,false,false,false]
["BYZD4",null,"VARCHAR2(100)",100,0,false,false,false]
["BYZD5",null,"VARCHAR2(100)",100,0,false,false,false]
["LHXZ","理化性质","VARCHAR2(512)",512,0,false,false,false]
["AQFFCS","防范措施","VARCHAR2(1000)",1000,0,false,false,false]
["SZD","SZD","NUMBER",0,0,false,false,false]
["HZWXX","火灾危险性","NUMBER",0,0,false,false,false]
["DXDJ","毒性等级","NUMBER",0,0,false,false,false]
["WRLB","污染类别","NUMBER",0,0,false,false,false]