Changes between Version 6 and Version 7 of design


Ignore:
Timestamp:
02/06/25 16:44:08 (2 weeks ago)
Author:
155036
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • design

    v6 v7  
    99== Табели ==
    1010
    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)
     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) 
    1212
    13 **ACTORS**(__**Actor_Id**__* , **Actor_Code**, **Actor_Name**, Country_Code, Type_Code)
     13**ACTORS**(Actor_Id*, **Actor_Code**, **Actor_Name**, Country_Code, Type_Code) 
    1414
    15 **LOCATIONS**(__**Location_Id**__* , **Full_Name**, Country_Code, Adm1_Code, Latitude, Longitude, Feature_Id)
     15**LOCATIONS**(Location_Id*, **Full_Name**, Country_Code, Adm1_Code, Latitude, Longitude, Feature_Id) 
    1616
    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**__*) 
     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*) 
    2121
    22 **USERS**(__**User_Id**__* , **First_Name**, **Last_Name**, **Email**, **Password_Hash**, __**Role_Id**__* , Last_Login_Date, **Register_Date**) 
    23   * __**Role_Id**__* референцира кон **ROLES**(__**Role_Id**__*) 
     22**USERS**(User_Id*, **First_Name**, **Last_Name**, **Email**, **Password_Hash**, **Role_Id**, Last_Login_Date, **Register_Date**) 
     23- Role_Id* референцира кон **ROLES**(Role_Id*) 
    2424
    25 **ROLES**(__**Role_Id**__* , **Role_Name**)
     25**ROLES**(Role_Id*, **Role_Name**) 
    2626
    27 **PLAN**(__**Plan_Id**__* , **Plan_Name**, Max_Events, Max_Notifications)
     27**PLAN**(Plan_Id*, **Plan_Name**, **Max_Events**, **Max_Notifications**, **Max_Predictions**) 
    2828
    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**__*) 
     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*) 
    3232
    33 **NOTIFICATIONS**(__**Notification_Id**__* , __**User_Id**__* , __**Event_Id**__* , **Notification_Date**, **Status**) 
    34   * __**User_Id**__* референцира кон **USERS**(__**User_Id**__*) 
    35   * __**Event_Id**__* референцира кон **EVENTS**(__**Global_Event_Id**__*) 
     33**NOTIFICATIONS**(Notification_Id*, User_Id*, Event_Id*, **Notification_Date**, **Status**) 
     34- User_Id* референцира кон **USERS**(User_Id*) 
     35- Event_Id* референцира кон **EVENTS**(Global_Event_Id*) 
    3636
    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**__*) 
     37**PREDICTIONS**(Prediction_Id*, Event_Id*, Actor_Id*, **Predicted_Date**, **Prediction_Type**, **Confidence_Score**) 
     38- Event_Id* референцира кон **EVENTS**(Global_Event_Id*) 
     39- Actor_Id* референцира кон **ACTORS**(Actor_Id*) 
    4140
    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**__*) 
     41**CONFLICT_RISK**(Conflict_Id*, Actor1_Id*, Actor2_Id*, **Risk_Score**, **Predicted_Date**, Description) 
     42- Actor1_Id* референцира кон **ACTORS**(Actor_Id*) 
     43- Actor2_Id* референцира кон **ACTORS**(Actor_Id*) 
    4544
    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**__*) 
     45**EVENT_ANALYTICS**(Analytics_Id*, Actor_Id*, Event_Id*, **Date**, Conflict_Coefficient, Mentions_Count, Avg_Tone, Description) 
     46- Actor_Id* референцира кон **ACTORS**(Actor_Id*) 
     47- Event_Id* референцира кон **EVENTS**(Global_Event_Id*) 
    4948
    5049