NAME

Interchange6::Schema::Result::Order

TABLE: orders

ACCESSORS

orders_id

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

order_number

data_type: 'varchar'
is_nullable: 0
size: 24

order_date

data_type: 'timestamp'
is_nullable: 1

users_id

data_type: 'integer'
is_foreign_key: 1
is_nullable: 0

email

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

shipping_addresses_id

data_type: 'integer'
is_foreign_key: 1
is_nullable: 0

billing_addresses_id

data_type: 'integer'
is_foreign_key: 1
is_nullable: 0

weight

data_type: 'numeric'
default_value: 0.0
is_nullable: 0

payment_method

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

payment_number

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

payment_status

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

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

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]

total_cost

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

• "orders_id"

UNIQUE CONSTRAINTS

orders_order_number_key

• "order_number"

RELATIONS

ShippingAddress

Type: belongs_to

Related object: Interchange6::Schema::Result::Address

BillingAddress

Type: belongs_to

Related object: Interchange6::Schema::Result::Address

orderlines

Type: has_many

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

PaymentOrder

Type: has_many

Related object: Interchange6::Schema::Result::PaymentOrder

User

Type: belongs_to

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

cpanm Interchange6::Schema

perl -MCPAN -e shell
install Interchange6::Schema