CREATE TABLE IF NOT EXISTS attendance
(id
int(11) NOT NULL AUTO_INCREMENT,time
datetime NOT NULL COMMENT '打卡时间',employee_id
varchar(30) NOT NULL COMMENT '员工id',employee_name
varchar(50) DEFAULT NULL COMMENT '员工姓名',workcode
varchar(30) DEFAULT NULL,status
varchar(30) DEFAULT NULL,authority
varchar(30) DEFAULT NULL,card_src
varchar(30) DEFAULT NULL,type
varchar(30) DEFAULT NULL,create_time
datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',update_time
datetime DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (id
),
UNIQUE KEY employee_time_UNIQUE
(time
,employee_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;