1 |
|
2 |
DROP TABLE vodeca; |
3 |
DROP TABLE lijekovi; |
4 |
DROP TABLE nacin_izdavanja; |
5 |
DROP TABLE list_fond; |
6 |
DROP TABLE trudnoca; |
7 |
DROP TABLE dojencad; |
8 |
DROP TABLE vozac; |
9 |
DROP TABLE droga; |
10 |
DROP TABLE atk_inn; |
11 |
DROP TABLE zupanije; |
12 |
DROP TABLE proizvodjaci; |
13 |
|
14 |
|
15 |
CREATE TABLE vodeca ( |
16 |
sifra CHAR VARYING(20) NOT NULL PRIMARY KEY, |
17 |
naziv TEXT |
18 |
); |
19 |
|
20 |
CREATE TABLE lijekovi ( |
21 |
sifra INTEGER NOT NULL PRIMARY KEY, |
22 |
naziv CHAR VARYING(100) NOT NULL, |
23 |
sif_atk CHAR VARYING(20), |
24 |
sif_inn CHAR VARYING(20), |
25 |
sif_proizvodjac INTEGER, |
26 |
pakovanje TEXT NOT NULL, |
27 |
sastav_1 TEXT NOT NULL, |
28 |
sastav_2 TEXT NOT NULL, |
29 |
sif_nacin_izdavanja INTEGER, |
30 |
sif_list_fond INTEGER, |
31 |
sif_trudnoca INTEGER, |
32 |
sif_dojencad INTEGER, |
33 |
sif_vozac INTEGER, |
34 |
sif_droga INTEGER, |
35 |
cijena CHAR VARYING(16) NOT NULL, |
36 |
sif_med INTEGER NOT NULL, |
37 |
razno TEXT, |
38 |
glav_razno TEXT, |
39 |
djelovanje TEXT, |
40 |
indikacije TEXT, |
41 |
oprez TEXT |
42 |
); |
43 |
|
44 |
CREATE TABLE nacin_izdavanja ( |
45 |
sifra INTEGER NOT NULL, |
46 |
opis TEXT |
47 |
); |
48 |
|
49 |
CREATE TABLE list_fond ( |
50 |
sifra INTEGER NOT NULL, |
51 |
opis TEXT |
52 |
); |
53 |
|
54 |
CREATE TABLE trudnoca ( |
55 |
sifra INTEGER NOT NULL, |
56 |
opis TEXT |
57 |
); |
58 |
|
59 |
CREATE TABLE dojencad ( |
60 |
sifra INTEGER NOT NULL, |
61 |
opis TEXT |
62 |
); |
63 |
|
64 |
CREATE TABLE vozac ( |
65 |
sifra INTEGER NOT NULL, |
66 |
opis TEXT |
67 |
); |
68 |
|
69 |
CREATE TABLE droga ( |
70 |
sifra INTEGER NOT NULL, |
71 |
opis TEXT |
72 |
); |
73 |
|
74 |
CREATE TABLE atk_inn ( |
75 |
sifra CHAR VARYING(20) PRIMARY KEY NOT NULL, |
76 |
naziv CHAR VARYING(100) NOT NULL, |
77 |
razno TEXT |
78 |
); |
79 |
|
80 |
CREATE TABLE zupanije ( |
81 |
broj INTEGER NOT NULL, |
82 |
naziv CHAR VARYING(30) NOT NULL, |
83 |
centar CHAR VARYING(20) NOT NULL, |
84 |
pos_broj CHAR VARYING(7) NOT NULL, |
85 |
npos_broj CHAR VARYING(7) NOT NULL, |
86 |
spos_broj CHAR VARYING(7) NOT NULL, |
87 |
grad CHAR VARYING(20) NOT NULL, |
88 |
zip CHAR VARYING(10) NOT NULL |
89 |
); |
90 |
|
91 |
CREATE TABLE proizvodjaci ( |
92 |
sifra INTEGER NOT NULL PRIMARY KEY, |
93 |
naziv CHAR VARYING(100) NOT NULL, |
94 |
drzava CHAR VARYING(30) NOT NULL, |
95 |
zastupnistvo CHAR VARYING(50) NOT NULL, |
96 |
mjesto CHAR VARYING(30) NOT NULL, |
97 |
zip CHAR VARYING(10) NOT NULL, |
98 |
ulica_i_broj CHAR VARYING(50) NOT NULL, |
99 |
razno TEXT, |
100 |
telefon CHAR VARYING(15), |
101 |
fax CHAR VARYING(15) |
102 |
); |
103 |
|