<?php

$_['main_sheet'] = array(
    'name' => 'Attributes',
    'table' => array(
        'name' => 'ag',
        'full_name' => 'attribute_group',
        'key' => 'attribute_group_id'
        ),

    'tables' => array(
        array(
            'name' => 'agd',
            'full_name' => 'attribute_group_description',
            'key' => 'attribute_group_id',
            'join' => 'INNER',
            'multi_language' => 1
            )
        ),

    'columns' => array(
        array(
            'column' => 'attribute_group_id',
            'table' => 'ag',
            'name' => 'Attribute Group ID',
            'filter' => 1
            ),
        array(
            'column' => 'name',
            'table' => 'agd',
            'name' => 'Name',
            'filter' => 1
            ),
        array(
            'column' => 'sort_order',
            'table' => 'ag',
            'name' => 'Sort Order',
            'filter' => 1
            ),
        ),

    'values' => array(
        'table' => array(
            'name' => 'a',
            'full_name' => 'attribute',
            'key' => 'attribute_id',
            'related_key' => 'attribute_group_id'
            ),
        'tables' => array(
            array(
                'name' => 'ad',
                'full_name' => 'attribute_description',
                'key' => 'attribute_id',
                'join' => 'INNER',
                'multi_language' => 1
                )
            ),
        'columns' => array(
            array(
                'column' => 'attribute_id',
                'table' => 'a',
                'name' => 'Attribute ID'
                ),
            array(
                'column' => 'name',
                'table' => 'ad',
                'name' => 'Name'
                ),
            array(
                'column' => 'sort_order',
                'table' => 'a',
                'name' => 'Sort Order'
                ),
            )
        ),
    );

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