退货表mysql_openant电商-退货 - 数据库设计 - 数据库表结构 - 果创云

-- 数据库大全：openant电商-退货

-- 来源：YesApi.cn

CREATE TABLE `yesapi_openant_return` (

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`product_id` int(11) NOT NULL COMMENT '',

`yesapi_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 '',

PRIMARY KEY (`id`)

) ENGINE=InnoDB COMMENT 'openant电商-退货';