MySQL Create Table SQL
Table Structure: okayapi_fie_auth_access：/tablelist/okayapi_fie_auth_access.html
-- MySQL Table okayapi_fie_auth_access
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_auth_access` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`role_id` int(10) NOT NULL COMMENT '角色',
`rule_name` varchar(100) NOT NULL COMMENT '规则唯一英文标识,全小写',
`okayapi_fie_auth_access_type` varchar(30) NOT NULL COMMENT '权限规则分类,请加应用前缀,如admin_',
KEY `role_id` (`role_id`),
KEY `rule_name` (`rule_name`),
KEY `okayapi_fie_auth_access_type` (`okayapi_fie_auth_access_type`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-权限授权表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-3 of 3 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| role_id | int(10) | 否 | 角色 | Normal Index | ||
| rule_name | varchar(100) | 否 | 规则唯一英文标识,全小写 | Normal Index | ||
| okayapi_fie_auth_access_type | varchar(30) | 否 | 权限规则分类,请加应用前缀,如admin_ |
