标签信息表：dl_label
====================================

**标签信息表**


**字段**

+--------------+---------+------+--------+----------+--------+---------------+
|     列名     |  类型   | 长度 | 小数点 | 是否非空 | 默认值 |     备注      |
+==============+=========+======+========+==========+========+===============+
| id           | bigint  | 20   | 0      | not null |        | 主键，自增 ID |
+--------------+---------+------+--------+----------+--------+---------------+
| label_set_id | bigint  | 20   | 0      | not null |        | 标签集 ID     |
+--------------+---------+------+--------+----------+--------+---------------+
| name         | varchar | 255  | 0      | not null |        | 标签名称      |
+--------------+---------+------+--------+----------+--------+---------------+
| color        | varchar | 255  | 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 |        | 修改时间      |
+--------------+---------+------+--------+----------+--------+---------------+


**索引**

+-----------------------------+----------+------+
|            字段             | 索引类型 | 备注 |
+=============================+==========+======+
| id                          | PRIMARY  |      |
+-----------------------------+----------+------+
| ( `label_set_id` , `name` ) | UNIQUE   |      |
+-----------------------------+----------+------+


**建表语句**        

::

  CREATE TABLE `dl_label` (
    `id` BIGINT ( 20 ) NOT NULL AUTO_INCREMENT,
    `label_set_id` BIGINT ( 20 ) NOT NULL,
    `name` VARCHAR ( 255 ) NOT NULL,
    `color` VARCHAR ( 255 ) DEFAULT 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` ),
  UNIQUE KEY `unique_labelsetid_name` ( `label_set_id`, `name` ) USING BTREE 
  ) ENGINE = INNODB AUTO_INCREMENT = 54 DEFAULT CHARSET = utf8;