grthtrhthjhtyjytjytkergtrhtrjytjerhrfh4:24 29/09/2026 'surveys', 'audited' => true, 'inline_edit' => true, 'duplicate_merge' => true, 'fields' => array ( 'id' => array ( 'name' => 'id', 'vname' => 'LBL_ID', 'type' => 'id', 'required' => true, 'reportable' => true, 'comment' => 'Unique identifier', 'inline_edit' => false, ), 'name' => array ( 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'name', 'link' => true, 'dbType' => 'varchar', 'len' => 255, 'unified_search' => true, 'full_text_search' => array ( 'boost' => 3, ), 'required' => true, 'importable' => 'required', 'duplicate_merge' => 'enabled', 'merge_filter' => 'selected', ), 'date_entered' => array ( 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'group' => 'created_by_name', 'comment' => 'Date record created', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, ), 'date_modified' => array ( 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'group' => 'modified_by_name', 'comment' => 'Date record last modified', 'enable_range_search' => true, 'options' => 'date_range_search_dom', 'inline_edit' => false, ), 'modified_user_id' => array ( 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_MODIFIED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'group' => 'modified_by_name', 'dbType' => 'id', 'reportable' => true, 'comment' => 'User who last modified record', 'massupdate' => false, 'inline_edit' => false, ), 'modified_by_name' => array ( 'name' => 'modified_by_name', 'vname' => 'LBL_MODIFIED_NAME', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'rname' => 'user_name', 'table' => 'users', 'id_name' => 'modified_user_id', 'module' => 'Users', 'link' => 'modified_user_link', 'duplicate_merge' => 'disabled', 'massupdate' => false, 'inline_edit' => false, ), 'created_by' => array ( 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_CREATED', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'group' => 'created_by_name', 'comment' => 'User who created record', 'massupdate' => false, 'inline_edit' => false, ), 'created_by_name' => array ( 'name' => 'created_by_name', 'vname' => 'LBL_CREATED', 'type' => 'relate', 'reportable' => false, 'link' => 'created_by_link', 'rname' => 'user_name', 'source' => 'non-db', 'table' => 'users', 'id_name' => 'created_by', 'module' => 'Users', 'duplicate_merge' => 'disabled', 'importable' => 'false', 'massupdate' => false, 'inline_edit' => false, ), 'description' => array ( 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', 'comment' => 'Full text of the note', 'rows' => 6, 'cols' => 80, ), 'deleted' => array ( 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'default' => '0', 'reportable' => false, 'comment' => 'Record deletion indicator', ), 'created_by_link' => array ( 'name' => 'created_by_link', 'type' => 'link', 'relationship' => 'surveys_created_by', 'vname' => 'LBL_CREATED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', ), 'modified_user_link' => array ( 'name' => 'modified_user_link', 'type' => 'link', 'relationship' => 'surveys_modified_user', 'vname' => 'LBL_MODIFIED_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', ), 'assigned_user_id' => array ( 'name' => 'assigned_user_id', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'vname' => 'LBL_ASSIGNED_TO_ID', 'group' => 'assigned_user_name', 'type' => 'relate', 'table' => 'users', 'module' => 'Users', 'reportable' => true, 'isnull' => 'false', 'dbType' => 'id', 'audited' => true, 'comment' => 'User ID assigned to record', 'duplicate_merge' => 'disabled', ), 'assigned_user_name' => array ( 'name' => 'assigned_user_name', 'link' => 'assigned_user_link', 'vname' => 'LBL_ASSIGNED_TO_NAME', 'rname' => 'user_name', 'type' => 'relate', 'reportable' => false, 'source' => 'non-db', 'table' => 'users', 'id_name' => 'assigned_user_id', 'module' => 'Users', 'duplicate_merge' => 'disabled', ), 'assigned_user_link' => array ( 'name' => 'assigned_user_link', 'type' => 'link', 'relationship' => 'surveys_assigned_user', 'vname' => 'LBL_ASSIGNED_TO_USER', 'link_type' => 'one', 'module' => 'Users', 'bean_name' => 'User', 'source' => 'non-db', 'duplicate_merge' => 'enabled', 'rname' => 'user_name', 'id_name' => 'assigned_user_id', 'table' => 'users', ), 'SecurityGroups' => array ( 'name' => 'SecurityGroups', 'type' => 'link', 'relationship' => 'securitygroups_surveys', 'module' => 'SecurityGroups', 'bean_name' => 'SecurityGroup', 'source' => 'non-db', 'vname' => 'LBL_SECURITYGROUPS', ), 'status' => array ( 'required' => false, 'name' => 'status', 'vname' => 'LBL_STATUS', 'type' => 'enum', 'massupdate' => 0, 'default' => 'Draft', 'no_default' => false, 'comments' => '', 'help' => '', 'importable' => 'true', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => '0', 'audited' => false, 'inline_edit' => true, 'reportable' => true, 'unified_search' => false, 'merge_filter' => 'disabled', 'len' => 100, 'size' => '20', 'options' => 'survey_status_list', 'studio' => 'visible', 'dependency' => false, ), 'survey_questions_display' => array ( 'name' => 'survey_questions_display', 'vname' => 'LBL_SURVEY_QUESTIONS_DISPLAY', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'inline_edit' => false, 'function' => array ( 'name' => 'survey_questions_display', 'returns' => 'html', 'include' => 'modules/Surveys/Lines/Lines.php', ), ), 'survey_url_display' => array ( 'name' => 'survey_url_display', 'vname' => 'LBL_SURVEY_URL_DISPLAY', 'type' => 'function', 'source' => 'non-db', 'massupdate' => 0, 'importable' => 'false', 'duplicate_merge' => 'disabled', 'duplicate_merge_dom_value' => 0, 'audited' => false, 'reportable' => false, 'inline_edit' => false, 'function' => array ( 'name' => 'survey_url_display', 'returns' => 'html', 'include' => 'modules/Surveys/Utils/utils.php', ), ), 'submit_text' => array ( 'required' => false, 'name' => 'submit_text', 'vname' => 'LBL_SUBMIT_TEXT', 'type' => 'varchar', 'massupdate' => 0, 'default' => 'Submit', ), 'satisfied_text' => array ( 'required' => false, 'name' => 'satisfied_text', 'vname' => 'LBL_SATISFIED_TEXT', 'type' => 'varchar', 'massupdate' => 0, 'default' => 'Satisfied', ), 'neither_text' => array ( 'required' => false, 'name' => 'neither_text', 'vname' => 'LBL_NEITHER_TEXT', 'type' => 'varchar', 'massupdate' => 0, 'default' => 'Neither Satisfied nor Dissatisfied', ), 'dissatisfied_text' => array ( 'required' => false, 'name' => 'dissatisfied_text', 'vname' => 'LBL_DISSATISFIED_TEXT', 'type' => 'varchar', 'massupdate' => 0, 'default' => 'Dissatisfied', ), 'surveys_surveyquestions' => array ( 'name' => 'surveys_surveyquestions', 'type' => 'link', 'relationship' => 'surveys_surveyquestions', 'source' => 'non-db', 'module' => 'SurveyQuestions', 'bean_name' => 'SurveyQuestions', 'side' => 'right', 'vname' => 'LBL_SURVEYS_SURVEYQUESTIONS_FROM_SURVEYQUESTIONS_TITLE', ), 'surveys_surveyresponses' => array ( 'name' => 'surveys_surveyresponses', 'type' => 'link', 'relationship' => 'surveys_surveyresponses', 'source' => 'non-db', 'module' => 'SurveyResponses', 'bean_name' => 'SurveyResponses', 'side' => 'right', 'vname' => 'LBL_SURVEYS_SURVEYRESPONSES_FROM_SURVEYRESPONSES_TITLE', ), ), 'relationships' => array ( 'surveys_modified_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Surveys', 'rhs_table' => 'surveys', 'rhs_key' => 'modified_user_id', 'relationship_type' => 'one-to-many', ), 'surveys_created_by' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Surveys', 'rhs_table' => 'surveys', 'rhs_key' => 'created_by', 'relationship_type' => 'one-to-many', ), 'surveys_assigned_user' => array ( 'lhs_module' => 'Users', 'lhs_table' => 'users', 'lhs_key' => 'id', 'rhs_module' => 'Surveys', 'rhs_table' => 'surveys', 'rhs_key' => 'assigned_user_id', 'relationship_type' => 'one-to-many', ), 'securitygroups_surveys' => array ( 'lhs_module' => 'SecurityGroups', 'lhs_table' => 'securitygroups', 'lhs_key' => 'id', 'rhs_module' => 'Surveys', 'rhs_table' => 'surveys', 'rhs_key' => 'id', 'relationship_type' => 'many-to-many', 'join_table' => 'securitygroups_records', 'join_key_lhs' => 'securitygroup_id', 'join_key_rhs' => 'record_id', 'relationship_role_column' => 'module', 'relationship_role_column_value' => 'Surveys', ), 'surveys_surveyquestions' => array ( 'rhs_module' => 'SurveyQuestions', 'rhs_table' => 'surveyquestions', 'rhs_key' => 'survey_id', 'lhs_module' => 'Surveys', 'lhs_table' => 'surveys', 'lhs_key' => 'id', 'relationship_type' => 'one-to-many', ), 'surveys_surveyresponses' => array ( 'rhs_module' => 'SurveyResponses', 'rhs_table' => 'surveyresponses', 'rhs_key' => 'survey_id', 'lhs_module' => 'Surveys', 'lhs_table' => 'surveys', 'lhs_key' => 'id', 'relationship_type' => 'one-to-many', ), 'surveys_campaigns' => array ( 'rhs_module' => 'Campaigns', 'rhs_table' => 'campaigns', 'rhs_key' => 'survey_id', 'lhs_module' => 'Surveys', 'lhs_table' => 'surveys', 'lhs_key' => 'id', 'relationship_type' => 'one-to-many', ), ), 'optimistic_locking' => true, 'unified_search' => true, 'indices' => array ( 'id' => array ( 'name' => 'surveyspk', 'type' => 'primary', 'fields' => array ( 0 => 'id', ), ), ), 'templates' => array ( 'security_groups' => 'security_groups', 'assignable' => 'assignable', 'basic' => 'basic', ), 'custom_fields' => false, );