guzijian / bsth-alcohol-sign · Files

CREATE TABLE lingang_all_in_one.sign_report_day_summary (
	id INT auto_increment NOT NULL COMMENT 'ID',
	dateStr varchar(30) NOT NULL COMMENT '日期 格式为：yyyy-MM-dd',
	alcohol_Num INT DEFAULT 0 NULL COMMENT '酒驾人数',
	early_Signing INT DEFAULT 0 NULL COMMENT '早签人数',
	late_Signing INT DEFAULT 0 NULL COMMENT '晚签人数',
	normal_Signing INT DEFAULT 0 NULL COMMENT '正常签到人数',
	CONSTRAINT sign_report_day_summary_pk PRIMARY KEY (id),
	CONSTRAINT sign_report_day_summary_unique UNIQUE KEY (dateStr)
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;