==============================
							
Table data cars (TableCarsXXX.csv)
-----
CAR_BRANDS - manufacturer
MODEL_CAR - model car
TYP_CAR - type car (engine data)
BODY_TYPE - body type
OF_THE_YEAR - from year
UP_TO_A_YEAR - to year
KV - kw
PM - pm/hp
CC - ccm
TTC_TYP_ID - id type car
TTC_MOD_ID - id model car
TTC_MFA_ID - id brand car
TECHNICAL_INFORMATION - technical info of car
ENGINES - list engines							

							
Table cross-refernce numbers codes (TablePartsCrossReference.csv)
-----
mainART_BRANDS – brand spare parts for which are sought analogues
mainART_CODE_PARTS – code spare parts for which are sought analogues
TTC_ART_ID – index field of spare parts (refer to the table  MainTableParts.csv)
BRANDS -  brand cross-reference (if empty - code of users)
CODE_PARTS – code parts analogue (cross-reference) short
CODE_PARTS_ADVANCED - code parts analogue (cross-reference) full
KIND – type analogue (2 – trade number; 3 – original;  4- not original) 


Data table parts (MainTableParts.csv)
-----
NAME_PARTS – name of the part
BRAND – brand name manufacturer parts
CODE_PART – search code parts (no dots, spaces, and additional characters);
CODE_PARTS_ADVANCED – code parts specified by the manufacturer
EAN – Barcode Parts
STATUSPRODUCT  -  Product status
TTC_ART_ID - The index field parts


Table of characteristics (criteria) parts in a separate file (MainTablePartsCRI.csv)
-----
TTC_ART_ID– The index field parts
BRAND – brand name manufacturer parts
CODE_PART – search code parts (no dots, spaces, and additional characters);
CODE_PARTS_ADVANCED – code parts specified by the manufacturer
NAMECRITERIA– name of criterion spare parts (characteristic)
VALUECRITERIA – value  of criterion spare parts


Tables binders spare parts and product groups (Table applicability regarding the spare parts) (TableUseCarsForParts_ART_ID.csv)
-----
TTC_ART_ID  – The index field parts
ART_BRAND – brand name manufacturer parts
ART_CODE_1 – search code parts (no dots, spaces, and additional characters)
ART_CODE_2 – code parts specified by the manufacturer
ART_NAME – name of the part 
ART_EAN – Barcode Parts
PARTS_INFO – criteria Part
TERMS_OF_USE – use of spare parts for the selected car
ART_CROSS – cross-reference code
TTC_TYP_ID – index field vehicles
CAR_BRAND– brand name car
CAR_MODEL– car Model
CAR_TYP– type of engine
CAR_BODY– type of car body
CAR_OF_YEAR – from the year 
CAR_TO_YEAR -  to model year
CAR_KW – engine power, KW	
CAR_PM – engine power, HP
CAR_CC	–  The index field parts 


							==============================

================
- All images are converted into graphical format "JPG".
- All images placed in separate folders with names as ID manufacturers (also there are script for rename folder as names of brands)
- The file name corresponds identification number spare parts ttc_ART_ID.
- If the file name contains auxiliary numbers through the point, this means that an additional image for this parts, for example:
2649579.1.JPG - a subsidiary picture for Item from ttc_ART_ID = 2649579, and possible name images for this parts, such as:
		2649579.JPG
		2649579.1.JPG
		2649579.2.JPG
		... 2649579.x.JPG


***************************************************************************************

If you can not open the correct table using the table editor (when all the data in one line),
need to change in the settings of the local computer for list separator tables on the symbol of point with coma ";"
(example changes http://ttc.bovsoft.com/download/listseparatorforyourlocale.jpg)
************************************************************************************