okayapi_openant_return_history - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_return_history：/tablelist/okayapi_openant_return_history.html


-- MySQL Table okayapi_openant_return_history
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_return_history` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `return_history_id` int(11) NULL COMMENT '',
    `return_id` int(11) NULL COMMENT '',
    `return_status_id` int(11) NULL COMMENT '',
    `notify` tinyint(1) NULL COMMENT '',
    `date_added` datetime NULL COMMENT '',
    `okayapi_openant_return_history_comment` text NULL COMMENT '',
    KEY `return_history_id` (`return_history_id`),
    KEY `return_id` (`return_id`),
    KEY `return_status_id` (`return_status_id`),
    KEY `notify` (`notify`),
    KEY `date_added` (`date_added`),
    KEY `okayapi_openant_return_history_comment` (`okayapi_openant_return_history_comment`),
    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	IS NULL
return_history_id	int(11)	否
return_id	int(11)	否
return_status_id	int(11)	否
notify	tinyint(1)	否
date_added	datetime	否
okayapi_openant_return_history_comment	text	是