Changes between Initial Version and Version 1 of RelationalDesign


Ignore:
Timestamp:
02/20/24 01:19:50 (4 months ago)
Author:
201156
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v1 v1  
     1Firma (FirmaID(PK), Naziv, Adresa, Broj)
     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)
     6
     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))