<?php

$_['main_sheet'] = array(
    'name' => 'Filters',
    'table' => array(
        'name' => 'fg',
        'full_name' => 'filter_group',
        'key' => 'filter_group_id'
        ),

    'tables' => array(
        array(
            'name' => 'fgd',
            'full_name' => 'filter_group_description',
            'key' => 'filter_group_id',
            'join' => 'INNER',
            'multi_language' => 1
            )
        ),

    'columns' => array(
        array(
            'column' => 'filter_group_id',
            'table' => 'fg',
            'name' => 'Filter Group ID',
            'filter' => 1
            ),
        array(
            'column' => 'name',
            'table' => 'fgd',
            'name' => 'Name',
            'filter' => 1
            ),
        array(
            'column' => 'sort_order',
            'table' => 'fg',
            'name' => 'Sort Order',
            'filter' => 1
            ),
        ),

    'values' => array(
        'table' => array(
            'name' => 'f',
            'full_name' => 'filter',
            'key' => 'filter_id',
            'related_key' => 'filter_group_id'
            ),
        'tables' => array(
            array(
                'name' => 'fd',
                'full_name' => 'filter_description',
                'key' => 'filter_id',
                'require_key' => 'filter_group_id',
                'join' => 'INNER',
                'multi_language' => 1
                )
            ),
        'columns' => array(
            array(
                'column' => 'filter_id',
                'table' => 'f',
                'name' => 'Filter ID'
                ),
            array(
                'column' => 'name',
                'table' => 'fd',
                'name' => 'Name'
                ),
            array(
                'column' => 'sort_order',
                'table' => 'f',
                'name' => 'Sort Order'
                ),
            )
        ),
    );

$_['sheets'] = array();