1 |
DROP SEQUENCE "qualification_sifra_seq"; |
2 |
DROP TABLE "qualification"; |
3 |
CREATE TABLE "qualification" ( |
4 |
"sifra" SERIAL, |
5 |
"opis" text, |
6 |
PRIMARY KEY (sifra) |
7 |
); |
8 |
|
9 |
DROP TABLE "org_jed"; |
10 |
CREATE TABLE "org_jed" ( |
11 |
"sifra" text NOT NULL, |
12 |
"opis" text, |
13 |
"language" character varying(2) DEFAULT 'HR' NOT NULL, |
14 |
PRIMARY KEY (sifra) |
15 |
); |
16 |
|
17 |
DROP SEQUENCE "vrsta_strucne_spreme_sifra_seq"; |
18 |
DROP TABLE "vrsta_strucne_spreme"; |
19 |
CREATE TABLE "vrsta_strucne_spreme" ( |
20 |
"sifra" SERIAL, |
21 |
"opis" text, |
22 |
"language" character varying(2) DEFAULT 'HR' NOT NULL, |
23 |
PRIMARY KEY (sifra) |
24 |
); |
25 |
|
26 |
DROP SEQUENCE "strucne_sprem_sif_str_sprem_seq"; |
27 |
DROP TABLE "strucne_spreme"; |
28 |
CREATE TABLE "strucne_spreme" ( |
29 |
"stupanj" text NOT NULL, |
30 |
"sif_vrsta_str_spreme" integer references vrsta_strucne_spreme(sifra), |
31 |
"sif_str_spreme" SERIAL, |
32 |
"sap" text, |
33 |
"language" character varying(2) DEFAULT 'HR' NOT NULL, |
34 |
PRIMARY KEY (sif_str_spreme) |
35 |
); |
36 |
|
37 |
DROP SEQUENCE "ustanove_sifra_seq"; |
38 |
DROP TABLE "ustanove"; |
39 |
CREATE TABLE "ustanove" ( |
40 |
"sifra" SERIAL, |
41 |
"naziv" character varying(250) NOT NULL, |
42 |
"grad" text, |
43 |
"mjesto" text, |
44 |
"date_lupdate" date DEFAULT 'now', |
45 |
"language" character varying(2) DEFAULT 'HR' NOT NULL, |
46 |
PRIMARY KEY (sifra) |
47 |
); |
48 |
|
49 |
DROP SEQUENCE "obrazovna_ustanova_sifra_seq"; |
50 |
DROP TABLE "obrazovna_ustanova"; |
51 |
CREATE TABLE "obrazovna_ustanova" ( |
52 |
"sifra" SERIAL, |
53 |
"naziv" text NOT NULL, |
54 |
"grad" text, |
55 |
"datum_lupdate" date DEFAULT 'now', |
56 |
"language" character varying(2) DEFAULT 'HR' NOT NULL, |
57 |
PRIMARY KEY (sifra) |
58 |
); |
59 |
|
60 |
DROP SEQUENCE "strani_jezik_sifra_seq"; |
61 |
DROP TABLE "strani_jezik"; |
62 |
CREATE TABLE "strani_jezik" ( |
63 |
"sifra" SERIAL, |
64 |
"opis" text, |
65 |
"datum_lupdate" date DEFAULT 'now', |
66 |
"language" character varying(2) DEFAULT 'HR' NOT NULL, |
67 |
PRIMARY KEY (sifra) |
68 |
); |
69 |
|
70 |
DROP SEQUENCE "stupanj_str_jezika_sifra_seq"; |
71 |
DROP TABLE "stupanj_str_jezika"; |
72 |
CREATE TABLE "stupanj_str_jezika" ( |
73 |
"sifra" SERIAL, |
74 |
"stupanj" text, |
75 |
"opis" text, |
76 |
"language" character varying(2) DEFAULT 'HR' NOT NULL, |
77 |
PRIMARY KEY (sifra) |
78 |
); |
79 |
|
80 |
DROP SEQUENCE "osoba_sif_radnika_seq"; |
81 |
DROP TABLE "osoba"; |
82 |
CREATE TABLE "osoba" ( |
83 |
"sif_radnika" SERIAL, |
84 |
"ime" character varying(100) NOT NULL, |
85 |
"prezime" character varying(100) NOT NULL, |
86 |
"naziv_struke" text, |
87 |
"sif_org_jed" text REFERENCES org_jed(sifra), |
88 |
"radna_jedinica" text, |
89 |
"radno_mjesto" text, |
90 |
"spol" character varying(1) CHECK (spol = 'M' OR spol = 'F'), |
91 |
"datum_rodjenja" date, |
92 |
"stupanj_str_spreme" text, |
93 |
"smjer" text, |
94 |
"titula" text, |
95 |
"telefon" character varying(50), |
96 |
"email" character varying(250), |
97 |
"language" character varying(2) DEFAULT 'HR' NOT NULL |
98 |
); |
99 |
|
100 |
DROP SEQUENCE "certifikati_sif_edukacije_seq"; |
101 |
DROP TABLE "certifikati"; |
102 |
CREATE TABLE "certifikati" ( |
103 |
"sif_edukacije" SERIAL, |
104 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
105 |
"sif_ustanove" integer REFERENCES ustanove(sifra), |
106 |
"naziv" text, |
107 |
"titula" text, |
108 |
"dat_izdavanja" date, |
109 |
"dat_polaganja" date, |
110 |
"dat_vrijedi_do" date, |
111 |
"xxxx" text, |
112 |
PRIMARY KEY (sif_edukacije) |
113 |
); |
114 |
|
115 |
DROP SEQUENCE "tecajevi_sifra_seq"; |
116 |
DROP TABLE "tecajevi"; |
117 |
CREATE TABLE "tecajevi" ( |
118 |
"sifra" SERIAL, |
119 |
"naziv" text NOT NULL, |
120 |
"xxxx" text, |
121 |
"sif_qualification" integer REFERENCES qualification(sifra), |
122 |
"language" character varying(2) DEFAULT 'HR' NOT NULL, |
123 |
PRIMARY KEY (sifra) |
124 |
); |
125 |
|
126 |
DROP SEQUENCE "edukacije_sifra_seq"; |
127 |
DROP TABLE "edukacije"; |
128 |
CREATE TABLE "edukacije" ( |
129 |
"sifra" SERIAL, |
130 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
131 |
"naziv" text, |
132 |
"sif_ustanove" integer REFERENCES obrazovna_ustanova(sifra), |
133 |
"datum_upisa" date, |
134 |
"datum_zavrsetka" date, |
135 |
"ukupno_ispita" smallint, |
136 |
"polozenih_ispita" smallint, |
137 |
"ukupno_semestara" smallint, |
138 |
"polozenih_semestara" smallint, |
139 |
"zavrsio_ispitom" boolean default false, |
140 |
"sif_qualification" integer references qualification(sifra), |
141 |
"sif_tecaja" integer references tecajevi(sifra), |
142 |
"stupanj_str_jezika" integer references stupanj_str_jezika(sifra), |
143 |
"sif_stranog_jezika" integer references strani_jezik(sifra), |
144 |
"date_lupdate" date, |
145 |
"sif_strucna_sprema" integer references strucne_spreme(sif_str_spreme), |
146 |
"grad_odrzavanja_tecaja" text, |
147 |
"titula" text, |
148 |
PRIMARY KEY (sifra) |
149 |
); |
150 |
|
151 |
DROP SEQUENCE "izvan_plive_id_seq"; |
152 |
DROP TABLE "izvan_plive"; |
153 |
CREATE TABLE "izvan_plive" ( |
154 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
155 |
"tvrtka" text, |
156 |
"radno_mjesto" text, |
157 |
"zadaci" text, |
158 |
"datum_od" date, |
159 |
"datum_do" date, |
160 |
"id" SERIAL, |
161 |
"date_lupdate" date DEFAULT 'now', |
162 |
PRIMARY KEY (id) |
163 |
); |
164 |
|
165 |
DROP SEQUENCE "nagrade_id_seq"; |
166 |
DROP TABLE "nagrade"; |
167 |
CREATE TABLE "nagrade" ( |
168 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
169 |
"naziv" text NOT NULL, |
170 |
"opis" text, |
171 |
"sif_ustanove" integer references ustanove(sifra), |
172 |
"urucitelj" text, |
173 |
"godina" text, |
174 |
"id" SERIAL, |
175 |
"date_lupdate" date DEFAULT 'now', |
176 |
PRIMARY KEY (id) |
177 |
); |
178 |
|
179 |
DROP TABLE "o_meni"; |
180 |
CREATE TABLE "o_meni" ( |
181 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
182 |
"opis" text, |
183 |
"datum_lupdate" date DEFAULT 'now', |
184 |
PRIMARY KEY (sif_radnika) |
185 |
); |
186 |
|
187 |
DROP SEQUENCE "strucni_skupovi_rbr_seq"; |
188 |
DROP TABLE "strucni_skupovi"; |
189 |
CREATE TABLE "strucni_skupovi" ( |
190 |
"rbr" SERIAL, |
191 |
"naziv" text, |
192 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
193 |
"grad" text, |
194 |
"datum_od" date, |
195 |
"datum_do" date, |
196 |
"datum_lupdate" date DEFAULT 'now', |
197 |
PRIMARY KEY (rbr) |
198 |
); |
199 |
|
200 |
DROP SEQUENCE "radovi_rbr_seq"; |
201 |
DROP TABLE "radovi"; |
202 |
CREATE TABLE "radovi" ( |
203 |
"rbr" SERIAL, |
204 |
"sif_str_skupa" integer references strucni_skupovi(rbr), |
205 |
"xxxx" integer, |
206 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
207 |
"godina" character varying(4), |
208 |
"naziv_rada_knjige" text, |
209 |
"naziv_casopisa" text, |
210 |
"datum_lupdate" date DEFAULT 'now', |
211 |
PRIMARY KEY (rbr) |
212 |
); |
213 |
|
214 |
DROP SEQUENCE "u_plivi_id_seq"; |
215 |
DROP TABLE "u_plivi"; |
216 |
CREATE TABLE "u_plivi" ( |
217 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
218 |
"radno_mjesto" text, |
219 |
"zadaci" text, |
220 |
"datum_od" date, |
221 |
"datum_do" date, |
222 |
"id" serial, |
223 |
"date_lupdate" date DEFAULT 'now', |
224 |
PRIMARY KEY (id) |
225 |
); |
226 |
|
227 |
DROP SEQUENCE "patenti_sifra_seq"; |
228 |
DROP TABLE "patenti"; |
229 |
CREATE TABLE "patenti" ( |
230 |
"sifra" SERIAL, |
231 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
232 |
"autori" varchar(200), |
233 |
"naziv" varchar(150), |
234 |
"godina" integer, |
235 |
"zastita" varchar(100), |
236 |
"na_snazi" boolean default false, |
237 |
"drzave" varchar(250), |
238 |
"komentar" text, |
239 |
PRIMARY KEY (sifra) |
240 |
); |
241 |
|