okayapi_openant_order_history - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_order_history：/tablelist/okayapi_openant_order_history.html


-- MySQL Table okayapi_openant_order_history
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_order_history` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `order_history_id` int(11) NOT NULL COMMENT '',
    `order_id` int(11) NOT NULL COMMENT '',
    `order_status_id` int(11) NOT NULL COMMENT '',
    `notify` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_openant_order_history_comment` text NOT NULL COMMENT '',
    `date_added` datetime NOT NULL COMMENT '',
    KEY `order_history_id` (`order_history_id`),
    KEY `order_id` (`order_id`),
    KEY `order_status_id` (`order_status_id`),
    KEY `notify` (`notify`),
    KEY `okayapi_openant_order_history_comment` (`okayapi_openant_order_history_comment`),
    KEY `date_added` (`date_added`),
    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-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Demo Data
order_history_id	int(11)		否
order_id	int(11)		否
order_status_id	int(11)		否
notify	tinyint(1)	0	否	0
okayapi_openant_order_history_comment	text		否
date_added	datetime		否