BOVsoft
DESCRIPTION OF TABLES WHICH IS THE OPPORTUNITY TO CREATE USING “CREATOR DATA FOR SALE OF AUTO PARTS” (ttc.index.html#creator data)
Information Table :
• Table brand parts (TableBrands.csv)
• A table of vehicles (TableCarsPassenger.csv и TableCarsTruck.csv)
• Data table parts (MainTableParts.csv)
• Data table specification parts (TableSpecificationsParts.csv)
Catalog tables:
• Grouped table (TableUsePartsForCars_TYP_ID.csv) containing data of cars, data of parts are used on this car, data product groups that include this spare parts.
• Table cross codes (table substitutes) (TablePartsCrossReference.csv)
• Tables for the creation of spare parts catalog (for search parts on these cars). Contains tables :
o Table categories Parts (TableTreeProductGroup.csv)
o Table grouping tables cars and parts relative to the table of categories of spare parts (TableLinkGroupsCarsAndParts.csv)
o Table vehicle group (LinkedTableCars.csv)
o Table of groups spare parts (LinkedTableParts.csv)
o Or by using a linked table
Describing Tables:
• Table brand parts (TableBrands.csv). Поля таблицы :
BRAND – brand name or OEM manufacturer
ADDITIONAL_DATA – brand data (address, website, etc.)
TTC_SUP_ID – The index link to a table of suppliers “”
TTC_BRA_ID – The index link to a table of brands.
• A table of vehicles (TableCarsPassenger.csv and TableCarsTruck.csv)
CAR_BRANDS – brand name car
MODEL_CAR – car Model
TYP_CAR – type of engine
BODY_TYPE – type of car body
OF_THE_YEAR – from the year
UP_TO_A_YEAR - to model year
KV – engine power, KW
PM – engine power, HP
CC – Displacement, CC
TECHNICAL_INFORMATION – Car technical information.
TTC_TYP_ID – index field vehicles
• Table of characteristics (criteria) cars in a separate file (TableCarsPassengerCRI.csv and TableCarsTruckCRI.csv)
TTC_TYP_ID – index field vehicles
CAR_BRANDS – brand name car
MODEL_CAR – car Model
TYP_CAR – type of engine
NAMECRITERIA– name of criterion spare parts (characteristic)
VALUECRITERIA – value of criterion spare parts
• 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
NAME_IMAGE – name image, HEX(BRAND + spase + CODE_PART), где HEX – translation of the text to hexadecimal notation
TTC_ART_ID - The index field parts
ADDITIONAL_DATA – Additional data parts (criteria)
• 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
• Data table specification parts (TableSpecificationsParts.csv)
mainTTC_ART_ID– index field for spare parts, for which are sought the components
mainART_BRANDS – brand of parts, for which are sought the components
mainART_CODE_PARTS – code parts, for which are sought the components
TTC_ART_ID – index field of spare parts (refer to the table MainTableParts.csv) of component
BRANDS - brand of component
CODE_PARTS – trade code of component
QUANTITY - number in the kit
• Bulksheet vehicles, spare parts and product groups (Table applicability regarding the car) (TableUsePartsForCars_TYP_ID.csv)
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
CAR_INFO – technical data of the vehicle
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
ART_NAME_IMAGE – name image, HEX(BRAND + spase + CODE_PART), где HEX – translation of the text to hexadecimal notation
PARTS_INFO – criteria Part
TERMS_OF_USE – use of spare parts for the selected car
ART_CROSS – cross-reference code
TTC_GA_ID – index field of commodity groups
GA_NAME - Full name of groups
GA_STANDARD - Short name of the groups
GA_ASSEMBLY - Place where established
GA_INTENDED – In which additionally includes
• Bulksheet vehicles, 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
ART_NAME_IMAGE – name image, HEX(BRAND + spase + CODE_PART), где HEX – translation of the text to hexadecimal notation
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
CAR_INFO – technical data of the vehicle
• Table cross codes (table substitutes) (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)
KIND – type analogue (2 – trade number; 3 – original; 4- not original)
• Tables to create a catalog of spare parts (Search parts for this car).
Contains tables :
o Table categories Parts (TableTreeProductGroup.csv)
STR_ID – index field categories table
STR_ID_PARENT – child categories, the reference to the parent of the list (on STR_ID)
STR_TYPE – type of product group (1. Car; 2.Truck; 3.Engine; 4.Uuniversal; 5.Axe)
STR_LEVEL – level
STR_TEXT – name category catalog (product group)
o Table grouping tables cars and parts relative to the table of categories of spare parts (TableLinkGroupsCarsAndParts.csv)
LGS_STR_ID– index table field (referring to STR_ID the table TableTreeProductGroup.csv)
LGS_GA_ID– index table field (referring to GA_ID the table LinkedTableCars.csv and LinkedTableParts.csv)
o Table vehicle group (LinkedTableCars.csv)
LAT_TYP_ID– index table field (referring to TTC_TYP_ID the table TableCarsPassenger.csv and/or TableCarsTruck.csv)
LAT_LA_ID - index table field (key to group the applicability to the car)
LAT_GA_ID - index table field (Group number of articles)
o Table of groups of spare parts (LinkedTableParts.csv)
LA_ART_ID– index table field (referring to TTC_ ART_ID the table MainTableParts.csv)
LA_ID - index table field (key to group the applicability to the car)
LA_GA_ID - index table field (Group number of articles)
o Or by using a linked table
- TableTreeProductGroup.csv (Описание данных таблицы выше)
- ExportAddition_TYPID_ARTID.csv (Description of the data table below)
- ExportAddition_TYPID_SRTID.csv (Description of the data table below)
- ExportAddition_ARTID_SRTID.csv (Description of the data table below)
Additional tables
• Link Table [TTC_TYP_ID]=>[TTC_ART_ID] ExportAddition_TYPID_ARTID.csv
TTC_TYP_ID - index field of table cars (referring to TTC_TYP_ID tables TableCarsPassenger.csv and/or TableCarsTruck.csv)
TTC_ART_ID - index field of table spare parts (referring to TTC_ ART_ID the table MainTableParts.csv)
• Link Table [TTC_TYP_ID]=>[STR_ID] ExportAddition_TYPID_SRTID.csv
TTC_TYP_ID - index field of table cars (referring to TTC_TYP_ID tables TableCarsPassenger.csv and/or TableCarsTruck.csv)
STR_ID1 … STR_ID5 – index field categories table (referring to STR_ID tables TableTreeProductGroup.csv);
TEXT1… TEXT5 – name category catalog (product group)
• Link Table [TTC_ART_ID]=>[STR_ID] ExportAddition_ARTID_SRTID.csv
TTC_ART_ID - index field of table spare parts (referring to TTC_ ART_ID the table MainTableParts.csv)
STR_ID – index field categories table (referring to STR_ID tables TableTreeProductGroup.csv);
• Link Table [TTC_ART_ID]=>[TTC_TYP_ID]=>[TERMS_OF_USE] ExportAddition_ARTIDTYPID_TERMSOFUSE.csv
TTC_ART_ID - index field of table spare parts (referring to TTC_ ART_ID the table MainTableParts.csv)
TTC_TYP_ID - index field of table cars (referring to TTC_TYP_ID tables TableCarsPassenger.csv and/or TableCarsTruck.csv)
TERMS_OF_USE – use of spare parts for the selected car
• Table replacement old part numbers to the new [NEW_ART_ID] = [OLD_ART_ID] ExportAddition_ NEWOLDART.csv
NEW_ART_ID - index field of table spare parts (referring to TTC_ ART_ID the table MainTableParts.csv). Trade number to be inserted.
OLD_ART_ID – index field of table spare parts (referring to TTC_ ART_ID the table MainTableParts.csv). Trading numbers for replacement.
• Table KBA / MIME / NUMBERPLATE codes
ExportAddition_ KBA.csv, ExportAddition_ MIME.csv, ExportAddition_ NUMBERPLATE.csv
TTC_TYP_ID - index field of table cars (referring to TTC_TYP_ID tables TableCarsPassenger.csv and/or TableCarsTruck.csv)
KEYNUMBER – Search number, such as KBA-number
Description of the format to list of criteria
[+] Separation of lines in the list of attributes is a symbol of CHR(10)
[+] Separation criterion name and its value - a combination of characters [=>]
[+] If the name criterion of the empty value - then its value is the description of characteristics
Description table, example for database Mysql
The most common SQL queries:
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.