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 |
"obrazovna" boolean default false, |
47 |
PRIMARY KEY (sifra) |
48 |
); |
49 |
|
50 |
DROP SEQUENCE "strani_jezik_sifra_seq"; |
51 |
DROP TABLE "strani_jezik"; |
52 |
CREATE TABLE "strani_jezik" ( |
53 |
"sifra" SERIAL, |
54 |
"opis" 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 "stupanj_str_jezika_sifra_seq"; |
61 |
DROP TABLE "stupanj_str_jezika"; |
62 |
CREATE TABLE "stupanj_str_jezika" ( |
63 |
"sifra" SERIAL, |
64 |
"stupanj" text, |
65 |
"opis" text, |
66 |
"language" character varying(2) DEFAULT 'HR' NOT NULL, |
67 |
PRIMARY KEY (sifra) |
68 |
); |
69 |
|
70 |
DROP SEQUENCE "osoba_sif_radnika_seq"; |
71 |
DROP TABLE "osoba"; |
72 |
CREATE TABLE "osoba" ( |
73 |
"sif_radnika" SERIAL, |
74 |
"ime" character varying(100) NOT NULL, |
75 |
"prezime" character varying(100) NOT NULL, |
76 |
"naziv_struke" text, |
77 |
"sif_org_jed" text REFERENCES org_jed(sifra), |
78 |
"radna_jedinica" text, |
79 |
"radno_mjesto" text, |
80 |
"spol" character varying(1) CHECK (spol = 'M' OR spol = 'F'), |
81 |
"datum_rodjenja" date, |
82 |
"stupanj_str_spreme" text, |
83 |
"smjer" text, |
84 |
"titula" text, |
85 |
"telefon" character varying(50), |
86 |
"email" character varying(250), |
87 |
"language" character varying(2) DEFAULT 'HR' NOT NULL |
88 |
); |
89 |
|
90 |
DROP TABLE "certifikati"; |
91 |
CREATE TABLE "certifikati" ( |
92 |
"sif_edukacije" INTEGER, |
93 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
94 |
"sif_ustanove" integer REFERENCES ustanove(sifra), |
95 |
"naziv" text, |
96 |
"titula" text, |
97 |
"dat_izdavanja" date, |
98 |
"dat_polaganja" date, |
99 |
"dat_vrijedi_do" date, |
100 |
"xxxx" text, |
101 |
PRIMARY KEY (sif_edukacije, sif_radnika) |
102 |
); |
103 |
|
104 |
DROP SEQUENCE "tecajevi_sifra_seq"; |
105 |
DROP TABLE "tecajevi"; |
106 |
CREATE TABLE "tecajevi" ( |
107 |
"sifra" SERIAL, |
108 |
"naziv" text NOT NULL, |
109 |
"xxxx" text, |
110 |
"sif_qualification" integer REFERENCES qualification(sifra), |
111 |
"language" character varying(2) DEFAULT 'HR' NOT NULL, |
112 |
PRIMARY KEY (sifra) |
113 |
); |
114 |
|
115 |
DROP TABLE "edukacije"; |
116 |
CREATE TABLE "edukacije" ( |
117 |
"sifra" INTEGER, |
118 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
119 |
"naziv" text, |
120 |
"sif_ustanove" integer REFERENCES obrazovna_ustanova(sifra), |
121 |
"datum_upisa" date, |
122 |
"datum_zavrsetka" date, |
123 |
"ukupno_ispita" smallint, |
124 |
"polozenih_ispita" smallint, |
125 |
"ukupno_semestara" smallint, |
126 |
"polozenih_semestara" smallint, |
127 |
"zavrsio_ispitom" boolean default false, |
128 |
"sif_qualification" integer references qualification(sifra), |
129 |
"sif_tecaja" integer references tecajevi(sifra), |
130 |
"stupanj_str_jezika" integer references stupanj_str_jezika(sifra), |
131 |
"sif_stranog_jezika" integer references strani_jezik(sifra), |
132 |
"date_lupdate" date, |
133 |
"sif_strucna_sprema" integer references strucne_spreme(sif_str_spreme), |
134 |
"grad_odrzavanja_tecaja" text, |
135 |
"titula" text, |
136 |
PRIMARY KEY (sifra, sif_radnika) |
137 |
); |
138 |
|
139 |
DROP SEQUENCE "izvan_plive_id_seq"; |
140 |
DROP TABLE "izvan_plive"; |
141 |
CREATE TABLE "izvan_plive" ( |
142 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
143 |
"tvrtka" text, |
144 |
"radno_mjesto" text, |
145 |
"zadaci" text, |
146 |
"datum_od" date, |
147 |
"datum_do" date, |
148 |
"id" SERIAL, |
149 |
"date_lupdate" date DEFAULT 'now', |
150 |
PRIMARY KEY (id) |
151 |
); |
152 |
|
153 |
DROP SEQUENCE "nagrade_id_seq"; |
154 |
DROP TABLE "nagrade"; |
155 |
CREATE TABLE "nagrade" ( |
156 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
157 |
"naziv" text NOT NULL, |
158 |
"opis" text, |
159 |
"sif_ustanove" integer references ustanove(sifra), |
160 |
"urucitelj" text, |
161 |
"godina" text, |
162 |
"id" SERIAL, |
163 |
"date_lupdate" date DEFAULT 'now', |
164 |
PRIMARY KEY (id) |
165 |
); |
166 |
|
167 |
DROP TABLE "o_meni"; |
168 |
CREATE TABLE "o_meni" ( |
169 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
170 |
"opis" text, |
171 |
"datum_lupdate" date DEFAULT 'now', |
172 |
PRIMARY KEY (sif_radnika) |
173 |
); |
174 |
|
175 |
DROP TABLE "strucni_skupovi"; |
176 |
CREATE TABLE "strucni_skupovi" ( |
177 |
"rbr" INTEGER, |
178 |
"naziv" text, |
179 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
180 |
"grad" text, |
181 |
"datum_od" date, |
182 |
"datum_do" date, |
183 |
"datum_lupdate" date DEFAULT 'now', |
184 |
PRIMARY KEY (rbr, sif_radnika) |
185 |
); |
186 |
|
187 |
DROP TABLE "radovi"; |
188 |
CREATE TABLE "radovi" ( |
189 |
"rbr" INTEGER, |
190 |
"sif_str_skupa" integer, |
191 |
"xxxx" integer, |
192 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
193 |
"godina" character varying(4), |
194 |
"naziv_rada_knjige" text, |
195 |
"naziv_casopisa" text, |
196 |
"datum_lupdate" date DEFAULT 'now', |
197 |
PRIMARY KEY (rbr, sif_radnika) |
198 |
); |
199 |
|
200 |
DROP SEQUENCE "u_plivi_id_seq"; |
201 |
DROP TABLE "u_plivi"; |
202 |
CREATE TABLE "u_plivi" ( |
203 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
204 |
"radno_mjesto" text, |
205 |
"zadaci" text, |
206 |
"datum_od" date, |
207 |
"datum_do" date, |
208 |
"id" serial, |
209 |
"date_lupdate" date DEFAULT 'now', |
210 |
PRIMARY KEY (id) |
211 |
); |
212 |
|
213 |
DROP SEQUENCE "patenti_sifra_seq"; |
214 |
DROP TABLE "patenti"; |
215 |
CREATE TABLE "patenti" ( |
216 |
"sifra" SERIAL, |
217 |
"sif_radnika" INTEGER REFERENCES osoba(sif_radnika), |
218 |
"autori" varchar(200), |
219 |
"naziv" varchar(150), |
220 |
"godina" integer, |
221 |
"zastita" varchar(100), |
222 |
"na_snazi" boolean default false, |
223 |
"drzave" varchar(250), |
224 |
"komentar" text, |
225 |
PRIMARY KEY (sifra) |
226 |
); |
227 |
|