<<

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: 32

surname

  data_type: 'longtext'
  is_nullable: 1

firstname

  data_type: 'mediumtext'
  is_nullable: 1

title

  data_type: 'longtext'
  is_nullable: 1

othernames

  data_type: 'longtext'
  is_nullable: 1

initials

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

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

guarantorid

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

flags

  data_type: 'integer'
  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

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

checkprevcheckout

  data_type: 'varchar'
  default_value: 'inherit'
  is_nullable: 0
  size: 7

updated_on

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

lastseen

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

lang

  data_type: 'varchar'
  default_value: 'default'
  is_nullable: 0
  size: 25

login_attempts

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

overdrive_auth_token

  data_type: 'mediumtext'
  is_nullable: 1

anonymized

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

PRIMARY KEY

UNIQUE CONSTRAINTS

cardnumber

userid

RELATIONS

accountlines

Type: has_many

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

accountlines_managers

Type: has_many

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

api_keys

Type: has_many

Related object: Koha::Schema::Result::ApiKey

aqbasketusers

Type: has_many

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

aqbudgetborrowers

Type: has_many

Related object: Koha::Schema::Result::Aqbudgetborrower

aqorder_users

Type: has_many

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

aqorders

Type: has_many

Related object: Koha::Schema::Result::Aqorder

article_requests

Type: has_many

Related object: Koha::Schema::Result::ArticleRequest

borrower_attributes

Type: has_many

Related object: Koha::Schema::Result::BorrowerAttribute

borrower_debarments

Type: has_many

Related object: Koha::Schema::Result::BorrowerDebarment

borrower_files

Type: has_many

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

borrower_message_preferences

Type: has_many

Related object: Koha::Schema::Result::BorrowerMessagePreference

branchcode

Type: belongs_to

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

categorycode

Type: belongs_to

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

club_enrollments

Type: has_many

Related object: Koha::Schema::Result::ClubEnrollment

course_instructors

Type: has_many

Related object: Koha::Schema::Result::CourseInstructor

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

housebound_profile

Type: might_have

Related object: Koha::Schema::Result::HouseboundProfile

housebound_role

Type: might_have

Related object: Koha::Schema::Result::HouseboundRole

housebound_visit_chooser_brwnumbers

Type: has_many

Related object: Koha::Schema::Result::HouseboundVisit

housebound_visit_deliverer_brwnumbers

Type: has_many

Related object: Koha::Schema::Result::HouseboundVisit

illcomments

Type: has_many

Related object: Koha::Schema::Result::Illcomment

illrequests

Type: has_many

Related object: Koha::Schema::Result::Illrequest

issues

Type: has_many

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

items_last_borrowers

Type: has_many

Related object: Koha::Schema::Result::ItemsLastBorrower

message_queues

Type: has_many

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

messages

Type: has_many

Related object: Koha::Schema::Result::Message

messages_borrowernumbers

Type: has_many

Related object: Koha::Schema::Result::Message

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_consents

Type: has_many

Related object: Koha::Schema::Result::PatronConsent

patron_list_patrons

Type: has_many

Related object: Koha::Schema::Result::PatronListPatron

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

Related object: Koha::Schema::Result::Subscriptionroutinglist

suggestions_acceptedbies

Type: has_many

Related object: Koha::Schema::Result::Suggestion

suggestions_managedbies

Type: has_many

Related object: Koha::Schema::Result::Suggestion

suggestions_rejectedbies

Type: has_many

Related object: Koha::Schema::Result::Suggestion

suggestions_suggestedbies

Type: has_many

Related object: Koha::Schema::Result::Suggestion

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

Related object: Koha::Schema::Result::Virtualshelfcontent

virtualshelfshares

Type: has_many

Related object: Koha::Schema::Result::Virtualshelfshare

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

<<