电商十五、pinyougou02.sql的内容⑥_lbh19630726的博客

DROP TABLE IF EXISTS `tb_order`;

CREATE TABLE `tb_order` (
  `order_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单id',
  `payment` decimal(20,2) DEFAULT NULL COMMENT '实付金额。精确到2位小数;单位:元。如:200.07，表示:200元7分',
  `payment_type` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '支付类型，1、在线支付，2、货到付款',
  `post_fee` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '邮费。精确到2位小数;单位:元。如:200.07，表示:200元7分',
  `status` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '状态：1、未付款，2、已付款，3、未发货，4、已发货，5、交易成功，6、交易关闭,7、待评价',
  `create_time` datetime DEFAULT NULL COMMENT '订单创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '订单更新时间',
  `payment_time` datetime DEFAULT NULL COMMENT '付款时间',
  `consign_time` datetime DEFAULT NULL COMMENT '发货时间',
  `end_time` datetime DEFAULT NULL COMMENT '交易完成时间',
  `close_time` datetime DEFAULT NULL COMMENT '交易关闭时间',
  `shipping_name` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '物流名称',
  `shipping_code` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '物流单号',
  `user_id` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '用户id',
  `buyer_message` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '买家留言',
  `buyer_nick` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '买家昵称',
  `buyer_rate` varchar(2) COLLATE utf8_bin DEFAULT NULL COMMENT '买家是否已经评价',
  `receiver_area_name` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '收货人地区名称(省，市，县)街道',
  `receiver_mobile` varchar(12) COLLATE utf8_bin DEFAULT NULL COMMENT '收货人手机',
  `receiver_zip_code` varchar(15) COLLATE utf8_bin DEFAULT NULL COMMENT '收货人邮编',
  `receiver` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '收货人',
  `expire` datetime DEFAULT NULL COMMENT '过期时间，定期清理',
  `invoice_type` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '发票类型(普通发票，电子发票，增值税发票)',
  `source_type` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '订单来源：1:app端，2：pc端，3：M端，4：微信端，5：手机qq端',
  `seller_id` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '商家ID',
  PRIMARY KEY (`order_id`),
  KEY `create_time` (`create_time`),
  KEY `buyer_nick` (`buyer_nick`),
  KEY `status` (`status`),
  KEY `payment_type` (`payment_type`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `tb_order` */

insert  into `tb_order`(`order_id`,`payment`,`payment_type`,`post_fee`,`status`,`create_time`,`update_time`,`payment_time`,`consign_time`,`end_time`,`close_time`,`shipping_name`,`shipping_code`,`user_id`,`buyer_message`,`buyer_nick`,`buyer_rate`,`receiver_area_name`,`receiver_mobile`,`receiver_zip_code`,`receiver`,`expire`,`invoice_type`,`source_type`,`seller_id`) values (1,NULL,'1',NULL,'0','2017-08-24 20:42:25','2017-08-24 20:42:25',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(2,NULL,'1',NULL,'0','2017-08-24 20:44:03','2017-08-24 20:44:03',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(3,'3.00','1',NULL,'0','2017-08-24 20:46:10','2017-08-24 20:46:10',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(4,'266.64','1',NULL,'0','2017-08-24 20:46:11','2017-08-24 20:46:11',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(5,'299.97','1',NULL,'0','2017-08-24 20:46:11','2017-08-24 20:46:11',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(6,'3.00','1',NULL,'0','2017-08-24 20:46:40','2017-08-24 20:46:40',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(7,'266.64','1',NULL,'0','2017-08-24 20:46:40','2017-08-24 20:46:40',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(8,'299.97','1',NULL,'0','2017-08-24 20:46:40','2017-08-24 20:46:40',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(9,'3.00','1',NULL,'0','2017-08-24 21:01:10','2017-08-24 21:01:10',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(10,'266.64','1',NULL,'0','2017-08-24 21:01:11','2017-08-24 21:01:11',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(11,'299.97','1',NULL,'0','2017-08-24 21:01:11','2017-08-24 21:01:11',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(12,'3.00','1',NULL,'0','2017-08-24 21:05:56','2017-08-24 21:05:56',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(13,'266.64','1',NULL,'0','2017-08-24 21:05:56','2017-08-24 21:05:56',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(14,'299.97','1',NULL,'0','2017-08-24 21:05:56','2017-08-24 21:05:56',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(15,'3.00','1',NULL,'0','2017-08-24 23:07:38','2017-08-24 23:07:38',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(16,'266.64','1',NULL,'0','2017-08-24 23:07:38','2017-08-24 23:07:38',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(17,'299.97','1',NULL,'0','2017-08-24 23:07:38','2017-08-24 23:07:38',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'金燕龙办公楼','13900112222',NULL,'李嘉诚',NULL,NULL,NULL,NULL),(18,'177.76','1',NULL,'1','2017-08-25 11:59:03','2017-08-25 11:59:03',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yijia'),(19,'2.00','1',NULL,'1','2017-08-25 11:59:03','2017-08-25 11:59:03',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'qiandu'),(20,'177.76','1',NULL,'1','2017-08-25 11:59:03','2017-08-25 11:59:03',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yijia'),(21,'177.76','1',NULL,'1','2017-08-25 23:26:10','2017-08-25 23:26:10',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(22,'2.00','1',NULL,'1','2017-08-25 23:26:11','2017-08-25 23:26:11',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(23,'177.76','1',NULL,'1','2017-08-25 23:26:11','2017-08-25 23:26:11',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(24,'2.00','1',NULL,'1','2017-08-25 23:28:10','2017-08-25 23:28:10',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(25,'1.00','1',NULL,'1','2017-08-25 23:49:18','2017-08-25 23:49:18',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(26,'0.01','1',NULL,'1','2017-08-26 00:06:31','2017-08-26 00:06:31',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'修正大厦','13700221122',NULL,'李佳红',NULL,NULL,NULL,NULL),(27,'0.01','1',NULL,'1','2017-08-26 00:10:13','2017-08-26 00:10:13',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(28,'0.01','1',NULL,'1','2017-08-26 00:17:53','2017-08-26 00:17:53',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(29,'0.01','1',NULL,'1','2017-08-26 00:19:56','2017-08-26 00:19:56',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(30,'0.01','1',NULL,'1','2017-08-26 00:37:47','2017-08-26 00:37:47',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(31,'0.02','1',NULL,'1','2017-08-26 00:37:47','2017-08-26 00:37:47',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(32,'0.02','1',NULL,'2','2017-08-26 00:41:13','2017-08-26 00:41:13',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(33,'0.01','1',NULL,'2','2017-08-26 00:41:14','2017-08-26 00:41:14',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,'中腾大厦','13301212233',NULL,'李佳星',NULL,NULL,NULL,NULL),(34,'0.01','1',NULL,'1','2017-08-26 11:57:26','2017-08-26 11:57:26',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'qiandu'),(35,'0.01','1',NULL,'1','2017-08-26 12:21:39','2017-08-26 12:21:39',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'qiandu'),(36,'0.01','1',NULL,'1','2017-08-26 12:34:46','2017-08-26 12:34:46',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'qiandu'),(37,'0.01','1',NULL,'2','2017-08-26 12:47:44','2017-08-26 12:47:44',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'qiandu'),(38,'0.02','1',NULL,'2','2017-08-26 12:47:44','2017-08-26 12:47:44',NULL,NULL,NULL,NULL,NULL,NULL,'lijialong',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yijia');

/*Table structure for table `tb_order_item` */
DROP TABLE IF EXISTS `tb_order`;

CREATE TABLE