En useful tables.txt
ONLY THE FOLLOWING TABLES are used in my sample SQL-queries!
If my samples are enough for you, there is no need to upload other 40-odd tables into your database.
It is possible, that even not all of these tables are necessary, therefore check the below given purpose of each table.
ART_COUNTRY_SPECIFICS - Parts status: Normal, Not available, Discontinued product etc.
ART_LOOKUP - Parts analogs search
ARTICLE_CRITERIA - Products (criteria) specifications : installation locations, dimensions etc.
ARTICLE_INFO - Additional information on spare parts (only used in one query of the same name in ARTICLES.sql sample)
ARTICLES - The main spare parts table
BRANDS - All spare parts manufacturers (including original)
COUNTRIES - Countries (used only in samples: COUNTRIES.sql, SUPPLIER_COUNTRIES.sql)
COUNTRY_DESIGNATIONS - Connection of the other tables with text data (DES_TEXTS)
CRITERIA - Parts (criteria) specifications : installation locations, dimensions etc.
DES_TEXTS - All text data
DESIGNATIONS - Link of the other tables with text data (DES_TEXTS)
DOC_TYPES - Pictures formats (used to determine the extension of pictures)
ENGINES - Car Engines
GRAPHICS - Pictures and PDF-files numbers (used to determine the names of folders and pictures/PDF-files)
LINK_ART - Spare parts link with parts groups LA_ID (used to determine spare parts applicability to vehicles and spare parts categories' tree
construction)
LINK_ART_GA - Spare parts link with parts groups GA_ID (used for spare parts categories' tree construction)
LINK_GA_STR - Link of spare parts groups GA_ID with spare parts categories STR_ID (used for spare parts categories' tree construction)
LINK_GRA_ART - Spare parts link with pictures and PDF-files
LINK_LA_TYP - Link of spare parts groups LA_ID with cars (used to determine spare parts applicability to vehicles)
LINK_TYP_ENG - Link of cars and engines
MANUFACTURERS - Car manufacturers
MODELS - Car models
PRICES - Spare parts prices recommended by manufacturers (only used in one query of the same name in ARTICLES.sql)
SEARCH_TREE - Spare parts categories' tree
SUPPLIER_ADDRESSES - Non-original spare parts manufacturers contact information (only used in SUPPLIER_COUNTRIES.sql)
SUPPLIER_LOGOS - Non-original spare parts manufacturers' logos numbers
SUPPLIERS - Non-original spare parts manufacturers
TEXT_MODULE_TEXTS - Texts with additional information on spare parts (only used in one query of the same name in ARTICLES.sql)
TEXT_MODULES - Additional information on spare parts (only used in one query of the same name in ARTICLES.sql)
TYPE_NUMBERS - Additional car numbers (used only for car search by KBA-number)
TYPES - Kinds (types) of cars
Here is a separate list compiled of the above mentioned tables, sufficient for analogs (crosses) search:
ART_LOOKUP - Parts analogs search
ARTICLES - The main spare parts table
BRANDS - All spare parts manufacturers (including original)
DES_TEXTS - All text data
DESIGNATIONS - Link of the other tables with text data (DES_TEXTS)
SUPPLIERS - Non-original spare parts manufacturers
- Back to index page: Tecdoc_queries_and_structure_manual_-_version_2
- Prices and packages for Irbis software based on tecdoc from Mstarproject company: http://www.mstarproject.com/en/?action=tecdoc_mysql_site
