How autodatabases/tecdoc_2q2023 works
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 Article details · Выбор всех спецификации(критериев) для артикула.sql Article specifications · Выбор критериев артикулов для авто.sql Vehicle criteria · Выбор применяемости артикула к пассажирским авто.sql Article fitment
Components 27
Parts queries
- Article details
Выбор информации об артикуле.sql - Article specifications
Выбор всех спецификации(критериев) для артикула.sql - Vehicle criteria
Выбор критериев артикулов для авто.sql - Article fitment
Выбор применяемости артикула к пассажирским авто.sql - Article accessories
Выбор списка аксессуаров для артикула.sql - Article images
Выбор списка изображений для артикула.sql - Article components
Список деталей для артикула.sql - Article cross-references
Получения всех кроссов для артикула.sql - Part number equivalents
Поиск аналогов запчастей по номерам.sql - Parts by group
Выбор списка артикулов для указанной товарной группы и производителя.sql - Image part coordinates
Получения координат артикулов на общем изображении для списка деталей.sql
Vehicle queries
- Vehicle specifications
Выбор всех спецификации(критериев) для пассажирского авто.sql - Commercial vehicle details
Выбор подробной информации о коммерческом авто.sql - Passenger vehicle details
Выбор подробной информации о пассажирском авто.sql - Vehicle suppliers and groups
Выбор поставщиков и товарных групп для пассажирского авто.sql - Vehicle manufacturers
Выбор списка производителей для пассажирских авто.sql - KBA lookup
Поиск пассажирского авто по KBA-номеру.sql - Netherlands plate lookup
Поиск пассажирского авто по номерным знакам авто Нидерландов(Kenteken).sql - France plate lookup
Поиск пассажирского авто по номерным знакам авто Франции(cartes grises).sql - Vehicle model ranges
Выбор списка модельных рядов для производителя пассажирских авто.sql - Models in range
Выбор списка моделей пассажирских авто для модельного ряда.sql
Catalog queries
- Vehicle category tree
Построения дерева товарных групп для пассажирского авто.sql - Category search
Поиск древа товарной группы по описанию.sql
Database diagnostics
- Table sizes
вес таблиц.sql - Unused indexes
все неиспользуемые индексы.sql
Other components
- User
- TECDOC database
Connections 48
- User → Article details: requests details
README.md - User → Article specifications: requests specifications
README.md - User → Vehicle criteria: requests fitment criteria
README.md - User → Article fitment: requests fitment
README.md - User → Article accessories: requests accessories
README.md - User → Article images: requests images
README.md - User → Article components: requests components
README.md - User → Article cross-references: requests cross-references
README.md - User → Part number equivalents: searches equivalents
README.md - User → Parts by group: requests grouped parts
README.md - User → Image part coordinates: requests image coordinates
README.md - User → Vehicle specifications: requests specifications
README.md - User → Commercial vehicle details: requests vehicle details
README.md - User → Passenger vehicle details: requests vehicle details
README.md - User → Vehicle suppliers and groups: requests suppliers
README.md - User → Vehicle manufacturers: requests manufacturers
README.md - User → KBA lookup: searches by KBA
README.md - User → Netherlands plate lookup: searches by plate
README.md - User → France plate lookup: searches by plate
README.md - User → Vehicle model ranges: requests model ranges
README.md - User → Models in range: requests models
README.md - User → Vehicle category tree: requests category tree
README.md - User → Category search: searches categories
README.md - User → Table sizes: checks table sizes
README.md - User → Unused indexes: checks indexes
README.md - Article details → TECDOC database: queries
README.md - Article specifications → TECDOC database: queries
README.md - Vehicle criteria → TECDOC database: queries
README.md - Article fitment → TECDOC database: queries
README.md - Article accessories → TECDOC database: queries
README.md - Article images → TECDOC database: queries
README.md - Article components → TECDOC database: queries
README.md - Article cross-references → TECDOC database: queries
README.md - Part number equivalents → TECDOC database: queries
README.md - Parts by group → TECDOC database: queries
README.md - Image part coordinates → TECDOC database: queries
README.md - Vehicle specifications → TECDOC database: queries
README.md - Commercial vehicle details → TECDOC database: queries
README.md - Passenger vehicle details → TECDOC database: queries
README.md - Vehicle suppliers and groups → TECDOC database: queries
README.md - Vehicle manufacturers → TECDOC database: queries
README.md - KBA lookup → TECDOC database: queries
README.md - Netherlands plate lookup → TECDOC database: queries
README.md - France plate lookup → TECDOC database: queries
README.md - Vehicle model ranges → TECDOC database: queries
README.md - Models in range → TECDOC database: queries
README.md - Vehicle category tree → TECDOC database: queries
README.md - Category search → TECDOC database: queries
README.md