Kanbay System
Autor: Rachel • April 8, 2018 • 670 Words (3 Pages) • 564 Views
...
--
-- Database of: `b1300922`
--
-- --------------------------------------------------------
--
-- Table structure for table `Accessory`
--
CREATE TABLE IF NOT EXISTS `Accessory` (
`Accessory_ID` varchar(10) NOT NULL,
`Accessory_Name` varchar(20) NOT NULL,
`Model` varchar(10) NOT NULL,
`Brand` varchar(15) NOT NULL,
PRIMARY KEY (`Accessory_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Accessory`
--
INSERT INTO `Accessory` (`Accessory_ID`, `Accessory_Name`, `Model`, `Brand`) VALUES
('A0001', 'Pen drive', '16GB', 'Toshiba'),
('A0002', 'Hard Disk', '500 GB', 'Toshiba'),
('A0003', 'mouse', 'Remote Mou', 'HP');
-- --------------------------------------------------------
--
-- Table structure for table `Employee`
--
CREATE TABLE IF NOT EXISTS `Employee` (
`Emp_id` varchar(6) NOT NULL,
`Emp_Name` varchar(30) NOT NULL,
`DOB` date NOT NULL,
`DOJ` date NOT NULL,
`Qualification` varchar(10) NOT NULL,
`Design_Code` varchar(10) NOT NULL,
`Dept` varchar(10) NOT NULL,
`Proj_ID` varchar(10) NOT NULL,
`Mgr_Id` varchar(10) NOT NULL,
`Trainer_Id` varchar(10) DEFAULT NULL,
`Accessory_id` varchar(10) DEFAULT NULL,
PRIMARY KEY (`Emp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Employee`
--
INSERT INTO `Employee` (`Emp_id`, `Emp_Name`, `DOB`, `DOJ`, `Qualification`, `Design_Code`, `Dept`, `Proj_ID`, `Mgr_Id`, `Trainer_Id`, `Accessory_id`) VALUES
('1', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `Emp_Type`
--
CREATE TABLE IF NOT EXISTS `Emp_Type` (
`Design_Code` varchar(10) NOT NULL,
`Designation_Name` varchar(30) NOT NULL,
`Salary_Slab_ID` int(11) DEFAULT NULL,
PRIMARY KEY (`Design_Code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Emp_Type`
--
INSERT INTO `Emp_Type` (`Design_Code`, `Designation_Name`, `Salary_Slab_ID`) VALUES
('C001', ' Contract_Staff', 1),
('P001', ' Permanent _Staff', 2),
('T001', ' Temporary Staff', 3);
-- --------------------------------------------------------
--
-- Table structure for table `login`
--
CREATE TABLE IF NOT EXISTS `login` (
`ID` int(11) NOT NULL,
`username` varchar(50) DEFAULT NULL,
`password` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `login`
--
INSERT INTO `login` (`ID`, `username`, `password`) VALUES
(0, NULL, NULL),
(1, 'admin', '123'),
(2, 'employee', '123'),
(1, 'admin', '12345'),
(0, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `Manager`
--
CREATE TABLE IF NOT EXISTS `Manager` (
`Mgr_Code` varchar(10) NOT NULL,
`Mgr_Name` varchar(30) NOT NULL,
`Mgr_Start_Date` date NOT NULL,
`Mgr_End_Date` date NOT NULL,
`Mgr_Salary`
...