MySQL Create Table SQL
Table Structure: okayapi_sys_authassignment：/tablelist/okayapi_sys_authassignment.html
-- MySQL Table okayapi_sys_authassignment
-- From: OkayAPI.com
CREATE TABLE `okayapi_sys_authassignment` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`itemname` varchar(64) NULL COMMENT '权限管理表',
`userid` varchar(64) NULL COMMENT '',
`bizrule` text NULL COMMENT '',
`data` text NULL COMMENT '权限管理表',
KEY `itemname` (`itemname`),
KEY `userid` (`userid`),
KEY `bizrule` (`bizrule`),
KEY `data` (`data`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-权限_认证项赋权关系';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-4 of 4 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| itemname | varchar(64) | 否 | 权限管理表 | |||
| userid | varchar(64) | 否 | ||||
| bizrule | text | 是 | ||||
| data | text | 是 | 权限管理表 |
