TecDoc mySQL

TecDoc mySQL

Latest mySQL versions of TecDoc Spare parts catalogue

Ask us live!

TECDOC 2020 mySQL

Using the experience of previous releases of the database, starting from 2017, our specialists have significantly changed the structure of the database and methods of data storage that as a result led to the growth of the speed of the queries up to 3 times.

Release 2020 is available in: Deutsch, English (Gb), Français, Italiano, Español, Nederlands, Dansk, Svenska, Norsk, Suomi, Magyar, Português, Russian, Slovenčina, Čeština, Polski, Ελληvικά, Română, Türkçe, Hrvatski, Srpski, Chinese, Blgarski, latviešu, lietuvių, Eesti, slovenski, English (USA), English (aus), Icelandic, português (br), Ukrainian.

the Structure of the database is built in such a way that you can have as many languages as You need in one database at the same time.

in Addition to the database included in the release archive of images, structured in the following way: /brandName/articleNumber/articleNumber.jpg and also, archive of media materials in PDF formats, etc., structured in a similar way to photos of articles.

Release 2020 includes PNG icons of car manufacturers, icons of car components, icons of types of spare parts. In addition, almost every car model has a corresponding icon on a transparent background in high resolution.

To quickly deploy the catalog to the Web, the release includes a ready-made set of programs in PHP. Once the database is deployed on the mySQL server, in the php-directory settings file, you must specify the username, password, database name and address of the mysql-server). The catalog code is fully open and on its basis, You can create absolutely any complexity web catalog of cars and spare parts.

the Procedure for updating 2020 and all subsequent releases is fully automated and will not require the participation of programmers. Both the installation and the update will be able to cope with a person with basic knowledge in the field of web development.

Also on FTP You will find:
1. Full documentation with a description of each table and each field of the database, sample queries.
2. Images, PDFs, 360 degrees media, youtube links and etc. 3. 12Gb of Studio photos of spare parts without watermarks, sorted by folders with the brand name.
4. Two types of car images (white car, transparent background and colored car with white background).

as a bonus, each buyer 2020 provided, paid for 3 month api-key to VIN-decoder on the server partsapi.ru. On partsapi.ru you will need to register and report the received login Your Manager chat technical support or email info@autodatabases.ru

What you get in TecDoc mySQL database?



amBrand
719


amBrandsAddress
668


articleCriteria
63 492 295


articleCrosses
21 329 954


articleEAN
2 993 815


articleLinks
322 533


articlePdfs
508 005


articles
7 912 906


articlesVehicleTrees
634 593 937


axleBodyType
19 395


axleBrakeSizes
70


bodyMark
50 593


bodyMarkCarIds
45 952


cars
660 861


carsBodies
91 945


countries
1494


countryGroups
24


genericArticles
19 624 858


genericArticlesGroups
8 088


languages
39


legacy2generic
5 654 945


manufacturerMotorIds
26 280


manufacturers
1 475


modelSeries
22 905


motorDetails
25 240


oemNumbers
88 798 712


replacedByArticles
750 667


replacesArticles
776 507


searchIndex
5 670 121


shortCuts
89


tradeNumbers
4 714 713


vehicleAxles
1 504 486


vehicleDetails
88 970


vehicleMotorCodes
88 377


vehicleProtoTypes
72 299


vehicleSecondaryTypes
2 444


vehicleTrees
24 662 693


vehicleWheelBases
64 241

Import is fully automated by means of bash/cmd scripts that will create the necessary tables in the database and fill them with the relevant data.

On FTP you`ll find php-class with all basic sql-queries to construct web catalogue in few hours.
Our support is 24/7 online and will always help you with using DB.

TECDOC 2020

Cost of database:
1000 EUR per 1 language release


We guarantee a full refund in case of non-compliance of the data provided by the declared.