NAME

Koha::Schema::Result::Category

TABLE: `categories`

ACCESSORS

categorycode

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 10

unique primary key used to idenfity the patron category

description

  data_type: 'longtext'
  is_nullable: 1

description of the patron category

enrolmentperiod

  data_type: 'smallint'
  is_nullable: 1

number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set)

enrolmentperioddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date the patron is enrolled until (will be NULL if enrolmentperiod is set)

password_expiry_days

  data_type: 'smallint'
  is_nullable: 1

number of days after which the patron must reset their password

upperagelimit

  data_type: 'smallint'
  is_nullable: 1

age limit for the patron

dateofbirthrequired

  data_type: 'tinyint'
  is_nullable: 1

the minimum age required for the patron category

finetype

  data_type: 'varchar'
  is_nullable: 1
  size: 30

unused in Koha

bulk

  data_type: 'tinyint'
  is_nullable: 1

enrolmentfee

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

enrollment fee for the patron

overduenoticerequired

  data_type: 'tinyint'
  is_nullable: 1

are overdue notices sent to this patron category (1 for yes, 0 for no)

issuelimit

  data_type: 'smallint'
  is_nullable: 1

unused in Koha

reservefee

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

cost to place holds

hidelostitems

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

are lost items shown to this category (1 for yes, 0 for no)

category_type

  data_type: 'varchar'
  default_value: 'A'
  is_nullable: 0
  size: 1

type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)

BlockExpiredPatronOpacActions

  accessor: 'block_expired_patron_opac_actions'
  data_type: 'tinyint'
  default_value: -1
  is_nullable: 0

wheither or not a patron of this category can renew books or place holds once their card has expired. 0 means they can, 1 means they cannot, -1 means use syspref BlockExpiredPatronOpacActions

default_privacy

  data_type: 'enum'
  default_value: 'default'
  extra: {list => ["default","never","forever"]}
  is_nullable: 0

Default privacy setting for this patron category

checkprevcheckout

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

produce a warning for this patron category if this item has previously been checked out to this patron if 'yes', not if 'no', defer to syspref setting if 'inherit'.

can_place_ill_in_opac

  data_type: 'tinyint'
  default_value: 1
  is_nullable: 0

can this patron category place interlibrary loan requests

can_be_guarantee

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

if patrons of this category can be guarantees

reset_password

  data_type: 'tinyint'
  is_nullable: 1

if patrons of this category can do the password reset flow,

change_password

  data_type: 'tinyint'
  is_nullable: 1

if patrons of this category can change their passwords in the OAPC

min_password_length

  data_type: 'smallint'
  is_nullable: 1

set minimum password length for patrons in this category

require_strong_password

  data_type: 'tinyint'
  is_nullable: 1

set required password strength for patrons in this category

exclude_from_local_holds_priority

  data_type: 'tinyint'
  is_nullable: 1

Exclude patrons of this category from local holds priority

PRIMARY KEY

"categorycode"

RELATIONS

borrower_attribute_types

Type: has_many

borrower_message_preferences

Type: has_many

borrowers

Type: has_many

Related object: Koha::Schema::Result::Borrower

categories_branches

Type: has_many

circulation_rules

Type: has_many

Related object: Koha::Schema::Result::CirculationRule

identity_provider_domains

Type: has_many