标签集信息表:dl_label_set =============================== **标签集信息表** **字段** +-------------+---------+------+--------+----------+--------+---------------+ | 列名 | 类型 | 长度 | 小数点 | 是否非空 | 默认值 | 备注 | +=============+=========+======+========+==========+========+===============+ | id | bigint | 20 | 0 | not null | | 主键,自增 ID | +-------------+---------+------+--------+----------+--------+---------------+ | name | varchar | 255 | 0 | not null | | 标签集名称 | +-------------+---------+------+--------+----------+--------+---------------+ | type | int | 11 | 0 | not null | | 标签集类型 | +-------------+---------+------+--------+----------+--------+---------------+ | description | varchar | 1000 | 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 | | +------+----------+------+ | name | NORMAL | | +------+----------+------+ | type | NORMAL | | +------+----------+------+ **建表语句** :: CREATE TABLE `dl_label_set` ( `id` BIGINT ( 20 ) NOT NULL AUTO_INCREMENT, `name` VARCHAR ( 255 ) NOT NULL, `type` INT ( 255 ) NOT NULL, `description` VARCHAR ( 1000 ) 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` ), KEY `normal_name` ( `name` ) USING BTREE, KEY `normal_type` ( `type` ) USING BTREE ) ENGINE = INNODB AUTO_INCREMENT = 34 DEFAULT CHARSET = utf8;