2 package Koha::Schema::Result::Aqcontact;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Aqcontact
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<aqcontacts>
22 __PACKAGE__->table("aqcontacts");
32 primary key and unique number assigned by Koha
40 name of contact at vendor
48 contact person's position
56 contact's phone number
64 contact's alternate phone number
80 contact's email address
87 notes related to the contact
89 =head2 orderacquisition
95 should this contact receive acquisition orders
97 =head2 claimacquisition
103 should this contact receive acquisitions claims
111 should this contact receive serial claims
119 is this the primary contact for acquisitions messages
121 =head2 serialsprimary
127 is this the primary contact for serials messages
137 __PACKAGE__->add_columns(
139 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
141 { data_type => "varchar", is_nullable => 1, size => 100 },
143 { data_type => "varchar", is_nullable => 1, size => 100 },
145 { data_type => "varchar", is_nullable => 1, size => 100 },
147 { data_type => "varchar", is_nullable => 1, size => 100 },
149 { data_type => "varchar", is_nullable => 1, size => 100 },
151 { data_type => "varchar", is_nullable => 1, size => 100 },
153 { data_type => "longtext", is_nullable => 1 },
155 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
157 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
159 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
161 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
163 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
165 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
178 __PACKAGE__->set_primary_key("id");
186 Related object: L<Koha::Schema::Result::Aqbookseller>
190 __PACKAGE__->belongs_to(
192 "Koha::Schema::Result::Aqbookseller",
193 { id => "booksellerid" },
194 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
198 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
199 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IefjqDsoXPLWKSfhYGne1A
201 __PACKAGE__->add_columns(
202 '+orderacquisition' => { is_boolean => 1 },
203 '+claimacquisition' => { is_boolean => 1 },
204 '+claimissues' => { is_boolean => 1 },
205 '+acqprimary' => { is_boolean => 1 },
206 '+serialsprimary' => { is_boolean => 1 },
209 sub koha_object_class {
210 'Koha::Acquisition::Bookseller::Contact';
212 sub koha_objects_class {
213 'Koha::Acquisition::Bookseller::Contacts';