CREATE TABLE `salary` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `employ_id` int(10) DEFAULT NULL comment '员工id',
  `created` datetime not null default current_timestamp comment '创建日期',
  `before_salary` float not null comment '调薪前薪资',
  `salary` float not null comment '当前薪资',
  `remark` text default null comment '备注',
  PRIMARY KEY (`id`)
) comment '薪资表';


create table employee(
	id int PRIMARY key AUTO_INCREMENT,
	name char(64) not null comment '员工姓名',
	gender tinyint default 0 comment '性别(1:男,2:女)',
	birthday datetime comment '生日',
	id_card char(32) not null comment '身份证',
	email char(64) comment '邮箱',
	phone char(32) not null comment '电话',
	department_id int not null comment '所属部门',
	created datetime not null default current_timestamp
) comment '职员表';



create table department(
	id int not null PRIMARY key AUTO_INCREMENT,
	name char(64) not null comment '部门名称',
	parent_id int default 0 comment '父部门',
	dep_path char(128) comment '部门路径',
	enabled tinyint default 1 comment '-1:禁用,1:使用'
) comment '部门表';


create table hr(
	id int PRIMARY key AUTO_INCREMENT,
	name char(64) not null comment '姓名',
	phone char(32) not null comment '电话',
	address char(255) not null comment '地址',
	enabled tinyint default 1 comment '账户是否可用(-1:禁用,1正常)',
	username char(255) not null comment '用户名',
	password char(255) not null comment '密码',
	user_face char(255) comment '用户头像',
	remark char(255) comment '备注'
) comment 'hr 表';


create table role(
	id int PRIMARY key AUTO_INCREMENT,
	name char(64) not null comment '角色'
) comment '角色表';


create table hr_role(
	id int PRIMARY key AUTO_INCREMENT,
	hr_id int not null comment'hr id',
	role_id int not null comment'角色id'
) comment 'hr 角色关联表';

create table menu(
	id int PRIMARY key AUTO_INCREMENT,
	name char(255) comment '组件名',
	icon char(255) comment '菜单图标',
	path char(255) comment '路由',
	parent_id int comment '父菜单',
	enabled tinyint default 1 comment'是否可用(-1:禁用,1:正常)'
) comment '菜单表';


create table menu_role(
	id int PRIMARY key AUTO_INCREMENT,
	menu_id int not null comment'menu id',
	role_id int not null comment'角色id'
) comment '菜单角色关联表';