use utf8; package Koha::Schema::Result::BorrowerModification; # Created by DBIx::Class::Schema::Loader # DO NOT MODIFY THE FIRST PART OF THIS FILE =head1 NAME Koha::Schema::Result::BorrowerModification =cut use strict; use warnings; use base 'DBIx::Class::Core'; =head1 TABLE: C =cut __PACKAGE__->table("borrower_modifications"); =head1 ACCESSORS =head2 timestamp data_type: 'timestamp' datetime_undef_if_invalid: 1 default_value: current_timestamp is_nullable: 0 =head2 verification_token data_type: 'varchar' default_value: (empty string) is_nullable: 0 size: 255 =head2 changed_fields data_type: 'mediumtext' is_nullable: 1 =head2 borrowernumber data_type: 'integer' default_value: 0 is_nullable: 0 =head2 cardnumber data_type: 'varchar' is_nullable: 1 size: 32 =head2 surname data_type: 'longtext' is_nullable: 1 =head2 firstname data_type: 'mediumtext' is_nullable: 1 =head2 middle_name data_type: 'longtext' is_nullable: 1 patron/borrower's middle name =head2 title data_type: 'longtext' is_nullable: 1 =head2 othernames data_type: 'longtext' is_nullable: 1 =head2 initials data_type: 'mediumtext' is_nullable: 1 =head2 pronouns data_type: 'longtext' is_nullable: 1 =head2 streetnumber data_type: 'varchar' is_nullable: 1 size: 10 =head2 streettype data_type: 'varchar' is_nullable: 1 size: 50 =head2 address data_type: 'longtext' is_nullable: 1 =head2 address2 data_type: 'mediumtext' is_nullable: 1 =head2 city data_type: 'longtext' is_nullable: 1 =head2 state data_type: 'mediumtext' is_nullable: 1 =head2 zipcode data_type: 'varchar' is_nullable: 1 size: 25 =head2 country data_type: 'mediumtext' is_nullable: 1 =head2 email data_type: 'longtext' is_nullable: 1 =head2 phone data_type: 'mediumtext' is_nullable: 1 =head2 mobile data_type: 'varchar' is_nullable: 1 size: 50 =head2 fax data_type: 'longtext' is_nullable: 1 =head2 emailpro data_type: 'mediumtext' is_nullable: 1 =head2 phonepro data_type: 'mediumtext' is_nullable: 1 =head2 B_streetnumber accessor: 'b_streetnumber' data_type: 'varchar' is_nullable: 1 size: 10 =head2 B_streettype accessor: 'b_streettype' data_type: 'varchar' is_nullable: 1 size: 50 =head2 B_address accessor: 'b_address' data_type: 'varchar' is_nullable: 1 size: 100 =head2 B_address2 accessor: 'b_address2' data_type: 'mediumtext' is_nullable: 1 =head2 B_city accessor: 'b_city' data_type: 'longtext' is_nullable: 1 =head2 B_state accessor: 'b_state' data_type: 'mediumtext' is_nullable: 1 =head2 B_zipcode accessor: 'b_zipcode' data_type: 'varchar' is_nullable: 1 size: 25 =head2 B_country accessor: 'b_country' data_type: 'mediumtext' is_nullable: 1 =head2 B_email accessor: 'b_email' data_type: 'mediumtext' is_nullable: 1 =head2 B_phone accessor: 'b_phone' data_type: 'longtext' is_nullable: 1 =head2 dateofbirth data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 =head2 branchcode data_type: 'varchar' is_nullable: 1 size: 10 =head2 categorycode data_type: 'varchar' is_nullable: 1 size: 10 =head2 dateenrolled data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 =head2 dateexpiry data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 =head2 date_renewed data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 =head2 gonenoaddress data_type: 'tinyint' is_nullable: 1 =head2 lost data_type: 'tinyint' is_nullable: 1 =head2 debarred data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 =head2 debarredcomment data_type: 'varchar' is_nullable: 1 size: 255 =head2 contactname data_type: 'longtext' is_nullable: 1 =head2 contactfirstname data_type: 'mediumtext' is_nullable: 1 =head2 contacttitle data_type: 'mediumtext' is_nullable: 1 =head2 borrowernotes data_type: 'longtext' is_nullable: 1 =head2 relationship data_type: 'varchar' is_nullable: 1 size: 100 =head2 sex data_type: 'varchar' is_nullable: 1 size: 1 =head2 password data_type: 'varchar' is_nullable: 1 size: 30 =head2 flags data_type: 'bigint' is_nullable: 1 =head2 userid data_type: 'varchar' is_nullable: 1 size: 75 =head2 opacnote data_type: 'longtext' is_nullable: 1 =head2 contactnote data_type: 'varchar' is_nullable: 1 size: 255 =head2 sort1 data_type: 'varchar' is_nullable: 1 size: 80 =head2 sort2 data_type: 'varchar' is_nullable: 1 size: 80 =head2 altcontactfirstname data_type: 'varchar' is_nullable: 1 size: 255 =head2 altcontactsurname data_type: 'varchar' is_nullable: 1 size: 255 =head2 altcontactaddress1 data_type: 'varchar' is_nullable: 1 size: 255 =head2 altcontactaddress2 data_type: 'varchar' is_nullable: 1 size: 255 =head2 altcontactaddress3 data_type: 'varchar' is_nullable: 1 size: 255 =head2 altcontactstate data_type: 'mediumtext' is_nullable: 1 =head2 altcontactzipcode data_type: 'varchar' is_nullable: 1 size: 50 =head2 altcontactcountry data_type: 'mediumtext' is_nullable: 1 =head2 altcontactphone data_type: 'varchar' is_nullable: 1 size: 50 =head2 smsalertnumber data_type: 'varchar' is_nullable: 1 size: 50 =head2 privacy data_type: 'integer' is_nullable: 1 =head2 extended_attributes data_type: 'mediumtext' is_nullable: 1 =head2 gdpr_proc_consent data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1 data processing consent =head2 primary_contact_method data_type: 'varchar' is_nullable: 1 size: 45 useful for reporting purposes =head2 lang data_type: 'varchar' is_nullable: 1 size: 25 =cut __PACKAGE__->add_columns( "timestamp", { data_type => "timestamp", datetime_undef_if_invalid => 1, default_value => \"current_timestamp", is_nullable => 0, }, "verification_token", { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 }, "changed_fields", { data_type => "mediumtext", is_nullable => 1 }, "borrowernumber", { data_type => "integer", default_value => 0, is_nullable => 0 }, "cardnumber", { data_type => "varchar", is_nullable => 1, size => 32 }, "surname", { data_type => "longtext", is_nullable => 1 }, "firstname", { data_type => "mediumtext", is_nullable => 1 }, "middle_name", { data_type => "longtext", is_nullable => 1 }, "title", { data_type => "longtext", is_nullable => 1 }, "othernames", { data_type => "longtext", is_nullable => 1 }, "initials", { data_type => "mediumtext", is_nullable => 1 }, "pronouns", { data_type => "longtext", is_nullable => 1 }, "streetnumber", { data_type => "varchar", is_nullable => 1, size => 10 }, "streettype", { data_type => "varchar", is_nullable => 1, size => 50 }, "address", { data_type => "longtext", is_nullable => 1 }, "address2", { data_type => "mediumtext", is_nullable => 1 }, "city", { data_type => "longtext", is_nullable => 1 }, "state", { data_type => "mediumtext", is_nullable => 1 }, "zipcode", { data_type => "varchar", is_nullable => 1, size => 25 }, "country", { data_type => "mediumtext", is_nullable => 1 }, "email", { data_type => "longtext", is_nullable => 1 }, "phone", { data_type => "mediumtext", is_nullable => 1 }, "mobile", { data_type => "varchar", is_nullable => 1, size => 50 }, "fax", { data_type => "longtext", is_nullable => 1 }, "emailpro", { data_type => "mediumtext", is_nullable => 1 }, "phonepro", { 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 => "mediumtext", is_nullable => 1 }, "B_city", { accessor => "b_city", data_type => "longtext", is_nullable => 1 }, "B_state", { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 }, "B_zipcode", { accessor => "b_zipcode", data_type => "varchar", is_nullable => 1, size => 25, }, "B_country", { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 }, "B_email", { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 }, "B_phone", { accessor => "b_phone", data_type => "longtext", is_nullable => 1 }, "dateofbirth", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "branchcode", { data_type => "varchar", is_nullable => 1, size => 10 }, "categorycode", { data_type => "varchar", is_nullable => 1, size => 10 }, "dateenrolled", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "dateexpiry", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "date_renewed", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "gonenoaddress", { data_type => "tinyint", is_nullable => 1 }, "lost", { data_type => "tinyint", is_nullable => 1 }, "debarred", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "debarredcomment", { data_type => "varchar", is_nullable => 1, size => 255 }, "contactname", { data_type => "longtext", is_nullable => 1 }, "contactfirstname", { data_type => "mediumtext", is_nullable => 1 }, "contacttitle", { data_type => "mediumtext", is_nullable => 1 }, "borrowernotes", { data_type => "longtext", is_nullable => 1 }, "relationship", { data_type => "varchar", is_nullable => 1, size => 100 }, "sex", { data_type => "varchar", is_nullable => 1, size => 1 }, "password", { data_type => "varchar", is_nullable => 1, size => 30 }, "flags", { data_type => "bigint", is_nullable => 1 }, "userid", { data_type => "varchar", is_nullable => 1, size => 75 }, "opacnote", { data_type => "longtext", is_nullable => 1 }, "contactnote", { data_type => "varchar", is_nullable => 1, size => 255 }, "sort1", { data_type => "varchar", is_nullable => 1, size => 80 }, "sort2", { data_type => "varchar", is_nullable => 1, size => 80 }, "altcontactfirstname", { data_type => "varchar", is_nullable => 1, size => 255 }, "altcontactsurname", { data_type => "varchar", is_nullable => 1, size => 255 }, "altcontactaddress1", { data_type => "varchar", is_nullable => 1, size => 255 }, "altcontactaddress2", { data_type => "varchar", is_nullable => 1, size => 255 }, "altcontactaddress3", { data_type => "varchar", is_nullable => 1, size => 255 }, "altcontactstate", { data_type => "mediumtext", is_nullable => 1 }, "altcontactzipcode", { data_type => "varchar", is_nullable => 1, size => 50 }, "altcontactcountry", { data_type => "mediumtext", is_nullable => 1 }, "altcontactphone", { data_type => "varchar", is_nullable => 1, size => 50 }, "smsalertnumber", { data_type => "varchar", is_nullable => 1, size => 50 }, "privacy", { data_type => "integer", is_nullable => 1 }, "extended_attributes", { data_type => "mediumtext", is_nullable => 1 }, "gdpr_proc_consent", { data_type => "datetime", datetime_undef_if_invalid => 1, is_nullable => 1, }, "primary_contact_method", { data_type => "varchar", is_nullable => 1, size => 45 }, "lang", { data_type => "varchar", is_nullable => 1, size => 25 }, ); =head1 PRIMARY KEY =over 4 =item * L =item * L =back =cut __PACKAGE__->set_primary_key("verification_token", "borrowernumber"); # Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-08 13:26:34 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pgmClJsT12pxLZHRYrRY9g sub koha_object_class { 'Koha::Patron::Modification'; } sub koha_objects_class { 'Koha::Patron::Modifications'; } 1;