From d51ecc91ec46a0bef9bf402331fd0ac83de2ff8e Mon Sep 17 00:00:00 2001
From: 许鹏程 <1821349743@qq.com>
Date: 星期二, 21 一月 2025 14:07:08 +0800
Subject: [PATCH] other:patch sql

---
 /dev/null                                              |   10 --
 product-server-web/patch/patch-20250102-001-deploy.sql |    0 
 product-server-web/patch/patch-20250102-002-deploy.sql |   87 +++++++++++++++++++++
 product-server-web/patch/patch-20250103-001-deploy.sql |  106 ++++++++++++++++++++++++++
 4 files changed, 193 insertions(+), 10 deletions(-)

diff --git a/product-server-web/patch/patch-20250102-001.sql b/product-server-web/patch/patch-20250102-001-deploy.sql
similarity index 100%
rename from product-server-web/patch/patch-20250102-001.sql
rename to product-server-web/patch/patch-20250102-001-deploy.sql
diff --git a/product-server-web/patch/patch-20250102-002-deploy.sql b/product-server-web/patch/patch-20250102-002-deploy.sql
new file mode 100644
index 0000000..62151c1
--- /dev/null
+++ b/product-server-web/patch/patch-20250102-002-deploy.sql
@@ -0,0 +1,87 @@
+INSERT INTO `product_sys_function_buttons` ( `uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '6e1cf9c9-a4b3-4af0-bbcd-f41401094f0f', '2fbcdeca-5266-493c-8af9-1f0c52e78cfc', 'autoLayout', '鑷姩甯冨眬', NULL, 2, '', '', NULL, 0, '1', NULL, 1, NULL, NULL, 'custom', 'Web', NULL, '194px', '913px', 'autoLayout', '', '1', '172887454447636WoA1b839', NULL, 0, '', 'rgba(30, 144, 255, 1)', '', '', 1);
+INSERT INTO `product_sys_function_buttons` ( `uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '2a60f5ee-cd59-4832-9e3a-d926e59fc1a5', '2fbcdeca-5266-493c-8af9-1f0c52e78cfc', 'copy', '鍙傜収鍏朵粬琛ㄥ崟', NULL, 2, '', '', NULL, 0, '1', NULL, 1, NULL, NULL, 'custom', 'Web', NULL, '129px', '912px', 'copyFace', '', '1', '172887454446069yV530192', NULL, 0, '', 'rgba(30, 144, 255, 1)', '', '', 1);
+
+INSERT INTO `product_sys_link` (`created_utc_datetime`, `created_by`, `line_from`, `from_type`, `function_uuid`,  `link_type`, `line_to`, `to_type`, `updated_by`, `updated_utc_datetime`, `uuid`, `terminal_type`) VALUES ('2024-10-14 10:55:45', 1, '9bf0c614-a31c-474e-ac20-8af8ae8aa01a', 2, '2fbcdeca-5266-493c-8af9-1f0c52e78cfc',  0, '2a60f5ee-cd59-4832-9e3a-d926e59fc1a5', 1, NULL, NULL, '820fd3b3-14ec-4b08-bb34-23cb0aa69407', 1);
+INSERT INTO `product_sys_link` (`created_utc_datetime`, `created_by`, `line_from`, `from_type`, `function_uuid`,  `link_type`, `line_to`, `to_type`, `updated_by`, `updated_utc_datetime`, `uuid`, `terminal_type`) VALUES ('2024-10-14 10:55:45', 1, '9bf0c614-a31c-474e-ac20-8af8ae8aa01a', 2, '2fbcdeca-5266-493c-8af9-1f0c52e78cfc',  0, '6e1cf9c9-a4b3-4af0-bbcd-f41401094f0f', 1, NULL, NULL, '9012029d-7d01-499b-b4c1-ff4e43f9db5a', 1);
+INSERT INTO `product_sys_dict` ( `uuid`, `dict_name`, `dict_label`, `dict_value`, `is_used`, `client_type`, `org_level_uuid`, `sequence`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `client_uuid`, `dict_value_color`, `dict_value_img`, `dict_group`) VALUES ( '1d478f8e-85dc-4024-b325-c441ecb888d5', '缁勭粐鏈烘瀯鎺т欢閫夋嫨绫诲瀷', '鍏徃', '1', 1, 'Web', '00000000-0000-0000-0000-000000000000', 1, 1, '2023-04-20 10:56:29', 1, '2023-04-20 10:56:55', NULL, NULL, NULL, NULL);
+INSERT INTO `product_sys_dict` ( `uuid`, `dict_name`, `dict_label`, `dict_value`, `is_used`, `client_type`, `org_level_uuid`, `sequence`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `client_uuid`, `dict_value_color`, `dict_value_img`, `dict_group`) VALUES ( 'baa650b6-22d9-484d-9342-10d7dce428c2', '缁勭粐鏈烘瀯鎺т欢閫夋嫨绫诲瀷', '閮ㄩ棬', '2', 1, 'Web', '00000000-0000-0000-0000-000000000000', 2, 1, '2023-04-20 10:56:29', 1, '2023-04-20 10:56:55', NULL, NULL, NULL, NULL);
+INSERT INTO `product_sys_dict` ( `uuid`, `dict_name`, `dict_label`, `dict_value`, `is_used`, `client_type`, `org_level_uuid`, `sequence`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `client_uuid`, `dict_value_color`, `dict_value_img`, `dict_group`) VALUES ( 'cf1f4d7b-af04-45a7-9b49-06b5e42e88b7', '缁勭粐鏈烘瀯鎺т欢閫夋嫨绫诲瀷', '宀椾綅', '3', 1, 'Web', '00000000-0000-0000-0000-000000000000', 3, 1, '2023-04-20 10:56:29', 1, '2023-04-20 10:56:55', NULL, NULL, NULL, NULL);
+INSERT INTO `product_sys_dict` ( `uuid`, `dict_name`, `dict_label`, `dict_value`, `is_used`, `client_type`, `org_level_uuid`, `sequence`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `client_uuid`, `dict_value_color`, `dict_value_img`, `dict_group`) VALUES ( 'e692b2be-f96b-4952-866c-9ddb06e16a7e', '缁勭粐鏈烘瀯鎺т欢閫夋嫨绫诲瀷', '宀椾綅灞傜骇涓嬬殑浜哄憳', '4', 1, 'Web', '00000000-0000-0000-0000-000000000000', 4, 1, '2023-04-20 10:56:29', 1, '2023-04-20 10:56:55', NULL, NULL, NULL, NULL);
+INSERT INTO `product_sys_dict` ( `uuid`, `dict_name`, `dict_label`, `dict_value`, `is_used`, `client_type`, `org_level_uuid`, `sequence`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `client_uuid`, `dict_value_color`, `dict_value_img`, `dict_group`) VALUES ( '193f0119-0855-4cf9-9769-ffa2f3d224d8', '缁勭粐鏈烘瀯鎺т欢閫夋嫨绫诲瀷', '閮ㄩ棬灞傜骇涓嬬殑浜哄憳', '5', 1, 'Web', '00000000-0000-0000-0000-000000000000', 5, 1, '2023-04-20 10:56:29', 1, '2023-04-20 10:56:55', NULL, NULL, NULL, NULL);
+
+
+INSERT INTO `product_sys_datamodel_table` (uuid,created_by,created_utc_datetime,updated_by,updated_utc_datetime,org_level_uuid,table_name,table_description,table_type,table_base_view,view_sql,table_primary_key,sequence,is_international,produce_msg,container_name,view_status) SELECT '0671f9dc-15a4-45cc-bf92-834be5774c75', '1', '2022-07-29 00:00:00', '1', '2022-07-29 00:00:00', NULL, 'product_sys_sent_v', '宸插彂瑙嗗浘', '2', '', 'select *
+from (
+	select t.uuid,t.title,n.title node_title,send_time,finish_type status,0 type,sender,group_concat(expect_person) wait_deal_person
+	from product_sys_flow_task t
+	inner join product_sys_flow_node n on t.cur_node_uuid=n.uuid
+	left join product_sys_flow_detail d on d.task_uuid=t.uuid and d.node_deal_sign in (0,1,5)
+	group by 1,2,3,4,5,6,7
+	union all
+	select uuid,title,null node_title,start_time,status,1 type,created_by,null
+	from product_oa_cooperates
+	where status is not null
+) t', NULL, '1', NULL, NULL, NULL, NULL from DUAL where not EXISTS (select 1 from product_sys_datamodel_table  where table_name='product_sys_sent_v');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '0671f9dc-15a4-45cc-bf92-834be5774c75', 'node_title', 'string', '鐜妭鏍囬', '鐜妭鏍囬', '20', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '0', '1', '2024-07-04 09:07:53', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' and field_name='node_title');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '0671f9dc-15a4-45cc-bf92-834be5774c75', 'send_time', 'datetime', '鍙戦�佹椂闂�', '鍙戦�佹椂闂�', '20', '0', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, '0', '1', '2024-07-04 09:07:53', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' and field_name='send_time');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '0671f9dc-15a4-45cc-bf92-834be5774c75', 'sender', 'string', '鍙戦�佷汉', '鍙戦�佷汉', '20', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '0', '1', '2024-07-04 09:07:53', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' and field_name='sender');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '0671f9dc-15a4-45cc-bf92-834be5774c75', 'status', 'int', '鐘舵��', '鐘舵��', '20', '0', '0', NULL, NULL, '1', NULL, NULL, '銆奻low_send_status銆�', NULL, '0', '1', '2024-07-04 09:07:53', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' and field_name='status');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '0671f9dc-15a4-45cc-bf92-834be5774c75', 'title', 'string', '鏍囬', '鏍囬', '20', '0', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, '0', '1', '2024-07-04 09:07:53', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' and field_name='title');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '0671f9dc-15a4-45cc-bf92-834be5774c75', 'type', 'int', '绫诲瀷', '绫诲瀷', '20', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '0', '1', '2024-07-04 09:07:53', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' and field_name='type');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '0671f9dc-15a4-45cc-bf92-834be5774c75', 'uuid', 'string', '鏄庣粏uuid', '鏄庣粏uuid', '20', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '0', '1', '2024-07-04 09:07:53', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' and field_name='uuid');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '0671f9dc-15a4-45cc-bf92-834be5774c75', 'wait_deal_person', 'string', '寰呭鐞嗕汉鍛�', '寰呭鐞嗕汉鍛�', '200', '0', '0', NULL, NULL, '0', NULL, NULL, 'user_name_by_user_id', NULL, '0', '1', '2024-07-04 09:07:53', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' and field_name='wait_deal_person');
+UPDATE product_sys_datamodel_field SET table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75', field_name = 'node_title', field_type = 'string', field_show_name = '鐜妭鏍囬', field_description = '鐜妭鏍囬', field_length = 20, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = '1', created_utc_datetime = '2024-07-04 09:07:53', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' AND field_name = 'node_title';
+UPDATE product_sys_datamodel_field SET table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75', field_name = 'send_time', field_type = 'datetime', field_show_name = '鍙戦�佹椂闂�', field_description = '鍙戦�佹椂闂�', field_length = 20, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 1, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = '1', created_utc_datetime = '2024-07-04 09:07:53', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' AND field_name = 'send_time';
+UPDATE product_sys_datamodel_field SET table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75', field_name = 'sender', field_type = 'string', field_show_name = '鍙戦�佷汉', field_description = '鍙戦�佷汉', field_length = 20, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = '1', created_utc_datetime = '2024-07-04 09:07:53', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' AND field_name = 'sender';
+UPDATE product_sys_datamodel_field SET table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75', field_name = 'status', field_type = 'int', field_show_name = '鐘舵��', field_description = '鐘舵��', field_length = 20, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 1, field_format = NULL, related_table = NULL, field_reference = '銆奻low_send_status銆�', field_relation_table = NULL, field_sequence = 0, created_by = '1', created_utc_datetime = '2024-07-04 09:07:53', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' AND field_name = 'status';
+UPDATE product_sys_datamodel_field SET table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75', field_name = 'title', field_type = 'string', field_show_name = '鏍囬', field_description = '鏍囬', field_length = 20, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 1, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = '1', created_utc_datetime = '2024-07-04 09:07:53', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' AND field_name = 'title';
+UPDATE product_sys_datamodel_field SET table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75', field_name = 'type', field_type = 'int', field_show_name = '绫诲瀷', field_description = '绫诲瀷', field_length = 20, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = '1', created_utc_datetime = '2024-07-04 09:07:53', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' AND field_name = 'type';
+UPDATE product_sys_datamodel_field SET table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75', field_name = 'uuid', field_type = 'string', field_show_name = '鏄庣粏uuid', field_description = '鏄庣粏uuid', field_length = 20, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = '1', created_utc_datetime = '2024-07-04 09:07:53', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' AND field_name = 'uuid';
+UPDATE product_sys_datamodel_field SET table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75', field_name = 'wait_deal_person', field_type = 'string', field_show_name = '寰呭鐞嗕汉鍛�', field_description = '寰呭鐞嗕汉鍛�', field_length = 200, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = 'user_name_by_user_id', field_relation_table = NULL, field_sequence = 0, created_by = '1', created_utc_datetime = '2024-07-04 09:07:53', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '0671f9dc-15a4-45cc-bf92-834be5774c75' AND field_name = 'wait_deal_person';
+DELETE FROM `product_sys_datamodel_field` where table_uuid='0671f9dc-15a4-45cc-bf92-834be5774c75' and  DATE_FORMAT(updated_utc_datetime, '%Y-%m-%d') != DATE_FORMAT(CURDATE(), '%Y-%m-%d');
+DELETE FROM `product_sys_datamodel_table_index` where table_uuid='0671f9dc-15a4-45cc-bf92-834be5774c75';
+
+
+
+ALTER TABLE `product_sys_data_upload_model` ADD COLUMN `start_row_index` int NULL DEFAULT NULL COMMENT '琛ㄥご琛岃捣濮嬩笅鏍�' AFTER `sheet_order`;
+
+
+INSERT INTO `product_sys_datamodel_table` (uuid,created_by,created_utc_datetime,updated_by,updated_utc_datetime,org_level_uuid,table_name,table_description,table_type,table_base_view,view_sql,table_primary_key,sequence,is_international,produce_msg,container_name,view_status) SELECT '9a55ffcb-eecd-4e4d-99f8-24c06014f506', '1', '2021-06-29 00:00:00', '1', '2021-06-29 00:00:00', NULL, 'product_sys_data_upload_model', '鏁版嵁涓婁紶妯℃澘', '1', NULL, NULL, 'uuid', '210', NULL, NULL, NULL, NULL from DUAL where not EXISTS (select 1 from product_sys_datamodel_table  where table_name='product_sys_data_upload_model');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'after_func', 'string', '淇濆瓨鍚庡鐞�', '淇濆瓨鍚庡鐞嗘柟娉�', '200', '0', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='after_func');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'before_func', 'string', '淇濆瓨鍓嶅鐞�', '淇濆瓨鍓嶅鐞嗘柟娉�', '200', '0', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='before_func');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'button_title', 'string', '鎸夐挳鏍囬', '瀵瑰簲鎸夐挳鏍囬', '200', '0', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='button_title');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'created_by', 'userid', '鍒涘缓鑰�', '鍒涘缓鑰�', '11', '0', '1', NULL, NULL, '0', NULL, NULL, 'user_name_by_user_id', NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='created_by');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'created_utc_datetime', 'datetime', '鍒涘缓鏃堕棿', '鍒涘缓鏃堕棿', '0', '0', '1', NULL, NULL, '0', NULL, NULL, '', NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='created_utc_datetime');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'function_uuid', 'string', '鍔熻兘uuid', '瀵瑰簲鍔熻兘uuid', '80', '0', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='function_uuid');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'id', 'pk', '涓婚敭', '涓婚敭', '11', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='id');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'org_level_uuid', 'orgUuid', '缁勭粐鏈烘瀯', '缁勭粐鏈烘瀯', '80', '0', '1', NULL, NULL, '0', NULL, NULL, 'levels', NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='org_level_uuid');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'sheet_order', 'int', 'sheet椤哄簭', 'sheet椤哄簭', '4', '0', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='sheet_order');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'start_row_index', 'int', '琛ㄥご琛岃捣濮嬩笅鏍�', '琛ㄥご琛岃捣濮嬩笅鏍�', '2', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '0', '1', '2023-07-03 10:13:09', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='start_row_index');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'table_name', 'string', '瀵瑰簲琛ㄥ悕', '瀵瑰簲琛ㄥ悕', '100', '0', '1', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='table_name');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'template_info', 'file', '闄勪欢琛╱uid', '瀵瑰簲闄勪欢琛╱uid', '80', '0', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='template_info');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'title', 'string', '鏍囬', '鏍囬', '500', '0', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='title');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'updated_by', 'int', '鏇存柊鑰�', '鏇存柊鑰�', '11', '0', '0', NULL, NULL, '0', NULL, NULL, 'user_name_by_user_id', NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='updated_by');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'updated_utc_datetime', 'datetime', '鏇存柊鏃堕棿', '鏇存柊鏃堕棿', '0', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='updated_utc_datetime');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'upload_sign', 'string', '瀵煎叆鍞竴鏍囪瘑', '鏈瀵煎叆鍞竴鏍囪瘑', '80', '0', '1', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='upload_sign');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), '9a55ffcb-eecd-4e4d-99f8-24c06014f506', 'uuid', 'string', '鍞竴鏍囪瘑', '鍞竴鏍囪瘑', '80', '0', '1', '1', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', '2023-07-03 10:13:09', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' and field_name='uuid');
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'after_func', field_type = 'string', field_show_name = '淇濆瓨鍚庡鐞�', field_description = '淇濆瓨鍚庡鐞嗘柟娉�', field_length = 200, field_unit = '0', is_required = 0, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'after_func';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'before_func', field_type = 'string', field_show_name = '淇濆瓨鍓嶅鐞�', field_description = '淇濆瓨鍓嶅鐞嗘柟娉�', field_length = 200, field_unit = '0', is_required = 0, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'before_func';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'button_title', field_type = 'string', field_show_name = '鎸夐挳鏍囬', field_description = '瀵瑰簲鎸夐挳鏍囬', field_length = 200, field_unit = '0', is_required = 0, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'button_title';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'created_by', field_type = 'userid', field_show_name = '鍒涘缓鑰�', field_description = '鍒涘缓鑰�', field_length = 11, field_unit = '0', is_required = 1, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = 'user_name_by_user_id', field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'created_by';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'created_utc_datetime', field_type = 'datetime', field_show_name = '鍒涘缓鏃堕棿', field_description = '鍒涘缓鏃堕棿', field_length = 0, field_unit = '0', is_required = 1, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = '', field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'created_utc_datetime';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'function_uuid', field_type = 'string', field_show_name = '鍔熻兘uuid', field_description = '瀵瑰簲鍔熻兘uuid', field_length = 80, field_unit = '0', is_required = 0, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'function_uuid';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'id', field_type = 'pk', field_show_name = '涓婚敭', field_description = '涓婚敭', field_length = 11, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'id';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'org_level_uuid', field_type = 'orgUuid', field_show_name = '缁勭粐鏈烘瀯', field_description = '缁勭粐鏈烘瀯', field_length = 80, field_unit = '0', is_required = 1, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = 'levels', field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'org_level_uuid';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'sheet_order', field_type = 'int', field_show_name = 'sheet椤哄簭', field_description = 'sheet椤哄簭', field_length = 4, field_unit = '0', is_required = 0, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'sheet_order';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'start_row_index', field_type = 'int', field_show_name = '琛ㄥご琛岃捣濮嬩笅鏍�', field_description = '琛ㄥご琛岃捣濮嬩笅鏍�', field_length = 2, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = '1', created_utc_datetime = '2023-07-03 10:13:09', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'start_row_index';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'table_name', field_type = 'string', field_show_name = '瀵瑰簲琛ㄥ悕', field_description = '瀵瑰簲琛ㄥ悕', field_length = 100, field_unit = '0', is_required = 1, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'table_name';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'template_info', field_type = 'file', field_show_name = '闄勪欢琛╱uid', field_description = '瀵瑰簲闄勪欢琛╱uid', field_length = 80, field_unit = '0', is_required = 0, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'template_info';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'title', field_type = 'string', field_show_name = '鏍囬', field_description = '鏍囬', field_length = 500, field_unit = '0', is_required = 0, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'title';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'updated_by', field_type = 'int', field_show_name = '鏇存柊鑰�', field_description = '鏇存柊鑰�', field_length = 11, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = 'user_name_by_user_id', field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'updated_by';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'updated_utc_datetime', field_type = 'datetime', field_show_name = '鏇存柊鏃堕棿', field_description = '鏇存柊鏃堕棿', field_length = 0, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'updated_utc_datetime';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'upload_sign', field_type = 'string', field_show_name = '瀵煎叆鍞竴鏍囪瘑', field_description = '鏈瀵煎叆鍞竴鏍囪瘑', field_length = 80, field_unit = '0', is_required = 1, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'upload_sign';
+UPDATE product_sys_datamodel_field SET table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506', field_name = 'uuid', field_type = 'string', field_show_name = '鍞竴鏍囪瘑', field_description = '鍞竴鏍囪瘑', field_length = 80, field_unit = '0', is_required = 1, is_unique = 1, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = '9a55ffcb-eecd-4e4d-99f8-24c06014f506' AND field_name = 'uuid';
+DELETE FROM `product_sys_datamodel_field` where table_uuid='9a55ffcb-eecd-4e4d-99f8-24c06014f506' and  DATE_FORMAT(updated_utc_datetime, '%Y-%m-%d') != DATE_FORMAT(CURDATE(), '%Y-%m-%d');
+DELETE FROM `product_sys_datamodel_table_index` where table_uuid='9a55ffcb-eecd-4e4d-99f8-24c06014f506';
+INSERT INTO `product_sys_datamodel_table_index` (`uuid`, `table_uuid`, `index_name`, `index_fields`, `index_type`) values ('b659ecd0-7fad-11ec-a3ed-902b3470f24e','9a55ffcb-eecd-4e4d-99f8-24c06014f506','uuid','uuid','1' );
+
diff --git a/product-server-web/patch/patch-20250102-002.sql b/product-server-web/patch/patch-20250102-002.sql
deleted file mode 100644
index c7f6b89..0000000
--- a/product-server-web/patch/patch-20250102-002.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-INSERT INTO `product_sys_function_buttons` ( `uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '6e1cf9c9-a4b3-4af0-bbcd-f41401094f0f', '2fbcdeca-5266-493c-8af9-1f0c52e78cfc', 'autoLayout', '鑷姩甯冨眬', NULL, 2, '', '', NULL, 0, '1', NULL, 1, NULL, NULL, 'custom', 'Web', NULL, '194px', '913px', 'autoLayout', '', '1', '172887454447636WoA1b839', NULL, 0, '', 'rgba(30, 144, 255, 1)', '', '', 1);
-INSERT INTO `product_sys_function_buttons` ( `uuid`, `function_uuid`, `button_name`, `button_title`, `button_description`, `button_type`, `button_icon`, `upload_parameter`, `api_url`, `is_main`, `status_uuid`, `script`, `sequence`, `is_send_email`, `script_method`, `button_category_uuid`, `client_type_uuid`, `version_uuid`, `top_location`, `left_location`, `click_method`, `upload_api_url`, `multiple_choice`, `route_name`, `params`, `is_warn`, `warn_info`, `button_color`, `print_template`, `next_page_keys`, `terminal_type`) VALUES ( '2a60f5ee-cd59-4832-9e3a-d926e59fc1a5', '2fbcdeca-5266-493c-8af9-1f0c52e78cfc', 'copy', '鍙傜収鍏朵粬琛ㄥ崟', NULL, 2, '', '', NULL, 0, '1', NULL, 1, NULL, NULL, 'custom', 'Web', NULL, '129px', '912px', 'copyFace', '', '1', '172887454446069yV530192', NULL, 0, '', 'rgba(30, 144, 255, 1)', '', '', 1);
-
-INSERT INTO `product_sys_link` (`created_utc_datetime`, `created_by`, `line_from`, `from_type`, `function_uuid`,  `link_type`, `line_to`, `to_type`, `updated_by`, `updated_utc_datetime`, `uuid`, `terminal_type`) VALUES ('2024-10-14 10:55:45', 1, '9bf0c614-a31c-474e-ac20-8af8ae8aa01a', 2, '2fbcdeca-5266-493c-8af9-1f0c52e78cfc',  0, '2a60f5ee-cd59-4832-9e3a-d926e59fc1a5', 1, NULL, NULL, '820fd3b3-14ec-4b08-bb34-23cb0aa69407', 1);
-INSERT INTO `product_sys_link` (`created_utc_datetime`, `created_by`, `line_from`, `from_type`, `function_uuid`,  `link_type`, `line_to`, `to_type`, `updated_by`, `updated_utc_datetime`, `uuid`, `terminal_type`) VALUES ('2024-10-14 10:55:45', 1, '9bf0c614-a31c-474e-ac20-8af8ae8aa01a', 2, '2fbcdeca-5266-493c-8af9-1f0c52e78cfc',  0, '6e1cf9c9-a4b3-4af0-bbcd-f41401094f0f', 1, NULL, NULL, '9012029d-7d01-499b-b4c1-ff4e43f9db5a', 1);
-INSERT INTO `product_sys_dict` ( `uuid`, `dict_name`, `dict_label`, `dict_value`, `is_used`, `client_type`, `org_level_uuid`, `sequence`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `client_uuid`, `dict_value_color`, `dict_value_img`, `dict_group`) VALUES ( '1d478f8e-85dc-4024-b325-c441ecb888d5', '缁勭粐鏈烘瀯鎺т欢閫夋嫨绫诲瀷', '鍏徃', '1', 1, 'Web', '00000000-0000-0000-0000-000000000000', 1, 1, '2023-04-20 10:56:29', 1, '2023-04-20 10:56:55', NULL, NULL, NULL, NULL);
-INSERT INTO `product_sys_dict` ( `uuid`, `dict_name`, `dict_label`, `dict_value`, `is_used`, `client_type`, `org_level_uuid`, `sequence`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `client_uuid`, `dict_value_color`, `dict_value_img`, `dict_group`) VALUES ( 'baa650b6-22d9-484d-9342-10d7dce428c2', '缁勭粐鏈烘瀯鎺т欢閫夋嫨绫诲瀷', '閮ㄩ棬', '2', 1, 'Web', '00000000-0000-0000-0000-000000000000', 2, 1, '2023-04-20 10:56:29', 1, '2023-04-20 10:56:55', NULL, NULL, NULL, NULL);
-INSERT INTO `product_sys_dict` ( `uuid`, `dict_name`, `dict_label`, `dict_value`, `is_used`, `client_type`, `org_level_uuid`, `sequence`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `client_uuid`, `dict_value_color`, `dict_value_img`, `dict_group`) VALUES ( 'cf1f4d7b-af04-45a7-9b49-06b5e42e88b7', '缁勭粐鏈烘瀯鎺т欢閫夋嫨绫诲瀷', '宀椾綅', '3', 1, 'Web', '00000000-0000-0000-0000-000000000000', 3, 1, '2023-04-20 10:56:29', 1, '2023-04-20 10:56:55', NULL, NULL, NULL, NULL);
-INSERT INTO `product_sys_dict` ( `uuid`, `dict_name`, `dict_label`, `dict_value`, `is_used`, `client_type`, `org_level_uuid`, `sequence`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `client_uuid`, `dict_value_color`, `dict_value_img`, `dict_group`) VALUES ( 'e692b2be-f96b-4952-866c-9ddb06e16a7e', '缁勭粐鏈烘瀯鎺т欢閫夋嫨绫诲瀷', '宀椾綅灞傜骇涓嬬殑浜哄憳', '4', 1, 'Web', '00000000-0000-0000-0000-000000000000', 4, 1, '2023-04-20 10:56:29', 1, '2023-04-20 10:56:55', NULL, NULL, NULL, NULL);
-INSERT INTO `product_sys_dict` ( `uuid`, `dict_name`, `dict_label`, `dict_value`, `is_used`, `client_type`, `org_level_uuid`, `sequence`, `created_by`, `created_utc_datetime`, `updated_by`, `updated_utc_datetime`, `client_uuid`, `dict_value_color`, `dict_value_img`, `dict_group`) VALUES ( '193f0119-0855-4cf9-9769-ffa2f3d224d8', '缁勭粐鏈烘瀯鎺т欢閫夋嫨绫诲瀷', '閮ㄩ棬灞傜骇涓嬬殑浜哄憳', '5', 1, 'Web', '00000000-0000-0000-0000-000000000000', 5, 1, '2023-04-20 10:56:29', 1, '2023-04-20 10:56:55', NULL, NULL, NULL, NULL);
diff --git a/product-server-web/patch/patch-20250103-001-deploy.sql b/product-server-web/patch/patch-20250103-001-deploy.sql
new file mode 100644
index 0000000..4a530dc
--- /dev/null
+++ b/product-server-web/patch/patch-20250103-001-deploy.sql
@@ -0,0 +1,106 @@
+ALTER TABLE `product_oa_ask_for_leave` DROP COLUMN `is_go_out`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `flow_flag` int NULL DEFAULT NULL COMMENT '娴佺▼閫佸姙榛樿瀛楁锛�0-寰呭彂锛�1-鍦ㄥ姙锛�2-鍔炵粨' FIRST;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `cause` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '璇峰亣鍘熷洜' AFTER `flow_flag`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `created_by` int NOT NULL COMMENT '鍒涘缓浜�' AFTER `cause`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `created_utc_datetime` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿' AFTER `created_by`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `department_uuid` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '閮ㄩ棬uuid' AFTER `created_utc_datetime`;
+
+
+update product_oa_ask_for_leave set end_time= DATE_ADD(start_time,INTERVAL `day` DAY) WHERE end_time is null;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `end_time` datetime NOT NULL COMMENT '缁撴潫鏃堕棿' AFTER `department_uuid`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `id` bigint NOT NULL COMMENT '鑷涓婚敭' AFTER `end_time`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `org_level_uuid` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '鍏徃uuid' AFTER `id`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `start_time` datetime NULL DEFAULT NULL COMMENT '寮�濮嬫椂闂�' AFTER `org_level_uuid`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `leave_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '璇峰亣绫诲瀷' AFTER `start_time`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `updated_by` int NULL DEFAULT NULL COMMENT '淇敼浜�' AFTER `leave_type`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `updated_utc_datetime` datetime NULL DEFAULT NULL COMMENT '淇敼鏃堕棿' AFTER `updated_by`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `uuid` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '鍞竴涓婚敭' AFTER `updated_utc_datetime`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `fill_in_time` datetime NULL DEFAULT NULL COMMENT '鐢宠鏃堕棿' AFTER `uuid`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `day` int NULL DEFAULT NULL COMMENT '璇峰亣鏃堕暱' AFTER `fill_in_time`;
+
+ALTER TABLE `product_oa_ask_for_leave` ADD COLUMN `user_id` int NULL DEFAULT NULL COMMENT '鐢宠浜�' AFTER `day`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `day_week` int NULL DEFAULT NULL COMMENT '鍏辫澶╂暟(鍚懆鏈�)' AFTER `user_id`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `accessory_uuid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '闄勪欢' AFTER `day_week`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `work_year` int NULL DEFAULT NULL COMMENT '宸ヤ綔骞撮檺' AFTER `accessory_uuid`;
+
+update product_oa_ask_for_leave set join_work_time=concat(join_work_time,'-01') WHERE length(join_work_time)=7;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `join_work_time` datetime NULL DEFAULT NULL COMMENT '鍙傚姞宸ヤ綔鏃堕棿' AFTER `work_year`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `work_assignment_person` int NULL DEFAULT NULL COMMENT '鏈汉宸ヤ綔浜ゅ姙浜�' AFTER `join_work_time`;
+
+ALTER TABLE `product_oa_ask_for_leave` MODIFY COLUMN `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鑷涓婚敭';
+
+INSERT INTO `product_sys_datamodel_table` (uuid,created_by,created_utc_datetime,updated_by,updated_utc_datetime,org_level_uuid,table_name,table_description,table_type,table_base_view,view_sql,table_primary_key,sequence,is_international,produce_msg,container_name,view_status) SELECT 'product_sys_ask_for_leave', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', NULL, 'product_oa_ask_for_leave', '璇峰亣琛ㄧ敵璇�', '1', '', NULL, 'uuid', '103', '0', NULL, NULL, NULL from DUAL where not EXISTS (select 1 from product_sys_datamodel_table  where table_name='product_oa_ask_for_leave');
+UPDATE `product_sys_datamodel_table` SET  uuid = 'product_sys_ask_for_leave', created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = '2020-01-01 00:00:00', org_level_uuid = NULL, table_name = 'product_oa_ask_for_leave', table_description = '璇峰亣琛ㄧ敵璇�', table_type = '1', table_base_view = '', view_sql = NULL, table_primary_key = 'uuid', sequence = '103', is_international = '0', produce_msg = NULL, view_status = NULL  WHERE table_name = 'product_oa_ask_for_leave';
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'accessory_uuid', 'file', '闄勪欢', '闄勪欢', '100', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '20', '1', '2024-10-15 17:06:26', '1', '2024-10-15 17:07:45', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='accessory_uuid');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'cause', 'string', '璇峰亣鍘熷洜', '璇峰亣鍘熷洜', '2000', '0', '0', '0', '0', '0', NULL, NULL, 'Leave_Type
+', NULL, '2', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='cause');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'created_by', 'int', '鍒涘缓浜�', '鍒涘缓浜�', '11', '0', '1', '0', '0', '0', NULL, NULL, 'user_name_by_user_id', NULL, '3', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='created_by');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'created_utc_datetime', 'datetime', '鍒涘缓鏃堕棿', '鍒涘缓鏃堕棿', '0', '0', '0', '0', '0', '0', NULL, NULL, NULL, NULL, '4', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='created_utc_datetime');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'day', 'int', '璇峰亣鏃堕暱', '璇峰亣鏃堕暱', '20', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '15', '1', '2024-08-06 00:00:00', '1', '2024-08-06 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='day');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'day_week', 'int', '鍏辫澶╂暟(鍚懆鏈�)', '鍏辫澶╂暟(鍚懆鏈�)', '20', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '19', '1', '2024-10-15 16:04:23', '1', '2024-10-15 17:04:45', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='day_week');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'department_uuid', 'string', '閮ㄩ棬uuid', '閮ㄩ棬uuid', '80', '0', '1', '0', '0', '0', NULL, NULL, 'this_level_dept', NULL, '5', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='department_uuid');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'end_time', 'datetime', '缁撴潫鏃堕棿', '缁撴潫鏃堕棿', '0', '0', '1', '0', '0', '0', NULL, NULL, NULL, NULL, '6', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='end_time');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'fill_in_time', 'datetime', '鐢宠鏃堕棿', '鐢宠鏃堕棿', '0', '0', '0', '0', '0', '0', NULL, NULL, NULL, NULL, '14', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='fill_in_time');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'flow_flag', 'flowsign', '娴佺▼鐘舵��', '娴佺▼閫佸姙榛樿瀛楁锛�0-寰呭彂锛�1-鍦ㄥ姙锛�2-鍔炵粨', '2', '0', '0', '0', NULL, '0', NULL, NULL, '銆奻low_send_status銆�', NULL, '1', NULL, NULL, '1', '2024-08-06 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='flow_flag');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'id', 'pk', '鑷涓婚敭', '鑷涓婚敭', '11', '0', '0', '0', '0', '0', NULL, NULL, NULL, NULL, '7', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='id');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'join_work_time', 'datetime', '鍙傚姞宸ヤ綔鏃堕棿', '鍙傚姞宸ヤ綔鏃堕棿', '0', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '22', '1', '2024-10-15 17:10:20', '1', '2024-10-15 17:11:56', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='join_work_time');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'leave_type', 'string', '璇峰亣绫诲瀷', '璇峰亣绫诲瀷', '30', '0', '1', '0', '0', '0', NULL, NULL, NULL, NULL, '10', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='leave_type');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'manager_opinion', 'string', 'manager_opinion', 'manager_opinion', '300', '0', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, '2024-10-18 15:29:48', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='manager_opinion');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'org_level_uuid', 'string', '鍏徃uuid', '鍏徃uuid', '80', '0', '1', '0', '0', '0', NULL, NULL, 'levels', NULL, '8', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='org_level_uuid');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'personnel_opinion', 'string', 'personnel_opinion', 'personnel_opinion', '300', '0', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, '2024-10-18 15:29:48', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='personnel_opinion');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'staff_uuid', 'string', 'staff_uuid', 'staff_uuid', '80', '0', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, '0', NULL, '2024-10-18 15:29:48', NULL, NULL, NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='staff_uuid');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'start_time', 'datetime', '寮�濮嬫椂闂�', '寮�濮嬫椂闂�', '0', '0', '0', '0', '0', '0', NULL, NULL, NULL, NULL, '9', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='start_time');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'updated_by', 'int', '淇敼浜�', '淇敼浜�', '11', '0', '0', '0', '0', '0', NULL, NULL, 'user_name_by_user_id', NULL, '11', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='updated_by');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'updated_utc_datetime', 'datetime', '淇敼鏃堕棿', '淇敼鏃堕棿', '0', '0', '0', '0', '0', '0', NULL, NULL, NULL, NULL, '12', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='updated_utc_datetime');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'user_id', 'int', '鐢宠浜�', '鐢宠浜�', '20', '0', '0', NULL, NULL, '0', NULL, NULL, 'user_name_by_user_id', NULL, '18', '1', '2024-08-06 00:00:00', '1', '2024-08-06 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='user_id');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'uuid', 'string', '鍞竴涓婚敭', '鍞竴涓婚敭', '80', '0', '1', '0', '0', '0', NULL, NULL, NULL, NULL, '13', '1', '2020-01-01 00:00:00', '1', '2020-01-01 00:00:00', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='uuid');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'work_assignment_person', 'int', '鏈汉宸ヤ綔浜ゅ姙浜�', '鏈汉宸ヤ綔浜ゅ姙浜�', '20', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '23', '1', '2024-10-15 17:11:56', '1', '2024-10-15 17:16:08', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='work_assignment_person');
+INSERT INTO product_sys_datamodel_field (uuid,table_uuid, field_name, field_type, field_show_name, field_description, field_length, field_unit, is_required, is_unique, is_international, is_filter, field_format, related_table, field_reference, field_relation_table, field_sequence, created_by, created_utc_datetime, updated_by, updated_utc_datetime, is_more_value) SELECT uuid(), 'product_sys_ask_for_leave', 'work_year', 'int', '宸ヤ綔骞撮檺', '宸ヤ綔骞撮檺', '11', '0', '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, '21', '1', '2024-10-15 17:10:20', '1', '2024-10-15 17:11:56', '0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM product_sys_datamodel_field WHERE table_uuid = 'product_sys_ask_for_leave' and field_name='work_year');
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'accessory_uuid', field_type = 'file', field_show_name = '闄勪欢', field_description = '闄勪欢', field_length = 100, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 20, created_by = '1', created_utc_datetime = '2024-10-15 17:06:26', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'accessory_uuid';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'cause', field_type = 'string', field_show_name = '璇峰亣鍘熷洜', field_description = '璇峰亣鍘熷洜', field_length = 2000, field_unit = '0', is_required = 0, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = 'Leave_Type
+', field_relation_table = NULL, field_sequence = 2, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'cause';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'created_by', field_type = 'int', field_show_name = '鍒涘缓浜�', field_description = '鍒涘缓浜�', field_length = 11, field_unit = '0', is_required = 1, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = 'user_name_by_user_id', field_relation_table = NULL, field_sequence = 3, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'created_by';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'created_utc_datetime', field_type = 'datetime', field_show_name = '鍒涘缓鏃堕棿', field_description = '鍒涘缓鏃堕棿', field_length = 0, field_unit = '0', is_required = 0, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 4, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'created_utc_datetime';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'day', field_type = 'int', field_show_name = '璇峰亣鏃堕暱', field_description = '璇峰亣鏃堕暱', field_length = 20, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 15, created_by = '1', created_utc_datetime = '2024-08-06 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'day';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'day_week', field_type = 'int', field_show_name = '鍏辫澶╂暟(鍚懆鏈�)', field_description = '鍏辫澶╂暟(鍚懆鏈�)', field_length = 20, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 19, created_by = '1', created_utc_datetime = '2024-10-15 16:04:23', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'day_week';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'department_uuid', field_type = 'string', field_show_name = '閮ㄩ棬uuid', field_description = '閮ㄩ棬uuid', field_length = 80, field_unit = '0', is_required = 1, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = 'this_level_dept', field_relation_table = NULL, field_sequence = 5, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'department_uuid';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'end_time', field_type = 'datetime', field_show_name = '缁撴潫鏃堕棿', field_description = '缁撴潫鏃堕棿', field_length = 0, field_unit = '0', is_required = 1, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 6, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'end_time';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'fill_in_time', field_type = 'datetime', field_show_name = '鐢宠鏃堕棿', field_description = '鐢宠鏃堕棿', field_length = 0, field_unit = '0', is_required = 0, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 14, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'fill_in_time';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'flow_flag', field_type = 'flowsign', field_show_name = '娴佺▼鐘舵��', field_description = '娴佺▼閫佸姙榛樿瀛楁锛�0-寰呭彂锛�1-鍦ㄥ姙锛�2-鍔炵粨', field_length = 2, field_unit = '0', is_required = 0, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = '銆奻low_send_status銆�', field_relation_table = NULL, field_sequence = 1, created_by = NULL, created_utc_datetime = NULL, updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'flow_flag';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'id', field_type = 'pk', field_show_name = '鑷涓婚敭', field_description = '鑷涓婚敭', field_length = 11, field_unit = '0', is_required = 0, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 7, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'id';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'join_work_time', field_type = 'datetime', field_show_name = '鍙傚姞宸ヤ綔鏃堕棿', field_description = '鍙傚姞宸ヤ綔鏃堕棿', field_length = 0, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 22, created_by = '1', created_utc_datetime = '2024-10-15 17:10:20', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'join_work_time';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'leave_type', field_type = 'string', field_show_name = '璇峰亣绫诲瀷', field_description = '璇峰亣绫诲瀷', field_length = 30, field_unit = '0', is_required = 1, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 10, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'leave_type';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'manager_opinion', field_type = 'string', field_show_name = 'manager_opinion', field_description = 'manager_opinion', field_length = 300, field_unit = '0', is_required = 0, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = '2024-10-18 15:29:48', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'manager_opinion';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'org_level_uuid', field_type = 'string', field_show_name = '鍏徃uuid', field_description = '鍏徃uuid', field_length = 80, field_unit = '0', is_required = 1, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = 'levels', field_relation_table = NULL, field_sequence = 8, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'org_level_uuid';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'personnel_opinion', field_type = 'string', field_show_name = 'personnel_opinion', field_description = 'personnel_opinion', field_length = 300, field_unit = '0', is_required = 0, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = '2024-10-18 15:29:48', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'personnel_opinion';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'staff_uuid', field_type = 'string', field_show_name = 'staff_uuid', field_description = 'staff_uuid', field_length = 80, field_unit = '0', is_required = 0, is_unique = 0, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 0, created_by = NULL, created_utc_datetime = '2024-10-18 15:29:48', updated_by = NULL, updated_utc_datetime = now(), is_more_value = NULL WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'staff_uuid';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'start_time', field_type = 'datetime', field_show_name = '寮�濮嬫椂闂�', field_description = '寮�濮嬫椂闂�', field_length = 0, field_unit = '0', is_required = 0, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 9, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'start_time';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'updated_by', field_type = 'int', field_show_name = '淇敼浜�', field_description = '淇敼浜�', field_length = 11, field_unit = '0', is_required = 0, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = 'user_name_by_user_id', field_relation_table = NULL, field_sequence = 11, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'updated_by';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'updated_utc_datetime', field_type = 'datetime', field_show_name = '淇敼鏃堕棿', field_description = '淇敼鏃堕棿', field_length = 0, field_unit = '0', is_required = 0, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 12, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'updated_utc_datetime';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'user_id', field_type = 'int', field_show_name = '鐢宠浜�', field_description = '鐢宠浜�', field_length = 20, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = 'user_name_by_user_id', field_relation_table = NULL, field_sequence = 18, created_by = '1', created_utc_datetime = '2024-08-06 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'user_id';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'uuid', field_type = 'string', field_show_name = '鍞竴涓婚敭', field_description = '鍞竴涓婚敭', field_length = 80, field_unit = '0', is_required = 1, is_unique = 0, is_international = 0, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 13, created_by = '1', created_utc_datetime = '2020-01-01 00:00:00', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'uuid';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'work_assignment_person', field_type = 'int', field_show_name = '鏈汉宸ヤ綔浜ゅ姙浜�', field_description = '鏈汉宸ヤ綔浜ゅ姙浜�', field_length = 20, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 23, created_by = '1', created_utc_datetime = '2024-10-15 17:11:56', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'work_assignment_person';
+UPDATE product_sys_datamodel_field SET table_uuid = 'product_sys_ask_for_leave', field_name = 'work_year', field_type = 'int', field_show_name = '宸ヤ綔骞撮檺', field_description = '宸ヤ綔骞撮檺', field_length = 11, field_unit = '0', is_required = 0, is_unique = NULL, is_international = NULL, is_filter = 0, field_format = NULL, related_table = NULL, field_reference = NULL, field_relation_table = NULL, field_sequence = 21, created_by = '1', created_utc_datetime = '2024-10-15 17:10:20', updated_by = '1', updated_utc_datetime = now(), is_more_value = 0 WHERE table_uuid = 'product_sys_ask_for_leave' AND field_name = 'work_year';
+DELETE FROM `product_sys_datamodel_field` where table_uuid='product_sys_ask_for_leave' and  DATE_FORMAT(updated_utc_datetime, '%Y-%m-%d') != DATE_FORMAT(CURDATE(), '%Y-%m-%d');
+DELETE FROM `product_sys_datamodel_table_index` where table_uuid='product_sys_ask_for_leave';
+INSERT INTO `product_sys_datamodel_table_index` (`uuid`, `table_uuid`, `index_name`, `index_fields`, `index_type`) values ('b6594f71-7fad-11ec-a3ed-902b3470f24e','product_sys_ask_for_leave','uuid','uuid','1' );

--
Gitblit v1.9.2