SchemaSpy - View d47civi_0z3xa.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 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()) and (`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