Version 1 (modified by 3 months ago) ( diff ) | ,
---|
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