mysql中角色权限表的设计_用户角色权限管理数据库表如何设计最为合理?

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for rs_menu

-- ----------------------------

DROP TABLE IF EXISTS `rs_menu`;

CREATE TABLE `rs_menu` (

`MENU_ID` varchar(32) NOT NULL,

`PARENT_ID` varchar(32) DEFAULT NULL,

`MENU_NAME` varchar(255) DEFAULT NULL,

`ORDER_ID` int(11) DEFAULT NULL,

`MENU_ICON` varchar(255) DEFAULT NULL,

PRIMARY KEY (`MENU_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for rs_menu_op

-- ----------------------------

DROP TABLE IF EXISTS `rs_menu_op`;

CREATE TABLE `rs_menu_op` (

`OP_ID` varchar(32) NOT NULL,

`MENU_ID` varchar(32) NOT NULL,

`URL` varchar(1024) NOT NULL,

`MENU_TYPE` varchar(32) NOT NULL,

PRIMARY KEY (`OP_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for rs_organ

-- ----------------------------

DROP TABLE IF EXISTS `rs_organ`;

CREATE TABLE `rs_organ` (

`ORGAN_ID` varchar(32) NOT NULL,

`ORGAN_CODE` varchar(255) DEFAULT NULL,

`ORGAN_NAME` varchar(255) DEFAULT NULL,

`ORGAN_TYPE` varchar(255) DEFAULT NULL,

`PARENT_ID` varchar(32) DEFAULT NULL,

`ORDER_ID` varchar(255) NOT NULL DEFAULT '0',

PRIMARY KEY (`ORGAN_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for rs_roles

-- ----------------------------

DROP TABLE IF EXISTS `rs_roles`;

CREATE TABLE `rs_roles` (

`ROLE_ID` varchar(32) NOT NULL,

`ROLE_NAME` varchar(50) NOT NULL,

`DESCRIPTION` varchar(255) DEFAULT NULL,

`CTIME` varchar(50) DEFAULT NULL,

`UPDATA` varchar(50) DEFAULT NULL,

PRIMARY KEY (`ROLE_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for rs_role_menu

-- ----------------------------

DROP TABLE IF EXISTS `rs_role_menu`;

CREATE TABLE `rs_role_menu` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`ROLE_ID` varchar(32) NOT NULL,

`MENU_ID` varchar(32) NOT NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for rs_users

-- ----------------------------

DROP TABLE IF EXISTS `rs_users`;

CREATE TABLE `rs_users` (

`USER_ID` varchar(32) NOT NULL,

`USER_NAME` varchar(1024) DEFAULT NULL,

`USER_PASSWORD` varchar(32) DEFAULT NULL,

`USER_STATUS` varchar(32) DEFAULT NULL,

`CREATE_TIME` varchar(32) DEFAULT NULL,

`LOCK_TIME` varchar(32) DEFAULT NULL,

`EXPIRED_TIME` varchar(32) DEFAULT NULL,

`PWD_UP_TIME` varchar(32) DEFAULT NULL,

`PWD_TIME` varchar(32) DEFAULT NULL,

PRIMARY KEY (`USER_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for rs_users_organ

-- ----------------------------

DROP TABLE IF EXISTS `rs_users_organ`;

CREATE TABLE `rs_users_organ` (

`USER_ID` varchar(32) NOT NULL,

`ORGAN_ID` varchar(32) DEFAULT NULL,

PRIMARY KEY (`USER_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------

-- Table structure for rs_users_role

-- ----------------------------

DROP TABLE IF EXISTS `rs_users_role`;

CREATE TABLE `rs_users_role` (

`RULE_ID` varchar(32) NOT NULL,

`USER_ID` varchar(32) NOT NULL,

`ROLE_ID` varchar(32) DEFAULT NULL,

PRIMARY KEY (`RULE_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;