
-- ----------------------------
-- Table structure for xy_orders
-- ----------------------------
DROP TABLE IF EXISTS `xy_orders`;
CREATE TABLE `xy_orders`  (
  `oid` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  `otrade` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `type` tinyint(0) NULL DEFAULT 0 COMMENT '订单类型',
  `alias_id` int(0) NULL DEFAULT 0,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `uid` int(0) NULL DEFAULT 0,
  `is_company` tinyint(1) NULL DEFAULT 1,
  `status` tinyint(1) NULL DEFAULT 0,
  `oprice` decimal(8, 2) NULL DEFAULT 0.00,
  `coupon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `score` int(0) NULL DEFAULT 0,
  `otitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `pay_type` tinyint(1) NULL DEFAULT 0,
  `channel_type` tinyint(1) NULL DEFAULT 0,
  `product_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `invoice_status` tinyint(1) NULL DEFAULT 0,
  `create_time` int(0) NULL DEFAULT NULL,
  `update_time` int(0) NULL DEFAULT NULL,
  `cancel_time` int(0) NULL DEFAULT NULL,
  `expire_time` int(0) NULL DEFAULT NULL,
  `finish_time` int(0) NULL DEFAULT NULL,
  `pay_time` int(0) NULL DEFAULT NULL,
  `delete_time` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`oid`) USING BTREE,
  UNIQUE INDEX `订单号`(`otrade`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单表' ROW_FORMAT = Dynamic;
