okayapi_migo_sys_role_menu

MySQL Create Table SQL

Table Structure: okayapi_migo_sys_role_menu：/tablelist/okayapi_migo_sys_role_menu.html


-- MySQL Table okayapi_migo_sys_role_menu
-- From: OkayAPI.com
CREATE TABLE `okayapi_migo_sys_role_menu` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `role_id` bigint(20) NULL COMMENT '角色ID',
    `menu_id` bigint(20) NULL COMMENT '菜单ID',
    KEY `role_id` (`role_id`),
    KEY `menu_id` (`menu_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'migo权限管理-角色与菜单对应关系';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-2 of 2 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
role_id	bigint(20)		是	角色ID
menu_id	bigint(20)		是	菜单ID

Guess You Like

MySQL Table Design okayapi_migo_schedule_job

MySQL Table Design okayapi_migo_schedule_job_log

MySQL Create Table SQL

MySQL database table structure design

Guess You Like

MySQL Table Design okayapi_migo_schedule_job

MySQL Table Design okayapi_migo_schedule_job_log

MySQL Table Design okayapi_migo_sys_config

MySQL Table Design okayapi_migo_sys_log

MySQL Table Design okayapi_migo_sys_menu

MySQL Table Design okayapi_migo_sys_oss

MySQL Table Design okayapi_migo_sys_role

MySQL Table Design okayapi_migo_sys_user

MySQL Table Design okayapi_migo_sys_user_role

MySQL Table Design okayapi_migo_tb_token

MySQL Table Design okayapi_migo_tb_user

MySQL Table Design okayapi_rights_assign