-- phpMyAdmin SQL Dump
-- version 4.9.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: May 23, 2021 at 01:13 PM
-- Server version: 5.7.26
-- PHP Version: 7.4.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `ta_system`
--

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

--
-- Table structure for table `accidentInformatiom`
--

CREATE TABLE `accidentInformatiom` (
  `id` int(11) NOT NULL,
  `cardType` int(1) NOT NULL,
  `uvdNumber` int(6) NOT NULL,
  `go-rovdNumber` int(6) NOT NULL,
  `addCardNumber` int(11) NOT NULL,
  `accidentDate` date NOT NULL,
  `accidentTime` time NOT NULL,
  `deadNumber` int(2) NOT NULL,
  `injuredNumber` int(2) NOT NULL,
  `roadAccidentCategory` int(1) NOT NULL,
  `roadAccidentType` int(1) NOT NULL,
  `totalMaterialDamage` int(7) NOT NULL,
  `accidentArea` varchar(45) NOT NULL,
  `locality` varchar(60) NOT NULL,
  `street` varchar(60) NOT NULL,
  `houseNumber` varchar(20) NOT NULL,
  `blockNumber` int(3) NOT NULL,
  `intersectedStreet` varchar(60) NOT NULL,
  `highwayValue` int(1) NOT NULL,
  `highwayName` varchar(45) NOT NULL,
  `mileageAndMeters` varchar(15) NOT NULL,
  `roadBeloning` int(1) NOT NULL,
  `roadOrganization` varchar(30) NOT NULL,
  `typeOfCoating` int(1) NOT NULL,
  `roadwayState` int(2) NOT NULL,
  `illumination` int(1) NOT NULL,
  `planAndProfileElements` int(1) NOT NULL,
  `weatherCondition` int(1) NOT NULL,
  `trafficLanesNumber` int(1) NOT NULL,
  `roadWidth` float NOT NULL,
  `shoulderWidth` float NOT NULL,
  `roadsideWidth` float NOT NULL,
  `divingStripWidth` float NOT NULL,
  `sidewalkWidth` float NOT NULL,
  `unsatisfactoryRoadConditions` varchar(50) NOT NULL,
  `otherRoadElements` varchar(50) NOT NULL,
  `schemaFileName` varchar(30) NOT NULL,
  `employeeID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `accidentInformatiom`
--

INSERT INTO `accidentInformatiom` (`id`, `cardType`, `uvdNumber`, `go-rovdNumber`, `addCardNumber`, `accidentDate`, `accidentTime`, `deadNumber`, `injuredNumber`, `roadAccidentCategory`, `roadAccidentType`, `totalMaterialDamage`, `accidentArea`, `locality`, `street`, `houseNumber`, `blockNumber`, `intersectedStreet`, `highwayValue`, `highwayName`, `mileageAndMeters`, `roadBeloning`, `roadOrganization`, `typeOfCoating`, `roadwayState`, `illumination`, `planAndProfileElements`, `weatherCondition`, `trafficLanesNumber`, `roadWidth`, `shoulderWidth`, `roadsideWidth`, `divingStripWidth`, `sidewalkWidth`, `unsatisfactoryRoadConditions`, `otherRoadElements`, `schemaFileName`, `employeeID`) VALUES
(1, 2, 4353, 543, 444, '2021-05-14', '13:48:00', 5, 4, 2, 1, 5, '5f', 'retr', '45', '5', 55, '5', 2, '555', '5f', 3, '555', 2, 3, 2, 4, 3, 4, 4, 0, 664, 432, 423, '7,5', '5,12', 'fdg,sadasd.jpg', 1);

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `name`) VALUES
(1, 'ОГАИ Фрунзенского РУВД');

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

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `id` int(11) NOT NULL,
  `firstName` varchar(45) NOT NULL,
  `lastName` varchar(45) NOT NULL,
  `patronymic` varchar(45) NOT NULL,
  `login` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `departmentID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`id`, `firstName`, `lastName`, `patronymic`, `login`, `password`, `departmentID`) VALUES
(1, 'Петров', 'Владимир', 'Андреевич', 'petrov.v', '3e66f7aaad4294225b5d14e513278d3a', 1);

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

--
-- Table structure for table `participantsGeneralInformation`
--

CREATE TABLE `participantsGeneralInformation` (
  `id` int(11) NOT NULL,
  `vehicleSerialNumber` int(2) NOT NULL,
  `movementMemberNumber` int(2) NOT NULL,
  `memberCategory` int(1) NOT NULL,
  `beloningToVehicle` int(2) NOT NULL,
  `memberStatus` varchar(5) NOT NULL,
  `dateDeath` date NOT NULL,
  `severityOfInjuries` int(3) NOT NULL,
  `medicalInstitutiionWhereIsPlaced` varchar(45) NOT NULL,
  `trafficViolation` int(2) NOT NULL,
  `beltOrHemlet` int(1) NOT NULL,
  `measuresTaken` int(1) NOT NULL,
  `accidentInformatiomID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `partisipantsPersonalData`
--

CREATE TABLE `partisipantsPersonalData` (
  `id` int(11) NOT NULL,
  `passportNumber` varchar(45) NOT NULL,
  `firstName` varchar(45) NOT NULL,
  `lastName` varchar(45) NOT NULL,
  `patronymic` varchar(45) NOT NULL,
  `sex` varchar(1) NOT NULL,
  `birthday` date NOT NULL,
  `driversLisence` varchar(45) NOT NULL,
  `lisenceIssueDate` date NOT NULL,
  `drivingExperience` varchar(10) NOT NULL,
  `timeBehindTheWheel` varchar(10) NOT NULL,
  `state` varchar(45) NOT NULL,
  `area` varchar(60) NOT NULL,
  `district` varchar(45) NOT NULL,
  `locality` varchar(60) NOT NULL,
  `street` varchar(60) NOT NULL,
  `houseNumber` int(3) NOT NULL,
  `blockNumber` int(3) NOT NULL,
  `flatNumber` int(3) NOT NULL,
  `plaseOfWork` varchar(60) NOT NULL,
  `participantsGeneralInformationID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `vehicleData`
--

CREATE TABLE `vehicleData` (
  `id` int(11) NOT NULL,
  `brandName` varchar(45) NOT NULL,
  `vehicleType` int(3) NOT NULL,
  `licensePlate` varchar(45) NOT NULL,
  `engineNumber` varchar(45) NOT NULL,
  `bodyNumber` varchar(45) NOT NULL,
  `state` varchar(45) NOT NULL,
  `area` varchar(60) NOT NULL,
  `district` varchar(45) NOT NULL,
  `locality` varchar(60) NOT NULL,
  `street` varchar(60) NOT NULL,
  `houseNumber` int(3) NOT NULL,
  `blockNumber` int(3) NOT NULL,
  `flatNumber` int(3) NOT NULL,
  `nameOfCompanyOrMan` varchar(60) NOT NULL,
  `driveType` int(1) NOT NULL,
  `loadType` int(1) NOT NULL,
  `steeringLocation` varchar(6) NOT NULL,
  `color` int(2) NOT NULL,
  `trailerPresence` varchar(12) NOT NULL,
  `vehicleProblems` int(2) NOT NULL,
  `participantsGeneralInformationID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accidentInformatiom`
--
ALTER TABLE `accidentInformatiom`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employeeID` (`employeeID`);

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

--
-- Indexes for table `employee`
--
ALTER TABLE `employee`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`),
  ADD KEY `departmentID` (`departmentID`);

--
-- Indexes for table `participantsGeneralInformation`
--
ALTER TABLE `participantsGeneralInformation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `accidentInformatiomID` (`accidentInformatiomID`);

--
-- Indexes for table `partisipantsPersonalData`
--
ALTER TABLE `partisipantsPersonalData`
  ADD PRIMARY KEY (`id`),
  ADD KEY `participantsGeneralInformationID` (`participantsGeneralInformationID`);

--
-- Indexes for table `vehicleData`
--
ALTER TABLE `vehicleData`
  ADD PRIMARY KEY (`id`),
  ADD KEY `participantsGeneralInformationID` (`participantsGeneralInformationID`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `accidentInformatiom`
--
ALTER TABLE `accidentInformatiom`
  ADD CONSTRAINT `accidentinformatiom_ibfk_1` FOREIGN KEY (`employeeID`) REFERENCES `employee` (`id`);

--
-- Constraints for table `employee`
--
ALTER TABLE `employee`
  ADD CONSTRAINT `employee_ibfk_1` FOREIGN KEY (`departmentID`) REFERENCES `departments` (`id`);

--
-- Constraints for table `participantsGeneralInformation`
--
ALTER TABLE `participantsGeneralInformation`
  ADD CONSTRAINT `participantsgeneralinformation_ibfk_1` FOREIGN KEY (`accidentInformatiomID`) REFERENCES `accidentInformatiom` (`id`);

--
-- Constraints for table `partisipantsPersonalData`
--
ALTER TABLE `partisipantsPersonalData`
  ADD CONSTRAINT `partisipantspersonaldata_ibfk_1` FOREIGN KEY (`participantsGeneralInformationID`) REFERENCES `participantsGeneralInformation` (`id`);

--
-- Constraints for table `vehicleData`
--
ALTER TABLE `vehicleData`
  ADD CONSTRAINT `vehicledata_ibfk_1` FOREIGN KEY (`participantsGeneralInformationID`) REFERENCES `participantsGeneralInformation` (`id`);