样本库标签表:dl_samplelib_label ==================================== **样本库标签表** **字段** +---------------+---------+------+--------+----------+--------+---------------+ | 列名 | 类型 | 长度 | 小数点 | 是否非空 | 默认值 | 备注 | +===============+=========+======+========+==========+========+===============+ | id | bigint | 20 | 0 | not null | | 主键,自增 ID | +---------------+---------+------+--------+----------+--------+---------------+ | name | varchar | 255 | 0 | not null | | 标签名称 | +---------------+---------+------+--------+----------+--------+---------------+ | samplelib_id | bigint | 20 | 0 | not null | | 样本库 ID | +---------------+---------+------+--------+----------+--------+---------------+ | labelset_type | int | 11 | 0 | not null | | 标签集类型 | +---------------+---------+------+--------+----------+--------+---------------+ | labelset_id | bigint | 20 | 0 | not null | | 标签集 ID | +---------------+---------+------+--------+----------+--------+---------------+ | label_id | bigint | 20 | 0 | not null | | 标签 ID | +---------------+---------+------+--------+----------+--------+---------------+ **索引** +------+----------+------+ | 字段 | 索引类型 | 备注 | +======+==========+======+ | id | PRIMARY | | +------+----------+------+ **建表语句** :: CREATE TABLE `dl_samplelib_label` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL COMMENT '标签名称', `samplelib_id` bigint(20) NOT NULL, `labelset_type` int(11) NOT NULL, `labelset_id` bigint(20) NOT NULL, `label_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;