Firma (FirmaID(PK), Naziv, Adresa, Broj)
Artikl (ArtiklID(PK), Naziv, Cena, EdMera, StapkaDDV, Zaliha)
Naracka (NarackaID(PK), Kolicina, Datum, Opis)
IzrabotkaPlan (DatumStart, DatumEnd)
Faktura (FakturaID(PK), Datum, Iznos, Broj)
Naracka_Artikl (NarackaID(FK), ArtiklID(FK), PRIMARY KEY(NarackaID, ArtiklID))
Naracka_IzrabotkaPlan (NarackaID(FK), DatumStart, DatumEnd, PRIMARY KEY(NarackaID, DatumStart, DatumEnd))
Naracka_Firma (NarackaID(FK), FirmaID(FK), PRIMARY KEY(NarackaID, FirmaID))
Faktura_Firma (FakturaID(FK), FirmaID(FK), PRIMARY KEY(FakturaID, FirmaID))
Faktura_Naracka (FakturaID(FK), NarackaID(FK), PRIMARY KEY(FakturaID, NarackaID))
Attachments (3)
- kreiranje.sql (2.0 KB ) - added by 3 months ago.
- polnenje.sql (441 bytes ) - added by 3 months ago.
- schema.png (23.9 KB ) - added by 3 months ago.
Download all attachments as: .zip