| 5 | | === Табели === |
| | 5 | * __Примарен клуч__: underline |
| | 6 | * __Надворешен клуч__: underline и * |
| | 7 | * **Not null**: bold |
| | 8 | |
| | 9 | == Табели == |
| | 10 | |
| | 11 | **EVENTS**(__**Global_Event_Id**__* , **Sql_Date**, **Month_Year**, **Year**, **Fraction_Date**, **Is_Root_Event**, **Event_Code**, Goldstein_Scale, Num_Mentions, Num_Sources, Num_Articles, Avg_Tone) |
| | 12 | |
| | 13 | **ACTORS**(__**Actor_Id**__* , **Actor_Code**, **Actor_Name**, Country_Code, Type_Code) |
| | 14 | |
| | 15 | **LOCATIONS**(__**Location_Id**__* , **Full_Name**, Country_Code, Adm1_Code, Latitude, Longitude, Feature_Id) |
| | 16 | |
| | 17 | **EVENT_DETAILS**(__**Global_Event_Id**__* , __**Actor_Id**__* , __**Location_Id**__* ) |
| | 18 | * __**Global_Event_Id**__* референцира кон **EVENTS**(__**Global_Event_Id**__*) |
| | 19 | * __**Actor_Id**__* референцира кон **ACTORS**(__**Actor_Id**__*) |
| | 20 | * __**Location_Id**__* референцира кон **LOCATIONS**(__**Location_Id**__*) |
| | 21 | |
| | 22 | **USERS**(__**User_Id**__* , **First_Name**, **Last_Name**, **Email**, **Password_Hash**, __**Role_Id**__* , Last_Login_Date, **Register_Date**) |
| | 23 | * __**Role_Id**__* референцира кон **ROLES**(__**Role_Id**__*) |
| | 24 | |
| | 25 | **ROLES**(__**Role_Id**__* , **Role_Name**) |
| | 26 | |
| | 27 | **PLAN**(__**Plan_Id**__* , **Plan_Name**, Max_Events, Max_Notifications) |
| | 28 | |
| | 29 | **SUBSCRIPTION**(__**Subscription_Id**__* , __**User_Id**__* , __**Plan_Id**__* , **Start_Date**, End_Date, **Status**) |
| | 30 | * __**User_Id**__* референцира кон **USERS**(__**User_Id**__*) |
| | 31 | * __**Plan_Id**__* референцира кон **PLAN**(__**Plan_Id**__*) |
| | 32 | |
| | 33 | **NOTIFICATIONS**(__**Notification_Id**__* , __**User_Id**__* , __**Event_Id**__* , **Notification_Date**, **Status**) |
| | 34 | * __**User_Id**__* референцира кон **USERS**(__**User_Id**__*) |
| | 35 | * __**Event_Id**__* референцира кон **EVENTS**(__**Global_Event_Id**__*) |
| | 36 | |
| | 37 | **PREDICTIONS**(__**Prediction_Id**__* , __**Event_Id**__* , __**Actor_Id**__* , __**Location_Id**__* , **Predicted_Date**, **Prediction_Type**, **Confidence_Score**) |
| | 38 | * __**Event_Id**__* референцира кон **EVENTS**(__**Global_Event_Id**__*) |
| | 39 | * __**Actor_Id**__* референцира кон **ACTORS**(__**Actor_Id**__*) |
| | 40 | * __**Location_Id**__* референцира кон **LOCATIONS**(__**Location_Id**__*) |
| | 41 | |
| | 42 | **CONFLICT_RISK**(__**Conflict_Id**__* , __**Actor1_Id**__* , __**Actor2_Id**__* , **Risk_Score**, **Predicted_Date**, **Description**) |
| | 43 | * __**Actor1_Id**__* референцира кон **ACTORS**(__**Actor_Id**__*) |
| | 44 | * __**Actor2_Id**__* референцира кон **ACTORS**(__**Actor_Id**__*) |
| | 45 | |
| | 46 | **TRENDS**(__**Trend_Id**__* , __**Actor_Id**__* , __**Event_Id**__* , **Date**, Conflict_Coefficient, **Mentions_Count**, **Avg_Tone**, Description) |
| | 47 | * __**Actor_Id**__* референцира кон **ACTORS**(__**Actor_Id**__*) |
| | 48 | * __**Event_Id**__* референцира кон **EVENTS**(__**Global_Event_Id**__*) |
| | 49 | |
