true 100 A4 210 x 297 mm 30 30 30 30 0 1.0 2149 2154 128 128 192 255 255 255 Segoe UI 9 StandardSQL false 0 true 2 1 1 false true false false db\core.sql UTF-8 CR+LF false 7be191506f9daa8070b3ac14921dffd44063d2bb null true false true false true false false false false false false false false false false true false true false false null db\core.xls en true true true true true true db\core.png true true false 0 false false false -1 -1 Microsoft YaHei UI 9 50 50 255 255 255 false 2016-12-25 17:25:00 Project Name Model Name Version Company Author 7be191506f9daa8070b3ac14921dffd44063d2bb Default 666f23b96ed873b11a77ceca096cafe42631af5f 255 null false null false false false false 联系地址 联系地址 address varchar(n) 21ca6f52589f791a2ea859b73780a62c8cbebad8 100 null false null false false false false 区域编码 区域编码 area_code varchar(n) 20537c3bba575f25a12b27aad98fa1dc2fdff7a7 100 null false null false false false false 区域名称 区域名称 area_name nvarchar(n) 76ef00368999973a28221425b221bc4dd8c4b671 1 null false null false false false false 区域类型 区域类型 area_type character(n) a20282cd8e23adbbd4bbeda3ab214076e017ef91 200 null false null false false false false JAVA字段名 类的属性名 attr_name varchar(n) fdf9c3937f0215dcae1a58299485afde19ad799b 200 null false null false false false false JAVA字段类型 类的属性类型 attr_type varchar(n) c138ba567a58d48a0a7a6e7cb56d33c1dc38b17c 1000 null false null false false false false 头像 头像路径 avatar varchar(n) 667704664e4b88b145cebda0d6a1fbafb53525f0 64 null false null false false false false 业务主键 业务主键 biz_key varchar(n) 9c7b6cb6e8190ee30301f5046f6caceb0d9914d0 255 null false null false false false false 适应业务范围（不同的功能，不同的数据权限支持） biz_scope varchar(n) 4f9a5bc4fccb64cfc3a35f9209c9ce9bd044a6b9 64 null false null false false false false 业务类型 业务类型 biz_type varchar(n) b441f2f2ea527884a201789d79d7d08907eb97ac 100 null false null false false false false 浏览器名称 浏览器名称 browser_name varchar(n) ff1e0ad7d41ac61e908fc5656bdde67a164a6974 100 null false null false false false false 实体类名称 实体类名称 class_name varchar(n) 15ef7eb1eb6b56a4cefc4a85913d8d1d1bbe911a 50 null false null false false false false 列标签名 column_label nvarchar(n) 9add4a1f079cf3aa4d3da1da358d97f29d976c0d 64 null false null false false false false 列名 列名 column_name varchar(n) e8cd4d7657f8c37a71e34f28e71eea3df33bc82f 10 null false null false false false false 排序（升序） 列排序（升序） column_sort decimal(p) 8ed24661d9998b1972d3eb3f240c93991f1f12d2 100 null false null false false false false 类型 类型 column_type varchar(n) 6f68e29abaf597635078994b33a6f145325f25f6 500 null false null false false false false 列说明 列备注说明 comments nvarchar(n) 079f2c6d89277b4daecbd337e1bf4f781232976a 500 null false null false false false false 表说明 表说明 comments nvarchar(n) 8b9e1b544f371e8c2350ab8926707418a6ea8fdf 64 null false null false false false false 公司编码 公司编码 company_code varchar(n) f0f47249781a8c1e655ae11236426b788f099fce 200 null false null false false false false 公司名称 公司名称 company_name nvarchar(n) 261aca14bc2dd0bef97fa78a1256a95b5cb94171 1 null false null false false false false 是否并发执行 是否并发执行 concurrent character(n) 3bd475d905295b18837332926f66deacf286f563 100 null false null false false false false 参数键 参数键 config_key varchar(n) ee84723c8bde13d17589d3a0059e969a54af1a76 100 null false null false false false false 名称 名称 config_name nvarchar(n) a49b2ebdb0ca593f13c432eb28d1bbfe109c1421 1000 null false null false false false false 参数值 参数值 config_value nvarchar(n) a654ac8de54e8c19cfdba4bcf6d636ab760799b9 1 null false null false false false false 内容级别（1普通 2一般 3紧急） content_level character(n) 31410c3d884588423ca2a5803e78d0934412f458 1 null false null false false false false 内容类型(1公告 2新闻 3会议 4其它) 内容类型（1公告 2新闻 3会议 4其它） content_type character(n) 136ca02f1b3a96a8f2e242d5dd64d48f566143ef 64 null false null false false false false 租户代码 租户代码 corp_code varchar(n) f116706ac00cd3a3ee88b2a88debf7ebc3eeb12d 100 null false null false false false false 租户名称 租户名称 corp_name nvarchar(n) 1a3b3f8bccfce8894d117d6bdb0a6b104bfb80ef 64 null false null false false false false 创建者 create_by varchar(n) 03609a0dae154a21833b6bebb7110209336ffbbb 64 null false null false false false false 创建者 创建者 create_by varchar(n) aa74f5d673e427a2a45b14ea12e10f69ba9ed0ad 100 null false null false false false false 用户名称 用户名称 create_by_name nvarchar(n) dba1aec0c72d79ea73ed4ebde07696cf4df174b7 null null false null false false false false 创建时间 create_date datetime 03debcf1d4bf27cdad9acd24fda84a6ee9cdd908 255 null false null false false false false Cron执行表达式 Cron执行表达式 cron_expression varchar(n) 1f24bfd07483cf3e59f6ecbd4966755d9670df74 500 null false null false false false false css类名（如：red） css类名（如：red） css_class nvarchar(n) 1310f67a2772a72e48216c23deb7f7e7ef6f0041 500 null false null false false false false css样式（如：color:red) css样式（如：color:red) css_style nvarchar(n) 69bed3e42a9bbab83f7eb519e2786edc22260fd4 64 null false null false false false false 控制数据 ctrl_data varchar(n) 286b8f3e3671588da8693a150d1c611ff0634dcf 64 null false null false false false false 控制权限 ctrl_permi varchar(n) df33cf2fa1349df70c9c48ac3a90b92a146224ed 20 null false null false false false false H拥有的权限、M可管理的权限 控制类型 ctrl_type varchar(n) f1196b5a1e9072ac4cc990c913b774e777b09a46 50 null false null false false false false 当前版本 current_version varchar(n) 1b0f1b3a4e3073d84bc2c8406195d3eaa5276c19 1 null false null false false false false 数据范围设置（0未设置 1全部数据 2自定义数据） data_scope character(n) a9b040a1f3059a566ea241c3327fd8b328753c52 64 null false null false false false false 数据源名称 data_source_name varchar(n) 6cf6b1b94ad089cda04f9ed8ea2ad13bd9de0dd0 100 null false null false false false false 任务描述 任务描述 description nvarchar(n) b3d67ac6d9320b61db546035ec7c8e487fd8a9c4 500 null false null false false false false 字典描述 description nvarchar(n) f7114401c278a134ec74f1836c0f4afeed91cf0f 500 null false null false false false false 描述 模块描述 description nvarchar(n) 2fc82098d4733d740dba3a09a78f4917544b1251 100 null false null false false false false 设备名称/操作系统 设备名称/操作系统 device_name varchar(n) 32c7f5bb206f025610dd8211c6d397ee4845f3a3 64 null false null false false false false 字典编码 dict_code varchar(n) a4c755ab584ef5ca499f4e3412caa6d99305b36e 100 null false null false false false false 字典图标 dict_icon varchar(n) 9ca0e5536ea6174629b791183977dcc92c13f908 100 null false null false false false false 字典名 字典标签 dict_label nvarchar(n) 127ff1ab1747f2d85218814e7367474e78a29826 100 null false null false false false false 字典名称 dict_name nvarchar(n) cec894690e4c1517d172409b7da10408776930b2 100 null false null false false false false 用户字典类型 字典类型 dict_type varchar(n) cc294effb178877401baf60d266faff21b80c5ea 100 null false null false false false false 字典值 字典键值 dict_value varchar(n) ed5ac38bb6330b7ce8daaa76475ac87c6e1f7e4c null null false null false false false false 新旧数据比较结果 diff_modify_data clob 329bbb76f0884117ace79bb686695f4e9cb120b6 300 null false null false false false false 邮箱 电子邮箱 email varchar(n) 0eb719cd3d6524bc3778d73c3634c1b976baa3c7 64 null false null false false false false 员工编码 员工编码 emp_code varchar(n) 125f4be73b069fa39d11d391ebc30169bb835827 100 null false null false false false false 名称 员工姓名 emp_name nvarchar(n) 46d0f56aace23d853693d4e581e9904d463b8860 100 null false null false false false false 英文名 员工英文名 emp_name_en varchar(n) c3398bbf1c346a338db14449fcb9fa2f6c70f372 100 null false null false false false false 员工工号 emp_no nvarchar(n) d903f31236ff7a6701ff92a19986146ace84c236 null null false null false false false false 异常信息 异常信息 exception_info clob 510f647b2d9d95b636aa517b9826966d98962277 19 null false null false false false false 执行时间 execute_time decimal(p) f01926071736b56b898949cc0720149c71504324 null null false null false false false false 扩展 Date 1 extend_d1 datetime 942700093ab61c3be0bdf6b23bcba210bcc30281 null null false null false false false false 扩展 Date 2 extend_d2 datetime f221902bf89fe94dece8ccf309f59cc2c479d63f null null false null false false false false 扩展 Date 3 extend_d3 datetime c8d21e24bc69aac295703b0bae56269035b729f0 null null false null false false false false 扩展 Date 4 extend_d4 datetime 4c0cc4ae32f8774cc319f516784430204aef0bdb 19 4 false null false false false false 扩展 Float 1 extend_f1 decimal(p,s) 2e958c528620621985af4394590198feed57cdf9 19 4 false null false false false false 扩展 Float 2 extend_f2 decimal(p,s) 7c25ad75662553c7d4a58fa66eb50ca7c0ffee59 19 4 false null false false false false 扩展 Float 3 extend_f3 decimal(p,s) 1f81990c9694963f032c302d1834b972a6f2eb74 19 4 false null false false false false 扩展 Float 4 extend_f4 decimal(p,s) a1d747cd40768ac9f85176518ee48cb513bae110 19 null false null false false false false 扩展 Integer 1 extend_i1 decimal(p) a9f0e14d6691c397990abe4ef1ff21674dccf401 19 null false null false false false false 扩展 Integer 2 extend_i2 decimal(p) 2ce06c5cf87d93bb1e3f47268dbc679be4b6dd8d 19 null false null false false false false 扩展 Integer 3 extend_i3 decimal(p) 53d8c730fcec69d341f44089817ae06eb4844278 19 null false null false false false false 扩展 Integer 4 extend_i4 decimal(p) ad6f9eff50476669df62b7601cbc3a2e0c905d36 500 null false null false false false false 扩展 String 1 extend_s1 nvarchar(n) 3a24133d2be4831e99d1319983e5393bcf964ff9 500 null false null false false false false 扩展 String 2 extend_s2 nvarchar(n) 40e1afbbad28d28e371dd1ab77fb56640b1cb66b 500 null false null false false false false 扩展 String 3 extend_s3 nvarchar(n) a2d6b5a494fc1a3d29360d922296521c6640856b 500 null false null false false false false 扩展 String 4 extend_s4 nvarchar(n) 29f701cc6a308fbfc5b12b80fee621ceeb231dcc 500 null false null false false false false 扩展 String 5 extend_s5 nvarchar(n) c9a37a7b6a5451930ca63e36814767f742cd1393 500 null false null false false false false 扩展 String 6 extend_s6 nvarchar(n) 8c26203d310a4e602cf0c0fc8a7b2c818219c1dc 500 null false null false false false false 扩展 String 7 extend_s7 nvarchar(n) 54448f19b0f5d1630bf29f9f99787802c36ebddb 500 null false null false false false false 扩展 String 8 extend_s8 nvarchar(n) 1bd41a312e06683ca045e5888d200e0b78f34eb9 200 null false null false false false false 文件内容类型 file_content_type varchar(n) 7a27c52b873302f4200abb336291da16d67e971c 100 null false null false false false false 文件扩展名 文件后缀扩展名 file_extension varchar(n) 06c8c06de2e755ce212c5bc885d60c2258ed1582 64 null false null false false false false 文件编号 file_id varchar(n) ec29482dfd36942ef1e387a971d5369769998532 64 null false null false false false false 文件MD5 文件MD5 file_md5 varchar(n) e2e0369af3191a268fc1d03ea0eef107d0392be0 255 null false null false false false false 文件信息(JSON格式) file_meta varchar(n) 7295c82faa1ac317a2e7b0e11fbc9b7f8a1bc1e4 500 null false null false false false false 文件名称 file_name nvarchar(n) 680182522ef3e840e233d3245867576299b4f93a 1000 null false null false false false false 存库文件相对路径 文件相对路径 file_path nvarchar(n) 1b5310d274dec8e27515ab91eb99537ee0d2a855 1 null false null false false false false 0 无需处理；1 待生成；2 已生成； 文件预览标记 file_preview character(n) 4f74582c7985a857816f60e5cb57e552173d6786 31 null false null false false false false 文件大小(单位B) 文件大小(单位B) file_size decimal(p) 91535d1fca32e48c6db699f421f606a7eede469a 10 null false null false false false false 排序（升序） 文件排序（升序） file_sort decimal(p) 474216e9f34d3d238da54689cd04d32e20a0a4bb 20 null false null false false false false 文件分类（image图片、media媒体、file文档） 文件分类（image、media、file） file_type varchar(n) c1d6e02f5f9a31d6a494f646bbff8479fa3f52b9 200 null false null false false false false 冻结原因 freeze_cause varchar(n) 2492476f4d92ca4051cc9cd883c427585bd01a7d null null false null false false false false 冻结时间 冻结时间 freeze_date datetime cc2d46a644ef882366305e786927e310dc7945cb 200 null false null false false false false 公司简称 公司全称 full_name nvarchar(n) 60bc76a5c1e1f5559a42184bff19549d11c7173a 200 null false null false false false false 名称全称 机构全称 full_name varchar(n) edc273602f2feb54b0d9f060c9414873cf0e46d1 50 null false null false false false false 生成功能作者 生成功能作者 function_author nvarchar(n) dc13101e962883627abb3ca0967353d2d1920ae1 200 null false null false false false false 生成功能名 生成功能名 function_name nvarchar(n) b50c10e77abcb30aa7a0efe2b3a9ef080516967a 50 null false null false false false false 生成功能名（简写） 生成功能名（简写） function_name_simple nvarchar(n) a7e9e473423331cc2e697d7bad777fab8ea6487a 1000 null false null false false false false 生成基础路径 生成基础路径 gen_base_dir nvarchar(n) 6c2473c9a63d2ad405655d7adff7591d6d6c532c null null false null false false false false 最后心跳时间 heart_time datetime 869fc70cf3a4e92e8056b40814df8e03f9f9efde 64 null false null false false false false 编号 id varchar(n) f69037f9c9f1c4e8dd771b537b5cf3bc26d7ac3f 64 null false null false false false false 集群的实例名字 instance_name varchar(n) e2663716e6af40682333d3e8495a04bceff16647 1000 null false null false false false false 调用目标字符串 调用目标字符串 invoke_target nvarchar(n) da74a37a1025119cd79a05644781c76b606352d3 1 null false null false false false false 是否有附件 is_attac character(n) 1f28b66ae37ff660c2675ba152dee6b728f083d7 1 null false null false false false false 是否编辑字段 是否编辑字段 is_edit character(n) e889df5da9a251b18e384fc428bb2654cdda9310 1 null false null false false false false 是否异常 is_exception character(n) ceaed31e30ef442dc589a113de79bd6a81248d78 1 null false null false false false false 是否插入字段 是否插入字段 is_insert character(n) 31a7568881d922441d4dbebe5a6143735995ed3b 1 null false null false false false false 是否列表字段 是否列表字段 is_list character(n) 5224ef38946585af8ba22f294756ffaecb434ddc 1 null false null false false false false 1是 0否 不重要消息，合并发送，规定时间推送一次。 是否合并推送 is_merge_push character(n) e0da8eabac4712b66e3cf284f8be5a8533c31220 1 null false null false false false false 是否可为空 是否可为空 is_null character(n) d7c4eca9ef06061ed7759b05cd050ef4b8c2111e 1 null false null false false false false 是否主键 是否主键 is_pk character(n) 5174c7a0354ffa29e89aacf71d1b96e56f78b1fb 1 null false null false false false false 是否查询字段 是否查询字段 is_query character(n) a5e7e1443b21fe207b79ab4300b2ab90bc8a69ea 1 null false null false false false false 是否显示（1显示 0隐藏） 是否显示（1显示 0隐藏） is_show character(n) beb0b2bbc25fd0de1f47e6d31d88cbb3e2af3631 1 null false null false false false false 是否标星 is_star character(n) 91ff2bdef1967c13003dcc863afcfda57b73e55e 1 null false null false false false false 是否系统字典 is_sys character(n) 7feb27963741f108bd29ccf401a0f25ec6f588ff 1 null false null false false false false 系统内置（1是 0否） is_sys character(n) 0d830d7889e57b255de5bb649e4f13fc1c369c86 1 null false null false false false false 是否更新字段 是否更新字段 is_update character(n) 728962f9a8c15fa620380b1e8bbb54a9b386ce72 200 null false null false false false false 新建、执行、暂停、恢复、异常 日志事件 job_event varchar(n) 2fe17467ad48944f125de4abf28e973234a9bcb4 64 null false null false false false false 任务组名 任务组名 job_group varchar(n) 78a5e7f85b6c82e0032ba56579b661b0971a46c8 500 null false null false false false false 日志信息 job_message varchar(n) 70abca97f16eab0d562a2104ec1a0ede326b1c46 64 null false null false false false false 任务名称 任务名称 job_name varchar(n) 8afadc1ddabcb75c4b83d8bef5401cd464ddb03b 50 null false null false false false false 调度日志、任务日志、触发日志 日志类型 job_type varchar(n) 2392b56eaf51ec9f6e32fe6553460d25b3da9729 500 null false null false false false false 语言编码 lang_code nvarchar(n) 26c952fa648f51d2350f628195fc098f918d8149 500 null false null false false false false 语言译文 lang_text nvarchar(n) 26bbe2ffbcc2678b0691f0721632c3dcdabfb4ff 50 null false null false false false false 语言类型 lang_type varchar(n) 2c9ac39dfb195a0768ec52f0b2a3e96dc3575819 null null false null false false false false 最后登陆时间 最后登陆时间 last_login_date datetime 01dfcccb43a2647979ef648912e43b8982c0cf42 100 null false null false false false false 最后登陆IP 最后登陆IP last_login_ip varchar(n) b458d603ccaa8a68b8e7f4af5bc49b45cab7d11c 100 null false null false false false false 负责人 负责人 leader varchar(n) 7eedb24c45d73dd56887eefd7e438528fbf4cf10 10 null false null false false false false 社区版、标准版、专业版 系统许可版本 lic_version nvarchar(n) b6a52f87ba533a819eb169768b846266226d641c 100 null false null false false false false 登录账号 登录账号 login_code varchar(n) 0f3bdea163557e4155a4c3c90c8389ea9e55e5b5 500 null false null false false false false 日志标题 日志标题 log_title nvarchar(n) e05fe9078021fb5b026eefac77069bc0b2d13c56 50 null false null false false false false 日志类型 日志类型 log_type varchar(n) a349e3aeee90969e1e0c7f6ad8481b209eb691f3 500 null false null false false false false 主类全名 main_class_name varchar(n) adba31cfd94479f79feda2a3b90cc1bac3eed99f 64 null false null false false false false 菜单编码 menu_code varchar(n) 17699b17170db6b9ffcf6ffd332fc0cfc983d8ac 50 null false null false false false false 颜色 颜色 menu_color varchar(n) 61ecd8a2f562b6c7540d73935c5ab7672d3f3bfc 1000 null false null false false false false 链接 链接 menu_href varchar(n) 1e3adac597a8668830a11c2652cc6adb661d941a 100 null false null false false false false 图标 图标 menu_icon varchar(n) d5a4d04f60ce748f15b651a78cef47d1a14e19fa 100 null false null false false false false 菜单名称 菜单名称 menu_name varchar(n) bcf07d65d41b82a0a96dc5da4faa8d4a2c52e3e9 20 null false null false false false false 目标 目标 menu_target varchar(n) e6d37962edd3a1eefde9a3795406fdd36887f1ac 100 null false null false false false false 菜单标题 menu_title varchar(n) f22f8e8ec4f9a9edfc3a04de5c62d4cb485a0f82 1 null false null false false false false 菜单类型（1菜单 2权限 3开发） menu_type character(n) a960c1b4db1c00820c60b00152ddb17ef23fd0b8 1 null false null false false false false 管理员类型（0非管理员 1系统管理员 2二级管理员） 管理员类型（0非管理员 1系统管理员 2二级管理员） mgr_type character(n) 44ce4edd5ad45896934d6f90f14af5884b98ba5b 1 null false null false false false false 计划执行错误策略 计划执行错误策略 misfire_instruction decimal(p) 04844023ecf0480ce786e53a5246e93cc875987f 100 null false null false false false false 手机 手机号码 mobile varchar(n) 8738d2bb42a1224d22235ec41e1358b890a50955 100 null false null false false false false 手机串号 绑定的手机串号 mobile_imei varchar(n) c2c68b3979b0c52109cb085c491bebb415a189b4 64 null false null false false false false 归属模块 module_code varchar(n) 446f3cd3b9b1dd50fa5989a256c401a193a3706c 64 null false null false false false false 模块编码 模块编码 module_code varchar(n) 538b3f250c5594f837120b38e15103b7f1730d4a 500 null false null false false false false 归属模块（多个用逗号隔开） module_codes varchar(n) 2f27eb5025ffc1dddc8dd8f526bc9ba3fddd976b 100 null false null false false false false 模块名称 模块名称 module_name varchar(n) ce338c590e6e91ae174e1728177e527d1fb5a1f8 30 null false null false false false false 生成模块名 生成模块名 module_name varchar(n) 98eb079aebd2f56c461cb92d97ab4d56f603b840 null null false null false false false false 支持json，通知：设置按钮及链接；短信：设置模板及数据；app：设置设备，声音等；微信：设置模板及数据等；邮件：设置抄送，密送；内容等 消息内容 msg_content clob a304841afc9968e7c8768979fe2ba3f2f315db78 200 null false null false false false false 消息标题 msg_title varchar(n) e0b1aac165f125b035482c239571e732457eb8a9 16 null false null false false false false 消息类型（PC APP 短信 邮件 微信） msg_type varchar(n) 81e89a36c985a9f69710177677cd7be6ed6ea089 100 null false null false false false false 通知类型（PC APP 短信 邮件 微信）多选 notify_types varchar(n) a5fffb704f5efbf6cba1e9e81fd45336d06f06c0 64 null false null false false false false 机构编码 机构编码 office_code varchar(n) 2b8439b512c0d6df70ca5f7c65bfd30a32def655 100 null false null false false false false 机构名称 机构名称 office_name nvarchar(n) 7de44d266aacfd2735733386ead9dffd140cdef4 1 null false null false false false false 机构类型 机构类型 office_type character(n) 688b0f7ac0036d32e75f7da7a74d307c976be2ab 1000 null false null false false false false 其它生成选项 其它生成选项 options nvarchar(n) 705ceee9c058659c1509ef35e6cdd1bedc4422c4 500 null false null false false false false 生成包路径 生成包路径 package_name varchar(n) b18ce64a2a72d00b26515583d8bbfea282f30ea8 64 null false null false false false false 父级编号 parent_code varchar(n) 63772c051414452204e91e8d0dabd1dbfd640326 767 null false null false false false false 所有父级编号 parent_codes varchar(n) 7302decf65cd29ade7edd5a42ef629938c70f45c 64 null false null false false false false 本表关联父表的外键名 本表关联父表的外键名 parent_table_fk_name varchar(n) 03fa62677d146f929436f5b658fec1d454ec0adc 64 null false null false false false false 关联父表的表名 关联父表的表名 parent_table_name varchar(n) 747d0db2fe9de2a328a1f39ef6a11a915afada04 200 null false null false false false false 登录密码 登录密码 password varchar(n) 324e1ef832db227483e8f52111e219a2ad94f67e 1000 null false null false false false false 权限标识 权限标识 permission varchar(n) 73f7a37e9b9d7dbfe21646c4fab3347a7d204913 100 null false null false false false false 电话 办公电话 phone varchar(n) 28d67ce7603d635f412c5c3fe397b61580b962e5 null null false null false false false false 定时推送 计划推送时间 plan_push_date datetime c7414ff6615cec2297f4ac0e40cac1fd77b7dc51 64 null false null false false false false 岗位编码 岗位编码 post_code varchar(n) a7fd696bf0b4d6135cd8d9602d5b622896a3d708 100 null false null false false false false 岗位名称 岗位名称 post_name varchar(n) 40205670c71732eff440d692bfe2addb1fa7f728 10 null false null false false false false 排序（升序） 岗位排序（升序） post_sort decimal(p) 604aada9016061972b5fc4eeb951c4671f5307c4 100 null false null false false false false 岗位分类（高管、中层、基层） 岗位分类（高管、中层、基层） post_type varchar(n) 1ac0c56274ea3dd84f0a1c22002a44373d216d5f null null false null false false false false 推送时间 push_date datetime 7f00758215841d707b4eb3b7bdb1f7cbb4752a95 null null false null false false false false 失败后的尝试推送次数 推送尝试次数 push_number integer 4dcc8f1c91f65017557f2c3840e9245b21b22937 200 null false null false false false false 推送第三方返回的结果码 推送返回结果码 push_return_code varchar(n) a327f23161a6e1fad764457889fc84600651185b null null false null false false false false 包括异常信息 推送返回的内容信息 push_return_content clob 858797dd1d77830004f9030e960fedcc8fa3f4d5 200 null false null false false false false 推送返回消息编号 push_return_msg_id varchar(n) d58d7e14692bb3a537852c764bd0b13909be2167 1 null false null false false false false 推送状态（0未推送 1成功 2失败） push_status character(n) 23d9751f44d62a87de371c36b52664bec7e7815c 200 null false null false false false false 密保问题 密保问题 pwd_question varchar(n) 8026c23bd056a83798a77e010c2b810e6738f1fb 200 null false null false false false false 密保问题2 密保问题2 pwd_question_2 varchar(n) dffce782b8e0d921036feb32eb8137a84a937de9 200 null false null false false false false 密保问题3 密保问题3 pwd_question_3 varchar(n) 7f2a6a606ce3ff27a3778bacc036afb74d3b7346 200 null false null false false false false 密保问题答案 密保问题答案 pwd_question_answer varchar(n) 347c6496b6dc5e98d61a159e55f8aa8b847f3fba 200 null false null false false false false 密保问题答案2 密保问题答案2 pwd_question_answer_2 varchar(n) 6986b6de1581af248bdcdc6fc9e5d2f300c26c14 200 null false null false false false false 密保问题答案3 密保问题答案3 pwd_question_answer_3 varchar(n) 8c9ea8f33293f42f4bdee7a8251152567a4e731d null null false null false false false false 密码问题修改时间 密码问题修改时间 pwd_quest_update_date datetime cd995bcf9d5a67f471bb214c921b8b229de30767 1 null false null false false false false 密码安全级别（0初始 1很弱 2弱 3安全 4很安全） 密码安全级别（0初始 1很弱 2弱 3安全 4很安全） pwd_security_level decimal(p) 9ce384c009a431f01fe6840373567782fab32249 null null false null false false false false 密码最后更新时间 密码最后更新时间 pwd_update_date datetime 89226cf84f03f0a56ec7adcbf4781049b97121f9 1000 null false null false false false false 密码修改记录 pwd_update_record varchar(n) b51b6ef27d586f8267bfd6bbf27a0858e129fd8d 200 null false null false false false false 查询方式 查询方式 query_type varchar(n) 3751f5815571927a4e0256d96332940be3298b32 null null false null false false false false 读取时间 read_date datetime ee6a8b248591b7d9507799c3f8f8a8fb3421ba7e null null false null false false false false 阅读时间 阅读时间 read_date datetime 33137e3fab07284df34eba0d850170935559f88b 1 null false null false false false false 推送成功后，如短信、微信、邮件没有回调，则自动设置为已读状态。有回调的，如PC通知，手机通知，设置为未读状态 读取状态（0未送达 1已读 2未读） read_status character(n) 6b9d91752acccc30552bfaf5c7a8793defd825fb 64 null false null false false false false 根据消息类型存储，如：短信：存手机号、邮箱：存邮箱地址、微信：存openid 接受者账号 receive_code varchar(n) 5797ae3ca5da40a8a45dfd0071f3589585c2517f null null false null false false false false 接受者字符串 接受者字符串 receive_codes clob 86b915810d6436eb5c60062abbe4f8910c86f89c null null false null false false false false 接受者名称字符串 接受者名称字符串 receive_names clob 0fa4e2d76aa9a87670cb1345202c5fbc44183cfe 1 null false null false false false false 接受者类型（0全部 1用户 2部门 3角色 4岗位） 接受者类型（0全部 1用户 2部门 3角色 4岗位） receive_type character(n) 63ba93a883b0de38c98f6bd84772c7666b453576 64 null false null false false false false 接受者编码，对应user表的user_code 接受者用户编码 receive_user_code varchar(n) 1e639355834e23e3a39ac190e4768ef48463ae83 100 null false null false false false false 接受者姓名 接受者用户姓名 receive_user_name varchar(n) f95a0e3e0b66048e979ae0488e387f09e1c94f50 100 null false null false false false false 用户类型引用姓名 用户类型引用姓名 ref_name varchar(n) 8f7d3761c17a1b8632d186a3c67cb08dca18c498 500 null false null false false false false 备注信息 remarks nvarchar(n) 3f3d718d56a9cb12c3fa930238c9a47540b44121 255 null false null false false false false 操作IP地址 操作IP地址 remote_addr varchar(n) f8908cec8baf4ee5432e22045703bd123a10f6f8 10 null false null false false false false 操作方式 操作方式 request_method varchar(n) 3fff2c937b254b87dd3493f68af6567091dfc2b1 null null false null false false false false 操作提交的数据 操作提交的数据 request_params longtext f638d63bc277ad1057f0b0bfad3358ca3ba54294 500 null false null false false false false 请求URI 请求URI request_uri nvarchar(n) 0939f982d8d703b2e27b802da88b1ba1eeb11c63 64 null false null false false false false 角色编码 角色编码 role_code varchar(n) bf04028c4beab99e1c35c6a22ffa6f9b745a49f5 100 null false null false false false false 角色名称 角色名称 role_name varchar(n) f7482b471418bdd790ae93233367f1d6315506ed 10 null false null false false false false 角色排序（升序） role_sort decimal(p) 261201b437ac0f92fe52da10902425f2391f0fa8 100 null false null false false false false 角色分类（高管、中层、基层） 角色分类（高管、中层、基层、其它） role_type varchar(n) 5e197b7f106763a6952e72203fcc902cea793853 null null false null false false false false 发送时间（可定时） 发送时间 send_date datetime c5364fcf3327275d038d229e22f80ce97c28d402 64 null false null false false false false 发送者用户编码 send_user_code varchar(n) 949f48cec7229094875af06d5c3ee4e7efbba1e0 100 null false null false false false false 发送者用户姓名 send_user_name varchar(n) f0dca67090d0e6096bf6a6c9e2dfb35c0fd64de2 255 null false null false false false false 请求服务器地址 请求服务器地址 server_addr varchar(n) a08bfaf64f7f083d4150eb89f91545da11aea32c 50 null false null false false false false 系统节点名称 server_name nvarchar(n) 471884a5e2033e41803feef5822bdd0fe52abe3c 500 null false null false false false false 系统节点地址 server_url nvarchar(n) b63e72d00089330f9932863eeb972e87d94cabce 1 null false null false false false false 1男 2女 用户性别 sex character(n) ab96e97ea0fa572ae6c746aec5e8dd94569f053a 200 null false null false false false false 表单类型 表单类型 show_type varchar(n) 4551bd6ffaf84e43ffaaf7fa7ec5a46c37935f24 200 null false null false false false false 个性签名 sign nvarchar(n) cae139cc445b5d645601b0ef865245c1a57ac0cb 1 null false null false false false false 在线、在线许可不正确、离线 服务状态 state character(n) cf949a5f8d12902f0a8384fa68c72f55e6136812 1 null false null false false false false 状态（0在职 1删除 2离职） 状态（0在职 1删除 2离职） status character(n) ba0fb53af3ccc8b0e5d73baa58ec27fbb7973097 1 null false null false false false false 状态（0正常 1删除 2停用 3冻结 4审核 5驳回 9草稿） status character(n) b2b945d048896baab43ae931af786e910224b43b null null false null false false false false 状态（0正常 1删除 2停用 3冻结） 状态（0正常 1删除 2停用 3冻结） status char 17718c2364a2368c2072da279c927d7ad3bfcf08 1 null false null false false false false 状态（0正常 1删除 2停用） status character(n) 481c1a6225e0f2a86dbf4f752e9455afac57f897 1 null false null false false false false 状态（0正常 1删除 2暂停） 状态（0正常 1删除 2暂停） status character(n) 20092a8f08bbf1304383014693172e4fc863277d 1 null false null false false false false 状态（0正常 1删除 4审核 5驳回 9草稿） 状态（0正常 1删除 4审核 5驳回 9草稿） status character(n) 58ee1b25a309334f43edd0e3695be10addd71571 30 null false null false false false false 生成子模块名 生成子模块名 sub_module_name varchar(n) e0509c4cf92246c64c1f44892e866378cec1ee30 64 null false null false false false false 归属系统（default:主导航菜单、mobileApp:APP菜单） 归属系统（default:主导航菜单、mobileApp:APP菜单） sys_code varchar(n) f53f151fcfc0c5008da4d5314a50ef425a61c482 64 null false null false false false false 表名 表名 table_name varchar(n) cac7cfc71f4053cb77cde93a010175137825a041 10 null false null false false false false 超时时间 timeout decimal(p) 3c113dc08971de6b9b524afdcb41a1562f130081 200 null false null false false false false 生成模板分类 使用的模板 tpl_category varchar(n) 87c323ed50d7e952c195d1d2cfac3aaa1cc8c064 null null false null false false false false 1短信、2微信、3邮件 模板内容 tpl_content clob 85d3f3e510752f1fceb2eb3e31335189700bc51c 100 null false null false false false false 模板键值 tpl_key varchar(n) 6de45c0d7645e6c175422872e1870c090f401c1f 100 null false null false false false false 模板名称 tpl_name nvarchar(n) c37221af63cbefcf4e7f94fcfbc2e6af6779c915 16 null false null false false false false sms 短信 mail 邮件 模板类型 tpl_type varchar(n) 40b63ab3e485fd55370d6d04b063c4397483ebc1 1 null false null false false false false 是否最末级 tree_leaf character(n) 3b9c3307b7140f27edeb47ffe307a662b2856627 4 null false null false false false false 层次级别 tree_level decimal(p) f48d759281e0da56d3e82430c3489d1276418f61 767 null false null false false false false 全节点名 tree_names varchar(n) be17e27c1f73fe128f00468cc83953077b7e00a9 10 null false null false false false false 排序号（升序） tree_sort decimal(p) b0bd388c14e5b2bbab9590f5247961a7edd9eb3b 767 null false null false false false false 所有排序号 tree_sorts varchar(n) 2c6b290f30c6f9e100f6c77eab0cba7bb3386768 64 null false null false false false false 更新者 update_by varchar(n) f0bdbc4002f4a1b7fb7c5026bc21a7689c549728 null null false null false false false false 更新时间 update_date datetime cc6e1b3ebd5a36ac1f844bc246537c6f1e99c3af 300 null false null false false false false 升级信息 upgrade_info varchar(n) ef5ee759e44ca382acf8a7d7124978d0b509cbab 500 null false null false false false false 用户代理 用户代理 user_agent nvarchar(n) 72cb012455ead4444ad451f28f6bac51ad9b5130 100 null false null false false false false 用户编码 用户编码 user_code varchar(n) 17cc9c14f8fd31cc61e610dda56a2948f5b8266e 100 null false null false false false false 昵称 用户昵称 user_name varchar(n) 1c01776985dea9bd14e14cb8a97ab836bb4871ee 16 null false null false false false false 用户类型（none未设置 employee员工 member会员） 用户类型 user_type varchar(n) b395e79cb48e870a827a4ea6436f7d00c2f18111 16 null false null false false false false 用户类型（employee员工 member会员） user_type varchar(n) 5cb9825e5780cc2b9bdfffc62b843892cec567ed 8 null false null false false false false 政府单位高层靠前 用户权重（降序） user_weight decimal(p) 5574844cb0d58e6bdfa1ca122c6cca8c5b27602a 100 null false null false false false false 公司代码 公司代码 view_code varchar(n) 87b8aa1c7178b4ce728dac87ce65c43bec953427 100 null false null false false false false 机构代码 机构代码 view_code varchar(n) 5046a82641c7b483c20812028106e771891fa8c0 4 null false null false false false false 菜单权重 weight decimal(p) 5537317393b9e8a86c73daf8d584ace898c0d267 100 null false null false false false false 绑定的微信OpenID 绑定的微信号 wx_openid varchar(n) 275cece5dc0985966870fa12af1ce5928b902eb0 100 null false null false false false false 邮政编码 邮政编码 zip_code varchar(n) cb48c1cac141bb138bedb45c67fcae800e7e2767100319Segoe UI9170483 128 128 192 5c34d5d569f4c3e91ad429ffae21f6c8cde6e701 f6a8962b7fcb6101a25612849c208419604d342c cb48c1cac141bb138bedb45c67fcae800e7e2767 -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null 73078c6c0fb5f54142878da20e15be4ba532c23b 0ded13a505cc3bfde24edfbae369231be192a59b cb48c1cac141bb138bedb45c67fcae800e7e2767 -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null js_sys_user_role用户与角色关联表 537ed3a5e139d1fed26b9011d93c339510cda1f7 e59481cc0025d4da3d55201ee470c33b2c12a575 73078c6c0fb5f54142878da20e15be4ba532c23b varchar(n) false true true true false false false false 0 ffde396c7b349d700fe1b7891694ac538d00bf6d 22d38cfee95536d3e3af5fdd444b027a85d95432 5c34d5d569f4c3e91ad429ffae21f6c8cde6e701 varchar(n) false true true true false false false false 0 a164a0a63e52dfc0ae2ebd2165cb1d846c9783d1152352Segoe UI916081503 128 128 192 a52080b1f696ae2b0c542a9a2e6814e01289a9bf 0ded13a505cc3bfde24edfbae369231be192a59b a164a0a63e52dfc0ae2ebd2165cb1d846c9783d1 -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null js_sys_user_data_scope用户数据权限表 0d5ebb11e5172fb4a9e1b4b2e62140432e0cd3ff e59481cc0025d4da3d55201ee470c33b2c12a575 a52080b1f696ae2b0c542a9a2e6814e01289a9bf 控制用户编码 varchar(n) false true true true false false false false 0 df33cf2fa1349df70c9c48ac3a90b92a146224ed fa0fc88324f164510892cc92c2a06f4f5360a6b4 varchar(n) false false true true false false false false 0 69bed3e42a9bbab83f7eb519e2786edc22260fd4 6d91e3c98450b9e724ca8edd62e764e0df316c7e varchar(n) false false true true false false false false 0 286b8f3e3671588da8693a150d1c611ff0634dcf 1c8e5147d9b4ffed5b9c10b0e2fcc921973dce84 varchar(n) false false true true false false false false 0 aeeef3e96e94d3f99bf59b48790fdd6d04209c8e 121 349 Segoe UI 16 540 72 128 128 192 JeeSite 4.x Module Core http://jeesite.com 54d156398db07de97741ea8035283f424eae82dc100329Segoe UI9542264 128 128 192 a94020550e7bc4d31384f96700f2c31721d49880 26e4b2554a744e584fba5f3b88c267026359e727 54d156398db07de97741ea8035283f424eae82dc -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null 465f6e6cf94d54066bf3ed6825525842fc06119c 6615f2ce0ec05caf1a51f92d1c2b458984ac9db6 54d156398db07de97741ea8035283f424eae82dc -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null js_sys_employee_post员工与岗位关联表 2f7bbb8699e51f6ae50ccbab765f8de4a402cad2 ab8b402ea35a78cdadd5ed446d571c9a80b532ee a94020550e7bc4d31384f96700f2c31721d49880 varchar(n) false true true true false false false false 0 c06047702cc26617e350accac3afdbb589cf5cf4 ed19c91e49d39e19cffec01c77c369cd2ea1c989 465f6e6cf94d54066bf3ed6825525842fc06119c varchar(n) false true true true false false false false 0 dfd92f583371dc219fe0aeb5c64f4d7fc5b2db58620495Segoe UI932761416 128 128 192 js_sys_msg_pushed消息已推送表 869fc70cf3a4e92e8056b40814df8e03f9f9efde 94142372cce0fa637010a4f1ffbcdb09c79280a5 varchar(n) false false true true false false false false 0 e0b1aac165f125b035482c239571e732457eb8a9 48e3284819439b54313716f5d1b7875d96a94346 varchar(n) false false true false false false false false 0 a304841afc9968e7c8768979fe2ba3f2f315db78 348959ce20a023239a8585e94c0a26b144c706ab varchar(n) false false true false false false false false 0 98eb079aebd2f56c461cb92d97ab4d56f603b840 ad07cb36dfe9635464a8e916d1ff0f4cfc39354d clob false false true false false false false false 0 667704664e4b88b145cebda0d6a1fbafb53525f0 9616345b413d53f24fcfbd55ef76702530c5e135 varchar(n) false false false false false false false false 0 4f9a5bc4fccb64cfc3a35f9209c9ce9bd044a6b9 5818a0753aaaf1b6f7b5424c94109feca573eb9f varchar(n) false false false false false false false false 0 6b9d91752acccc30552bfaf5c7a8793defd825fb c1ad8a7f995b7e311e37727f2d83ab2999378bc3 varchar(n) false false true false false false false false 0 63ba93a883b0de38c98f6bd84772c7666b453576 1b9ecf5da3526acc0cb3d46775447289dd16781e varchar(n) false false true false false false false false 0 1e639355834e23e3a39ac190e4768ef48463ae83 3020883c0d78e9565931fa4cae562f1c5cbff195 varchar(n) false false true false false false false false 0 c5364fcf3327275d038d229e22f80ce97c28d402 14c84ddd9d5d81064c0e63c03280b58242e2f1ed varchar(n) false false true false false false false false 0 949f48cec7229094875af06d5c3ee4e7efbba1e0 de9e2029fea32d3ec721bed77fc90e870cee92a8 varchar(n) false false true false false false false false 0 5e197b7f106763a6952e72203fcc902cea793853 c3f7c93f6a43005dbffb262eb843aa0049a0069a datetime false false true false false false false false 0 5224ef38946585af8ba22f294756ffaecb434ddc da53917cef89b0ef7e6a4e190f1d74149d1f02a4 character(n) false false false false false false false false 0 28d67ce7603d635f412c5c3fe397b61580b962e5 855d14e23de62f5e57c41c705f39d7b749735ad2 datetime false false false false false false false false 0 7f00758215841d707b4eb3b7bdb1f7cbb4752a95 d6eb5f4356f8b46b1b74ca1fa9fe95dd7557bf4e integer false false false false false false false false 0 a327f23161a6e1fad764457889fc84600651185b 3c90e218d5110ed4f34dd5d7e8ee07dc468a57af clob false false false false false false false false 0 4dcc8f1c91f65017557f2c3840e9245b21b22937 8ecec2692a35e304edd445baa3944803de256ab4 varchar(n) false false false false false false false false 0 858797dd1d77830004f9030e960fedcc8fa3f4d5 a068a1a088b68f12b1c8141e473d53e57faf9a6b varchar(n) false false false false false false false false 0 d58d7e14692bb3a537852c764bd0b13909be2167 8c6b914d0d7fbf484630a356ebad0c5a370aefea character(n) false false false false false false false false 0 1ac0c56274ea3dd84f0a1c22002a44373d216d5f d91930762399578e65dc3d3b028052460dd28bdd datetime false false false false false false false false 0 33137e3fab07284df34eba0d850170935559f88b 1f712c0ab5fc4ef2b948047153cbc63e947c4fc5 character(n) false false false false false false false false 0 3751f5815571927a4e0256d96332940be3298b32 6a9f1a249aa33b4171ccaa3b9110e0ae015016cf datetime false false false false false false false false 0 false true idx_sys_msg_pushed_type 48e3284819439b54313716f5d1b7875d96a94346 false false true idx_sys_msg_pushed_rc c1ad8a7f995b7e311e37727f2d83ab2999378bc3 false false true idx_sys_msg_pushed_uc 1b9ecf5da3526acc0cb3d46775447289dd16781e false false true idx_sys_msg_pushed_suc 14c84ddd9d5d81064c0e63c03280b58242e2f1ed false false true idx_sys_msg_pushed_pd 855d14e23de62f5e57c41c705f39d7b749735ad2 false false true idx_sys_msg_pushed_ps 8c6b914d0d7fbf484630a356ebad0c5a370aefea false false true idx_sys_msg_pushed_rs 1f712c0ab5fc4ef2b948047153cbc63e947c4fc5 false false true idx_sys_msg_pushed_bk 9616345b413d53f24fcfbd55ef76702530c5e135 false false true idx_sys_msg_pushed_bt 5818a0753aaaf1b6f7b5424c94109feca573eb9f false false true idx_sys_msg_pushed_imp da53917cef89b0ef7e6a4e190f1d74149d1f02a4 false 319e4091b704702c77deaf7621a231f6cdd5a814282313Segoe UI919722453 128 128 192 f6fe4091f16d65b5cd4e05129fd4970d48b70a90 525b18e0d2c940bf132733cfaba411fb84ddf255 319e4091b704702c77deaf7621a231f6cdd5a814 -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null js_sys_job_log作业调度日志表 869fc70cf3a4e92e8056b40814df8e03f9f9efde 9382e4d59004f8f437199ae02d75645c714ed23f varchar(n) false false true true false false false false 0 6d5f3e5ef4d28e57966c33c4b4ef424f1dc42b7b 55c7d0a9ab8650c264a75bb1bf958cac2fe68152 f6fe4091f16d65b5cd4e05129fd4970d48b70a90 varchar(n) false true true false false false false false 0 91110163a8a31ee61a4153360707026b5498dd65 443772d4627c23aef484c324c8e431121b921a44 f6fe4091f16d65b5cd4e05129fd4970d48b70a90 varchar(n) false true true false false false false false 0 8afadc1ddabcb75c4b83d8bef5401cd464ddb03b 3e80df782a38bab9e765399dfd0343f568b4d9b7 varchar(n) false false false false false false false false 0 728962f9a8c15fa620380b1e8bbb54a9b386ce72 81bc4d9e8dad3d9348f2c71eb3c600e4594f1316 varchar(n) false false false false false false false false 0 78a5e7f85b6c82e0032ba56579b661b0971a46c8 6ed5757124ebbe8c4839b820b2418e840d14bb89 varchar(n) false false false false false false false false 0 e889df5da9a251b18e384fc428bb2654cdda9310 0b9a8fee0730362310d5c0e58a67ea01e2d5d722 character(n) false false false false false false false false 0 d903f31236ff7a6701ff92a19986146ace84c236 81d875aad67d3c4ada7aa5d5972a120957d18221 clob false false false false false false false false 0 dba1aec0c72d79ea73ed4ebde07696cf4df174b7 2aa75821064814ccb859d75d5c59616e9949cae2 datetime false false false false false false false false 0 false true idx_sys_job_log_jn 6d5f3e5ef4d28e57966c33c4b4ef424f1dc42b7b false false true idx_sys_job_log_jg 91110163a8a31ee61a4153360707026b5498dd65 false false true idx_sys_job_log_t 3e80df782a38bab9e765399dfd0343f568b4d9b7 false false true idx_sys_job_log_e 81bc4d9e8dad3d9348f2c71eb3c600e4594f1316 false false true idx_sys_job_log_ie 0b9a8fee0730362310d5c0e58a67ea01e2d5d722 false 8a8732a74e3df737bc9d9d452b8738c96a563d2e620377Segoe UI9387648 128 128 192 js_sys_log操作日志表 869fc70cf3a4e92e8056b40814df8e03f9f9efde e39df8f3ef6f4416a6a4afc8f5969a3c2fe571f0 varchar(n) false false true true false false false false 0 e05fe9078021fb5b026eefac77069bc0b2d13c56 a03e633748bfae8eae5aa92ae432469d3130afb4 varchar(n) false false true false false false false false 0 0f3bdea163557e4155a4c3c90c8389ea9e55e5b5 8e5bb751ebef3512dbf37eca52e8117c109db3de nvarchar(n) false false true false false false false false 0 03609a0dae154a21833b6bebb7110209336ffbbb 73b46542e2d30af66a06f9239d4df51c66795316 varchar(n) false false true false false false false false 0 aa74f5d673e427a2a45b14ea12e10f69ba9ed0ad d9887dd46c23dd6a8c9db285c1286350f9af6415 nvarchar(n) false false true false false false false false 0 dba1aec0c72d79ea73ed4ebde07696cf4df174b7 ee5addb412d3d8bb20efab0d4f26d782e1502c06 datetime false false true false false false false false 0 f638d63bc277ad1057f0b0bfad3358ca3ba54294 34aa444468170790d3bd52b0d8a5885776813978 nvarchar(n) false false false false false false false false 0 f8908cec8baf4ee5432e22045703bd123a10f6f8 720eed93135029065e5f52563626b1a8cbdd4d82 varchar(n) false false false false false false false false 0 3fff2c937b254b87dd3493f68af6567091dfc2b1 120ee1733cbc5b0fbbc524eaa0ffc5c5cfcf5af7 longtext false false false false false false false false 0 ed5ac38bb6330b7ce8daaa76475ac87c6e1f7e4c adcd4f96b525c65bc0d1f9ab2f20d70498760da8 clob false false false false false false false false 0 667704664e4b88b145cebda0d6a1fbafb53525f0 8f891169da270ac3ad6f57020764868821524aa8 varchar(n) false false false false false false false false 0 4f9a5bc4fccb64cfc3a35f9209c9ce9bd044a6b9 8e6382e07ed16d87522a4054f2e1012d73089f74 varchar(n) false false false false false false false false 0 3f3d718d56a9cb12c3fa930238c9a47540b44121 ca8c0785dd16dc39d2b5a9d2bf3c94866fa12f68 varchar(n) false false true false false false false false 0 f0dca67090d0e6096bf6a6c9e2dfb35c0fd64de2 39b14fb090fd4a37e35015dc92471ffcd9e11fbb varchar(n) false false true false false false false false 0 e889df5da9a251b18e384fc428bb2654cdda9310 186bf2bddf5b4fb9ce835106138d47adb1bebc9e character(n) false false false false false false false false 0 d903f31236ff7a6701ff92a19986146ace84c236 cce47a5de15237ce22ef226c5d652d9d0eeab8ce clob false false false false false false false false 0 ef5ee759e44ca382acf8a7d7124978d0b509cbab 8a9cf17c687cf83a7adf545b6c162d2ee001d0cf nvarchar(n) false false false false false false false false 0 2fc82098d4733d740dba3a09a78f4917544b1251 742136e3bb1180c33d9073b16589bffc10d5d4a3 varchar(n) false false false false false false false false 0 b441f2f2ea527884a201789d79d7d08907eb97ac 6b70f82998475f1acf4085f981b5cea34dd3af49 varchar(n) false false false false false false false false 0 510f647b2d9d95b636aa517b9826966d98962277 a066f670f69ee4fff51f21f262236b223733fea7 decimal(p) false false false false false false false false 0 ea920cba2fe0eaee64a2310ece7cda4b198b37ec false true idx_sys_log_cb 73b46542e2d30af66a06f9239d4df51c66795316 false false true idx_sys_log_cc b8ea4b73d6d32a222e5abfd453287575ae518480 false false true idx_sys_log_lt a03e633748bfae8eae5aa92ae432469d3130afb4 false false true idx_sys_log_bk 8f891169da270ac3ad6f57020764868821524aa8 false false true idx_sys_log_bt 8e6382e07ed16d87522a4054f2e1012d73089f74 false false true idx_sys_log_ie 186bf2bddf5b4fb9ce835106138d47adb1bebc9e false false true idx_sys_log_cd ee5addb412d3d8bb20efab0d4f26d782e1502c06 false 6615f2ce0ec05caf1a51f92d1c2b458984ac9db6296373Segoe UI93636 128 128 192 js_sys_post员工岗位表 c7414ff6615cec2297f4ac0e40cac1fd77b7dc51 ed19c91e49d39e19cffec01c77c369cd2ea1c989 varchar(n) false false true true false false false false 0 a7fd696bf0b4d6135cd8d9602d5b622896a3d708 a17d7b11efbe170a82448b6ac389463e6c9b4dae varchar(n) false false true false false false false false 0 604aada9016061972b5fc4eeb951c4671f5307c4 c47d32d84a5e1182a2f05ff1add8483117b13afd varchar(n) false false false false false false false false 0 40205670c71732eff440d692bfe2addb1fa7f728 197e6e932604cb4d72a8572426221048094400a2 decimal(p) false false false false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd ea920cba2fe0eaee64a2310ece7cda4b198b37ec false true idx_sys_post_cc b8ea4b73d6d32a222e5abfd453287575ae518480 false false true idx_sys_post_status f0036584bd8711715579d21994a0105935605a7e false false true idx_sys_post_ps 197e6e932604cb4d72a8572426221048094400a2 false e358008a1c9b84f744e89039339ba56765fe34bd1088387Segoe UI95211135 128 128 192 e75c04915f113193ab49ab9e492e925be95a8a10 1bfc4bd3083403779e9ec3b1bab83e7eed4732e5 e358008a1c9b84f744e89039339ba56765fe34bd -1 -1 -1 -1 0 0 0 1..n 0..1 true RESTRICT RESTRICT null null js_sys_company公司表 8b9e1b544f371e8c2350ab8926707418a6ea8fdf 5ac7f3a7a755a58e6119c8d4922df644559e632f varchar(n) false false true true false false false false 0 a535b6c506004a7fdf4d48984c9ff2cfa59c157a 5574844cb0d58e6bdfa1ca122c6cca8c5b27602a 7c46717b372c8596c8138ff412b0363bea79262f varchar(n) false false true false false false false false 0 f0f47249781a8c1e655ae11236426b788f099fce bb54ac3b2667504dc519cb88904db1337b64704e nvarchar(n) false false true false false false false false 0 cc2d46a644ef882366305e786927e310dc7945cb 0bc7917672103a43ef4220fe999083a392356666 nvarchar(n) false false true false false false false false 0 bdc9f61f5a7bd4a53e05d939ea82f9885c78eb01 84fb98359c82f62d61719d8ce1d1f850d69d972f e75c04915f113193ab49ab9e492e925be95a8a10 varchar(n) false true false false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd ea920cba2fe0eaee64a2310ece7cda4b198b37ec 118dab95fc1f792cd468b9f66af2d4fabd98c39b false true idx_sys_company_cc b8ea4b73d6d32a222e5abfd453287575ae518480 false false true idx_sys_company_pc 394369b90c0a5b6efeed3cf823c642605d7a1653 false false true idx_sys_company_ts 23f973124aedd0244533f4e7b3b103c548b966be false false true idx_sys_company_status f0036584bd8711715579d21994a0105935605a7e false false true idx_sys_company_vc 7c46717b372c8596c8138ff412b0363bea79262f false false true idx_sys_company_pcs e8d877396943acfec73023dba2c1c6e3d7802d62 false false true idx_sys_company_tss 984d5eac2b3221118a61655e4a5a49c78e0f0151 false 3674020785393b0615fba55ad49015a88e83da12152352Segoe UI920331536 128 128 192 53629fb1290a031fd6a1bb067fd1ba50ec6586de f6a8962b7fcb6101a25612849c208419604d342c 3674020785393b0615fba55ad49015a88e83da12 -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null js_sys_role_data_scope角色数据权限表 7e2f59707205419c8556876dc854aeff0fbf7b57 22d38cfee95536d3e3af5fdd444b027a85d95432 53629fb1290a031fd6a1bb067fd1ba50ec6586de 控制角色编码 varchar(n) false true true true false false false false 0 df33cf2fa1349df70c9c48ac3a90b92a146224ed 0584b59447729b3b369483353308793591c2c407 varchar(n) false false true true false false false false 0 69bed3e42a9bbab83f7eb519e2786edc22260fd4 0f7661178a7a9832b2b97169c49191338e769f6e varchar(n) false false true true false false false false 0 286b8f3e3671588da8693a150d1c611ff0634dcf db19c839b454a19a52e46cd7cbd9b0ba9dd8949c varchar(n) false false true true false false false false 0 1bfc4bd3083403779e9ec3b1bab83e7eed4732e5464387Segoe UI910781728 128 128 192 js_sys_area行政区划 21ca6f52589f791a2ea859b73780a62c8cbebad8 84fb98359c82f62d61719d8ce1d1f850d69d972f varchar(n) false false true true false false false false 0 a535b6c506004a7fdf4d48984c9ff2cfa59c157a 20537c3bba575f25a12b27aad98fa1dc2fdff7a7 01f29dafe6a3ae0f9ed8f7a7490875db991b3457 nvarchar(n) false false true false false false false false 0 76ef00368999973a28221425b221bc4dd8c4b671 ca7b63c6c2cea0cd801e625a1bf33afcd9c3615b character(n) false false false false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd false true idx_sys_area_pc 394369b90c0a5b6efeed3cf823c642605d7a1653 false false true idx_sys_area_ts 23f973124aedd0244533f4e7b3b103c548b966be false false true idx_sys_area_status f0036584bd8711715579d21994a0105935605a7e false false true idx_sys_area_pcs e8d877396943acfec73023dba2c1c6e3d7802d62 false false true idx_sys_area_tss 984d5eac2b3221118a61655e4a5a49c78e0f0151 false 3c87a1572923924d481891ca9d1a09451008cef5100321Segoe UI922921404 128 128 192 34abbb77c48708f95ddab5edd1235da98a90ea5f bbe68e376638ab208682d127d252c38bb6c953a5 3c87a1572923924d481891ca9d1a09451008cef5 -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null c4082c0b632d11a39c0aa770bf2e10a63143eab5 f6a8962b7fcb6101a25612849c208419604d342c 3c87a1572923924d481891ca9d1a09451008cef5 -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null js_sys_role_menu角色与菜单关联表 136c2841a88ba120cd1f0bb13f7ba446474de69e 22d38cfee95536d3e3af5fdd444b027a85d95432 c4082c0b632d11a39c0aa770bf2e10a63143eab5 varchar(n) false true true true false false false false 0 1882f53a36409270c8622486740876fcb2af9842 e84c40cdf5ffdb2ba4d59630d98abb5972d74795 34abbb77c48708f95ddab5edd1235da98a90ea5f varchar(n) false true true true false false false false 0 f24ec280de439487a7e35a62e11a445e7adbd9b61218387Segoe UI948804 128 128 192 js_sys_office组织机构表 a5fffb704f5efbf6cba1e9e81fd45336d06f06c0 512f24dbe486a211117dfb58e689ef3e0e5009a0 varchar(n) false false true true false false false false 0 a535b6c506004a7fdf4d48984c9ff2cfa59c157a 87b8aa1c7178b4ce728dac87ce65c43bec953427 362544a460470412b9160888e562c4a582626f0e varchar(n) false false true false false false false false 0 2b8439b512c0d6df70ca5f7c65bfd30a32def655 2c78fac5e5d538c5e2fa790b4ce1e0217547d271 nvarchar(n) false false true false false false false false 0 60bc76a5c1e1f5559a42184bff19549d11c7173a 32800aecf8993dd18a08cbed7711c76cf62a0c21 varchar(n) false false true false false false false false 0 7de44d266aacfd2735733386ead9dffd140cdef4 6eab10bd38fccfdcc5a25f66389ba23a3192b6c9 character(n) false false true false false false false false 0 b458d603ccaa8a68b8e7f4af5bc49b45cab7d11c 16612d3a02d933279b078bd47f663acefa60e8c5 varchar(n) false false false false false false false false 0 73f7a37e9b9d7dbfe21646c4fab3347a7d204913 7b0e850652cfc5cd4e87982e33f5787f6db36704 varchar(n) false false false false false false false false 0 666f23b96ed873b11a77ceca096cafe42631af5f 148bc18726ef2a8682f8cc0c8ae4859e090564e0 varchar(n) false false false false false false false false 0 275cece5dc0985966870fa12af1ce5928b902eb0 d63923c59ef1fcecc6a5d5853f41fb3915b3e010 varchar(n) false false false false false false false false 0 329bbb76f0884117ace79bb686695f4e9cb120b6 a524d13c791fb53b1465c6c814d96eff6798b2c3 varchar(n) false false false false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd ea920cba2fe0eaee64a2310ece7cda4b198b37ec 118dab95fc1f792cd468b9f66af2d4fabd98c39b false true idx_sys_office_cc b8ea4b73d6d32a222e5abfd453287575ae518480 false false true idx_sys_office_pc 394369b90c0a5b6efeed3cf823c642605d7a1653 false false true idx_sys_office_pcs e8d877396943acfec73023dba2c1c6e3d7802d62 false false true idx_sys_office_status f0036584bd8711715579d21994a0105935605a7e false false true idx_sys_office_ot 6eab10bd38fccfdcc5a25f66389ba23a3192b6c9 false false true idx_sys_office_vc 362544a460470412b9160888e562c4a582626f0e false false true idx_sys_office_ts 23f973124aedd0244533f4e7b3b103c548b966be false false true idx_sys_office_tss 984d5eac2b3221118a61655e4a5a49c78e0f0151 false b5ca9fe7c003b126205522a478b250eab5550f66100345Segoe UI9792148 128 128 192 a130ec188d7c885f6892dc71de1bae551f51edd1 e358008a1c9b84f744e89039339ba56765fe34bd b5ca9fe7c003b126205522a478b250eab5550f66 -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null f100a1495fd553d0b9eaf483190270e68e47bc7e f24ec280de439487a7e35a62e11a445e7adbd9b6 b5ca9fe7c003b126205522a478b250eab5550f66 -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null js_sys_company_office公司部门关联表 23ffaff951e2a129327ee9c1adbd27093924b4f4 5ac7f3a7a755a58e6119c8d4922df644559e632f a130ec188d7c885f6892dc71de1bae551f51edd1 varchar(n) false true true true false false false false 0 79c510b01e27862264aa98b183ba8fce4b97ecab 512f24dbe486a211117dfb58e689ef3e0e5009a0 f100a1495fd553d0b9eaf483190270e68e47bc7e varchar(n) false true true true false false false false 0 61df7bb2357160e94dfbe9e94a8efe0037d3a188360383Segoe UI938731428 128 128 192 js_sys_msg_template消息模板 869fc70cf3a4e92e8056b40814df8e03f9f9efde 139d6bde155f958249dc8c2b36dcbd4b210110a7 varchar(n) false false true true false false false false 0 c2c68b3979b0c52109cb085c491bebb415a189b4 4913a28d9b48eff059c519bbb400e91a9757fc62 varchar(n) false false false false false false false false 0 85d3f3e510752f1fceb2eb3e31335189700bc51c 53969a783147d2b18d0c939278f8417b00f2e8d8 varchar(n) false false true false false false false false 0 6de45c0d7645e6c175422872e1870c090f401c1f e0dd6cebe70cd3fb00bb305204f5393640f0311f nvarchar(n) false false true false false false false false 0 c37221af63cbefcf4e7f94fcfbc2e6af6779c915 e76a1511b06ae78cfda28f6c2b8c0a7f24f28be1 varchar(n) false false true false false false false false 0 87c323ed50d7e952c195d1d2cfac3aaa1cc8c064 9d170c0ed54dd59affbeddf966f469b915409027 clob false false true false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd false true idx_sys_msg_tpl_key 53969a783147d2b18d0c939278f8417b00f2e8d8 false false true idx_sys_msg_tpl_type e76a1511b06ae78cfda28f6c2b8c0a7f24f28be1 false false true idx_sys_msg_tpl_status f0036584bd8711715579d21994a0105935605a7e false 782b92987c27592a00cf1568e6690a1e81cf8b8a360383Segoe UI92952468 128 128 192 js_sys_module模块表 446f3cd3b9b1dd50fa5989a256c401a193a3706c d964f7c50e480b77047f79d1107c95d0bbe9717c varchar(n) false false true true false false false false 0 2f27eb5025ffc1dddc8dd8f526bc9ba3fddd976b 4c086c0ba92da3a70e70b9771d6af64841cc5080 varchar(n) false false true false false false false false 0 f7114401c278a134ec74f1836c0f4afeed91cf0f 9d82192f942304d0060c53ac9a03769df6797ff0 nvarchar(n) false false false false false false false false 0 a349e3aeee90969e1e0c7f6ad8481b209eb691f3 35d6215c6b80d8640b1632e1b8b2139f10d0cec1 varchar(n) false false false false false false false false 0 f1196b5a1e9072ac4cc990c913b774e777b09a46 33577148015618b442b625836cf90ba27ace9621 varchar(n) false false false false false false false false 0 cc6e1b3ebd5a36ac1f844bc246537c6f1e99c3af 6281abb4d5813839a39d7d75ce39843c4467c390 varchar(n) false false false false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd false true idx_sys_module_status f0036584bd8711715579d21994a0105935605a7e false baa54d8a660b4fa684a97d8dd288d1edcf52ec5a308383Segoe UI9295236 128 128 192 js_sys_dict_type字典类型表 869fc70cf3a4e92e8056b40814df8e03f9f9efde 8cfa30fec63c1cac2e5c8fc610368d283756a9d3 varchar(n) false false true true false false false false 0 127ff1ab1747f2d85218814e7367474e78a29826 cb4350483ced46c075d697e816fde1bddf28cc69 nvarchar(n) false false true false false false false false 0 cec894690e4c1517d172409b7da10408776930b2 4f8af0766a0ba0866db74d9fe750581d1eefea91 varchar(n) false false true false false false false false 0 91ff2bdef1967c13003dcc863afcfda57b73e55e a786de868a5c4d4ba470d449cf38f69982bdeee1 character(n) false false true false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd false true idx_sys_dict_type_is a786de868a5c4d4ba470d449cf38f69982bdeee1 false false true idx_sys_dict_type_status f0036584bd8711715579d21994a0105935605a7e false 0183c6d48cf94f7a33a297f161560e906cc28f14308336Segoe UI92963912 128 128 192 js_sys_config参数配置表 869fc70cf3a4e92e8056b40814df8e03f9f9efde f6060612c049709042d4157e4e40e81bd0321afe varchar(n) false false true true false false false false 0 ee84723c8bde13d17589d3a0059e969a54af1a76 e0f7d2c8f9db92fbc2ae5ac0fb1d0de34b8789f2 nvarchar(n) false false true false false false false false 0 3bd475d905295b18837332926f66deacf286f563 807d1ffdb87bb0bd9cc5211997e18efc06db6624 varchar(n) false false true false false false false false 0 a49b2ebdb0ca593f13c432eb28d1bbfe109c1421 c97cf10bf385b6b91e85108039b1a55d55fbde2e nvarchar(n) false false false false false false false false 0 7feb27963741f108bd29ccf401a0f25ec6f588ff 55bd63033160c21ac6e79051e3ea58f1bde0cac7 character(n) false false true false false false false false 0 85024a2953cf3e3c9c1cce49b2351853ab0d125b false false idx_sys_config_key 807d1ffdb87bb0bd9cc5211997e18efc06db6624 false 1d26bde59434d0fd95f797d3387dc564038d192c230467Segoe UI936602359 128 128 192 3fa95dcb5efff46a79aa5f99a24a551899857fd1 5fc45ff72e5a63eee633a54948970a8c9e0d17fb 1d26bde59434d0fd95f797d3387dc564038d192c -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null js_sys_msg_inner_record内部消息发送记录表 869fc70cf3a4e92e8056b40814df8e03f9f9efde 62cf3956f858a0d944fb3fe27dae7d861c74d3c1 varchar(n) false false true true false false false false 0 f385f23b1163beb8b239a67f5a262c83fb46cae6 5eecd1e4e1dc132da52de1bd1f59b13dd13a3587 3fa95dcb5efff46a79aa5f99a24a551899857fd1 所属消息 所属消息 msg_inner_id varchar(n) false true true false false false false false 0 63ba93a883b0de38c98f6bd84772c7666b453576 f291132581e824fea013624aa68208b946df9fe4 varchar(n) false false true false false false false false 0 1e639355834e23e3a39ac190e4768ef48463ae83 aaee2af8d27adc26dd44a3ed15d97e1d5a199041 varchar(n) false false true false false false false false 0 33137e3fab07284df34eba0d850170935559f88b 94c86f843b46a1e649f0e2333952b46978988a51 character(n) false false true false false false false false 0 ee6a8b248591b7d9507799c3f8f8a8fb3421ba7e 251c37ff5cda9c6aba51dc242966cddbf655942c datetime false false false false false false false false 0 beb0b2bbc25fd0de1f47e6d31d88cbb3e2af3631 a29b12cbd56c53b9e480f155f17c69e4bf4d8c7f character(n) false false false false false false false false 0 false true idx_sys_msg_inner_r_mi f385f23b1163beb8b239a67f5a262c83fb46cae6 false false true idx_sys_msg_inner_r_ruc f291132581e824fea013624aa68208b946df9fe4 false false true idx_sys_msg_inner_r_stat 94c86f843b46a1e649f0e2333952b46978988a51 false false true idx_sys_msg_inner_r_star a29b12cbd56c53b9e480f155f17c69e4bf4d8c7f false 56e45198e070129190243fbf2a29099d860aac1d620495Segoe UI926881416 128 128 192 js_sys_msg_push消息推送表 869fc70cf3a4e92e8056b40814df8e03f9f9efde 36cf10f3b283e8d16b710fd8d3d21f21e4dbd02d varchar(n) false false true true false false false false 0 e0b1aac165f125b035482c239571e732457eb8a9 cb11ee89c6123c0dc9ee5770735af56cc81c9b07 varchar(n) false false true false false false false false 0 a304841afc9968e7c8768979fe2ba3f2f315db78 116fd0c3c8c888027ad6419fe4eecb2a437e2bf1 varchar(n) false false true false false false false false 0 98eb079aebd2f56c461cb92d97ab4d56f603b840 a1af64703fec74d055736f7076d81ec79d6eb5e8 clob false false true false false false false false 0 667704664e4b88b145cebda0d6a1fbafb53525f0 3f61ba87308a18681e25ed3c0f8f89acd60e063b varchar(n) false false false false false false false false 0 4f9a5bc4fccb64cfc3a35f9209c9ce9bd044a6b9 7d9a7eae0e2ffc810fa615128b5dab3a613669af varchar(n) false false false false false false false false 0 6b9d91752acccc30552bfaf5c7a8793defd825fb 46d552357357e9392306339993963045756b751c varchar(n) false false true false false false false false 0 63ba93a883b0de38c98f6bd84772c7666b453576 b6c0b7eeb563ed932c43700dfde767999087aaab varchar(n) false false true false false false false false 0 1e639355834e23e3a39ac190e4768ef48463ae83 9ff498915b2e1106aa607a729127416ee63b29b2 varchar(n) false false true false false false false false 0 c5364fcf3327275d038d229e22f80ce97c28d402 16e3cd493352220f14b79e39d620496e775ebc30 varchar(n) false false true false false false false false 0 949f48cec7229094875af06d5c3ee4e7efbba1e0 9e783a5563fe8d587f3147ac34ea0ae33fa2b6f4 varchar(n) false false true false false false false false 0 5e197b7f106763a6952e72203fcc902cea793853 d5747a323719560026f890ebebfa03b1d2127e22 datetime false false true false false false false false 0 5224ef38946585af8ba22f294756ffaecb434ddc 385ac7698fd3d6123c18f7cd819a83e80313f614 character(n) false false false false false false false false 0 28d67ce7603d635f412c5c3fe397b61580b962e5 5aad5e7593bf81a4a0ffd20ccdc387cd37189614 datetime false false false false false false false false 0 7f00758215841d707b4eb3b7bdb1f7cbb4752a95 05cbcd8fafc5638da0efbe52a620ffbf0d6d17af integer false false false false false false false false 0 4dcc8f1c91f65017557f2c3840e9245b21b22937 5b814ffceb1e3c32a4f7d049bbdb00714fd8ea66 varchar(n) false false false false false false false false 0 858797dd1d77830004f9030e960fedcc8fa3f4d5 e7fe7d1c74a9703ea7a1e29120721f1176cb41f1 varchar(n) false false false false false false false false 0 a327f23161a6e1fad764457889fc84600651185b 8cee701ce9202132b8ec5662c63b5c375e7cc1dc clob false false false false false false false false 0 d58d7e14692bb3a537852c764bd0b13909be2167 a2da872da6106c1f9cb8eba2ad45d84139744ee8 character(n) false false false false false false false false 0 1ac0c56274ea3dd84f0a1c22002a44373d216d5f c3cd2effaf1523a2b4762fab9addcb786dfaf1de datetime false false false false false false false false 0 33137e3fab07284df34eba0d850170935559f88b bead1bd59c886dbba243654a0435de41897a6e4e character(n) false false false false false false false false 0 3751f5815571927a4e0256d96332940be3298b32 f63df89c936a59f159170698a25902a7557e204d datetime false false false false false false false false 0 false true idx_sys_msg_push_type cb11ee89c6123c0dc9ee5770735af56cc81c9b07 false false true idx_sys_msg_push_rc 46d552357357e9392306339993963045756b751c false false true idx_sys_msg_push_uc b6c0b7eeb563ed932c43700dfde767999087aaab false false true idx_sys_msg_push_suc 16e3cd493352220f14b79e39d620496e775ebc30 false false true idx_sys_msg_push_pd 5aad5e7593bf81a4a0ffd20ccdc387cd37189614 false false true idx_sys_msg_push_ps a2da872da6106c1f9cb8eba2ad45d84139744ee8 false false true idx_sys_msg_push_rs bead1bd59c886dbba243654a0435de41897a6e4e false false true idx_sys_msg_push_bk 3f61ba87308a18681e25ed3c0f8f89acd60e063b false false true idx_sys_msg_push_bt 7d9a7eae0e2ffc810fa615128b5dab3a613669af false false true idx_sys_msg_push_imp 385ac7698fd3d6123c18f7cd819a83e80313f614 false c58a967b7958dfa2351079a5cf55aa97da99ae82568449Segoe UI916201716 128 128 192 js_gen_table代码生成表 f53f151fcfc0c5008da4d5314a50ef425a61c482 a3c67705fc3d118ba46b7f57c9b24fbf0505d7b9 varchar(n) false false true true false false false false 0 ff1e0ad7d41ac61e908fc5656bdde67a164a6974 c1fb8a292fb9eddf858dd20d28a548c6af66fe4e varchar(n) false false true false false false false false 0 079f2c6d89277b4daecbd337e1bf4f781232976a 971fd03164a8df8dde64dcbc49d25bd9e325b735 nvarchar(n) false false true false false false false false 0 03fa62677d146f929436f5b658fec1d454ec0adc bc518c6e08246711da4ef4bbfd902690ebf6797d varchar(n) false false false false false false false false 0 7302decf65cd29ade7edd5a42ef629938c70f45c b6fb605970d322ce2b1fa51d9b72cdedacd92f27 varchar(n) false false false false false false false false 0 a9b040a1f3059a566ea241c3327fd8b328753c52 0ce662403b57068e13da3bbafac6841d287619a0 varchar(n) false false false false false false false false 0 3c113dc08971de6b9b524afdcb41a1562f130081 7d0c8a848b33bb097d6a6bfb1b223c0699830431 varchar(n) false false false false false false false false 0 705ceee9c058659c1509ef35e6cdd1bedc4422c4 d3257d8d8e063a7b8aab08c53d2ef9c5477e16d5 varchar(n) false false false false false false false false 0 ce338c590e6e91ae174e1728177e527d1fb5a1f8 2e588483efe68d91af1ede163ad51d1cfb60a8eb varchar(n) false false false false false false false false 0 58ee1b25a309334f43edd0e3695be10addd71571 a8f71b15e475b44708cf2638e6d1484c4bf9c5c8 varchar(n) false false false false false false false false 0 dc13101e962883627abb3ca0967353d2d1920ae1 6d2b54ff28dde18b6b574adac48050be8679f071 nvarchar(n) false false false false false false false false 0 b50c10e77abcb30aa7a0efe2b3a9ef080516967a 50929bce3dc6ed9c0d174fe99184428b6b25c376 nvarchar(n) false false false false false false false false 0 edc273602f2feb54b0d9f060c9414873cf0e46d1 34b9c5b33bfbc15bd8c8fbabe2e9e7f970cc9ddd nvarchar(n) false false false false false false false false 0 a7e9e473423331cc2e697d7bad777fab8ea6487a 69eabc90e25d0e1334e2e95c03192aea25a124ec nvarchar(n) false false false false false false false false 0 688b0f7ac0036d32e75f7da7a74d307c976be2ab e8f6148deaa56e9cde72c0ee2f693ba95ca4dcf7 nvarchar(n) false false false false false false false false 0 85024a2953cf3e3c9c1cce49b2351853ab0d125b false true idx_gen_table_ptn bc518c6e08246711da4ef4bbfd902690ebf6797d false 28d6a068ed90b37e3f2ccb30d9c0bd332591bce4542346Segoe UI922201729 128 128 192 13d5d16ad388cc5aa4c3a6c57b1088ee84f7dbd1 c58a967b7958dfa2351079a5cf55aa97da99ae82 28d6a068ed90b37e3f2ccb30d9c0bd332591bce4 -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null js_gen_table_column代码生成表列 869fc70cf3a4e92e8056b40814df8e03f9f9efde 01e9845d82f2f560da299a243b82c82c4d5b9323 varchar(n) false false true true false false false false 0 abd5fc5f0bb213daae3de2abc362c5aea5276f4d a3c67705fc3d118ba46b7f57c9b24fbf0505d7b9 13d5d16ad388cc5aa4c3a6c57b1088ee84f7dbd1 varchar(n) false true true false false false false false 0 9add4a1f079cf3aa4d3da1da358d97f29d976c0d 0d9c0d7416e02ee2fd019e6dc7537ccdf7a518cc varchar(n) false false true false false false false false 0 e8cd4d7657f8c37a71e34f28e71eea3df33bc82f 79241381fe1e3549e1434c88d56601520a46392a decimal(p) false false false false false false false false 0 8ed24661d9998b1972d3eb3f240c93991f1f12d2 8043f3b4e6daa792a13f5ce5b6319c7caa60a72e varchar(n) false false true false false false false false 0 15ef7eb1eb6b56a4cefc4a85913d8d1d1bbe911a 187b877adbbc84967fd4c90a10dbea94de5e3b15 nvarchar(n) false false false false false false false false 0 6f68e29abaf597635078994b33a6f145325f25f6 39b8368fae934c7104ba0343a6816e49e03a156d nvarchar(n) false false true false false false false false 0 a20282cd8e23adbbd4bbeda3ab214076e017ef91 4319d4fdb713f50e8d83a1f09d7945d7683dd916 varchar(n) false false true false false false false false 0 fdf9c3937f0215dcae1a58299485afde19ad799b 4cf8e4f7ab7021ee40f486cdf78f3da437b73e16 varchar(n) false false true false false false false false 0 d7c4eca9ef06061ed7759b05cd050ef4b8c2111e aae6788ed8ece4f35eabce00e75e788011d25d83 character(n) false false false false false false false false 0 e0da8eabac4712b66e3cf284f8be5a8533c31220 78d018f3284fe0ef2b71c4021fa8a3c8848436ed character(n) false false false false false false false false 0 ceaed31e30ef442dc589a113de79bd6a81248d78 47fed38931fcb8074fc07611fb49159af52e4b96 character(n) false false false false false false false false 0 0d830d7889e57b255de5bb649e4f13fc1c369c86 cd2bc61372e843b703bb36608cb58be277490a8a character(n) false false false false false false false false 0 31a7568881d922441d4dbebe5a6143735995ed3b 4651283ace05a6d80c5bec1ef610652216d21f84 character(n) false false false false false false false false 0 5174c7a0354ffa29e89aacf71d1b96e56f78b1fb 39d25d5df5b30a2486b7c492fdfee3bac08cddeb character(n) false false false false false false false false 0 b51b6ef27d586f8267bfd6bbf27a0858e129fd8d c4a768c9651f672727c4e10b81630aacab28e297 varchar(n) false false false false false false false false 0 1f28b66ae37ff660c2675ba152dee6b728f083d7 8132085f47b3d204c18ba3e2aa249225cb37d9b2 character(n) false false false false false false false false 0 ab96e97ea0fa572ae6c746aec5e8dd94569f053a f97e35c4ba758bb04138029605d0525d59786d62 varchar(n) false false false false false false false false 0 688b0f7ac0036d32e75f7da7a74d307c976be2ab 41b1918e7b74391852096cc8a204eba329cfb721 nvarchar(n) false false false false false false false false 0 false true idx_gen_table_column_tn abd5fc5f0bb213daae3de2abc362c5aea5276f4d false f151f987251ae4e9949b5ed48822458897360e0b152354Segoe UI975528 128 128 192 5c633b8026bdc419fe015e88d5a2e8c2622e7f1c 26e4b2554a744e584fba5f3b88c267026359e727 f151f987251ae4e9949b5ed48822458897360e0b -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null 613b4e66f8fbad7137b2110be806eb26ebfd1129 f24ec280de439487a7e35a62e11a445e7adbd9b6 f151f987251ae4e9949b5ed48822458897360e0b -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null 4c04a7a14b8549b8df50dcb17c7aaaf5c0e55c28 6615f2ce0ec05caf1a51f92d1c2b458984ac9db6 f151f987251ae4e9949b5ed48822458897360e0b -1 -1 -1 -1 0 0 0 1..n 0..1 true RESTRICT RESTRICT null null js_sys_employee_office员工附属机构关系表 869fc70cf3a4e92e8056b40814df8e03f9f9efde 91144e8cf1e444a22927928570fe34654e444bb4 varchar(n) false false true true false false false false 0 5eed2939e1d63782c6ef3363e98724114c4a5f6a ab8b402ea35a78cdadd5ed446d571c9a80b532ee 5c633b8026bdc419fe015e88d5a2e8c2622e7f1c varchar(n) false true true false false false false false 0 afab752045817ecbe4149d93bee23e784ce89a0b 512f24dbe486a211117dfb58e689ef3e0e5009a0 613b4e66f8fbad7137b2110be806eb26ebfd1129 varchar(n) false true true false false false false false 0 01a869279c2c0890d8b66c49ffee318db227eb0f ed19c91e49d39e19cffec01c77c369cd2ea1c989 4c04a7a14b8549b8df50dcb17c7aaaf5c0e55c28 varchar(n) false true false false false false false false 0 f6a8962b7fcb6101a25612849c208419604d342c984586Segoe UI91656384 128 128 192 js_sys_role角色表 0939f982d8d703b2e27b802da88b1ba1eeb11c63 22d38cfee95536d3e3af5fdd444b027a85d95432 varchar(n) false false true true false false false false 0 bf04028c4beab99e1c35c6a22ffa6f9b745a49f5 ecf6453361ea95112d99a48d499d245033596daf varchar(n) false false true false false false false false 0 261201b437ac0f92fe52da10902425f2391f0fa8 6bd0ef3540d4ec60b76dcbf8202a929fabb20f1b varchar(n) false false false false false false false false 0 f7482b471418bdd790ae93233367f1d6315506ed 1033b538c81cfc078c51eca175cf765d88459b30 decimal(p) false false false false false false false false 0 7feb27963741f108bd29ccf401a0f25ec6f588ff 39019eef1ff9876f6e75eb44e94aa9e4d8e79523 character(n) false false false false false false false false 0 b395e79cb48e870a827a4ea6436f7d00c2f18111 86b833a3be962a3cd6e79502f72d48b455bf247d varchar(n) false false false false false false false false 0 1b0f1b3a4e3073d84bc2c8406195d3eaa5276c19 00a708c89cdb80f2a937084230260e35dc689c4b character(n) false false false false false false false false 0 9c7b6cb6e8190ee30301f5046f6caceb0d9914d0 ca48faffcf40d18afd892ce5378f1b17aa5eb785 varchar(n) false false false false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd ea920cba2fe0eaee64a2310ece7cda4b198b37ec 118dab95fc1f792cd468b9f66af2d4fabd98c39b false true idx_sys_role_cc b8ea4b73d6d32a222e5abfd453287575ae518480 false false true idx_sys_role_is 39019eef1ff9876f6e75eb44e94aa9e4d8e79523 false false true idx_sys_role_status f0036584bd8711715579d21994a0105935605a7e false false true idx_sys_role_rs 1033b538c81cfc078c51eca175cf765d88459b30 false 8a139a0643de7dcb7489ba3a6eb8072830e2442c906470Segoe UI91082340 128 128 192 b0046026a86b96d1e93facef0237f3f72c3a6460 d6c60af63d4b54ff24149a17b7dbef6ba492e484 8a139a0643de7dcb7489ba3a6eb8072830e2442c -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null js_sys_file_upload文件上传表 869fc70cf3a4e92e8056b40814df8e03f9f9efde 71026cc36a892284987749f2f04c4f5b738353c1 varchar(n) false false true true false false false false 0 fc44d466dd6009e48b5222d1d71e38d025194ff0 54b86f255d95078898534902087fb704b4265b60 b0046026a86b96d1e93facef0237f3f72c3a6460 varchar(n) false true true false false false false false 0 7295c82faa1ac317a2e7b0e11fbc9b7f8a1bc1e4 10026ba39b384fa6e488e2777d16d4ac77f2c32f nvarchar(n) false false true false false false false false 0 474216e9f34d3d238da54689cd04d32e20a0a4bb 466c16fcce3610b3418c8168beb22289be9636ec varchar(n) false false true false false false false false 0 91535d1fca32e48c6db699f421f606a7eede469a f5d76e04be30a5d8d04611203aa57ae272827d59 decimal(p) false false false false false false false false 0 667704664e4b88b145cebda0d6a1fbafb53525f0 3ecd22c0c0d34b181f09931a092d0a8de161bf15 varchar(n) false false false false false false false false 0 4f9a5bc4fccb64cfc3a35f9209c9ce9bd044a6b9 9a3684fdb82233df73bc0aa62e2a6d4dad926c27 varchar(n) false false false false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd 118dab95fc1f792cd468b9f66af2d4fabd98c39b false true idx_sys_file_biz_ft 466c16fcce3610b3418c8168beb22289be9636ec false false true idx_sys_file_biz_fi fc44d466dd6009e48b5222d1d71e38d025194ff0 false false true idx_sys_file_biz_status f0036584bd8711715579d21994a0105935605a7e false false true idx_sys_file_biz_cb c391a15752a8eb58bc558a39d1b431f7ee125e0e false false true idx_sys_file_biz_ud f8ea4fc4a778a0b94398a661a1ed8608f0e8d28d false false true idx_sys_file_biz_bt 9a3684fdb82233df73bc0aa62e2a6d4dad926c27 false false true idx_sys_file_biz_bk 3ecd22c0c0d34b181f09931a092d0a8de161bf15 false 26e4b2554a744e584fba5f3b88c267026359e727438383Segoe UI9515468 128 128 192 45922c254c3b94aa89bf37d0dd2f3c7665aabcc2 e358008a1c9b84f744e89039339ba56765fe34bd 26e4b2554a744e584fba5f3b88c267026359e727 -1 -1 -1 -1 0 0 0 1..n 0..1 true RESTRICT RESTRICT null null 1f685cf44fc37577bc9d75f175ec6820d986117b f24ec280de439487a7e35a62e11a445e7adbd9b6 26e4b2554a744e584fba5f3b88c267026359e727 -1 -1 -1 -1 0 0 0 1..n 1 true RESTRICT RESTRICT null null js_sys_employee员工表 0eb719cd3d6524bc3778d73c3634c1b976baa3c7 ab8b402ea35a78cdadd5ed446d571c9a80b532ee varchar(n) false false true true false false false false 0 125f4be73b069fa39d11d391ebc30169bb835827 e0ee6264e4415cc7d534335a38f6dbec62822900 nvarchar(n) false false true false false false false false 0 46d0f56aace23d853693d4e581e9904d463b8860 28440c39441334f1eacbfa49440ebfc746edbada varchar(n) false false false false false false false false 0 c3398bbf1c346a338db14449fcb9fa2f6c70f372 d46df317a3e234d6fa23d149f1b0e61126beaf92 nvarchar(n) false false false false false false false false 0 b0ac1bfb9a465a46257d8e043e8d0370feb0ee7c 512f24dbe486a211117dfb58e689ef3e0e5009a0 1f685cf44fc37577bc9d75f175ec6820d986117b varchar(n) false true true false false false false false 0 2b8439b512c0d6df70ca5f7c65bfd30a32def655 2f53aa3a1613598e128ad9cab02374b32d9bf70b nvarchar(n) false false true false false false false false 0 76ab6ac096fb9c9be7bf61df683ce21a3da0c33d 5ac7f3a7a755a58e6119c8d4922df644559e632f 45922c254c3b94aa89bf37d0dd2f3c7665aabcc2 varchar(n) false true false false false false false false 0 f0f47249781a8c1e655ae11236426b788f099fce 653e75ecac41402f2d2bcea19230b9cb17536776 nvarchar(n) false false false false false false false false 0 cf949a5f8d12902f0a8384fa68c72f55e6136812 ebe0900f7c091a4c0c47ec7fb29f4a9d586cf74b character(n) false false true false false false false false 0 85024a2953cf3e3c9c1cce49b2351853ab0d125b ea920cba2fe0eaee64a2310ece7cda4b198b37ec false true idx_sys_employee_cco 76ab6ac096fb9c9be7bf61df683ce21a3da0c33d false false true idx_sys_employee_cc b8ea4b73d6d32a222e5abfd453287575ae518480 false false true idx_sys_employee_ud ee78b079f7d319bf8119fd01439cd97424ff49fa false false true idx_sys_employee_oc b0ac1bfb9a465a46257d8e043e8d0370feb0ee7c false false true idx_sys_employee_status ebe0900f7c091a4c0c47ec7fb29f4a9d586cf74b false 0ded13a505cc3bfde24edfbae369231be192a59b1283520Segoe UI996836 128 128 192 9a24a5fe2b90473016e496df5121ad7b1f2cfe4c 26e4b2554a744e584fba5f3b88c267026359e727 0ded13a505cc3bfde24edfbae369231be192a59b -1 -1 -1 -1 0 0 0 1..n 0..1 true RESTRICT RESTRICT null null js_sys_user用户表 72cb012455ead4444ad451f28f6bac51ad9b5130 e59481cc0025d4da3d55201ee470c33b2c12a575 varchar(n) false false true true false false false false 0 b6a52f87ba533a819eb169768b846266226d641c 4a7e78125c8684dc6f98b67cc49e4600866da601 varchar(n) false false true false false false false false 0 17cc9c14f8fd31cc61e610dda56a2948f5b8266e 54e129fdccc85d57a91f4b26761f017a7b22e8f0 varchar(n) false false true false false false false false 0 747d0db2fe9de2a328a1f39ef6a11a915afada04 f4ca0ea98363e69ea86e53f92ee70978245388ef varchar(n) false false true false false false false false 0 329bbb76f0884117ace79bb686695f4e9cb120b6 b26b503c2f877d3c0610ba8e6852be92620a3d49 varchar(n) false false false false false false false false 0 04844023ecf0480ce786e53a5246e93cc875987f 620cec0bfffd079cada15bb8d5f7f23ef8717109 varchar(n) false false false false false false false false 0 73f7a37e9b9d7dbfe21646c4fab3347a7d204913 cf2697e60824d45e6e66a9ea985717d2b8841131 varchar(n) false false false false false false false false 0 b63e72d00089330f9932863eeb972e87d94cabce c301c85a224df4e7ce77ca09bf4b6f2e50b50642 character(n) false false false false false false false false 0 c138ba567a58d48a0a7a6e7cb56d33c1dc38b17c 32945a48787fa20f4b0b4133a85dcf18fc9e47ce varchar(n) false false false false false false false false 0 4551bd6ffaf84e43ffaaf7fa7ec5a46c37935f24 19d69134b891c06724cdad70e4fd14312b978e1e nvarchar(n) false false false false false false false false 0 5537317393b9e8a86c73daf8d584ace898c0d267 0a1fff9c46e4ea49d99ed9a7b7681391af3607ee varchar(n) false false false false false false false false 0 8738d2bb42a1224d22235ec41e1358b890a50955 2490bcd7f26c115f7adabda428129e87783211c0 varchar(n) false false false false false false false false 0 1c01776985dea9bd14e14cb8a97ab836bb4871ee f2136ede82ec814cf359a6e4f74b8de48338516b varchar(n) false false true false false false false false 0 f22a1cfec76101d87da3a951bb05d7700418c1c1 ab8b402ea35a78cdadd5ed446d571c9a80b532ee 9a24a5fe2b90473016e496df5121ad7b1f2cfe4c 用户类型引用编号，例如如：当user_type为1员工的时候，ref_code关联的为emp_code 用户类型引用编号 ref_code varchar(n) false true false false false false false false 0 f95a0e3e0b66048e979ae0488e387f09e1c94f50 662dab21d6bd0ae2d75bec66ddb34790d579d565 varchar(n) false false false false false false false false 0 a960c1b4db1c00820c60b00152ddb17ef23fd0b8 6eb87d824bfedf47085bce06da8006148c601c9b character(n) false false true false false false false false 0 cd995bcf9d5a67f471bb214c921b8b229de30767 9de6b3b40e6c17d2f9214f7871889c228d14ffea decimal(p) false false false false false false false false 0 9ce384c009a431f01fe6840373567782fab32249 f99f45da94370a47298447010dec4ae231dbb779 datetime false false false false false false false false 0 89226cf84f03f0a56ec7adcbf4781049b97121f9 7ac242ca565ca0b0a0ecffbe368aca76fe23dcfc varchar(n) false false false false false false false false 0 23d9751f44d62a87de371c36b52664bec7e7815c de9b948748edf1d767e92d5d379d2a579702e1c8 varchar(n) false false false false false false false false 0 7f2a6a606ce3ff27a3778bacc036afb74d3b7346 f33c455810ac391cddb65c8c3d939e5007945e37 varchar(n) false false false false false false false false 0 8026c23bd056a83798a77e010c2b810e6738f1fb 6d0fffe12130e4430a4b007f3c8d65ba42acd01c varchar(n) false false false false false false false false 0 347c6496b6dc5e98d61a159e55f8aa8b847f3fba 2e621caaa75bf294661856f123b945ac50f3b0ae varchar(n) false false false false false false false false 0 dffce782b8e0d921036feb32eb8137a84a937de9 e71aff805f5202b16def2bea0ba95e132559b204 varchar(n) false false false false false false false false 0 6986b6de1581af248bdcdc6fc9e5d2f300c26c14 b5eb7a2850f2b31c0766b4f58e97a19ad9f8f46e varchar(n) false false false false false false false false 0 8c9ea8f33293f42f4bdee7a8251152567a4e731d 3e6071509571b1f7b649afc687f8fde46f884585 datetime false false false false false false false false 0 01dfcccb43a2647979ef648912e43b8982c0cf42 f900cc3efaa636755391acd8c539d790e37d01f3 varchar(n) false false false false false false false false 0 2c9ac39dfb195a0768ec52f0b2a3e96dc3575819 cbdf583d25790f552e2714bc6c88908dae42948f datetime false false false false false false false false 0 2492476f4d92ca4051cc9cd883c427585bd01a7d 2ece1cf7fd02751a2a9b462401909610f3b637ea datetime false false false false false false false false 0 c1d6e02f5f9a31d6a494f646bbff8479fa3f52b9 ff6668e0065bce65ac23f86c1db19bd619baed10 varchar(n) false false false false false false false false 0 5cb9825e5780cc2b9bdfffc62b843892cec567ed becd6c448ab4475068df58270f59642e68921951 decimal(p) 0 false false false false false false false false 0 b2b945d048896baab43ae931af786e910224b43b 40e6f855e21171ce241d4e842703cfeb439d61a6 char false false true false false false false false 0 85024a2953cf3e3c9c1cce49b2351853ab0d125b ea920cba2fe0eaee64a2310ece7cda4b198b37ec 118dab95fc1f792cd468b9f66af2d4fabd98c39b false true idx_sys_user_lc 4a7e78125c8684dc6f98b67cc49e4600866da601 false false true idx_sys_user_email b26b503c2f877d3c0610ba8e6852be92620a3d49 false false true idx_sys_user_mobile 620cec0bfffd079cada15bb8d5f7f23ef8717109 false false true idx_sys_user_wo 0a1fff9c46e4ea49d99ed9a7b7681391af3607ee false false true idx_sys_user_imei 2490bcd7f26c115f7adabda428129e87783211c0 false false true idx_sys_user_rt f2136ede82ec814cf359a6e4f74b8de48338516b false false true idx_sys_user_rc f22a1cfec76101d87da3a951bb05d7700418c1c1 false false true idx_sys_user_mt 6eb87d824bfedf47085bce06da8006148c601c9b false false true idx_sys_user_us becd6c448ab4475068df58270f59642e68921951 false false true idx_sys_user_ud ee78b079f7d319bf8119fd01439cd97424ff49fa false false true idx_sys_user_status 40e6f855e21171ce241d4e842703cfeb439d61a6 false false true idx_sys_user_cc b8ea4b73d6d32a222e5abfd453287575ae518480 false d6c60af63d4b54ff24149a17b7dbef6ba492e484256397Segoe UI97322520 128 128 192 js_sys_file_entity文件实体表 06c8c06de2e755ce212c5bc885d60c2258ed1582 54b86f255d95078898534902087fb704b4265b60 varchar(n) false false true true false false false false 0 ec29482dfd36942ef1e387a971d5369769998532 43456d1adb849472d81f93cd41bce296bea397fb varchar(n) false false true false false false false false 0 680182522ef3e840e233d3245867576299b4f93a e3cd211a088bfdbd2191f48258e13467f2ffcf8c nvarchar(n) false false true false false false false false 0 1bd41a312e06683ca045e5888d200e0b78f34eb9 2dcc1d71db1ea31eb1662f7adcadecfc29fc76b9 varchar(n) false false true false false false false false 0 7a27c52b873302f4200abb336291da16d67e971c deab0106de802419404e653b526b7cc4d38339d4 varchar(n) false false true false false false false false 0 4f74582c7985a857816f60e5cb57e552173d6786 db462e1b37a2d6bd5111a1ae2c1315cf186c5ded decimal(p) false false true false false false false false 0 e2e0369af3191a268fc1d03ea0eef107d0392be0 c1a441e7ef57c97818f59db365d7162fda7cc0df varchar(n) false false false false false false false false 0 1b5310d274dec8e27515ab91eb99537ee0d2a855 5014e5352b66ce51adc502d6628c87a0294ae63f character(n) false false false false false false false false 0 false true idx_sys_file_entity_md5 43456d1adb849472d81f93cd41bce296bea397fb false false true idx_sys_file_entity_size db462e1b37a2d6bd5111a1ae2c1315cf186c5ded false fe9991829b27dafb45a95e13b6e9dd724b3bf424308335Segoe UI93897792 128 128 192 js_sys_lang国际化语言 869fc70cf3a4e92e8056b40814df8e03f9f9efde 58d907ff9cf0c81b565cad158f3bec8b3758d59e varchar(n) false false true true false false false false 0 c2c68b3979b0c52109cb085c491bebb415a189b4 669456aef17849070945f58eba9269628ad31cc2 varchar(n) false false true false false false false false 0 2392b56eaf51ec9f6e32fe6553460d25b3da9729 1832e034e60a8176274736a921861da8f4a17b1f nvarchar(n) false false true false false false false false 0 26c952fa648f51d2350f628195fc098f918d8149 923b79d81325f08f9ef6d6cc4302024dd0717bad nvarchar(n) false false true false false false false false 0 26bbe2ffbcc2678b0691f0721632c3dcdabfb4ff b3438798385ef62434d0cdef3d6d9fa7a63e313c varchar(n) false false true false false false false false 0 85024a2953cf3e3c9c1cce49b2351853ab0d125b false true idx_sys_lang_code 1832e034e60a8176274736a921861da8f4a17b1f false false true idx_sys_lang_type b3438798385ef62434d0cdef3d6d9fa7a63e313c false bbe68e376638ab208682d127d252c38bb6c953a51244617Segoe UI9229236 128 128 192 js_sys_menu菜单表 adba31cfd94479f79feda2a3b90cc1bac3eed99f e84c40cdf5ffdb2ba4d59630d98abb5972d74795 varchar(n) false false true true false false false false 0 a535b6c506004a7fdf4d48984c9ff2cfa59c157a d5a4d04f60ce748f15b651a78cef47d1a14e19fa 4a02b55091ae2d39146d66ec12708a3121efc3bc varchar(n) false false true false false false false false 0 f22f8e8ec4f9a9edfc3a04de5c62d4cb485a0f82 c1a08754015d02b0489f0432d1a4f13db0384b71 character(n) false false true false false false false false 0 61ecd8a2f562b6c7540d73935c5ab7672d3f3bfc 854fc4de71470d2d019c5c2a0dd235e163bef43e varchar(n) false false false false false false false false 0 bcf07d65d41b82a0a96dc5da4faa8d4a2c52e3e9 95e937df6fffbcf8bedce5154965f2c8e7e1acd5 varchar(n) false false false false false false false false 0 1e3adac597a8668830a11c2652cc6adb661d941a 8f4fdd0a58a54d8205bf97966cc40375dc70c686 varchar(n) false false false false false false false false 0 17699b17170db6b9ffcf6ffd332fc0cfc983d8ac 4dfc3dbfd65c3c232d1e9321d6b7935389dbf566 varchar(n) false false false false false false false false 0 e6d37962edd3a1eefde9a3795406fdd36887f1ac 1aaf5f494723fa4747a006d991ac2e7f9cf2505f varchar(n) false false false false false false false false 0 324e1ef832db227483e8f52111e219a2ad94f67e 6423930cf5b3415930abb45c9c48fb991e2cf842 varchar(n) false false false false false false false false 0 5046a82641c7b483c20812028106e771891fa8c0 2f21e992c73004d22b4752787472c75e4ed6944e decimal(p) false false false false false false false false 0 a5e7e1443b21fe207b79ab4300b2ab90bc8a69ea 30091097be5bc88ee6a9e4f8b5ec175078df2576 character(n) false false true false false false false false 0 e0509c4cf92246c64c1f44892e866378cec1ee30 5ed51fee1299bd1ebc9f45127534fc806d0ab8e1 varchar(n) false false true false false false false false 0 538b3f250c5594f837120b38e15103b7f1730d4a 18d4616b20d068ccad4ecb854b2073ca2458b8df varchar(n) false false true false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd 118dab95fc1f792cd468b9f66af2d4fabd98c39b false true idx_sys_menu_pc 394369b90c0a5b6efeed3cf823c642605d7a1653 false false true idx_sys_menu_ts 23f973124aedd0244533f4e7b3b103c548b966be false false true idx_sys_menu_status f0036584bd8711715579d21994a0105935605a7e false false true idx_sys_menu_mt c1a08754015d02b0489f0432d1a4f13db0384b71 false false true idx_sys_menu_pss e8d877396943acfec73023dba2c1c6e3d7802d62 false false true idx_sys_menu_tss 984d5eac2b3221118a61655e4a5a49c78e0f0151 false false true idx_sys_menu_sc 5ed51fee1299bd1ebc9f45127534fc806d0ab8e1 false false true idx_sys_menu_is 30091097be5bc88ee6a9e4f8b5ec175078df2576 false false true idx_sys_menu_mcs 18d4616b20d068ccad4ecb854b2073ca2458b8df false false true idx_sys_menu_wt 2f21e992c73004d22b4752787472c75e4ed6944e false 08fbafe09b62772cf1c9f93979c41d74b3809b1f1166387Segoe UI9340824 128 128 192 e361a3cc6a03641a648b02657f9eed115301b76f baa54d8a660b4fa684a97d8dd288d1edcf52ec5a 08fbafe09b62772cf1c9f93979c41d74b3809b1f -1 -1 -1 -1 0 0 0 1..n 1 false RESTRICT RESTRICT 4f8af0766a0ba0866db74d9fe750581d1eefea91 null js_sys_dict_data字典数据表 32c7f5bb206f025610dd8211c6d397ee4845f3a3 424e7476db4a216fdf3eee470ce921c356f07e5e varchar(n) false false true true false false false false 0 a535b6c506004a7fdf4d48984c9ff2cfa59c157a 9ca0e5536ea6174629b791183977dcc92c13f908 396fee69de4e5229fae2bbdd0501e98cb740bfe5 nvarchar(n) false false true false false false false false 0 cc294effb178877401baf60d266faff21b80c5ea 99f4c815f19a4256e44625dac3423eaba8f23da1 varchar(n) false false true false false false false false 0 a4c755ab584ef5ca499f4e3412caa6d99305b36e 12111b66aa47de5aec6126db15dd7ec2bc35ae83 varchar(n) false false false false false false false false 0 2dbcbafe51e51ecb4546a0ebfe8767536a1eaaa8 4f8af0766a0ba0866db74d9fe750581d1eefea91 e361a3cc6a03641a648b02657f9eed115301b76f varchar(n) false true true false false false false false 0 7feb27963741f108bd29ccf401a0f25ec6f588ff 0baae707c361b3286955f0587b34476fd4f36cfd character(n) false false true false false false false false 0 b3d67ac6d9320b61db546035ec7c8e487fd8a9c4 41906c8f63b3a63fb41393d75e45d10a247e492d nvarchar(n) false false false false false false false false 0 1310f67a2772a72e48216c23deb7f7e7ef6f0041 645203ee29b1ee73a7f0d5e9878b4227a8b7302c nvarchar(n) false false false false false false false false 0 1f24bfd07483cf3e59f6ecbd4966755d9670df74 ac7e17e899d099929e517e74f7a116c939840895 nvarchar(n) false false false false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd ea920cba2fe0eaee64a2310ece7cda4b198b37ec 118dab95fc1f792cd468b9f66af2d4fabd98c39b false true idx_sys_dict_data_cc b8ea4b73d6d32a222e5abfd453287575ae518480 false false true idx_sys_dict_data_dt 2dbcbafe51e51ecb4546a0ebfe8767536a1eaaa8 false false true idx_sys_dict_data_pc 394369b90c0a5b6efeed3cf823c642605d7a1653 false false true idx_sys_dict_data_status f0036584bd8711715579d21994a0105935605a7e false false true idx_sys_dict_data_pcs e8d877396943acfec73023dba2c1c6e3d7802d62 false false true idx_sys_dict_data_ts 23f973124aedd0244533f4e7b3b103c548b966be false false true idx_sys_dict_data_tss 984d5eac2b3221118a61655e4a5a49c78e0f0151 false false true idx_sys_dict_data_dv 99f4c815f19a4256e44625dac3423eaba8f23da1 false 6e311fe2f6304c9e7fbc7e734d9b6e2dbe0144d2386383Segoe UI924242414 128 128 192 js_sys_health_check系统健康检查 869fc70cf3a4e92e8056b40814df8e03f9f9efde 903225e50be8c13dd9607b80b238e5689ecf425c varchar(n) false false true true false false false false 0 a08bfaf64f7f083d4150eb89f91545da11aea32c b651f63db113013221940195d72f8742c6aa080e nvarchar(n) false false false false false false false false 0 471884a5e2033e41803feef5822bdd0fe52abe3c 13be59535841c33bdf1402552eb15a4f40dbf8d4 nvarchar(n) false false false false false false false false 0 7eedb24c45d73dd56887eefd7e438528fbf4cf10 9ea3d2ee0c298406c51bc1452f706153ae4b005a nvarchar(n) false false false false false false false false 0 6c2473c9a63d2ad405655d7adff7591d6d6c532c e36b0b6edc64bd0f397c41372a501c3e1426f65c datetime false false false false false false false false 0 cac7cfc71f4053cb77cde93a010175137825a041 0fcf0332920224c88dec71a0ffecaf688b60e48e decimal(p) false false false false false false false false 0 cae139cc445b5d645601b0ef865245c1a57ac0cb 3cfa7de8639e8f7f1ddf28638698ff90818bb0fc character(n) false false false false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd 525b18e0d2c940bf132733cfaba411fb84ddf255412426Segoe UI913202388 128 128 192 js_sys_job作业调度表 70abca97f16eab0d562a2104ec1a0ede326b1c46 55c7d0a9ab8650c264a75bb1bf958cac2fe68152 varchar(n) false false true true false false false false 0 2fe17467ad48944f125de4abf28e973234a9bcb4 443772d4627c23aef484c324c8e431121b921a44 varchar(n) false false true true false false false false 0 6cf6b1b94ad089cda04f9ed8ea2ad13bd9de0dd0 225e6d868b8d45320dc7f79db6296db64985b308 nvarchar(n) false false true false false false false false 0 e2663716e6af40682333d3e8495a04bceff16647 c5abf897611d8a927582d1dcb3deceef5c164614 nvarchar(n) false false true false false false false false 0 03debcf1d4bf27cdad9acd24fda84a6ee9cdd908 d8ece7f15423d813de0dc100fa1c67e047ca4a08 varchar(n) false false true false false false false false 0 44ce4edd5ad45896934d6f90f14af5884b98ba5b 7041a843a37e89ce935ad9309fa1a3b2548920e5 decimal(p) false false true false false false false false 0 261aca14bc2dd0bef97fa78a1256a95b5cb94171 91c2e73c20940e4a715ffb02148e2f3a1bb72334 character(n) false false true false false false false false 0 f69037f9c9f1c4e8dd771b537b5cf3bc26d7ac3f 599b9798d287db98af97bda02a378aa97b0c62c4 varchar(n) JeeSiteScheduler false false true false false false false false 0 481c1a6225e0f2a86dbf4f752e9455afac57f897 644c88074f6f9cbe4b29b12b9633f4e238a2761b character(n) false false true false false false false false 0 85024a2953cf3e3c9c1cce49b2351853ab0d125b false true idx_sys_job_status 644c88074f6f9cbe4b29b12b9633f4e238a2761b false 5fc45ff72e5a63eee633a54948970a8c9e0d17fb542563Segoe UI929402316 128 128 192 js_sys_msg_inner内部消息 869fc70cf3a4e92e8056b40814df8e03f9f9efde 5eecd1e4e1dc132da52de1bd1f59b13dd13a3587 varchar(n) false false true true false false false false 0 a304841afc9968e7c8768979fe2ba3f2f315db78 cbbb279fbb0f0ea5d67536332ce7d9a8b3d70e36 varchar(n) false false true false false false false false 0 a654ac8de54e8c19cfdba4bcf6d636ab760799b9 04c3905ff7bf6c16dbe32569f226a3cbaf2674fe character(n) false false true false false false false false 0 31410c3d884588423ca2a5803e78d0934412f458 10a8ef0d67bd3c9a90e9c67dc86953fefb8f8755 character(n) false false false false false false false false 0 98eb079aebd2f56c461cb92d97ab4d56f603b840 48bf7c9cb90d62b9cba0283d51bf94980e9fea92 clob false false true false false false false false 0 0fa4e2d76aa9a87670cb1345202c5fbc44183cfe 5b256d59f963bf2a76cf35c847634b1188154874 character(n) false false true false false false false false 0 5797ae3ca5da40a8a45dfd0071f3589585c2517f fe9b7e3236d284db50cb1d4cda9a77d1d8de40d2 clob false false false false false false false false 0 86b915810d6436eb5c60062abbe4f8910c86f89c b21a2db1cf685edc44c2bf252785aabc4cfb0794 clob false false false false false false false false 0 c5364fcf3327275d038d229e22f80ce97c28d402 b0959f0c2f737aa49188e57cc71afb3242e9e97b varchar(n) false false false false false false false false 0 949f48cec7229094875af06d5c3ee4e7efbba1e0 8d09d0b4b174964fb858b7ccb77ed9e14767de65 varchar(n) false false false false false false false false 0 5e197b7f106763a6952e72203fcc902cea793853 d492c41633035ed8c33c89c5c704ef2dd5d7d32c datetime false false false false false false false false 0 da74a37a1025119cd79a05644781c76b606352d3 0390e069a393fa7b2f2de0531b12470c299317f8 character(n) false false false false false false false false 0 81e89a36c985a9f69710177677cd7be6ed6ea089 fd262e1d867fb854931a86728233eec74fc0099b varchar(n) false false false false false false false false 0 20092a8f08bbf1304383014693172e4fc863277d 6d885df5f4956aeb6b228e769b8d037459d7a7d7 character(n) false false true false false false false false 0 85024a2953cf3e3c9c1cce49b2351853ab0d125b false true idx_sys_msg_inner_cb e5355faba5ec3c9128507dd4c48ea9230631cf83 false false true idx_sys_msg_inner_status 6d885df5f4956aeb6b228e769b8d037459d7a7d7 false false true idx_sys_msg_inner_cl 04c3905ff7bf6c16dbe32569f226a3cbaf2674fe false false true idx_sys_msg_inner_sc b0959f0c2f737aa49188e57cc71afb3242e9e97b false false true idx_sys_msg_inner_sd d492c41633035ed8c33c89c5c704ef2dd5d7d32c false 845c82ebd869d5620b1ef2c2b6f438b11a045082 BaseEntity 869fc70cf3a4e92e8056b40814df8e03f9f9efde 02ecedc0de5850cba25bc91919ed39d414b74111 varchar(n) false false false false false false false false 0 ba0fb53af3ccc8b0e5d73baa58ec27fbb7973097 2fe6a36385238c1b21c76deae00a7afa00ff5538 character(n) false false true false false false false false 0 ea920cba2fe0eaee64a2310ece7cda4b198b37ec BaseEntityCorp 136ca02f1b3a96a8f2e242d5dd64d48f566143ef b8ea4b73d6d32a222e5abfd453287575ae518480 varchar(n) 0 false false true false false false false false 0 f116706ac00cd3a3ee88b2a88debf7ebc3eeb12d b94f5fe344185c40739cf93d1090686001bb11e0 nvarchar(n) JeeSite false false true false false false false false 0 35ae805d1da92afdb99b2fe8c536d1649356fccd DataEntity 17718c2364a2368c2072da279c927d7ad3bfcf08 f0036584bd8711715579d21994a0105935605a7e character(n) 0 false false true false false false false false 0 1a3b3f8bccfce8894d117d6bdb0a6b104bfb80ef c391a15752a8eb58bc558a39d1b431f7ee125e0e varchar(n) false false true false false false false false 0 dba1aec0c72d79ea73ed4ebde07696cf4df174b7 e2e82ba86e15fd67397355e711255b1625078ae1 datetime false false true false false false false false 0 2c6b290f30c6f9e100f6c77eab0cba7bb3386768 fd0546fc2d4e01c35dcbc23913add68a99fabd73 varchar(n) false false true false false false false false 0 f0bdbc4002f4a1b7fb7c5026bc21a7689c549728 f8ea4fc4a778a0b94398a661a1ed8608f0e8d28d datetime false false true false false false false false 0 8f7d3761c17a1b8632d186a3c67cb08dca18c498 69e01b6d4f42df40a09540ef4ba10ed8e006abaa nvarchar(n) false false false false false false false false 0 85024a2953cf3e3c9c1cce49b2351853ab0d125b DataEntityNoStatus 1a3b3f8bccfce8894d117d6bdb0a6b104bfb80ef e5355faba5ec3c9128507dd4c48ea9230631cf83 varchar(n) false false true false false false false false 0 dba1aec0c72d79ea73ed4ebde07696cf4df174b7 6bed374c39d181003a4f92d76d79a4119176ba0c datetime false false true false false false false false 0 2c6b290f30c6f9e100f6c77eab0cba7bb3386768 f9db19bb567760bbdd554d75bbfdc891c89f9da9 varchar(n) false false true false false false false false 0 f0bdbc4002f4a1b7fb7c5026bc21a7689c549728 ee78b079f7d319bf8119fd01439cd97424ff49fa datetime false false true false false false false false 0 8f7d3761c17a1b8632d186a3c67cb08dca18c498 f7b88ecec0ef386bb384c228842a7587432112fb nvarchar(n) false false false false false false false false 0 118dab95fc1f792cd468b9f66af2d4fabd98c39b ExtendEntity ad6f9eff50476669df62b7601cbc3a2e0c905d36 6ccadddab6ce48441ca7abd798cda6f3debf4a0c nvarchar(n) false false false false false false false false 0 3a24133d2be4831e99d1319983e5393bcf964ff9 93ab0ba3b47b01934614dbd3e572358c9f99e6ea nvarchar(n) false false false false false false false false 0 40e1afbbad28d28e371dd1ab77fb56640b1cb66b a78c7961910a5e697027d1a3530b1afaa8ea8c94 nvarchar(n) false false false false false false false false 0 a2d6b5a494fc1a3d29360d922296521c6640856b 40085364ec7a58653e96f8659aadd258d7556bc7 nvarchar(n) false false false false false false false false 0 29f701cc6a308fbfc5b12b80fee621ceeb231dcc 9787d7fe93ee31c5b4979fd620ff6e4b2777eccf nvarchar(n) false false false false false false false false 0 c9a37a7b6a5451930ca63e36814767f742cd1393 95c55b81b7e9e1a9bb01aa3d88fb90c648641c4e nvarchar(n) false false false false false false false false 0 8c26203d310a4e602cf0c0fc8a7b2c818219c1dc 16f44dfc7964796f109293bc49afd58dcb4eec1f nvarchar(n) false false false false false false false false 0 54448f19b0f5d1630bf29f9f99787802c36ebddb 39b1dffa083f74afc30df621845cf7f0ed71394f nvarchar(n) false false false false false false false false 0 a1d747cd40768ac9f85176518ee48cb513bae110 7584cc6360ae7edc99e1f619042eba5865b2c4c7 decimal(p) false false false false false false false false 0 a9f0e14d6691c397990abe4ef1ff21674dccf401 f0b5383e05c6b3f6e5f65b33b33009826c83d014 decimal(p) false false false false false false false false 0 2ce06c5cf87d93bb1e3f47268dbc679be4b6dd8d 260d5f31009fff18000d1e64f4f877926e621306 decimal(p) false false false false false false false false 0 53d8c730fcec69d341f44089817ae06eb4844278 a83144f40e7ae64e46a4b4ed651379774a953b17 decimal(p) false false false false false false false false 0 4c0cc4ae32f8774cc319f516784430204aef0bdb 2a5203a275171a250870cf6cb224a910aa9354ec decimal(p,s) false false false false false false false false 0 2e958c528620621985af4394590198feed57cdf9 3ef5bd65a7dcd74b9a9d8a292ec395f66b7de32b decimal(p,s) false false false false false false false false 0 7c25ad75662553c7d4a58fa66eb50ca7c0ffee59 01d0849bdda56a8d8f24befdadc3fc9b007ae92b decimal(p,s) false false false false false false false false 0 1f81990c9694963f032c302d1834b972a6f2eb74 1c8ed63d72f40f0fe2f05815675771bdf3f824f8 decimal(p,s) false false false false false false false false 0 f01926071736b56b898949cc0720149c71504324 2b49e875138bfb329aaa352629650b7881435123 datetime false false false false false false false false 0 942700093ab61c3be0bdf6b23bcba210bcc30281 5c6ec16226d85b0411b7077cb9a6e0c7aa8d74d1 datetime false false false false false false false false 0 f221902bf89fe94dece8ccf309f59cc2c479d63f d92b8f7fa7a2be49c7f00c447a603b136e84261d datetime false false false false false false false false 0 c8d21e24bc69aac295703b0bae56269035b729f0 095a76f07a3cd2bdc6cc442757c11012e1974f4a datetime false false false false false false false false 0 a535b6c506004a7fdf4d48984c9ff2cfa59c157a TreeEntity b18ce64a2a72d00b26515583d8bbfea282f30ea8 394369b90c0a5b6efeed3cf823c642605d7a1653 varchar(n) false false true false false false false false 0 63772c051414452204e91e8d0dabd1dbfd640326 e8d877396943acfec73023dba2c1c6e3d7802d62 varchar(n) false false true false false false false false 0 be17e27c1f73fe128f00468cc83953077b7e00a9 23f973124aedd0244533f4e7b3b103c548b966be decimal(p) false false true false false false false false 0 b0bd388c14e5b2bbab9590f5247961a7edd9eb3b 984d5eac2b3221118a61655e4a5a49c78e0f0151 varchar(n) false false true false false false false false 0 40b63ab3e485fd55370d6d04b063c4397483ebc1 b2f246a3f0ade317eaa9915e2fd539abae5a5ec8 character(n) false false true false false false false false 0 3b9c3307b7140f27edeb47ffe307a662b2856627 f5a9968479420f08da2e98d21136b3ed4b6e396f decimal(p) false false true false false false false false 0 f48d759281e0da56d3e82430c3489d1276418f61 618194ebfc8c6c42efcef3a4af0b8054f6af209b varchar(n) false false true false false false false false 0