NAME

Interchange6::Schema::Result::Orderline

TABLE: orderlines

ACCESSORS

orderlines_id

data_type: 'integer'
is_auto_increment: 1
is_nullable: 0
sequence: 'orderlines_orderlines_id_seq'

order_number

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

order_position

data_type: 'integer'
default_value: 0
is_nullable: 0

sku

data_type: 'varchar'
is_foreign_key: 1
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

weight

data_type: 'numeric'
default_value: 0.0
is_nullable: 0

quantity

data_type: 'integer'
is_nullable: 1

shipping_method

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

tracking_number

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

price

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

subtotal

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

shipping

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

handling

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

salestax

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

status

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

PRIMARY KEY

• "orderlines_id"

RELATIONS

Order

Type: belongs_to

Related object: Interchange6::Schema::Result::Order

OrderlinesShipping

Type: has_many

Related object: Interchange6::Schema::Result::OrderlinesShipping

Product

Type: belongs_to

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

addresses

Type: many_to_many

Composing rels: "OrderlinesShipping" -> Address

cpanm Interchange6::Schema

perl -MCPAN -e shell
install Interchange6::Schema