任务分配表:dl_task_mark ============================ **任务分配表** **字段** +----------------+--------+------+--------+----------+--------+---------------+ | 列名 | 类型 | 长度 | 小数点 | 是否非空 | 默认值 | 备注 | +================+========+======+========+==========+========+===============+ | id | bigint | 20 | 0 | not null | | 主键,自增 ID | +----------------+--------+------+--------+----------+--------+---------------+ | pre_id | bigint | 20 | 0 | not null | | 前任务ID | +----------------+--------+------+--------+----------+--------+---------------+ | type | int | 11 | 0 | not null | | 任务类型 | +----------------+--------+------+--------+----------+--------+---------------+ | label_set_type | int | 11 | 0 | not null | | 样本集类型 | +----------------+--------+------+--------+----------+--------+---------------+ | task_id | bigint | 20 | 0 | not null | | 任务ID | +----------------+--------+------+--------+----------+--------+---------------+ | sample_id | bigint | 20 | 0 | not null | | 样本ID | +----------------+--------+------+--------+----------+--------+---------------+ | label_id | bigint | 20 | 0 | not null | | 标签ID | +----------------+--------+------+--------+----------+--------+---------------+ | state | int | 11 | 0 | not null | | 任务状态 | +----------------+--------+------+--------+----------+--------+---------------+ **索引** +------+----------+------+ | 字段 | 索引类型 | 备注 | +======+==========+======+ | id | PRIMARY | | +------+----------+------+ **建表语句** :: CREATE TABLE `dl_task_mark` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `pre_id` bigint(20) NOT NULL, `type` int(11) NOT NULL, `label_set_type` int(11) DEFAULT NULL, `task_id` bigint(20) NOT NULL, `sample_id` bigint(20) NOT NULL, `label_id` bigint(20) NOT NULL, `state` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=649 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;