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;