| Column | 
  Type | 
  Size | 
  Nulls | 
  Auto | 
  Default | 
  Children | 
  Parents | 
  
 
 | id | 
 varchar | 
 36 | 
  | 
  | 
  | 
 
  
 | 
   | 
 
 
 | deleted | 
 bit | 
 1 | 
  √  | 
  | 
 0 | 
  | 
   | 
 
 
 | date_entered | 
 datetime | 
 19 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | date_modified | 
 datetime | 
 19 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | created_by | 
 char | 
 36 | 
  √  | 
  | 
 null | 
  | 
 
  
   
    | users.id
     | 
    Defined in XML R | 
    
   
  | 
 
 
 | modified_user_id | 
 char | 
 36 | 
  √  | 
  | 
 null | 
  | 
 
  
   
    | users.id
     | 
    Defined in XML R | 
    
   
  | 
 
 
 | name | 
 varchar | 
 255 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | job | 
 varchar | 
 255 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | date_time_start | 
 datetime | 
 19 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | date_time_end | 
 datetime | 
 19 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | job_interval | 
 varchar | 
 100 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | time_from | 
 time | 
 8 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | time_to | 
 time | 
 8 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | last_run | 
 datetime | 
 19 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | status | 
 varchar | 
 100 | 
  √  | 
  | 
 null | 
  | 
   | 
 
 
 | catch_up | 
 bit | 
 1 | 
  √  | 
  | 
 1 | 
  | 
   | 
 
 
 
Analyzed at Thu Jul 14 07:15 UTC 2016 
 |