1 | set search_path = project;
|
---|
2 |
|
---|
3 |
|
---|
4 | insert into tip_dijabetes(ime)
|
---|
5 | values
|
---|
6 | ('tip 1')
|
---|
7 | , ('tip 2');
|
---|
8 |
|
---|
9 | insert into tip_insulin(ime)
|
---|
10 | values
|
---|
11 | ('RAPID')
|
---|
12 | , ('BASAL');
|
---|
13 |
|
---|
14 | insert into nacin_prigotvuvanje_hrana (ime)
|
---|
15 | values
|
---|
16 | ('svezho')
|
---|
17 | , ('zamrznato')
|
---|
18 | , ('pecheno')
|
---|
19 | , ('vareno')
|
---|
20 | , ('dinstano')
|
---|
21 | , ('przheno')
|
---|
22 | , ('konzenvirano');
|
---|
23 |
|
---|
24 | insert into covek(embg, ime, prezime, pol, datum_na_ragjanje)
|
---|
25 | values
|
---|
26 | ('0101994000000', 'Kristijan', 'Ristovski', 'M', '1994-01-01')
|
---|
27 | , ('0911996123456', 'Nikola', 'Torbovski', 'M', '1996-11-09')
|
---|
28 | , ('1809004111111', 'Marija', 'Trajkovska', 'Z', '2004-04-18')
|
---|
29 | , ('110200299999', 'Luka', 'Markovski', 'M', '2002-02-11')
|
---|
30 | , ('0606999546872', 'Marionka', 'Japonka', 'Z', '1999-06-06')
|
---|
31 | , ('1708021333333', 'Nina', 'Jadrovska', 'Z', '2021-08-17');
|
---|
32 |
|
---|
33 | insert into dijabeticar (id, data_na_otkrivanje, tip_dijabetes_id)
|
---|
34 | values
|
---|
35 | (2, '1996-11-09', 1)
|
---|
36 | , (3, '2010-01-15', 2)
|
---|
37 | , (6, '2022-09-01', 1);
|
---|
38 |
|
---|
39 | insert into doktor (id)
|
---|
40 | values(1)
|
---|
41 | , (4)
|
---|
42 | , (5);
|
---|
43 |
|
---|
44 | insert into datoteka_metapodatoci (ime, hash, opis, mime, tip_datoteka)
|
---|
45 | values
|
---|
46 | ('zdravstven_rezultat_01_02_2023.pdf', '30e9b774c4691c38f0e3251545d1e238', '', 'application/pdf', 'Z')
|
---|
47 | , ('faksimil_09_08_2021.pdf', 'f75be9d5c7ee578aeec5fef7005f78a3', '', 'application/pdf', 'F')
|
---|
48 | , ('faksimil_19_09_2020.pdf', 'a96ef978bcd93a0813000886b09d99b5', 'Faksimil izdaden na 19-09-2020', 'application/pdf', 'F')
|
---|
49 | , ('zdravstven_rezultat_08_07_2022.pdf', '86e014467d5d5a21645bc17fb4bf328a', 'Opis za zdravstven rezultat...', 'application/pdf', 'Z')
|
---|
50 | , ('faksimil_07_12_2005.pdf', '0ef75e84f52a9793326dbf3f36fec367', '', 'application/pdf', 'F')
|
---|
51 | , ('zdravstven_rez_07_01_2001.pdf', '3e7a11c3f47cf8cc55fcf5e7f5bce614', ':)', 'application/pdf', 'Z');
|
---|
52 |
|
---|
53 | insert into zdrastven_rezultat (id, dijabeticar_id)
|
---|
54 | values
|
---|
55 | (1, 2)
|
---|
56 | , (4, 3)
|
---|
57 | , (6, 6);
|
---|
58 |
|
---|
59 | insert into faksimil (id, doktor_id, dijabeticar_id)
|
---|
60 | values
|
---|
61 | (2, 4, 2)
|
---|
62 | , (3, 4, 2)
|
---|
63 | , (5, 5, 6);
|
---|
64 |
|
---|
65 | insert into medikament (ime, proizvoditel, tip_medikament)
|
---|
66 | values
|
---|
67 | ('Lantus', 'Sanofi Aventis', 'I')
|
---|
68 | , ('Apidra', 'Sanofi Aventis', 'I')
|
---|
69 | , ('Novo Rapid', 'Novo Nordisk', 'I')
|
---|
70 | , ('Tyson Bio AC200', 'Tyson Bioresearch', 'L')
|
---|
71 | , ('Accu-Chek Active', 'Roche Diabetes Care', 'L')
|
---|
72 | , ('OneTouch Ultra', 'Lifescan Medical Devices', 'L');
|
---|
73 |
|
---|
74 |
|
---|
75 | insert into lenti_merenje_shekjer (id)
|
---|
76 | values
|
---|
77 | (4)
|
---|
78 | , (5)
|
---|
79 | , (6);
|
---|
80 |
|
---|
81 | insert into insulin (id, tip_insulin_id)
|
---|
82 | values
|
---|
83 | (1, 2)
|
---|
84 | , (2, 1)
|
---|
85 | , (3, 1);
|
---|
86 |
|
---|
87 |
|
---|
88 | insert into inventar (dijabeticar_id, medikament_id, rok_na_traenje, kolicina)
|
---|
89 | values
|
---|
90 | (2, 1, '2023-05-18', 5)
|
---|
91 | , (2, 1, '2025-09-17', 4)
|
---|
92 | , (2, 3, '2022-10-18', 1)
|
---|
93 | , (3, 5, '2024-12-12', 7)
|
---|
94 | , (6, 6, '2023-01-19', 13)
|
---|
95 | , (6, 6, '2023-05-06', 3);
|
---|
96 |
|
---|
97 | insert into hrana (ime, proizvoditel, glikemiski_indeks, proteini, jaglehidrati, shekjeri, masti, kalorii, nacin_prigotvuvanje_hrana_id)
|
---|
98 | values
|
---|
99 | ('leb na zar', 'stara furna', 20, 8, 60, 1.3, 1, 300, 3)
|
---|
100 | , ('leb', 'furna dime', 20, 9, 40, 1, 2, 312, 3)
|
---|
101 | , ('oriz', 'kamko', 13, 10, 55, 7, 8, 201, 4)
|
---|
102 | , ('makaroni', 'divela', 7, 11, 51, 8, 3, 135, 3)
|
---|
103 | , ('tuna', 'blue sea', 1, 22, 13, 2, 18, 400, 7)
|
---|
104 | , ('kulen', 'zlatibor', 9, 21, 15, 3, 31, 350, 1);
|
---|
105 |
|
---|
106 | -- 2 3 6
|
---|
107 | -- '1996-11-09' '2010-01-15' '2022-09-01'
|
---|
108 |
|
---|
109 | insert into zapis (dijabeticar_id, "data")
|
---|
110 | values
|
---|
111 | (2, '1999-02-08')
|
---|
112 | , (2, '2000-01-01')
|
---|
113 | , (2, '2001-08-09')
|
---|
114 | , (3, '2010-05-09')
|
---|
115 | , (3, '2010-09-09')
|
---|
116 | , (3, '2012-10-10')
|
---|
117 | , (6, '2022-10-01')
|
---|
118 | , (6, '2022-11-10')
|
---|
119 | , (6, '2022-12-30');
|
---|
120 |
|
---|
121 | insert into zapis_so_izmeren_sekjer (dijabeticar_id, "data", vrednost)
|
---|
122 | values
|
---|
123 | (2, '1999-02-08', 11.5)
|
---|
124 | ,(2, '2000-01-01', 9.8)
|
---|
125 | , (2, '2001-08-09', 3.1)
|
---|
126 | , (3, '2010-09-09', 8.1)
|
---|
127 | , (3, '2012-10-10', 2.3)
|
---|
128 | , (6, '2022-11-10', 7.9);
|
---|
129 |
|
---|
130 | insert into zapis_insulin (dijabeticar_id, "data")
|
---|
131 | values
|
---|
132 | (2, '1999-02-08')
|
---|
133 | , (2, '2000-01-01')
|
---|
134 | , (2, '2001-08-09')
|
---|
135 | , (3, '2010-09-09')
|
---|
136 | , (6, '2022-10-01')
|
---|
137 | , (6, '2022-12-30');
|
---|
138 |
|
---|
139 | insert into zapis_insulin_doziran_insulin (dijabeticar_id, "data", insulin_id, kolicina)
|
---|
140 | values
|
---|
141 | (2, '1999-02-08', 1, 15)
|
---|
142 | , (2, '2000-01-01', 1, 7)
|
---|
143 | , (2, '2001-08-09', 2, 1)
|
---|
144 | , (3, '2010-09-09', 3, 10)
|
---|
145 | , (6, '2022-10-01', 2, 9)
|
---|
146 | , (6, '2022-12-30', 2, 6);
|
---|
147 |
|
---|
148 | insert into zapis_hrana (dijabeticar_id, "data")
|
---|
149 | values
|
---|
150 | (2, '1999-02-08')
|
---|
151 | , (2, '2001-08-09')
|
---|
152 | , (3, '2010-09-09')
|
---|
153 | , (6, '2022-10-01')
|
---|
154 | , (6, '2022-12-30');
|
---|
155 |
|
---|
156 | insert into obrok (dijabeticar_id, "data", hrana_id, kolicina)
|
---|
157 | values
|
---|
158 | (2, '1999-02-08', 1, 100)
|
---|
159 | , (2, '1999-02-08', 6, 20)
|
---|
160 | , (2, '1999-02-08', 2, 16)
|
---|
161 | , (2, '2001-08-09', 2, 35)
|
---|
162 | , (3, '2010-09-09', 4, 125)
|
---|
163 | , (3, '2010-09-09', 5, 111)
|
---|
164 | , (6, '2022-10-01', 1, 37)
|
---|
165 | , (6, '2022-10-01', 5, 86)
|
---|
166 | , (6, '2022-12-30', 5, 97)
|
---|
167 | , (6, '2022-12-30', 1, 172);
|
---|