20180202-sales-report.sql 498 B

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