wiki:RelationalDesign

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))

UseCaseModel


Last modified 3 months ago Last modified on 02/20/24 15:38:21

Attachments (3)

Download all attachments as: .zip

Note: See TracWiki for help on using the wiki.