+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_openant_return:/tablelist/okayapi_openant_return.html


-- MySQL Table okayapi_openant_return
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_return` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(11) NOT NULL COMMENT '',
    `okayapi_openant_return_option` varchar(255) NOT NULL COMMENT '',
    `return_amount` decimal(15,4) NOT NULL COMMENT '',
    `user_id` int(11) NOT NULL COMMENT '',
    `firstname` varchar(32) NOT NULL COMMENT '',
    `lastname` varchar(32) NOT NULL COMMENT '',
    `email` varchar(96) NOT NULL COMMENT '',
    `telephone` varchar(32) NOT NULL COMMENT '',
    `quantity` int(4) NOT NULL COMMENT '',
    `opened` tinyint(1) NOT NULL COMMENT '',
    `mode_transport_id` int(11) NOT NULL COMMENT '',
    `return_reason_id` int(11) NOT NULL COMMENT '',
    `return_action_id` int(11) NOT NULL COMMENT '',
    `return_status_id` int(11) NOT NULL COMMENT '',
    `logistics` varchar(28) NOT NULL COMMENT '',
    `return_mode_id` int(11) NOT NULL COMMENT '',
    `date_added` datetime NOT NULL COMMENT '',
    `return_id` int(11) NOT NULL COMMENT '',
    `rowid` varchar(60) NOT NULL COMMENT '',
    `order_id` int(11) NOT NULL COMMENT '',
    KEY `product_id` (`product_id`),
    KEY `okayapi_openant_return_option` (`okayapi_openant_return_option`),
    KEY `return_amount` (`return_amount`),
    KEY `user_id` (`user_id`),
    KEY `firstname` (`firstname`),
    KEY `lastname` (`lastname`),
    KEY `email` (`email`),
    KEY `telephone` (`telephone`),
    KEY `quantity` (`quantity`),
    KEY `opened` (`opened`),
    KEY `mode_transport_id` (`mode_transport_id`),
    KEY `return_reason_id` (`return_reason_id`),
    KEY `return_action_id` (`return_action_id`),
    KEY `return_status_id` (`return_status_id`),
    KEY `logistics` (`logistics`),
    KEY `return_mode_id` (`return_mode_id`),
    KEY `date_added` (`date_added`),
    KEY `return_id` (`return_id`),
    KEY `rowid` (`rowid`),
    KEY `order_id` (`order_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-20 of 20 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
product_idint(11)
okayapi_openant_return_optionvarchar(255)
return_amountdecimal(15,4)
user_idint(11)
firstnamevarchar(32)
lastnamevarchar(32)
emailvarchar(96)
telephonevarchar(32)
quantityint(4)
openedtinyint(1)
mode_transport_idint(11)
return_reason_idint(11)
return_action_idint(11)
return_status_idint(11)
logisticsvarchar(28)
return_mode_idint(11)
date_addeddatetime
return_idint(11)
rowidvarchar(60)
order_idint(11)

Guess You Like

MySQL Table Design okayapi_goods

MySQL Table Design okayapi_goods_comment

MySQL Table Design okayapi_shopxo_s_admin

MySQL Table Design okayapi_shopxo_s_answer

MySQL Table Design okayapi_shopxo_s_app_center_nav

MySQL Table Design okayapi_shopxo_s_app_home_nav

MySQL Table Design okayapi_shopxo_s_article

MySQL Table Design okayapi_shopxo_s_article_category

MySQL Table Design okayapi_shopxo_s_attachment

MySQL Table Design okayapi_shopxo_s_brand

MySQL Table Design okayapi_shopxo_s_brand_category

MySQL Table Design okayapi_shopxo_s_cart

MySQL Table Design okayapi_shopxo_s_config

MySQL Table Design okayapi_shopxo_s_custom_view

MySQL Table Design okayapi_shopxo_s_express

MySQL Table Design okayapi_shopxo_s_goods

MySQL Table Design okayapi_shopxo_s_goods_browse

MySQL Table Design okayapi_shopxo_s_goods_category

MySQL Table Design okayapi_shopxo_s_goods_category_join

MySQL Table Design okayapi_shopxo_s_goods_comments

TOP ↑