<<

NAME

Koha::Schema::Result::BorrowerModification

TABLE: borrower_modifications

ACCESSORS

timestamp

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

verification_token

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

preferred_name

  data_type: 'longtext'
  is_nullable: 1

patron/borrower's preferred name

middle_name

  data_type: 'longtext'
  is_nullable: 1

patron/borrower's middle name

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

data processing consent

primary_contact_method

  data_type: 'varchar'
  is_nullable: 1
  size: 45

useful for reporting purposes

lang

  data_type: 'varchar'
  is_nullable: 1
  size: 25

PRIMARY KEY

<<