okayapi_openant_information - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_information：/tablelist/okayapi_openant_information.html


-- MySQL Table okayapi_openant_information
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_information` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `sort_order` int(3) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_openant_information_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    `date_added` datetime NOT NULL COMMENT '',
    `date_modified` datetime NOT NULL COMMENT '',
    `information_id` int(11) NOT NULL COMMENT '',
    `information_category_id` int(11) NOT NULL COMMENT '',
    `store_id` int(11) NOT NULL COMMENT '',
    KEY `sort_order` (`sort_order`),
    KEY `okayapi_openant_information_status` (`okayapi_openant_information_status`),
    KEY `date_added` (`date_added`),
    KEY `date_modified` (`date_modified`),
    KEY `information_id` (`information_id`),
    KEY `information_category_id` (`information_category_id`),
    KEY `store_id` (`store_id`),
    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	Default	IS NULL	Demo Data
sort_order	int(3)	0	否	0
okayapi_openant_information_status	tinyint(1)	1	否	1
date_added	datetime		否
date_modified	datetime		否
information_id	int(11)		否
information_category_id	int(11)		否
store_id	int(11)		否