2 | | **Artikl (ArtiklID(PK), Naziv, Cena, EdMera, StapkaDDV, Zaliha) |
3 | | **Naracka (NarackaID(PK), Kolicina, Datum, Opis) |
4 | | **IzrabotkaPlan (DatumStart, DatumEnd) |
5 | | **Faktura (FakturaID(PK), Datum, Iznos, Broj) |
7 | | **Naracka_Artikl (NarackaID(FK), ArtiklID(FK), PRIMARY KEY(NarackaID, ArtiklID)) |
8 | | **Naracka_IzrabotkaPlan (NarackaID(FK), DatumStart, DatumEnd, PRIMARY KEY(NarackaID, DatumStart, DatumEnd)) |
9 | | **Naracka_Firma (NarackaID(FK), FirmaID(FK), PRIMARY KEY(NarackaID, FirmaID)) |
10 | | **Faktura_Firma (FakturaID(FK), FirmaID(FK), PRIMARY KEY(FakturaID, FirmaID)) |
11 | | **Faktura_Naracka (FakturaID(FK), NarackaID(FK), PRIMARY KEY(FakturaID, NarackaID)) |
| 3 | Artikl (ArtiklID(PK), Naziv, Cena, EdMera, StapkaDDV, Zaliha) |
| 4 | |
| 5 | Naracka (NarackaID(PK), Kolicina, Datum, Opis) |
| 6 | |
| 7 | IzrabotkaPlan (DatumStart, DatumEnd) |
| 8 | |
| 9 | Faktura (FakturaID(PK), Datum, Iznos, Broj) |
| 10 | |
| 11 | Naracka_Artikl (NarackaID(FK), ArtiklID(FK), PRIMARY KEY(NarackaID, ArtiklID)) |
| 12 | |
| 13 | Naracka_IzrabotkaPlan (NarackaID(FK), DatumStart, DatumEnd, PRIMARY KEY(NarackaID, DatumStart, DatumEnd)) |
| 14 | |
| 15 | Naracka_Firma (NarackaID(FK), FirmaID(FK), PRIMARY KEY(NarackaID, FirmaID)) |
| 16 | |
| 17 | Faktura_Firma (FakturaID(FK), FirmaID(FK), PRIMARY KEY(FakturaID, FirmaID)) |
| 18 | |
| 19 | Faktura_Naracka (FakturaID(FK), NarackaID(FK), PRIMARY KEY(FakturaID, NarackaID)) |
| 20 | |
| 21 | |
| 22 | ---- |
| 23 | [[Image(schema.png)]] |