clinicdb

-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 16, 2019 at 05:17 AM
-- Server version: 8.0.15
-- PHP Version: 7.2.7

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `clinicdb`
--

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

--
-- Table structure for table `appointment`
--

CREATE TABLE `appointment` (
  `id` int(11) NOT NULL,
  `department` varchar(255) NOT NULL,
  `date` datetime NOT NULL,
  `completed` tinyint(1) NOT NULL,
  `no_show` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `appointment`
--

INSERT INTO `appointment` (`id`, `department`, `date`, `completed`, `no_show`) VALUES
(1, 'Laboratory', '2019-05-21 08:00:00', 0, 0),
(2, 'Radiology', '2018-11-21 15:00:00', 1, 0),
(3, 'Optometry', '2019-02-13 10:30:00', 0, 1),
(4, 'Cytology', '2019-06-29 11:00:00', 0, 0);

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

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `floor` int(11) NOT NULL,
  `poc_name` varchar(255) NOT NULL,
  `poc_phone` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`id`, `name`, `floor`, `poc_name`, `poc_phone`) VALUES
(1, 'Medical Laboratory', 2, 'Mr Dracula', 7567443566),
(2, 'Radiology', 2, 'Mrs Marie Curie', 7326888732),
(3, 'Medical Logistics', 1, 'John Fastwalker III', 7326888733),
(4, 'Pharmacy', 1, 'Dr Green Thumb', 8649371000);

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

--
-- Table structure for table `er`
--

CREATE TABLE `er` (
  `roomid` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `entrance_time` datetime NOT NULL,
  `expected_wait_time` time NOT NULL,
  `doctor_assigned` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `erstaff`
--

CREATE TABLE `erstaff` (
  `id` int(11) NOT NULL,
  `fName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `phone_ext` int(11) NOT NULL,
  `job_title` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `home_phone` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `erstaff_is_oncall`
--

CREATE TABLE `erstaff_is_oncall` (
  `nr` int(11) NOT NULL,
  `erstaff` int(11) NOT NULL,
  `oncall.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `erstaff_works_in_er`
--

CREATE TABLE `erstaff_works_in_er` (
  `nr` int(11) NOT NULL,
  `erstaff.id` int(11) NOT NULL,
  `er.roomid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `er_has_room`
--

CREATE TABLE `er_has_room` (
  `nr` int(11) NOT NULL,
  `er.roomid` int(11) NOT NULL,
  `room.number` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `insurance`
--

CREATE TABLE `insurance` (
  `market_id` int(32) NOT NULL,
  `type` varchar(255) NOT NULL,
  `provider` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `expiration_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `insurance`
--

INSERT INTO `insurance` (`market_id`, `type`, `provider`, `start_date`, `expiration_date`) VALUES
(4356756, 'free', 'Medicaid', '2018-11-27', '2019-06-27'),
(7689045, 'pay', 'Blue Shield', '2018-12-25', '2019-11-04'),
(98760001, 'free', 'Medicaid', '2018-09-04', '2019-05-19'),
(999888777, 'pay', 'Blue Cross', '2018-03-11', '2019-02-25');

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

--
-- Table structure for table `labstaff`
--

CREATE TABLE `labstaff` (
  `id` int(11) NOT NULL,
  `fName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `phone_ext` int(11) NOT NULL,
  `job_title` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `home_phone` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `labstaff_has_role`
--

CREATE TABLE `labstaff_has_role` (
  `nr` int(11) NOT NULL,
  `labstaff.id` int(11) NOT NULL,
  `role.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `labstaff_runs_labtest`
--

CREATE TABLE `labstaff_runs_labtest` (
  `nr` int(11) NOT NULL,
  `labstaff.id` int(11) NOT NULL,
  `labtest.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `labtest`
--

CREATE TABLE `labtest` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `tat_hours` int(11) NOT NULL,
  `fasting` tinyint(1) NOT NULL,
  `stat` tinyint(1) NOT NULL,
  `asap` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `medicine`
--

CREATE TABLE `medicine` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `concentration` float NOT NULL,
  `unit_of_measurement` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `controlled_substance` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `oncall`
--

CREATE TABLE `oncall` (
  `id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `department_id` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `phone` int(11) NOT NULL,
  `beeper` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

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

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

CREATE TABLE `patient` (
  `id` int(11) NOT NULL,
  `fName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `dob` date NOT NULL,
  `home_phone` int(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `patient` (`id`, `fName`, `lName`, `dob`, `home_phone`) VALUES
(1, 'Abe', 'Lincoln', '1900-01-30', 1111111111),
(2, 'Albert', 'Einstein', '1905-03-08', 1111111112),
(3, 'Leeroy', 'Jenkins', '1976-05-18', 1111111113),
(4, 'Robert', 'Paulson', '1983-01-23', 1111111114);

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

--
-- Table structure for table `patientstatus`
--

CREATE TABLE `patientstatus` (
  `id` int(11) NOT NULL,
  `admitted` datetime NOT NULL,
  `discharged` datetime NOT NULL,
  `needs_labs` tinyint(1) NOT NULL,
  `needs_medication` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `patient_has_appointment`
--

CREATE TABLE `patient_has_appointment` (
  `nr` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `appointment_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `patient_has_appointment`
--

INSERT INTO `patient_has_appointment` (`nr`, `patient_id`, `appointment_id`) VALUES
(1, 1, 4),
(2, 3, 3),
(3, 1, 1),
(4, 2, 2);

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

--
-- Table structure for table `patient_has_insurance`
--

CREATE TABLE `patient_has_insurance` (
  `nr` int(11) NOT NULL,
  `patient.id` int(11) NOT NULL,
  `insurance.market_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `patient_has_insurance`
--

INSERT INTO `patient_has_insurance` (`nr`, `patient.id`, `insurance.market_id`) VALUES
(1, 1, 4356756),
(2, 2, 7689045),
(3, 3, 999888777),
(4, 4, 98760001);

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

--
-- Table structure for table `patient_has_patientstatus`
--

CREATE TABLE `patient_has_patientstatus` (
  `nr` int(11) NOT NULL,
  `patient.id` int(11) NOT NULL,
  `patientstatus.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `patient_needs_labtest`
--

CREATE TABLE `patient_needs_labtest` (
  `nr` int(11) NOT NULL,
  `patient.id` int(11) NOT NULL,
  `labtest.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `patient_needs_medicine`
--

CREATE TABLE `patient_needs_medicine` (
  `nr` int(11) NOT NULL,
  `patient.id` int(11) NOT NULL,
  `medicine.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `critical_staff` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `room`
--

CREATE TABLE `room` (
  `number` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `floor` int(11) NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `storage_room` tinyint(1) NOT NULL,
  `isolation_room` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `student`
--

CREATE TABLE `student` (
  `id` int(11) NOT NULL,
  `fName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `lName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `dob` date NOT NULL,
  `intern` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `student`
--

INSERT INTO `student` (`id`, `fName`, `lName`, `dob`, `intern`) VALUES
(1, 'Francisco', 'Franco', '1904-05-12', 0),
(2, 'Mao', 'Zedong', '1892-09-23', 0),
(3, 'Pol', 'Pot', '1925-02-26', 0),
(4, 'Antonio', 'Alazar', '1901-12-08', 1);

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

--
-- Table structure for table `student_studies_in_department`
--

CREATE TABLE `student_studies_in_department` (
  `nr` int(11) NOT NULL,
  `student.id` int(11) NOT NULL,
  `department.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `supportstaff`
--

CREATE TABLE `supportstaff` (
  `id` int(11) NOT NULL,
  `fName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `lName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `phone_ext` int(11) NOT NULL,
  `job_title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `supportstaff`
--

INSERT INTO `supportstaff` (`id`, `fName`, `lName`, `phone_ext`, `job_title`) VALUES
(1, 'Henry', 'Ford', 1234, 'Lab Director'),
(2, 'Harrison', 'Ford', 2222, 'Medical Logistics Apprentice'),
(3, 'Jane', 'Fonda', 2132, 'Medical Logistics Journeyman'),
(4, 'Huddie', 'Leadbetter', 5324, 'Custodian');

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

--
-- Table structure for table `supportstaff_works_in_department`
--

CREATE TABLE `supportstaff_works_in_department` (
  `nr` int(11) NOT NULL,
  `supportStaff.id` int(11) NOT NULL,
  `department.id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `supportstaff_works_in_department`
--

INSERT INTO `supportstaff_works_in_department` (`nr`, `supportStaff.id`, `department.id`) VALUES
(1, 1, 1),
(2, 2, 3),
(3, 3, 3);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `appointment`
--
ALTER TABLE `appointment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `department`
--
ALTER TABLE `department`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `er`
--
ALTER TABLE `er`
  ADD PRIMARY KEY (`roomid`);

--
-- Indexes for table `erstaff`
--
ALTER TABLE `erstaff`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `erstaff_is_oncall`
--
ALTER TABLE `erstaff_is_oncall`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `erstaff_works_in_er`
--
ALTER TABLE `erstaff_works_in_er`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `er_has_room`
--
ALTER TABLE `er_has_room`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `insurance`
--
ALTER TABLE `insurance`
  ADD PRIMARY KEY (`market_id`);

--
-- Indexes for table `labstaff`
--
ALTER TABLE `labstaff`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `labstaff_has_role`
--
ALTER TABLE `labstaff_has_role`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `labstaff_runs_labtest`
--
ALTER TABLE `labstaff_runs_labtest`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `labtest`
--
ALTER TABLE `labtest`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `medicine`
--
ALTER TABLE `medicine`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oncall`
--
ALTER TABLE `oncall`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `patient`
--
ALTER TABLE `patient`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `patientstatus`
--
ALTER TABLE `patientstatus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `patient_has_appointment`
--
ALTER TABLE `patient_has_appointment`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `patient_has_insurance`
--
ALTER TABLE `patient_has_insurance`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `patient_has_patientstatus`
--
ALTER TABLE `patient_has_patientstatus`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `patient_needs_labtest`
--
ALTER TABLE `patient_needs_labtest`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `patient_needs_medicine`
--
ALTER TABLE `patient_needs_medicine`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `role`
--
ALTER TABLE `role`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `room`
--
ALTER TABLE `room`
  ADD PRIMARY KEY (`number`);

--
-- Indexes for table `student`
--
ALTER TABLE `student`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student_studies_in_department`
--
ALTER TABLE `student_studies_in_department`
  ADD PRIMARY KEY (`nr`);

--
-- Indexes for table `supportstaff`
--
ALTER TABLE `supportstaff`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `supportstaff_works_in_department`
--
ALTER TABLE `supportstaff_works_in_department`
  ADD PRIMARY KEY (`nr`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `appointment`
--
ALTER TABLE `appointment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `department`
--
ALTER TABLE `department`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `er`
--
ALTER TABLE `er`
  MODIFY `roomid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `erstaff`
--
ALTER TABLE `erstaff`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `erstaff_is_oncall`
--
ALTER TABLE `erstaff_is_oncall`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `erstaff_works_in_er`
--
ALTER TABLE `erstaff_works_in_er`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `er_has_room`
--
ALTER TABLE `er_has_room`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `labstaff`
--
ALTER TABLE `labstaff`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `labstaff_has_role`
--
ALTER TABLE `labstaff_has_role`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `labstaff_runs_labtest`
--
ALTER TABLE `labstaff_runs_labtest`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `medicine`
--
ALTER TABLE `medicine`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `oncall`
--
ALTER TABLE `oncall`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `patient`
--
ALTER TABLE `patient`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `patientstatus`
--
ALTER TABLE `patientstatus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `patient_has_appointment`
--
ALTER TABLE `patient_has_appointment`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `patient_has_insurance`
--
ALTER TABLE `patient_has_insurance`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `patient_has_patientstatus`
--
ALTER TABLE `patient_has_patientstatus`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `patient_needs_labtest`
--
ALTER TABLE `patient_needs_labtest`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `patient_needs_medicine`
--
ALTER TABLE `patient_needs_medicine`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `role`
--
ALTER TABLE `role`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `student`
--
ALTER TABLE `student`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `student_studies_in_department`
--
ALTER TABLE `student_studies_in_department`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supportstaff`
--
ALTER TABLE `supportstaff`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `supportstaff_works_in_department`
--
ALTER TABLE `supportstaff_works_in_department`
  MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

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