/[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.1.1.1 - (show annotations) (vendor branch)
Tue Jun 12 07:38:52 2001 UTC (22 years, 9 months ago) by ravilov
Branch: pliva
CVS Tags: r0
Changes since 1.1: +0 -0 lines
initial import

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

  ViewVC Help
Powered by ViewVC 1.1.26