Home Explore Help
Register Sign In
ccj
/
zlty-api
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 8780d4799e
Branches Tags
zlty-api
/
init.sql

init.sql 104 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : localhost
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80031
    7. 

  7.  Source Host           : localhost:3306
    8. 

  8.  Source Schema         : grain_search
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80031
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 20/09/2023 09:29:45
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for fil_file
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `fil_file`;
    24. 

  24. CREATE TABLE `fil_file`  (
    25. 

  25.   `ff_id` bigint NULL DEFAULT NULL COMMENT '主键id',
    26. 

  26.   `ff_biz_id` bigint NULL DEFAULT NULL COMMENT '业务id',
    27. 

  27.   `ff_biz_type` int NULL DEFAULT NULL COMMENT '业务类型',
    28. 

  28.   `ff_file_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '文件名称',
    29. 

  29.   `ff_relative_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '文件相对路径',
    30. 

  30.   `creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
    31. 

  31.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '创建人',
    32. 

  32.   `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
    33. 

  33.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '更新人',
    34. 

  34.   `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    35. 

  35.   `has_deleted` int NULL DEFAULT NULL COMMENT '是否删除0-否1-是'
    36. 

  36. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '文件信息' ROW_FORMAT = Dynamic;
    37. 

  37. 

  38. -- ----------------------------
    39. 

  39. -- Records of fil_file
    40. 

  40. -- ----------------------------
    41. 

  41. INSERT INTO `fil_file` VALUES (1697067110367059969, 1697067109947629569, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', NULL, NULL, '2023-08-31 10:01:44', NULL, '2023-08-31 10:01:44', 0);
    42. 

  42. INSERT INTO `fil_file` VALUES (1697067110367059970, 1697067109947629569, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', NULL, NULL, '2023-08-31 10:01:44', NULL, '2023-08-31 10:01:44', 0);
    43. 

  43. INSERT INTO `fil_file` VALUES (1697072666939060225, 1697072666486075393, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', NULL, '测试用户', '2023-08-31 10:23:49', '测试', '2023-08-31 10:23:49', 0);
    44. 

  44. INSERT INTO `fil_file` VALUES (1697072666939060226, 1697072666486075393, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', NULL, '测试用户', '2023-08-31 10:23:49', '测试', '2023-08-31 10:23:49', 0);
    45. 

  45. INSERT INTO `fil_file` VALUES (1697077723050926082, 1697077631774482434, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', NULL, '测试用户', '2023-08-31 10:43:54', '测试', '2023-08-31 10:43:54', 0);
    46. 

  46. INSERT INTO `fil_file` VALUES (1697078016299773954, 1697078007563038721, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-08-31 10:45:04', '测试', '2023-08-31 10:45:04', 0);
    47. 

  47. INSERT INTO `fil_file` VALUES (1697127602640945154, 1697127602284429313, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-08-31 14:02:06', '测试', '2023-08-31 14:02:06', 0);
    48. 

  48. INSERT INTO `fil_file` VALUES (1697127656013463554, 1697127655946354690, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-08-31 14:02:19', '测试', '2023-08-31 14:02:19', 0);
    49. 

  49. INSERT INTO `fil_file` VALUES (1697132239934758914, 1697132239678906369, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-08-31 14:20:32', '测试', '2023-08-31 14:20:32', 0);
    50. 

  50. INSERT INTO `fil_file` VALUES (1697132239934758913, 1698606971674750978, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-04 16:00:39', '测试', '2023-09-04 16:01:09', 1);
    51. 

  51. INSERT INTO `fil_file` VALUES (1697132239934758914, 1698605949896159233, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-04 15:56:32', '测试', '2023-09-04 15:56:32', 0);
    52. 

  52. INSERT INTO `fil_file` VALUES (1697132239934758913, 1698606971674750978, 1, '微信图片_20230814113826.jpg', '\\grain-right\\2bf485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-04 16:00:39', '测试', '2023-09-04 16:01:09', 1);
    53. 

  53. INSERT INTO `fil_file` VALUES (1697132239934758914, 1698606971674750978, 1, '微信图片_20230814113826.jpg', '\\grain-right\\123485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-04 16:00:39', '测试', '2023-09-04 16:00:39', 0);
    54. 

  54. INSERT INTO `fil_file` VALUES (1697132239934758914, 1698609691018219522, 1, '微信图片_20230814113826.jpg', '\\grain-right\\133485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-04 16:11:24', '测试', '2023-09-04 16:11:24', 0);
    55. 

  55. INSERT INTO `fil_file` VALUES (1699589242317783041, 1699589242116456449, 1, 'SitnsrGzt8sEeaf5fd5732689ed5608e9a349ad3ef6e.png', '\\grain-right\\ad0a83975932475d8fd0a034e91cab3f\\SitnsrGzt8sEeaf5fd5732689ed5608e9a349ad3ef6e.png', 2, '测试用户', '2023-09-07 09:03:47', '测试', '2023-09-07 09:03:47', 0);
    56. 

  56. INSERT INTO `fil_file` VALUES (1697132239934758914, 1699597888359559169, 1, '微信图片_20230814113826.jpg', '\\grain-right\\123485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-07 09:38:08', '测试', '2023-09-07 09:38:08', 0);
    57. 

  57. INSERT INTO `fil_file` VALUES (1697132239934758914, 1699630906977644545, 1, '微信图片_20230814113826.jpg', '\\grain-right\\123485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-07 11:49:21', '测试', '2023-09-07 11:49:21', 0);
    58. 

  58. INSERT INTO `fil_file` VALUES (1697132239934758914, 1699684907043540994, 1, '微信图片_20230814113826.jpg', '\\grain-right\\123485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-07 15:23:55', '测试', '2023-09-07 15:23:55', 0);
    59. 

  59. INSERT INTO `fil_file` VALUES (1697132239934758914, 1699685017781555202, 1, '微信图片_20230814113826.jpg', '\\grain-right\\123485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-07 15:24:22', '测试', '2023-09-07 15:24:22', 0);
    60. 

  60. INSERT INTO `fil_file` VALUES (1697132239934758914, 1699686232569483265, 1, '微信图片_20230814113826.jpg', '\\grain-right\\123485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-07 15:29:11', '测试', '2023-09-07 15:29:11', 0);
    61. 

  61. INSERT INTO `fil_file` VALUES (1697132239934758914, 1699687957099499521, 1, '微信图片_20230814113826.jpg', '\\grain-right\\123485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-07 15:36:02', '测试', '2023-09-07 15:36:02', 0);
    62. 

  62. INSERT INTO `fil_file` VALUES (1697132239934758914, 1701767483707162625, 1, '微信图片_20230814113826.jpg', '\\grain-right\\123485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-13 09:19:20', '测试', '2023-09-13 09:19:20', 0);
    63. 

  63. INSERT INTO `fil_file` VALUES (1697132239934758914, 1702605455180443650, 1, '微信图片_20230814113826.jpg', '\\grain-right\\123485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-15 16:49:08', '测试', '2023-09-15 16:49:08', 0);
    64. 

  64. INSERT INTO `fil_file` VALUES (1697132239934758914, 1702606396994625537, 1, '微信图片_20230814113826.jpg', '\\grain-right\\123485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-15 16:52:53', '测试', '2023-09-15 16:52:53', 0);
    65. 

  65. INSERT INTO `fil_file` VALUES (1697132239934758914, 1702606684501581825, 1, '微信图片_20230814113826.jpg', '\\grain-right\\123485f5d130436da81deb476d9ad4e4\\微信图片_20230814113826.jpg', 2, '测试用户', '2023-09-15 16:54:01', '测试', '2023-09-15 16:54:01', 0);
    66. 

  66. 

  67. -- ----------------------------
    68. 

  68. -- Table structure for grain_right
    69. 

  69. -- ----------------------------
    70. 

  70. DROP TABLE IF EXISTS `grain_right`;
    71. 

  71. CREATE TABLE `grain_right`  (
    72. 

  72.   `gr_id` bigint NOT NULL COMMENT '主键id',
    73. 

  73.   `gr_se_id` bigint NULL DEFAULT NULL COMMENT '企业id',
    74. 

  74.   `gr_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '粮权编号',
    75. 

  75.   `gr_pod_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '仓库名称',
    76. 

  76.   `gr_store_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '库区名称',
    77. 

  77.   `gr_pledgee` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '质权方',
    78. 

  78.   `gr_bailor` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '存货方',
    79. 

  79.   `gr_custodian` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '保管方',
    80. 

  80.   `gr_store_owner` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '库方',
    81. 

  81.   `gr_goods_variety` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '货物品种',
    82. 

  82.   `gr_goods_weight` decimal(16, 3) NULL DEFAULT NULL COMMENT '货物重量(吨)',
    83. 

  83.   `gr_state` int NULL DEFAULT NULL COMMENT '审核状态0-未提交1-审核中2-审核成功3-审核失败',
    84. 

  84.   `gr_goods_level` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '货物等级',
    85. 

  85.   `gr_has_log_off` int NULL DEFAULT NULL COMMENT '是否注销1-已注销0-未注销',
    86. 

  86.   `gr_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '地址',
    87. 

  87.   `gr_registrant` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '登记人',
    88. 

  88.   `gr_review_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
    89. 

  89.   `gr_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注',
    90. 

  90.   `creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
    91. 

  91.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '创建人',
    92. 

  92.   `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
    93. 

  93.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '更新人',
    94. 

  94.   `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    95. 

  95.   `has_deleted` int NULL DEFAULT NULL COMMENT '是否删除0-否1-是',
    96. 

  96.   PRIMARY KEY (`gr_id`) USING BTREE,
    97. 

  97.   UNIQUE INDEX `gr_no_unique`(`gr_no` ASC) USING BTREE
    98. 

  98. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '粮权' ROW_FORMAT = Dynamic;
    99. 

  99. 

  100. -- ----------------------------
    101. 

  101. -- Records of grain_right
    102. 

  102. -- ----------------------------
    103. 

  103. INSERT INTO `grain_right` VALUES (1697067109947629569, 1694621216858218498, 'LQ001', '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, 2, '测试用户', '2023-08-31 10:01:44', '测试用户', '2023-08-31 10:01:44', 0);
    104. 

  104. INSERT INTO `grain_right` VALUES (1697072666486075393, 1694621216858218498, 'LQ005', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, 2, '测试用户', '2023-08-31 10:23:48', '测试用户', '2023-08-31 11:37:00', 0);
    105. 

  105. INSERT INTO `grain_right` VALUES (1697077631774482434, 1694621216858218498, 'LQ003', '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, 2, '测试用户', '2023-08-31 10:43:32', '测试用户', '2023-08-31 10:43:32', 0);
    106. 

  106. INSERT INTO `grain_right` VALUES (1697078007563038721, 1694621216858218498, 'LQ004', '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, '1', 2, '测试用户', '2023-08-31 10:45:02', '测试用户', '2023-08-31 10:45:02', 0);
    107. 

  107. INSERT INTO `grain_right` VALUES (1699589242116456449, 1694621216858218498, 'LQ202309070001', '1', '1', '1', '11', '1', '1', '1', 1.000, NULL, '1', NULL, '1', '1', NULL, NULL, 2, '测试用户', '2023-09-07 09:03:47', '测试用户', '2023-09-07 09:03:47', 0);
    108. 

  108. INSERT INTO `grain_right` VALUES (1699597888359559169, 1694621216858218498, 'LQ202309070002', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, 2, '测试用户', '2023-09-07 09:38:08', '测试用户', '2023-09-07 09:38:08', 0);
    109. 

  109. INSERT INTO `grain_right` VALUES (1699630906977644545, 1694621216858218498, 'LQ202309070003', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, 2, '测试用户', '2023-09-07 11:49:20', '测试用户', '2023-09-07 11:49:20', 0);
    110. 

  110. INSERT INTO `grain_right` VALUES (1699686232569483265, 1694621216858218498, 'LQ202309070016', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, 2, '测试用户', '2023-09-07 15:29:11', '测试用户', '2023-09-15 17:03:48', 0);
    111. 

  111. INSERT INTO `grain_right` VALUES (1699687957099499521, 1694621216858218498, 'LQ202309070019', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, 2, '测试用户', '2023-09-07 15:36:02', '测试用户', '2023-09-07 15:36:02', 0);
    112. 

  112. INSERT INTO `grain_right` VALUES (1701767483707162625, 1694621216858218498, 'LQ202309130003', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, 2, '测试用户', '2023-09-13 09:19:20', '测试用户', '2023-09-13 09:19:20', 0);
    113. 

  113. INSERT INTO `grain_right` VALUES (1702605455180443650, 1694621216858218498, 'LQ202309150004', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, 2, '测试用户', '2023-09-15 16:49:08', '测试用户', '2023-09-15 16:49:08', 0);
    114. 

  114. INSERT INTO `grain_right` VALUES (1702606396994625537, 1694621216858218498, 'LQ202309150005', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, 2, '测试用户', '2023-09-15 16:52:53', '测试用户', '2023-09-15 16:52:53', 0);
    115. 

  115. INSERT INTO `grain_right` VALUES (1702606684501581825, 1694621216858218498, 'LQ202309150006', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, 2, '测试用户', '2023-09-15 16:54:01', '测试用户', '2023-09-15 16:54:01', 0);
    116. 

  116. 

  117. -- ----------------------------
    118. 

  118. -- Table structure for grain_right_board
    119. 

  119. -- ----------------------------
    120. 

  120. DROP TABLE IF EXISTS `grain_right_board`;
    121. 

  121. CREATE TABLE `grain_right_board`  (
    122. 

  122.   `grb_id` bigint NOT NULL COMMENT '主键id',
    123. 

  123.   `grb_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '粮权牌编号',
    124. 

  124.   `grb_se_id` bigint NULL DEFAULT NULL COMMENT '归属企业id',
    125. 

  125.   `grb_gr_id` bigint NULL DEFAULT NULL COMMENT '粮权id',
    126. 

  126.   `creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
    127. 

  127.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '创建人',
    128. 

  128.   `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
    129. 

  129.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '更新人',
    130. 

  130.   `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    131. 

  131.   `has_deleted` int NULL DEFAULT NULL COMMENT '是否删除0-否1-是',
    132. 

  132.   PRIMARY KEY (`grb_id`) USING BTREE,
    133. 

  133.   UNIQUE INDEX `grb_no_unique`(`grb_no` ASC) USING BTREE
    134. 

  134. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '粮权牌' ROW_FORMAT = Dynamic;
    135. 

  135. 

  136. -- ----------------------------
    137. 

  137. -- Records of grain_right_board
    138. 

  138. -- ----------------------------
    139. 

  139. INSERT INTO `grain_right_board` VALUES (123, '0108', 1694620844743761922, 1697077631774482434, NULL, '1', '2023-08-25 16:21:04', NULL, '2023-09-07 15:24:22', 0);
    140. 

  140. INSERT INTO `grain_right_board` VALUES (1111, '0109', 1694620844743761922, 1699687957099499521, NULL, '1', '2023-08-25 16:21:04', NULL, '2023-09-07 15:30:11', 0);
    141. 

  141. INSERT INTO `grain_right_board` VALUES (1112311, '0110', 1694620844743761922, 1699685017781555202, NULL, '1', '2023-08-25 16:21:04', NULL, '2023-09-07 15:24:22', 0);
    142. 

  142. INSERT INTO `grain_right_board` VALUES (1695997105026154497, '0111', 1694620844743761922, 1699686232569483265, NULL, '测试', '2023-08-28 11:09:55', '测试', '2023-09-15 17:03:48', 0);
    143. 

  143. INSERT INTO `grain_right_board` VALUES (1695997898311647233, '0112', 1694620844743761922, 1699686232569483265, NULL, '测试', '2023-08-28 11:13:04', '测试', '2023-09-15 17:03:48', 0);
    144. 

  144. INSERT INTO `grain_right_board` VALUES (1695997948853035010, '0113', 1694620844743761922, NULL, NULL, '测试', '2023-08-28 11:13:16', '测试', '2023-09-15 16:54:01', 0);
    145. 

  145. INSERT INTO `grain_right_board` VALUES (1695998524386975746, '0114', 1694621216858218498, 1699686232569483265, 1, '测试', '2023-08-28 11:15:33', '测试', '2023-09-15 17:03:48', 0);
    146. 

  146. 

  147. -- ----------------------------
    148. 

  148. -- Table structure for grain_right_history
    149. 

  149. -- ----------------------------
    150. 

  150. DROP TABLE IF EXISTS `grain_right_history`;
    151. 

  151. CREATE TABLE `grain_right_history`  (
    152. 

  152.   `grh_id` bigint NOT NULL COMMENT '主键id',
    153. 

  153.   `gr_id` bigint NULL DEFAULT NULL COMMENT '粮权主键id',
    154. 

  154.   `gr_se_id` bigint NULL DEFAULT NULL COMMENT '企业id',
    155. 

  155.   `grh_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '粮权编号',
    156. 

  156.   `grh_pod_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '仓库名称',
    157. 

  157.   `grh_store_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '库区名称',
    158. 

  158.   `grh_pledgee` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '质权方',
    159. 

  159.   `grh_bailor` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '存货方',
    160. 

  160.   `grh_custodian` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '保管方',
    161. 

  161.   `grh_store_owner` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '库方',
    162. 

  162.   `grh_goods_variety` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '货物品种',
    163. 

  163.   `grh_goods_weight` decimal(16, 3) NULL DEFAULT NULL COMMENT '货物重量(吨)',
    164. 

  164.   `grh_state` int NULL DEFAULT NULL COMMENT '审核状态0-未提交1-审核中2-审核成功3-审核失败',
    165. 

  165.   `grh_goods_level` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '货物等级',
    166. 

  166.   `grh_has_log_off` int NULL DEFAULT NULL COMMENT '是否注销1-已注销0-未注销',
    167. 

  167.   `grh_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '地址',
    168. 

  168.   `grh_registrant` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '登记人',
    169. 

  169.   `grh_review_id` bigint NULL DEFAULT NULL COMMENT '审核人id',
    170. 

  170.   `grh_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '备注',
    171. 

  171.   `grh_board_data` json NULL COMMENT '粮权牌数据',
    172. 

  172.   `grh_file_data` json NULL COMMENT '文件数据',
    173. 

  173.   `creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
    174. 

  174.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '创建人',
    175. 

  175.   `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
    176. 

  176.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '更新人',
    177. 

  177.   `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    178. 

  178.   `has_deleted` int NULL DEFAULT NULL COMMENT '是否删除0-否1-是',
    179. 

  179.   PRIMARY KEY (`grh_id`) USING BTREE
    180. 

  180. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '粮权历史' ROW_FORMAT = Dynamic;
    181. 

  181. 

  182. -- ----------------------------
    183. 

  183. -- Records of grain_right_history
    184. 

  184. -- ----------------------------
    185. 

  185. INSERT INTO `grain_right_history` VALUES (1, 1, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[{\"id\": \"1111\", \"boardNo\": \"2222\", \"createBy\": \"1\", \"createTime\": \"2023-08-25 16:21:04\", \"enterpriseName\": \"测试企业123\"}, {\"id\": \"123\", \"boardNo\": \"22223\", \"createBy\": \"1\", \"createTime\": \"2023-08-25 16:21:04\", \"enterpriseName\": \"测试企业123\"}]', NULL, 1, '1', '2023-08-29 10:59:02', '1', '2023-08-29 10:59:06', 0);
    186. 

  186. INSERT INTO `grain_right_history` VALUES (1696366459110596610, 1, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:37:35\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:37:35\"}]', NULL, NULL, NULL, '2023-08-29 11:37:35', '测试用户', '2023-08-29 11:37:35', NULL);
    187. 

  187. INSERT INTO `grain_right_history` VALUES (1696366802955444226, 1, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:38:51\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:38:51\"}]', NULL, NULL, NULL, '2023-08-29 11:38:57', '测试用户', '2023-08-29 11:38:57', NULL);
    188. 

  188. INSERT INTO `grain_right_history` VALUES (1696366851970080770, 1696366851907166210, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1696366851907166210, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:39:09\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1696366851907166210, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:39:09\"}]', NULL, 2, '测试用户', '2023-08-29 11:39:09', '测试用户', '2023-08-29 11:39:09', 0);
    189. 

  189. INSERT INTO `grain_right_history` VALUES (1696366924711895042, 1696366924711895041, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1696366924711895041, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:39:26\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1696366924711895041, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:39:26\"}]', NULL, 2, '测试用户', '2023-08-29 11:39:26', '测试用户', '2023-08-29 11:39:26', 0);
    190. 

  190. INSERT INTO `grain_right_history` VALUES (1696367289159163905, 1696367067884462082, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1696367067884462082, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:40:44\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1696367067884462082, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:40:44\"}]', NULL, 2, '测试用户', '2023-08-29 11:40:53', '测试用户', '2023-08-29 11:40:53', 0);
    191. 

  191. INSERT INTO `grain_right_history` VALUES (1696367643535908865, 1696367369333284865, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1696367369333284865, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:42:18\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1696367369333284865, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:42:18\"}]', NULL, 2, '测试用户', '2023-08-29 11:42:18', '测试用户', '2023-08-29 11:42:18', 0);
    192. 

  192. INSERT INTO `grain_right_history` VALUES (1696368391137112065, 1696368390755430402, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1696368390755430402, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:45:16\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1696368390755430402, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:45:16\"}]', NULL, 2, '测试用户', '2023-08-29 11:45:16', '测试用户', '2023-08-29 11:45:16', 0);
    193. 

  193. INSERT INTO `grain_right_history` VALUES (1696368574432391169, 1696368445264605185, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1696368445264605185, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:46:00\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1696368445264605185, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:46:00\"}]', NULL, 2, '测试用户', '2023-08-29 11:46:00', '测试用户', '2023-08-29 11:46:00', 0);
    194. 

  194. INSERT INTO `grain_right_history` VALUES (1696369105422786562, 1696369105045299202, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1696369105045299202, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:48:06\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1696369105045299202, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:48:06\"}]', NULL, 2, '测试用户', '2023-08-29 11:48:06', '测试用户', '2023-08-29 11:48:06', 0);
    195. 

  195. INSERT INTO `grain_right_history` VALUES (1696369793422942209, 1696369792789602305, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1696369792789602305, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:50:50\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1696369792789602305, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:50:50\"}]', NULL, 2, '测试用户', '2023-08-29 11:50:50', '测试用户', '2023-08-29 11:50:50', 0);
    196. 

  196. INSERT INTO `grain_right_history` VALUES (1696369848963915777, 1696369848896806913, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1696369848896806913, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:51:04\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1696369848896806913, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T11:51:04\"}]', NULL, 2, '测试用户', '2023-08-29 11:51:04', '测试用户', '2023-08-29 11:51:04', 0);
    197. 

  197. INSERT INTO `grain_right_history` VALUES (1696419139170414594, 1696419138679681026, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1696419138679681026, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T15:06:55\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1696419138679681026, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-29T15:06:55\"}]', NULL, 2, '测试用户', '2023-08-29 15:06:55', '测试用户', '2023-08-29 15:06:55', 0);
    198. 

  198. INSERT INTO `grain_right_history` VALUES (1696419263577665538, 1696419263514750978, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', NULL, 2, '测试用户', '2023-08-29 15:07:25', '测试用户', '2023-08-29 15:07:25', 0);
    199. 

  199. INSERT INTO `grain_right_history` VALUES (1696419311342399489, 1696419311304650753, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', NULL, 2, '测试用户', '2023-08-29 15:07:36', '测试用户', '2023-08-29 15:07:36', 0);
    200. 

  200. INSERT INTO `grain_right_history` VALUES (1696419853238087682, 1696419807889272834, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', NULL, 2, '测试用户', '2023-08-29 15:09:46', '测试用户', '2023-08-29 15:09:46', 0);
    201. 

  201. INSERT INTO `grain_right_history` VALUES (1696420783870275585, 1696420754329792514, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', NULL, 2, '测试用户', '2023-08-29 15:13:28', '测试用户', '2023-08-29 15:13:28', 0);
    202. 

  202. INSERT INTO `grain_right_history` VALUES (1696420820289417217, 1696420798684557313, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', NULL, 2, '测试用户', '2023-08-29 15:13:36', '测试用户', '2023-08-29 15:13:36', 0);
    203. 

  203. INSERT INTO `grain_right_history` VALUES (1696421647632678914, 1696421647250997250, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', NULL, 2, '测试用户', '2023-08-29 15:16:53', '测试用户', '2023-08-29 15:16:53', 0);
    204. 

  204. INSERT INTO `grain_right_history` VALUES (1696422056334049282, 1696422056266940418, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', NULL, 2, '测试用户', '2023-08-29 15:18:31', '测试用户', '2023-08-29 15:18:31', 0);
    205. 

  205. INSERT INTO `grain_right_history` VALUES (1696424154131963905, 1696424153599287297, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', NULL, 2, '测试用户', '2023-08-29 15:26:51', '测试用户', '2023-08-29 15:26:51', 0);
    206. 

  206. INSERT INTO `grain_right_history` VALUES (1696425126585442306, 1696425126061154306, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', NULL, 2, '测试用户', '2023-08-29 15:30:43', '测试用户', '2023-08-29 15:30:43', 0);
    207. 

  207. INSERT INTO `grain_right_history` VALUES (1696426414194892801, 1696426413611884546, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', NULL, 2, '测试用户', '2023-08-29 15:35:50', '测试用户', '2023-08-29 15:35:50', 0);
    208. 

  208. INSERT INTO `grain_right_history` VALUES (1696426449007616002, 1696426448940507138, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', NULL, 2, '测试用户', '2023-08-29 15:35:58', '测试用户', '2023-08-29 15:35:58', 0);
    209. 

  209. INSERT INTO `grain_right_history` VALUES (1697067110299951106, 1697067109947629569, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697067109947629569, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:01:44\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697067109947629569, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:01:44\"}]', NULL, 2, '测试用户', '2023-08-31 10:01:44', '测试用户', '2023-08-31 10:01:44', 0);
    210. 

  210. INSERT INTO `grain_right_history` VALUES (1697072666871951361, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:23:48\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:23:48\"}]', NULL, 2, '测试用户', '2023-08-31 10:23:49', '测试用户', '2023-08-31 10:23:49', 0);
    211. 

  211. INSERT INTO `grain_right_history` VALUES (1697072754402881538, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:24:09\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:24:09\"}]', NULL, NULL, NULL, '2023-08-31 10:24:09', '测试用户', '2023-08-31 10:24:09', NULL);
    212. 

  212. INSERT INTO `grain_right_history` VALUES (1697072881477709826, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:24:40\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:24:40\"}]', NULL, NULL, NULL, '2023-08-31 10:24:40', '测试用户', '2023-08-31 10:24:40', NULL);
    213. 

  213. INSERT INTO `grain_right_history` VALUES (1697073636540510210, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:27:40\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:27:40\"}]', NULL, NULL, NULL, '2023-08-31 10:27:40', '测试用户', '2023-08-31 10:27:40', NULL);
    214. 

  214. INSERT INTO `grain_right_history` VALUES (1697074498998493186, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:31:05\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:31:05\"}]', NULL, NULL, NULL, '2023-08-31 10:31:05', '测试用户', '2023-08-31 10:31:05', NULL);
    215. 

  215. INSERT INTO `grain_right_history` VALUES (1697074835494920194, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:32:26\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:32:26\"}]', NULL, NULL, NULL, '2023-08-31 10:32:26', '测试用户', '2023-08-31 10:32:26', NULL);
    216. 

  216. INSERT INTO `grain_right_history` VALUES (1697075233937022978, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:34:01\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:34:01\"}]', NULL, NULL, NULL, '2023-08-31 10:34:01', '测试用户', '2023-08-31 10:34:01', NULL);
    217. 

  217. INSERT INTO `grain_right_history` VALUES (1697075443455090689, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:34:51\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:34:51\"}]', NULL, NULL, NULL, '2023-08-31 10:34:51', '测试用户', '2023-08-31 10:34:51', NULL);
    218. 

  218. INSERT INTO `grain_right_history` VALUES (1697075570613805057, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:35:21\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:35:21\"}]', NULL, NULL, NULL, '2023-08-31 10:35:21', '测试用户', '2023-08-31 10:35:21', NULL);
    219. 

  219. INSERT INTO `grain_right_history` VALUES (1697075804135874562, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:36:17\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:36:17\"}]', NULL, NULL, NULL, '2023-08-31 10:36:17', '测试用户', '2023-08-31 10:36:17', NULL);
    220. 

  220. INSERT INTO `grain_right_history` VALUES (1697075852747857922, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:36:28\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:36:28\"}]', NULL, NULL, NULL, '2023-08-31 10:36:28', '测试用户', '2023-08-31 10:36:28', NULL);
    221. 

  221. INSERT INTO `grain_right_history` VALUES (1697076771296239618, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:40:07\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:40:07\"}]', NULL, NULL, NULL, '2023-08-31 10:40:07', '测试用户', '2023-08-31 10:40:07', NULL);
    222. 

  222. INSERT INTO `grain_right_history` VALUES (1697076804699676674, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:40:15\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:40:15\"}]', NULL, NULL, NULL, '2023-08-31 10:40:15', '测试用户', '2023-08-31 10:40:15', NULL);
    223. 

  223. INSERT INTO `grain_right_history` VALUES (1697077631774482435, 1697077631774482434, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697077631774482434, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:43:32\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697077631774482434, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:43:32\"}]', NULL, 2, '测试用户', '2023-08-31 10:43:32', '测试用户', '2023-08-31 10:43:32', 0);
    224. 

  224. INSERT INTO `grain_right_history` VALUES (1697078008003440642, 1697078007563038721, NULL, NULL, '仓库名称', '库区名称', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697078007563038721, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:45:02\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697078007563038721, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:45:02\"}]', NULL, 2, '测试用户', '2023-08-31 10:45:02', '测试用户', '2023-08-31 10:45:02', 0);
    225. 

  225. INSERT INTO `grain_right_history` VALUES (1697088252607823874, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T11:25:44\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T11:25:44\"}]', 'null', NULL, NULL, '2023-08-31 11:25:44', '测试用户', '2023-08-31 11:25:44', NULL);
    226. 

  226. INSERT INTO `grain_right_history` VALUES (1697088672445050881, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T11:27:24\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T11:27:24\"}]', '[{\"ffId\": 1697072666939060225, \"ffBizId\": 1697072666486075393, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"ffBizType\": 1, \"createTime\": \"2023-08-31T10:23:49\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:23:49\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697072666939060226, \"ffBizId\": 1697072666486075393, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"ffBizType\": 1, \"createTime\": \"2023-08-31T10:23:49\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:23:49\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-08-31 11:27:25', '测试用户', '2023-08-31 11:27:25', NULL);
    227. 

  227. INSERT INTO `grain_right_history` VALUES (1697089322641862657, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T11:29:10\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T11:29:10\"}]', '[{\"ffId\": 1697072666939060225, \"ffBizId\": 1697072666486075393, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"ffBizType\": 1, \"createTime\": \"2023-08-31T10:23:49\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:23:49\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697072666939060226, \"ffBizId\": 1697072666486075393, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"ffBizType\": 1, \"createTime\": \"2023-08-31T10:23:49\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:23:49\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-08-31 11:30:00', '测试用户', '2023-08-31 11:30:00', NULL);
    228. 

  228. INSERT INTO `grain_right_history` VALUES (1697090040178225153, 1697072666486075393, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T11:32:51\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T11:32:51\"}]', '[{\"ffId\": 1697072666939060225, \"ffBizId\": 1697072666486075393, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"ffBizType\": 1, \"createTime\": \"2023-08-31T10:23:49\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:23:49\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697072666939060226, \"ffBizId\": 1697072666486075393, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"ffBizType\": 1, \"createTime\": \"2023-08-31T10:23:49\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:23:49\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-08-31 11:32:51', '测试用户', '2023-08-31 11:32:51', NULL);
    229. 

  229. INSERT INTO `grain_right_history` VALUES (1697091084798980097, 1697072666486075393, NULL, 'LQ005', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T11:37:00\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697072666486075393, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T11:37:00\"}]', '[{\"ffId\": 1697072666939060225, \"ffBizId\": 1697072666486075393, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"ffBizType\": 1, \"createTime\": \"2023-08-31T10:23:49\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:23:49\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697072666939060226, \"ffBizId\": 1697072666486075393, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"ffBizType\": 1, \"createTime\": \"2023-08-31T10:23:49\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T10:23:49\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-08-31 11:37:00', '测试用户', '2023-08-31 11:37:00', NULL);
    230. 

  230. INSERT INTO `grain_right_history` VALUES (1697127602896797697, 1697127602284429313, NULL, 'LQ202308310001', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697127602284429313, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:02:06\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697127602284429313, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:02:06\"}]', '[{\"ffId\": 1697127602640945154, \"ffBizId\": 1697127602284429313, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:02:06\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:02:06\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-08-31 14:02:06', '测试用户', '2023-08-31 14:02:06', 0);
    231. 

  231. INSERT INTO `grain_right_history` VALUES (1697127656076378113, 1697127655946354690, NULL, 'LQ202308310002', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697127655946354690, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:02:19\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697127655946354690, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:02:19\"}]', '[{\"ffId\": 1697127656013463554, \"ffBizId\": 1697127655946354690, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:02:19\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:02:19\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-08-31 14:02:19', '测试用户', '2023-08-31 14:02:19', 0);
    232. 

  232. INSERT INTO `grain_right_history` VALUES (1697132240136085506, 1697132239678906369, NULL, 'LQ202308310003', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697132239678906369, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697132239678906369, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\"}]', '[{\"ffId\": 1697132239934758913, \"ffBizId\": 1697132239678906369, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:20:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697132239934758914, \"ffBizId\": 1697132239678906369, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:20:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-08-31 14:20:32', '测试用户', '2023-08-31 14:20:32', 0);
    233. 

  233. INSERT INTO `grain_right_history` VALUES (1697133683740061697, 1697132239678906369, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697132239678906369, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:26:16\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697132239678906369, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:26:16\"}]', '[{\"ffId\": 1697132239934758913, \"ffBizId\": 1697132239678906369, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:20:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697132239934758914, \"ffBizId\": 1697132239678906369, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:20:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-08-31 14:26:16', '测试用户', '2023-08-31 14:26:16', NULL);
    234. 

  234. INSERT INTO `grain_right_history` VALUES (1697133849851277314, 1697132239678906369, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697132239678906369, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:26:50\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697132239678906369, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:26:50\"}]', '[{\"ffId\": 1697132239934758913, \"ffBizId\": 1697132239678906369, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:20:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697132239934758914, \"ffBizId\": 1697132239678906369, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:20:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-08-31 14:26:56', '测试用户', '2023-08-31 14:26:56', NULL);
    235. 

  235. INSERT INTO `grain_right_history` VALUES (1697133881941897218, 1697132239678906369, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697132239678906369, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:27:02\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697132239678906369, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:27:02\"}]', '[{\"ffId\": 1697132239934758913, \"ffBizId\": 1697132239678906369, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:20:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697132239934758914, \"ffBizId\": 1697132239678906369, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:20:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-08-31 14:27:03', '测试用户', '2023-08-31 14:27:03', NULL);
    236. 

  236. INSERT INTO `grain_right_history` VALUES (1697133981481119745, 1697132239678906369, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697132239678906369, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:27:12\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697132239678906369, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:27:12\"}]', '[{\"ffId\": 1697132239934758913, \"ffBizId\": 1697132239678906369, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:20:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697132239934758914, \"ffBizId\": 1697132239678906369, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:20:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:20:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-08-31 14:27:27', '测试用户', '2023-08-31 14:27:27', NULL);
    237. 

  237. INSERT INTO `grain_right_history` VALUES (1697134450639187970, 1697134450572079106, NULL, 'LQ202308310004', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697134450572079106, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:29:19\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697134450572079106, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:29:19\"}]', '[{\"ffId\": 1697132239934758913, \"ffBizId\": 1697134450572079106, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:29:19\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:29:19\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697132239934758913, \"ffBizId\": 1697134450572079106, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-08-31T14:29:19\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:29:19\", \"ffRelativePath\": \"\\\\grain-right\\\\1bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-08-31 14:29:19', '测试用户', '2023-08-31 14:29:19', 0);
    238. 

  238. INSERT INTO `grain_right_history` VALUES (1697134629845020674, 1697134450572079106, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1697134450572079106, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:30:00\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1697134450572079106, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-08-31T14:30:00\"}]', '[]', NULL, NULL, '2023-08-31 14:30:02', '测试用户', '2023-08-31 14:30:02', NULL);
    239. 

  239. INSERT INTO `grain_right_history` VALUES (1698605950529499137, 1698605949896159233, NULL, 'LQ202309040005', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1698605949896159233, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:56:32\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1698605949896159233, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:56:32\"}]', '[{\"ffId\": 1697132239934758913, \"ffBizId\": 1698605949896159233, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-04T15:56:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:56:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697132239934758914, \"ffBizId\": 1698605949896159233, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-04T15:56:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:56:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-04 15:56:32', '测试用户', '2023-09-04 15:56:32', 0);
    240. 

  240. INSERT INTO `grain_right_history` VALUES (1698606261155459073, 1698605949896159233, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1698605949896159233, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:57:46\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1698605949896159233, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:57:46\"}]', '[{\"ffId\": 1697132239934758913, \"ffBizId\": 1698605949896159233, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-04T15:56:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:56:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697132239934758914, \"ffBizId\": 1698605949896159233, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-04T15:56:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:56:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-09-04 15:57:46', '测试用户', '2023-09-04 15:57:46', NULL);
    241. 

  241. INSERT INTO `grain_right_history` VALUES (1698606863419764738, 1698605949896159233, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1698605949896159233, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:58:25\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1698605949896159233, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:58:25\"}]', '[{\"ffId\": 1697132239934758913, \"ffBizId\": 1698605949896159233, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-04T15:56:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:56:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697132239934758914, \"ffBizId\": 1698605949896159233, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-04T15:56:32\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T15:56:32\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-09-04 16:00:09', '测试用户', '2023-09-04 16:00:09', NULL);
    242. 

  242. INSERT INTO `grain_right_history` VALUES (1698606985163632642, 1698606971674750978, NULL, 'LQ202309040006', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1698606971674750978, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T16:00:35\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1698606971674750978, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T16:00:35\"}]', '[{\"ffId\": 1697132239934758913, \"ffBizId\": 1698606971674750978, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-04T16:00:39\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T16:00:39\", \"ffRelativePath\": \"\\\\grain-right\\\\2bf485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}, {\"ffId\": 1697132239934758914, \"ffBizId\": 1698606971674750978, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-04T16:00:39\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T16:00:39\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-04 16:00:39', '测试用户', '2023-09-04 16:00:39', 0);
    243. 

  243. INSERT INTO `grain_right_history` VALUES (1698607114604048386, 1698606971674750978, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1698606971674750978, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T16:01:09\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1698606971674750978, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T16:01:09\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1698606971674750978, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-04T16:00:39\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T16:00:39\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-09-04 16:01:09', '测试用户', '2023-09-04 16:01:09', NULL);
    244. 

  244. INSERT INTO `grain_right_history` VALUES (1698609691609616385, 1698609691018219522, NULL, 'LQ202309040007', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1698609691018219522, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T16:11:24\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1698609691018219522, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T16:11:24\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1698609691018219522, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-04T16:11:24\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-04T16:11:24\", \"ffRelativePath\": \"\\\\grain-right\\\\133485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-04 16:11:24', '测试用户', '2023-09-04 16:11:24', 0);
    245. 

  245. INSERT INTO `grain_right_history` VALUES (1699589242586218497, 1699589242116456449, NULL, 'LQ202309070001', '1', '1', '1', '11', '1', '1', '1', 1.000, NULL, '1', NULL, '1', '1', NULL, NULL, '[{\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1699589242116456449, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T09:03:47\"}]', '[{\"ffId\": 1699589242317783041, \"ffBizId\": 1699589242116456449, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-07T09:03:47\", \"ffFileName\": \"SitnsrGzt8sEeaf5fd5732689ed5608e9a349ad3ef6e.png\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T09:03:47\", \"ffRelativePath\": \"\\\\grain-right\\\\ad0a83975932475d8fd0a034e91cab3f\\\\SitnsrGzt8sEeaf5fd5732689ed5608e9a349ad3ef6e.png\"}]', 2, '测试用户', '2023-09-07 09:03:47', '测试用户', '2023-09-07 09:03:47', 0);
    246. 

  246. INSERT INTO `grain_right_history` VALUES (1699597889244557313, 1699597888359559169, NULL, 'LQ202309070002', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1699597888359559169, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T09:38:08\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1699597888359559169, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T09:38:08\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1699597888359559169, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-07T09:38:08\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T09:38:08\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-07 09:38:08', '测试用户', '2023-09-07 09:38:08', 0);
    247. 

  247. INSERT INTO `grain_right_history` VALUES (1699630907451600898, 1699630906977644545, NULL, 'LQ202309070003', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1699630906977644545, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T11:49:21\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1699630906977644545, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-07T11:49:21\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T11:49:21\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-07 11:49:21', '测试用户', '2023-09-07 11:49:21', 0);
    248. 

  248. INSERT INTO `grain_right_history` VALUES (1699684907345530881, 1699684907043540994, NULL, 'LQ202309070011', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1699684907043540994, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:23:55\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1699684907043540994, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:23:55\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1699684907043540994, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-07T15:23:55\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:23:55\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-07 15:23:55', '测试用户', '2023-09-07 15:23:55', 0);
    249. 

  249. INSERT INTO `grain_right_history` VALUES (1699685017844469762, 1699685017781555202, NULL, 'LQ202309070013', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 123, \"grbNo\": \"22223\", \"seName\": \"测试企业123\", \"grbGrId\": 1699685017781555202, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:24:22\"}, {\"grbId\": 1112311, \"grbNo\": \"2222123212\", \"seName\": \"测试企业123\", \"grbGrId\": 1699685017781555202, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:24:22\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1699685017781555202, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-07T15:24:22\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:24:22\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-07 15:24:22', '测试用户', '2023-09-07 15:24:22', 0);
    250. 

  250. INSERT INTO `grain_right_history` VALUES (1699686233089576961, 1699686232569483265, NULL, 'LQ202309070016', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 1695997105026154497, \"grbNo\": \"121333\", \"seName\": \"测试企业123\", \"grbGrId\": 1699686232569483265, \"grbSeId\": 1694620844743761922, \"createBy\": \"测试\", \"updateBy\": \"测试\", \"createTime\": \"2023-08-28T11:09:55\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:29:11\"}, {\"grbId\": 1111, \"grbNo\": \"2222\", \"seName\": \"测试企业123\", \"grbGrId\": 1699686232569483265, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:29:11\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1699686232569483265, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-07T15:29:11\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:29:11\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-07 15:29:11', '测试用户', '2023-09-07 15:29:11', 0);
    251. 

  251. INSERT INTO `grain_right_history` VALUES (1699686453282148354, 1699686232569483265, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 1695997105026154497, \"grbNo\": \"121333\", \"seName\": \"测试企业123\", \"grbGrId\": 1699686232569483265, \"grbSeId\": 1694620844743761922, \"createBy\": \"测试\", \"updateBy\": \"测试\", \"createTime\": \"2023-08-28T11:09:55\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:30:04\"}, {\"grbId\": 1111, \"grbNo\": \"2222\", \"seName\": \"测试企业123\", \"grbGrId\": 1699686232569483265, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:30:04\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1699686232569483265, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-07T15:29:11\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:29:11\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-09-07 15:30:04', '测试用户', '2023-09-07 15:30:04', NULL);
    252. 

  252. INSERT INTO `grain_right_history` VALUES (1699686485729284097, 1699686232569483265, NULL, NULL, '仓库名称', '库区名称21', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 1695997105026154497, \"grbNo\": \"121333\", \"seName\": \"测试企业123\", \"grbGrId\": 1699686232569483265, \"grbSeId\": 1694620844743761922, \"createBy\": \"测试\", \"updateBy\": \"测试\", \"createTime\": \"2023-08-28T11:09:55\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:30:11\"}, {\"grbId\": 1111, \"grbNo\": \"2222\", \"seName\": \"测试企业123\", \"grbGrId\": 1699686232569483265, \"grbSeId\": 1694620844743761922, \"createBy\": \"1\", \"createTime\": \"2023-08-25T16:21:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:30:11\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1699686232569483265, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-07T15:29:11\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:29:11\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-09-07 15:30:12', '测试用户', '2023-09-07 15:30:12', NULL);
    253. 

  253. INSERT INTO `grain_right_history` VALUES (1699687957653147649, 1699687957099499521, NULL, 'LQ202309070019', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 1695997898311647233, \"grbNo\": \"121322\", \"seName\": \"测试企业123\", \"grbGrId\": 1699687957099499521, \"grbSeId\": 1694620844743761922, \"createBy\": \"测试\", \"updateBy\": \"测试\", \"createTime\": \"2023-08-28T11:13:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:36:02\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1699687957099499521, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-07T15:36:02\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:36:02\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-07 15:36:02', '测试用户', '2023-09-07 15:36:02', 0);
    254. 

  254. INSERT INTO `grain_right_history` VALUES (1701767484164341761, 1701767483707162625, NULL, 'LQ202309130003', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 1695998524386975746, \"grbNo\": \"0114\", \"seName\": \"测试企业123\", \"grbGrId\": 1701767483707162625, \"grbSeId\": 1694620844743761922, \"createBy\": \"测试\", \"updateBy\": \"测试\", \"creatorId\": 1, \"createTime\": \"2023-08-28T11:15:33\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-13T09:19:20\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1701767483707162625, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-13T09:19:20\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-13T09:19:20\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-13 09:19:20', '测试用户', '2023-09-13 09:19:20', 0);
    255. 

  255. INSERT INTO `grain_right_history` VALUES (1702605455750868993, 1702605455180443650, NULL, 'LQ202309150004', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1702605455180443650, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-15T16:49:08\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-15T16:49:08\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-15 16:49:08', '测试用户', '2023-09-15 16:49:08', 0);
    256. 

  256. INSERT INTO `grain_right_history` VALUES (1702606397602799618, 1702606396994625537, NULL, 'LQ202309150005', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1702606396994625537, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-15T16:52:53\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-15T16:52:53\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-15 16:52:53', '测试用户', '2023-09-15 16:52:53', 0);
    257. 

  257. INSERT INTO `grain_right_history` VALUES (1702606684602245121, 1702606684501581825, NULL, 'LQ202309150006', '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1702606684501581825, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-15T16:54:01\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-15T16:54:01\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', 2, '测试用户', '2023-09-15 16:54:01', '测试用户', '2023-09-15 16:54:01', 0);
    258. 

  258. INSERT INTO `grain_right_history` VALUES (1702609145501061122, 1699686232569483265, NULL, NULL, '仓库名称', '库区名称1', '质权方', '存货方', '保管方', '库方为空', '货物品种', 1000.000, NULL, '货物等级', NULL, '地址', '登记人', NULL, NULL, '[{\"grbId\": 1695998524386975746, \"grbNo\": \"0114\", \"seName\": \"测试企业\", \"grbGrId\": 1699686232569483265, \"grbSeId\": 1694621216858218498, \"createBy\": \"测试\", \"updateBy\": \"测试\", \"creatorId\": 1, \"createTime\": \"2023-08-28T11:15:33\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-15T17:03:48\"}, {\"grbId\": 1695997898311647233, \"grbNo\": \"0112\", \"seName\": \"测试企业123\", \"grbGrId\": 1699686232569483265, \"grbSeId\": 1694620844743761922, \"createBy\": \"测试\", \"updateBy\": \"测试\", \"createTime\": \"2023-08-28T11:13:04\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-15T17:03:48\"}, {\"grbId\": 1695997105026154497, \"grbNo\": \"0111\", \"seName\": \"测试企业123\", \"grbGrId\": 1699686232569483265, \"grbSeId\": 1694620844743761922, \"createBy\": \"测试\", \"updateBy\": \"测试\", \"createTime\": \"2023-08-28T11:09:55\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-15T17:03:48\"}]', '[{\"ffId\": 1697132239934758914, \"ffBizId\": 1699686232569483265, \"createBy\": \"测试用户\", \"updateBy\": \"测试\", \"creatorId\": 2, \"ffBizType\": 1, \"createTime\": \"2023-09-07T15:29:11\", \"ffFileName\": \"微信图片_20230814113826.jpg\", \"hasDeleted\": 0, \"updateTime\": \"2023-09-07T15:29:11\", \"ffRelativePath\": \"\\\\grain-right\\\\123485f5d130436da81deb476d9ad4e4\\\\微信图片_20230814113826.jpg\"}]', NULL, NULL, '2023-09-15 17:03:48', '测试用户', '2023-09-15 17:03:48', NULL);
    259. 

  259. 

  260. -- ----------------------------
    261. 

  261. -- Table structure for grain_right_subscription
    262. 

  262. -- ----------------------------
    263. 

  263. DROP TABLE IF EXISTS `grain_right_subscription`;
    264. 

  264. CREATE TABLE `grain_right_subscription`  (
    265. 

  265.   `grs_id` bigint NOT NULL COMMENT '主键id',
    266. 

  266.   `grs_gr_id` bigint NULL DEFAULT NULL COMMENT '粮权id',
    267. 

  267.   `subscribe_id` bigint NULL DEFAULT NULL COMMENT '订阅人',
    268. 

  268.   `creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
    269. 

  269.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '创建人',
    270. 

  270.   `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
    271. 

  271.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '更新人',
    272. 

  272.   `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    273. 

  273.   `has_deleted` int NULL DEFAULT NULL COMMENT '是否删除0-否1-是',
    274. 

  274.   PRIMARY KEY (`grs_id`) USING BTREE
    275. 

  275. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '粮权公告订阅' ROW_FORMAT = Dynamic;
    276. 

  276. 

  277. -- ----------------------------
    278. 

  278. -- Records of grain_right_subscription
    279. 

  279. -- ----------------------------
    280. 

  280. INSERT INTO `grain_right_subscription` VALUES (1, 1701767483707162625, 2, 3, '1', '2023-08-29 14:37:26', '测试用户', '2023-08-29 15:03:57', 0);
    281. 

  281. INSERT INTO `grain_right_subscription` VALUES (1696418293963632641, 1699687957099499521, 2, 2, '测试用户', '2023-08-29 15:03:34', '测试用户', '2023-08-29 15:04:12', 0);
    282. 

  282. INSERT INTO `grain_right_subscription` VALUES (1702165125377388545, 1697077631774482434, 2, 2, '测试用户', '2023-09-14 11:39:25', '测试用户', '2023-09-14 11:39:25', 0);
    283. 

  283. 

  284. -- ----------------------------
    285. 

  285. -- Table structure for sys_enterprise
    286. 

  286. -- ----------------------------
    287. 

  287. DROP TABLE IF EXISTS `sys_enterprise`;
    288. 

  288. CREATE TABLE `sys_enterprise`  (
    289. 

  289.   `se_id` bigint NOT NULL COMMENT '主键id',
    290. 

  290.   `se_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '企业编号',
    291. 

  291.   `se_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '企业名称',
    292. 

  292.   `se_legal_person_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '法人名称',
    293. 

  293.   `se_phone_no` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '联系方式',
    294. 

  294.   `se_enabled` int NULL DEFAULT NULL COMMENT '禁用状态1-正常0-禁用',
    295. 

  295.   `creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
    296. 

  296.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '创建人',
    297. 

  297.   `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
    298. 

  298.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '更新人',
    299. 

  299.   `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    300. 

  300.   `has_deleted` int NULL DEFAULT NULL COMMENT '是否删除0-否1-是',
    301. 

  301.   PRIMARY KEY (`se_id`) USING BTREE
    302. 

  302. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '企业' ROW_FORMAT = Dynamic;
    303. 

  303. 

  304. -- ----------------------------
    305. 

  305. -- Records of sys_enterprise
    306. 

  306. -- ----------------------------
    307. 

  307. INSERT INTO `sys_enterprise` VALUES (1694620844743761922, '91440300MA5H97798E', '测试企业123', '李四', '13050673470', 1, NULL, NULL, '2023-08-24 16:01:09', NULL, '2023-08-24 16:33:14', 0);
    308. 

  308. INSERT INTO `sys_enterprise` VALUES (1694621216858218498, '91440300MA5H97798E', '测试企业', '张三', '13050673470', 1, NULL, NULL, '2023-08-24 16:02:37', NULL, '2023-08-28 09:19:06', 0);
    309. 

  309. INSERT INTO `sys_enterprise` VALUES (1694624147221377025, '91440300MA5H97798E', '测试企业', '张三', '13050673470', 1, NULL, NULL, '2023-08-24 16:14:16', NULL, '2023-08-24 16:14:16', 0);
    310. 

  310. 

  311. -- ----------------------------
    312. 

  312. -- Table structure for sys_user
    313. 

  313. -- ----------------------------
    314. 

  314. DROP TABLE IF EXISTS `sys_user`;
    315. 

  315. CREATE TABLE `sys_user`  (
    316. 

  316.   `su_id` bigint NOT NULL COMMENT '主键id',
    317. 

  317.   `su_username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户名',
    318. 

  318.   `su_password` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '密码',
    319. 

  319.   `su_password_salt` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '密码盐',
    320. 

  320.   `su_real_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '真实姓名',
    321. 

  321.   `su_gender` int NULL DEFAULT NULL COMMENT '性别1-男2-女',
    322. 

  322.   `su_phone_no` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
    323. 

  323.   `su_se_id` bigint NULL DEFAULT NULL COMMENT '企业id',
    324. 

  324.   `su_user_type` int NULL DEFAULT NULL COMMENT '用户类型1-超级管理员2-系统用户3-普通用户',
    325. 

  325.   `su_enabled` int NULL DEFAULT NULL COMMENT '用户禁用状态1-正常0-禁用',
    326. 

  326.   `creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
    327. 

  327.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '创建人',
    328. 

  328.   `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
    329. 

  329.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '更新人',
    330. 

  330.   `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
    331. 

  331.   `has_deleted` int NULL DEFAULT NULL COMMENT '是否删除0-否1-是',
    332. 

  332.   PRIMARY KEY (`su_id`) USING BTREE,
    333. 

  333.   UNIQUE INDEX `su_username_unique`(`su_username` ASC) USING BTREE
    334. 

  334. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = Dynamic;
    335. 

  335. 

  336. -- ----------------------------
    337. 

  337. -- Records of sys_user
    338. 

  338. -- ----------------------------
    339. 

  339. INSERT INTO `sys_user` VALUES (1, 'admin', 'c562a37d599182bf58a9aa3993669ffd', 'grain-search', '测试', 1, '13050673470', 1694621216858218498, 1, 1, NULL, NULL, NULL, NULL, NULL, 0);
    340. 

  340. INSERT INTO `sys_user` VALUES (2, 'appAdmin', 'c562a37d599182bf58a9aa3993669ffd', 'grain-search', '测试用户', 1, '18241771147', 1694621216858218498, 3, 1, NULL, NULL, NULL, '测试', '2023-08-25 14:33:55', 0);
    341. 

  341. INSERT INTO `sys_user` VALUES (3, 'csyh1', 'c562a37d599182bf58a9aa3993669ffd', 'grain-search', '测试用户', 1, '18241771147', 1694621216858218498, 2, 1, NULL, NULL, NULL, '测试', '2023-08-25 14:33:09', 0);
    342. 

  342. INSERT INTO `sys_user` VALUES (4, 'admin3', 'c562a37d599182bf58a9aa3993669ffd', 'grain-search', '测试', 1, '13050673470', 1694621216858218498, 1, 1, NULL, NULL, NULL, '测试', '2023-08-25 14:34:38', 0);
    343. 

  343. INSERT INTO `sys_user` VALUES (1694922503659290625, 'csyh2', 'c562a37d599182bf58a9aa3993669ffd', 'grain-search', '测试用户', 1, '18241771147', 1694621216858218498, 2, 1, NULL, '测试', '2023-08-25 11:59:50', '测试', '2023-08-25 14:34:53', 0);
    344. 

  344. INSERT INTO `sys_user` VALUES (1694922785180975105, 'csyh3', 'ede2328575faf4ab72db845657ed3e34', 'grain-search', '测试用户', 1, '18241771147', 1694621216858218498, 2, 1, NULL, '测试', '2023-08-25 12:00:57', '测试', '2023-08-25 14:42:42', 0);
    345. 

  345. INSERT INTO `sys_user` VALUES (1702225979720437761, 'ccjjj', '308b9d347d6b69b7475721c6daf28f35', '4914aebc-5f24-48', '真实姓名', 2, '18241771147', 1694621216858218498, 3, 1, 2, '测试用户', '2023-09-14 15:41:14', '测试用户', '2023-09-14 15:41:14', 0);
    346. 

  346. 

  347. -- ----------------------------
    348. 

  348. -- Table structure for test_table
    349. 

  349. -- ----------------------------
    350. 

  350. DROP TABLE IF EXISTS `test_table`;
    351. 

  351. CREATE TABLE `test_table`  (
    352. 

  352.   `id` bigint NOT NULL AUTO_INCREMENT,
    353. 

  353.   `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容',
    354. 

  354.   `creator_id` bigint NULL DEFAULT NULL COMMENT '创建人id',
    355. 

  355.   `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    356. 

  356.   `create_time` datetime NULL DEFAULT NULL,
    357. 

  357.   `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    358. 

  358.   `update_time` datetime NULL DEFAULT NULL,
    359. 

  359.   `has_deleted` int NULL DEFAULT 0,
    360. 

  360.   PRIMARY KEY (`id`) USING BTREE
    361. 

  361. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;
    362. 

  362. 

  363. -- ----------------------------
    364. 

  364. -- Records of test_table
    365. 

  365. -- ----------------------------
    366. 

  366. 

  367. SET FOREIGN_KEY_CHECKS = 1;
    368.