== 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**