En useful tables.txt — различия между версиями

Текущая версия на 09:15, 15 мая 2013

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