|
<< Click to Display Table of Contents >> Standard database structure |
  
|
|
<< Click to Display Table of Contents >> Standard database structure |
|
Detailed information about the format of the underlying database files is presented here.
Please note that the database structures has been updated several times over the years when new fields and field lengths have been added to support new functionality. The tables below describe the format that was introduced in cadett ELSA R43.0.1.2.
The table below lists all database files of a cadett ELSA catalogue.
Catalogue database files |
|
|---|---|
Database file |
Description |
*KT.DBF |
Catalogue main table |
*AL.DBF |
Numbering algorithm assignments |
*AP.DBF |
Physical dimensions and cabinet layout symbols |
*BE.DBF |
Long descriptions |
*IL.DBF |
Internet and external document links |
*JU.DBF |
Links for terminals |
*KL.DBF |
Symbol assignments |
*MT.DBF |
Resource groups |
*SC.DBF |
Extended Symbol and Connection data |
*KS.DBF |
Discontinued (symbol assignments) |
*LA.DBF |
Discontinued (user defined field definitions) |
*UD.DBF |
Discontinued (user defined fields) |
The tables below contain format descriptions (standard field lengths without user defined fields)
*KT.DBF (main table) |
||
|---|---|---|
Field name |
Length |
Description |
INDEX |
16 |
Index |
BESCHREIB |
40 |
Short description |
EL_DATEN |
40 |
Electrical data |
HERSTELLER |
30 |
Manufacturer |
LIEFERANT |
30 |
Supplier |
TYPE |
35 |
Type number |
BESTELL_NR |
35 |
Ordering number |
EINZ_PREIS |
8 |
Price |
RABATT |
5 |
Discount |
BESTAND |
4 |
Quantity in stock |
MIN_MENGE |
4 |
Ordering limit |
BESTELL_ME |
4 |
Ordering quantity |
GEWICHT |
9 |
Mass/weight |
VORZUGSTYP |
1 |
Obsolete (not used) |
MODUL_ANZ |
3 |
Module |
BTTYP |
1 |
Obsolete (not used) |
BGRPNR |
4 |
Resource Category |
VERSCHL_GR |
1 |
Wear group |
FRAGE |
1 |
Obsolete (not used) |
UPDATE |
10 |
Update number |
E_NUMMER |
9 |
E-number |
PREIS_EINH |
5 |
Currency (unit for price, for instance "EUR") |
GEW_EINH |
5 |
Unit for mass (for instance "kg") |
MENGE_EINH |
5 |
Unit for quantity (for instance "pieces") |
DESTYPE |
1 |
Document type |
*AL.DBF (numbering algorithm assignments) |
||
|---|---|---|
Field name |
Length |
Description |
INDEX |
16 |
Index |
ALGONAME |
18 |
Numbering algorithm |
LIMIT |
4 |
Limit |
*AP.DBF (physical dimensions and cabinet layout symbol) |
||
|---|---|---|
Field name |
Length |
Description |
INDEX |
16 |
Index |
MESYMBOL |
8 |
Cabinet layout symbol |
HOEHE |
FLOAT |
Height |
BREITE |
FLOAT |
Width |
TIEFE |
FLOAT |
Depth |
MASS_EINH |
5 |
Unit for size (for example "mm") |
LAY_T |
40 |
2D symbol, top view |
LAY_D |
40 |
2D symbol, down bottom view |
LAY_L |
40 |
2D symbol, left view |
LAY_R |
40 |
2D symbol, right view |
LAY_F |
40 |
2D symbol, front view |
LAY_B |
40 |
2D symbol, back view |
LAY_3D1 |
40 |
3D symbol, standard |
LAY_3D2 |
40 |
3D symbol, simplified |
IMAGE |
40 |
Picture (photograph) |
*BE.DBF (long descriptions) |
||
|---|---|---|
Field name |
Length |
Description |
INDEX |
16 |
Index |
BESCHR1 |
68 |
Long description, line 1 |
BESCHR2 |
68 |
Long description, line 2 |
BESCHR3 |
68 |
Long description, line 3 |
BESCHR4 |
68 |
Long description, line 4 |
BESCHR5 |
68 |
Long description, line 5 |
*IL.DBF (information links) |
||
|---|---|---|
Field name |
Length |
Description |
INDEX |
16 |
Index |
INFOLINK |
250 |
Information link |
*JU.DBF (link limitations for terminals) |
||
|---|---|---|
Field name |
Length |
Description |
INDEX |
16 |
Index |
JLI |
5 |
Max. length of link on internal side |
JSI |
5 |
Max. no of terminals to skip on internal side |
JPI |
1 |
Max. no. of parallel links on internal side |
JCI |
1 |
Max. no. of connected links on internal side |
JLE |
5 |
Max. length of link on external side |
JSE |
5 |
Max. no of terminals to skip on external side |
JPE |
1 |
Max. no. of parallel links on external side |
JCE |
1 |
Max. no. of connected links on external side |
*KL.DBF (symbol assignments) |
||
|---|---|---|
Field name |
Length |
Description |
INDEX |
16 |
Index |
SYMBD_NORM |
10 |
Symbol standard (norm) |
ELSYMBOL |
8 |
Symbol name |
ORDER |
3 |
Insert sequence |
K1 |
8 |
Reserved for future use |
K2 |
8 |
Reserved for future use |
K3 |
8 |
Reserved for future use |
GROUP |
10 |
Symbol group |
DOCTYPE |
1 |
Document type |
NOCHECK |
1 |
Do not check for inconsistency |
*MT.DBF (resource group structures) |
||
|---|---|---|
Field name |
Length |
Description |
INDEX |
16 |
Index |
MULTI |
16 |
Sub-index |
ANZAHL |
3 |
Number of devices with specified sub-index |
SC.DBF (symbols and connections) |
||
|---|---|---|
Field name |
Length |
Description |
INDEX |
16 |
Index |
REC |
INTEGER |
Record number within resource |
LNR |
INTEGER |
Counting number corresponding to symbol for main/help symbols |
ART |
10 |
Function code (indirectly specifies number of records for the function) |
NORM |
10 |
Symbol standard for symbol specified in SYM |
DOCTYPE |
1 |
Document type for symbol specified in SYM |
SYM |
8 |
cadett ELSA symbol |
AP |
15 |
Connection point number |
ADR |
40 |
I/O number (physical address) for PLC |
X |
FLOAT |
Physical X position for connection point relative to reference point (mm) |
Y |
FLOAT |
Physical Y position for connection point relative to reference point (mm) |
Z |
FLOAT |
Physical Z position for connection point relative to reference point (mm) |
DIR |
2 |
Direction of the connection point (possible values: +X, -X, +Y, -Y, +Z, -Z) |