用户角色权限表结构设计

 CREATE TABLE `user`  (

    
   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    
   `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '姓名',
    
   `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
    
   `password` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
    
   `sjh` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
    
   `delete_flag` int(1) NOT NULL DEFAULT 0 COMMENT '删除标记 0未删除 1删除',
    
   `create_time` datetime(0) NOT N