任务信息表：dl_task
============================

**任务信息表**

**字段**

+-------------------+---------+------+--------+----------+--------+---------------+
|       列名        |  类型   | 长度 | 小数点 | 是否非空 | 默认值 |     备注      |
+===================+=========+======+========+==========+========+===============+
| id                | bigint  | 20   | 0      | not null |        | 主键，自增 ID |
+-------------------+---------+------+--------+----------+--------+---------------+
| pre_id            | bigint  | 20   | 0      | not null |        | 前任务ID      |
+-------------------+---------+------+--------+----------+--------+---------------+
| sample_library_id | bigint  | 20   | 0      | not null |        | 样本库 ID     |
+-------------------+---------+------+--------+----------+--------+---------------+
| owner_id          | varchar | 255  | 0      | not null |        | 所有人ID      |
+-------------------+---------+------+--------+----------+--------+---------------+
| name              | varchar | 255  | 0      | not null |        | 任务名称      |
+-------------------+---------+------+--------+----------+--------+---------------+
| type              | int     | 11   | 0      | not null |        | 任务类型      |
+-------------------+---------+------+--------+----------+--------+---------------+
| state             | int     | 11   | 0      | not null |        | 任务状态      |
+-------------------+---------+------+--------+----------+--------+---------------+
| 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 |        | 修改时间      |
+-------------------+---------+------+--------+----------+--------+---------------+


**索引**

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

**建表语句**
::

  CREATE TABLE `dl_task` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `pre_id` bigint(20) NOT NULL COMMENT '前任务id',
    `samplelib_id` bigint(20) NOT NULL,
    `owner_id` varchar(255) NOT NULL,
    `name` varchar(255) NOT NULL,
    `type` int(11) NOT NULL,
    `state` int(11) NOT NULL,
    `creator_id` varchar(255) NOT NULL,
    `create_time` bigint(20) NOT NULL,
    `updator_id` varchar(255) NOT NULL,
    `update_time` bigint(20) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;