ER Дијаграм

Податочни побарувања

Ентитети

Events

• Global_Event_Id (PK)
• Sql_Date
• Month_Year
• Year
• Fraction_Date
• Is_Root_Event
• Event_Code
• Goldstein_Scale
• Num_Mentions
• Num_Sources
• Num_Articles
• Avg_Tone

Actors

• Actor_Id (PK)
• Actor_Code
• Actor_Name
• Country_Code
• Type_Code

Locations

• Location_Id (PK)
• Full_Name
• Country_Code
• Adm1_Code
• Latitude
• Longitude
• Feature_Id

Event_Details

• Global_Event_Id (FK)
• Actor_Id (FK)
• Location_Id (FK)

Users

• User_Id (PK)
• First_Name
• Last_Name
• Email
• Password_Hash
• Role_Id (FK)

Roles

• Role_Id (PK)
• Role_Name

Plan

• Plan_Id (PK)
• Plan_Name
• Max_Events
• Max_Notifications

Subscription

• Subscription_Id (PK)
• User_Id (FK)
• Plan_Id (FK)
• Start_Date
• End_Date
• Status

Notifications

• Notification_Id (PK)
• User_Id (FK)
• Event_Id (FK)
• Notification_Date
• Status

Predictions

• Prediction_Id (PK)
• Event_Id (FK)
• Actor_Id (FK)
• Location_Id (FK)
• Predicted_Date
• Prediction_Type
• Confidence_Score

Conflict_Risk

• Conflict_Id (PK)
• Actor1_Id (FK)
• Actor2_Id (FK)
• Risk_Score
• Predicted_Date
• Description

Trends

• Trend_Id (PK)
• Actor_Id (FK)
• Event_Id (FK)
• Date
• Conflict_Coefficient
• Mentions_Count
• Avg_Tone
• Description

Релации

Events

• 1:N со Event_Details
• 1:N со Notifications
• 1:N со Predictions
• 1:N со Trends

Actors

• 1:N со Event_Details
• 1:N со Predictions
• 1:N со Conflict_Risk
• 1:N со Trends

Locations

• 1:N со Event_Details
• 1:N со Predictions

Event_Details

• N:1 со Events
• N:1 со Actors
• N:1 со Locations

Users

• 1:N со Subscription
• 1:N со Notifications

Roles

• 1:N со Users

Plan

• 1:N со Subscription

Subscription

• N:1 со Users
• N:1 со Plan

Notifications

• N:1 со Users
• N:1 со Events

Predictions

• N:1 со Events
• N:1 со Actors
• N:1 со Locations

Conflict_Risk

• N:1 со Actors

Trends

• N:1 со Actors
• N:1 со Events