<?php /* * Your installation or use of this SugarCRM file is subject to the applicable * terms available at * http://support.sugarcrm.com/Resources/Master_Subscription_Agreements/. * If you do not agree to all of the applicable terms or do not have the * authority to bind the entity as an authorized representative, then do not * install or use this SugarCRM file. * * Copyright (C) SugarCRM Inc. All rights reserved. */ $dictionary['DataSet'] = array('table' => 'data_sets' ,'fields' => array ( 'id' => array ( 'name' => 'id', 'vname' => 'LBL_NAME', 'type' => 'id', 'required' => true, 'reportable'=>false, ), 'deleted' => array ( 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => true, 'default' => '0', 'reportable'=>false, ), 'date_entered' => array ( 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true, ), 'date_modified' => array ( 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true, ), 'modified_user_id' => array ( 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id', 'reportable'=>true, ), 'created_by' => array ( 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => 'false', 'dbType' => 'id' ), 'parent_id' => array ( 'name' => 'parent_id', 'type' => 'id', 'reportable'=>false, ), 'parent_name' => array ( 'name' => 'parent_name', 'vname' => 'LBL_PARENT_DATASET', 'type' => 'relate', 'reportable'=>false, 'source'=>'non-db', 'table' => 'data_sets', 'id_name' => 'parent_id', 'rname' => 'name', 'module'=> 'DataSets', 'duplicate_merge'=>'disabled', 'comment' => 'Parent data sets for the data set (Meta-data only)', ), 'report_id' => array ( 'name' => 'report_id', 'type' => 'id', 'required'=>false, 'reportable'=>false, ), 'report_name' => array ( 'name' => 'report_name', 'vname' => 'LBL_REPORT_NAME', 'type' => 'varchar', 'reportable'=>false, 'source'=>'non-db', 'duplicate_merge'=>'disabled', 'comment' => 'Custom Queries for the data sets (Meta-data only)', ), 'query_id' => array ( 'name' => 'query_id', 'vname' => 'LBL_QUERY_NAME', 'type' => 'id', 'required'=>true, 'importable' => 'required', ), 'query_name' => array ( 'name' => 'query_name', 'vname' => 'LBL_QUERY_NAME', 'type' => 'relate', 'reportable'=>false, 'required'=>true, 'source'=>'non-db', 'table' => 'custom_queries', 'id_name' => 'query_id', 'rname' => 'name', 'module'=>'CustomQueries', 'duplicate_merge'=>'disabled', 'comment' => 'Custom Queries for the data sets (Meta-data only)', ), 'name' => array ( 'name' => 'name', 'vname' => 'LBL_NAME', 'type' => 'varchar', 'len' => '50', 'importable' => 'required', ), 'list_order_y' => array ( 'name' => 'list_order_y', 'vname' => 'LBL_LISTORDER_Y', 'type' => 'int', 'len' => '3', 'default' => '0', 'importable' => 'required', ), 'exportable' => array ( 'name' => 'exportable', 'vname' => 'LBL_EXPORTABLE', 'dbType' => 'varchar', 'type' => 'bool', 'len' => '3', 'default' => '0', ), 'header' => array ( 'name' => 'header', 'vname' => 'LBL_HEADER', 'dbType' => 'varchar', 'type' => 'bool', 'len' => '3', 'default' => '0', ), 'description' => array ( 'name' => 'description', 'vname' => 'LBL_DESCRIPTION', 'type' => 'text', ), 'table_width' => array ( 'name' => 'table_width', 'vname' => 'LBL_TABLE_WIDTH', 'type' => 'varchar', 'dbType' => 'varchar', 'len' => '3', 'default' => '0', ), 'font_size' => array ( 'name' => 'font_size', 'vname' => 'LBL_FONT_SIZE', 'type' => 'enum', 'options' => 'font_size_dom', 'len'=>8, 'default' => '0', ), 'output_default' => array ( 'name' => 'output_default', 'vname' => 'LBL_OUTPUT_DEFAULT', 'type' => 'enum', 'options' => 'dataset_output_default_dom', 'len' => 100, ), 'prespace_y' => array ( 'name' => 'prespace_y', 'vname' => 'LBL_PRESPACE_Y', 'type' => 'bool', 'dbType' => 'varchar', 'len' => '3', 'default' => '0', ), 'use_prev_header' => array ( 'name' => 'use_prev_header', 'vname' => 'LBL_USE_PREV_HEADER', 'type' => 'bool', 'dbType' => 'varchar', 'len' => '3', 'default' => '0', ), 'header_back_color' => array ( 'name' => 'header_back_color', 'vname' => 'LBL_HEADER_BACK_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 100, ), 'body_back_color' => array ( 'name' => 'body_back_color', 'vname' => 'LBL_BODY_BACK_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 100, ), 'header_text_color' => array ( 'name' => 'header_text_color', 'vname' => 'LBL_HEADER_TEXT_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 100, ), 'body_text_color' => array ( 'name' => 'body_text_color', 'vname' => 'LBL_BODY_TEXT_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 100, ), 'table_width_type' => array ( 'name' => 'table_width_type', 'vname' => 'LBL_TABLE_WIDTH_TYPE', 'type' => 'enum', 'options' => 'width_type_dom', 'len'=>3, ), 'custom_layout' => array ( 'name' => 'custom_layout', 'vname' => 'LBL_CUSTOM_LAYOUT', 'type' => 'enum', 'options' => 'custom_layout_dom', 'len'=>10, ), ), 'acls' => array('SugarACLAdminOnly' => array('allowUserRead' => true)), 'indices' => array ( array('name' =>'dataset_k', 'type' =>'primary', 'fields'=>array('id')), array('name' =>'idx_dataset', 'type'=>'index', 'fields'=>array('name','deleted')), ) ); VardefManager::createVardef('DataSets','DataSet', array( 'team_security', )); $dictionary['DataSet_Layout'] = array( 'table' => 'dataset_layouts', 'fields' => array( 'id' => array( 'name' => 'id', 'vname' => 'LBL_NAME', 'type' => 'id', 'required' => true, 'reportable' => false, ), 'deleted' => array( 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => true, 'default' => '0', 'reportable' => false, ), 'date_entered' => array( 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true, ), 'date_modified' => array( 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true, ), 'modified_user_id' => array( 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', 'reportable' => true, ), 'created_by' => array( 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', ), 'parent_value' => array( 'name' => 'parent_value', 'vname' => 'LBL_PARENT_VALUE', 'type' => 'varchar', 'len' => '50', ), 'layout_type' => array( 'name' => 'layout_type', 'vname' => 'LBL_LAYOUT_TYPE', 'type' => 'enum', 'required' => true, 'options' => 'dataset_layout_type_dom', 'len' => 25, ), 'parent_id' => array( 'name' => 'parent_id', 'type' => 'id', 'required' => false, 'reportable' => false, ), 'list_order_x' => array( 'name' => 'list_order_x', 'vname' => 'LBL_LIST_ORDER_X', 'type' => 'int', 'len' => '4', ), 'list_order_z' => array( 'name' => 'list_order_z', 'vname' => 'LBL_LIST_ORDER_Z', 'type' => 'int', 'len' => '4', ), 'row_header_id' => array( 'name' => 'row_header_id', 'vname' => 'LBL_ROW_HEADER_ID', 'type' => 'id', ), 'hide_column' => array( 'name' => 'hide_column', 'vname' => 'LBL_HIDE_COLUMN', 'type' => 'bool', 'dbType' => 'varchar', 'len' => '3', ), ), 'indices' => array( array( 'name' => 'datasetlayout_k', 'type' => 'primary', 'fields' => array('id'), ), array( 'name' => 'idx_datasetlayout', 'type' => 'index', 'fields' => array('parent_value', 'deleted'), ), ), ); $dictionary['DataSet_Attribute'] = array( 'table' => 'dataset_attributes', 'fields' => array( 'id' => array( 'name' => 'id', 'vname' => 'LBL_NAME', 'type' => 'id', 'required' => true, 'reportable' => false, ), 'deleted' => array( 'name' => 'deleted', 'vname' => 'LBL_DELETED', 'type' => 'bool', 'required' => true, 'default' => '0', 'reportable' => false, ), 'date_entered' => array( 'name' => 'date_entered', 'vname' => 'LBL_DATE_ENTERED', 'type' => 'datetime', 'required' => true, ), 'date_modified' => array( 'name' => 'date_modified', 'vname' => 'LBL_DATE_MODIFIED', 'type' => 'datetime', 'required' => true, ), 'modified_user_id' => array( 'name' => 'modified_user_id', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', 'reportable' => true, ), 'created_by' => array( 'name' => 'created_by', 'rname' => 'user_name', 'id_name' => 'modified_user_id', 'vname' => 'LBL_ASSIGNED_TO', 'type' => 'assigned_user_name', 'table' => 'users', 'isnull' => false, 'dbType' => 'id', ), 'display_type' => array( 'name' => 'display_type', 'vname' => 'LBL_DISPLAY_TYPE', 'type' => 'enum', 'required' => true, 'options' => 'dataset_att_display_type_dom', 'len' => 25, ), 'display_name' => array( 'name' => 'display_name', 'vname' => 'LBL_DISPLAY_NAME', 'type' => 'varchar', 'len' => '50', ), 'attribute_type' => array( 'name' => 'attribute_type', 'vname' => 'LBL_ATT_TYPE', 'type' => 'varchar', 'required' => true, 'len' => 8, ), 'parent_id' => array( 'name' => 'parent_id', 'type' => 'id', 'required' => false, 'reportable' => false, ), 'font_size' => array( 'name' => 'font_size', 'vname' => 'LBL_FONT_SIZE', 'type' => 'enum', 'options' => 'font_size_dom', 'len' => 8, 'default' => '0', ), 'cell_size' => array( 'name' => 'cell_size', 'vname' => 'LBL_CELL_SIZE', 'type' => 'varchar', 'len' => '3', ), 'size_type' => array( 'name' => 'size_type', 'vname' => 'LBL_SIZE_TYPE', 'type' => 'enum', 'options' => 'width_type_dom', 'len' => 3, ), 'bg_color' => array( 'name' => 'bg_color', 'vname' => 'LBL_BG_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 25, ), 'font_color' => array( 'name' => 'font_color', 'vname' => 'LBL_FONT_COLOR', 'type' => 'enum', 'options' => 'report_color_dom', 'len' => 25, ), 'wrap' => array( 'name' => 'wrap', 'vname' => 'LBL_WRAP', 'type' => 'bool', 'dbType' => 'varchar', 'len' => '3', ), 'style' => array( 'name' => 'style', 'vname' => 'LBL_STYLE', 'type' => 'enum', 'options' => 'dataset_style_dom', 'len' => 25, ), 'format_type' => array( 'name' => 'format_type', 'vname' => 'LBL_FORMAT_TYPE', 'type' => 'enum', 'required' => true, 'options' => 'dataset_att_format_type_dom', 'len' => 25, ), ), 'indices' => array( array( 'name' => 'datasetatt_k', 'type' => 'primary', 'fields' => array('id'), ), array( 'name' => 'idx_datasetatt', 'type' => 'index', 'fields' => array('parent_id', 'deleted'), ), ), );