okayapi_mcms_role_model

MySQL Create Table SQL

Table Structure: okayapi_mcms_role_model：/tablelist/okayapi_mcms_role_model.html


-- MySQL Table okayapi_mcms_role_model
-- From: OkayAPI.com
CREATE TABLE `okayapi_mcms_role_model` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `model_id` int(22) NULL COMMENT '模块编号',
    `role_id` int(22) NULL COMMENT '角色编号',
    KEY `model_id` (`model_id`),
    KEY `role_id` (`role_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'MCSM-角色模块关联表';

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
model_id	int(22)		是	模块编号	Normal Index
role_id	int(22)		是	角色编号	Normal Index

Guess You Like

MySQL Table Design okayapi_mcms_app

MySQL Table Design okayapi_mcms_cms_category

MySQL Create Table SQL

MySQL database table structure design

Guess You Like

MySQL Table Design okayapi_mcms_app

MySQL Table Design okayapi_mcms_cms_category

MySQL Table Design okayapi_mcms_cms_content

MySQL Table Design okayapi_mcms_cms_history_log

MySQL Table Design okayapi_mcms_logger

MySQL Table Design okayapi_mcms_manager

MySQL Table Design okayapi_mcms_mdiy_dict

MySQL Table Design okayapi_mcms_mdiy_model

MySQL Table Design okayapi_mcms_mdiy_page

MySQL Table Design okayapi_mcms_mdiy_tag

MySQL Table Design okayapi_mcms_mdiy_tag_sql

MySQL Table Design okayapi_mcms_model

MySQL Table Design okayapi_mcms_role