.. role:: strike :class: strike :strike:`privilege 权限表` ================================================== ## 字段 ----------------------- +-----------+-------------+----------+--------+----------+ | 列名 | 类型 | 是否非空 | 默认值 | 备注 | +-----------+-------------+----------+--------+----------+ | id | int | not null | null | 自增ID | +-----------+-------------+----------+--------+----------+ | priv_code | varchar(4) | not null | null | 权限编号 | +-----------+-------------+----------+--------+----------+ | priv_name | varchar(20) | not null | null | 权限名称 | +-----------+-------------+----------+--------+----------+ ## 索引 +------+----------+------+ | 字段 | 唯一索引 | 备注 | +------+----------+------+ | 无 | | | +------+----------+------+ ## 说明 ## 建表语句 .. code:: create table privilege( id int primary key auto_increment comment '唯一键', priv_code varchar(4) not null comment '权限标号', priv_name varchar(20) not null comment '权限名称' );