Página Principal Explorar Ajuda
Registe-se Iniciar Sessão
CRBC-MaaS-Platform-Project
/
LQAdminPlatform
3
0
Fork 0
Ficheiros Problemas 0 Pull Requests 0 Wiki
Árvore: 1ae1fd79e9
Ramos Etiquetas
LQAdminPlatform
/
scripts
/
annotation_platform_20260131.sql

annotation_platform_20260131.sql 26 KB
Histórico Em bruto

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 192.168.92.61-lq-db
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80035
    7. 

  7.  Source Host           : 192.168.92.61:13306
    8. 

  8.  Source Schema         : annotation_platform
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80035
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 31/01/2026 17:50:56
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

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

  21. -- Table structure for annotations
    22. 

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

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

  24. CREATE TABLE `annotations`  (
    25. 

  25.   `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    26. 

  26.   `task_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    27. 

  27.   `user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    28. 

  28.   `result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    29. 

  29.   `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    30. 

  30.   `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
    31. 

  31.   PRIMARY KEY (`id`) USING BTREE,
    32. 

  32.   INDEX `idx_annotations_task`(`task_id`) USING BTREE,
    33. 

  33.   INDEX `idx_annotations_user`(`user_id`) USING BTREE,
    34. 

  34.   CONSTRAINT `annotations_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
    35. 

  35. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
    36. 

  36. 

  37. -- ----------------------------
    38. 

  38. -- Records of annotations
    39. 

  39. -- ----------------------------
    40. 

  40. INSERT INTO `annotations` VALUES ('ann_03b2a396aa76', 'task_11e92924c29d', 'current_user', '{\"result\": [{\"value\": {\"start\": 4, \"end\": 11, \"text\": \"\\u534e\\u5927\\u5b66\\u7684\\u6559\\u6388\\uff0c\", \"labels\": [\"\\u4eba\\u540d\"]}, \"id\": \"gjPTjODjER\", \"from_name\": \"label\", \"to_name\": \"text\", \"type\": \"labels\", \"origin\": \"manual\"}]}', '2026-01-21 07:28:23', '2026-01-21 07:28:23');
    41. 

  41. INSERT INTO `annotations` VALUES ('ann_093eb88120b0', 'task_49835ad11f75', 'current_user', '{\"result\": [{\"value\": {\"start\": 25, \"end\": 41, \"text\": \"\\u6570\\u636e\\u4e2d\\u5b66\\u4e60\\u5e76\\u505a\\u51fa\\u51b3\\u7b56\\u3002\\u6df1\\u5ea6\\u5b66\\u4e60\\u662f\", \"labels\": [\"\\u95ee\\u9898\"]}, \"id\": \"dmnhTWzRnm\", \"from_name\": \"label\", \"to_name\": \"text\", \"type\": \"labels\", \"origin\": \"manual\"}]}', '2026-01-15 09:12:52', '2026-01-15 09:12:52');
    42. 

  42. INSERT INTO `annotations` VALUES ('ann_0fd0cf4ceab3', 'task_1af9289d86f7', 'current_user', '{\"result\": [{\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"x\": 54, \"y\": 68.29268292682927, \"width\": 4.875, \"height\": 5.44090056285178, \"rotation\": 0, \"rectanglelabels\": [\"\\u8f66\"]}, \"id\": \"jkqFmKZlcs\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}, {\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"x\": 46.5, \"y\": 68.66791744840526, \"width\": 5.75, \"height\": 5.44090056285178, \"rotation\": 0, \"rectanglelabels\": [\"\\u8f66\"]}, \"id\": \"gckHOs0xkY\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}]}', '2026-01-21 10:02:15', '2026-01-21 10:02:15');
    43. 

  43. INSERT INTO `annotations` VALUES ('ann_156bbe8132c3', 'task_4bf9614120e0', 'user_45ff87b34123', '{\"confidence\": 0.95, \"label\": \"positive\"}', '2026-01-22 07:44:20', '2026-01-22 07:44:20');
    44. 

  44. INSERT INTO `annotations` VALUES ('ann_1cbfaa48f7e4', 'task_156b3b77ffb7', 'current_user', '{\"result\": [{\"value\": {\"choices\": [\"\\u6a21\\u7cca\", \"\\u566a\\u70b9\\u591a\"]}, \"id\": \"VAok790xjK\", \"from_name\": \"issues\", \"to_name\": \"image\", \"type\": \"choices\", \"origin\": \"manual\"}, {\"value\": {\"choices\": [\"\\u826f\\u597d\"]}, \"id\": \"XS979Tq4Qb\", \"from_name\": \"quality\", \"to_name\": \"image\", \"type\": \"choices\", \"origin\": \"manual\"}]}', '2026-01-21 08:43:50', '2026-01-21 09:57:34');
    45. 

  45. INSERT INTO `annotations` VALUES ('ann_25f5dcee7fbf', 'task_9dfba8d63541', 'current_user', '{\"result\": [{\"value\": {\"choices\": [\"\\u52a8\\u7269\"]}, \"id\": \"tVimhVA4ON\", \"from_name\": \"category\", \"to_name\": \"image\", \"type\": \"choices\", \"origin\": \"manual\"}]}', '2026-01-20 02:57:02', '2026-01-20 02:57:02');
    46. 

  46. INSERT INTO `annotations` VALUES ('ann_3b7d45bcf93f', 'task_80385274acb5', 'current_user', '{\"result\": [{\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"points\": [[17.07126076742365, 13.396004700352526], [19.42051683633516, 25.381903642773207], [20.751761942051683, 34.665099882491184], [21.456538762725135, 48.766157461809634], [21.1433046202036, 58.049353701527615], [22.16131558339859, 72.38542890716803], [24.119028974158184, 77.2032902467685], [21.378230227094754, 81.786133960047], [23.02270947533281, 88.01410105757932], [29.130775254502737, 89.42420681551117], [34.37744714173845, 86.3689776733255], [49.96084573218481, 90.0117508813161], [54.581049334377454, 89.77673325499413], [62.88175411119812, 88.01410105757932], [68.59827721221613, 86.83901292596946], [74.78465152701645, 86.3689776733255], [77.76037588097103, 86.01645123384255], [83.24197337509788, 83.31374853113984], [84.96476115896633, 79.31844888366626], [81.83241973375098, 64.27732079905994], [78.54346123727485, 58.75440658049354], [71.80892717306186, 51.233842538190366], [66.327329678935, 48.64864864864865], [57.321848081440876, 39.9529964747356], [54.97259201252936, 39.60047003525264], [52.07517619420516, 36.54524089306698], [49.569303054032886, 26.08695652173913], [51.21378230227095, 17.038777908343125], [49.96084573218481, 6.462984723854288], [49.80422866092404, 1.8801410105757932], [44.16601409553642, 1.762632197414806], [40.72043852779953, 11.045828437132785], [38.37118245888802, 14.336075205640423], [32.96789350039154, 14.101057579318448], [29.052466718872356, 12.338425381903642], [24.667188723570867, 10.105757931844888], [19.57713390759593, 6.698002350176263], [15.505090054815977, 9.283196239717979]], \"closed\": true, \"polygonlabels\": [\"\\u80cc\\u666f\"]}, \"id\": \"V6m3fq0CDF\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"polygonlabels\", \"origin\": \"manual\"}]}', '2026-01-20 07:23:00', '2026-01-21 07:52:07');
    47. 

  47. INSERT INTO `annotations` VALUES ('ann_a072ebdfcfa9', 'task_4df2784ccbe2', 'current_user', '{\"result\": [{\"value\": {\"choices\": [\"\\u6a21\\u7cca\", \"\\u66dd\\u5149\\u8fc7\\u5ea6\"]}, \"id\": \"s9Ic31qJyu\", \"from_name\": \"issues\", \"to_name\": \"image\", \"type\": \"choices\", \"origin\": \"manual\"}, {\"value\": {\"choices\": [\"\\u826f\\u597d\"]}, \"id\": \"INTNWZE1fw\", \"from_name\": \"quality\", \"to_name\": \"image\", \"type\": \"choices\", \"origin\": \"manual\"}]}', '2026-01-21 08:43:47', '2026-01-21 09:57:32');
    48. 

  48. INSERT INTO `annotations` VALUES ('ann_c935c2aba079', 'task_e095e9480142', 'current_user', '{\"result\": [{\"original_width\": 800, \"original_height\": 492, \"image_rotation\": 0, \"value\": {\"x\": 22.74549098196393, \"y\": 56.84039087947883, \"width\": 8.517034068136269, \"height\": 16.938110749185668, \"rotation\": 0, \"rectanglelabels\": [\"\\u81ea\\u884c\\u8f66\"]}, \"id\": \"n4AkBzRY0A\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}, {\"original_width\": 800, \"original_height\": 492, \"image_rotation\": 0, \"value\": {\"x\": 44.625, \"y\": 39.22764227642276, \"width\": 21.625, \"height\": 30.487804878048784, \"rotation\": 0, \"rectanglelabels\": [\"\\u72d7\"]}, \"id\": \"SEhj2Ov6Kr\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}]}', '2026-01-21 08:44:12', '2026-01-21 10:00:47');
    49. 

  49. INSERT INTO `annotations` VALUES ('ann_ddcdd6ca3c36', 'task_918c8f5b76a7', 'current_user', '{\"result\": [{\"value\": {\"start\": 10, \"end\": 17, \"text\": \"\\uff0c\\u5f20\\u4e09\\u5728\\u5317\\u4eac\\u5927\", \"labels\": [\"\\u5730\\u540d\"]}, \"id\": \"IMh75W8bLY\", \"from_name\": \"label\", \"to_name\": \"text\", \"type\": \"labels\", \"origin\": \"manual\"}]}', '2026-01-21 10:02:31', '2026-01-21 10:02:31');
    50. 

  50. INSERT INTO `annotations` VALUES ('ann_fa2cfdbdf061', 'task_49835ad11f75', 'current_user', '{\"result\": [{\"value\": {\"start\": 18, \"end\": 30, \"text\": \"\\u4f7f\\u8ba1\\u7b97\\u673a\\u80fd\\u591f\\u4ece\\u6570\\u636e\\u4e2d\\u5b66\\u4e60\", \"labels\": [\"\\u5173\\u952e\\u8bcd\"]}, \"id\": \"4nt_bOQqyL\", \"from_name\": \"label\", \"to_name\": \"text\", \"type\": \"labels\", \"origin\": \"manual\"}]}', '2026-01-15 09:12:41', '2026-01-15 09:12:41');
    51. 

  51. INSERT INTO `annotations` VALUES ('ann_fc486c891408', 'task_651a1eb8eba9', 'current_user', '{\"result\": [{\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"x\": 28.625, \"y\": 31.70731707317073, \"width\": 16.375, \"height\": 18.38649155722327, \"rotation\": 0, \"rectanglelabels\": [\"\\u4eba\"]}, \"id\": \"COfSUsIOtR\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}, {\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"x\": 52.75, \"y\": 31.70731707317073, \"width\": 16.75, \"height\": 31.33208255159475, \"rotation\": 0, \"rectanglelabels\": [\"\\u8f66\"]}, \"id\": \"3KDhCLs_SW\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}, {\"original_width\": 800, \"original_height\": 533, \"image_rotation\": 0, \"value\": {\"x\": 23.75, \"y\": 61.16322701688556, \"width\": 24.75, \"height\": 24.577861163227013, \"rotation\": 0, \"rectanglelabels\": [\"\\u81ea\\u884c\\u8f66\"]}, \"id\": \"xUO3CSDxWF\", \"from_name\": \"label\", \"to_name\": \"image\", \"type\": \"rectanglelabels\", \"origin\": \"manual\"}]}', '2026-01-21 08:44:22', '2026-01-21 10:00:27');
    52. 

  52. 

  53. -- ----------------------------
    54. 

  54. -- Table structure for projects
    55. 

  55. -- ----------------------------
    56. 

  56. DROP TABLE IF EXISTS `projects`;
    57. 

  57. CREATE TABLE `projects`  (
    58. 

  58.   `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    59. 

  59.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    60. 

  60.   `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    61. 

  61.   `config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    62. 

  62.   `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    63. 

  63.   PRIMARY KEY (`id`) USING BTREE
    64. 

  64. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
    65. 

  65. 

  66. -- ----------------------------
    67. 

  67. -- Records of projects
    68. 

  68. -- ----------------------------
    69. 

  69. INSERT INTO `projects` VALUES ('proj_184d40f741d3', '关键点标注 - 人体姿态估计', '标注人体关键点（头部、肩膀、肘部、手腕、膝盖、脚踝）', '<View>\n  <Header value=\"关键点标注 - 人体姿态\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <KeyPointLabels name=\"keypoint\" toName=\"image\">\n    <Label value=\"头部\" background=\"red\"/>\n    <Label value=\"肩膀\" background=\"blue\"/>\n    <Label value=\"肘部\" background=\"green\"/>\n    <Label value=\"手腕\" background=\"orange\"/>\n    <Label value=\"膝盖\" background=\"purple\"/>\n    <Label value=\"脚踝\" background=\"pink\"/>\n  </KeyPointLabels>\n</View>', '2026-01-20 01:57:53');
    70. 

  70. INSERT INTO `projects` VALUES ('proj_1d139f153fc2', 'Project 2', 'Description 2', '<View></View>', '2026-01-12 09:42:01');
    71. 

  71. INSERT INTO `projects` VALUES ('proj_2cde4d9f0473', 'Test Project', 'A test project', '{\"type\":\"image\"}', '2026-01-22 07:43:24');
    72. 

  72. INSERT INTO `projects` VALUES ('proj_3371717af8b0', 'Test Project', 'A test project', '{\"type\":\"image\"}', '2026-01-22 07:44:20');
    73. 

  73. INSERT INTO `projects` VALUES ('proj_54497c8fd0fe', 'Project 0', 'Description 0', '<View></View>', '2026-01-12 09:42:01');
    74. 

  74. INSERT INTO `projects` VALUES ('proj_6ae8808c8aca', 'Test Project', 'Test Description', '<View></View>', '2026-01-12 09:42:01');
    75. 

  75. INSERT INTO `projects` VALUES ('proj_72b10c8c9760', '1', '123', '123123', '2026-01-13 01:46:12');
    76. 

  76. INSERT INTO `projects` VALUES ('proj_74abc15e846f', 'Updated Manual Test Project', 'Testing the API manually', '<View><Text name=\'text\' value=\'$text\'/></View>', '2026-01-12 09:43:42');
    77. 

  77. INSERT INTO `projects` VALUES ('proj_7bfaa470da67', '目标检测 - 街道场景', '标注街道场景中的人、车、自行车等物体', '<View>\n  <Header value=\"目标检测 - 物体识别\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <RectangleLabels name=\"label\" toName=\"image\">\n    <Label value=\"人\" background=\"red\"/>\n    <Label value=\"车\" background=\"blue\"/>\n    <Label value=\"自行车\" background=\"green\"/>\n    <Label value=\"狗\" background=\"orange\"/>\n    <Label value=\"猫\" background=\"purple\"/>\n  </RectangleLabels>\n</View>', '2026-01-20 01:57:30');
    78. 

  78. INSERT INTO `projects` VALUES ('proj_88c6a5634055', 'Updated Name', 'Updated Description', '<View></View>', '2026-01-12 09:42:01');
    79. 

  79. INSERT INTO `projects` VALUES ('proj_8a9a38046843', '多标签图像分类', '为图片添加多个属性标签（室内/室外、白天/夜晚等）', '<View>\n  <Header value=\"多标签图像分类\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <Choices name=\"attributes\" toName=\"image\" choice=\"multiple\" showInline=\"false\">\n    <Choice value=\"室内\"/>\n    <Choice value=\"室外\"/>\n    <Choice value=\"白天\"/>\n    <Choice value=\"夜晚\"/>\n    <Choice value=\"晴天\"/>\n    <Choice value=\"雨天\"/>\n    <Choice value=\"有人\"/>\n    <Choice value=\"无人\"/>\n  </Choices>\n</View>', '2026-01-20 01:57:59');
    80. 

  80. INSERT INTO `projects` VALUES ('proj_a27d01af8fc5', '文本高亮标注项目', '标记文本中的重要信息、关键词和问题', '<View>\n  <Header value=\"文本高亮标注\"/>\n  <Text name=\"text\" value=\"$text\"/>\n  <Labels name=\"label\" toName=\"text\">\n    <Label value=\"重要信息\" background=\"yellow\"/>\n    <Label value=\"关键词\" background=\"lightblue\"/>\n    <Label value=\"问题\" background=\"pink\"/>\n  </Labels>\n</View>', '2026-01-13 02:25:22');
    81. 

  81. INSERT INTO `projects` VALUES ('proj_bb449109487e', '情感分析标注项目', '对用户评论进行情感分类（正面/负面/中性）', '<View>\n  <Header value=\"文本分类标注\"/>\n  <Text name=\"text\" value=\"$text\"/>\n  <Choices name=\"sentiment\" toName=\"text\" choice=\"single\" showInline=\"true\">\n    <Choice value=\"正面\"/>\n    <Choice value=\"负面\"/>\n    <Choice value=\"中性\"/>\n  </Choices>\n</View>', '2026-01-13 02:25:08');
    82. 

  82. INSERT INTO `projects` VALUES ('proj_bdb7e77c0867', '图像分类', '将图片分类为风景、人物、动物、建筑、食物等类别', '<View>\n  <Header value=\"图像分类\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <Choices name=\"category\" toName=\"image\" choice=\"single\" showInline=\"true\">\n    <Choice value=\"风景\"/>\n    <Choice value=\"人物\"/>\n    <Choice value=\"动物\"/>\n    <Choice value=\"建筑\"/>\n    <Choice value=\"食物\"/>\n    <Choice value=\"其他\"/>\n  </Choices>\n</View>', '2026-01-20 01:57:38');
    83. 

  83. INSERT INTO `projects` VALUES ('proj_ccfcd6e8f988', '图像质量评估', '评估图片质量并标注存在的问题（模糊、曝光等）', '<View>\n  <Header value=\"图像质量评估\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <Choices name=\"quality\" toName=\"image\" choice=\"single\" showInline=\"true\">\n    <Choice value=\"优秀\"/>\n    <Choice value=\"良好\"/>\n    <Choice value=\"一般\"/>\n    <Choice value=\"较差\"/>\n  </Choices>\n  <Choices name=\"issues\" toName=\"image\" choice=\"multiple\" showInline=\"false\">\n    <Choice value=\"模糊\"/>\n    <Choice value=\"曝光过度\"/>\n    <Choice value=\"曝光不足\"/>\n    <Choice value=\"噪点多\"/>\n    <Choice value=\"色彩失真\"/>\n  </Choices>\n</View>', '2026-01-20 01:58:05');
    84. 

  84. INSERT INTO `projects` VALUES ('proj_dad6cafccde9', '图片测试', '123123', '<View>\n  <Header value=\"Select label and click the image to start\"/>\n  <Image name=\"image\" value=\"$image\" zoom=\"true\"/>\n  <PolygonLabels name=\"label\" toName=\"image\"\n                 strokeWidth=\"3\" pointSize=\"small\"\n                 opacity=\"0.9\">\n    <Label value=\"Airplane\" background=\"red\"/>\n    <Label value=\"Car\" background=\"blue\"/>\n  </PolygonLabels>\n</View>', '2026-01-20 01:35:48');
    85. 

  85. INSERT INTO `projects` VALUES ('proj_ed0c23756a04', 'Project 1', 'Description 1', '<View></View>', '2026-01-12 09:42:01');
    86. 

  86. INSERT INTO `projects` VALUES ('proj_f8a01451be86', '图像分割 - 物体轮廓', '使用多边形工具精细标注物体轮廓', '<View>\n  <Header value=\"图像分割 - 精细标注\"/>\n  <Image name=\"image\" value=\"$image\"/>\n  <PolygonLabels name=\"label\" toName=\"image\">\n    <Label value=\"前景\" background=\"rgba(255, 0, 0, 0.5)\"/>\n    <Label value=\"背景\" background=\"rgba(0, 0, 255, 0.5)\"/>\n    <Label value=\"物体\" background=\"rgba(0, 255, 0, 0.5)\"/>\n  </PolygonLabels>\n</View>', '2026-01-20 01:57:46');
    87. 

  87. INSERT INTO `projects` VALUES ('proj_f99b41b4b3f5', '命名实体识别项目', '识别文本中的人名、地名、机构名和时间等实体', '<View>\n  <Header value=\"命名实体识别\"/>\n  <Text name=\"text\" value=\"$text\"/>\n  <Labels name=\"label\" toName=\"text\">\n    <Label value=\"人名\" background=\"red\"/>\n    <Label value=\"地名\" background=\"blue\"/>\n    <Label value=\"机构名\" background=\"green\"/>\n    <Label value=\"时间\" background=\"orange\"/>\n  </Labels>\n</View>', '2026-01-13 02:25:16');
    88. 

  88. INSERT INTO `projects` VALUES ('proj_fc8b3cfd42e7', 'Test Project', 'Test Description', '<View><Image name=\'img\' value=\'$image\'/></View>', '2026-01-12 09:42:01');
    89. 

  89. 

  90. -- ----------------------------
    91. 

  91. -- Table structure for tasks
    92. 

  92. -- ----------------------------
    93. 

  93. DROP TABLE IF EXISTS `tasks`;
    94. 

  94. CREATE TABLE `tasks`  (
    95. 

  95.   `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    96. 

  96.   `project_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    97. 

  97.   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    98. 

  98.   `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    99. 

  99.   `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'pending',
    100. 

  100.   `assigned_to` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    101. 

  101.   `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    102. 

  102.   PRIMARY KEY (`id`) USING BTREE,
    103. 

  103.   INDEX `idx_tasks_project`(`project_id`) USING BTREE,
    104. 

  104.   INDEX `idx_tasks_status`(`status`) USING BTREE,
    105. 

  105.   CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
    106. 

  106. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
    107. 

  107. 

  108. -- ----------------------------
    109. 

  109. -- Records of tasks
    110. 

  110. -- ----------------------------
    111. 

  111. INSERT INTO `tasks` VALUES ('task_03423e2aa5da', 'proj_8a9a38046843', '场景分析-1', '{\"image\": \"https://images.unsplash.com/photo-1464822759023-fed622ff2c3b?w=800\"}', 'pending', NULL, '2026-01-20 01:58:01');
    112. 

  112. INSERT INTO `tasks` VALUES ('task_0763c5d98044', 'proj_bdb7e77c0867', '风景图片-1', '{\"image\": \"https://images.unsplash.com/photo-1506905925346-21bda4d32df4?w=800\"}', 'pending', NULL, '2026-01-20 01:57:40');
    113. 

  113. INSERT INTO `tasks` VALUES ('task_11e92924c29d', 'proj_f99b41b4b3f5', '命名实体识别任务-2', '{\"text\": \"\\u674e\\u660e\\u662f\\u6e05\\u534e\\u5927\\u5b66\\u7684\\u6559\\u6388\\uff0c\\u4ed6\\u5728\\u4e0a\\u6d77\\u4ea4\\u901a\\u5927\\u5b66\\u83b7\\u5f97\\u4e86\\u535a\\u58eb\\u5b66\\u4f4d\\u3002\"}', 'completed', NULL, '2026-01-13 02:25:20');
    114. 

  114. INSERT INTO `tasks` VALUES ('task_12f44bd12afb', 'proj_bdb7e77c0867', '建筑图片-1', '{\"image\": \"https://images.unsplash.com/photo-1480714378408-67cf0d13bc1b?w=800\"}', 'pending', NULL, '2026-01-20 01:57:42');
    115. 

  115. INSERT INTO `tasks` VALUES ('task_156b3b77ffb7', 'proj_ccfcd6e8f988', '质量评估-1', '{\"image\": \"https://images.unsplash.com/photo-1472214103451-9374bd1c798e?w=800\"}', 'completed', NULL, '2026-01-20 01:58:07');
    116. 

  116. INSERT INTO `tasks` VALUES ('task_1629da00e218', 'proj_f8a01451be86', '物体分割-2', '{\"image\": \"https://images.unsplash.com/photo-1514888286974-6c03e2ca1dba?w=800\"}', 'pending', NULL, '2026-01-20 01:57:51');
    117. 

  117. INSERT INTO `tasks` VALUES ('task_1af9289d86f7', 'proj_7bfaa470da67', '街道场景-1', '{\"image\": \"https://images.unsplash.com/photo-1449824913935-59a10b8d2000?w=800\"}', 'completed', NULL, '2026-01-20 01:57:32');
    118. 

  118. INSERT INTO `tasks` VALUES ('task_1b884bdd989c', 'proj_8a9a38046843', '场景分析-2', '{\"image\": \"https://images.unsplash.com/photo-1469474968028-56623f02e42e?w=800\"}', 'pending', NULL, '2026-01-20 01:58:03');
    119. 

  119. INSERT INTO `tasks` VALUES ('task_1e6af2e95494', 'proj_1d139f153fc2', '123', '{\"data\": \"\\u8bf7\\u95ee\"}', 'pending', '123', '2026-01-13 02:13:04');
    120. 

  120. INSERT INTO `tasks` VALUES ('task_29701a5b2324', 'proj_bb449109487e', '文本分类任务-2', '{\"text\": \"\\u4ea7\\u54c1\\u8d28\\u91cf\\u592a\\u5dee\\u4e86\\uff0c\\u7528\\u4e86\\u4e0d\\u5230\\u4e00\\u5468\\u5c31\\u574f\\u4e86\\uff0c\\u5ba2\\u670d\\u6001\\u5ea6\\u4e5f\\u5f88\\u6076\\u52a3\\uff0c\\u975e\\u5e38\\u5931\\u671b\\u3002\"}', 'pending', NULL, '2026-01-13 02:25:12');
    121. 

  121. INSERT INTO `tasks` VALUES ('task_49835ad11f75', 'proj_a27d01af8fc5', '文本高亮任务-1', '{\"text\": \"\\u673a\\u5668\\u5b66\\u4e60\\u662f\\u4eba\\u5de5\\u667a\\u80fd\\u7684\\u4e00\\u4e2a\\u91cd\\u8981\\u5206\\u652f\\uff0c\\u5b83\\u4f7f\\u8ba1\\u7b97\\u673a\\u80fd\\u591f\\u4ece\\u6570\\u636e\\u4e2d\\u5b66\\u4e60\\u5e76\\u505a\\u51fa\\u51b3\\u7b56\\u3002\\u6df1\\u5ea6\\u5b66\\u4e60\\u662f\\u673a\\u5668\\u5b66\\u4e60\\u7684\\u4e00\\u4e2a\\u5b50\\u9886\\u57df\\uff0c\\u4f7f\\u7528\\u795e\\u7ecf\\u7f51\\u7edc\\u6765\\u6a21\\u62df\\u4eba\\u8111\\u7684\\u5de5\\u4f5c\\u65b9\\u5f0f\\u3002\"}', 'in_progress', NULL, '2026-01-13 02:25:24');
    122. 

  122. INSERT INTO `tasks` VALUES ('task_4bf9614120e0', 'proj_3371717af8b0', 'Test Task', '{\"items\": [{\"id\": 1, \"text\": \"Sample text\"}]}', 'pending', 'user_45ff87b34123', '2026-01-22 07:44:20');
    123. 

  123. INSERT INTO `tasks` VALUES ('task_4df2784ccbe2', 'proj_ccfcd6e8f988', '质量评估-2', '{\"image\": \"https://images.unsplash.com/photo-1501594907352-04cda38ebc29?w=800\"}', 'completed', NULL, '2026-01-20 01:58:09');
    124. 

  124. INSERT INTO `tasks` VALUES ('task_56621217e18a', 'proj_bb449109487e', '文本分类任务-1', '{\"text\": \"\\u8fd9\\u5bb6\\u9910\\u5385\\u7684\\u670d\\u52a1\\u6001\\u5ea6\\u975e\\u5e38\\u597d\\uff0c\\u83dc\\u54c1\\u4e5f\\u5f88\\u7f8e\\u5473\\uff0c\\u73af\\u5883\\u4f18\\u96c5\\uff0c\\u5f3a\\u70c8\\u63a8\\u8350\\uff01\"}', 'pending', NULL, '2026-01-13 02:25:10');
    125. 

  125. INSERT INTO `tasks` VALUES ('task_5d5fc8a3f8f7', 'proj_184d40f741d3', '人体姿态-2', '{\"image\": \"https://images.unsplash.com/photo-1517836357463-d25dfeac3438?w=800\"}', 'pending', NULL, '2026-01-20 01:57:57');
    126. 

  126. INSERT INTO `tasks` VALUES ('task_651a1eb8eba9', 'proj_7bfaa470da67', '公园场景', '{\"image\": \"https://images.unsplash.com/photo-1441974231531-c6227db76b6e?w=800\"}', 'completed', NULL, '2026-01-20 01:57:36');
    127. 

  127. INSERT INTO `tasks` VALUES ('task_80385274acb5', 'proj_f8a01451be86', '物体分割-1', '{\"image\": \"https://images.unsplash.com/photo-1518791841217-8f162f1e1131?w=800\"}', 'completed', NULL, '2026-01-20 01:57:49');
    128. 

  128. INSERT INTO `tasks` VALUES ('task_918c8f5b76a7', 'proj_f99b41b4b3f5', '命名实体识别任务-1', '{\"text\": \"2024\\u5e741\\u670815\\u65e5\\uff0c\\u5f20\\u4e09\\u5728\\u5317\\u4eac\\u5927\\u5b66\\u53c2\\u52a0\\u4e86\\u4eba\\u5de5\\u667a\\u80fd\\u7814\\u8ba8\\u4f1a\\u3002\"}', 'completed', NULL, '2026-01-13 02:25:18');
    129. 

  129. INSERT INTO `tasks` VALUES ('task_94503e84b095', 'proj_bb449109487e', '文本分类任务-3', '{\"text\": \"\\u8fd9\\u6b3e\\u624b\\u673a\\u6027\\u80fd\\u4e00\\u822c\\uff0c\\u4ef7\\u683c\\u9002\\u4e2d\\uff0c\\u9002\\u5408\\u65e5\\u5e38\\u4f7f\\u7528\\u3002\"}', 'pending', NULL, '2026-01-13 02:25:14');
    130. 

  130. INSERT INTO `tasks` VALUES ('task_9dfba8d63541', 'proj_bdb7e77c0867', '动物图片-1', '{\"image\": \"https://images.unsplash.com/photo-1425082661705-1834bfd09dca?w=800\"}', 'in_progress', NULL, '2026-01-20 01:57:44');
    131. 

  131. INSERT INTO `tasks` VALUES ('task_e095e9480142', 'proj_7bfaa470da67', '街道场景-2', '{\"image\": \"https://images.unsplash.com/photo-1477959858617-67f85cf4f1df?w=800\"}', 'completed', NULL, '2026-01-20 01:57:34');
    132. 

  132. INSERT INTO `tasks` VALUES ('task_eee0f95c961b', 'proj_184d40f741d3', '人体姿态-1', '{\"image\": \"https://images.unsplash.com/photo-1571019614242-c5c5dee9f50b?w=800\"}', 'pending', NULL, '2026-01-20 01:57:55');
    133. 

  133. 

  134. -- ----------------------------
    135. 

  135. -- Table structure for users
    136. 

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

  137. DROP TABLE IF EXISTS `users`;
    138. 

  138. CREATE TABLE `users`  (
    139. 

  139.   `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    140. 

  140.   `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    141. 

  141.   `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    142. 

  142.   `password_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    143. 

  143.   `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'annotator',
    144. 

  144.   `oauth_provider` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    145. 

  145.   `oauth_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    146. 

  146.   `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    147. 

  147.   `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
    148. 

  148.   PRIMARY KEY (`id`) USING BTREE,
    149. 

  149.   UNIQUE INDEX `username`(`username`) USING BTREE,
    150. 

  150.   UNIQUE INDEX `email`(`email`) USING BTREE,
    151. 

  151.   INDEX `idx_users_username`(`username`) USING BTREE,
    152. 

  152.   INDEX `idx_users_email`(`email`) USING BTREE,
    153. 

  153.   INDEX `idx_users_oauth`(`oauth_provider`, `oauth_id`) USING BTREE
    154. 

  154. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
    155. 

  155. 

  156. -- ----------------------------
    157. 

  157. -- Records of users
    158. 

  158. -- ----------------------------
    159. 

  159. INSERT INTO `users` VALUES ('user_20260122180848_6a6d9cad', 'zhangsan', 'zhangsan@qq.com', '', 'annotator', 'sso', 'd3e906de-b9a6-4a78-a643-233252252776', '2026-01-22 18:08:49', '2026-01-22 10:08:48');
    160. 

  160. INSERT INTO `users` VALUES ('user_20260129151138_93b2226d', 'admin', 'admin@example.com', '', 'annotator', 'sso', 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '2026-01-29 15:11:38', '2026-01-29 15:11:37');
    161. 

  161. INSERT INTO `users` VALUES ('user_45ff87b34123', 'testuser2', 'test2@example.com', '$2b$12$1a9JM.mrG0s5CYvuq7d1ZOetmKN3bjCD1xGs9YaDJzJd17VpX0O9i', 'annotator', NULL, NULL, '2026-01-22 07:44:20', '2026-01-22 07:44:20');
    162. 

  162. INSERT INTO `users` VALUES ('user_91797832d370', 'testuser', 'test@example.com', '$2b$12$1tw51ab6rLi1mWzrC3NcQujFOswYZ5iLMq3BPZ4VoIy8.QYmCJui2', 'annotator', NULL, NULL, '2026-01-22 07:41:36', '2026-01-22 07:41:36');
    163. 

  163. 

  164. SET FOREIGN_KEY_CHECKS = 1;
    165.