4HzUVJRd

1DROP TABLE IF EXISTS artikl CASCADE;
2DROP TABLE IF EXISTS dobavljac CASCADE;
3DROP TABLE IF EXISTS porudzbna CASCADE;
4DROP TABLE IF EXISTS stavka_porudzbine CASCADE;
5 
6DROP SEQUENCE IF EXISTS artikl_seq;
7DROP SEQUENCE IF EXISTS dobavljac_seq;
8DROP SEQUENCE IF EXISTS porudzbina_seq;
9DROP SEQUENCE IF EXISTS stavka_porudzbine_seq;
10 
11CREATE TABLE artikl (
12    id integer not null,
13    naziv varchar(50) not null,
14    proizvodjac varchar(50)
15);
16 
17CREATE TABLE dobavljac (
18    id integer not null,
19    naziv varchar(50) not null,
20    adresa varchar(200) not null,
21    contact varchar(100) not null
22);
23 
24CREATE TABLE porudzbina (
25    id integer not null,
26    datum date not null,
27    isporuceno date not null,
28    iznos numeric not null,
29    placeno boolean,
30    dobavljac integer not null
31);
32 
33CREATE TABLE stavka_porudzbine (
34    id integer not null,
35    redni_broj integer not null,
36    kolicina numeric not null,
37    jedinica_mere varchar(50) not null,
38    cena numeric not null,
39    porudzbina integer not null,
40    artikl integer not null
41);
42 
43ALTER TABLE artikl ADD CONSTRAINT PK_Artikl
44PRIMARY KEY(id);
45ALTER TABLE dobavljac ADD CONSTRAINT PK_Dobavljac
46PRIMARY KEY(id);
47ALTER TABLE porudzbina ADD CONSTRAINT PK_Porudzbina
48PRIMARY KEY(id);
49ALTER TABLE stavka_porudzbine ADD CONSTRAINT PK_Stavka_porudzbine
50PRIMARY KEY(id);
51
52ALTER TABLE porudzbina ADD CONSTRAINT FK_Proudzbina_dobavljac
53FOREIGN KEY(dobavljac) REFERENCES dobavljac(id);
54ALTER TABLE stavka_porudzbine ADD CONSTRAINT FK_Stavka_porudzbine_porudzbina
55FOREIGN KEY(porudzbina) REFERENCES porudzbina(id);
56ALTER TABLE stavka_porudzbine ADD CONSTRAINT FK_Stavka_porudzbine_artikl
57FOREIGN KEY(artikl) REFERENCES artikl(id);
58
59CREATE INDEX IDXFK_Porudzbina_dobavljac
60ON porudzbina(dobavljac)
61CREATE INDEX IDXFK_Stavka_porudzbine_porudzbina
62ON stavka_porudzbine(porudzbina);
63CREATE INDEX IDXFK_Stavka_porudzbine_artikl
64ON stavka_porudzbine(artikl);
65
66CREATE SEQUENCE artikl_seq
67INCREMENT 1;
68CREATE SEQUENCE dobavljac_seq
69INCREMENT 1;
70CREATE SEQUENCE porudzbina_seq
71INCREMENT 1;
72CREATE SEQUENCE stavka_porudzbine_seq
73INCREMENT 1;