|
Štruktúra databáz verzie 2.0
| Clipart.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| Customer |
A |
10 |
* |
|
| Article |
A |
5 |
* |
|
| Model |
A |
5 |
* |
|
| Bmp |
G |
|
|
|
| Customer.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| Customer |
A |
10 |
|
|
| Country |
A |
3 |
|
|
| City |
A |
10 |
|
|
| Street |
A |
10 |
|
|
| Delivery.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| DelNo |
I |
|
* |
|
| PackNo |
I |
|
* |
|
| DelDate |
D |
|
|
|
| SectNo |
S |
|
|
|
| Employee.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| EmpNo |
I |
|
* |
|
| Name |
A |
30 |
|
|
| Price |
S |
|
|
|
| SectNo |
S |
|
|
|
| Fulfil.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
Secondary |
| PackNo |
I |
|
* |
"EmpKey" |
| OperNo |
I |
|
* |
EmpNo |
| EmpNo |
I |
|
* |
Date |
| Date |
D |
|
|
|
| Price |
N |
|
|
|
| Qty |
I |
|
|
|
| Interval.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| OperFrom |
I |
|
|
|
| OperTo |
I |
|
|
|
| Desc |
A |
30 |
|
|
| Color |
I |
|
|
|
| Oper.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| OperNo |
I |
|
* |
|
| Desc |
A |
60 |
|
|
| Norm |
S |
|
|
|
| Price1 |
N |
|
|
|
| Price2 |
N |
|
|
|
| Used |
L |
|
|
|
| Orders1.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| OrdNo |
A |
7 |
|
|
| Article |
A |
5 |
|
|
| Model |
A |
5 |
|
|
| Variant |
A |
5 |
|
|
| Qty |
I |
|
|
|
| Term |
A |
10 |
|
|
| Percent |
S |
|
|
|
| Time |
A |
12 |
|
|
| Ordersi.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| Customer |
A |
10 |
* |
|
| OrdNo |
A |
7 |
* |
|
| Article |
A |
5 |
* |
|
| Model |
A |
5 |
* |
|
| Variant |
A |
5 |
* |
|
| Size |
A |
10 |
* |
|
| Qty |
I |
|
|
|
| Orderst.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| Customer |
A |
10 |
* |
|
| OrdNo |
A |
7 |
* |
|
| Article |
A |
5 |
* |
|
| Model |
A |
5 |
* |
|
| Variant |
A |
5 |
* |
|
| Term |
D |
|
|
|
| Pack.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
Secondary |
| PackNo |
I |
|
* |
"CustKey" |
| SectNo |
S |
|
|
Customer |
| Customer |
A |
10 |
|
OrdNo |
| OrdNo |
A |
7 |
|
Article |
| Article |
A |
5 |
|
Model |
| Model |
A |
5 |
|
Variant |
| Variant |
A |
5 |
|
|
| Term |
D |
|
|
|
| Size |
A |
10 |
|
|
| Qty |
I |
|
|
|
| Bath |
S |
|
|
|
| Printed |
L |
|
|
|
| Pack1.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| OrdNo |
A |
7 |
* |
|
| Article |
A |
5 |
* |
|
| Model |
A |
5 |
* |
|
| Variant |
A |
5 |
* |
|
| PackNo |
I |
|
* |
|
| SectNo |
S |
|
|
|
| Qty |
I |
|
|
|
| Size |
A |
10 |
|
|
| Percent |
S |
|
|
|
| Time |
A |
12 |
|
|
| Procedure.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| Customer |
A |
10 |
* |
|
| Article |
A |
5 |
* |
|
| Model |
A |
5 |
* |
|
| No |
S |
|
* |
|
| OperNo |
I |
|
|
|
| Section.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| SectNo |
S |
|
* |
|
| Name |
A |
20 |
|
|
| Wage.DBF |
| Pole |
Typ |
Dľžka |
Des.miesto |
|
| EmpNo |
N |
5 |
0 |
|
| Name |
C |
30 |
|
|
| Sum |
N |
14 |
2 |
|
Štruktúra databáz verzie 1.9
| Employee.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| EmpNo |
I |
|
* |
|
| Name |
A |
30 |
|
|
| Price |
S |
|
|
|
| Orders1.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| Key |
A |
20 |
|
|
| OrdNo |
I |
|
|
|
| Article |
A |
5 |
|
|
| Model |
A |
5 |
|
|
| Variant |
A |
5 |
|
|
| Qty |
I |
|
|
|
| Term |
A |
10 |
|
|
| Percent |
S |
|
|
|
| Time |
A |
12 |
|
|
| Ordersi.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| Customer |
A |
10 |
* |
|
| OrdNo |
I |
|
* |
|
| Article |
A |
5 |
* |
|
| Model |
A |
5 |
* |
|
| Variant |
A |
5 |
* |
|
| Size |
A |
5 |
* |
|
| Qty |
I |
|
|
|
| Orderst.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| Customer |
A |
10 |
* |
|
| OrdNo |
I |
|
* |
|
| Article |
A |
5 |
* |
|
| Model |
A |
5 |
* |
|
| Variant |
A |
5 |
* |
|
| Term |
D |
|
|
|
| Pack.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
Secondary |
| PackNo |
I |
|
* |
"CustKey" |
| SectNo |
S |
|
|
Customer |
| Customer |
A |
10 |
|
OrdNo |
| OrdNo |
I |
|
|
Article |
| Article |
A |
5 |
|
Model |
| Model |
A |
5 |
|
Variant |
| Variant |
A |
5 |
|
|
| Term |
D |
|
|
|
| Size |
A |
5 |
|
|
| Qty |
I |
|
|
|
| Bath |
S |
|
|
|
| Printed |
L |
|
|
|
| Pack1.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| Key |
A |
20 |
* |
|
| PackNo |
I |
|
* |
|
| SectNo |
S |
|
|
|
| Qty |
I |
|
|
|
| Size |
A |
5 |
|
|
| Percent |
S |
|
|
|
| Time |
A |
12 |
|
|
Štruktúra databáz verzie 1.8
| Orders.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| Customer |
A |
10 |
* |
|
| OrdNo |
I |
|
* |
|
| Article |
A |
5 |
* |
|
| Model |
A |
5 |
* |
|
| Variant |
A |
5 |
* |
|
| Term |
D |
|
|
|
| S1 |
I |
|
|
|
| S2 |
I |
|
|
|
| S3 |
I |
|
|
|
| S4 |
I |
|
|
|
| S5 |
I |
|
|
|
| S6 |
I |
|
|
|
| S7 |
I |
|
|
|
| S8 |
I |
|
|
|
| Sizes.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| Customer |
A |
10 |
* |
|
| OrdFrom |
I |
|
* |
|
| OrdTo |
I |
|
|
|
| S1 |
A |
5 |
|
|
| S2 |
A |
5 |
|
|
| S3 |
A |
5 |
|
|
| S4 |
A |
5 |
|
|
| S5 |
A |
5 |
|
|
| S6 |
A |
5 |
|
|
| S7 |
A |
5 |
|
|
| S8 |
A |
5 |
|
|
Štruktúra databáz verzie 1.7
Pribudol súbor Clipart.DB
Štruktúra databáz verzie 1.6
| Oper.DB |
| Pole |
Typ |
Dľžka |
Kľúč |
|
| OperNo |
I |
|
* |
|
| Desc |
A |
30 |
|
|
| Norm |
S |
|
|
|
| Price1 |
N |
|
|
|
| Price2 |
N |
|
|
|
| Used |
L |
|
|
|
|
|