<?php
/**
* @table goods_keywords;
*
* @package Schemas
* @version $
* @copyright 2003-2009 ShopEx
* @license Commercial
*/

$db['goods_keywords']=array (
  'columns' => 
  array (
    'goods_id' => 
    array (
      'type' => 'object:goods/products',
      'required' => true,
      'default' => 0,
      'pkey' => true,
      'editable' => false,
    ),
    'keyword' => 
    array (
      'type' => 'varchar(40)',
      'default' => '',
      'required' => true,
      'pkey' => true,
      'editable' => false,
    ),
    'refer'=>array(
      'type' => 'varchar(255)',
      'default' => '',
      'required' => false,
      'editable' => false
    ),
    'res_type'=>array(
      'type' => 'enum(\'goods\',\'article\')',
      'default' => 'goods',
      'required' => true,
      'pkey' => true,
      'editable' => false
    )
  ),
  'pkeys'=>array(
      'keyword','goods_id','res_type'
  )
);