NAME

Koha::Schema::Result::Borrower

TABLE: `borrowers`

ACCESSORS

borrowernumber

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

cardnumber

  data_type: 'varchar'
  is_nullable: 1
  size: 16

surname

  data_type: 'mediumtext'
  is_nullable: 0

firstname

  data_type: 'text'
  is_nullable: 1

title

  data_type: 'mediumtext'
  is_nullable: 1

othernames

  data_type: 'mediumtext'
  is_nullable: 1

initials

  data_type: 'text'
  is_nullable: 1

streetnumber

  data_type: 'varchar'
  is_nullable: 1
  size: 10

streettype

  data_type: 'varchar'
  is_nullable: 1
  size: 50

address

  data_type: 'mediumtext'
  is_nullable: 0

address2

  data_type: 'text'
  is_nullable: 1

city

  data_type: 'mediumtext'
  is_nullable: 0

state

  data_type: 'text'
  is_nullable: 1

zipcode

  data_type: 'varchar'
  is_nullable: 1
  size: 25

country

  data_type: 'text'
  is_nullable: 1

email

  data_type: 'mediumtext'
  is_nullable: 1

phone

  data_type: 'text'
  is_nullable: 1

mobile

  data_type: 'varchar'
  is_nullable: 1
  size: 50

fax

  data_type: 'mediumtext'
  is_nullable: 1

emailpro

  data_type: 'text'
  is_nullable: 1

phonepro

  data_type: 'text'
  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: 'varchar'
  default_value: (empty string)
  is_foreign_key: 1
  is_nullable: 0
  size: 10

categorycode

  data_type: 'varchar'
  default_value: (empty string)
  is_foreign_key: 1
  is_nullable: 0
  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

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: 'mediumtext'
  is_nullable: 1

contactfirstname

  data_type: 'text'
  is_nullable: 1

contacttitle

  data_type: 'text'
  is_nullable: 1

guarantorid

  data_type: 'integer'
  is_nullable: 1

borrowernotes

  data_type: 'mediumtext'
  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: 60

flags

  data_type: 'integer'
  is_nullable: 1

userid

  data_type: 'varchar'
  is_nullable: 1
  size: 75

opacnote

  data_type: 'mediumtext'
  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: 'text'
  is_nullable: 1

altcontactzipcode

  data_type: 'varchar'
  is_nullable: 1
  size: 50

altcontactcountry

  data_type: 'text'
  is_nullable: 1

altcontactphone

  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

updated_on

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

PRIMARY KEY

"borrowernumber"

UNIQUE CONSTRAINTS

`cardnumber`

"cardnumber"

`userid`

"userid"

RELATIONS

accountlines

Type: has_many

Related object: Koha::Schema::Result::Accountline

accountoffsets

Type: has_many

Related object: Koha::Schema::Result::Accountoffset

aqbasketusers

Type: has_many

Related object: Koha::Schema::Result::Aqbasketuser

aqbudgetborrowers

Type: has_many

aqorder_users

Type: has_many

Related object: Koha::Schema::Result::AqorderUser

borrower_attributes

Type: has_many

borrower_debarments

Type: has_many

borrower_files

Type: has_many

Related object: Koha::Schema::Result::BorrowerFile

borrower_message_preferences

Type: has_many

borrower_syncs

Type: has_many

Related object: Koha::Schema::Result::BorrowerSync

branchcode

Type: belongs_to

Related object: Koha::Schema::Result::Branch

categorycode

Type: belongs_to

Related object: Koha::Schema::Result::Category

course_instructors

Type: has_many

creator_batches

Type: has_many

Related object: Koha::Schema::Result::CreatorBatch

discharges

Type: has_many

Related object: Koha::Schema::Result::Discharge

hold_fill_targets

Type: has_many

Related object: Koha::Schema::Result::HoldFillTarget

issues

Type: has_many

Related object: Koha::Schema::Result::Issue

items_last_borrowers

Type: has_many

message_queues

Type: has_many

Related object: Koha::Schema::Result::MessageQueue

old_issues

Type: has_many

Related object: Koha::Schema::Result::OldIssue

old_reserves

Type: has_many

Related object: Koha::Schema::Result::OldReserve

opac_news

Type: has_many

Related object: Koha::Schema::Result::OpacNews

patron_list_patrons

Type: has_many

patron_lists

Type: has_many

Related object: Koha::Schema::Result::PatronList

patronimage

Type: might_have

Related object: Koha::Schema::Result::Patronimage

ratings

Type: has_many

Related object: Koha::Schema::Result::Rating

reserves

Type: has_many

Related object: Koha::Schema::Result::Reserve

reviews

Type: has_many

Related object: Koha::Schema::Result::Review

sms_provider

Type: belongs_to

Related object: Koha::Schema::Result::SmsProvider

subscriptionroutinglists

Type: has_many

tags_all

Type: has_many

Related object: Koha::Schema::Result::TagAll

tags_approvals

Type: has_many

Related object: Koha::Schema::Result::TagsApproval

user_permissions

Type: has_many

Related object: Koha::Schema::Result::UserPermission

virtualshelfcontents

Type: has_many

virtualshelfshares

Type: has_many

virtualshelves

Type: has_many

Related object: Koha::Schema::Result::Virtualshelve

basketnoes

Type: many_to_many

Composing rels: "aqbasketusers" -> basketno

budgets

Type: many_to_many

Composing rels: "aqbudgetborrowers" -> budget

courses

Type: many_to_many

Composing rels: "course_instructors" -> course

ordernumbers

Type: many_to_many

Composing rels: "aqorder_users" -> ordernumber