[简单工作流系统的自己搭建]数据库设计-员工打卡、考勤、工资等

drop database if exists hrSystem;

create database hrSystem;

use hrSystem;

create table type_table
(
 type_id int auto_increment,
 type_name varchar(50) not null,
 amerce_amount double not null,
 primary key(type_id)
);

create table emp_table
(
 emp_id int auto_increment,
 emp_type int,
 emp_name varchar(50) not null,
 emp_pass varchar(50) not null,
 emp_salary double not null,
 mgr_id int,
 dept_name varchar(50),
 primary key(emp_id),
 unique key(emp_name),
 foreign key(mgr_id) references emp_table(emp_id)
);

create table attend_table
(
 attend_id int auto_increment,
 duty_day varchar(50) not null,
 punch_time datetime,
 is_come boolean not null,
 type_id int not null,
 emp_id int not null,
 primary key(attend_id),
 foreign key(type_id) references type_table(type_id),
 foreign key(emp_id) references emp_table(emp_id)
);

create table app_table
(
 app_id int auto_increment,
 attend_id int not null,
 app_reason varchar(255),
 app_result boolean,
 type