okayapi_zheng_upms_user_permission - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_zheng_upms_user_permission：/tablelist/okayapi_zheng_upms_user_permission.html


-- MySQL Table okayapi_zheng_upms_user_permission
-- From: OkayAPI.com
CREATE TABLE `okayapi_zheng_upms_user_permission` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` int(10) NOT NULL COMMENT '用户编号',
    `permission_id` int(10) NOT NULL COMMENT '权限编号',
    `okayapi_zheng_upms_user_permission_type` tinyint(4) NOT NULL COMMENT '权限类型(-1:减权限,1:增权限)',
    KEY `user_id` (`user_id`),
    KEY `permission_id` (`permission_id`),
    KEY `okayapi_zheng_upms_user_permission_type` (`okayapi_zheng_upms_user_permission_type`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'zheng敏捷开发-用户权限关联表';

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	IS NULL	Field Comment
user_id	int(10)	否	用户编号
permission_id	int(10)	否	权限编号
okayapi_zheng_upms_user_permission_type	tinyint(4)	否	权限类型(-1:减权限,1:增权限)