 --
 ALTER TABLE `user`
   ADD PRIMARY KEY (`employee_id`),
-  ADD KEY `position` (`position`),
-  ADD KEY `civil status` (`civil status`),
-  ADD KEY `gender` (`gender`);
+  ADD KEY `position` (`position_id`),
+  ADD KEY `civil status` (`civil_status_id`),
+  ADD KEY `gender` (`gender_id`);
 
 --
 -- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `employee_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- Constraints for dumped tables
--

-- Constraints for table `user`
--
ALTER TABLE `user`
  ADD CONSTRAINT `user_ibfk_2` FOREIGN KEY (`gender_id`) REFERENCES `gender` (`gender_id`),
  ADD CONSTRAINT `user_ibfk_3` FOREIGN KEY (`civil_status_id`) REFERENCES `civil_status` (`cs_id`),
  ADD CONSTRAINT `user_ibfk_4` FOREIGN KEY (`position_id`) REFERENCES `position` (`position_id`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
