okayapi_openant_information_category - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_information_category：/tablelist/okayapi_openant_information_category.html


-- MySQL Table okayapi_openant_information_category
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_information_category` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `information_category_id` int(11) NOT NULL COMMENT '',
    `sort_order` int(3) NOT NULL COMMENT '',
    `parent_id` int(11) NOT NULL COMMENT '',
    `okayapi_openant_information_category_status` tinyint(1) NOT NULL COMMENT '',
    `position` varchar(32) NOT NULL COMMENT '',
    `store_id` int(11) NOT NULL COMMENT '',
    `okayapi_openant_information_category_column` int(11) NOT NULL COMMENT '',
    KEY `information_category_id` (`information_category_id`),
    KEY `sort_order` (`sort_order`),
    KEY `parent_id` (`parent_id`),
    KEY `okayapi_openant_information_category_status` (`okayapi_openant_information_category_status`),
    KEY `position` (`position`),
    KEY `store_id` (`store_id`),
    KEY `okayapi_openant_information_category_column` (`okayapi_openant_information_category_column`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-信息分类';

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	IS NULL
information_category_id	int(11)	否
sort_order	int(3)	否
parent_id	int(11)	否
okayapi_openant_information_category_status	tinyint(1)	否
position	varchar(32)	否
store_id	int(11)	否
okayapi_openant_information_category_column	int(11)	否