| 1234567891011 |
- 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;
|