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电商-退货';

复制后，到数据库执行，即可创建此数据库表。