/ 
Interchange6-Schema-0.010
River stage one • 1 direct dependent • 1 total dependent
/ Interchange6::Schema::Result::Product

NAME

Interchange6::Schema::Result::Product

TABLE: products

DESCRIPTION

The products table contains three product types parent, child and single.

  • Parent Product A parent product is a container product in which variations of parent product or "child products" are linked.

  • Child Product A child product for example "Acme Pro 10lb Dumbbell" would include the canonical_sku of the parent item whose description might be something like "Acme Pro Dumbbell". In general a child product would contain attributes while a parent product would not.

  • Single Product A single product does not have child products and will become a parent product if a child product exists.

sku:

name:

short_description:

description:

price:

uri: Unique product uri. Example "acme-pro-dumbbells"

weight:

priority: Display order priority.

gtin: EAN or UPC type data.

canonical_sku: If the product is a child of a parent product the parent product sku would be referenced here.

active: Default is true

inventory_exempt:

ACCESSORS

sku

data_type: 'varchar'
is_nullable: 0
size: 32

name

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

short_description

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

description

data_type: 'text'
default_value: (empty string)
is_nullable: 0

price

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

uri

data_type: 'varchar'
is_nullable: 1
size: 255

weight

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

priority

data_type: 'integer'
default_value: 0
is_nullable: 0

gtin

data_type: 'varchar'
is_nullable: 1
size: 32

canonical_sku

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

active

data_type: 'boolean'
default_value: true
is_nullable: 0

inventory_exempt

data_type: 'boolean'
default_value: false
is_nullable: 0

METHODS

path

Produces navigation path for this product. Returns array reference in scalar context.

PRIMARY KEY

UNIQUE CONSTRAINTS

products_gtin

products_uri

RELATIONS

CartProduct

Type: has_many

Related object: Interchange6::Schema::Result::CartProduct

GroupPricing

Type: has_many

Related object: Interchange6::Schema::Result::GroupPricing

Inventory

Type: might_have

Related object: Interchange6::Schema::Result::Inventory

MediaDisplay

Type: has_many

Related object: Interchange6::Schema::Result::MediaDisplay

MediaProduct

Type: has_many

Related object: Interchange6::Schema::Result::MediaProduct

MerchandisingProduct

Type: has_many

Related object: Interchange6::Schema::Result::MerchandisingProduct

MerchandisingProductRelated

Type: has_many

Related object: Interchange6::Schema::Result::MerchandisingProduct

Type: has_many

Related object: Interchange6::Schema::Result::NavigationProduct

Orderline

Type: has_many

Related object: Interchange6::Schema::Result::Orderline

ProductAttributes

Type: has_many

Related object: Interchange6::Schema::Result::ProductAttributes

product_attributes

Type: many_to_many

Composing rels: "ProductAttributes" -> ProductAttribute