Changes between Version 5 and Version 6 of ImportantUseCase002

Timestamp:

12/27/22 18:57:57 (2 years ago)

Author:

201144

Comment:

--

ImportantUseCase002

@@ -30 +30 @@
 
 
+{{{
+insert into appuser(ime,prezime,pass,phone_number,city_of_residency,datumragj)
+values  ('Filip','Trajkovski','ft12','111-111-111','Skopje',TO_DATE('15/04/2001', 'DD/MM/YYYY')),
+            ('Blagoja','Nikolovski','bn12','111-111-111','Skopje',TO_DATE('01/01/2001', 'DD/MM/YYYY')),
+            ('Darko','Nikolov','dn23','123-234-444','Ohrid',TO_DATE('02/06/1979', 'DD/MM/YYYY')),
+            ('Aleksandar','Aleksandrov','aa23','222-222-222','Veles',TO_DATE('05/05/1994', 'DD/MM/YYYY')),
+            ('Ana','Ristova','ar23','444-222-111','Bitola',TO_DATE('11/12/1989', 'DD/MM/YYYY'));
+
+insert into apartment_owner(ownerid)
+values  (1),
+                (2),
+                (3);
+
+insert into city(cityname)      
+values  ('Skopje');
+
+insert into building(cityname,building_adress)  
+values  ('Skopje','Prashka 21');
+
+insert into apartment(buildingid,ownerid,apartment_adress,apartment_size)
+values  (1,1,'2nd Floor Room 21','55m2');
+
+insert into post(cityname,number_of_roommates,price,date_posted,description)
+values  ('Skopje',4,200,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'izdavam stan');
+
+insert into owner_post(owner_postid,apartmentid,ownerid)
+values  (1,1,1);
+}}}
 
 
@@ -36 +64 @@
 
 
+
+