use utf8;
package Interchange6::Schema::Result::Order;
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
=head1 NAME
Interchange6::Schema::Result::Order
=cut
use strict;
use warnings;
use base 'DBIx::Class::Core';
=head1 TABLE: C<orders>
=cut
__PACKAGE__->table("orders");
=head1 ACCESSORS
=head2 orders_id
data_type: 'integer'
is_auto_increment: 1
is_nullable: 0
sequence: 'orders_orders_id_seq'
=head2 order_number
data_type: 'varchar'
is_nullable: 0
size: 24
=head2 order_date
data_type: 'timestamp'
is_nullable: 1
=head2 users_id
data_type: 'integer'
is_foreign_key: 1
is_nullable: 0
=head2 email
data_type: 'varchar'
default_value: (empty string)
is_nullable: 0
size: 255
=head2 shipping_addresses_id
data_type: 'integer'
is_foreign_key: 1
is_nullable: 0
=head2 billing_addresses_id
data_type: 'integer'
is_foreign_key: 1
is_nullable: 0
=head2 weight
data_type: 'numeric'
default_value: 0.0
is_nullable: 0
=head2 payment_method
data_type: 'varchar'
default_value: (empty string)
is_nullable: 0
size: 255
=head2 payment_number
data_type: 'varchar'
default_value: (empty string)
is_nullable: 0
size: 255
=head2 payment_status
data_type: 'varchar'
default_value: (empty string)
is_nullable: 0
size: 255
=head2 shipping_method
data_type: 'varchar'
default_value: (empty string)
is_nullable: 0
size: 255
=head2 tracking_number
data_type: 'varchar'
default_value: (empty string)
is_nullable: 0
size: 255
=head2 subtotal
data_type: 'numeric'
default_value: 0.0
is_nullable: 0
size: [11,2]
=head2 shipping
data_type: 'numeric'
default_value: 0.0
is_nullable: 0
size: [11,2]
=head2 handling
data_type: 'numeric'
default_value: 0.0
is_nullable: 0
size: [11,2]
=head2 salestax
data_type: 'numeric'
default_value: 0.0
is_nullable: 0
size: [11,2]
=head2 total_cost
data_type: 'numeric'
default_value: 0.0
is_nullable: 0
size: [11,2]
=head2 status
data_type: 'varchar'
default_value: (empty string)
is_nullable: 0
size: 24
=cut
__PACKAGE__->add_columns(
"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 => "", 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 => "", is_nullable => 0, size => 255 },
"payment_number",
{ data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
"payment_status",
{ data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
"shipping_method",
{ data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
"tracking_number",
{ data_type => "varchar", default_value => "", 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 => "", is_nullable => 0, size => 24 },
);
=head1 PRIMARY KEY
=over 4
=item * L</orders_id>
=back
=cut
__PACKAGE__->set_primary_key("orders_id");
=head1 UNIQUE CONSTRAINTS
=head2 C<orders_order_number_key>
=over 4
=item * L</order_number>
=back
=cut
__PACKAGE__->add_unique_constraint("orders_order_number_key", ["order_number"]);
=head1 RELATIONS
=head2 ShippingAddress
Type: belongs_to
Related object: L<Interchange6::Schema::Result::Address>
=cut
__PACKAGE__->belongs_to(
"ShippingAddress",
"Interchange6::Schema::Result::Address",
{ addresses_id => "shipping_addresses_id" },
{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 BillingAddress
Type: belongs_to
Related object: L<Interchange6::Schema::Result::Address>
=cut
__PACKAGE__->belongs_to(
"BillingAddress",
"Interchange6::Schema::Result::Address",
{ addresses_id => "billing_addresses_id" },
{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 orderlines
Type: has_many
Related object: L<Interchange6::Schema::Result::Orderline>
=cut
__PACKAGE__->has_many(
"Orderline",
"Interchange6::Schema::Result::Orderline",
{ "foreign.order_number" => "self.order_number" },
{ cascade_copy => 0, cascade_delete => 0 },
);
=head2 PaymentOrder
Type: has_many
Related object: L<Interchange6::Schema::Result::PaymentOrder>
=cut
__PACKAGE__->has_many(
"PaymentOrders",
"Interchange6::Schema::Result::PaymentOrder",
{ "foreign.order_number" => "self.order_number" },
{ cascade_copy => 0, cascade_delete => 0 },
);
=head2 User
Type: belongs_to
Related object: L<Interchange6::Schema::Result::User>
=cut
__PACKAGE__->belongs_to(
"User",
"Interchange6::Schema::Result::User",
{ users_id => "users_id" },
{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-11-08 09:38:12
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uxX60rXHAH7ndGzsvd5jcw
# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;