'title' => ts('Note ID'),
'description' => ts('Note ID'),
'required' => TRUE,
+ 'where' => 'civicrm_note.id',
'table_name' => 'civicrm_note',
'entity' => 'Note',
'bao' => 'CRM_Core_BAO_Note',
'required' => TRUE,
'maxlength' => 64,
'size' => CRM_Utils_Type::BIG,
+ 'where' => 'civicrm_note.entity_table',
'table_name' => 'civicrm_note',
'entity' => 'Note',
'bao' => 'CRM_Core_BAO_Note',
'title' => ts('Note Entity ID'),
'description' => ts('Foreign key to the referenced item.'),
'required' => TRUE,
+ 'where' => 'civicrm_note.entity_id',
'table_name' => 'civicrm_note',
'entity' => 'Note',
'bao' => 'CRM_Core_BAO_Note',
'type' => CRM_Utils_Type::T_INT,
'title' => ts('Note Created By'),
'description' => ts('FK to Contact ID creator'),
+ 'where' => 'civicrm_note.contact_id',
'table_name' => 'civicrm_note',
'entity' => 'Note',
'bao' => 'CRM_Core_BAO_Note',
'type' => CRM_Utils_Type::T_DATE,
'title' => ts('Note Modified By'),
'description' => ts('When was this note last modified/edited'),
+ 'where' => 'civicrm_note.modified_date',
'table_name' => 'civicrm_note',
'entity' => 'Note',
'bao' => 'CRM_Core_BAO_Note',
'description' => ts('subject of note description'),
'maxlength' => 255,
'size' => 60,
+ 'where' => 'civicrm_note.subject',
'table_name' => 'civicrm_note',
'entity' => 'Note',
'bao' => 'CRM_Core_BAO_Note',
'description' => ts('Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)'),
'maxlength' => 255,
'size' => CRM_Utils_Type::HUGE,
+ 'where' => 'civicrm_note.privacy',
'table_name' => 'civicrm_note',
'entity' => 'Note',
'bao' => 'CRM_Core_BAO_Note',