NAME
Mango::Schema::Order::Item - DBIC schema class for order items
SYNOPSIS
use Mango::Schema;
my $schema = Mango::Schema->connect;
my $items = $schema->resultset('OrderItems')->search;DESCRIPTION
Mango::Schema::Order::Item is loaded by Mango::Schema to read/write order item data.
COLUMNS
id
Contains the primary key for each order item record.
id => {
data_type => 'INT',
is_auto_increment => 1,
is_nullable => 0,
extras => {unsigned => 1}
},order_id
Contains the foreign key to the orders table.
order_id => {
data_type => 'INT',
is_nullable => 0,
is_foreign_key => 1,
extras => {unsigned => 1}
},sku
Contains the sku (Stock Keeping Unit), or part number for the current order item.
sku => {
data_type => 'VARCHAR',
size => 25,
is_nullable => 0,
},quantity
Contains the number of this order item being ordered.
quantity => {
data_type => 'TINYINT',
size => 3,
is_nullable => 0,
default_value => 1,
extras => {unsigned => 1}
},price
The price of the current order item.
price => {
data_type => 'DECIMAL',
size => [9,2],
is_nullable => 0,
default_value => '0.00'
},total
The total cost of this order item.
total => {
data_type => 'DECIMAL',
size => [9,2],
is_nullable => 0,
default_value => '0.00'
},description
Contains the description of the current order item.
description => {
data_type => 'VARCHAR',
size => 255,
is_nullable => 1,
default_value => undef
},created
When the order item record was created.
created => {
data_type => 'DATETIME',
is_nullable => 0
},updated
When the order item record was updated.
updated => {
data_type => 'DATETIME',
is_nullable => 0
}AUTHOR
Christopher H. Laco
CPAN ID: CLACO
claco@chrislaco.com
http://today.icantfocus.com/blog/