marker-wu commented on issue #13343:
URL:
https://github.com/apache/shardingsphere/issues/13343#issuecomment-954362150
CREATE TABLE `oms_order_data_0` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`zid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '企业ID',
`order_number` varchar(32) NOT NULL DEFAULT '' COMMENT '系统订单号',
`order_data` mediumtext NOT NULL COMMENT '订单数据',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP COMMENT '数据更新时间',
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据创建时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uk-order_number` (`order_number`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统订单数据表';
CREATE TABLE `oms_order_items_0` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`zid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '企业ID',
`order_number` varchar(32) NOT NULL DEFAULT '' COMMENT '系统订单号',
`platform_order_id` varchar(40) NOT NULL DEFAULT '' COMMENT '平台订单号',
`platform_order_item_id` varchar(50) NOT NULL DEFAULT '' COMMENT
'平台订单商品ID',
`pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'pid',
`asin` varchar(16) NOT NULL DEFAULT '' COMMENT 'ASIN',
`seller_sku` varchar(50) NOT NULL DEFAULT '' COMMENT 'SKU',
`title` varchar(500) NOT NULL DEFAULT '' COMMENT '商品标题',
`quantity_modified` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT
'修改后的商品数量',
`item_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品金额',
`item_tax` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品税费',
`shipping_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT
'客付运费',
`cod_fee` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'COD费用',
`cod_fee_discount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT
'COD费用的折扣',
`shipping_tax` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT
'运费税',
`gift_wrap_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT
'商品的礼品包装价格',
`gift_wrap_tax` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT
'礼品包装价格的税金',
`shipping_discount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT
'运费折扣',
`shipping_discount_tax` decimal(10,2) unsigned NOT NULL DEFAULT '0.00'
COMMENT '运费折价税',
`promotion_discount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00'
COMMENT '促销折扣的总和',
`promotion_discount_tax` decimal(10,2) unsigned NOT NULL DEFAULT '0.00'
COMMENT '促销折扣的总和税',
`currency_code` varchar(10) NOT NULL DEFAULT '' COMMENT '币种编码',
`item_unit_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT
'单价(计算)',
`sales_revenue_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00'
COMMENT '销售收益(计算)',
`tax_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT
'税费(计算)',
`gross_profit_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT
'毛利润(计算可为负)',
`outbound_cost_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00'
COMMENT '出库成本(￥计算)',
`shipping_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT
'运费(￥计算)',
`is_delete` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT
'删除标记:0未删除,1已删除',
`customization` text NOT NULL COMMENT '商品信息的附件信息',
`attachments` text NOT NULL COMMENT '商品信息的附件图片地址等',
`gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP COMMENT '数据更新时间',
`gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '数据创建时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx-asin` (`asin`) USING BTREE,
KEY `idx-pid` (`pid`) USING BTREE,
KEY `idx-order_number` (`order_number`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单商品列表';
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
