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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
product_id | int(11) | 否 | ||||
okayapi_openant_return_option | varchar(255) | 是 | ||||
return_amount | decimal(15,4) | 否 | ||||
user_id | int(11) | 否 | ||||
firstname | varchar(32) | 是 | ||||
lastname | varchar(32) | 是 | ||||
varchar(96) | 是 | |||||
telephone | varchar(32) | 是 | ||||
quantity | int(4) | 否 | ||||
opened | tinyint(1) | 否 | ||||
mode_transport_id | int(11) | 是 | ||||
return_reason_id | int(11) | 否 | ||||
return_action_id | int(11) | 否 | ||||
return_status_id | int(11) | 否 | ||||
logistics | varchar(28) | 是 | ||||
return_mode_id | int(11) | 是 | ||||
date_added | datetime | 否 | ||||
return_id | int(11) | 否 | ||||
rowid | varchar(60) | 否 | ||||
order_id | int(11) | 否 |