标注信息表：dl_sample_label
==================================

**标注信息表**

**字段**

+------------------+---------+------+--------+----------+--------+-----------------------------+
|       列名       |  类型   | 长度 | 小数点 | 是否非空 | 默认值 |            备注             |
+==================+=========+======+========+==========+========+=============================+
| id               | bigint  | 20   | 0      | not null |        | 主键，自增 ID               |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| name             | varchar | 255  | 0      | not null |        | 标识名称                    |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| type             | tinyint | 11   | 0      | not null |        | 正负样本标识 （1=正，2=负） |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| samplelib_id     | bigint  | 20   | 0      | not null |        | 样本库 ID                   |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| sample_id        | bigint  | 20   | 0      | not null |        | 样本 ID                     |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| label_id         | bigint  | 20   | 0      | not null |        | 标签 ID                     |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| task_id          | bigint  | 20   | 0      |          |        | 任务 ID                     |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| frame_coordinate | text    | 0    | 0      |          |        | 图片方框坐标                |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| creator_id       | varchar | 255  | 0      | not null |        | 创建人 ID                   |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| create_time      | bigint  | 20   | 0      | not null |        | 创建时间                    |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| updator_id       | varchar | 255  | 0      | not null |        | 修改人 ID                   |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| update_time      | bigint  | 20   | 0      | not null |        | 修改时间                    |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| task_mark_id     | bigint  | 20   | 0      |          |        | 子任务ID                    |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| state            | int     | 11   | 0      | not null |        | 标注状态                    |
+------------------+---------+------+--------+----------+--------+-----------------------------+
| opinion          | varchar | 1000 | 0      |          |        | 审核意见                    |
+------------------+---------+------+--------+----------+--------+-----------------------------+

**索引**

+------+----------+------+
| 字段 | 索引类型 | 备注 |
+======+==========+======+
| id   | PRIMARY  |      |
+------+----------+------+

**建表语句**
::

  CREATE TABLE `dl_sample_label` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL COMMENT '标识名称',
    `type` tinyint(3) DEFAULT NULL COMMENT '正负样本标识',
    `samplelib_id` bigint(20) NOT NULL COMMENT '样本库id',
    `sample_id` bigint(20) NOT NULL COMMENT '样本id',
    `label_id` bigint(20) NOT NULL COMMENT '标签id',
    `task_id` bigint(20) DEFAULT NULL COMMENT '任务id',
    `frame_coordinate` text DEFAULT NULL COMMENT '图片方框坐标',
    `creator_id` varchar(255) NOT NULL,
    `create_time` bigint(20) NOT NULL,
    `updator_id` varchar(255) NOT NULL,
    `update_time` bigint(20) NOT NULL,
    `task_mark_id` bigint(20) DEFAULT NULL COMMENT '标注任务id',
    `state` int(11) NOT NULL DEFAULT 0 COMMENT '审核状态',
    `opinion` varchar(1000) DEFAULT NULL COMMENT '审核意见',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;