成员角色表:dl_role =========================== **成员角色表** **字段** +-------------+---------+------+--------+----------+--------+---------------+ | 列名 | 类型 | 长度 | 小数点 | 是否非空 | 默认值 | 备注 | +=============+=========+======+========+==========+========+===============+ | id | bigint | 20 | 0 | not null | | 主键,自增 ID | +-------------+---------+------+--------+----------+--------+---------------+ | name | varchar | 255 | 0 | not null | | 标签名称 | +-------------+---------+------+--------+----------+--------+---------------+ | description | varchar | 255 | 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_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) 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`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;