-- --------------------------------------------------------

--
-- Table structure for table `patient`
--

CREATE TABLE `patient` (
  `id` int(11) NOT NULL,
  `patient_id` varchar(20) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `sex` varchar(10) DEFAULT NULL,
  `blood_group` varchar(10) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `affliate` varchar(50) DEFAULT NULL,
  `picture` varchar(50) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `patient`
--

INSERT INTO `patient` (`id`, `patient_id`, `firstname`, `lastname`, `phone`, `mobile`, `address`, `sex`, `blood_group`, `date_of_birth`, `affliate`, `picture`, `created_by`, `create_date`, `status`) VALUES
(9, 'P7OGZGC3', 'Tuhin', 'Sorkar', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', '', '2015-11-01', NULL, 'assets/images/patient/2016-11-20/p14.png', 2, '2016-09-04', 1),
(10, 'PDX3KY02', 'Raihan', 'Rahman', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'B-', '2016-09-29', NULL, 'assets/images/patient/2016-11-20/p12.png', 2, '2011-10-19', 1),
(11, 'PEJNSXWO', 'Kamal', 'Uddin', '', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'B+', '1988-10-02', NULL, 'assets/images/patient/2016-11-20/p11.png', 2, '2016-08-10', 1),
(12, 'PEJNSXWC', 'Hashem', 'Roy', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'O+', '1988-10-02', NULL, 'assets/images/patient/2016-11-20/p10.png', 2, '2016-08-03', 1),
(13, 'P02DQ9T1', 'Hello', 'World', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'O+', '1996-10-01', NULL, 'assets/images/patient/2016-11-20/p9.png', 2, '2016-10-27', 1),
(15, 'PSUR2YIC', 'Hello', 'World', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'B+', '1996-10-01', NULL, 'assets/images/patient/2016-11-20/p8.png', 2, '2016-10-27', 1),
(16, 'PF3A7NPY', 'Nazmul', 'Islam', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'O-', '2010-10-01', NULL, 'assets/images/patient/2016-11-20/p7.png', 2, '2016-10-27', 1),
(17, 'PB92AZ7I', 'Hasan', 'Mashood', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'AB+', '1996-10-01', NULL, 'assets/images/patient/2016-11-20/p6.png', 2, '2016-10-27', 1),
(18, 'PMO8J6J9', 'Jhon', 'Doe', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'A+', '2016-11-19', NULL, 'assets/images/patient/2016-11-20/p5.png', 2, '2016-11-19', 1),
(19, 'P5FJJUQS', 'Jhon', 'Doe', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'A+', '2016-11-19', NULL, 'assets/images/patient/2016-11-20/p4.png', 2, '2016-11-19', 1),
(20, 'PHO969YL', 'Jhon', 'Doe', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'A+', '2016-11-01', NULL, 'assets/images/patient/2016-11-20/p3.png', 2, '2016-11-19', 1),
(21, 'P2FBAKE0', 'Jhon', 'Doe', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'A+', '2016-11-01', NULL, 'assets/images/patient/2016-11-20/p2.png', 2, '2016-11-19', 1),
(23, 'P4FXWA25', 'Jhon', 'Doe', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'A+', '2016-11-01', NULL, 'assets/images/patient/2016-11-20/p1.png', 2, '2016-11-19', 1),
(24, 'PPBSFHZP', 'Harald', 'Hass', '0123456789', '0123456789', '98 Green Road, Farmgate, Dhaka-1215', 'Male', 'A+', '2016-11-01', NULL, 'assets/images/patient/2016-11-20/p.png', 2, '2016-11-19', 1);

-- --------------------------------------------------------

--
-- Table structure for table `schedule`
--

CREATE TABLE `schedule` (
  `schedule_id` int(11) NOT NULL,
  `doctor_id` int(11) DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `available_days` varchar(50) DEFAULT NULL,
  `per_patient_time` time DEFAULT NULL,
  `serial_visibility_type` tinyint(4) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `schedule`
--

INSERT INTO `schedule` (`schedule_id`, `doctor_id`, `start_time`, `end_time`, `available_days`, `per_patient_time`, `serial_visibility_type`, `status`) VALUES
(5, 8, '09:00:00', '12:00:00', 'Monday', '00:30:00', 2, 1),
(6, 1, '09:00:00', '12:00:00', 'Tuesday', '00:30:00', 1, 1),
(9, 7, '10:00:00', '20:00:00', 'Sunday', '00:30:00', 2, 1),
(10, 7, '10:00:00', '20:00:00', 'Thursday', '00:30:00', 1, 1),
(11, 1, '11:00:00', '10:00:00', 'Sunday', '13:35:00', 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `setting_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `email` varchar(50) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `logo` varchar(50) DEFAULT NULL,
  `favicon` varchar(100) DEFAULT NULL,
  `footer_text` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`setting_id`, `title`, `description`, `email`, `phone`, `logo`, `favicon`, `footer_text`) VALUES
(1, 'Hospital Management System PHP MYSQL Source Code', 'Hospital Management System PHP MYSQL Source Code', 'admin@example.com', '0123456788', 'assets/images/apps/2017-01-14/l.png', 'assets/images/icons/2016-11-20/f.png', 'Hospital Management System PHP MYSQL Source Code');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `user_id` int(11) NOT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `user_role` tinyint(1) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `short_biography` text,
  `picture` varchar(50) DEFAULT NULL,
  `specialist` varchar(255) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `sex` varchar(10) DEFAULT NULL,
  `blood_group` varchar(10) DEFAULT NULL,
  `degree` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `update_date` date DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `firstname`, `lastname`, `email`, `password`, `user_role`, `designation`, `department_id`, `address`, `phone`, `mobile`, `short_biography`, `picture`, `specialist`, `date_of_birth`, `sex`, `blood_group`, `degree`, `created_by`, `create_date`, `update_date`, `status`) VALUES
(1, 'Samim', 'Khan', 'doctor@demo.com', '827ccb0eea8a706c4c34a16891f84e7b', 2, '', 2, 'It is a long established fact that a reader will be distracted by the readable content ', '0123456798', '0123456798', '<p>It is a long established fact that a reader will be distracted by the readable content</p>', 'assets/images/doctor/2016-11-20/a1.png', '', '2016-10-12', 'Male', 'A+', '<p>It is a long established fact that a reader will be distracted by the readable content</p>', 2, '2016-11-20', NULL, 1),
(2, 'Hospital', 'Management System', 'admin@demo.com', '827ccb0eea8a706c4c34a16891f84e7b', 1, '', 0, 'Dhaka', '01821742285', '01821742285', '', 'assets/images/doctor/2016-11-20/p.png', '', '1994-02-10', 'Male', 'B+', '', 2, '2017-01-14', NULL, 1),
(4, 'Md. Jabed', 'Mahmud', 'doctor@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 3, 'Frontent Developer', 1, '98 Green Road, Farmgate, Dhaka-1215', '0123456798', '1234567890', '<p>TEST</p>', 'assets/images/representative/2016-11-20/p1.png', 'MBBS', '2016-10-11', 'Male', 'B-', '<p>TEST</p>', 2, '2016-10-15', NULL, 1),
(7, 'Jahed', 'Abdullah', 'tuhin@gmail.com', '25f9e794323b453885f5181f1b624d0b', 2, 'Seniro Doctor', 3, 'It is a long established fact that a reader will be distracted by the readable content ', '01234567980', '01234567980', '<p>It is a long established fact that a reader will be distracted by the readable content </p>', 'assets/images/doctor/2016-11-20/a.png', 'MBBS', '2016-10-11', 'Male', 'A+', '<p>It is a long established fact that a reader will be distracted by the readable content </p>', 2, '2016-11-20', NULL, 1),
(8, 'Naeem', 'Khan', 'naeem@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 2, 'Frontent Developer', 1, 'Dhaka', '1234567890', '1234567890', '<p>sdfaasdfasdfs</p>', 'assets/images/doctor/2016-11-20/d1.png', '', '2016-10-10', 'Male', 'B+', '<p>It is a long established fact that a reader will be distracted by the readable content </p>', 2, '2016-11-20', NULL, 1),
(9, 'Kamrul', 'Anam', 'agent@demo.com', '827ccb0eea8a706c4c34a16891f84e7b', 3, '', 2, 'Dhaka Bangladesh', '0180525666', '0182554885', '', 'assets/images/representative/2016-11-20/p.png', '', '2016-10-02', 'Male', 'B-', '', 2, '2016-10-15', NULL, 1),
(10, 'Jane ', 'Doe', 'jane@example.com', '827ccb0eea8a706c4c34a16891f84e7b', 2, 'Doctor', 2, 'Dhaka, Bangladesh', '1234567890', '1234567890', '<p>Test</p>', 'assets/images/doctor/2016-11-20/d.png', '', '1994-11-01', 'Male', 'B+', '', 2, '2016-11-20', NULL, 1);

-- --------------------------------------------------------