<<

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

  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

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

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

privacy

  data_type: 'integer'
  default_value: 1
  is_nullable: 0

PRIMARY KEY

• "borrowernumber"

UNIQUE CONSTRAINTS

cardnumber

• "cardnumber"

RELATIONS

accountlines

Type: has_many

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

accountoffsets

Type: has_many

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

aqbudgetborrowers

Type: has_many

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

borrower_attributes

Type: has_many

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

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

course_instructors

Type: has_many

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

creator_batches

Type: has_many

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

hold_fill_targets

Type: has_many

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

issues

Type: has_many

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

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

patron_list_patrons

Type: has_many

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

patron_lists

Type: has_many

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

patroncards

Type: has_many

Related object: Koha::Schema::Result::Patroncard

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

subscriptionroutinglists

Type: has_many

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

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

budgets

Type: many_to_many

Composing rels: "aqbudgetborrowers" -> budget

courses

Type: many_to_many

Composing rels: "course_instructors" -> course

<<