MySQL Create Table SQL
Table Structure: okayapi_rights_assign：/tablelist/okayapi_rights_assign.html
-- MySQL Table okayapi_rights_assign
-- From: OkayAPI.com
CREATE TABLE `okayapi_rights_assign` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_role` varchar(20) NULL COMMENT '会员分组',
`assign_user` varchar(32) NULL COMMENT '授权的用户UUID',
`menu_key` varchar(255) NULL COMMENT '菜单项',
`menu_title` varchar(100) NULL COMMENT '菜单名称',
`menu_icon` varchar(255) NULL COMMENT '菜单图标',
`menu_sort` int(11) NULL DEFAULT '0' COMMENT '排序值，小在前',
KEY `user_role` (`user_role`),
KEY `assign_user` (`assign_user`),
KEY `menu_key` (`menu_key`),
KEY `menu_title` (`menu_title`),
KEY `menu_icon` (`menu_icon`),
KEY `menu_sort` (`menu_sort`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '用户权限分配';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| user_role | varchar(20) | 是 | 会员分组 | |||
| assign_user | varchar(32) | 是 | 授权的用户UUID | |||
| menu_key | varchar(255) | 否 | 菜单项 | |||
| menu_title | varchar(100) | 是 | 菜单名称 | |||
| menu_icon | varchar(255) | 是 | 菜单图标 | |||
| menu_sort | int(11) | 0 | 是 | 排序值，小在前 | 0 |
