/[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

Annotation of /shema.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.2 - (hide annotations)
Tue Jun 12 10:11:24 2001 UTC (22 years, 9 months ago) by ravilov
Branch: MAIN
Changes since 1.1: +14 -20 lines
Fixed conversion routine for "vodeca". Removed "vodeca" from the scheme.

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    

  ViewVC Help
Powered by ViewVC 1.1.26