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