okayapi_eduwind_ew_category - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_eduwind_ew_category：/tablelist/okayapi_eduwind_ew_category.html


-- MySQL Table okayapi_eduwind_ew_category
-- From: OkayAPI.com
CREATE TABLE `okayapi_eduwind_ew_category` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_eduwind_ew_category_name` char(64) NULL COMMENT '类型',
    `parentId` int(11) NULL DEFAULT '0' COMMENT '父级分类',
    `okayapi_eduwind_ew_category_type` char(64) NULL COMMENT '类型,book,course等',
    `weight` int(11) NULL DEFAULT '0' COMMENT '排序',
    `userId` int(11) NULL DEFAULT '0' COMMENT '创建者',
    `description` text NULL COMMENT '',
    `addTime` varchar(45) NULL COMMENT '',
    KEY `okayapi_eduwind_ew_category_name` (`okayapi_eduwind_ew_category_name`),
    KEY `parentId` (`parentId`),
    KEY `okayapi_eduwind_ew_category_type` (`okayapi_eduwind_ew_category_type`),
    KEY `weight` (`weight`),
    KEY `userId` (`userId`),
    KEY `description` (`description`),
    KEY `addTime` (`addTime`),
    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-7 of 7 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
okayapi_eduwind_ew_category_name	char(64)		否	类型
parentId	int(11)	0	否	父级分类	0
okayapi_eduwind_ew_category_type	char(64)		否	类型,book,course等
weight	int(11)	0	否	排序	0
userId	int(11)	0	否	创建者	0
description	text		是
addTime	varchar(45)		是