Проектирование базы данных

Вернадского, д. 132, кв. 243', 'b_user'),(3, 'Хлебникова', 'Тамара', 'Евгеньевна', 3, '1998-12-17', '89055682247', '5200235847', 'ул. Вертолетчиков, д. 12,кв. 17', 'b_user'),(4, 'Пискунова', 'Любовь', 'Анатольевна', 5, '2000-05-12', '89035684417', '3400124785', 'ул. Звенигородская, д. 16. кв. 32', 'retail_user'),(5, 'Кузнецова', 'Анна', 'Аркадьевна', 4, '1995-04-30', '89275864127', '5400257335', 'ул. Лобачевского, д. 63, кв. 112', 'ok_user'),(6, 'Орлов', 'Антон', 'Васильевич', 5, '1995-09-28', '89275864130', '5400254335', 'ул. Толстого, д. 13, кв. 12', 'retail_user'),(7, 'Коврова', 'Анна', 'Петровна', 6, '1975-02-07', '89275864154', '5400221235', 'ул. Достоевского, д. 3, кв. 11', 'retail_user'),(8, 'Антонов', 'Сергей', 'Павлович', 8, '1983-10-11', '89375457154', '5400321233', 'ул. Светлая, д. 6, кв. 22', 'retail_user'),(9, 'Козлова', 'Яна', 'Владимировна', 5, '1993-11-20', '89056574521', '5400562335', 'ул. Академическая, д. 57, кв. 5', 'retail_user');REPLACE INTO `guaranteemeasure` (`idGuaranteeMeasure`, `GuaranteeMeasureName`) VALUES(1, 'день'),(2, 'месяц'),(3, 'год');REPLACE INTO `invoices` (`idInvoice`, `InvoicesDate`, `InvoicesNumber`, `idProvider`) VALUES(1, '2023-01-23', 20230101, 3),(2, '2023-01-23', 20230102, 2),(3, '2023-02-10', 20230203, 2),(4, '2023-02-10', 20230203, 1),(5, '2023-03-15', 20230304, 3),(6, '2023-04-10', 20230305, 4),(7, '2023-04-20', 20230406, 3),(8, '2023-05-12', 20230507, 1);REPLACE INTO `manufacturers` (`idManufacturer`, `NameManufacturer`) VALUES(1, 'Без бренда'),(2, 'ООО НПЦ ПО ГУСЕВОДСТВУ И УТКОВОДСТВУ "СЕРАФИМОВСКАЯ ПУШИНКА"'),(3, 'MEIWA'),(4, 'LEIFHEIT'),(5, 'НИКА'),(6, 'PASABAHCE'),(7, 'FINISH'),(8, 'РЫЖИЙ КОТ'),(9, 'CLEANELLY'),(10, 'TRAMONTINA');REPLACE INTO `measures` (`idMeasure`, `MeasuresName`, `ShortName`) VALUES(1, 'штука', 'шт.'),(2, 'килограмм', 'кг'),(3, 'литр', 'л'),(4, 'Бобина', 'боб'),(5, 'Лист', 'л.'),(6, 'Сто листов', '100 л.'),(7, 'Дюжина (12 шт.)', 'дюжина'),(8, 'Изделие', 'изд'),(9, 'Упаковка', 'упак'),(10, 'Рулон', 'рул'),(11, 'Десять пар', '10 пар'),(12, 'Набор', 'набор'),(13, 'Пара (2 шт.)', 'пар'),(14, 'Сто упаковок', '100 упак'),(15, 'Сто штук', '100 шт'),(16, 'Тысяча штук', 'тыс. шт');REPLACE INTO `posts` (`idPost`, `NamePost`, `Salary`) VALUES(1, 'Директор магазина', 80000.00),(2, 'Главный бухгалтер', 60000.00),(3, 'Бухгалтер', 32000.00),(4, 'Менеджер по кадрам', 40000.00),(5, 'Продавец-консультант', 35000.00),(6, 'Продавец-кассир', 30000.00),(7, 'Товаровед', 30000.00),(8, 'Менеджер по закупкам', 45000.00);REPLACE INTO `procurements` (`idProcurement`, `idInvoice`, `idProduct`, `CountProduct`, `PurchasePrice`) VALUES(1, 1, 4, 65.000, 12000.00),(2, 1, 5, 90.000, 221.70),(3, 1, 6, 5.000, 595.00),(4, 2, 3, 500.000, 140.00),(5, 2, 11, 300.000, 63.00),(6, 3, 10, 90.000, 8950.00),(7, 3, 8, 10.000, 123.00),(8, 4, 7, 20.000, 1737.00),(9, 4, 17, 50.000, 494.50),(10, 4, 9, 40.000, 1738.50),(11, 5, 14, 50.000, 1738.50),(12, 5, 15, 55.000, 1192.50),(13, 5, 16, 40.000, 1342.50),(14, 6, 1, 10.000, 2785.50),(15, 6, 2, 70.000, 147.60),(16, 6, 19, 10.000, 3700.00),(17, 6, 13, 20.000, 670.00),(18, 6, 18, 60.000, 562.50),(19, 7, 9, 50.000, 1729.50),(20, 7, 20, 50.000, 1254.50),(21, 8, 12, 10.000, 1654.50),(22, 8, 8, 50.000, 147.00);REPLACE INTO `products` (`idProduct`, `NameProduct`, `IdCategory`, `idManufacturer`, `idMeasure`, `SellingPrice`, `GuaranteePeriod`, `idGuaranteeMeasure`) VALUES(1, 'халат CLEANELLY махр.Maschioмуж.р-р 48 синий, арт.ХЦ901-2755м41р48', 1, 9, 1, 3714.00, 12, 2),(2, 'ваза PASABAHCE Flora 26,5смцилиндрстекло', 2, 6, 1, 199.00, 12, 2),(3, 'игрушкаспиральРадуга d7см', 37, 1, 1, 185.00, 6, 2),(4, 'наборножей TRAMONTINA Cutlery Century 6 предметовнерж.сталь', 3, 10, 1, 15990.00, 3, 3),(5, 'Овощечистка TRAMONTINA Century нержсталь', 3, 10, 1, 299.00, 3, 3),(6, 'Толкушка TRAMONTINA Polywoodнерж.сталь', 3, 10, 1, 779.00, 2, 3),(7, 'таблеткид/ПММ FINISH POWER All in 1 Max 100шт.', 20, 7, 15, 2316.00, 2, 3),(8, 'коробка РЫЖИЙ КОТ, 33х20х13 см, 8,5 л, для хранения обуви, пластик, с крышкой', 21, 8, 1, 199.00, 12, 2),(9, 'скатерть ПВХ Meiwa бежевая FPLUS-PLAIN SARASA круглая D 178 см, арт.5137', 31, 3, 1, 2318.00, 6, 2),(10, 'набор для уборки LEIFHEIT CleanTwistSystem: ведро 20л с отжимом+поломой складной 140см', 33, 4, 12, 10600.00, 2, 3),(11, 'лента п/э 40мм 2,7м сетка золотая с блестками в асс-те', 42, 1, 1, 99.00, 6, 2),(12, 'доска гладильная НИКА-3М 122х34 см', 34, 5, 1, 2206.00, 2, 3),(13, 'короб складной, 300х200х170 мм, коричневый, бамбук', 35, 1, 1, 929.00, 6, 2),(14, 'Подушка СЕРАФ. ПУШИНКА 50х68см пух 90% перо 10%, арт.1080470', 9, 2, 1, 2349.00, 6, 2),(15, 'Подушка СЕРАФ. ПУШИНКА 50х68см пух 50% перо 50%, арт.1080540', 9, 2, 1, 1590.00, 6, 2),(16, 'Подушка СЕРАФ. ПУШИНКА 68х68см пух 40% перо 60%, арт.1080580', 9, 2, 1, 1790.00, 6, 2),(17, 'Ополаскиватель для ПММ FINISH, 800 мл', 20, 7, 1, 663.00, 2, 3),(18, 'Корзина складная BLB-09-1, 380х280х160 мм, натуральная, бамбук, лен', 35, 8, 1, 743.00, 6, 2),(19, 'Простыня CLEANELLY Регата 200х180см махровая с велюром пестроткань', 9, 9, 1, 4669.00, 12, 2),(20, 'Скатерть ПВХ MEIWA FPLUS-PlainSarasa овал 132х178см бежевая, арт.5783', 31, 3, 1, 1679.00, 6, 2);REPLACE INTO `providers` (`idProvider`, `NameProvider`, `INN`, `Phone`, `Manager`) VALUES(1, 'ООО "Юпитер"', '7704407589', '84953200055', 'Васильченко А.А.'),(2, 'ООО "ПластикГранд"', '2304507589', '89374324242', 'Карпов П.П.'),(3, 'ИП Архипов Ф.Г.', '772116561411', '89196321705', 'Агапова Н.И.'),(4, 'ИП Тарасов А.В.', '616608929424', '89175214075', 'Маркина Ю.В.');REPLACE INTO `realizations` (`idRealization`, `idCheck`, `idProduct`, `RealizationsCount`, `Sale`, `RealizationsSum`) VALUES(1, 1, 14, 1.000, 2.50, 2290.00),(2, 2, 6, 2.000, 3.25, 1507.00),(3, 2, 8, 3.000, 4.50, 570.00),(4, 3, 20, 2.000, 1.75, 3299.00),(5, 4, 12, 2.000, 3.25, 4268.00),(6, 5, 14, 1.000, 5.50, 2219.00),(7, 6, 3, 2.000, 7.00, 344.00),(8, 7, 20, 2.000, 4.50, 3206.00),(9, 8, 2, 2.000, 6.25, 373.00),(10, 9, 20, 2.000, 6.25, 3148.00),(11, 10, 12, 2.000, 6.50, 4125.00),(12, 10, 3, 1.000, 1.00, 183.00),(13, 10, 20, 2.000, 0.25, 3349.00),(14, 11, 8, 1.000, 6.25, 186.00),(15, 12, 3, 1.000, 1.50, 182.00),(16, 13, 14, 1.000, 2.00, 2302.00),(17, 14, 20, 1.000, 6.50, 1569.00),(18, 15, 19, 3.000, 3.00, 13586.00),(19, 16, 2, 2.000, 4.50, 380.00),(20, 17, 19, 2.000, 4.50, 8917.00),(21, 18, 3, 1.000, 3.00, 179.00),(22, 19, 14, 3.000, 3.00, 6835.00),(23, 20, 16, 1.000, 2.00, 1754.00),(24, 21, 15, 1.000, 3.75, 1530.00),(25, 22, 16, 2.000, 2.50, 3490.00),(26, 23, 14, 2.000, 2.75, 4568.00),(27, 24, 8, 3.000, 4.75, 568.00),(28, 25, 9, 2.000, 5.75, 4369.00),(29, 26, 17, 1.000, 5.25, 628.00),(30, 27, 3, 3.000, 5.00, 527.00),(31, 27, 12, 2.000, 6.75, 4114.00),(32, 27, 14, 1.000, 1.00, 2325.00),(33, 28, 19, 3.000, 3.75, 13481.00),(34, 29, 2, 3.000, 2.25, 583.00),(35, 30, 16, 1.000, 7.00, 1664.00),(36, 31, 20, 1.000, 6.50, 1569.00),(37, 32, 6, 3.000, 6.75, 2179.00),(38, 33, 18, 1.000, 0.25, 741.00),(39, 34, 10, 2.000, 6.25, 19875.00),(40, 35, 5, 2.000, 2.00, 586.00),(41, 36, 16, 3.000, 2.25, 5249.00),(42, 37, 15, 3.000, 3.00, 4626.00),(43, 38, 10, 3.000, 3.50, 30687.00),(44, 39, 17, 1.000, 3.00, 643.00),(45, 40, 2, 3.000, 0.75, 592.00),(46, 41, 17, 3.000, 3.75, 1914.00),(47, 42, 10, 1.000, 4.75, 10096.00),(48, 43, 16, 3.000, 0.25, 5356.00),(49, 44, 2, 3.000, 2.00, 585.00),(50, 45, 10, 1.000, 1.00, 10494.00),(51, 46, 10, 1.000, 3.25, 10255.00),(52, 47, 20, 3.000, 0.25, 5024.00),(53, 48, 8, 1.000, 1.00, 197.00),(54, 49, 16, 2.000, 3.00, 3472.00),(55, 50, 17, 3.000, 3.75, 1914.00),(56, 51, 6, 2.000, 3.25, 1507.00),(57, 52, 11, 3.000, 3.50, 286.00),(58, 53, 12, 2.000, 2.25, 4312.00),(59, 54, 16, 3.000, 5.75, 5061.00),(60, 55, 16, 2.000, 1.75, 3517.00),(61, 56, 11, 2.000, 2.00, 194.00),(62, 57, 5, 1.000, 6.50, 279.00),(63, 58, 3, 3.000, 3.25, 536.00),(64, 59, 16, 2.000, 4.00, 3436.00),(65, 60, 9, 3.000, 6.25, 6519.00),(66, 61, 16, 1.000, 2.00, 1754.00),(67, 62, 2, 2.000, 2.25, 389.00),(68, 63, 17, 2.000, 5.50, 1253.00),(69, 64, 5, 2.000, 1.25, 590.00),(70, 65, 12, 2.000, 3.50, 4257.00),(71, 66, 8, 2.000, 2.75, 387.00),(72, 67, 10, 2.000, 5.00, 20140.00),(73, 68, 4, 2.000, 6.25, 29981.00),(74, 69, 2, 3.000, 0.00, 597.00),(75, 70, 6, 3.000, 3.25, 2261.00),(76, 71, 9, 2.000, 4.50, 4427.00),(77, 72, 10, 1.000, 1.00, 10494.00),(78, 73, 17, 1.000, 2.25, 648.00),(79, 73, 6, 2.000, 5.00, 1480.00),(80, 73, 1, 1.000, 4.25, 3556.00),(81, 74, 20, 1.000, 6.25, 1574.00),(82, 75, 9, 2.000, 3.25, 4485.00),(83, 76, 9, 2.000, 0.75, 4601.00),(84, 77, 7, 1.000, 5.00, 2200.00),(85, 78, 10, 1.000, 6.75, 9884.00),(86, 79, 4, 1.000, 6.50, 14950.00),(87, 80, 3, 3.000, 3.50, 535.00),(88, 81, 3, 2.000, 3.00, 358.00),(89, 82, 2, 3.000, 3.75, 574.00),(90, 83, 15, 2.000, 1.00, 3148.00),(91, 84, 7, 1.000, 2.50, 2258.00),(92, 85, 17, 3.000, 3.25, 1924.00),(93, 86, 6, 2.000, 6.75, 1452.00),(94, 87, 18, 3.000, 2.50, 2173.00),(95, 87, 20, 1.000, 5.75, 1582.00),(96, 88, 17, 1.000, 4.00, 636.00),(97, 89, 12, 2.000, 6.00, 4147.00),(98, 90, 2, 3.000, 0.25, 595.00),(99, 91, 16, 3.000, 6.00, 5047.00),(100, 92, 14, 2.000, 6.50, 4392.00),(101, 93, 17, 2.000, 2.25, 1296.00),(102, 94, 16, 1.000, 6.75, 1669.00),(103, 95, 12, 3.000, 6.75, 6171.00),(104, 96, 17, 1.000, 6.50, 619.00),(105, 96, 4, 1.000, 3.00, 15510.00),(106, 97, 20, 2.000, 2.00, 3290.00),(107, 98, 10, 1.000, 1.00, 10494.00),(108, 99, 10, 1.000, 2.75, 10308.00),(109, 100, 3, 1.000, 4.75, 176.00),(110, 101, 20, 2.000, 6.25, 3148.00),(111, 102, 3, 1.000, 4.75, 176.00),(112, 103, 20, 2.000, 0.50, 3341.00),(113, 104, 9, 1.000, 1.50, 2283.00),(114, 105, 13, 2.000, 4.50, 1774.00),(115, 106, 4, 1.000, 6.00, 15030.00),(116, 107, 14, 1.000, 2.50, 2290.00),(117, 108, 8, 2.000, 1.50, 392.00),(118, 108, 2, 2.000, 3.00, 386.00),(119, 108, 17, 2.000, 2.00, 1299.00),(120, 109, 6, 1.000, 2.50, 759.00),(121, 110, 8, 1.000, 4.00, 191.00),(122, 111, 9, 2.000, 6.50, 4334.00),(123, 112, 12, 2.000, 6.00, 4147.00),(124, 113, 5, 2.000, 3.00, 580.00),(125, 114, 15, 3.000, 4.25, 4567.00);REPLACE INTO `store` (`idStorePos`, `idProduct`, `StoreCount`, `ReleaseDate`) VALUES(1, 5, 86.000, '2022-07-23'),(2, 18, 30.000, '2022-08-10'),(3, 2, 30.000, '2022-10-23'),(4, 4, 60.000, '2022-10-30'),(5, 16, 30.000, '2022-12-10'),(6, 14, 20.000, '2023-01-15'),(7, 15, 50.000, '2022-01-20'),(8, 10, 83.000, '2023-01-10'),(9, 3, 400.000, '2022-12-17'),(10, 2, 70.000, '2023-03-14'),(11, 8, 50.000, '2023-04-10'),(12, 12, 10.000, '2023-04-20'),(13, 17, 40.000, '2022-12-20'),(14, 9, 45.000, '2023-02-20'),(15, 20, 43.000, '2023-02-20'),(16, 1, 10.000, '2023-01-15');CREATE VIEW CurrSummRealization AS SELECT sum(RealizationsSum ) AS SumOnCurrDate from ListRealizationOnCurrDate ;CREATE VIEW `counrealizeoncategoriescurrmonth` AS select `productslist`.`NameCategory` AS `NameCategory`,sum(`listrealizationoncheck`.`RealizationsCount`) AS `RealizationCount` from (`productslist` join `listrealizationoncheck`) where ((`productslist`.`NameProduct` = `listrealizationoncheck`.`NameProduct`) and (month(`listrealizationoncheck`.`RealizationDate`) = month(curdate()))) group by `productslist`.`NameCategory`;CREATE VIEW `currsummrealization` AS select sum(`listrealizationoncurrdate`.`RealizationsSum`) AS `SumOnCurrDate` from `listrealizationoncurrdate`;CREATE VIEW `employerslist` AS select `employers`.`idEmployer` AS `idEmployer`,`employers`.`Surname` AS `Surname`,`employers`.`Firstname` AS `Firstname`,`employers`.`Middlename` AS `Middlename`,`employers`.`Birthday` AS `Birthday`,`employers`.`Passport` AS `Passport`,`employers`.`Phone` AS `Phone`,`employers`.`Address` AS `Address`,`posts`.`NamePost` AS `Post`,`posts`.`Salary` AS `Salary` from (`employers` join `posts`) where (`employers`.`idPost` = `posts`.`idPost`);CREATE VIEW `listcategories` AS select `categories`.`idCategory` AS `idCategory`,`categories`.`NameCategory` AS `NameCategory` from `categories`;CREATE VIEW `listmanufacturers` AS select `manufacturers`.`idManufacturer` AS `idManufacturer`,`manufacturers`.`NameManufacturer` AS `NameManufacturer` from `manufacturers`;CREATE VIEW `listmeasures` AS select `measures`.`idMeasure` AS `idMeasure`,`measures`.`MeasuresName` AS `MeasuresName`,`measures`.`ShortName` AS `ShortName` from `measures`;CREATE VIEW `listposts` AS select `posts`.`idPost` AS `idPost`,`posts`.`NamePost` AS `NamePost`,`posts`.`Salary` AS `Salary` from `posts`;CREATE VIEW `listprocurementoncurrdate` AS select `listprocurementoninvoice`.`idInvoice` AS `idInvoice`,`listprocurementoninvoice`.`InvoicesDate` AS `InvoicesDate`,`listprocurementoninvoice`.`InvoicesNumber` AS `InvoicesNumber`,`listprocurementoninvoice`.`NameProduct` AS `NameProduct`,`listprocurementoninvoice`.`NameManufacturer` AS `NameManufacturer`,`listprocurementoninvoice`.`NameCategory` AS `NameCategory`,`listprocurementoninvoice`.`CountProduct` AS `CountProduct`,`listprocurementoninvoice`.`PurchasePrice` AS `PurchasePrice` from `listprocurementoninvoice` where (`listprocurementoninvoice`.`InvoicesDate` = curdate());CREATE VIEW `listprocurementoncurrmonth` AS select `listprocurementoninvoice`.`idInvoice` AS `idInvoice`,`listprocurementoninvoice`.`InvoicesDate` AS `InvoicesDate`,`listprocurementoninvoice`.`InvoicesNumber` AS `InvoicesNumber`,`listprocurementoninvoice`.`NameProduct` AS `NameProduct`,`listprocurementoninvoice`.`NameManufacturer` AS `NameManufacturer`,`listprocurementoninvoice`.`NameCategory` AS `NameCategory`,`listprocurementoninvoice`.`CountProduct` AS `CountProduct`,`listprocurementoninvoice`.`PurchasePrice` AS `PurchasePrice` from `listprocurementoninvoice` where (month(`listprocurementoninvoice`.`InvoicesDate`) = month(curdate()));CREATE VIEW `listprocurementoninvoice` AS select `procurementlist`.`idInvoice` AS `idInvoice`,`invoices`.`InvoicesDate` AS `InvoicesDate`,`invoices`.`InvoicesNumber` AS `InvoicesNumber`,`procurementlist`.`NameProduct` AS `NameProduct`,`procurementlist`.`NameManufacturer` AS `NameManufacturer`,`procurementlist`.`NameCategory` AS `NameCategory`,`procurementlist`.`CountProduct` AS `CountProduct`,`procurementlist`.`PurchasePrice` AS `PurchasePrice` from (`procurementlist` join `invoices`) where (`procurementlist`.`idInvoice` = `invoices`.`idInvoice`);CREATE VIEW `listproviders` AS select `providers`.`idProvider` AS `idProvider`,`providers`.`NameProvider` AS `NameProvider`,`providers`.`INN` AS `INN`,`providers`.`Phone` AS `Phone`,`providers`.`Manager` AS `Manager` from `providers`;CREATE VIEW `listrealizationoncheck` AS select `realizationlist`.`idCheck` AS `idCheck`,`checks`.`RealizationDate` AS `RealizationDate`,`checks`.`CheckNumber` AS `CheckNumber`,`realizationlist`.`NameProduct` AS `NameProduct`,`realizationlist`.`SellingPrice` AS `SellingPrice`,`realizationlist`.`RealizationsCount` AS `RealizationsCount`,`realizationlist`.`Sale` AS `Sale`,`realizationlist`.`RealizationsSum` AS `RealizationsSum` from (`realizationlist` join `checks`) where (`realizationlist`.`idCheck` = `checks`.`idCheck`);CREATE VIEW `listrealizationoncurrdate` AS select `listrealizationoncheck`.`idCheck` AS `idCheck`,`listrealizationoncheck`.`RealizationDate` AS `RealizationDate`,`listrealizationoncheck`.`CheckNumber` AS `CheckNumber`,`listrealizationoncheck`.`NameProduct` AS `NameProduct`,`listrealizationoncheck`.`SellingPrice` AS `SellingPrice`,`listrealizationoncheck`.`RealizationsCount` AS `RealizationsCount`,`listrealizationoncheck`.`Sale` AS `Sale`,`listrealizationoncheck`.`RealizationsSum` AS `RealizationsSum` from `listrealizationoncheck` where (`listrealizationoncheck`.`RealizationDate` = curdate());CREATE VIEW `liststore` AS select `productslist`.`NameProduct` AS `NameProduct`,`productslist`.`NameManufacturer` AS `NameManufacturer`,`productslist`.`NameCategory` AS `NameCategory`,`productslist`.`SellingPrice` AS `SellingPrice`,`productslist`.`ShortName` AS `ShortName`,`productslist`.`GuaranteePeriod` AS `GuaranteePeriod`,`productslist`.`GuaranteeMeasureName` AS `GuaranteeMeasureName`,`store`.`StoreCount` AS `StoreCount`,`store`.`ReleaseDate` AS `ReleaseDate` from (`store` join `productslist`) where (`store`.`idProduct` = `productslist`.`idProduct`);CREATE VIEW `procurementlist` AS select `procurements`.`idInvoice` AS `idInvoice`,`productslist`.`NameProduct` AS `NameProduct`,`productslist`.`NameManufacturer` AS `NameManufacturer`,`productslist`.`NameCategory` AS `NameCategory`,`procurements`.`CountProduct` AS `CountProduct`,`procurements`.`PurchasePrice` AS `PurchasePrice` from (`procurements` join `productslist`) where (`procurements`.`idProduct` = `productslist`.`idProduct`);CREATE VIEW `productslist` AS select `products`.`idProduct` AS `idProduct`,`products`.`NameProduct` AS `NameProduct`,`manufacturers`.`NameManufacturer` AS `NameManufacturer`,`categories`.`NameCategory` AS `NameCategory`,`products`.`SellingPrice` AS `SellingPrice`,`measures`.`ShortName` AS `ShortName`,`products`.`GuaranteePeriod` AS `GuaranteePeriod`,`guaranteemeasure`.`GuaranteeMeasureName` AS `GuaranteeMeasureName` from ((((`products` join `categories`) join `measures`) join `guaranteemeasure`) join `manufacturers`) where ((`products`.`IdCategory` = `categories`.`idCategory`) and (`products`.`idMeasure` = `measures`.`idMeasure`) and (`products`.`idGuaranteeMeasure` = `guaranteemeasure`.`idGuaranteeMeasure`) and (`products`.`idManufacturer` = `manufacturers`.`idManufacturer`));CREATE VIEW `realizationlist` AS select `realizations`.`idCheck` AS `idCheck`,`products`.`NameProduct` AS `NameProduct`,`products`.`SellingPrice` AS `SellingPrice`,`realizations`.`RealizationsCount` AS `RealizationsCount`,`realizations`.`Sale` AS `Sale`,`realizations`.`RealizationsSum` AS `RealizationsSum` from (`realizations` join `products`) where (`realizations`.`idProduct` = `products`.`idProduct`) order by `realizations`.`idCheck`;