1 | --Create Tables
|
---|
2 | CREATE TABLE Firma (
|
---|
3 | FirmaID SERIAL PRIMARY KEY,
|
---|
4 | Adresa VARCHAR(255),
|
---|
5 | Broj VARCHAR(255)
|
---|
6 | )
|
---|
7 |
|
---|
8 | CREATE TABLE Artikl (
|
---|
9 | ArtiklID SERIAL PRIMARY KEY,
|
---|
10 | Cena DECIMAL,
|
---|
11 | EdMera VARCHAR(255),
|
---|
12 | StapkaDDV DECIMAL,
|
---|
13 | Zaliha INT
|
---|
14 | )
|
---|
15 |
|
---|
16 | CREATE TABLE Naracka (
|
---|
17 | NarackaID SERIAL PRIMARY KEY,
|
---|
18 | Kolicina INT,
|
---|
19 | Datum DATE,
|
---|
20 | Opis TEXT
|
---|
21 | )
|
---|
22 |
|
---|
23 | CREATE TABLE IzrabotkaPlan (
|
---|
24 | DatumStart DATE,
|
---|
25 | DatumEnd DATE
|
---|
26 | )
|
---|
27 |
|
---|
28 | CREATE TABLE Faktura (
|
---|
29 | FakturaID SERIAL PRIMARY KEY,
|
---|
30 | Datum DATE,
|
---|
31 | Iznos DECIMAL,
|
---|
32 | Broj VARCHAR(255)
|
---|
33 | )
|
---|
34 |
|
---|
35 |
|
---|
36 | CREATE TABLE Naracka_Artikl (
|
---|
37 | NarackaID INT,
|
---|
38 | ArtiklID INT,
|
---|
39 | Kolicina INT,
|
---|
40 | CenaPriNaracka INT,
|
---|
41 | FOREIGN KEY (NarackaID) REFERENCES Naracka(NarackaID),
|
---|
42 | FOREIGN KEY (ArtiklID) REFERENCES Artikl(ArtiklID),
|
---|
43 | PRIMARY KEY (NarackaID, ArtiklID)
|
---|
44 | )
|
---|
45 |
|
---|
46 | CREATE TABLE Naracka_IzrabotkaPlan (
|
---|
47 | NarackaID INT,
|
---|
48 | DatumStart DATE,
|
---|
49 | DatumEnd DATE,
|
---|
50 | FOREIGN KEY (NarackaID) REFERENCES Naracka(NarackaID),
|
---|
51 | PRIMARY KEY (NarackaID, DatumStart, DatumEnd)
|
---|
52 | )
|
---|
53 |
|
---|
54 | CREATE TABLE Naracka_Firma (
|
---|
55 | NarackaID INT,
|
---|
56 | FirmaID INT,
|
---|
57 | FOREIGN KEY (NarackaID) REFERENCES Naracka(NarackaID),
|
---|
58 | FOREIGN KEY (FirmaID) REFERENCES Firma(FirmaID),
|
---|
59 | PRIMARY KEY (NarackaID, FirmaID)
|
---|
60 | )
|
---|
61 |
|
---|
62 | CREATE TABLE Faktura_Firma (
|
---|
63 | FakturaID INT,
|
---|
64 | FirmaID INT,
|
---|
65 | FOREIGN KEY (FakturaID) REFERENCES Faktura(FakturaID),
|
---|
66 | FOREIGN KEY (FirmaID) REFERENCES Firma(FirmaID),
|
---|
67 | PRIMARY KEY (FakturaID, FirmaID)
|
---|
68 | )
|
---|
69 |
|
---|
70 | CREATE TABLE Faktura_Naracka (
|
---|
71 | FakturaID INT,
|
---|
72 | NarackaID INT,
|
---|
73 | FOREIGN KEY (FakturaID) REFERENCES Faktura(FakturaID),
|
---|
74 | FOREIGN KEY (NarackaID) REFERENCES Naracka(NarackaID),
|
---|
75 | PRIMARY KEY (FakturaID, NarackaID)
|
---|
76 | )
|
---|