| Column | 
  Type | 
  Size | 
  Nulls | 
  Auto | 
  Default | 
  Children | 
  Parents | 
  
 
 | id | 
 char | 
 36 | 
  | 
  | 
  | 
  | 
   | 
 
 
 | timeperiod_id | 
 char | 
 36 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | forecast_type | 
 varchar | 
 100 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | opp_count | 
 int | 
 5 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | pipeline_opp_count | 
 int | 
 5 | 
  √  | 
  | 
 0 | 
  | 
   | 
 
 
 | pipeline_amount | 
 decimal | 
 26,6 | 
  √  | 
  | 
 0.000000 | 
  | 
   | 
 
 
 | closed_amount | 
 decimal | 
 26,6 | 
  √  | 
  | 
 0.000000 | 
  | 
   | 
 
 
 | opp_weigh_value | 
 int | 
 11 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | best_case | 
 decimal | 
 26,6 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | likely_case | 
 decimal | 
 26,6 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | worst_case | 
 decimal | 
 26,6 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | user_id | 
 char | 
 36 | 
  √  | 
  | 
 null | 
  | 
 
  
   
    | users.id
     | 
    Defined in XML R | 
    
   
  | 
 
 
 | date_entered | 
 datetime | 
 19 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | date_modified | 
 datetime | 
 19 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | deleted | 
 bit | 
 1 | 
  √  | 
  | 
 0 | 
  | 
   | 
 
 
 | currency_id | 
 char | 
 36 | 
  √  | 
  | 
 -99 | 
  | 
 
  
  | 
 
 
 | base_rate | 
 decimal | 
 26,6 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 
Analyzed at Sat Jan 13 08:23 UTC 2018 
 |