MySQL Create Table SQL
Table Structure: okayapi_eduwind_AuthAssignment：/tablelist/okayapi_eduwind_AuthAssignment.html
-- MySQL Table okayapi_eduwind_AuthAssignment
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_AuthAssignment` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`itemname` varchar(64) NULL COMMENT '',
`userid` varchar(64) NULL COMMENT '',
`bizrule` text NULL COMMENT '',
`okayapi_eduwind_AuthAssignment_data` text NULL COMMENT '',
KEY `itemname` (`itemname`),
KEY `userid` (`userid`),
KEY `bizrule` (`bizrule`),
KEY `okayapi_eduwind_AuthAssignment_data` (`okayapi_eduwind_AuthAssignment_data`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'EW在线教育-权限分配';
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 | 是 | ||||
| okayapi_eduwind_AuthAssignment_data | text | 是 |
