text: --Data for the initialization of the database 
  
  insert into FormativeAction(ID_fa, nameFa, totalPlaces, objectives, mainContent, status, enrollmentStart, enrollmentEnd) values
  	(1000, 'Initiation to scrum',	 6,	'some objctives', 'some main content', 'EXECUTED', '2021-01-01 00:00:00.0',	'2021-02-01 00:00:00.0'),
  	(1001, 'Initiation to agile',	10, 	'some objctives', 'some main content', 'EXECUTED', '2021-01-01 00:00:00.0',	'2021-02-08 00:00:00.0'),
  	(1002, 'JDBC',  		 4,  	'some objctives', 'some main content', 'ACTIVE',   '2021-03-01 00:00:00.0',	'2021-04-08 00:00:00.0'),
  	(1003, 'Java programming',	 5,	'some objctives', 'some main content', 'ACTIVE',   '2021-04-01 00:00:00.0',	'2021-04-28 00:00:00.0');
  
  insert into Session(ID_session, ID_fa, location, duration, sessionStart) values
  	(0, 1000, 'online', 2, '2021-02-03 15:00:00.0'),
  	(1, 1000, 'online', 2, '2021-02-04 15:00:00.0'),
  	(2, 1000, 'online', 2, '2021-02-05 15:00:00.0'),
  	(3, 1001, 'online', 3, '2021-02-10 09:00:00.0'),
  	(4, 1001, 'online', 3, '2021-02-11 09:00:00.0'),
  	(5, 1002, 'online', 3, '2021-04-10 12:00:00.0'),
  	(6, 1003, 'online', 4, '2021-05-01 10:00:00.0');
  
  insert into Fee(ID_fee, amount, category, ID_fa) values
  	(1000, 15, 'Standard', 1000),
  	(1001, 10, 'Standard', 1001),
  	(1002, 20, 'Standard', 1002),
  	(1003, 30, 'Standard', 1003),
  	(1004, 25, 'College Members', 1003),
  	(1005, 20, 'UniOvi Members', 1003);
  
  insert into Professional(ID_professional, name, surname, phone, email) values
  	(2000, 'Pablo',	'Gonzales', 		'+341762568901', 	'pablo.gonzales@uniovi.es'),
  	(2001, 'Juan',		'Fernandez', 		'+3413705978356', 	'juan.fernandez@uniovi.es'),
  	(2002, 'Carlo', 	'Perez', 		'+3427889123675', 	'carlo.perez@uniovi.es'),
  	(2003, 'Alvaro', 	'Lopez', 		'+3436789863729', 	'alvaro.lopez@uniovi.es'),
  	(2004, 'Maria', 	'Meier', 		'+491755676536', 	'maria.meier@rub.de'),
  	(2005, 'Paul', 	'Bauer', 		'+4917064578933', 	'paul.bauer@rub.de');
  
  insert into Enrollment(ID_fa, ID_professional, status, timeEn, category) values
  	(1000, 2000, 'RECEIVED', '2021-01-02 16:00:00.0', 'Standard'),
  	(1000, 2001, 'CONFIRMED', '2021-01-04 17:00:00.0', 'Standard'),
  	(1000, 2002, 'CONFIRMED', '2021-01-07 18:00:00.0', 'Standard'),
  	(1000, 2003, 'CONFIRMED', '2021-01-10 19:00:00.0', 'Standard'),
  	(1000, 2004, 'CONFIRMED', '2021-01-13 10:00:00.0', 'Standard'),
  	(1000, 2005, 'CONFIRMED', '2021-01-16 13:00:00.0', 'Standard'),
  	(1001, 2000, 'CONFIRMED', '2021-01-02 12:00:00.0', 'Standard'),
  	(1001, 2001, 'CONFIRMED', '2021-01-13 14:00:00.0', 'Standard'),
  	(1001, 2002, 'CONFIRMED', '2021-01-23 22:00:00.0', 'Standard'),
  	(1001, 2003, 'CONFIRMED', '2021-02-03 20:00:00.0', 'Standard'),
  	(1001, 2004, 'CONFIRMED', '2021-02-01 08:00:00.0', 'Standard'),
  	(1002, 2000, 'CONFIRMED', '2021-03-02 12:00:00.0', 'Standard'),
  	(1002, 2005, 'RECEIVED', '2021-03-05 08:00:00.0', 'Standard'),
  	(1002, 2001, 'CONFIRMED', '2021-03-05 08:00:00.0', 'Standard');
  
  insert into Invoice (Id_invoice , amount, dateIn , sender, receiver, address, fiscalNumber, ID_fa, ID_professional, description) values
          (4000, 15, '2021-01-02', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1000, 2000, "This is a test of the functionality");
  		
  insert into Invoice (Id_invoice , amount, dateIn , sender, receiver, address, fiscalNumber, ID_fa, ID_professional) values
          (4001, 15, '2021-01-04', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1000, 2001 ),
          (4002, 15, '2021-01-07', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1000, 2002 ),
          (4003, 15, '2021-01-11', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1000, 2003 ),
          (4004, 15, '2021-01-14', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1000, 2004 ),
          (4005, 15, '2021-01-16', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1000, 2005 ),
          (4006, 10, '2021-01-02', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1001, 2000 ),
          (4007, 10, '2021-01-13', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1001, 2001 ),
          (4008, 10, '2021-01-24', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1001, 2002 ),
          (4009, 10, '2021-02-04', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1001, 2003 ),
          (4010, 10, '2021-02-01', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1001, 2004 ),
          (4011, 20, '2021-03-22', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1002, 2000 ),
          (4012, 20, '2021-03-03', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1002, 2005 ),
          (4013, 20, '2021-03-05', 'senderName', 'COIIPA', 'address', 'fiscalNumber', 1002, 2001 );
  
  insert into Payment(ID_payment, amount, datePay, confirmed, ID_invoice) values
  	(3000, 15, '2021-01-02 17:00:00.0', true, 4000),
  	(3001, 15, '2021-01-04 18:00:00.0', true, 4001),
  	(3002, 15, '2021-01-07 20:00:00.0', true, 4002),
  	(3003, 15, '2021-01-11 12:00:00.0', true, 4003),
  	(3004, 15, '2021-01-14 13:00:00.0', true, 4004),
  	(3005, 15, '2021-01-16 14:00:00.0', true, 4005),
  	(3006, 10, '2021-01-02 18:00:00.0', true, 4006),
  	(3007, 10, '2021-01-13 15:00:00.0', true, 4007),
  	(3008, 10, '2021-01-24 08:00:00.0', true, 4008),
  	(3009, 10, '2021-02-04 10:00:00.0', true, 4009),
  	(3010, 10, '2021-02-01 15:00:00.0', true, 4010),
  	(3011, 30, '2021-03-22 13:00:00.0', false, 4011),
  	(3012, 10, '2021-03-03 13:00:00.0', false, 4012),
  	(3013, 20, '2021-03-05 10:00:00.0', true,  4013),
  	(3014, -10, '2021-03-05 10:00:00.0', true, 4000);
  
  insert into Teacher (ID_teacher, name, surname, phone, email, fiscalNumber) values
  	(1000, "Jose", "Garcia Fanjul", "", "", "23455656H"),
  	(1001, "Marcos", "Gutierrez Alonso", "", "", "78967856A"),
  	(1002, "Marek", "Ruschulte", "", "", "45667899D"),
  	(1003, "Vivien", "Drescher", "", "", "45345678G"),
  	(1004, "Silvia", "Rodriguez", "", "", "66756789F"),
  	(1005, "Rosalina", "Alvarez", "", "", "43214565G");
  	
  insert into TeacherTeaches (ID_teacher , ID_fa , remuneration) values
  	(1000,1000, 50.0),
  	(1001,1000, 50.0),
  	(1002,1001, 60.0),
  	(1003,1001, 60.0),
  	(1004,1002, 100.0),
  	(1005,1003, 80.0);
  
  insert into InvoiceTeacher (Id_invoice , amount, dateIn, sender, receiver, address, fiscalNumber, ID_fa, ID_teacher) values
  
  	('4000', 50, '2021-01-02' , 'COIIPA', 'recieverName', 'address', 'fiscalNumber', 1000, 1000),
  	('4001', 50, '2021-01-02' , 'COIIPA', 'recieverName', 'address', 'fiscalNumber', 1000, 1001),
  	('4002', 60, '2021-01-03 ', 'COIIPA', 'recieverName', 'address', 'fiscalNumber', 1001, 1002),
  	('4003', 60, '2021-01-03 ', 'COIIPA', 'recieverName', 'address', 'fiscalNumber', 1001, 1003),
  	('4004', 100, '2021-01-04 ', 'COIIPA', 'recieverName', 'address', 'fiscalNumber',  1002, 1004),
  	('4005', 80, '2021-05-04 ', 'COIIPA', 'Rosalina', 'address', 'fiscalNumber',  1003, 1005);
  
  insert into PaymentTeacher( ID_payment, amount, datePay,  confirmed, ID_invoice) values
  	(3000, 50, '2021-01-02 00:00:00.0 ', true, '4000'),
  	(3001, 30, '2021-01-04 00:00:00.0 ', false, '4001'),
  	(3002, 70, '2021-01-07 00:00:00.0 ', false, '4002'),
  	(3003, 70, '2021-05-04 00:00:00.0 ', true, '4005');
  