View d47civi_0z3xa.civicrm_view_case_activity_upcoming Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
case_id int unsigned 10 Case ID of case-activity association.
id int unsigned 10 0 Unique Other Activity ID
activity_date_time datetime 19  √  null Date and time this activity is scheduled to occur. Formerly named scheduled_date_time.
status_id int unsigned 10  √  null ID of the status this activity is currently in. Foreign key to civicrm_option_value.
activity_type_id int unsigned 10 1 FK to civicrm_option_value.id, that has to be valid, registered activity type.

Analyzed at mer. avr. 13 16:52 EDT 2016

View Definition:
select `ca`.`case_id` AS `case_id`,`a`.`id` AS `id`,`a`.`activity_date_time` AS `activity_date_time`,`a`.`status_id` AS `status_id`,`a`.`activity_type_id` AS `activity_type_id` from (`d47civi_0z3xa`.`civicrm_case_activity` `ca` join `d47civi_0z3xa`.`civicrm_activity` `a` on((`ca`.`activity_id` = `a`.`id`))) where ((`a`.`activity_date_time` <= (now() + interval 14 day)) and (`a`.`is_current_revision` = 1) and (`a`.`is_deleted` = 0) and (`a`.`status_id` = 1))
 
Possibly Referenced Tables/Views: