SchemaSpy - View d44civi_9xzwf.civicrm_view_case_activity

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default	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 Wed Nov 11 17:14 EST 2015

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 (`d44civi_9xzwf`.`civicrm_case_activity` `ca` join `d44civi_9xzwf`.`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:

civicrm_activity civicrm_case_activity