.. role:: strike :class: strike :strike:`role_priv 角色权限表` =============================== ## 字段 ------------------- +----------+--------------+----------+--------+----------------------------+ | 列名 | 类型 | 是否非空 | 默认值 | 备注 | +----------+--------------+----------+--------+----------------------------+ | id | int | not null | null | 自增id | +----------+--------------+----------+--------+----------------------------+ | role_id | int | not null | null | 角色id | +----------+--------------+----------+--------+----------------------------+ | priv_num | varchar(300) | null | null | 权限id数组字符串,按序分割 | +----------+--------------+----------+--------+----------------------------+ ## 索引 --------------- +------+----------+------+ | 字段 | 唯一索引 | 备注 | +------+----------+------+ | 无 | | | +------+----------+------+ ## 说明 ## 建表语句 .. code:: create table role_priv( id int primary key auto_increment comment '唯一键', role_id int not null comment '角色id', priv_num varchar(300) not null comment '权限' );