CREATE TABLE `daily_sales_report` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `admin_id` varchar(36) DEFAULT NULL COMMENT '员工id',
  `dep_id` varchar(36) DEFAULT NULL COMMENT '部门id',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '统计日期',
  `order_count` int(8) DEFAULT '0' COMMENT '销售签单数量',
  `order_amount` decimal(12,2) DEFAULT '0.00' COMMENT '销售签单总额',
  PRIMARY KEY (`id`),
  KEY `timeIdx` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
