Christopher H. Laco > Mango-0.01000_13 > Mango::Schema::Order::Item

Download:
Mango-0.01000_13.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Source  

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/
syntax highlighting: