UML skeemide joonistamine

Arvutihooldus

SQL Skeem & kood

CREATE TABLE `Employees` (
  `id` int,
  `nimi` varchar(25),
  `perekonnanimi` varchar(25),
  `isikukood` char(11),
  `role` varchar(11),
  PRIMARY KEY (`id`)
);

CREATE TABLE `Clients` (
  `id` int,
  `nimi` varchar(25),
  `perekonnanimi` varchar(25),
  `isikukood` char(11),
  PRIMARY KEY (`id`)
);

CREATE TABLE `Contracts` (
  `id` int,
  `employee` int,
  `client` int,
  `description` varchar(255),
  `assigned` datetime,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`employee`) REFERENCES `Employees`(`id`),
  FOREIGN KEY (`client`) REFERENCES `Clients`(`id`)
);

CREATE TABLE `Units` (
  `id` int,
  `nimetus` varchar(25),
  `contractId` int,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`contractId`) REFERENCES `Contracts`(`id`)
);