data_type: 'text'
is_nullable: 1
-=head2 b_streetnumber
+=head2 B_streetnumber
+ accessor: 'b_streetnumber'
data_type: 'varchar'
is_nullable: 1
size: 10
-=head2 b_streettype
+=head2 B_streettype
+ accessor: 'b_streettype'
data_type: 'varchar'
is_nullable: 1
size: 50
-=head2 b_address
+=head2 B_address
+ accessor: 'b_address'
data_type: 'varchar'
is_nullable: 1
size: 100
-=head2 b_address2
+=head2 B_address2
+ accessor: 'b_address2'
data_type: 'text'
is_nullable: 1
-=head2 b_city
+=head2 B_city
+ accessor: 'b_city'
data_type: 'mediumtext'
is_nullable: 1
-=head2 b_state
+=head2 B_state
+ accessor: 'b_state'
data_type: 'text'
is_nullable: 1
-=head2 b_zipcode
+=head2 B_zipcode
+ accessor: 'b_zipcode'
data_type: 'varchar'
is_nullable: 1
size: 25
-=head2 b_country
+=head2 B_country
+ accessor: 'b_country'
data_type: 'text'
is_nullable: 1
-=head2 b_email
+=head2 B_email
+ accessor: 'b_email'
data_type: 'text'
is_nullable: 1
-=head2 b_phone
+=head2 B_phone
+ accessor: 'b_phone'
data_type: 'mediumtext'
is_nullable: 1
is_nullable: 1
size: 100
-=head2 ethnicity
-
- data_type: 'varchar'
- is_nullable: 1
- size: 50
-
-=head2 ethnotes
-
- data_type: 'varchar'
- is_nullable: 1
- size: 255
-
=head2 sex
data_type: 'varchar'
is_nullable: 1
size: 50
+=head2 sms_provider_id
+
+ data_type: 'integer'
+ is_foreign_key: 1
+ is_nullable: 1
+
=head2 privacy
data_type: 'integer'
default_value: 1
is_nullable: 0
+=head2 privacy_guarantor_checkouts
+
+ data_type: 'tinyint'
+ default_value: 0
+ is_nullable: 0
+
=cut
__PACKAGE__->add_columns(
{ data_type => "text", is_nullable => 1 },
"phonepro",
{ data_type => "text", is_nullable => 1 },
- "b_streetnumber",
- { data_type => "varchar", is_nullable => 1, size => 10 },
- "b_streettype",
- { data_type => "varchar", is_nullable => 1, size => 50 },
- "b_address",
- { data_type => "varchar", is_nullable => 1, size => 100 },
- "b_address2",
- { data_type => "text", is_nullable => 1 },
- "b_city",
- { data_type => "mediumtext", is_nullable => 1 },
- "b_state",
- { data_type => "text", is_nullable => 1 },
- "b_zipcode",
- { data_type => "varchar", is_nullable => 1, size => 25 },
- "b_country",
- { data_type => "text", is_nullable => 1 },
- "b_email",
- { data_type => "text", is_nullable => 1 },
- "b_phone",
- { data_type => "mediumtext", is_nullable => 1 },
+ "B_streetnumber",
+ {
+ accessor => "b_streetnumber",
+ data_type => "varchar",
+ is_nullable => 1,
+ size => 10,
+ },
+ "B_streettype",
+ {
+ accessor => "b_streettype",
+ data_type => "varchar",
+ is_nullable => 1,
+ size => 50,
+ },
+ "B_address",
+ {
+ accessor => "b_address",
+ data_type => "varchar",
+ is_nullable => 1,
+ size => 100,
+ },
+ "B_address2",
+ { accessor => "b_address2", data_type => "text", is_nullable => 1 },
+ "B_city",
+ { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
+ "B_state",
+ { accessor => "b_state", data_type => "text", is_nullable => 1 },
+ "B_zipcode",
+ {
+ accessor => "b_zipcode",
+ data_type => "varchar",
+ is_nullable => 1,
+ size => 25,
+ },
+ "B_country",
+ { accessor => "b_country", data_type => "text", is_nullable => 1 },
+ "B_email",
+ { accessor => "b_email", data_type => "text", is_nullable => 1 },
+ "B_phone",
+ { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
"dateofbirth",
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
"branchcode",
{ data_type => "mediumtext", is_nullable => 1 },
"relationship",
{ data_type => "varchar", is_nullable => 1, size => 100 },
- "ethnicity",
- { data_type => "varchar", is_nullable => 1, size => 50 },
- "ethnotes",
- { data_type => "varchar", is_nullable => 1, size => 255 },
"sex",
{ data_type => "varchar", is_nullable => 1, size => 1 },
"password",
{ data_type => "varchar", is_nullable => 1, size => 50 },
"smsalertnumber",
{ data_type => "varchar", is_nullable => 1, size => 50 },
+ "sms_provider_id",
+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
"privacy",
{ data_type => "integer", default_value => 1, is_nullable => 0 },
+ "privacy_guarantor_checkouts",
+ { data_type => "tinyint", default_value => 0, is_nullable => 0 },
);
=head1 PRIMARY KEY
__PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
+=head2 C<userid>
+
+=over 4
+
+=item * L</userid>
+
+=back
+
+=cut
+
+__PACKAGE__->add_unique_constraint("userid", ["userid"]);
+
=head1 RELATIONS
=head2 accountlines
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 aqbasketusers
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Aqbasketuser>
+
+=cut
+
+__PACKAGE__->has_many(
+ "aqbasketusers",
+ "Koha::Schema::Result::Aqbasketuser",
+ { "foreign.borrowernumber" => "self.borrowernumber" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 aqbudgetborrowers
Type: has_many
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 aqorder_users
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::AqorderUser>
+
+=cut
+
+__PACKAGE__->has_many(
+ "aqorder_users",
+ "Koha::Schema::Result::AqorderUser",
+ { "foreign.borrowernumber" => "self.borrowernumber" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 borrower_attributes
Type: has_many
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 borrower_debarments
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::BorrowerDebarment>
+
+=cut
+
+__PACKAGE__->has_many(
+ "borrower_debarments",
+ "Koha::Schema::Result::BorrowerDebarment",
+ { "foreign.borrowernumber" => "self.borrowernumber" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 borrower_files
Type: has_many
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 borrower_syncs
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::BorrowerSync>
+
+=cut
+
+__PACKAGE__->has_many(
+ "borrower_syncs",
+ "Koha::Schema::Result::BorrowerSync",
+ { "foreign.borrowernumber" => "self.borrowernumber" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 branchcode
Type: belongs_to
"branchcode",
"Koha::Schema::Result::Branch",
{ branchcode => "branchcode" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
);
=head2 categorycode
"categorycode",
"Koha::Schema::Result::Category",
{ categorycode => "categorycode" },
- { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
);
=head2 course_instructors
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 discharges
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::Discharge>
+
+=cut
+
+__PACKAGE__->has_many(
+ "discharges",
+ "Koha::Schema::Result::Discharge",
+ { "foreign.borrower" => "self.borrowernumber" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 hold_fill_targets
Type: has_many
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 items_last_borrowers
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::ItemsLastBorrower>
+
+=cut
+
+__PACKAGE__->has_many(
+ "items_last_borrowers",
+ "Koha::Schema::Result::ItemsLastBorrower",
+ { "foreign.borrowernumber" => "self.borrowernumber" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 message_queues
Type: has_many
{ cascade_copy => 0, cascade_delete => 0 },
);
-=head2 patron_list_patrons
+=head2 opac_news
Type: has_many
-Related object: L<Koha::Schema::Result::PatronListPatron>
+Related object: L<Koha::Schema::Result::OpacNews>
=cut
__PACKAGE__->has_many(
- "patron_list_patrons",
- "Koha::Schema::Result::PatronListPatron",
+ "opac_news",
+ "Koha::Schema::Result::OpacNews",
{ "foreign.borrowernumber" => "self.borrowernumber" },
{ cascade_copy => 0, cascade_delete => 0 },
);
-=head2 patron_lists
+=head2 patron_list_patrons
Type: has_many
-Related object: L<Koha::Schema::Result::PatronList>
+Related object: L<Koha::Schema::Result::PatronListPatron>
=cut
__PACKAGE__->has_many(
- "patron_lists",
- "Koha::Schema::Result::PatronList",
- { "foreign.owner" => "self.borrowernumber" },
+ "patron_list_patrons",
+ "Koha::Schema::Result::PatronListPatron",
+ { "foreign.borrowernumber" => "self.borrowernumber" },
{ cascade_copy => 0, cascade_delete => 0 },
);
-=head2 patroncards
+=head2 patron_lists
Type: has_many
-Related object: L<Koha::Schema::Result::Patroncard>
+Related object: L<Koha::Schema::Result::PatronList>
=cut
__PACKAGE__->has_many(
- "patroncards",
- "Koha::Schema::Result::Patroncard",
- { "foreign.borrowernumber" => "self.borrowernumber" },
+ "patron_lists",
+ "Koha::Schema::Result::PatronList",
+ { "foreign.owner" => "self.borrowernumber" },
{ cascade_copy => 0, cascade_delete => 0 },
);
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 sms_provider
+
+Type: belongs_to
+
+Related object: L<Koha::Schema::Result::SmsProvider>
+
+=cut
+
+__PACKAGE__->belongs_to(
+ "sms_provider",
+ "Koha::Schema::Result::SmsProvider",
+ { id => "sms_provider_id" },
+ {
+ is_deferrable => 1,
+ join_type => "LEFT",
+ on_delete => "RESTRICT",
+ on_update => "RESTRICT",
+ },
+);
+
=head2 subscriptionroutinglists
Type: has_many
{ cascade_copy => 0, cascade_delete => 0 },
);
+=head2 basketnoes
+
+Type: many_to_many
+
+Composing rels: L</aqbasketusers> -> basketno
+
+=cut
+
+__PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
+
=head2 budgets
Type: many_to_many
__PACKAGE__->many_to_many("courses", "course_instructors", "course");
+=head2 ordernumbers
+
+Type: many_to_many
+
+Composing rels: L</aqorder_users> -> ordernumber
+
+=cut
+
+__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
+
-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 21:34:14
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MW1ML4Sc1swrZCYxL/yMzA
+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-12-31 16:48:38
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dd1tdtsFTruFwsmCZU6ogQ
+__PACKAGE__->belongs_to(
+ "guarantor",
+ "Koha::Schema::Result::Borrower",
+ { borrowernumber => "guarantorid" },
+);
-# You can replace this text with custom content, and it will be preserved on regeneration
1;