Creation of online stores selling auto parts | Automate ...



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.

Google Online Preview   Download