Changes between Version 2 and Version 3 of appdesign

Timestamp:

02/06/25 17:42:31 (2 weeks ago)

Author:

155036

Comment:

--

appdesign

@@ -65 +65 @@
 
 == Најважни случаи на употреба ==
+
+'''1. Преглед на настани'''
+{{{
+SELECT 
+    e.global_event_id, e.sql_date, e.event_code, e.goldstein_scale, 
+    e.num_mentions, e.num_sources, e.num_articles, e.avg_tone 
+FROM events e 
+ORDER BY e.sql_date DESC
+LIMIT 50;
+}}}
+
+'''2. Анализа на актер'''
+{{{
+SELECT 
+    a.actor_name, e.global_event_id, e.event_code, e.sql_date, 
+    e.num_mentions, e.avg_tone 
+FROM actors a
+JOIN event_details ed ON a.actor_id = ed.actor_id
+JOIN events e ON ed.global_event_id = e.global_event_id
+WHERE a.actor_id = 5003
+ORDER BY e.sql_date DESC;
+}}}
+
+'''3. Следење на конфликти'''
+{{{
+SELECT 
+    cr.conflict_id, a1.actor_name AS actor_1, 
+    a2.actor_name AS actor_2, cr.risk_score, 
+    cr.predicted_date, cr.description 
+FROM conflict_risk cr
+JOIN actors a1 ON cr.actor1_id = a1.actor_id
+JOIN actors a2 ON cr.actor2_id = a2.actor_id
+WHERE cr.predicted_date >= CURRENT_DATE
+ORDER BY cr.risk_score DESC;
+}}}
+
+'''4. Генерирање извештаи'''
+{{{
+SELECT 
+    p.prediction_id, e.global_event_id, a.actor_name, 
+    p.prediction_type, p.confidence_score, p.predicted_date 
+FROM predictions p
+JOIN events e ON p.event_id = e.global_event_id
+JOIN actors a ON p.actor_id = a.actor_id
+WHERE p.predicted_date BETWEEN CURRENT_DATE - INTERVAL '30 days' AND CURRENT_DATE
+ORDER BY p.confidence_score DESC;
+}}}
+
+'''5. Известувања за нови настани'''
+{{{
+SELECT 
+    n.notification_id, u.email, e.global_event_id, 
+    e.event_code, n.notification_date, n.status 
+FROM notifications n
+JOIN users u ON n.user_id = u.user_id
+JOIN events e ON n.event_id = e.global_event_id
+WHERE n.notification_date >= CURRENT_DATE - INTERVAL '7 days'
+ORDER BY n.notification_date DESC;
+}}}