RelationalDesign: polnenje.sql

insert into users(user_id,user_username,user_password,user_phone_number,user_name,user_surname,user_email,user_role)
values (12342,'darko258121','darko12345#','071-132-882','Darko','Popovski','darkopopovski@yahoo.com','Employee'),
           (21231,'nikola.sofeski','nikola1234.','070-430-911','Nikola','Sofeski','sofeskin@hotmail.com','Employee'),
           (1208,'iva12','abvgd9542','03720-12-24-48','Iva','Naskovska','iva.nask12@yahoo.com','Employee'),
           (32423,'johnwood13212','johhnywoodie111','202-555-0188','John','Wood','johnwood222@gmail.com','Client'),
           (4123,'erich12','qwerty666','03731-41-64-54 ','Erich','Schnell','erichschnell2@gmail.com','Client'),
           (23013,'JohnnyB','ahevne123','072-312-274','Johnny','Bravo','bravo.jon@gmail.com','Client');
                

------------------------------------------------------          

insert into employee(employee_id,user_id)
values (1,12342),
       (2,21231),
       (3,1208);
      
------------------------------------------------------            

insert into client(client_id,user_id)
values (1,32423),
           (2,4123),
           (3,23013);
            
------------------------------------------------------  

insert into firm(firm_id,firm_city,firm_adress,firm_name)
values (1,'Skopje','Partizanski Odredi','Skopje Cinema'),
       (2,'Ohrid','Goce Delcev','Lake Cinema'),
       (3,'Prilep','Lece Koteski','PrilepCinema'),
       (4,'Bitola','Blagojche Siljanovski','BTCinema');



------------------------------------------------------  
      
insert into auditorium(auditorium_id,auditorium_name,auditorium_capacity,firm_id)
values (1,'Sala-1',50,1),
           (2,'Sala-2',35,2),
           (3,'Sala-3',50,3),
       (4,'Sala-4',40,4);
      
------------------------------------------------------  
      
insert into genre(genre_id,genre_name)
values (321,'Western'),
           (211,'Action'),
           (121,'Fantasy'),
           (11,'SCI-FI');
       
------------------------------------------------------  

insert into movie(movie_id,movie_name,movie_age_category,movie_production,movie_film_director,movie_cast,movie_time_duration)
values (132423,'The Good, the Bad and the Ugly','12+','Produzioni Europee Associate','Sergio Leone','Clint Eastwood','2h 58m'),
           (21232,'Terminator 3: Rise of the Machines','15+','Intermedia, C2 Pictures','Jonathan Mostow','Arnold Schwarzenegger,Kristanna Loken','1h 49m'),
       (34433423,'The Matrix','16+','Warner Bros', 'Lana Wachowski,Lilly Wachowski','Keanu Reeves,Laurence Fishburne,Carrie-Anne Moss','2h 26m'),
           (454334,'Interstellar','12+','Paramount Pictures','Christopher Nolan','Matthew McConaughey,John Lithgow,Ellen Burstyn','2h 28m');
 
------------------------------------------------------

insert into works_in(user_id,firm_id,works_from,works_to)
values (12342,1,'2021-11-10',now()),
       (21231,2,'2020-05-12',now()),
       (1208,3,'2021-02-11',now()),
       (21231,4,'2021-07-08',now());
      
------------------------------------------------------

insert into movieprojection(projection_id,projection_movie_start,projection_movie_end,projection_screening_date,projection_type,projection_price,movie_id)
values (12732,'16h:00min','18h:58m','2021-12-17','2D',350,132423),
           (182736,'19h:00min','21h:26min','2021-12-23','2D',280,21232),
       (61235,'15h:00min','17h:28min','2021-12-20','3D',380,34433423),
       (16732,'19h:00min','21h:26m','2021-12-17','2D',450,454334);

------------------------------------------------------

insert into payment_type(payment_type_id,payment_type)
values (12366,'Ticket-Office'),
            (12367,'Online');

------------------------------------------------------

insert into seat(seat_id,auditorium_id,seat_number)
values (1,1,1),
(2,1,2),
(3,1,3),
(4,1,4),
(5,1,5),
(6,1,6),
(7,1,7),
(8,1,8),
(9,1,9),
(10,1,10),
(11,1,11),
(12,1,12),
(13,1,13),
(14,1,14),
(15,1,15),
(16,1,16),
(17,1,17),
(18,1,18),
(19,1,19),
(20,1,20),
(21,1,21),
(22,1,22),
(23,1,23),
(24,1,24),
(25,1,25),
(26,1,26),
(27,1,27),
(28,1,28),
(29,1,29),
(30,1,30),
(31,1,31),
(32,1,32),
(33,1,33),
(34,1,34),
(35,1,35),
(36,1,36),
(37,1,37),
(38,1,38),
(39,1,39),
(40,1,40),
(41,1,41),
(42,1,42),
(43,1,43),
(44,1,44),
(45,1,45),
(46,1,46),
(47,1,47),
(48,1,48),
(49,1,49),
(1,2,1),
(2,2,2),
(3,2,3),
(4,2,4),
(5,2,5),
(6,2,6),
(7,2,7),
(8,2,8),
(9,2,9),
(10,2,10),
(11,2,11),
(12,2,12),
(13,2,13),
(14,2,14),
(15,2,15),
(16,2,16),
(17,2,17),
(18,2,18),
(19,2,19),
(20,2,20),
(21,2,21),
(22,2,22),
(23,2,23),
(24,2,24),
(25,2,25),
(26,2,26),
(27,2,27),
(28,2,28),
(29,2,29),
(30,2,30),
(31,2,31),
(32,2,32),
(33,2,33),
(34,2,34),
(35,2,35),
(36,2,36),
(37,2,37),
(38,2,38),
(39,2,39),
(40,2,40),
(41,2,41),
(42,2,42),
(43,2,43),
(44,2,44),
(45,2,45),
(46,2,46),
(47,2,47),
(48,2,48),
(49,2,49),
(1,3,1),
(2,3,2),
(3,3,3),
(4,3,4),
(5,3,5),
(6,3,6),
(7,3,7),
(8,3,8),
(9,3,9),
(10,3,10),
(11,3,11),
(12,3,12),
(13,3,13),
(14,3,14),
(15,3,15),
(16,3,16),
(17,3,17),
(18,3,18),
(19,3,19),
(20,3,20),
(21,3,21),
(22,3,22),
(23,3,23),
(24,3,24),
(25,3,25),
(26,3,26),
(27,3,27),
(28,3,28),
(29,3,29),
(30,3,30),
(31,3,31),
(32,3,32),
(33,3,33),
(34,3,34),
(35,3,35),
(36,3,36),
(37,3,37),
(38,3,38),
(39,3,39),
(40,3,40),
(41,3,41),
(42,3,42),
(43,3,43),
(44,3,44),
(45,3,45),
(46,3,46),
(47,3,47),
(48,3,48),
(49,3,49);

           

------------------------------------------------------

insert into reservation(reservation_id,reservation_date,payment_type_id,user_id,seat_id,auditorium_id,projection_id)
values (005,'2021-12-23',12366,4123,1,1,12732),
                (002,'2021-12-22',12366,4123,1,2,182736),
           (003,'2021-12-19',12367,23013,5,3,61235);
  
------------------------------------------------------

insert into payment(payment_id,payment_type_id,payment_date,user_id,reservation_id)
values  (162536,12366,'2021-12-18',4123,002),
                (162732,12367,'2021-12-20',23013,003);
                  
------------------------------------------------------
          
insert into is_(movie_id,genre_id)
values (132423,321),
           (21232,211),
           (34433423,121),
           (454334,11);

------------------------------------------------------
          
insert into controles(user_id,projection_id)
values (12342,12732),
           (21231,182736),
           (1208,61235);
          
------------------------------------------------------

insert into gives(seat_limitation,projection_id, auditorium_id)
values (40,61235,2),
           (35,12732,1),
       (28,182736,2),
       (42,182736,3);
    
------------------------------------------------------