36 |
); |
); |
37 |
|
|
38 |
CREATE TABLE nacin_izdavanja ( |
CREATE TABLE nacin_izdavanja ( |
39 |
sifra CHAR VARYING(5) NOT NULL, |
sifra CHAR VARYING(5) NOT NULL PRIMARY KEY, |
40 |
opis TEXT |
opis TEXT |
41 |
); |
); |
42 |
|
|
43 |
CREATE TABLE list_fond ( |
CREATE TABLE list_fond ( |
44 |
sifra CHAR VARYING(5) NOT NULL, |
sifra CHAR VARYING(5) NOT NULL PRIMARY KEY, |
45 |
opis TEXT |
opis TEXT |
46 |
); |
); |
47 |
|
|
48 |
CREATE TABLE trudnoca ( |
CREATE TABLE trudnoca ( |
49 |
sifra CHAR VARYING(5) NOT NULL, |
sifra CHAR VARYING(5) NOT NULL PRIMARY KEY, |
50 |
opis TEXT |
opis TEXT |
51 |
); |
); |
52 |
|
|
53 |
CREATE TABLE dojencad ( |
CREATE TABLE dojencad ( |
54 |
sifra CHAR VARYING(5) NOT NULL, |
sifra CHAR VARYING(5) NOT NULL PRIMARY KEY, |
55 |
opis TEXT |
opis TEXT |
56 |
); |
); |
57 |
|
|
58 |
CREATE TABLE vozac ( |
CREATE TABLE vozac ( |
59 |
sifra CHAR VARYING(5) NOT NULL, |
sifra CHAR VARYING(5) NOT NULL PRIMARY KEY, |
60 |
opis TEXT |
opis TEXT |
61 |
); |
); |
62 |
|
|
63 |
CREATE TABLE droga ( |
CREATE TABLE droga ( |
64 |
sifra CHAR VARYING(5) NOT NULL, |
sifra CHAR VARYING(5) NOT NULL PRIMARY KEY, |
65 |
opis TEXT |
opis TEXT |
66 |
); |
); |
67 |
|
|
75 |
broj INTEGER NOT NULL, |
broj INTEGER NOT NULL, |
76 |
naziv CHAR VARYING(30) NOT NULL, |
naziv CHAR VARYING(30) NOT NULL, |
77 |
centar CHAR VARYING(20) NOT NULL, |
centar CHAR VARYING(20) NOT NULL, |
78 |
pos_broj CHAR VARYING(7) NOT NULL, |
pos_broj CHAR VARYING(7) NOT NULL PRIMARY KEY, |
79 |
npos_broj CHAR VARYING(7) NOT NULL, |
npos_broj CHAR VARYING(7) NOT NULL, |
80 |
spos_broj CHAR VARYING(7) NOT NULL, |
spos_broj CHAR VARYING(7) NOT NULL, |
81 |
grad CHAR VARYING(20) NOT NULL, |
grad CHAR VARYING(20) NOT NULL, |