Changes between Version 7 and Version 8 of UseCaseModel/evaluation

Timestamp:

08/31/25 15:06:49 (5 days ago)

Author:

175012

Comment:

--

UseCaseModel/evaluation

@@ -110 +110 @@
 == Погледи
 
-View имаме креирано во фаза 2
+{{{
+
+--View
+-- project.packageview source
+
+CREATE OR REPLACE VIEW project.packageview
+AS SELECT c.cov_amount,
+    c.cov_type,
+    p.title AS packagetitle,
+    p.total AS packagetotal,
+    p.valuet AS packagevalue,
+        CASE
+            WHEN p.type_pol = 3 THEN 'Auto Policy'::text
+            WHEN p.type_pol = 1 THEN 'Travel Health'::text
+            ELSE 'Property Policy'::text
+        END AS policytype
+   FROM project.covers c
+     JOIN project.package p ON c.package::integer = p.code;
+    
+    
+}}}
 
 == Трансакции