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

Версия 09:08, 15 мая 2013

TecDoc tables structure

===========

// General Information

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

All useful tables of the original TecDoc database (based on DBMS TransBase) started from the prefix TECDOC_TOF_...

To shorten the names during MySQL upload the prefixes were removed by me.

If it is necessary to get data for a specific country and language, filter them by the following fields:

1. *_LNG - Language code. Codes correspondence to languages are listed in LANGUAGES table - field LNG_ISO2 stands for a two-letter country code (corresponds to Internet-domains of countries: ru, de etc.).

Russian*_LNG=16

German: *_LNG=1

There is also a "univesral languauge": *_LNG=255 - the data, corresponding to all languages at once (e.g. pictures without text designations, multilingual PDF-files, etc.) has references to it. If you select your own language data, it is some times necessary to select not only a specific language, but also the records, which refer to the above mentioned "univesral languauge".

2. *_COU - Country code. Codes correspondence to countries are listed in COUNTRIES table - you may similarly go by two-letter codes in field COU_ISO2. Or else you may execute the sample query COUNTRIES.sql.

Russia: *_COU=186

Ukraine: *_COU=223

Belarus: *_COU=33

Former Soviet Union: *_COU=204

Germany: *_COU=52

There are also 2 "country groups":

"Europe": *_COU=248

"Entire world": *_COU=249

Similarly to the "univesral languauge", some data refers not to a specific country, but to one of the country groups, although mostly, of course, it refers both to the country and to the group.

3. *_CTM - Country relevance. Cars/car parts, sold in different countries, are selected by this parameter. There is some possibility to get identical records for different countries. For instance in the U.S. car model Volkswagen Jetta corresponds to Jetta I in Europe. Moreover for Renault there are different names for the same vehicle. Perhaps, some parts can also be different for different countries.

Country relevance for Russia and former USSR coincides in 99% of cases, but for some reason 1% more cars, spare parts etc. refer to Russia - ex-USSR may mean all CIS countries except Russia in TecDoc, however all of these countries also have their own separate codes in the database. In general, if it is necessary to filter by country Russia, my advice is to use code 186, instead of 204.

In DBMS Transbase *_CTM fields are represented as bit fields: '1' values are in positions, numbers of which correspond to country codes - others are '0' values. Thus, for Russia, it is necessary to check the presence of '1' value in the 186th bit.

The maximum length of bit fields in MySQL is 64 bits, and TecDoc now requires 247 bits for *_CTM fields, so during MySQL upload they were converted in BINARY type (analog of conventional CHAR type lines, but excluding code page), 250 bytes length, i.e. the size of the fields became about 8 times larger, than in TransBase and they take 90% size of most tables. If desired, you may convert them to something more compact, but more often the data of all tables is one time filtered by these fields, leaving only the relevance to a necessary country, and then they get rid of both of these very fields and of unnecessary entries in the tables - as a result there is an about 6 time decrease of MySQL database size.

The first 2 characters in MySQL-version of *_CTM fields are always "0b", then come 0-1 digits, though already located not in bits, but in BYTES. Thus, for instance, in the filter for Russia, it is necessary to check: MySQL Syntax: SUBSTRING(*_CTM, 186+2, 1)='1' DBMS TransBase Syntax: *_CTM SUBRANGE(186 CAST INTEGER) = 1 where 186 - code of the country 'Russia' in the COUNTRIES table.

There is no need to further check the 248th and 249th bits of *_CTM fields (corresponding to the groups 'Europe' and 'The World'), as bit field of the group 'Europe'contains '1' digit not only in the 248th bit, but in the bits, corresponding to codes of all European countries, and bit field of the group 'The World' contains '1' digits in all bits. Thus, '1' digit in the bit of a specified country ia always set, if the table entry for that country is relevant.

// Basic tables

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

USER_SETTINGS

Only the following tables of user settings are noteworthy

USS_LNG_ID = 16 - Russian languauge

USS_COU_ID = 186 - country Russia

Next, we will consider that in the tables which contain various text information LNG_ID will be equal to 16, and COU_ID - 186. This will create a filter by languauge <Russian> and by country <Russia>

// Text tables

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

COUNTRY_DESIGNATIONS

Table-grouping of text designations (basis of grouping - unknown)

CDS_ID - key

CDS_LNG_ID - (languauge of text designation) the key with reference to the table LANGUAGES=>LNG_ID

CDS_TEX_ID - (text) the key with reference to the table DES_TEXTS=>TEX_ID

DES_TEXTS

General list of all TecDoc text data

TEX_ID - key

TEX_TEXT - field MEMO, stores text information

DESIGNATIONS

Table-grouping of text designations (basis of grouping - unknown)

DES_ID - key

DES_LNG_ID - (languauge of text designation) the key with reference to the table LANGUAGES=>LNG_ID

DES_TEX_ID - (text) the key with reference to the table DES_TEXTS=>TEX_ID

LANGUAGES

Table-List of TecDoc languauges

LNG_ID - key

LNG_DES_ID - (languauge designation) the key with reference to the table DESIGNATIONS=>DES_ID

COUNTRIES

Table-List of TecDoc countries

COU_ID - key

COU_CC - country code (3-letter)

COU_DES_ID - (country name) the key with reference to the table DESIGNATIONS=>DES_ID

COU_CURRENCY_CODE - currency code

COU_ISO2 - country code (2-letter), matches the names of the Internet domains of the respective countries: de, ru etc.

COU_IS_GROUP - 0 - a specific country, 1 - a group of countries (248 - European countries, 249 - All countries)

// Suppliers tables block

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

SUPPLIERS

Table of non-original spare parts manufacturers. Most likely TecDoc suppliers.

SUP_ID - key

SUP_BRAND - brand

SUP_SUPPLIER_NR - supplier's number according to TecDoc.

SUP_COU_ID - always a blank field. I suppose there will be a country identifier in the future. (COUNTRIES=>COU_ID)

SUPPLIER_LOGOS

Table of logos for suppliers. LNG_ID always equals 255 which stands for the international language (English). I.е. all logos are made for English.

SLO_SUP_ID - (name of the supplier for the logo) the key with reference to the table SUPPLIERS=>SUP_ID

SLO_LNG_ID - (language of supplier's logo) the key with reference to the table LANGUAGES=>LNG_ID

SLO_LOGO - logo in the binary data format.

SUPPLIER_ADDRESSES

Table with information on suppliers (address, phone numbers etc.)

SAD_SUP_ID - key

SAD_TYPE_OF_ADDRESS

SAD_COU_ID - (supllier's country) the key with reference to the table COUNTRIES=>COU_ID

BRANDS

Table of all spare parts manufacturers. (including original). Most likely TecDoc brands.

BRA_ID - key

BRA_CDS_ID - (text) the key with reference to the table COUNTRY_DESIGNATIONS=>CDS_ID

BRA_MFC_CODE - manufacturer's name (abbreviated)

BRA_BRAND - manufacturer's name (full)

BRA_MF_NR - Manufacturer's number according to TecDoc.

1.1 Cars model range Manufacturers and car models

1.1.1 MANUFACTURERS

Cars manufacturers

MFA_ID key

MFA_PC_MFC presence/absence of the manufacturer in the list of passenger cars manufacturers (1 - presence, 0 - absence)

MFA_CV_MFC presence/absence of the manufacturer in the list of trucks manufacturers.

MFA_ENG_MFC presence/absence of the manufacturer in the list of engines manufacturers.

MFA_ENG_TYP engine type: gasoline, diesel etc.

MFA_AXL_MFC presence/absence of the manufacturer in the list of axles manufacturers.

MFA_MFC_CODE abbreviated supplier's name (BRANDS=>BRA_MF_CODE).

MFA_BRAND full supplier's name (BRANDS=>BRA_BRAND).

MFA_MF_NR supplier's number according to TECDOC. (BRANDS=>BRA_MF_NR)

1.1.2 MODELS

Cars models

MOD_ID key

MOD_MFA_ID (supplier) the key with reference to the table MANUFACTURERS=>MFA_ID

MOD_CDS_ID (model) the key with reference to the table COUNTRY_DESIGNATIONS=>CDS_ID. Full text description. In the table country_designations there is reference to des_texts depending on the language. Filter for Russia by cds_lng_id=16

MOD_SORT sort field (determines the serial number in the list <sequence> for the specified supplier)

MOD_PCON_START first 4 digits: model release year from the list <sequence>, last 2: model release month.

MOD_PCON_END first 4 digits: the year of model production termination from the list <sequence>, last 2: the month of model production termination.

MOD_PC presence/absence of the model in the list <sequence> for the manufacturers of passenger cars.

MOD_CV presence/absence of the model in the list <sequence> for truck manufacturers.

MOD_PC_CTM Cars, sold in different countries, are selected by this parameter.

1.1.3 TYPES

Table of vehicle types

TYP_CDS_ID, TYP_MMT_CDS_ID - these two fields stand for the name of the type. In the table country_designations there is a reference to des_texts depending on the languauge. Filter for Russia by cds_lng_id=16

TYP_KW_FROM, TYP_KW_UPTO, TYP_HP_FROM, TYP_HP_UPTO - TecDoc client application does not show the field UPTO, but there still are values for some cars in this field as well. They are supposed to be a kind of a backup, some engines may have spread in power (it might depend on the number of the engine or it might not).

TYP_ID key

TYP_CDS_ID (short type name) the key with refrence to the table COUNTRY_DESIGNATIONS=>CDS_ID

TYP_MMT_CDS_ID (full type name) the key with refrence to the table COUNTRY_DESIGNATIONS=>CDS_ID

TYP_MOD_ID (type model) the key with refrence to the table MODELS=>MOD_ID

TYP_SORT serial number in the list <description> for a particular model, selected from the list <sequence>.

TYP_CTM Cars, sold in different countries, are selected by this parameter.

TYP_LA_CTM ?

TYP_PCON_START first 4 digits: model release year, last 2: model release month.

TYP_PCON_END first 4 digits: the year of model production termination, last 2: the month of model production termination.

TYP_KW_FROM Technical information/Engine power(KW) (from)

TYP_KW_UPTO Technical information/Engine power(KW) (upto)

TYP_HP_FROM Technical information/Engine power(HP) (from)

TYP_HP_UPTO Technical information/Engine power(HP) (upto)

TYP_CCM Technical information/Tech. Cc volume capacity

TYP_CYLINDERS Technical information/Cylinder (Number of cylinders)

TYP_DOORS Design/Number of doors.

TYP_TANK Design/Tank

TYP_KV_VOLTAGE_DES_ ID - (voltage) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_ABS_DES_ID (Technical information/ABS) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_ASR_DES_ID (Technical information/ASR) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_ENGINE_DES_ID - (Technical information/Engine type) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_BRAKE_TYPE_DES_ID (Technical information/Brake type) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_BRAKE_SYST_DES_ID - (Technical information/Brake system) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_FUEL_DES_ ID - (Technical information/Fuel type) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_CATALYST_DES_ID - (Technical information/Catalyst type) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_BODY_DES_ID - (Technical information/Design type) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_STEERING_DES_ID - it may describe steering, and it is always blank in TecDoc.

TYP_KV_STEERING_SIDE_DES_ID - it may determine the side of the steering wheel, and it is always blank in TecDoc.

TYP_MAX_WEIGHT Design/Tonnage

TYP_KV_MODEL_DES_ID - (Design/Build type) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_AXLE_DES_ID - (Design/Axis configuration) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_CCM_TAX Technical information/Тех. Cc volume capacity

TYP_LITRES Technical information/Engine capacity in litres

TYP_KV_DRIVE_DES_ID - (Design/Drive type) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_TRANS_DES_ID - (Technical information/Transmission) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_KV_FUEL_SUPPLY_DES_ID - (Technical information/Fueling) the key with reference to the table DESIGNATIONS=>DES_ID

TYP_VALVES Technical information/Number of valves per combustion chamber

TYP_RT_EXIST always zero

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

// Other tables

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

LINK_LA_TYP_NEW The purpose is not clear. Used since 3rd quarter 2004.

LINK_LA_TYP

Link table.

LAT_TYP_ID - the key with reference to TYPES=>TYP_ID

LAT_LA_ID - the key with reference to LINK_ART=>LA_ID

LAT_GA_ID - (a group of articles) the key with reference to GENERIC_ARTICLES=>GA_ID

LAT_SUP_ID - (supplier) the key with reference to SUPPLIERS=>SUP_ID

LAT_SORT - the field for data sorting in TecDoc format

LINK_ART

Link table, groups article with the shared key LA_ID

LA_ID - key

LA_ART_ID - (article) the key with reference to the table ARTICLES=>ART_ID

LA_GA_ID - (a group of articles) the key with reference to GENERIC_ARTICLES=>GA_ID

LA_SORT - the field for data sorting in TecDoc format

1.1.4 LINK_ART_GA

Link table, does not have a key. Most likely it is an auxiliary table, as it is possible to skip it.

LAG_ART_ID - (article) the key with reference to the table ARTICLES=>ART_ID

LAG_GA_ID - (a group of articles) the key with reference to GENERIC_ARTICLES=>GA_ID

LAG_SUP_ID - (supplier) the key with reference to SUPPLIERS=>SUP_ID

1.2 Spare parts

1.2.1 ARTICLES

Table of articles (table of spare parts)

ART_ID key

ART_ARTICLE_NR article number. Text article number. Used in prices, history, comments.

ART_SUP_ID (supplier - Code of the spare part supplier) the key with reference to SUPPLIERS=>SUP_ID

ART_DES_ID (product description, almost always blank) the key with reference to the table DESIGNATIONS=>DES_ID

ART_CTM Availability for sale in different countries

ART_COMPLETE_DES_ID (product name) the key with reference to the table DESIGNATIONS=>DES_ID

ART_PACK_SELFSERVICE selfservice allowed or not allowed (1/0)

ART_MATERIAL_MARK requires mandatory marking or not (1/0)

ART_REPLACEMENT a spare part is subject to replacement or not (1/0)

ART_ACCESSORY accessory or not (1/0)

ART_BATCH_SIZE1 unknown, designation of this field has not been found in TecDoc

ART_BATCH_SIZE2 unknown, designation of this field has not been found in TecDoc

ART_COUNTRY_SPECIFICS

Table of aricles specs by countries

ACS_ART_ID - (article with attached information) the key with reference to the table ARTICLES=>ART_ID

ACS_CTM - Spec. for this country

ACS_PACK_UNIT - Packing unit

ACS_KV_STATUS_DES_ID - (product status description, for instance <Normal> or <Production discontinued>) the key with reference to the table DESIGNATIONS=>DES_ID

ACS_KV_STATUS - Product status in numerical form 1 - normal 2 - not available 5 - available only under specification 7 - pseudo-product 8 - production discontinued 9 - no longer available ACS_STATUS_DATE - The date, when the article acquired this status (available from, replaced from etc.)

MOD_TYP_LOOKUP

Search tables by models and types of cars.

MTL_TYP_ID - (car type) the key with reference to TYPES=>TYP_ID

MTL_LNG_ID - (search language)

MTL_SEARCH_TEXT - search text

ARTICLE_LISTS

Table of article specifications.

ALI_ART_ID - (the part we draw up a specification for) the key with reference to the table ARTICLES=>ART_ID

ALI_SORT - the field for data sorting in TecDoc format

ALI_ART_ID_COMPONENT - (specification component) the key with reference to the table ARTICLES=>ART_ID

ALI_QUANTITY - quantity for a specification component

ALI_GA_ID - (a group of articles) the key with reference to GENERIC_ARTICLES=>GA_ID

ART_LOOKUP

Search table

ARL_ART_ID - (spare part) the key with reference to the table ARTICLES=>ART_ID

ARL_SEARCH_NUMBER - search number, without periods and spaces.

ARL_KIND - kind of number: 1 - non-original (article) number, the analogs are related to 2 - commercial number (user number) 3 - original (construction) number 4 - non-original analog 5 - bar code (EAN number)

ARL_BRA_ID - (supplier) the key with reference to the table BRANDS=>BRA_ID

ARL_DISPLAY_NR - number with spaces, periods etc.

ARL_DISPLAY - unknown (I did not find the usage)

GENERIC_ARTICLES

Table of the names of article groups

GA_ID - key

GA_NR - number for each group of articles

GA_DES_ID - (full name of the group, the article belongs to) the key with reference to the table DESIGNATIONS=>DES_ID

GA_DES_ID_STANDARD - (name of the article group) the key with reference to the table DESIGNATIONS=>DES_ID

GA_DES_ID_ASSEMBLY - (installation, assembly place) the key with reference to the table DESIGNATIONS=>DES_ID

GA_DES_ID_INTENDED - (intended for) the key with reference to the table DESIGNATIONS=>DES_ID

GA_UNIVERSAL - 1/0 (unknown)

ARTICLE_INFO

Additional information on articles

AIN_ART_ID - (article with additional information) the key with reference to the table ARTICLES=>ART_ID

AIN_SORT - the field for data sorting in TecDoc format

AIN_KV_TYPE - criterion type, used somewhere inside.

AIN_DISPLAY - (screen display, most likely - 1/0) is not used.

AIN_TMO_ID - (text) the key with reference to the table TEXT_MODULES=>TMO_ID

TEXT_MODULES

Table of text information grouping by languauges

TMO_ID - key

TMO_LNG_ID - (language of text information) the key with reference to the table LANGUAGES=>LNG_ID

TMO_FIXED - unknown, I did not find its usage

TMO_TMT_ID - (text) the key with reference to the table TEXT_MODULE_TEXTS=>TMT_ID

TEXT_MODULE_TEXTS

Table containing text information in binary-ASCII format.

TMT_ID - key

TMT_TEXT - the text (binary)

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

// Graphics

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

LINK_GRA_LA

Graphics linking with article blocks

LGL_LA_ID - the key with reference to LINK_ART=>LA_ID

LGL_TYP_ID - the key with reference to TYPES=>TYP_ID

LGL_ENG_ID

LGA_SORT - the field for data sorting in TecDoc format

LGL_GRA_ID - (picture) the key with reference to the table GRAPHICS=>GRA_ID

LINK_GRA_ART

Graphics linking with articles

LGA_ART_ID - (article) the key with reference to the table ARTICLES=>ART_ID

LGA_SORT - the field for data sorting in TecDoc format

LGA_GRA_ID - (picture) the key with reference to the table GRAPHICS=>GRA_ID

GRAPHICS

Data grouping by formats and resource tables

GRA_SUP_ID - (supplier-holder of the picture) the key with reference to the table SUPPLIERS=>SUP_ID

GRA_ID - key

GRA_DOC_TYPE (graphics data type) the key with reference to the table DOC_TYPES=>DOC_TYPE

GRA_LNG_ID (picture language) the key with reference to the table LANGUAGES=>LNG_ID

GRA_GRD_ID (picture) the key with reference to the table GRA_DATA_...=>GRD_ID

GRA_TYPE - unknown, always equals 1

GRA_NORM - unknown, perhaps a type of the window, where the picture is displayed.

GRA_SUPPLIER_NR - number of the supplier, according to the table SUPPLIERS.

GRA_TAB_NR - number of the table GRA_DATA_...

GRA_DATA_0-5

Graphic data. Binary-format.

GRD_ID - key

GRD_GRAPHIC - graphic data (binary)

DOC_TYPES

DOC_TYPE - key

DOC_EXTENSION - graphic data extension (bmp, jpg :)

SEARCH_TREE

Product groups tree (from child to parent)

STR_ID - key

STR_ID_PARENT - (reference to the parent list entry) =>STR_ID

STR_TYPE - product group type 1 - Passenger cars 2 - Commercial vehicles 3 - Engine 4 - Universal 5 - Axis

STR_LEVEL - nesting level (1- the highest level)

STR_DES_ID - designation of list entry (product group)

STR_SORT - sorting

STR_NODE_NR - node number

STR_FAMILY_TREE

From-ancestor-to-descendant product groups tree

SFT_ANCESTOR_STR_ID - (ancestor entry) the key with reference to the table SEARCH_TREE =>STR_ID

SFT_DESCENDANT_STR_ID - (descendant entry) the key with reference to the table SEARCH_TREE =>STR_ID

STR_LOOKUP

Product groups search tree

STL_LNG_ID - (search languauge) the key with reference to the table LANGUAGES=>LNG_ID

STL_SEARCH_TEXT - search text

STL_STR_ID - (product group) the key with reference to the table SEARCH_TREE=>STR_ID

STL_GA_ID - (a group of articles) the key with reference to GENERIC_ARTICLES=>GA_ID

///////////////////////////////////////////////////////////////////////////////////////////////////

// Criteria of spare parts and lists of parts relevance to cars.

// Criteria. The structure of criteria application in TecDoc 1.2005 has changed

///////////////////////////////////////////////////////////////////////////////////////////////////

// Display order is as follows:

// Shortened: it is used, when a lot of found numbers are displayed and it is necessary to display some of their properies as well.

// the result is as follows:

// [ARTICLES=>ART_ARTICLE_NR]

// [CRITERIA=>CRI_SHORT_DES_ID=>:]

// : (colon)

// [ARTICLE_CRITERIA=> ACR_VALUE] or [ARTICLE_CRITERIA=> KV_DES_ID=>:]

// [CRITERIA=>CRI_UNIT_DES_ID=>:]

// Full: when we look through the properties of the specific spare part

// [ARTICLES=>ART_ARTICLE_NR]

// [CRITERIA=>CRI_DES_ID=>:]

// = (equal sign)

// [ARTICLE_CRITERIA=> ACR_VALUE] or [ARTICLE_CRITERIA=> KV_DES_ID=>:]

CRITERIA

Criteria options

CRI_ID - key

CRI_DES_ID - (criterion description, it is not displayed in TecDoc) the key with reference to the table DESIGNATIONS=>DES_ID

CRI_SHORT_DES_ID - (brief criterion description) the key with reference to the table DESIGNATIONS=>DES_ID

CRI_UNIT_DES_ID - (criterion units) the key with reference to the table DESIGNATIONS=>DES_ID

CRI_TYPE - unknown

Text - criterion is a string. Sometimes even in English.

Numerical - a number. May be even a fraction.

Tip: consider all criteria values as a string and do not parse them into types.

A - (almost the same as N) text criterion, although it is contained in VALUE (ARTICLE_CRITERIA=>ACR_VALUE)

B - information number

D - release years (almost the same as N) text criterion, although it is contained in VALUE (ARTICLE_CRITERIA=>ACR_VALUE)

K - text criterion, its value is contained in DES_ID (ARTICLE_CRITERIA=>ACR_KV_DES_ID), KV_KT_ID value should also be considered for these criteria

N - numerical critrion, its value is contained in VALUE (ARTICLE_CRITERIA=>ACR_VALUE)

V - the criterion itself is a value. The fields DES_ID or VALUE are blank.

CRI_KT_ID - (possible installation options list, what for they need the list here - unknown) the key with reference to the table KEY_VALUES=>KV_KT_ID

CRI_IS_INTERVAL - determines whether this criterion is an interval of values or not (1/0)

CRI_SUCCESSOR - (Second criterion. Makes sense only if CRI_IS_INTERVAL=1) the key with reference to the table CRITERIA=>CRI_ID

ARTICLE_CRITERIA

The lists of criteria by articles with their values

ACR_ART_ID - (the part, the criteria are selected for) the key with reference to the table ARTICLES=>ART_ID

ACR_SORT - the field for data sorting in TecDoc format

ACR_CRI_ID - (criterion, name of criterion) the key with reference to the table CRITERIA=>CRI_ID

ACR_VALUE - criterion numerical value (if present)

ACR_KV_DES_ID - criterion string value (if present)

ACR_DISPLAY - determines whether to show the criterion together with the value (displays, not while viewing the spare part, but in the found list, in a small font, as a more detailed data on the spare part)

ARTICLE_LIST_CRITERIA

Criteria list for articles. It is used when the list of relevant cars to the spare part is displayed. Opposite each car the condition (exception) of use of the spare part with the given car is set. These conditions are the criteria in this table.

ALC_ALI_ART_ID - (the spare part, the criteria are selected for) the key with reference to the table ARTICLES=>ART_ID

ALC_ALI_SORT - the field for data sorting in TecDoc format (in order of criterion units)

ALC_SORT - the field for data sorting in TecDoc format (in order of criteria)

ALC_CRI_ID - the key with reference to the table CRITERIA=>CRI_ID

ALC_VALUE - criterion value

ALC_KV_DES_ID - criterion dimension

ALC_TYP_ID - (type of vehicle, the spare part with exceptions is used with) the key with reference to the table TYPES=>TYP_ID

ALC_ENG_ID - (type of engine , the spare part with exceptions is used with)

KEY_VALUES Table designation is unknown, as the same values in other tables can be simply acquired through DES_ID. List of values - key, subkey, value.

KV_KT_ID - key

KV_KV - unknown

KV_DES_ID - (name of key) the key with reference to the table DESIGNATIONS=>DES_ID

///////////////////////////////////////////////////////////////////////////////////////////////////

ENGINES Car engines table

• 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/?action=tecdoc_mysql_site