RelationalDesign: vnesuvanje.sql

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 administrator(adminid,adminrole)
values  (4,'mod'),
                (5,'mod'),
                (6,'mod');
                
insert into city(cityname)      
values  ('Skopje'),     
        ('Veles'),      
        ('Ohrid'),      
        ('Kumanovo'),   
        ('Stip');       
       
insert into building(cityname,building_adress)  
values  ('Skopje','Blaze Koneski 10'),  
        ('Skopje','Gologanov 24'),      
        ('Ohrid', 'Rade Koncar 1'),     
        ('Kumanovo', 'Gologanov 3'),    
        ('Stip', 'Kiro Gligorov 3');


      
insert into faculty(facultyname,cityname)       
values  ('FINKI','Skopje'),
                ('PMF','Skopje'),
                ('Gastronomija','Ohrid');
                
insert into student(studentid,facultyid,age,gender)
values  (2,1,21,'male'),
                (1,1,21,'male');
        

insert into apartment(buildingid,ownerid,apartment_adress,apartment_size)
values  (1,1,'Vlez 4 Stan 3','60m2'),
                (2,2,'Vlez 1 Stan 12','55m2'),
                (3,3,'Vlez 3 Stan 6','70m2');
insert into apartment_agreement(apartmentid,ownerid,date_signed,date_expires,apartment_rent)
values  (4,1,TO_DATE('10/09/2022', 'DD/MM/YYYY'),TO_DATE('30/06/2023', 'DD/MM/YYYY'),250),
                (5,2,TO_DATE('10/09/2022', 'DD/MM/YYYY'),TO_DATE('30/06/2023', 'DD/MM/YYYY'),300);
insert into apartment_agreement(apartmentid,ownerid,date_signed,date_expires,apartment_rent)
values  (4,3,TO_DATE('10/09/2022', 'DD/MM/YYYY'),TO_DATE('30/06/2023', 'DD/MM/YYYY'),250);

insert into student_signs(studentid,agreementid)
values  (2,3),
                (1,3);
                
insert into student_signs(studentid,agreementid)
values  (2,4),
                (1,5);

insert into post(cityname,number_of_roommates,price,date_posted,description)
values  ('Skopje',2,250,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'baram cimer'),
                ('Skopje',2,300,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'izdavam stan'),
                ('Skopje',2,300,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'izdavam stan'),
                ('Skopje',2,300,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'baram cimer');


                
insert into post(cityname,number_of_roommates,price,date_posted,description)
values  ('Skopje',3,250,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'baram cimeri');
insert into post(cityname,number_of_roommates,price,date_posted,description)
values  ('Ohrid',4,400,TO_DATE('10/09/2022', 'DD/MM/YYYY'),'izdavam stan');


                
insert into owner_post(owner_postid,apartmentid,ownerid)
values  (2,4,1),
                (3,5,2);
insert into owner_post(owner_postid,apartmentid,ownerid)
values  (6,6,3);

insert into apartment_photos(postid,photosurl)          
values  (2,'link1'),
                (3,'link3');
insert into apartment_photos(postid,photosurl)          
values  (6,'link4');

insert into student_post(student_postid,studentid)
values  (1,1),
                (4,2);
insert into student_post(student_postid,studentid)
values  (5,2);

insert into moderates_posts_for(cityname,adminid)
values  ('Skopje',4),
                ('Skopje',5),
                ('Stip',6);