okayapi_openant_order_total - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_openant_order_total：/tablelist/okayapi_openant_order_total.html


-- MySQL Table okayapi_openant_order_total
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_order_total` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `order_total_id` int(10) NOT NULL COMMENT '',
    `order_id` int(11) NOT NULL COMMENT '',
    `okayapi_openant_order_total_code` varchar(32) NOT NULL COMMENT '',
    `title` varchar(255) NOT NULL COMMENT '',
    `okayapi_openant_order_total_value` decimal(15,4) NOT NULL DEFAULT '0.0000' COMMENT '',
    `sort_order` int(3) NOT NULL COMMENT '',
    KEY `order_total_id` (`order_total_id`),
    KEY `order_id` (`order_id`),
    KEY `okayapi_openant_order_total_code` (`okayapi_openant_order_total_code`),
    KEY `title` (`title`),
    KEY `okayapi_openant_order_total_value` (`okayapi_openant_order_total_value`),
    KEY `sort_order` (`sort_order`),
    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_total_id	int(10)		否
order_id	int(11)		否
okayapi_openant_order_total_code	varchar(32)		否
title	varchar(255)		否
okayapi_openant_order_total_value	decimal(15,4)	0.0000	否	0.0000
sort_order	int(3)		否