okayapi_eduwind_AuthItem - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_AuthItem：/tablelist/okayapi_eduwind_AuthItem.html


-- MySQL Table okayapi_eduwind_AuthItem
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_AuthItem` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_eduwind_AuthItem_name` varchar(64) NULL COMMENT '',
    `okayapi_eduwind_AuthItem_type` int(11) NULL COMMENT '',
    `description` text NULL COMMENT '',
    `bizrule` text NULL COMMENT '',
    `okayapi_eduwind_AuthItem_data` text NULL COMMENT '',
    KEY `okayapi_eduwind_AuthItem_name` (`okayapi_eduwind_AuthItem_name`),
    KEY `okayapi_eduwind_AuthItem_type` (`okayapi_eduwind_AuthItem_type`),
    KEY `description` (`description`),
    KEY `bizrule` (`bizrule`),
    KEY `okayapi_eduwind_AuthItem_data` (`okayapi_eduwind_AuthItem_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-5 of 5 results.

Field Name	Field Type	IS NULL
okayapi_eduwind_AuthItem_name	varchar(64)	否
okayapi_eduwind_AuthItem_type	int(11)	否
description	text	是
bizrule	text	是
okayapi_eduwind_AuthItem_data	text	是