Parametry tabulky: Cukr cukr_prevod
| id |
int(11) |
not_null primary_key auto_increment |
primary_key auto_increment |
| datum |
timestamp(19) |
not_null unsigned zerofill binary timestamp |
|
| ---------------------- |
| cislo |
int(11) |
not_null multiple_key |
multiple_key |
| carovy |
int(20) |
not_null multiple_key |
multiple_key |
| nazev |
string(50) |
not_null |
|
| popis |
string(255) |
not_null |
|
| zkratka |
string(20) |
not_null multiple_key |
multiple_key |
| oblast |
string(10) |
not_null multiple_key |
multiple_key |
| podoblast |
string(10) |
not_null |
|
| foto |
string(150) |
not_null |
|
| poznamka |
string(255) |
not_null |
|
| vlozil |
string(32) |
not_null |
|
| upravil |
string(32) |
not_null |
|
| zasoba_min |
real(12) |
not_null |
|
| zasoba_ok |
real(12) |
not_null |
|
| zasoba_max |
real(12) |
not_null |
|
Parametry tabulky: Ceny ceny
| id_ceny |
int(11) |
not_null primary_key auto_increment |
primary_key auto_increment |
| datum |
timestamp(19) |
not_null unsigned zerofill binary timestamp |
| | ---------------------- |
| id_cukr_prevod |
int(11) |
not_null multiple_key |
multiple_key |
| zadal |
string(32) |
not_null |
|
| c1 |
real(12) |
not_null |
|
| c2 |
real(12) |
not_null |
|
| c3 |
real(12) |
not_null |
|
| dodano |
real(12) |
not_null |
|
| mnozstvi |
real(12) |
not_null |
|
| trvanlivost |
datetime(19) |
not_null binary |
|
| odpis |
real(12) |
not_null |
|
| ceny_poznamka |
string(255) |
not_null |
| |
Parametry tabulky: Prodej prodej
| id_prodej |
int(11) |
not_null primary_key auto_increment |
primary_key auto_increment |
| datum |
timestamp(19) |
not_null multiple_key unsigned zerofill binary timestamp |
multiple_key | | ---------------------- |
| cislo |
int(11) |
not_null multiple_key |
multiple_key |
| carovy |
int(20) |
not_null |
|
| nazev |
string(32) |
not_null |
|
| cena |
real(12) |
not_null |
|
| kusu |
real(12) |
not_null |
|
| c1 |
real(12) |
not_null |
|
| c2 |
real(12) |
not_null |
|
| c3 |
real(12) |
not_null |
|
| ucet |
string(32) |
not_null |
|
| prodal |
string(32) |
not_null multiple_key |
multiple_key |
| poznamka |
string(60) |
not_null |
| |
Parametry tabulky: Inventura inventura
| id_inventura |
int(11) |
not_null primary_key auto_increment |
primary_key auto_increment |
| datum |
timestamp(19) |
not_null unsigned zerofill binary timestamp |
| | ---------------------- |
| id_zbozi |
int(11) |
not_null multiple_key |
multiple_key |
| cislo_inventury |
int(11) |
not_null |
|
| cislo |
int(11) |
not_null multiple_key |
multiple_key |
| carovy |
string(20) |
not_null multiple_key |
multiple_key |
| pom_nazev |
string(32) |
not_null multiple_key |
multiple_key |
| pom_c3 |
real(12) |
not_null |
|
| kusu |
real(12) |
not_null |
|
| trvanlivost |
date(10) |
not_null binary |
|
| poznamka |
string(255) |
not_null |
|
| umisteni |
string(60) |
not_null |
|
| x |
real(12) |
not_null |
|
| y |
real(12) |
not_null |
|
| z |
real(12) |
not_null |
| |
Parametry tabulky: Akce akce
| id_akce |
int(11) |
not_null primary_key auto_increment |
primary_key auto_increment |
| datum |
timestamp(19) |
not_null unsigned zerofill binary timestamp |
| | ---------------------- |
| cislo |
int(11) |
not_null multiple_key |
multiple_key |
| od |
datetime(19) |
not_null binary |
|
| do |
datetime(19) |
not_null binary |
|
| cena |
real(12) |
not_null |
| |
Parametry tabulky: Dodavatele dodavatele
| id_dodavatele |
int(11) |
not_null primary_key |
primary_key |
| datum |
datetime(19) |
not_null binary |
| | ---------------------- |
| nazev |
string(32) |
not_null multiple_key |
multiple_key |
| cely_nazev |
string(100) |
not_null |
|
| oblast |
string(32) |
not_null |
|
| dodavky_dne |
string(32) |
not_null |
|
| telefon |
string(32) |
not_null |
|
| adresa |
string(50) |
not_null |
|
| poznamka |
string(255) |
not_null |
|
| logo |
string(120) |
not_null |
| |
Cukr cukr_prevod
| id |
| datum |
| ---------------------- |
| cislo |
| carovy |
| nazev |
| popis |
| zkratka |
| oblast |
| podoblast |
| foto |
| poznamka |
| vlozil |
| upravil |
| zasoba_min |
| zasoba_ok |
| zasoba_max |
|
| Ceny ceny
| id_ceny |
| datum |
| ---------------------- |
| id_cukr_prevod |
| zadal |
| c1 |
| c2 |
| c3 |
| dodano |
| mnozstvi |
| trvanlivost |
| odpis |
| ceny_poznamka |
|
| Prodej prodej
| id_prodej |
| datum |
| ---------------------- |
| cislo |
| carovy |
| nazev |
| cena |
| kusu |
| c1 |
| c2 |
| c3 |
| ucet |
| prodal |
| poznamka |
|
| Inventura inventura
| id_inventura |
| datum |
| ---------------------- |
| id_zbozi |
| cislo_inventury |
| cislo |
| carovy |
| pom_nazev |
| pom_c3 |
| kusu |
| trvanlivost |
| poznamka |
| umisteni |
| x |
| y |
| z |
|
| Akce akce
| id_akce |
| datum |
| ---------------------- |
| cislo |
| od |
| do |
| cena |
|
| Dodavatele dodavatele
| id_dodavatele |
| datum |
| ---------------------- |
| nazev |
| cely_nazev |
| oblast |
| dodavky_dne |
| telefon |
| adresa |
| poznamka |
| logo |
|
|
Tabulka Cukr obsahuje zakladni data o zbozi, ceny se vztahuje k dodavce, prodej zaznamenava prodane zbozi.
Vazba cukr - ceny prez cukr.id na ceny.id_cukr_prevod
|