Changes between Version 10 and Version 11 of RelationalDesign

Timestamp:

02/07/24 22:52:51 (5 months ago)

Author:

Nikola Torbovski

Comment:

--

RelationalDesign

@@ -17 +17 @@
 Nacin_prigotvuvanje_hrana(__**id**__, **[[span(style=color: #FF0000,ime)]]**) 
 
-Covek(__**id**__, **[[span(style=color: #FF0000,embg)]]**, **ime**, **prezime**, **pol**, **datum_na_ragjanje**) 
+Covek(__**id**__, **[[span(style=color: #FF0000,embg)]]**, **[[span(style=color: #FF0000,email)]]**, **ime**, **prezime**, **pol**, **datum_na_ragjanje**) 
 
 Doktor(__**id**__{{{*}}})
@@ -99 +99 @@
 {{{
 #!sql
-
 
 set search_path = project;
@@ -196 +195 @@
         id serial4 NOT NULL,
         embg char(13) NOT NULL,
+        email varchar(128) not null,
         ime varchar(256) NOT NULL,
         prezime varchar(256) NOT NULL,
@@ -203 +203 @@
         CONSTRAINT "PK_covek_id" PRIMARY KEY (id),
         CONSTRAINT "UNQ_covek_embg" unique(embg),
+        constraint "UNQ_covek_email" unique(email),
         CONSTRAINT "CHK_covek_pol" CHECK ((pol = ANY (ARRAY['M'::bpchar, 'Z'::bpchar])))
 );
@@ -553 +554 @@
 , ('konzenvirano');
 
-insert into covek(embg, ime, prezime, pol, datum_na_ragjanje)
-values
-('0101994000000', 'Kristijan', 'Ristovski', 'M', '1994-01-01')
-, ('0911996123456', 'Nikola', 'Torbovski', 'M', '1996-11-09')
-, ('1809004111111', 'Marija', 'Trajkovska', 'Z', '2004-04-18')
-, ('110200299999', 'Luka', 'Markovski', 'M', '2002-02-11')
-, ('0606999546872', 'Marionka', 'Japonka', 'Z', '1999-06-06')
-, ('1708021333333', 'Nina', 'Jadrovska', 'Z', '2021-08-17');
+insert into covek(embg, email, ime, prezime, pol, datum_na_ragjanje)
+values
+('0101994000000', 'kristijan.ristovski@students.finki.ukim.mk', 'Kristijan', 'Ristovski', 'M', '1994-01-01')
+, ('0911996123456', 'nikola.torbovski@students.finki.ukim.mk', 'Nikola', 'Torbovski', 'M', '1996-11-09')
+, ('1809004111111', 'marija.trajkovska@students.finki.ukim.mk', 'Marija', 'Trajkovska', 'Z', '2004-04-18')
+, ('110200299999', 'luka.markovski@students.finki.ukim.mk', 'Luka', 'Markovski', 'M', '2002-02-11')
+, ('0606999546872', 'marionka.japonka@students.finki.ukim.mk', 'Marionka', 'Japonka', 'Z', '1999-06-06')
+, ('1708021333333', 'nina.jadrovska@students.finki.ukim.mk', 'Nina', 'Jadrovska', 'Z', '2021-08-17');
 
 insert into dijabeticar (id, data_na_otkrivanje, tip_dijabetes_id)
@@ -698 +699 @@
 , (6, '2022-12-30', 1, 172);
 
+
 }}}
 == Релациски дијаграм изваден од DBeaver