Doxbin – sohanetworks hospital

-- -------------------------------------------------------- -- -- 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', 'It is a long established fact that a reader will be distracted by the readable content', 'assets/images/doctor/2016-11-20/a1.png', '', '2016-10-12', 'Male', 'A+', 'It is a long established fact that a reader will be distracted by the readable content', 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', 'TEST', 'assets/images/representative/2016-11-20/p1.png', 'MBBS', '2016-10-11', 'Male', 'B-', 'TEST', 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', 'It is a long established fact that a reader will be distracted by the readable content ', 'assets/images/doctor/2016-11-20/a.png', 'MBBS', '2016-10-11', 'Male', 'A+', 'It is a long established fact that a reader will be distracted by the readable content ', 2, '2016-11-20', NULL, 1), (8, 'Naeem', 'Khan', 'naeem@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 2, 'Frontent Developer', 1, 'Dhaka', '1234567890', '1234567890', 'sdfaasdfasdfs', 'assets/images/doctor/2016-11-20/d1.png', '', '2016-10-10', 'Male', 'B+', 'It is a long established fact that a reader will be distracted by the readable content ', 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', 'Test', 'assets/images/doctor/2016-11-20/d.png', '', '1994-11-01', 'Male', 'B+', '', 2, '2016-11-20', NULL, 1); -- --------------------------------------------------------

  ____            _     _       
 |  _ \  _____  _| |__ (_)_ __  
 | | | |/ _ \ \/ / '_ \| | '_ \ 
 | |_| | (_) >  <| |_) | | | | |
 |____/ \___/_/\_\_.__/|_|_| |_|

Captcha

Hide Paste

Bump Paste

Upgrade Required

Select Currency