职位表:
CREATE TABLE `zhiwei` (
`zhiwei_id` int(15) NOT NULL AUTO_INCREMENT,
`zhiwei` varchar(255) NOT NULL,
`users_id` int(20) NOT NULL,
PRIMARY KEY (`zhiwei_id`),
KEY `zhiwei-users` (`users_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
部门表:
CREATE TABLE `bumen` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`bumen` varchar(255) NOT NULL,
`users_id` int(11) NOT NULL,
`zhiwei_id` int(15) NOT NULL,
PRIMARY KEY (`id`),
KEY `users-bumen` (`users_id`),
KEY `bumen-zhiwei` (`zhiwei_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
薪资表:
CREATE TABLE `salary` (
`salary_id` int(20) NOT NULL AUTO_INCREMENT,
`salary` int(8) DEFAULT NULL,
`users_id` int(20) NOT NULL,
PRIMARY KEY (`salary_id`),
KEY `users-salary` (`users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;