etrade / dili-xtrade · Files

use dili_etrade;
CREATE TABLE `order_extra` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `order_id` bigint DEFAULT NULL COMMENT '订单主键',
  `order_code` varchar(40) DEFAULT NULL COMMENT '订单编码',
  `market_id` bigint DEFAULT NULL COMMENT '订单市场id',
  `user_mark` varchar(40) DEFAULT NULL COMMENT '创建订单标识 小程序openId，app是安卓id',
  `source` tinyint DEFAULT NULL COMMENT '订单来源',
  `created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `modified_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;