# autodatabases/tecdoc_2q2023 architecture

> Architecture diagram of the GitHub repository autodatabases/tecdoc_2q2023, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-07). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/autodatabases/tecdoc_2q2023
- Repository: https://github.com/autodatabases/tecdoc_2q2023

## Overview

This repository describes the TECDOC 2Q 2023 automotive-parts database and supplies a set of SQL query examples. The main workflow represented here is a user looking up parts or vehicles through a query, with the database providing the catalog data. The README documents the database’s broad contents and the accompanying query collection, but no SQL excerpts were provided; query-to-database links therefore rely on that documentation, not inspected query implementations. The README also mentions a ready-to-run PHP site, but no PHP source appears in the tree.

Main entry points: [`Выбор информации об артикуле.sql`](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D0%B8%20%D0%BE%D0%B1%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B5.sql) (Article details), [`Выбор всех спецификации(критериев) для артикула.sql`](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%B2%D1%81%D0%B5%D1%85%20%D1%81%D0%BF%D0%B5%D1%86%D0%B8%D1%84%D0%B8%D0%BA%D0%B0%D1%86%D0%B8%D0%B8(%D0%BA%D1%80%D0%B8%D1%82%D0%B5%D1%80%D0%B8%D0%B5%D0%B2)%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0.sql) (Article specifications), [`Выбор критериев артикулов для авто.sql`](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BA%D1%80%D0%B8%D1%82%D0%B5%D1%80%D0%B8%D0%B5%D0%B2%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%BE%D0%B2%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D0%B2%D1%82%D0%BE.sql) (Vehicle criteria), [`Выбор применяемости артикула к пассажирским авто.sql`](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BF%D1%80%D0%B8%D0%BC%D0%B5%D0%BD%D1%8F%D0%B5%D0%BC%D0%BE%D1%81%D1%82%D0%B8%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0%20%D0%BA%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%B8%D0%BC%20%D0%B0%D0%B2%D1%82%D0%BE.sql) (Article fitment)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_parts["Parts queries"]
  node_article_info["Article details"]
  node_article_specs["Article specifications"]
  node_article_criteria["Vehicle criteria"]
  node_article_fitment["Article fitment"]
  node_article_accessories["Article accessories"]
  node_article_images["Article images"]
  node_article_parts["Article components"]
  node_article_crosses["Article cross-references"]
  node_part_equivalents["Part number equivalents"]
  node_part_group_list["Parts by group"]
  node_part_image_coords["Image part coordinates"]
end

subgraph group_vehicles["Vehicle queries"]
  node_passenger_specs["Vehicle specifications"]
  node_commercial_details["Commercial vehicle details"]
  node_passenger_details["Passenger vehicle details"]
  node_passenger_suppliers["Vehicle suppliers and groups"]
  node_passenger_makes["Vehicle manufacturers"]
  node_vehicle_kba["KBA lookup"]
  node_vehicle_nl["Netherlands plate lookup"]
  node_vehicle_fr["France plate lookup"]
  node_model_series["Vehicle model ranges"]
  node_series_models["Models in range"]
end

subgraph group_catalog["Catalog queries"]
  node_category_tree["Vehicle category tree"]
  node_category_search["Category search"]
end

subgraph group_maintenance["Database diagnostics"]
  node_table_sizes["Table sizes<br/>[вес таблиц.sql]"]
  node_unused_indexes["Unused indexes"]
end

node_user(("User"))
node_db[("TECDOC database")]

node_user -->|"requests details"| node_article_info
node_user -->|"requests specifications"| node_article_specs
node_user -->|"requests fitment criteria"| node_article_criteria
node_user -->|"requests fitment"| node_article_fitment
node_user -->|"requests accessories"| node_article_accessories
node_user -->|"requests images"| node_article_images
node_user -->|"requests components"| node_article_parts
node_user -->|"requests cross-references"| node_article_crosses
node_user -->|"searches equivalents"| node_part_equivalents
node_user -->|"requests grouped parts"| node_part_group_list
node_user -->|"requests image coordinates"| node_part_image_coords
node_user -->|"requests specifications"| node_passenger_specs
node_user -->|"requests vehicle details"| node_commercial_details
node_user -->|"requests vehicle details"| node_passenger_details
node_user -->|"requests suppliers"| node_passenger_suppliers
node_user -->|"requests manufacturers"| node_passenger_makes
node_user -->|"searches by KBA"| node_vehicle_kba
node_user -->|"searches by plate"| node_vehicle_nl
node_user -->|"searches by plate"| node_vehicle_fr
node_user -->|"requests model ranges"| node_model_series
node_user -->|"requests models"| node_series_models
node_user -->|"requests category tree"| node_category_tree
node_user -->|"searches categories"| node_category_search
node_user -->|"checks table sizes"| node_table_sizes
node_user -->|"checks indexes"| node_unused_indexes
node_article_info -->|"queries"| node_db
node_article_specs -->|"queries"| node_db
node_article_criteria -->|"queries"| node_db
node_article_fitment -->|"queries"| node_db
node_article_accessories -->|"queries"| node_db
node_article_images -->|"queries"| node_db
node_article_parts -->|"queries"| node_db
node_article_crosses -->|"queries"| node_db
node_part_equivalents -->|"queries"| node_db
node_part_group_list -->|"queries"| node_db
node_part_image_coords -->|"queries"| node_db
node_passenger_specs -->|"queries"| node_db
node_commercial_details -->|"queries"| node_db
node_passenger_details -->|"queries"| node_db
node_passenger_suppliers -->|"queries"| node_db
node_passenger_makes -->|"queries"| node_db
node_vehicle_kba -->|"queries"| node_db
node_vehicle_nl -->|"queries"| node_db
node_vehicle_fr -->|"queries"| node_db
node_model_series -->|"queries"| node_db
node_series_models -->|"queries"| node_db
node_category_tree -->|"queries"| node_db
node_category_search -->|"queries"| node_db

click node_article_info "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D0%B8%20%D0%BE%D0%B1%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B5.sql"
click node_article_specs "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%B2%D1%81%D0%B5%D1%85%20%D1%81%D0%BF%D0%B5%D1%86%D0%B8%D1%84%D0%B8%D0%BA%D0%B0%D1%86%D0%B8%D0%B8(%D0%BA%D1%80%D0%B8%D1%82%D0%B5%D1%80%D0%B8%D0%B5%D0%B2)%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0.sql"
click node_article_criteria "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BA%D1%80%D0%B8%D1%82%D0%B5%D1%80%D0%B8%D0%B5%D0%B2%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%BE%D0%B2%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D0%B2%D1%82%D0%BE.sql"
click node_article_fitment "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BF%D1%80%D0%B8%D0%BC%D0%B5%D0%BD%D1%8F%D0%B5%D0%BC%D0%BE%D1%81%D1%82%D0%B8%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0%20%D0%BA%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%B8%D0%BC%20%D0%B0%D0%B2%D1%82%D0%BE.sql"
click node_article_accessories "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%B0%D0%BA%D1%81%D0%B5%D1%81%D1%81%D1%83%D0%B0%D1%80%D0%BE%D0%B2%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0.sql"
click node_article_images "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B9%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0.sql"
click node_article_parts "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%A1%D0%BF%D0%B8%D1%81%D0%BE%D0%BA%20%D0%B4%D0%B5%D1%82%D0%B0%D0%BB%D0%B5%D0%B9%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0.sql"
click node_article_crosses "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%BB%D1%83%D1%87%D0%B5%D0%BD%D0%B8%D1%8F%20%D0%B2%D1%81%D0%B5%D1%85%20%D0%BA%D1%80%D0%BE%D1%81%D1%81%D0%BE%D0%B2%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0.sql"
click node_part_equivalents "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%B8%D1%81%D0%BA%20%D0%B0%D0%BD%D0%B0%D0%BB%D0%BE%D0%B3%D0%BE%D0%B2%20%D0%B7%D0%B0%D0%BF%D1%87%D0%B0%D1%81%D1%82%D0%B5%D0%B9%20%D0%BF%D0%BE%20%D0%BD%D0%BE%D0%BC%D0%B5%D1%80%D0%B0%D0%BC.sql"
click node_part_group_list "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%BE%D0%B2%20%D0%B4%D0%BB%D1%8F%20%D1%83%D0%BA%D0%B0%D0%B7%D0%B0%D0%BD%D0%BD%D0%BE%D0%B9%20%D1%82%D0%BE%D0%B2%D0%B0%D1%80%D0%BD%D0%BE%D0%B9%20%D0%B3%D1%80%D1%83%D0%BF%D0%BF%D1%8B%20%D0%B8%20%D0%BF%D1%80%D0%BE%D0%B8%D0%B7%D0%B2%D0%BE%D0%B4%D0%B8%D1%82%D0%B5%D0%BB%D1%8F.sql"
click node_part_image_coords "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%BB%D1%83%D1%87%D0%B5%D0%BD%D0%B8%D1%8F%20%D0%BA%D0%BE%D0%BE%D1%80%D0%B4%D0%B8%D0%BD%D0%B0%D1%82%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%BE%D0%B2%20%D0%BD%D0%B0%20%D0%BE%D0%B1%D1%89%D0%B5%D0%BC%20%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B8%20%D0%B4%D0%BB%D1%8F%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%B4%D0%B5%D1%82%D0%B0%D0%BB%D0%B5%D0%B9.sql"
click node_passenger_specs "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%B2%D1%81%D0%B5%D1%85%20%D1%81%D0%BF%D0%B5%D1%86%D0%B8%D1%84%D0%B8%D0%BA%D0%B0%D1%86%D0%B8%D0%B8(%D0%BA%D1%80%D0%B8%D1%82%D0%B5%D1%80%D0%B8%D0%B5%D0%B2)%20%D0%B4%D0%BB%D1%8F%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE.sql"
click node_commercial_details "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BF%D0%BE%D0%B4%D1%80%D0%BE%D0%B1%D0%BD%D0%BE%D0%B9%20%D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D0%B8%20%D0%BE%20%D0%BA%D0%BE%D0%BC%D0%BC%D0%B5%D1%80%D1%87%D0%B5%D1%81%D0%BA%D0%BE%D0%BC%20%D0%B0%D0%B2%D1%82%D0%BE.sql"
click node_passenger_details "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BF%D0%BE%D0%B4%D1%80%D0%BE%D0%B1%D0%BD%D0%BE%D0%B9%20%D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D0%B8%20%D0%BE%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%BC%20%D0%B0%D0%B2%D1%82%D0%BE.sql"
click node_passenger_suppliers "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BF%D0%BE%D1%81%D1%82%D0%B0%D0%B2%D1%89%D0%B8%D0%BA%D0%BE%D0%B2%20%D0%B8%20%D1%82%D0%BE%D0%B2%D0%B0%D1%80%D0%BD%D1%8B%D1%85%20%D0%B3%D1%80%D1%83%D0%BF%D0%BF%20%D0%B4%D0%BB%D1%8F%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE.sql"
click node_passenger_makes "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%BF%D1%80%D0%BE%D0%B8%D0%B7%D0%B2%D0%BE%D0%B4%D0%B8%D1%82%D0%B5%D0%BB%D0%B5%D0%B9%20%D0%B4%D0%BB%D1%8F%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%B8%D1%85%20%D0%B0%D0%B2%D1%82%D0%BE.sql"
click node_vehicle_kba "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%B8%D1%81%D0%BA%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%BF%D0%BE%20KBA-%D0%BD%D0%BE%D0%BC%D0%B5%D1%80%D1%83.sql"
click node_vehicle_nl "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%B8%D1%81%D0%BA%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%BF%D0%BE%20%D0%BD%D0%BE%D0%BC%D0%B5%D1%80%D0%BD%D1%8B%D0%BC%20%D0%B7%D0%BD%D0%B0%D0%BA%D0%B0%D0%BC%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%9D%D0%B8%D0%B4%D0%B5%D1%80%D0%BB%D0%B0%D0%BD%D0%B4%D0%BE%D0%B2(Kenteken).sql"
click node_vehicle_fr "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%B8%D1%81%D0%BA%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%BF%D0%BE%20%D0%BD%D0%BE%D0%BC%D0%B5%D1%80%D0%BD%D1%8B%D0%BC%20%D0%B7%D0%BD%D0%B0%D0%BA%D0%B0%D0%BC%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%A4%D1%80%D0%B0%D0%BD%D1%86%D0%B8%D0%B8(cartes%20grises).sql"
click node_model_series "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%BC%D0%BE%D0%B4%D0%B5%D0%BB%D1%8C%D0%BD%D1%8B%D1%85%20%D1%80%D1%8F%D0%B4%D0%BE%D0%B2%20%D0%B4%D0%BB%D1%8F%20%D0%BF%D1%80%D0%BE%D0%B8%D0%B7%D0%B2%D0%BE%D0%B4%D0%B8%D1%82%D0%B5%D0%BB%D1%8F%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%B8%D1%85%20%D0%B0%D0%B2%D1%82%D0%BE.sql"
click node_series_models "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%BC%D0%BE%D0%B4%D0%B5%D0%BB%D0%B5%D0%B9%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%B8%D1%85%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%B4%D0%BB%D1%8F%20%D0%BC%D0%BE%D0%B4%D0%B5%D0%BB%D1%8C%D0%BD%D0%BE%D0%B3%D0%BE%20%D1%80%D1%8F%D0%B4%D0%B0.sql"
click node_category_tree "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D1%81%D1%82%D1%80%D0%BE%D0%B5%D0%BD%D0%B8%D1%8F%20%D0%B4%D0%B5%D1%80%D0%B5%D0%B2%D0%B0%20%D1%82%D0%BE%D0%B2%D0%B0%D1%80%D0%BD%D1%8B%D1%85%20%D0%B3%D1%80%D1%83%D0%BF%D0%BF%20%D0%B4%D0%BB%D1%8F%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE.sql"
click node_category_search "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%B8%D1%81%D0%BA%20%D0%B4%D1%80%D0%B5%D0%B2%D0%B0%20%D1%82%D0%BE%D0%B2%D0%B0%D1%80%D0%BD%D0%BE%D0%B9%20%D0%B3%D1%80%D1%83%D0%BF%D0%BF%D1%8B%20%D0%BF%D0%BE%20%D0%BE%D0%BF%D0%B8%D1%81%D0%B0%D0%BD%D0%B8%D1%8E.sql"
click node_table_sizes "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%B2%D0%B5%D1%81%20%D1%82%D0%B0%D0%B1%D0%BB%D0%B8%D1%86.sql"
click node_unused_indexes "https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%B2%D1%81%D0%B5%20%D0%BD%D0%B5%D0%B8%D1%81%D0%BF%D0%BE%D0%BB%D1%8C%D0%B7%D1%83%D0%B5%D0%BC%D1%8B%D0%B5%20%D0%B8%D0%BD%D0%B4%D0%B5%D0%BA%D1%81%D1%8B.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_article_info,node_article_specs,node_article_criteria,node_article_fitment,node_article_accessories,node_article_images,node_article_parts,node_article_crosses,node_part_equivalents,node_part_group_list,node_part_image_coords,node_user toneBlue
class node_passenger_specs,node_commercial_details,node_passenger_details,node_passenger_suppliers,node_passenger_makes,node_vehicle_kba,node_vehicle_nl,node_vehicle_fr,node_model_series,node_series_models,node_db toneAmber
class node_category_tree,node_category_search toneMint
class node_table_sizes,node_unused_indexes toneRose
```

## Components

### Parts queries

- [Article details](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D0%B8%20%D0%BE%D0%B1%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B5.sql): `Выбор информации об артикуле.sql`
- [Article specifications](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%B2%D1%81%D0%B5%D1%85%20%D1%81%D0%BF%D0%B5%D1%86%D0%B8%D1%84%D0%B8%D0%BA%D0%B0%D1%86%D0%B8%D0%B8(%D0%BA%D1%80%D0%B8%D1%82%D0%B5%D1%80%D0%B8%D0%B5%D0%B2)%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0.sql): `Выбор всех спецификации(критериев) для артикула.sql`
- [Vehicle criteria](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BA%D1%80%D0%B8%D1%82%D0%B5%D1%80%D0%B8%D0%B5%D0%B2%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%BE%D0%B2%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D0%B2%D1%82%D0%BE.sql): `Выбор критериев артикулов для авто.sql`
- [Article fitment](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BF%D1%80%D0%B8%D0%BC%D0%B5%D0%BD%D1%8F%D0%B5%D0%BC%D0%BE%D1%81%D1%82%D0%B8%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0%20%D0%BA%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%B8%D0%BC%20%D0%B0%D0%B2%D1%82%D0%BE.sql): `Выбор применяемости артикула к пассажирским авто.sql`
- [Article accessories](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%B0%D0%BA%D1%81%D0%B5%D1%81%D1%81%D1%83%D0%B0%D1%80%D0%BE%D0%B2%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0.sql): `Выбор списка аксессуаров для артикула.sql`
- [Article images](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B9%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0.sql): `Выбор списка изображений для артикула.sql`
- [Article components](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%A1%D0%BF%D0%B8%D1%81%D0%BE%D0%BA%20%D0%B4%D0%B5%D1%82%D0%B0%D0%BB%D0%B5%D0%B9%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0.sql): `Список деталей для артикула.sql`
- [Article cross-references](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%BB%D1%83%D1%87%D0%B5%D0%BD%D0%B8%D1%8F%20%D0%B2%D1%81%D0%B5%D1%85%20%D0%BA%D1%80%D0%BE%D1%81%D1%81%D0%BE%D0%B2%20%D0%B4%D0%BB%D1%8F%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%B0.sql): `Получения всех кроссов для артикула.sql`
- [Part number equivalents](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%B8%D1%81%D0%BA%20%D0%B0%D0%BD%D0%B0%D0%BB%D0%BE%D0%B3%D0%BE%D0%B2%20%D0%B7%D0%B0%D0%BF%D1%87%D0%B0%D1%81%D1%82%D0%B5%D0%B9%20%D0%BF%D0%BE%20%D0%BD%D0%BE%D0%BC%D0%B5%D1%80%D0%B0%D0%BC.sql): `Поиск аналогов запчастей по номерам.sql`
- [Parts by group](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%BE%D0%B2%20%D0%B4%D0%BB%D1%8F%20%D1%83%D0%BA%D0%B0%D0%B7%D0%B0%D0%BD%D0%BD%D0%BE%D0%B9%20%D1%82%D0%BE%D0%B2%D0%B0%D1%80%D0%BD%D0%BE%D0%B9%20%D0%B3%D1%80%D1%83%D0%BF%D0%BF%D1%8B%20%D0%B8%20%D0%BF%D1%80%D0%BE%D0%B8%D0%B7%D0%B2%D0%BE%D0%B4%D0%B8%D1%82%D0%B5%D0%BB%D1%8F.sql): `Выбор списка артикулов для указанной товарной группы и производителя.sql`
- [Image part coordinates](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%BB%D1%83%D1%87%D0%B5%D0%BD%D0%B8%D1%8F%20%D0%BA%D0%BE%D0%BE%D1%80%D0%B4%D0%B8%D0%BD%D0%B0%D1%82%20%D0%B0%D1%80%D1%82%D0%B8%D0%BA%D1%83%D0%BB%D0%BE%D0%B2%20%D0%BD%D0%B0%20%D0%BE%D0%B1%D1%89%D0%B5%D0%BC%20%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B8%20%D0%B4%D0%BB%D1%8F%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%B4%D0%B5%D1%82%D0%B0%D0%BB%D0%B5%D0%B9.sql): `Получения координат артикулов на общем изображении для списка деталей.sql`

### Vehicle queries

- [Vehicle specifications](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%B2%D1%81%D0%B5%D1%85%20%D1%81%D0%BF%D0%B5%D1%86%D0%B8%D1%84%D0%B8%D0%BA%D0%B0%D1%86%D0%B8%D0%B8(%D0%BA%D1%80%D0%B8%D1%82%D0%B5%D1%80%D0%B8%D0%B5%D0%B2)%20%D0%B4%D0%BB%D1%8F%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE.sql): `Выбор всех спецификации(критериев) для пассажирского авто.sql`
- [Commercial vehicle details](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BF%D0%BE%D0%B4%D1%80%D0%BE%D0%B1%D0%BD%D0%BE%D0%B9%20%D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D0%B8%20%D0%BE%20%D0%BA%D0%BE%D0%BC%D0%BC%D0%B5%D1%80%D1%87%D0%B5%D1%81%D0%BA%D0%BE%D0%BC%20%D0%B0%D0%B2%D1%82%D0%BE.sql): `Выбор подробной информации о коммерческом авто.sql`
- [Passenger vehicle details](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BF%D0%BE%D0%B4%D1%80%D0%BE%D0%B1%D0%BD%D0%BE%D0%B9%20%D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D0%B8%20%D0%BE%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%BC%20%D0%B0%D0%B2%D1%82%D0%BE.sql): `Выбор подробной информации о пассажирском авто.sql`
- [Vehicle suppliers and groups](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D0%BF%D0%BE%D1%81%D1%82%D0%B0%D0%B2%D1%89%D0%B8%D0%BA%D0%BE%D0%B2%20%D0%B8%20%D1%82%D0%BE%D0%B2%D0%B0%D1%80%D0%BD%D1%8B%D1%85%20%D0%B3%D1%80%D1%83%D0%BF%D0%BF%20%D0%B4%D0%BB%D1%8F%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE.sql): `Выбор поставщиков и товарных групп для пассажирского авто.sql`
- [Vehicle manufacturers](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%BF%D1%80%D0%BE%D0%B8%D0%B7%D0%B2%D0%BE%D0%B4%D0%B8%D1%82%D0%B5%D0%BB%D0%B5%D0%B9%20%D0%B4%D0%BB%D1%8F%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%B8%D1%85%20%D0%B0%D0%B2%D1%82%D0%BE.sql): `Выбор списка производителей для пассажирских авто.sql`
- [KBA lookup](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%B8%D1%81%D0%BA%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%BF%D0%BE%20KBA-%D0%BD%D0%BE%D0%BC%D0%B5%D1%80%D1%83.sql): `Поиск пассажирского авто по KBA-номеру.sql`
- [Netherlands plate lookup](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%B8%D1%81%D0%BA%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%BF%D0%BE%20%D0%BD%D0%BE%D0%BC%D0%B5%D1%80%D0%BD%D1%8B%D0%BC%20%D0%B7%D0%BD%D0%B0%D0%BA%D0%B0%D0%BC%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%9D%D0%B8%D0%B4%D0%B5%D1%80%D0%BB%D0%B0%D0%BD%D0%B4%D0%BE%D0%B2(Kenteken).sql): `Поиск пассажирского авто по номерным знакам авто Нидерландов(Kenteken).sql`
- [France plate lookup](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%B8%D1%81%D0%BA%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%BF%D0%BE%20%D0%BD%D0%BE%D0%BC%D0%B5%D1%80%D0%BD%D1%8B%D0%BC%20%D0%B7%D0%BD%D0%B0%D0%BA%D0%B0%D0%BC%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%A4%D1%80%D0%B0%D0%BD%D1%86%D0%B8%D0%B8(cartes%20grises).sql): `Поиск пассажирского авто по номерным знакам авто Франции(cartes grises).sql`
- [Vehicle model ranges](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%BC%D0%BE%D0%B4%D0%B5%D0%BB%D1%8C%D0%BD%D1%8B%D1%85%20%D1%80%D1%8F%D0%B4%D0%BE%D0%B2%20%D0%B4%D0%BB%D1%8F%20%D0%BF%D1%80%D0%BE%D0%B8%D0%B7%D0%B2%D0%BE%D0%B4%D0%B8%D1%82%D0%B5%D0%BB%D1%8F%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%B8%D1%85%20%D0%B0%D0%B2%D1%82%D0%BE.sql): `Выбор списка модельных рядов для производителя пассажирских авто.sql`
- [Models in range](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%92%D1%8B%D0%B1%D0%BE%D1%80%20%D1%81%D0%BF%D0%B8%D1%81%D0%BA%D0%B0%20%D0%BC%D0%BE%D0%B4%D0%B5%D0%BB%D0%B5%D0%B9%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%B8%D1%85%20%D0%B0%D0%B2%D1%82%D0%BE%20%D0%B4%D0%BB%D1%8F%20%D0%BC%D0%BE%D0%B4%D0%B5%D0%BB%D1%8C%D0%BD%D0%BE%D0%B3%D0%BE%20%D1%80%D1%8F%D0%B4%D0%B0.sql): `Выбор списка моделей пассажирских авто для модельного ряда.sql`

### Catalog queries

- [Vehicle category tree](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D1%81%D1%82%D1%80%D0%BE%D0%B5%D0%BD%D0%B8%D1%8F%20%D0%B4%D0%B5%D1%80%D0%B5%D0%B2%D0%B0%20%D1%82%D0%BE%D0%B2%D0%B0%D1%80%D0%BD%D1%8B%D1%85%20%D0%B3%D1%80%D1%83%D0%BF%D0%BF%20%D0%B4%D0%BB%D1%8F%20%D0%BF%D0%B0%D1%81%D1%81%D0%B0%D0%B6%D0%B8%D1%80%D1%81%D0%BA%D0%BE%D0%B3%D0%BE%20%D0%B0%D0%B2%D1%82%D0%BE.sql): `Построения дерева товарных групп для пассажирского авто.sql`
- [Category search](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%9F%D0%BE%D0%B8%D1%81%D0%BA%20%D0%B4%D1%80%D0%B5%D0%B2%D0%B0%20%D1%82%D0%BE%D0%B2%D0%B0%D1%80%D0%BD%D0%BE%D0%B9%20%D0%B3%D1%80%D1%83%D0%BF%D0%BF%D1%8B%20%D0%BF%D0%BE%20%D0%BE%D0%BF%D0%B8%D1%81%D0%B0%D0%BD%D0%B8%D1%8E.sql): `Поиск древа товарной группы по описанию.sql`

### Database diagnostics

- [Table sizes](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%B2%D0%B5%D1%81%20%D1%82%D0%B0%D0%B1%D0%BB%D0%B8%D1%86.sql): `вес таблиц.sql`
- [Unused indexes](https://github.com/autodatabases/tecdoc_2q2023/blob/main/%D0%B2%D1%81%D0%B5%20%D0%BD%D0%B5%D0%B8%D1%81%D0%BF%D0%BE%D0%BB%D1%8C%D0%B7%D1%83%D0%B5%D0%BC%D1%8B%D0%B5%20%D0%B8%D0%BD%D0%B4%D0%B5%D0%BA%D1%81%D1%8B.sql): `все неиспользуемые индексы.sql`

### Other components

- **User**
- **TECDOC database**

## Connections

- User → Article details: requests details (evidence: `README.md`)
- User → Article specifications: requests specifications (evidence: `README.md`)
- User → Vehicle criteria: requests fitment criteria (evidence: `README.md`)
- User → Article fitment: requests fitment (evidence: `README.md`)
- User → Article accessories: requests accessories (evidence: `README.md`)
- User → Article images: requests images (evidence: `README.md`)
- User → Article components: requests components (evidence: `README.md`)
- User → Article cross-references: requests cross-references (evidence: `README.md`)
- User → Part number equivalents: searches equivalents (evidence: `README.md`)
- User → Parts by group: requests grouped parts (evidence: `README.md`)
- User → Image part coordinates: requests image coordinates (evidence: `README.md`)
- User → Vehicle specifications: requests specifications (evidence: `README.md`)
- User → Commercial vehicle details: requests vehicle details (evidence: `README.md`)
- User → Passenger vehicle details: requests vehicle details (evidence: `README.md`)
- User → Vehicle suppliers and groups: requests suppliers (evidence: `README.md`)
- User → Vehicle manufacturers: requests manufacturers (evidence: `README.md`)
- User → KBA lookup: searches by KBA (evidence: `README.md`)
- User → Netherlands plate lookup: searches by plate (evidence: `README.md`)
- User → France plate lookup: searches by plate (evidence: `README.md`)
- User → Vehicle model ranges: requests model ranges (evidence: `README.md`)
- User → Models in range: requests models (evidence: `README.md`)
- User → Vehicle category tree: requests category tree (evidence: `README.md`)
- User → Category search: searches categories (evidence: `README.md`)
- User → Table sizes: checks table sizes (evidence: `README.md`)
- User → Unused indexes: checks indexes (evidence: `README.md`)
- Article details → TECDOC database: queries (evidence: `README.md`)
- Article specifications → TECDOC database: queries (evidence: `README.md`)
- Vehicle criteria → TECDOC database: queries (evidence: `README.md`)
- Article fitment → TECDOC database: queries (evidence: `README.md`)
- Article accessories → TECDOC database: queries (evidence: `README.md`)
- Article images → TECDOC database: queries (evidence: `README.md`)
- Article components → TECDOC database: queries (evidence: `README.md`)
- Article cross-references → TECDOC database: queries (evidence: `README.md`)
- Part number equivalents → TECDOC database: queries (evidence: `README.md`)
- Parts by group → TECDOC database: queries (evidence: `README.md`)
- Image part coordinates → TECDOC database: queries (evidence: `README.md`)
- Vehicle specifications → TECDOC database: queries (evidence: `README.md`)
- Commercial vehicle details → TECDOC database: queries (evidence: `README.md`)
- Passenger vehicle details → TECDOC database: queries (evidence: `README.md`)
- Vehicle suppliers and groups → TECDOC database: queries (evidence: `README.md`)
- Vehicle manufacturers → TECDOC database: queries (evidence: `README.md`)
- KBA lookup → TECDOC database: queries (evidence: `README.md`)
- Netherlands plate lookup → TECDOC database: queries (evidence: `README.md`)
- France plate lookup → TECDOC database: queries (evidence: `README.md`)
- Vehicle model ranges → TECDOC database: queries (evidence: `README.md`)
- Models in range → TECDOC database: queries (evidence: `README.md`)
- Vehicle category tree → TECDOC database: queries (evidence: `README.md`)
- Category search → TECDOC database: queries (evidence: `README.md`)
