Changes between Version 4 and Version 5 of UseCaseModel/sale

Timestamp:

08/24/25 23:10:41 (19 hours ago)

Author:

175012

Comment:

--

UseCaseModel/sale

@@ -44 +44 @@
         * Следните полиња се за одредување на полисата: датумот на почеток, траење на полисата (број на денови), и избор на пакет.
 
-{{{INSERT INTO project.Policy (sdate, edate, package) VALUES (@Sdate, @Edate, @Package) RETURNING p_id}}}
+{{{INSERT INTO project.Policy (s_date, e_date, package_code, d_embg) VALUES (@Sdate, @Edate, @Package @d_embg) RETURNING p_id}}}
 
-{{{INSERT INTO project.Travel_pol (pol_id) VALUES (@Pol_Id) RETURNING tr_id}}}
+{{{INSERT INTO project.Travel_pol (pol_id,o_embg) VALUES (@Pol_Id, @o_embg) RETURNING tr_id}}}
 
 {{{INSERT INTO project.Pol_osi (o_embg, policy, name, surname, birthdate, kontakt) VALUES (@O_Embg, @Policy, @Name, @Surname, @Birthdate, @Kontakt)}}}
 
-{{{INSERT INTO project.pol_dog (d_embg, c_id, name, policy, birthdate) SELECT @tr_id, c_id, name, @Policy, CURRENT_DATE FROM project.Customer WHERE email = @email}}}
+{{{INSERT INTO project.pol_dog (d_embg, c_id, name, surname, birthdate) SELECT @tr_id, c_id, name, surname, CURRENT_DATE FROM project.Customer WHERE email = @email}}}
 
      ==== Чекор 3.