1 |
|
|
|
DROP TABLE vodeca; |
|
2 |
DROP TABLE lijekovi; |
DROP TABLE lijekovi; |
3 |
DROP TABLE nacin_izdavanja; |
DROP TABLE nacin_izdavanja; |
4 |
DROP TABLE list_fond; |
DROP TABLE list_fond; |
11 |
DROP TABLE proizvodjaci; |
DROP TABLE proizvodjaci; |
12 |
|
|
13 |
|
|
|
CREATE TABLE vodeca ( |
|
|
sifra CHAR VARYING(20) NOT NULL PRIMARY KEY, |
|
|
naziv TEXT |
|
|
); |
|
|
|
|
14 |
CREATE TABLE lijekovi ( |
CREATE TABLE lijekovi ( |
15 |
sifra INTEGER NOT NULL PRIMARY KEY, |
sifra INTEGER NOT NULL PRIMARY KEY, |
16 |
naziv CHAR VARYING(100) NOT NULL, |
naziv CHAR VARYING(100) NOT NULL, |
20 |
pakovanje TEXT NOT NULL, |
pakovanje TEXT NOT NULL, |
21 |
sastav_1 TEXT NOT NULL, |
sastav_1 TEXT NOT NULL, |
22 |
sastav_2 TEXT NOT NULL, |
sastav_2 TEXT NOT NULL, |
23 |
sif_nacin_izdavanja INTEGER, |
sif_nacin_izdavanja CHAR VARYING(5), |
24 |
sif_list_fond INTEGER, |
sif_list_fond CHAR VARYING(5), |
25 |
sif_trudnoca INTEGER, |
sif_trudnoca CHAR VARYING(5), |
26 |
sif_dojencad INTEGER, |
sif_dojencad CHAR VARYING(5), |
27 |
sif_vozac INTEGER, |
sif_vozac CHAR VARYING(5), |
28 |
sif_droga INTEGER, |
sif_droga CHAR VARYING(5), |
29 |
cijena CHAR VARYING(16) NOT NULL, |
cijena CHAR VARYING(16) NOT NULL, |
30 |
sif_med INTEGER NOT NULL, |
sif_med INTEGER NOT NULL, |
31 |
razno TEXT, |
razno TEXT, |
36 |
); |
); |
37 |
|
|
38 |
CREATE TABLE nacin_izdavanja ( |
CREATE TABLE nacin_izdavanja ( |
39 |
sifra INTEGER NOT NULL, |
sifra CHAR VARYING(5) NOT NULL, |
40 |
opis TEXT |
opis TEXT |
41 |
); |
); |
42 |
|
|
43 |
CREATE TABLE list_fond ( |
CREATE TABLE list_fond ( |
44 |
sifra INTEGER NOT NULL, |
sifra CHAR VARYING(5) NOT NULL, |
45 |
opis TEXT |
opis TEXT |
46 |
); |
); |
47 |
|
|
48 |
CREATE TABLE trudnoca ( |
CREATE TABLE trudnoca ( |
49 |
sifra INTEGER NOT NULL, |
sifra CHAR VARYING(5) NOT NULL, |
50 |
opis TEXT |
opis TEXT |
51 |
); |
); |
52 |
|
|
53 |
CREATE TABLE dojencad ( |
CREATE TABLE dojencad ( |
54 |
sifra INTEGER NOT NULL, |
sifra CHAR VARYING(5) NOT NULL, |
55 |
opis TEXT |
opis TEXT |
56 |
); |
); |
57 |
|
|
58 |
CREATE TABLE vozac ( |
CREATE TABLE vozac ( |
59 |
sifra INTEGER NOT NULL, |
sifra CHAR VARYING(5) NOT NULL, |
60 |
opis TEXT |
opis TEXT |
61 |
); |
); |
62 |
|
|
63 |
CREATE TABLE droga ( |
CREATE TABLE droga ( |
64 |
sifra INTEGER NOT NULL, |
sifra CHAR VARYING(5) NOT NULL, |
65 |
opis TEXT |
opis TEXT |
66 |
); |
); |
67 |
|
|
91 |
zip CHAR VARYING(10) NOT NULL, |
zip CHAR VARYING(10) NOT NULL, |
92 |
ulica_i_broj CHAR VARYING(50) NOT NULL, |
ulica_i_broj CHAR VARYING(50) NOT NULL, |
93 |
razno TEXT, |
razno TEXT, |
94 |
telefon CHAR VARYING(15), |
telefon CHAR VARYING(20), |
95 |
fax CHAR VARYING(15) |
fax CHAR VARYING(20) |
96 |
); |
); |
97 |
|
|