Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- tabulka OBJEDNAVKY
- id_objednavky | kdo | kdy | blablabla
- -------------------------------------
- 1 | ...
- 2 | ...
- .
- .
- .
- tabulka KOSIKY
- id_objednavky | id_zbozi | pocet | blablabla
- --------------------------------------------
- 2 | 51 | 3 | ...
- 2 | 20 | 1 | ...
- 1 | 21 | 10 | ...
- 1 | 20 | 1 | ...
- 1 | 99 | 2 | ...
- .
- .
- .
- clovek ktereho jsi zapsal do objednavky 2, si objednal tri kusy zbozi 51 a jeden kus zbozi 20
- ten co ma objednavku 1 si koupil 10x zbozi 21, 1x zbozi 20, 2x zbozi 99
- a dalsi objednavky dle libosti, staci ti na to dve tabulky
Add Comment
Please, Sign In to add comment