样本库成员表:dl_samplelib_member ==================================== **样本库成员表** **字段** +--------------+---------+------+--------+----------+--------+---------------+ | 列名 | 类型 | 长度 | 小数点 | 是否非空 | 默认值 | 备注 | +==============+=========+======+========+==========+========+===============+ | id | bigint | 20 | 0 | not null | | 主键,自增 ID | +--------------+---------+------+--------+----------+--------+---------------+ | user_id | varchar | 255 | 0 | not null | | 用户ID | +--------------+---------+------+--------+----------+--------+---------------+ | role_id | bigint | 20 | 0 | not null | | 角色ID | +--------------+---------+------+--------+----------+--------+---------------+ | samplelib_id | bigint | 20 | 0 | not null | | 样本库 ID | +--------------+---------+------+--------+----------+--------+---------------+ | 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 | | +------+----------+------+ **建表语句** :: CREATE TABLE `dl_samplelib_member` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` varchar(255) NOT NULL, `role_id` bigint(20) NOT NULL, `samplelib_id` bigint(20) NOT NULL, `description` varchar(255) 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=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;