{"text_format":"3","workbook":"xls","n_sheets":50,"sheets":["Cover","Change Tracking","List of sheets","Diagram","sys_area","sys_dict","sys_log","sys_mdict","sys_menu","sys_office","sys_role","sys_role_menu","sys_role_office","sys_user","sys_user_role","sys_area_parent_id","sys_area_parent_ids","sys_area_del_flag","sys_dict_value","sys_dict_label","sys_dict_del_flag","sys_log_create_by","sys_log_request_uri","sys_log_type","sys_log_create_date","sys_mdict_parent_id","sys_mdict_parent_ids","sys_mdict_del_flag","sys_menu_parent_id","sys_menu_parent_ids","sys_menu_del_flag","sys_office_parent_id","sys_office_parent_ids","sys_office_del_flag","sys_office_type","sys_role_del_flag","sys_role_enname","sys_user_office_id","sys_user_login_name","sys_user_company_id","sys_user_update_date","sys_user_del_flag","SEQ_sys_log_id","all attributes","Tables in no category","all tables","all indices","all sequences","all view","all trigger"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Cover","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[null,null,"Table definition book"]

{"sheet":"Change Tracking","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"flags":["formulas_cached_only"]}
["Change Tracking"]
[]
["DATE","Contents of change"]

{"sheet":"List of sheets","index":2,"n_rows":52,"n_cols":3,"rows_kept":52,"flags":["formulas_cached_only"]}
["List of sheets"]
[]
["Type","Name","Description"]
["Other","Cover",""]
["Other","Change Tracking",""]
["Other","sheet_index_template",""]
["Other","Diagram",""]
["Table","sys_area","区域表"]
["Table","sys_dict","字典表"]
["Table","sys_log","日志表"]
["Table","sys_mdict","多级字典表"]
["Table","sys_menu","菜单表"]
["Table","sys_office","部门表"]
["Table","sys_role","角色表"]
["Table","sys_role_menu","角色-菜单"]
["Table","sys_role_office","角色-机构"]
["Table","sys_user","用户表"]
["Table","sys_user_role","用户-角色"]
["Index","sys_area_parent_id",""]
["Index","sys_area_parent_ids",""]
["Index","sys_area_del_flag",""]
["Index","sys_dict_value",""]
["Index","sys_dict_label",""]
["Index","sys_dict_del_flag",""]
["Index","sys_log_create_by",""]
["Index","sys_log_request_uri",""]
["Index","sys_log_type",""]
["Index","sys_log_create_date",""]
["Index","sys_mdict_parent_id",""]
["Index","sys_mdict_parent_ids",""]
["Index","sys_mdict_del_flag",""]
["Index","sys_menu_parent_id",""]
["Index","sys_menu_parent_ids",""]
["Index","sys_menu_del_flag",""]
["Index","sys_office_parent_id",""]
["Index","sys_office_parent_ids",""]
["Index","sys_office_del_flag",""]
["Index","sys_office_type",""]
["Index","sys_role_del_flag",""]
["Index","sys_role_enname",""]
["Index","sys_user_office_id",""]
["Index","sys_user_login_name",""]
["Index","sys_user_company_id",""]
["Index","sys_user_update_date",""]
["Index","sys_user_del_flag",""]
["Sequence","SEQ_sys_log_id",""]
["List","all attributes",""]
["List","all tables",""]
["List","all indices",""]
["List","all sequences",""]
["List","all view",""]
["List","all trigger",""]

{"sheet":"Diagram","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"flags":["formulas_cached_only"]}
[]
[null,""]

{"sheet":"sys_area","index":4,"n_rows":65,"n_cols":13,"rows_kept":65,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[20,8,20,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","区域表"]
["Table name (physical name)","sys_area"]
["Description","区域表"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["区域编码","code","varchar2(n)",100,""," ","",""," ","","","","区域编码"]
["区域类型","type","char(n)",1,""," ","",""," ","","","","区域类型（1：国家；2：省份、直辖市；3：地市；4：区县）"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_area_parent_id","sys_area_parent_ids","sys_area_del_flag"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["code"]
["type"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_area_parent_id","sys_area_parent_ids","sys_area_del_flag"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["区域编码"]
["区域类型"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"sys_dict","index":5,"n_rows":65,"n_cols":13,"rows_kept":65,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[20,8,20,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","字典表"]
["Table name (physical name)","sys_dict"]
["Description","字典表"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["数据值","value","varchar2(n)",100,""," ","*",""," ","","","","数据值"]
["标签名","label","varchar2(n)",100,""," ","*",""," ","","","","标签名"]
["类型","type","varchar2(n)",100,""," ","*",""," ","","","","类型"]
["描述","description","nvarchar2(n)",100,""," ","*",""," ","","","","描述"]
["排序（升序）","sort","number(p,s)",10,0," ","*",""," ","","","","排序（升序）"]
["父级编号","parent_id","varchar2(n)",64,""," ","",""," ","","",0,"父级编号"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_dict_value","sys_dict_label","sys_dict_del_flag"]
["id"]
["value",1]
["label",null,1]
["type"]
["description"]
["sort"]
["parent_id"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_dict_value","sys_dict_label","sys_dict_del_flag"]
["编号"]
["数据值",1]
["标签名",null,1]
["类型"]
["描述"]
["排序（升序）"]
["父级编号"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"sys_log","index":6,"n_rows":56,"n_cols":13,"rows_kept":56,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[17,8,17,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","日志表"]
["Table name (physical name)","sys_log"]
["Description","日志表"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","*","","编号"]
["日志类型","type","char(n)",1,""," ","",""," ","","",1,"日志类型（1：接入日志；2：异常日志）"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["操作IP地址","remote_addr","varchar2(n)",255,""," ","",""," ","","","","操作IP地址"]
["用户代理","user_agent","varchar2(n)",255,""," ","",""," ","","","","用户代理"]
["请求URI","request_uri","varchar2(n)",255,""," ","",""," ","","","","请求URI"]
["操作方式","method","varchar2(n)",5,""," ","",""," ","","","","操作方式"]
["操作提交的数据","params","clob","",""," ","",""," ","","","","操作提交的数据"]
["异常信息","exception","clob","",""," ","",""," ","","","","异常信息"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_log_create_by","sys_log_request_uri","sys_log_type","sys_log_create_date"]
["id"]
["type",null,null,1]
["create_by",1]
["create_date",{"$nulls":3},1]
["remote_addr"]
["user_agent"]
["request_uri",null,1]
["method"]
["params"]
["exception"]
[]
[]
[null,"sys_log_create_by","sys_log_request_uri","sys_log_type","sys_log_create_date"]
["编号"]
["日志类型",null,null,1]
["创建者",1]
["创建时间",{"$nulls":3},1]
["操作IP地址"]
["用户代理"]
["请求URI",null,1]
["操作方式"]
["操作提交的数据"]
["异常信息"]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"sys_mdict","index":7,"n_rows":62,"n_cols":13,"rows_kept":62,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[19,8,19,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","多级字典表"]
["Table name (physical name)","sys_mdict"]
["Description","多级字典表"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["描述","description","nvarchar2(n)",100,""," ","",""," ","","","","描述"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_mdict_parent_id","sys_mdict_parent_ids","sys_mdict_del_flag"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["description"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_mdict_parent_id","sys_mdict_parent_ids","sys_mdict_del_flag"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["描述"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"sys_menu","index":8,"n_rows":74,"n_cols":13,"rows_kept":74,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[23,8,23,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","菜单表"]
["Table name (physical name)","sys_menu"]
["Description","菜单表"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["链接","href","varchar2(n)",2000,""," ","",""," ","","","","链接"]
["目标","target","varchar2(n)",20,""," ","",""," ","","","","目标（mainFrame、 _blank、_self、_parent、_top）"]
["图标","icon","varchar2(n)",100,""," ","",""," ","","","","图标"]
["是否在菜单中显示","is_show","char(n)",1,""," ","*",""," ","","","","是否在菜单中显示（1：显示；0：不显示）"]
["权限标识","permission","varchar2(n)",200,""," ","",""," ","","","","权限标识"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_menu_parent_id","sys_menu_parent_ids","sys_menu_del_flag"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["href"]
["target"]
["icon"]
["is_show"]
["permission"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_menu_parent_id","sys_menu_parent_ids","sys_menu_del_flag"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["链接"]
["目标"]
["图标"]
["是否在菜单中显示"]
["权限标识"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"sys_office","index":9,"n_rows":99,"n_cols":13,"rows_kept":99,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[31,8,31,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","机构表"]
["Table name (physical name)","sys_office"]
["Description","部门表"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["归属区域","area_id","varchar2(n)",64,""," ","*","","-> 区域表.编号","","","","归属区域"]
["区域编码","code","varchar2(n)",100,""," ","",""," ","","","","区域编码"]
["机构类型","type","char(n)",1,""," ","*",""," ","","","","机构类型（1：公司；2：部门；3：小组）"]
["机构等级","grade","char(n)",1,""," ","*",""," ","","","","机构等级（1：一级；2：二级；3：三级；4：四级）"]
["联系地址","address","nvarchar2(n)",255,""," ","",""," ","","","","联系地址"]
["邮政编码","zip_code","varchar2(n)",100,""," ","",""," ","","","","邮政编码"]
["负责人","master","nvarchar2(n)",100,""," ","",""," ","","","","负责人"]
["电话","phone","nvarchar2(n)",200,""," ","",""," ","","","","电话"]
["传真","fax","nvarchar2(n)",200,""," ","",""," ","","","","传真"]
["邮箱","email","nvarchar2(n)",200,""," ","",""," ","","","","邮箱"]
["是否启用","USEABLE","varchar2(n)",64,""," ","",""," ","","","",""]
["主负责人","PRIMARY_PERSON","varchar2(n)",64,""," ","",""," ","","","",""]
["副负责人","DEPUTY_PERSON","varchar2(n)",64,""," ","",""," ","","","",""]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_office_parent_id","sys_office_parent_ids","sys_office_del_flag","sys_office_type"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["area_id"]
["code"]
["type",{"$nulls":3},1]
["grade"]
["address"]
["zip_code"]
["master"]
["phone"]
["fax"]
["email"]
["USEABLE"]
["PRIMARY_PERSON"]
["DEPUTY_PERSON"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_office_parent_id","sys_office_parent_ids","sys_office_del_flag","sys_office_type"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["归属区域"]
["区域编码"]
["机构类型",{"$nulls":3},1]
["机构等级"]
["联系地址"]
["邮政编码"]
["负责人"]
["电话"]
["传真"]
["邮箱"]
["是否启用"]
["主负责人"]
["副负责人"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["归属区域","area_id","sys_area","id"]

{"sheet":"sys_role","index":10,"n_rows":68,"n_cols":13,"rows_kept":68,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[21,8,21,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","角色表"]
["Table name (physical name)","sys_role"]
["Description","角色表"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["归属机构","office_id","varchar2(n)",64,""," ","",""," ","","","","归属机构"]
["角色名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","角色名称"]
["英文名称","enname","varchar2(n)",255,""," ","",""," ","","","","英文名称"]
["角色类型","role_type","varchar2(n)",255,""," ","",""," ","","","","角色类型"]
["数据范围","data_scope","char(n)",1,""," ","",""," ","","","","数据范围（0：所有数据；1：所在公司及以下数据；2：所在公司数据；3：所在部门及以下数据；4：所在部门数据；8：仅本人数据；9：按明细设置）"]
["是否系统数据","is_sys","varchar2(n)",64,""," ","",""," ","","","",""]
["是否可用","useable","varchar2(n)",64,""," ","",""," ","","","",""]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_role_del_flag","sys_role_enname"]
["id"]
["office_id"]
["name"]
["enname",null,1]
["role_type"]
["data_scope"]
["is_sys"]
["useable"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"sys_role_del_flag","sys_role_enname"]
["编号"]
["归属机构"]
["角色名称"]
["英文名称",null,1]
["角色类型"]
["数据范围"]
["是否系统数据"]
["是否可用"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]

{"sheet":"sys_role_menu","index":11,"n_rows":30,"n_cols":13,"rows_kept":30,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[9,8,9,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","角色-菜单"]
["Table name (physical name)","sys_role_menu"]
["Description","角色-菜单"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","","角色编号"]
["菜单编号","menu_id","varchar2(n)",64,"","* ","*","","-> 菜单表.编号","","","","菜单编号"]
[]
[]
[]
[]
["INDEX"]
[]
[]
[]
[]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["角色编号","role_id","sys_role","id"]
["菜单编号","menu_id","sys_menu","id"]

{"sheet":"sys_role_office","index":12,"n_rows":30,"n_cols":13,"rows_kept":30,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[9,8,9,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","角色-机构"]
["Table name (physical name)","sys_role_office"]
["Description","角色-机构"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","","角色编号"]
["机构编号","office_id","varchar2(n)",64,"","* ","*","","-> 机构表.编号","","","","机构编号"]
[]
[]
[]
[]
["INDEX"]
[]
[]
[]
[]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["角色编号","role_id","sys_role","id"]
["机构编号","office_id","sys_office","id"]

{"sheet":"sys_user","index":13,"n_rows":91,"n_cols":13,"rows_kept":91,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[28,8,28,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","用户表"]
["Table name (physical name)","sys_user"]
["Description","用户表"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["归属公司","company_id","varchar2(n)",64,""," ","*","","-> 机构表.编号","","","","归属公司"]
["归属部门","office_id","varchar2(n)",64,""," ","*","","-> 机构表.编号","","","","归属部门"]
["登录名","login_name","varchar2(n)",100,""," ","*",""," ","","","","登录名"]
["密码","password","varchar2(n)",100,""," ","*",""," ","","","","密码"]
["工号","no","varchar2(n)",100,""," ","",""," ","","","","工号"]
["姓名","name","nvarchar2(n)",100,""," ","*",""," ","","","","姓名"]
["邮箱","email","nvarchar2(n)",200,""," ","",""," ","","","","邮箱"]
["电话","phone","varchar2(n)",200,""," ","",""," ","","","","电话"]
["手机","mobile","varchar2(n)",200,""," ","",""," ","","","","手机"]
["用户类型","user_type","char(n)",1,""," ","",""," ","","","","用户类型"]
["用户头像","photo","varchar2(n)",1000,""," ","",""," ","","","",""]
["最后登陆IP","login_ip","varchar2(n)",100,""," ","",""," ","","","","最后登陆IP"]
["最后登陆时间","login_date","timestamp","",""," ","",""," ","","","","最后登陆时间"]
["是否可登录","login_flag","varchar2(n)",64,""," ","",""," ","","","",""]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_user_office_id","sys_user_login_name","sys_user_company_id","sys_user_update_date","sys_user_del_flag"]
["id"]
["company_id",null,null,1]
["office_id",1]
["login_name",null,1]
["password"]
["no"]
["name"]
["email"]
["phone"]
["mobile"]
["user_type"]
["photo"]
["login_ip"]
["login_date"]
["login_flag"]
["create_by"]
["create_date"]
["update_by"]
["update_date",{"$nulls":3},1]
["remarks"]
["del_flag",{"$nulls":4},1]
[]
[]
[null,"sys_user_office_id","sys_user_login_name","sys_user_company_id","sys_user_update_date","sys_user_del_flag"]
["编号"]
["归属公司",null,null,1]
["归属部门",1]
["登录名",null,1]
["密码"]
["工号"]
["姓名"]
["邮箱"]
["电话"]
["手机"]
["用户类型"]
["用户头像"]
["最后登陆IP"]
["最后登陆时间"]
["是否可登录"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间",{"$nulls":3},1]
["备注信息"]
["删除标记",{"$nulls":4},1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["归属公司","company_id","sys_office","id"]
["归属部门","office_id","sys_office","id"]

{"sheet":"sys_user_role","index":14,"n_rows":30,"n_cols":13,"rows_kept":30,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[9,8,9,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)","用户-角色"]
["Table name (physical name)","sys_user_role"]
["Description","用户-角色"]
["Constraint",""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["用户编号","user_id","varchar2(n)",64,"","* ","*","","-> 用户表.编号","","","","用户编号"]
["角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","","角色编号"]
[]
[]
[]
[]
["INDEX"]
[]
[]
[]
[]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["用户编号","user_id","sys_user","id"]
["角色编号","role_id","sys_role","id"]

{"sheet":"sys_area_parent_id","index":15,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_area_parent_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_area"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"父级编号","parent_id"]

{"sheet":"sys_area_parent_ids","index":16,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_area_parent_ids"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_area"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"所有父级编号","parent_ids"]

{"sheet":"sys_area_del_flag","index":17,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_area_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_area"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"sys_dict_value","index":18,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_dict_value"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_dict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"数据值","value"]

{"sheet":"sys_dict_label","index":19,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_dict_label"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_dict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"标签名","label"]

{"sheet":"sys_dict_del_flag","index":20,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_dict_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_dict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"sys_log_create_by","index":21,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_log_create_by"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_log"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"创建者","create_by"]

{"sheet":"sys_log_request_uri","index":22,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_log_request_uri"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_log"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"请求URI","request_uri"]

{"sheet":"sys_log_type","index":23,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_log_type"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_log"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"日志类型","type"]

{"sheet":"sys_log_create_date","index":24,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_log_create_date"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_log"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"创建时间","create_date"]

{"sheet":"sys_mdict_parent_id","index":25,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_mdict_parent_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_mdict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"父级编号","parent_id"]

{"sheet":"sys_mdict_parent_ids","index":26,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_mdict_parent_ids"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_mdict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"所有父级编号","parent_ids"]

{"sheet":"sys_mdict_del_flag","index":27,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_mdict_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_mdict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"sys_menu_parent_id","index":28,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_menu_parent_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_menu"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"父级编号","parent_id"]

{"sheet":"sys_menu_parent_ids","index":29,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_menu_parent_ids"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_menu"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"所有父级编号","parent_ids"]

{"sheet":"sys_menu_del_flag","index":30,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_menu_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_menu"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"sys_office_parent_id","index":31,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_office_parent_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_office"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"父级编号","parent_id"]

{"sheet":"sys_office_parent_ids","index":32,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_office_parent_ids"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_office"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"所有父级编号","parent_ids"]

{"sheet":"sys_office_del_flag","index":33,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_office_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_office"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"sys_office_type","index":34,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_office_type"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_office"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"机构类型","type"]

{"sheet":"sys_role_del_flag","index":35,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_role_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_role"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"sys_role_enname","index":36,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_role_enname"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_role"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"英文名称","enname"]

{"sheet":"sys_user_office_id","index":37,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_user_office_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_user"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"归属部门","office_id"]

{"sheet":"sys_user_login_name","index":38,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_user_login_name"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_user"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"登录名","login_name"]

{"sheet":"sys_user_company_id","index":39,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_user_company_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_user"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"归属公司","company_id"]

{"sheet":"sys_user_update_date","index":40,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_user_update_date"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_user"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"更新时间","update_date"]

{"sheet":"sys_user_del_flag","index":41,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
["Index Name","sys_user_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_user"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"SEQ_sys_log_id","index":42,"n_rows":9,"n_cols":2,"rows_kept":9,"flags":["formulas_cached_only"]}
["Object Type","Sequence"]
["Sequence Name","SEQ_sys_log_id"]
["Description",""]
["Increment","1"]
["Min Value",""]
["Max Value",""]
["Start Value","1"]
["Cache",""]
["Cycle",""]

{"sheet":"all attributes","index":43,"n_rows":130,"n_cols":14,"rows_kept":130,"flags":["formulas_cached_only"]}
["Table name\n(logical name)","Table name\n(physical name)","Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK","Auto increment","Default value","Description"]
["区域表","sys_area","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["区域表","sys_area","父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","父级编号"]
["区域表","sys_area","所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","所有父级编号"]
["区域表","sys_area","名称","name","nvarchar2(n)",100,""," ","*",""," ","","","名称"]
["区域表","sys_area","排序","sort","number(p,s)",10,0," ","*",""," ","","","排序"]
["区域表","sys_area","区域编码","code","varchar2(n)",100,""," ","",""," ","","","区域编码"]
["区域表","sys_area","区域类型","type","char(n)",1,""," ","",""," ","","","区域类型（1：国家；2：省份、直辖市；3：地市；4：区县）"]
["区域表","sys_area","创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","创建者"]
["区域表","sys_area","创建时间","create_date","timestamp","",""," ","*",""," ","","","创建时间"]
["区域表","sys_area","更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","更新者"]
["区域表","sys_area","更新时间","update_date","timestamp","",""," ","*",""," ","","","更新时间"]
["区域表","sys_area","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["区域表","sys_area","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["字典表","sys_dict","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["字典表","sys_dict","数据值","value","varchar2(n)",100,""," ","*",""," ","","","数据值"]
["字典表","sys_dict","标签名","label","varchar2(n)",100,""," ","*",""," ","","","标签名"]
["字典表","sys_dict","类型","type","varchar2(n)",100,""," ","*",""," ","","","类型"]
["字典表","sys_dict","描述","description","nvarchar2(n)",100,""," ","*",""," ","","","描述"]
["字典表","sys_dict","排序（升序）","sort","number(p,s)",10,0," ","*",""," ","","","排序（升序）"]
["字典表","sys_dict","父级编号","parent_id","varchar2(n)",64,""," ","",""," ","",0,"父级编号"]
["字典表","sys_dict","创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","创建者"]
["字典表","sys_dict","创建时间","create_date","timestamp","",""," ","*",""," ","","","创建时间"]
["字典表","sys_dict","更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","更新者"]
["字典表","sys_dict","更新时间","update_date","timestamp","",""," ","*",""," ","","","更新时间"]
["字典表","sys_dict","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["字典表","sys_dict","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["日志表","sys_log","编号","id","varchar2(n)",64,"","* ","*",""," ","*","","编号"]
["日志表","sys_log","日志类型","type","char(n)",1,""," ","",""," ","",1,"日志类型（1：接入日志；2：异常日志）"]
["日志表","sys_log","创建者","create_by","varchar2(n)",64,""," ","",""," ","","","创建者"]
["日志表","sys_log","创建时间","create_date","timestamp","",""," ","",""," ","","","创建时间"]
["日志表","sys_log","操作IP地址","remote_addr","varchar2(n)",255,""," ","",""," ","","","操作IP地址"]
["日志表","sys_log","用户代理","user_agent","varchar2(n)",255,""," ","",""," ","","","用户代理"]
["日志表","sys_log","请求URI","request_uri","varchar2(n)",255,""," ","",""," ","","","请求URI"]
["日志表","sys_log","操作方式","method","varchar2(n)",5,""," ","",""," ","","","操作方式"]
["日志表","sys_log","操作提交的数据","params","clob","",""," ","",""," ","","","操作提交的数据"]
["日志表","sys_log","异常信息","exception","clob","",""," ","",""," ","","","异常信息"]
["多级字典表","sys_mdict","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["多级字典表","sys_mdict","父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","父级编号"]
["多级字典表","sys_mdict","所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","所有父级编号"]
["多级字典表","sys_mdict","名称","name","nvarchar2(n)",100,""," ","*",""," ","","","名称"]
["多级字典表","sys_mdict","排序","sort","number(p,s)",10,0," ","*",""," ","","","排序"]
["多级字典表","sys_mdict","描述","description","nvarchar2(n)",100,""," ","",""," ","","","描述"]
["多级字典表","sys_mdict","创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","创建者"]
["多级字典表","sys_mdict","创建时间","create_date","timestamp","",""," ","*",""," ","","","创建时间"]
["多级字典表","sys_mdict","更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","更新者"]
["多级字典表","sys_mdict","更新时间","update_date","timestamp","",""," ","*",""," ","","","更新时间"]
["多级字典表","sys_mdict","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["多级字典表","sys_mdict","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["菜单表","sys_menu","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["菜单表","sys_menu","父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","父级编号"]
["菜单表","sys_menu","所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","所有父级编号"]
["菜单表","sys_menu","名称","name","nvarchar2(n)",100,""," ","*",""," ","","","名称"]
["菜单表","sys_menu","排序","sort","number(p,s)",10,0," ","*",""," ","","","排序"]
["菜单表","sys_menu","链接","href","varchar2(n)",2000,""," ","",""," ","","","链接"]
["菜单表","sys_menu","目标","target","varchar2(n)",20,""," ","",""," ","","","目标（mainFrame、 _blank、_self、_parent、_top）"]
["菜单表","sys_menu","图标","icon","varchar2(n)",100,""," ","",""," ","","","图标"]
["菜单表","sys_menu","是否在菜单中显示","is_show","char(n)",1,""," ","*",""," ","","","是否在菜单中显示（1：显示；0：不显示）"]
["菜单表","sys_menu","权限标识","permission","varchar2(n)",200,""," ","",""," ","","","权限标识"]
["菜单表","sys_menu","创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","创建者"]
["菜单表","sys_menu","创建时间","create_date","timestamp","",""," ","*",""," ","","","创建时间"]
["菜单表","sys_menu","更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","更新者"]
["菜单表","sys_menu","更新时间","update_date","timestamp","",""," ","*",""," ","","","更新时间"]
["菜单表","sys_menu","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["菜单表","sys_menu","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["机构表","sys_office","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["机构表","sys_office","父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","父级编号"]
["机构表","sys_office","所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","所有父级编号"]
["机构表","sys_office","名称","name","nvarchar2(n)",100,""," ","*",""," ","","","名称"]
["机构表","sys_office","排序","sort","number(p,s)",10,0," ","*",""," ","","","排序"]
["机构表","sys_office","归属区域","area_id","varchar2(n)",64,""," ","*","","-> 区域表.编号","","","归属区域"]
["机构表","sys_office","区域编码","code","varchar2(n)",100,""," ","",""," ","","","区域编码"]
["机构表","sys_office","机构类型","type","char(n)",1,""," ","*",""," ","","","机构类型（1：公司；2：部门；3：小组）"]
["机构表","sys_office","机构等级","grade","char(n)",1,""," ","*",""," ","","","机构等级（1：一级；2：二级；3：三级；4：四级）"]
["机构表","sys_office","联系地址","address","nvarchar2(n)",255,""," ","",""," ","","","联系地址"]
["机构表","sys_office","邮政编码","zip_code","varchar2(n)",100,""," ","",""," ","","","邮政编码"]
["机构表","sys_office","负责人","master","nvarchar2(n)",100,""," ","",""," ","","","负责人"]
["机构表","sys_office","电话","phone","nvarchar2(n)",200,""," ","",""," ","","","电话"]
["机构表","sys_office","传真","fax","nvarchar2(n)",200,""," ","",""," ","","","传真"]
["机构表","sys_office","邮箱","email","nvarchar2(n)",200,""," ","",""," ","","","邮箱"]
["机构表","sys_office","是否启用","USEABLE","varchar2(n)",64,""," ","",""," ","","",""]
["机构表","sys_office","主负责人","PRIMARY_PERSON","varchar2(n)",64,""," ","",""," ","","",""]
["机构表","sys_office","副负责人","DEPUTY_PERSON","varchar2(n)",64,""," ","",""," ","","",""]
["机构表","sys_office","创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","创建者"]
["机构表","sys_office","创建时间","create_date","timestamp","",""," ","*",""," ","","","创建时间"]
["机构表","sys_office","更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","更新者"]
["机构表","sys_office","更新时间","update_date","timestamp","",""," ","*",""," ","","","更新时间"]
["机构表","sys_office","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["机构表","sys_office","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["角色表","sys_role","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["角色表","sys_role","归属机构","office_id","varchar2(n)",64,""," ","",""," ","","","归属机构"]
["角色表","sys_role","角色名称","name","nvarchar2(n)",100,""," ","*",""," ","","","角色名称"]
["角色表","sys_role","英文名称","enname","varchar2(n)",255,""," ","",""," ","","","英文名称"]
["角色表","sys_role","角色类型","role_type","varchar2(n)",255,""," ","",""," ","","","角色类型"]
["角色表","sys_role","数据范围","data_scope","char(n)",1,""," ","",""," ","","","数据范围（0：所有数据；1：所在公司及以下数据；2：所在公司数据；3：所在部门及以下数据；4：所在部门数据；8：仅本人数据；9：按明细设置）"]
["角色表","sys_role","是否系统数据","is_sys","varchar2(n)",64,""," ","",""," ","","",""]
["角色表","sys_role","是否可用","useable","varchar2(n)",64,""," ","",""," ","","",""]
["角色表","sys_role","创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","创建者"]
["角色表","sys_role","创建时间","create_date","timestamp","",""," ","*",""," ","","","创建时间"]
["角色表","sys_role","更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","更新者"]
["角色表","sys_role","更新时间","update_date","timestamp","",""," ","*",""," ","","","更新时间"]
["角色表","sys_role","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["角色表","sys_role","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["角色-菜单","sys_role_menu","角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","角色编号"]
["角色-菜单","sys_role_menu","菜单编号","menu_id","varchar2(n)",64,"","* ","*","","-> 菜单表.编号","","","菜单编号"]
["角色-机构","sys_role_office","角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","角色编号"]
["角色-机构","sys_role_office","机构编号","office_id","varchar2(n)",64,"","* ","*","","-> 机构表.编号","","","机构编号"]
["用户表","sys_user","编号","id","varchar2(n)",64,"","* ","*",""," ","","","编号"]
["用户表","sys_user","归属公司","company_id","varchar2(n)",64,""," ","*","","-> 机构表.编号","","","归属公司"]
["用户表","sys_user","归属部门","office_id","varchar2(n)",64,""," ","*","","-> 机构表.编号","","","归属部门"]
["用户表","sys_user","登录名","login_name","varchar2(n)",100,""," ","*",""," ","","","登录名"]
["用户表","sys_user","密码","password","varchar2(n)",100,""," ","*",""," ","","","密码"]
["用户表","sys_user","工号","no","varchar2(n)",100,""," ","",""," ","","","工号"]
["用户表","sys_user","姓名","name","nvarchar2(n)",100,""," ","*",""," ","","","姓名"]
["用户表","sys_user","邮箱","email","nvarchar2(n)",200,""," ","",""," ","","","邮箱"]
["用户表","sys_user","电话","phone","varchar2(n)",200,""," ","",""," ","","","电话"]
["用户表","sys_user","手机","mobile","varchar2(n)",200,""," ","",""," ","","","手机"]
["用户表","sys_user","用户类型","user_type","char(n)",1,""," ","",""," ","","","用户类型"]
["用户表","sys_user","用户头像","photo","varchar2(n)",1000,""," ","",""," ","","",""]
["用户表","sys_user","最后登陆IP","login_ip","varchar2(n)",100,""," ","",""," ","","","最后登陆IP"]
["用户表","sys_user","最后登陆时间","login_date","timestamp","",""," ","",""," ","","","最后登陆时间"]
["用户表","sys_user","是否可登录","login_flag","varchar2(n)",64,""," ","",""," ","","",""]
["用户表","sys_user","创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","创建者"]
["用户表","sys_user","创建时间","create_date","timestamp","",""," ","*",""," ","","","创建时间"]
["用户表","sys_user","更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","更新者"]
["用户表","sys_user","更新时间","update_date","timestamp","",""," ","*",""," ","","","更新时间"]
["用户表","sys_user","备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","备注信息"]
["用户表","sys_user","删除标记","del_flag","char(n)",1,""," ","*",""," ","",0,"删除标记（0：正常；1：删除）"]
["用户-角色","sys_user_role","用户编号","user_id","varchar2(n)",64,"","* ","*","","-> 用户表.编号","","","用户编号"]
["用户-角色","sys_user_role","角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","角色编号"]

{"sheet":"Tables in no category","index":44,"n_rows":720,"n_cols":13,"rows_kept":720,"merged":[[0,0,0,1],[0,2,0,12],[1,0,1,1],[1,2,1,12],[2,0,2,1],[2,2,2,12],[3,0,3,1],[3,2,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[20,8,20,9],[70,0,70,1],[70,2,70,12],[71,0,71,1],[71,2,71,12],[72,0,72,1],[72,2,72,12],[73,0,73,1],[73,2,73,12],[75,8,75,9],[76,8,76,9],[77,8,77,9],[78,8,78,9],[79,8,79,9],[80,8,80,9],[81,8,81,9],[82,8,82,9],[83,8,83,9],[84,8,84,9],[85,8,85,9],[86,8,86,9],[87,8,87,9],[88,8,88,9],[90,8,90,9],[140,0,140,1],[140,2,140,12],[141,0,141,1],[141,2,141,12],[142,0,142,1],[142,2,142,12],[143,0,143,1],[143,2,143,12],[145,8,145,9],[146,8,146,9],[147,8,147,9],[148,8,148,9],[149,8,149,9],[150,8,150,9],[151,8,151,9],[152,8,152,9],[153,8,153,9],[154,8,154,9],[155,8,155,9],[157,8,157,9],[201,0,201,1],[201,2,201,12],[202,0,202,1],[202,2,202,12],[203,0,203,1],[203,2,203,12],[204,0,204,1],[204,2,204,12],[206,8,206,9],[207,8,207,9],[208,8,208,9],[209,8,209,9],[210,8,210,9],[211,8,211,9],[212,8,212,9],[213,8,213,9],[214,8,214,9],[215,8,215,9],[216,8,216,9],[217,8,217,9],[218,8,218,9],[220,8,220,9],[268,0,268,1],[268,2,268,12],[269,0,269,1],[269,2,269,12],[270,0,270,1],[270,2,270,12],[271,0,271,1],[271,2,271,12],[273,8,273,9],[274,8,274,9],[275,8,275,9],[276,8,276,9],[277,8,277,9],[278,8,278,9],[279,8,279,9],[280,8,280,9],[281,8,281,9],[282,8,282,9],[283,8,283,9],[284,8,284,9],[285,8,285,9],[286,8,286,9],[287,8,287,9],[288,8,288,9],[289,8,289,9],[291,8,291,9],[347,0,347,1],[347,2,347,12],[348,0,348,1],[348,2,348,12],[349,0,349,1],[349,2,349,12],[350,0,350,1],[350,2,350,12],[352,8,352,9],[353,8,353,9],[354,8,354,9],[355,8,355,9],[356,8,356,9],[357,8,357,9],[358,8,358,9],[359,8,359,9],[360,8,360,9],[361,8,361,9],[362,8,362,9],[363,8,363,9],[364,8,364,9],[365,8,365,9],[366,8,366,9],[367,8,367,9],[368,8,368,9],[369,8,369,9],[370,8,370,9],[371,8,371,9],[372,8,372,9],[373,8,373,9],[374,8,374,9],[375,8,375,9],[376,8,376,9],[378,8,378,9],[451,0,451,1],[451,2,451,12],[452,0,452,1],[452,2,452,12],[453,0,453,1],[453,2,453,12],[454,0,454,1],[454,2,454,12],[456,8,456,9],[457,8,457,9],[458,8,458,9],[459,8,459,9],[460,8,460,9],[461,8,461,9],[462,8,462,9],[463,8,463,9],[464,8,464,9],[465,8,465,9],[466,8,466,9],[467,8,467,9],[468,8,468,9],[469,8,469,9],[470,8,470,9],[472,8,472,9],[524,0,524,1],[524,2,524,12],[525,0,525,1],[525,2,525,12],[526,0,526,1],[526,2,526,12],[527,0,527,1],[527,2,527,12],[529,8,529,9],[530,8,530,9],[531,8,531,9],[533,8,533,9],[559,0,559,1],[559,2,559,12],[560,0,560,1],[560,2,560,12],[561,0,561,1],[561,2,561,12],[562,0,562,1],[562,2,562,12],[564,8,564,9],[565,8,565,9],[566,8,566,9],[568,8,568,9],[594,0,594,1],[594,2,594,12],[595,0,595,1],[595,2,595,12],[596,0,596,1],[596,2,596,12],[597,0,597,1],[597,2,597,12],[599,8,599,9],[600,8,600,9],[601,8,601,9],[602,8,602,9],[603,8,603,9],[604,8,604,9],[605,8,605,9],[606,8,606,9],[607,8,607,9],[608,8,608,9],[609,8,609,9],[610,8,610,9],[611,8,611,9],[612,8,612,9],[613,8,613,9],[614,8,614,9],[615,8,615,9],[616,8,616,9],[617,8,617,9],[618,8,618,9],[619,8,619,9],[620,8,620,9],[622,8,622,9],[690,0,690,1],[690,2,690,12],[691,0,691,1],[691,2,691,12],[692,0,692,1],[692,2,692,12],[693,0,693,1],[693,2,693,12],[695,8,695,9],[696,8,696,9],[697,8,697,9],[699,8,699,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)",null,"区域表"]
["Table name (physical name)",null,"sys_area"]
["Description",null,"区域表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["区域编码","code","varchar2(n)",100,""," ","",""," ","","","","区域编码"]
["区域类型","type","char(n)",1,""," ","",""," ","","","","区域类型（1：国家；2：省份、直辖市；3：地市；4：区县）"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_area_parent_id","sys_area_parent_ids","sys_area_del_flag"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["code"]
["type"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_area_parent_id","sys_area_parent_ids","sys_area_del_flag"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["区域编码"]
["区域类型"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"字典表"]
["Table name (physical name)",null,"sys_dict"]
["Description",null,"字典表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["数据值","value","varchar2(n)",100,""," ","*",""," ","","","","数据值"]
["标签名","label","varchar2(n)",100,""," ","*",""," ","","","","标签名"]
["类型","type","varchar2(n)",100,""," ","*",""," ","","","","类型"]
["描述","description","nvarchar2(n)",100,""," ","*",""," ","","","","描述"]
["排序（升序）","sort","number(p,s)",10,0," ","*",""," ","","","","排序（升序）"]
["父级编号","parent_id","varchar2(n)",64,""," ","",""," ","","",0,"父级编号"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_dict_value","sys_dict_label","sys_dict_del_flag"]
["id"]
["value",1]
["label",null,1]
["type"]
["description"]
["sort"]
["parent_id"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_dict_value","sys_dict_label","sys_dict_del_flag"]
["编号"]
["数据值",1]
["标签名",null,1]
["类型"]
["描述"]
["排序（升序）"]
["父级编号"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"日志表"]
["Table name (physical name)",null,"sys_log"]
["Description",null,"日志表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","*","","编号"]
["日志类型","type","char(n)",1,""," ","",""," ","","",1,"日志类型（1：接入日志；2：异常日志）"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["操作IP地址","remote_addr","varchar2(n)",255,""," ","",""," ","","","","操作IP地址"]
["用户代理","user_agent","varchar2(n)",255,""," ","",""," ","","","","用户代理"]
["请求URI","request_uri","varchar2(n)",255,""," ","",""," ","","","","请求URI"]
["操作方式","method","varchar2(n)",5,""," ","",""," ","","","","操作方式"]
["操作提交的数据","params","clob","",""," ","",""," ","","","","操作提交的数据"]
["异常信息","exception","clob","",""," ","",""," ","","","","异常信息"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_log_create_by","sys_log_request_uri","sys_log_type","sys_log_create_date"]
["id"]
["type",null,null,1]
["create_by",1]
["create_date",{"$nulls":3},1]
["remote_addr"]
["user_agent"]
["request_uri",null,1]
["method"]
["params"]
["exception"]
[]
[]
[null,"sys_log_create_by","sys_log_request_uri","sys_log_type","sys_log_create_date"]
["编号"]
["日志类型",null,null,1]
["创建者",1]
["创建时间",{"$nulls":3},1]
["操作IP地址"]
["用户代理"]
["请求URI",null,1]
["操作方式"]
["操作提交的数据"]
["异常信息"]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"多级字典表"]
["Table name (physical name)",null,"sys_mdict"]
["Description",null,"多级字典表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["描述","description","nvarchar2(n)",100,""," ","",""," ","","","","描述"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_mdict_parent_id","sys_mdict_parent_ids","sys_mdict_del_flag"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["description"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_mdict_parent_id","sys_mdict_parent_ids","sys_mdict_del_flag"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["描述"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"菜单表"]
["Table name (physical name)",null,"sys_menu"]
["Description",null,"菜单表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["链接","href","varchar2(n)",2000,""," ","",""," ","","","","链接"]
["目标","target","varchar2(n)",20,""," ","",""," ","","","","目标（mainFrame、 _blank、_self、_parent、_top）"]
["图标","icon","varchar2(n)",100,""," ","",""," ","","","","图标"]
["是否在菜单中显示","is_show","char(n)",1,""," ","*",""," ","","","","是否在菜单中显示（1：显示；0：不显示）"]
["权限标识","permission","varchar2(n)",200,""," ","",""," ","","","","权限标识"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_menu_parent_id","sys_menu_parent_ids","sys_menu_del_flag"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["href"]
["target"]
["icon"]
["is_show"]
["permission"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_menu_parent_id","sys_menu_parent_ids","sys_menu_del_flag"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["链接"]
["目标"]
["图标"]
["是否在菜单中显示"]
["权限标识"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"机构表"]
["Table name (physical name)",null,"sys_office"]
["Description",null,"部门表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["归属区域","area_id","varchar2(n)",64,""," ","*","","-> 区域表.编号","","","","归属区域"]
["区域编码","code","varchar2(n)",100,""," ","",""," ","","","","区域编码"]
["机构类型","type","char(n)",1,""," ","*",""," ","","","","机构类型（1：公司；2：部门；3：小组）"]
["机构等级","grade","char(n)",1,""," ","*",""," ","","","","机构等级（1：一级；2：二级；3：三级；4：四级）"]
["联系地址","address","nvarchar2(n)",255,""," ","",""," ","","","","联系地址"]
["邮政编码","zip_code","varchar2(n)",100,""," ","",""," ","","","","邮政编码"]
["负责人","master","nvarchar2(n)",100,""," ","",""," ","","","","负责人"]
["电话","phone","nvarchar2(n)",200,""," ","",""," ","","","","电话"]
["传真","fax","nvarchar2(n)",200,""," ","",""," ","","","","传真"]
["邮箱","email","nvarchar2(n)",200,""," ","",""," ","","","","邮箱"]
["是否启用","USEABLE","varchar2(n)",64,""," ","",""," ","","","",""]
["主负责人","PRIMARY_PERSON","varchar2(n)",64,""," ","",""," ","","","",""]
["副负责人","DEPUTY_PERSON","varchar2(n)",64,""," ","",""," ","","","",""]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_office_parent_id","sys_office_parent_ids","sys_office_del_flag","sys_office_type"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["area_id"]
["code"]
["type",{"$nulls":3},1]
["grade"]
["address"]
["zip_code"]
["master"]
["phone"]
["fax"]
["email"]
["USEABLE"]
["PRIMARY_PERSON"]
["DEPUTY_PERSON"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_office_parent_id","sys_office_parent_ids","sys_office_del_flag","sys_office_type"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["归属区域"]
["区域编码"]
["机构类型",{"$nulls":3},1]
["机构等级"]
["联系地址"]
["邮政编码"]
["负责人"]
["电话"]
["传真"]
["邮箱"]
["是否启用"]
["主负责人"]
["副负责人"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["归属区域","area_id","sys_area","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"角色表"]
["Table name (physical name)",null,"sys_role"]
["Description",null,"角色表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["归属机构","office_id","varchar2(n)",64,""," ","",""," ","","","","归属机构"]
["角色名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","角色名称"]
["英文名称","enname","varchar2(n)",255,""," ","",""," ","","","","英文名称"]
["角色类型","role_type","varchar2(n)",255,""," ","",""," ","","","","角色类型"]
["数据范围","data_scope","char(n)",1,""," ","",""," ","","","","数据范围（0：所有数据；1：所在公司及以下数据；2：所在公司数据；3：所在部门及以下数据；4：所在部门数据；8：仅本人数据；9：按明细设置）"]
["是否系统数据","is_sys","varchar2(n)",64,""," ","",""," ","","","",""]
["是否可用","useable","varchar2(n)",64,""," ","",""," ","","","",""]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_role_del_flag","sys_role_enname"]
["id"]
["office_id"]
["name"]
["enname",null,1]
["role_type"]
["data_scope"]
["is_sys"]
["useable"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"sys_role_del_flag","sys_role_enname"]
["编号"]
["归属机构"]
["角色名称"]
["英文名称",null,1]
["角色类型"]
["数据范围"]
["是否系统数据"]
["是否可用"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"角色-菜单"]
["Table name (physical name)",null,"sys_role_menu"]
["Description",null,"角色-菜单"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","","角色编号"]
["菜单编号","menu_id","varchar2(n)",64,"","* ","*","","-> 菜单表.编号","","","","菜单编号"]
[]
[]
[]
[]
["INDEX"]
[]
[]
[]
[]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["角色编号","role_id","sys_role","id"]
["菜单编号","menu_id","sys_menu","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"角色-机构"]
["Table name (physical name)",null,"sys_role_office"]
["Description",null,"角色-机构"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","","角色编号"]
["机构编号","office_id","varchar2(n)",64,"","* ","*","","-> 机构表.编号","","","","机构编号"]
[]
[]
[]
[]
["INDEX"]
[]
[]
[]
[]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["角色编号","role_id","sys_role","id"]
["机构编号","office_id","sys_office","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"用户表"]
["Table name (physical name)",null,"sys_user"]
["Description",null,"用户表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["归属公司","company_id","varchar2(n)",64,""," ","*","","-> 机构表.编号","","","","归属公司"]
["归属部门","office_id","varchar2(n)",64,""," ","*","","-> 机构表.编号","","","","归属部门"]
["登录名","login_name","varchar2(n)",100,""," ","*",""," ","","","","登录名"]
["密码","password","varchar2(n)",100,""," ","*",""," ","","","","密码"]
["工号","no","varchar2(n)",100,""," ","",""," ","","","","工号"]
["姓名","name","nvarchar2(n)",100,""," ","*",""," ","","","","姓名"]
["邮箱","email","nvarchar2(n)",200,""," ","",""," ","","","","邮箱"]
["电话","phone","varchar2(n)",200,""," ","",""," ","","","","电话"]
["手机","mobile","varchar2(n)",200,""," ","",""," ","","","","手机"]
["用户类型","user_type","char(n)",1,""," ","",""," ","","","","用户类型"]
["用户头像","photo","varchar2(n)",1000,""," ","",""," ","","","",""]
["最后登陆IP","login_ip","varchar2(n)",100,""," ","",""," ","","","","最后登陆IP"]
["最后登陆时间","login_date","timestamp","",""," ","",""," ","","","","最后登陆时间"]
["是否可登录","login_flag","varchar2(n)",64,""," ","",""," ","","","",""]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_user_office_id","sys_user_login_name","sys_user_company_id","sys_user_update_date","sys_user_del_flag"]
["id"]
["company_id",null,null,1]
["office_id",1]
["login_name",null,1]
["password"]
["no"]
["name"]
["email"]
["phone"]
["mobile"]
["user_type"]
["photo"]
["login_ip"]
["login_date"]
["login_flag"]
["create_by"]
["create_date"]
["update_by"]
["update_date",{"$nulls":3},1]
["remarks"]
["del_flag",{"$nulls":4},1]
[]
[]
[null,"sys_user_office_id","sys_user_login_name","sys_user_company_id","sys_user_update_date","sys_user_del_flag"]
["编号"]
["归属公司",null,null,1]
["归属部门",1]
["登录名",null,1]
["密码"]
["工号"]
["姓名"]
["邮箱"]
["电话"]
["手机"]
["用户类型"]
["用户头像"]
["最后登陆IP"]
["最后登陆时间"]
["是否可登录"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间",{"$nulls":3},1]
["备注信息"]
["删除标记",{"$nulls":4},1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["归属公司","company_id","sys_office","id"]
["归属部门","office_id","sys_office","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"用户-角色"]
["Table name (physical name)",null,"sys_user_role"]
["Description",null,"用户-角色"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["用户编号","user_id","varchar2(n)",64,"","* ","*","","-> 用户表.编号","","","","用户编号"]
["角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","","角色编号"]
[]
[]
[]
[]
["INDEX"]
[]
[]
[]
[]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["用户编号","user_id","sys_user","id"]
["角色编号","role_id","sys_role","id"]

{"sheet":"all tables","index":45,"n_rows":720,"n_cols":13,"rows_kept":720,"merged":[[0,0,0,1],[0,2,0,12],[1,0,1,1],[1,2,1,12],[2,0,2,1],[2,2,2,12],[3,0,3,1],[3,2,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[20,8,20,9],[70,0,70,1],[70,2,70,12],[71,0,71,1],[71,2,71,12],[72,0,72,1],[72,2,72,12],[73,0,73,1],[73,2,73,12],[75,8,75,9],[76,8,76,9],[77,8,77,9],[78,8,78,9],[79,8,79,9],[80,8,80,9],[81,8,81,9],[82,8,82,9],[83,8,83,9],[84,8,84,9],[85,8,85,9],[86,8,86,9],[87,8,87,9],[88,8,88,9],[90,8,90,9],[140,0,140,1],[140,2,140,12],[141,0,141,1],[141,2,141,12],[142,0,142,1],[142,2,142,12],[143,0,143,1],[143,2,143,12],[145,8,145,9],[146,8,146,9],[147,8,147,9],[148,8,148,9],[149,8,149,9],[150,8,150,9],[151,8,151,9],[152,8,152,9],[153,8,153,9],[154,8,154,9],[155,8,155,9],[157,8,157,9],[201,0,201,1],[201,2,201,12],[202,0,202,1],[202,2,202,12],[203,0,203,1],[203,2,203,12],[204,0,204,1],[204,2,204,12],[206,8,206,9],[207,8,207,9],[208,8,208,9],[209,8,209,9],[210,8,210,9],[211,8,211,9],[212,8,212,9],[213,8,213,9],[214,8,214,9],[215,8,215,9],[216,8,216,9],[217,8,217,9],[218,8,218,9],[220,8,220,9],[268,0,268,1],[268,2,268,12],[269,0,269,1],[269,2,269,12],[270,0,270,1],[270,2,270,12],[271,0,271,1],[271,2,271,12],[273,8,273,9],[274,8,274,9],[275,8,275,9],[276,8,276,9],[277,8,277,9],[278,8,278,9],[279,8,279,9],[280,8,280,9],[281,8,281,9],[282,8,282,9],[283,8,283,9],[284,8,284,9],[285,8,285,9],[286,8,286,9],[287,8,287,9],[288,8,288,9],[289,8,289,9],[291,8,291,9],[347,0,347,1],[347,2,347,12],[348,0,348,1],[348,2,348,12],[349,0,349,1],[349,2,349,12],[350,0,350,1],[350,2,350,12],[352,8,352,9],[353,8,353,9],[354,8,354,9],[355,8,355,9],[356,8,356,9],[357,8,357,9],[358,8,358,9],[359,8,359,9],[360,8,360,9],[361,8,361,9],[362,8,362,9],[363,8,363,9],[364,8,364,9],[365,8,365,9],[366,8,366,9],[367,8,367,9],[368,8,368,9],[369,8,369,9],[370,8,370,9],[371,8,371,9],[372,8,372,9],[373,8,373,9],[374,8,374,9],[375,8,375,9],[376,8,376,9],[378,8,378,9],[451,0,451,1],[451,2,451,12],[452,0,452,1],[452,2,452,12],[453,0,453,1],[453,2,453,12],[454,0,454,1],[454,2,454,12],[456,8,456,9],[457,8,457,9],[458,8,458,9],[459,8,459,9],[460,8,460,9],[461,8,461,9],[462,8,462,9],[463,8,463,9],[464,8,464,9],[465,8,465,9],[466,8,466,9],[467,8,467,9],[468,8,468,9],[469,8,469,9],[470,8,470,9],[472,8,472,9],[524,0,524,1],[524,2,524,12],[525,0,525,1],[525,2,525,12],[526,0,526,1],[526,2,526,12],[527,0,527,1],[527,2,527,12],[529,8,529,9],[530,8,530,9],[531,8,531,9],[533,8,533,9],[559,0,559,1],[559,2,559,12],[560,0,560,1],[560,2,560,12],[561,0,561,1],[561,2,561,12],[562,0,562,1],[562,2,562,12],[564,8,564,9],[565,8,565,9],[566,8,566,9],[568,8,568,9],[594,0,594,1],[594,2,594,12],[595,0,595,1],[595,2,595,12],[596,0,596,1],[596,2,596,12],[597,0,597,1],[597,2,597,12],[599,8,599,9],[600,8,600,9],[601,8,601,9],[602,8,602,9],[603,8,603,9],[604,8,604,9],[605,8,605,9],[606,8,606,9],[607,8,607,9],[608,8,608,9],[609,8,609,9],[610,8,610,9],[611,8,611,9],[612,8,612,9],[613,8,613,9],[614,8,614,9],[615,8,615,9],[616,8,616,9],[617,8,617,9],[618,8,618,9],[619,8,619,9],[620,8,620,9],[622,8,622,9],[690,0,690,1],[690,2,690,12],[691,0,691,1],[691,2,691,12],[692,0,692,1],[692,2,692,12],[693,0,693,1],[693,2,693,12],[695,8,695,9],[696,8,696,9],[697,8,697,9],[699,8,699,9]],"flags":["formulas_cached_only"]}
["Table name (logical name)",null,"区域表"]
["Table name (physical name)",null,"sys_area"]
["Description",null,"区域表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["区域编码","code","varchar2(n)",100,""," ","",""," ","","","","区域编码"]
["区域类型","type","char(n)",1,""," ","",""," ","","","","区域类型（1：国家；2：省份、直辖市；3：地市；4：区县）"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_area_parent_id","sys_area_parent_ids","sys_area_del_flag"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["code"]
["type"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_area_parent_id","sys_area_parent_ids","sys_area_del_flag"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["区域编码"]
["区域类型"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"字典表"]
["Table name (physical name)",null,"sys_dict"]
["Description",null,"字典表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["数据值","value","varchar2(n)",100,""," ","*",""," ","","","","数据值"]
["标签名","label","varchar2(n)",100,""," ","*",""," ","","","","标签名"]
["类型","type","varchar2(n)",100,""," ","*",""," ","","","","类型"]
["描述","description","nvarchar2(n)",100,""," ","*",""," ","","","","描述"]
["排序（升序）","sort","number(p,s)",10,0," ","*",""," ","","","","排序（升序）"]
["父级编号","parent_id","varchar2(n)",64,""," ","",""," ","","",0,"父级编号"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_dict_value","sys_dict_label","sys_dict_del_flag"]
["id"]
["value",1]
["label",null,1]
["type"]
["description"]
["sort"]
["parent_id"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_dict_value","sys_dict_label","sys_dict_del_flag"]
["编号"]
["数据值",1]
["标签名",null,1]
["类型"]
["描述"]
["排序（升序）"]
["父级编号"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"日志表"]
["Table name (physical name)",null,"sys_log"]
["Description",null,"日志表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","*","","编号"]
["日志类型","type","char(n)",1,""," ","",""," ","","",1,"日志类型（1：接入日志；2：异常日志）"]
["创建者","create_by","varchar2(n)",64,""," ","",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","",""," ","","","","创建时间"]
["操作IP地址","remote_addr","varchar2(n)",255,""," ","",""," ","","","","操作IP地址"]
["用户代理","user_agent","varchar2(n)",255,""," ","",""," ","","","","用户代理"]
["请求URI","request_uri","varchar2(n)",255,""," ","",""," ","","","","请求URI"]
["操作方式","method","varchar2(n)",5,""," ","",""," ","","","","操作方式"]
["操作提交的数据","params","clob","",""," ","",""," ","","","","操作提交的数据"]
["异常信息","exception","clob","",""," ","",""," ","","","","异常信息"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_log_create_by","sys_log_request_uri","sys_log_type","sys_log_create_date"]
["id"]
["type",null,null,1]
["create_by",1]
["create_date",{"$nulls":3},1]
["remote_addr"]
["user_agent"]
["request_uri",null,1]
["method"]
["params"]
["exception"]
[]
[]
[null,"sys_log_create_by","sys_log_request_uri","sys_log_type","sys_log_create_date"]
["编号"]
["日志类型",null,null,1]
["创建者",1]
["创建时间",{"$nulls":3},1]
["操作IP地址"]
["用户代理"]
["请求URI",null,1]
["操作方式"]
["操作提交的数据"]
["异常信息"]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"多级字典表"]
["Table name (physical name)",null,"sys_mdict"]
["Description",null,"多级字典表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["描述","description","nvarchar2(n)",100,""," ","",""," ","","","","描述"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_mdict_parent_id","sys_mdict_parent_ids","sys_mdict_del_flag"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["description"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_mdict_parent_id","sys_mdict_parent_ids","sys_mdict_del_flag"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["描述"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"菜单表"]
["Table name (physical name)",null,"sys_menu"]
["Description",null,"菜单表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["链接","href","varchar2(n)",2000,""," ","",""," ","","","","链接"]
["目标","target","varchar2(n)",20,""," ","",""," ","","","","目标（mainFrame、 _blank、_self、_parent、_top）"]
["图标","icon","varchar2(n)",100,""," ","",""," ","","","","图标"]
["是否在菜单中显示","is_show","char(n)",1,""," ","*",""," ","","","","是否在菜单中显示（1：显示；0：不显示）"]
["权限标识","permission","varchar2(n)",200,""," ","",""," ","","","","权限标识"]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_menu_parent_id","sys_menu_parent_ids","sys_menu_del_flag"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["href"]
["target"]
["icon"]
["is_show"]
["permission"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_menu_parent_id","sys_menu_parent_ids","sys_menu_del_flag"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["链接"]
["目标"]
["图标"]
["是否在菜单中显示"]
["权限标识"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"机构表"]
["Table name (physical name)",null,"sys_office"]
["Description",null,"部门表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["父级编号","parent_id","varchar2(n)",64,""," ","*",""," ","","","","父级编号"]
["所有父级编号","parent_ids","varchar2(n)",2000,""," ","*",""," ","","","","所有父级编号"]
["名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","名称"]
["排序","sort","number(p,s)",10,0," ","*",""," ","","","","排序"]
["归属区域","area_id","varchar2(n)",64,""," ","*","","-> 区域表.编号","","","","归属区域"]
["区域编码","code","varchar2(n)",100,""," ","",""," ","","","","区域编码"]
["机构类型","type","char(n)",1,""," ","*",""," ","","","","机构类型（1：公司；2：部门；3：小组）"]
["机构等级","grade","char(n)",1,""," ","*",""," ","","","","机构等级（1：一级；2：二级；3：三级；4：四级）"]
["联系地址","address","nvarchar2(n)",255,""," ","",""," ","","","","联系地址"]
["邮政编码","zip_code","varchar2(n)",100,""," ","",""," ","","","","邮政编码"]
["负责人","master","nvarchar2(n)",100,""," ","",""," ","","","","负责人"]
["电话","phone","nvarchar2(n)",200,""," ","",""," ","","","","电话"]
["传真","fax","nvarchar2(n)",200,""," ","",""," ","","","","传真"]
["邮箱","email","nvarchar2(n)",200,""," ","",""," ","","","","邮箱"]
["是否启用","USEABLE","varchar2(n)",64,""," ","",""," ","","","",""]
["主负责人","PRIMARY_PERSON","varchar2(n)",64,""," ","",""," ","","","",""]
["副负责人","DEPUTY_PERSON","varchar2(n)",64,""," ","",""," ","","","",""]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_office_parent_id","sys_office_parent_ids","sys_office_del_flag","sys_office_type"]
["id"]
["parent_id",1]
["parent_ids",null,1]
["name"]
["sort"]
["area_id"]
["code"]
["type",{"$nulls":3},1]
["grade"]
["address"]
["zip_code"]
["master"]
["phone"]
["fax"]
["email"]
["USEABLE"]
["PRIMARY_PERSON"]
["DEPUTY_PERSON"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",null,null,1]
[]
[]
[null,"sys_office_parent_id","sys_office_parent_ids","sys_office_del_flag","sys_office_type"]
["编号"]
["父级编号",1]
["所有父级编号",null,1]
["名称"]
["排序"]
["归属区域"]
["区域编码"]
["机构类型",{"$nulls":3},1]
["机构等级"]
["联系地址"]
["邮政编码"]
["负责人"]
["电话"]
["传真"]
["邮箱"]
["是否启用"]
["主负责人"]
["副负责人"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",null,null,1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["归属区域","area_id","sys_area","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"角色表"]
["Table name (physical name)",null,"sys_role"]
["Description",null,"角色表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["归属机构","office_id","varchar2(n)",64,""," ","",""," ","","","","归属机构"]
["角色名称","name","nvarchar2(n)",100,""," ","*",""," ","","","","角色名称"]
["英文名称","enname","varchar2(n)",255,""," ","",""," ","","","","英文名称"]
["角色类型","role_type","varchar2(n)",255,""," ","",""," ","","","","角色类型"]
["数据范围","data_scope","char(n)",1,""," ","",""," ","","","","数据范围（0：所有数据；1：所在公司及以下数据；2：所在公司数据；3：所在部门及以下数据；4：所在部门数据；8：仅本人数据；9：按明细设置）"]
["是否系统数据","is_sys","varchar2(n)",64,""," ","",""," ","","","",""]
["是否可用","useable","varchar2(n)",64,""," ","",""," ","","","",""]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_role_del_flag","sys_role_enname"]
["id"]
["office_id"]
["name"]
["enname",null,1]
["role_type"]
["data_scope"]
["is_sys"]
["useable"]
["create_by"]
["create_date"]
["update_by"]
["update_date"]
["remarks"]
["del_flag",1]
[]
[]
[null,"sys_role_del_flag","sys_role_enname"]
["编号"]
["归属机构"]
["角色名称"]
["英文名称",null,1]
["角色类型"]
["数据范围"]
["是否系统数据"]
["是否可用"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间"]
["备注信息"]
["删除标记",1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"角色-菜单"]
["Table name (physical name)",null,"sys_role_menu"]
["Description",null,"角色-菜单"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","","角色编号"]
["菜单编号","menu_id","varchar2(n)",64,"","* ","*","","-> 菜单表.编号","","","","菜单编号"]
[]
[]
[]
[]
["INDEX"]
[]
[]
[]
[]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["角色编号","role_id","sys_role","id"]
["菜单编号","menu_id","sys_menu","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"角色-机构"]
["Table name (physical name)",null,"sys_role_office"]
["Description",null,"角色-机构"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","","角色编号"]
["机构编号","office_id","varchar2(n)",64,"","* ","*","","-> 机构表.编号","","","","机构编号"]
[]
[]
[]
[]
["INDEX"]
[]
[]
[]
[]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["角色编号","role_id","sys_role","id"]
["机构编号","office_id","sys_office","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"用户表"]
["Table name (physical name)",null,"sys_user"]
["Description",null,"用户表"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["编号","id","varchar2(n)",64,"","* ","*",""," ","","","","编号"]
["归属公司","company_id","varchar2(n)",64,""," ","*","","-> 机构表.编号","","","","归属公司"]
["归属部门","office_id","varchar2(n)",64,""," ","*","","-> 机构表.编号","","","","归属部门"]
["登录名","login_name","varchar2(n)",100,""," ","*",""," ","","","","登录名"]
["密码","password","varchar2(n)",100,""," ","*",""," ","","","","密码"]
["工号","no","varchar2(n)",100,""," ","",""," ","","","","工号"]
["姓名","name","nvarchar2(n)",100,""," ","*",""," ","","","","姓名"]
["邮箱","email","nvarchar2(n)",200,""," ","",""," ","","","","邮箱"]
["电话","phone","varchar2(n)",200,""," ","",""," ","","","","电话"]
["手机","mobile","varchar2(n)",200,""," ","",""," ","","","","手机"]
["用户类型","user_type","char(n)",1,""," ","",""," ","","","","用户类型"]
["用户头像","photo","varchar2(n)",1000,""," ","",""," ","","","",""]
["最后登陆IP","login_ip","varchar2(n)",100,""," ","",""," ","","","","最后登陆IP"]
["最后登陆时间","login_date","timestamp","",""," ","",""," ","","","","最后登陆时间"]
["是否可登录","login_flag","varchar2(n)",64,""," ","",""," ","","","",""]
["创建者","create_by","varchar2(n)",64,""," ","*",""," ","","","","创建者"]
["创建时间","create_date","timestamp","",""," ","*",""," ","","","","创建时间"]
["更新者","update_by","varchar2(n)",64,""," ","*",""," ","","","","更新者"]
["更新时间","update_date","timestamp","",""," ","*",""," ","","","","更新时间"]
["备注信息","remarks","nvarchar2(n)",255,""," ","",""," ","","","","备注信息"]
["删除标记","del_flag","char(n)",1,""," ","*",""," ","","",0,"删除标记（0：正常；1：删除）"]
[]
[]
[]
[]
["INDEX"]
[null,"sys_user_office_id","sys_user_login_name","sys_user_company_id","sys_user_update_date","sys_user_del_flag"]
["id"]
["company_id",null,null,1]
["office_id",1]
["login_name",null,1]
["password"]
["no"]
["name"]
["email"]
["phone"]
["mobile"]
["user_type"]
["photo"]
["login_ip"]
["login_date"]
["login_flag"]
["create_by"]
["create_date"]
["update_by"]
["update_date",{"$nulls":3},1]
["remarks"]
["del_flag",{"$nulls":4},1]
[]
[]
[null,"sys_user_office_id","sys_user_login_name","sys_user_company_id","sys_user_update_date","sys_user_del_flag"]
["编号"]
["归属公司",null,null,1]
["归属部门",1]
["登录名",null,1]
["密码"]
["工号"]
["姓名"]
["邮箱"]
["电话"]
["手机"]
["用户类型"]
["用户头像"]
["最后登陆IP"]
["最后登陆时间"]
["是否可登录"]
["创建者"]
["创建时间"]
["更新者"]
["更新时间",{"$nulls":3},1]
["备注信息"]
["删除标记",{"$nulls":4},1]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["归属公司","company_id","sys_office","id"]
["归属部门","office_id","sys_office","id"]
[]
[]
[]
[]
[]
["Table name (logical name)",null,"用户-角色"]
["Table name (physical name)",null,"sys_user_role"]
["Description",null,"用户-角色"]
["Constraint",null,""]
[]
["Column name\n(logical name)","Column name\n(physical name)","Type","Length","Decimal","PK","NOT NULL","UNIQUE","FK",null,"Auto increment","Default value","Description"]
["用户编号","user_id","varchar2(n)",64,"","* ","*","","-> 用户表.编号","","","","用户编号"]
["角色编号","role_id","varchar2(n)",64,"","* ","*","","-> 角色表.编号","","","","角色编号"]
[]
[]
[]
[]
["INDEX"]
[]
[]
[]
[]
[]
[]
["COMPLEX UNIQUE KEY"]
[]
[]
[]
[]
[]
[]
["FOREIGN KEY"]
["Column name\n(logical name)","Column name\n(physical name)","Reference Table","Reference Key"]
["用户编号","user_id","sys_user","id"]
["角色编号","role_id","sys_role","id"]

{"sheet":"all indices","index":46,"n_rows":348,"n_cols":3,"rows_kept":348,"merged":[[0,1,0,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[70,1,70,2],[71,1,71,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[93,1,93,2],[94,1,94,2],[95,1,95,2],[96,1,96,2],[97,1,97,2],[106,1,106,2],[107,1,107,2],[108,1,108,2],[109,1,109,2],[110,1,110,2],[119,1,119,2],[120,1,120,2],[121,1,121,2],[122,1,122,2],[123,1,123,2],[132,1,132,2],[133,1,133,2],[134,1,134,2],[135,1,135,2],[136,1,136,2],[145,1,145,2],[146,1,146,2],[147,1,147,2],[148,1,148,2],[149,1,149,2],[158,1,158,2],[159,1,159,2],[160,1,160,2],[161,1,161,2],[162,1,162,2],[171,1,171,2],[172,1,172,2],[173,1,173,2],[174,1,174,2],[175,1,175,2],[184,1,184,2],[185,1,185,2],[186,1,186,2],[187,1,187,2],[188,1,188,2],[197,1,197,2],[198,1,198,2],[199,1,199,2],[200,1,200,2],[201,1,201,2],[210,1,210,2],[211,1,211,2],[212,1,212,2],[213,1,213,2],[214,1,214,2],[223,1,223,2],[224,1,224,2],[225,1,225,2],[226,1,226,2],[227,1,227,2],[236,1,236,2],[237,1,237,2],[238,1,238,2],[239,1,239,2],[240,1,240,2],[249,1,249,2],[250,1,250,2],[251,1,251,2],[252,1,252,2],[253,1,253,2],[262,1,262,2],[263,1,263,2],[264,1,264,2],[265,1,265,2],[266,1,266,2],[275,1,275,2],[276,1,276,2],[277,1,277,2],[278,1,278,2],[279,1,279,2],[288,1,288,2],[289,1,289,2],[290,1,290,2],[291,1,291,2],[292,1,292,2],[301,1,301,2],[302,1,302,2],[303,1,303,2],[304,1,304,2],[305,1,305,2],[314,1,314,2],[315,1,315,2],[316,1,316,2],[317,1,317,2],[318,1,318,2],[327,1,327,2],[328,1,328,2],[329,1,329,2],[330,1,330,2],[331,1,331,2],[340,1,340,2],[341,1,341,2],[342,1,342,2],[343,1,343,2],[344,1,344,2]],"flags":["formulas_cached_only"]}
["Object Type","Index"]
[]
["Index Name","sys_area_parent_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_area"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"父级编号","parent_id"]
[]
[]
[]
[]
[]
["Index Name","sys_area_parent_ids"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_area"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"所有父级编号","parent_ids"]
[]
[]
[]
[]
[]
["Index Name","sys_area_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_area"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","sys_dict_value"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_dict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"数据值","value"]
[]
[]
[]
[]
[]
["Index Name","sys_dict_label"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_dict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"标签名","label"]
[]
[]
[]
[]
[]
["Index Name","sys_dict_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_dict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","sys_log_create_by"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_log"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"创建者","create_by"]
[]
[]
[]
[]
[]
["Index Name","sys_log_request_uri"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_log"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"请求URI","request_uri"]
[]
[]
[]
[]
[]
["Index Name","sys_log_type"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_log"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"日志类型","type"]
[]
[]
[]
[]
[]
["Index Name","sys_log_create_date"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_log"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"创建时间","create_date"]
[]
[]
[]
[]
[]
["Index Name","sys_mdict_parent_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_mdict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"父级编号","parent_id"]
[]
[]
[]
[]
[]
["Index Name","sys_mdict_parent_ids"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_mdict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"所有父级编号","parent_ids"]
[]
[]
[]
[]
[]
["Index Name","sys_mdict_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_mdict"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","sys_menu_parent_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_menu"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"父级编号","parent_id"]
[]
[]
[]
[]
[]
["Index Name","sys_menu_parent_ids"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_menu"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"所有父级编号","parent_ids"]
[]
[]
[]
[]
[]
["Index Name","sys_menu_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_menu"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","sys_office_parent_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_office"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"父级编号","parent_id"]
[]
[]
[]
[]
[]
["Index Name","sys_office_parent_ids"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_office"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"所有父级编号","parent_ids"]
[]
[]
[]
[]
[]
["Index Name","sys_office_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_office"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","sys_office_type"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_office"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"机构类型","type"]
[]
[]
[]
[]
[]
["Index Name","sys_role_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_role"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]
[]
[]
[]
[]
[]
["Index Name","sys_role_enname"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_role"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"英文名称","enname"]
[]
[]
[]
[]
[]
["Index Name","sys_user_office_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_user"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"归属部门","office_id"]
[]
[]
[]
[]
[]
["Index Name","sys_user_login_name"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_user"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"登录名","login_name"]
[]
[]
[]
[]
[]
["Index Name","sys_user_company_id"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_user"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"归属公司","company_id"]
[]
[]
[]
[]
[]
["Index Name","sys_user_update_date"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_user"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"更新时间","update_date"]
[]
[]
[]
[]
[]
["Index Name","sys_user_del_flag"]
["Type",""]
["Unique",""]
["Description",""]
["Table Name","sys_user"]
[]
["Column Order","Column name (logical name)","Column name (physical name)"]
[1,"删除标记","del_flag"]

{"sheet":"all sequences","index":47,"n_rows":10,"n_cols":2,"rows_kept":10,"flags":["formulas_cached_only"]}
["Object Type","Sequence"]
[]
["Sequence Name","SEQ_sys_log_id"]
["Description",""]
["Increment","1"]
["Min Value",""]
["Max Value",""]
["Start Value","1"]
["Cache",""]
["Cycle",""]

{"sheet":"all view","index":48,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[0,1,0,12],[1,1,1,12],[2,1,2,12],[3,1,3,12],[5,8,5,9],[6,8,6,9],[7,8,7,9]],"flags":["formulas_cached_only"]}

{"sheet":"all trigger","index":49,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[0,1,0,11],[1,1,1,11],[2,1,2,11]],"flags":["formulas_cached_only"]}