NAME

Interchange6::Schema::Result::Review

TABLE: reviews

DESCRIPTION

User product reviews

reviews_id:

sku:

title:

content:

users_id:

rating: Numeric range 1.0 to 5.0 for item rating.

recommend:

public: Default is false

approved: Default is false

created:

ACCESSORS

reviews_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

sku

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 0
  size: 64

title

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 255

content

  data_type: 'text'
  is_nullable: 0

users_id

  is_foreign_key: 1
  is_nullable: 0

rating

  data_type: 'numeric'
  default_value: 0.0
  is_nullable: 0
  size: [4,2]

recommend

  data_type: 'boolean'
  is_nullable: 1

public

  data_type: 'boolean'
  default_value: false
  is_nullable: 0

approved

  data_type: 'boolean'
  default_value: false
  is_nullable: 0

created

  data_type: 'datetime'
  set_on_create: 1
  is_nullable: 0

PRIMARY KEY

• "reviews_id"

RELATIONS

User

Type: belongs_to

Related object: Interchange6::Schema::Result::User

Product

Type: belongs_to

Related object: Interchange6::Schema::Result::Product

cpanm Interchange6::Schema

perl -MCPAN -e shell
install Interchange6::Schema