use utf8; package CLMApp::Schema::Result::PreSaleItem; # Created by DBIx::Class::Schema::Loader # DO NOT MODIFY THE FIRST PART OF THIS FILE =head1 NAME CLMApp::Schema::Result::PreSaleItem =cut use strict; use warnings; use base 'DBIx::Class::Core'; =head1 COMPONENTS LOADED =over 4 =item * L =back =cut __PACKAGE__->load_components("InflateColumn::DateTime"); =head1 TABLE: C =cut __PACKAGE__->table("PreSaleItem"); =head1 ACCESSORS =head2 presaleitemid data_type: 'integer' is_auto_increment: 1 is_nullable: 0 =head2 distributorcompanyid data_type: 'integer' default_value: 0 is_nullable: 1 =head2 distributorwarehouseid data_type: 'integer' is_nullable: 0 =head2 chaingroupid data_type: 'integer' is_nullable: 0 =head2 chainconceptid data_type: 'integer' default_value: 0 is_nullable: 1 =head2 itemnumber data_type: 'varchar' is_nullable: 1 size: 256 =head2 amphireitemid data_type: 'integer' default_value: 0 is_nullable: 1 =head2 description data_type: 'varchar' is_nullable: 1 size: 512 =head2 status data_type: 'varchar' is_nullable: 1 size: 20 =head2 updatedby data_type: 'integer' is_nullable: 0 =head2 created data_type: 'datetime' datetime_undef_if_invalid: 1 default_value: '0000-00-00 00:00:00' is_nullable: 1 =head2 updated data_type: 'datetime' datetime_undef_if_invalid: 1 default_value: '0000-00-00 00:00:00' is_nullable: 1 =head2 processed data_type: 'datetime' datetime_undef_if_invalid: 1 default_value: '0000-00-00 00:00:00' is_nullable: 1 =head2 sold data_type: 'datetime' datetime_undef_if_invalid: 1 default_value: '0000-00-00 00:00:00' is_nullable: 1 =head2 deleted data_type: 'tinyint' default_value: 0 is_nullable: 1 =head2 asstatus data_type: 'varchar' is_nullable: 1 size: 20 =head2 ascreated data_type: 'datetime' datetime_undef_if_invalid: 1 default_value: '0000-00-00 00:00:00' is_nullable: 1 =head2 asupdated data_type: 'datetime' datetime_undef_if_invalid: 1 default_value: '0000-00-00 00:00:00' is_nullable: 1 =head2 asprocessed data_type: 'datetime' datetime_undef_if_invalid: 1 default_value: '0000-00-00 00:00:00' is_nullable: 1 =head2 assold data_type: 'datetime' datetime_undef_if_invalid: 1 default_value: '0000-00-00 00:00:00' is_nullable: 1 =cut __PACKAGE__->add_columns( "presaleitemid", { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "distributorcompanyid", { data_type => "integer", default_value => 0, is_nullable => 1 }, "distributorwarehouseid", { data_type => "integer", is_nullable => 0 }, "chaingroupid", { data_type => "integer", is_nullable => 0 }, "chainconceptid", { data_type => "integer", default_value => 0, is_nullable => 1 }, "itemnumber", { data_type => "varchar", is_nullable => 1, size => 256 }, "amphireitemid", { data_type => "integer", default_value => 0, is_nullable => 1 }, "description", { data_type => "varchar", is_nullable => 1, size => 512 }, "status", { data_type => "varchar", is_nullable => 1, size => 20 }, "updatedby", { data_type => "integer", is_nullable => 0 }, "created", { data_type => "datetime", datetime_undef_if_invalid => 1, default_value => "0000-00-00 00:00:00", is_nullable => 1, }, "updated", { data_type => "datetime", datetime_undef_if_invalid => 1, default_value => "0000-00-00 00:00:00", is_nullable => 1, }, "processed", { data_type => "datetime", datetime_undef_if_invalid => 1, default_value => "0000-00-00 00:00:00", is_nullable => 1, }, "sold", { data_type => "datetime", datetime_undef_if_invalid => 1, default_value => "0000-00-00 00:00:00", is_nullable => 1, }, "deleted", { data_type => "tinyint", default_value => 0, is_nullable => 1 }, "asstatus", { data_type => "varchar", is_nullable => 1, size => 20 }, "ascreated", { data_type => "datetime", datetime_undef_if_invalid => 1, default_value => "0000-00-00 00:00:00", is_nullable => 1, }, "asupdated", { data_type => "datetime", datetime_undef_if_invalid => 1, default_value => "0000-00-00 00:00:00", is_nullable => 1, }, "asprocessed", { data_type => "datetime", datetime_undef_if_invalid => 1, default_value => "0000-00-00 00:00:00", is_nullable => 1, }, "assold", { data_type => "datetime", datetime_undef_if_invalid => 1, default_value => "0000-00-00 00:00:00", is_nullable => 1, }, ); =head1 PRIMARY KEY =over 4 =item * L =back =cut __PACKAGE__->add_unique_constraint( "ChainGroupIdDistributorWarehouseIdItemNumber", ["chaingroupid", "distributorwarehouseid", "itemnumber"], ); __PACKAGE__->set_primary_key("presaleitemid"); __PACKAGE__->belongs_to( "distributor", "CLMApp::Schema::Result::DistributorCompany", { "foreign.distributorcompanyid" => "self.distributorcompanyid" }, { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION", join_type => 'left' }, ); __PACKAGE__->belongs_to( "chaingrp", "CLMApp::Schema::Result::ChainGroup", { "foreign.chaingroupid" => "self.chaingroupid" }, { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION", join_type => 'left' }, ); __PACKAGE__->belongs_to( "warehouse", "CLMApp::Schema::Result::DistributorWarehouse", {"foreign.distributorwarehouseid" => "self.distributorwarehouseid"}, # [{ "foreign.distributorlocid" => "self.distributorwarehouse", # "foreign.parentid" => "self.distributorcompany" }], # AND = 1 hash, OR = multiple { is_deferrable => 1, on_delete => "NO ACTION", on_update => "NO ACTION", join_type => 'left' }, ); __PACKAGE__->belongs_to( "user", "CLMApp::Schema::Result::User", { "foreign.user_id" => "self.updatedby" }, { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION", join_type => 'left' }, ); # Created by DBIx::Class::Schema::Loader v0.07039 @ 2018-09-20 09:35:03 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Zhdskaz/5O/1b4LGfPw1aQ # You can replace this text with custom code or comments, and it will be preserved on regeneration 1;