okayapi_mall_ums_role_permission_relation

MySQL Create Table SQL

Table Structure: okayapi_mall_ums_role_permission_relation：/tablelist/okayapi_mall_ums_role_permission_relation.html


-- MySQL Table okayapi_mall_ums_role_permission_relation
-- From: OkayAPI.com
CREATE TABLE `okayapi_mall_ums_role_permission_relation` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `role_id` bigint(20) NULL COMMENT '',
    `permission_id` bigint(20) NULL COMMENT '',
    KEY `role_id` (`role_id`),
    KEY `permission_id` (`permission_id`),
    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-2 of 2 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
role_id	bigint(20)		是
permission_id	bigint(20)		是

MySQL Create Table SQL

MySQL database table structure design

Guess You Like

MySQL Table Design okayapi_mall_ums_member_receive_address

MySQL Table Design okayapi_mall_ums_member_rule_setting

MySQL Table Design okayapi_mall_ums_member_statistics_info

MySQL Table Design okayapi_cloud_image_sync

MySQL Table Design okayapi_hc_act_re_model

MySQL Table Design okayapi_hc_group_buy