/[registar]/shema.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /shema.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.3 - (show annotations)
Tue Jun 19 09:27:25 2001 UTC (22 years, 9 months ago) by dpavlin
Branch: MAIN
Changes since 1.2: +7 -7 lines
dodani primarni ključevi

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 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 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 sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
40 opis TEXT
41 );
42
43 CREATE TABLE list_fond (
44 sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
45 opis TEXT
46 );
47
48 CREATE TABLE trudnoca (
49 sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
50 opis TEXT
51 );
52
53 CREATE TABLE dojencad (
54 sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
55 opis TEXT
56 );
57
58 CREATE TABLE vozac (
59 sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
60 opis TEXT
61 );
62
63 CREATE TABLE droga (
64 sifra CHAR VARYING(5) NOT NULL PRIMARY KEY,
65 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 PRIMARY KEY,
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 telefon CHAR VARYING(20),
95 fax CHAR VARYING(20)
96 );
97

  ViewVC Help
Powered by ViewVC 1.1.26