19 lines
11 KiB
SQL
19 lines
11 KiB
SQL
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1745048627706060801, 'sys_oa_contract', '合同表', null, null, 'SysOaContract', 'crud', 'com.ruoyi.oa', 'oa', 'oaContract', '合同管理', 'huangxing', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":"1744021734047330305"}', 'admin', '2024-01-10 19:42:24', 'admin', '2024-01-10 22:36:46', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1745320956109504514, 'sys_oa_project', '项目管理表', null, null, 'SysOaProject', 'crud', 'com.ruoyi.oa', 'oa', 'project', '项目管理', 'huangxing', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":"1744021537846177794"}', 'admin', '2024-01-11 12:59:29', 'admin', '2024-02-26 02:03:49', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1745469117209657346, 'sys_oa_task', '任务管理表', null, null, 'SysOaTask', 'crud', 'com.ruoyi.oa', 'oa', 'task', '任务管理', 'huangxing', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":"1744021537846177794"}', 'admin', '2024-01-11 23:33:11', 'admin', '2024-03-09 17:31:59', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1747288575859388418, 'sys_oa_finance', '进出账主表', null, null, 'SysOaFinance', 'crud', 'com.ruoyi.oa', 'oa', 'finance', '进出账管理', 'huangxing', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":"1744022006375100417"}', 'admin', '2024-01-16 23:59:36', 'admin', '2024-01-17 00:13:25', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1747293982443089922, 'sys_oa_detail', '进出账明细表', null, null, 'SysOaDetail', 'crud', 'com.ruoyi.oa', 'oa', 'detail', '进出账明细', 'huangxing', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":"1744022006375100417"}', 'admin', '2024-01-17 00:01:45', 'admin', '2024-01-17 00:28:40', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1747449601267474434, 'sys_oa_category', '文章分类表', '', '', 'SysOaCategory', 'tree', 'com.ruoyi.oa', 'oa', 'category', '知识分类', 'huangxing', '0', '/', '{"treeCode":"category_id","treeName":"category_name","treeParentCode":"parent_id","parentMenuId":"1744026651709386753"}', 'admin', '2024-01-17 10:39:37', 'admin', '2024-01-17 10:56:32', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1747454222346113026, 'sys_oa_article', '知识库表', null, null, 'SysOaArticle', 'crud', 'com.ruoyi.oa', 'oa', 'article', '知识管理', 'huangxing', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":"1744026651709386753"}', 'admin', '2024-01-17 10:42:55', 'admin', '2024-01-17 11:12:49', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1760940104147521538, 'sys_oa_bid', '投标管理表', null, null, 'SysOaBid', 'crud', 'com.ruoyi.oa', 'oa', 'oaBid', '投标管理', 'huangxing', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":"1760944548859858945"}', 'admin', '2024-02-23 16:09:11', 'admin', '2024-03-03 17:47:50', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1774252383009918978, 'sys_oa_purpose', '采购意向表', null, null, 'SysOaPurpose', 'crud', 'com.ruoyi.oa', 'oa', 'purpose', '采购意向', 'huangxing', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":"1760944548859858945"}', 'admin', '2024-03-31 09:48:00', 'admin', '2024-03-31 09:52:48', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1774987912672313345, 'sys_oa_remind', '任务事件提醒表', null, null, 'SysOaRemind', 'crud', 'com.ruoyi.oa', 'oa', 'remind', '事件提醒', 'huangxing', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":"1774989374680858626"}', 'admin', '2024-04-02 10:30:02', 'admin', '2024-04-02 10:52:57', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1848275002168209409, 'socket_contact', '通信目录表', null, null, 'SocketContact', 'crud', 'com.ruoyi.system', 'system', 'contact', '通信目录', 'hdka', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":null}', 'admin', '2024-10-21 15:59:27', 'admin', '2024-10-21 16:08:37', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1850345960404221953, 'socket_message', '对话信息表', null, null, 'SocketMessage', 'crud', 'com.ruoyi.system', 'system', 'message', '对话信息', 'hdka', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":null}', 'admin', '2024-10-27 09:09:08', 'admin', '2024-10-27 09:17:37', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1852578588693954561, 'sys_oa_warehouse_detail', '仓库出库表', null, null, 'SysOaOutWarehouse', 'crud', 'com.ruoyi.oa', 'oa', 'oaOutWarehouse', '仓库出库', 'liuzongkun999', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":"1852933620281430018"}', 'admin', '2024-11-02 12:00:40', 'admin', '2024-11-04 15:47:02', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1852578589482483713, 'sys_oa_warehouse', '仓库管理表', null, null, 'SysOaWarehouse', 'crud', 'com.ruoyi.oa', 'oa', 'oaWarehouse', '库存管理', 'liuzongkun999', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":"1852933620281430018"}', 'admin', '2024-11-02 11:42:55', 'admin', '2024-11-03 12:40:50', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1852593527033245697, 'sys_oa_receive_account', '付款账户管理', null, null, 'SysOaReceiveAccount', 'crud', 'com.ruoyi.system', 'system', 'oaReceiveAccount', '付款账户管理', 'hdka', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":3}', 'admin', '2024-11-02 14:07:30', 'admin', '2024-11-02 14:08:54', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1852965373587013633, 'sys_oa_worker', '人员管理', null, null, 'SysOaWorker', 'crud', 'com.ruoyi.oa', 'system', 'oaWorker', '人员管理', 'hdka', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":null}', 'admin', '2024-11-03 14:34:56', 'admin', '2024-11-03 14:49:53', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1853701253083701250, 'sys_oa_attendance', '人员考勤', null, null, 'SysOaAttendance', 'crud', 'com.ruoyi.oa', 'system', 'oaAttendance', '人员考勤', 'hdka', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":3}', 'admin', '2024-11-05 12:57:35', 'admin', '2024-11-05 15:30:44', null);
|
|
INSERT INTO fad_oa.gen_table (table_id, table_name, table_comment, sub_table_name, sub_table_fk_name, class_name, tpl_category, package_name, module_name, business_name, function_name, function_author, gen_type, gen_path, options, create_by, create_time, update_by, update_time, remark) VALUES (1855144915911069697, 'sys_oa_task_user', '任务工人', null, null, 'SysOaTaskUser', 'crud', 'com.ruoyi.oa', 'system', 'oaTaskUser', '任务工人', 'hdka', '0', '/', '{"treeCode":null,"treeName":null,"treeParentCode":null,"parentMenuId":3}', 'admin', '2024-11-09 14:43:59', 'admin', '2024-11-09 15:07:13', null);
|