NAME

Koha::Schema::Result::SipAccount

TABLE: `sip_accounts`

ACCESSORS

sip_account_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

sip_institution_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

Foreign key to sip_institutions.sip_institution_id

ae_field_template

  data_type: 'varchar'
  is_nullable: 1
  size: 255

allow_additional_materials_checkout

  data_type: 'tinyint'
  is_nullable: 1

allow_empty_passwords

  data_type: 'tinyint'
  is_nullable: 1

allow_fields

  data_type: 'varchar'
  is_nullable: 1
  size: 255

av_field_template

  data_type: 'varchar'
  is_nullable: 1
  size: 255

blocked_item_types

  data_type: 'varchar'
  is_nullable: 1
  size: 255

checked_in_ok

  data_type: 'tinyint'
  is_nullable: 1

convert_nonprinting_characters

  data_type: 'varchar'
  is_nullable: 1
  size: 10

cr_item_field

  data_type: 'varchar'
  is_nullable: 1
  size: 255

ct_always_send

  data_type: 'tinyint'
  is_nullable: 1

cv_send_00_on_success

  data_type: 'tinyint'
  is_nullable: 1

cv_triggers_alert

  data_type: 'tinyint'
  is_nullable: 1

da_field_template

  data_type: 'varchar'
  is_nullable: 1
  size: 255

delimiter

  data_type: 'varchar'
  default_value: '|'
  is_nullable: 1
  size: 10

disallow_overpayment

  data_type: 'tinyint'
  is_nullable: 1

encoding

  data_type: 'varchar'
  is_nullable: 1
  size: 10

error_detect

  data_type: 'tinyint'
  is_nullable: 1

format_due_date

  data_type: 'tinyint'
  is_nullable: 1

hide_fields

  data_type: 'varchar'
  is_nullable: 1
  size: 255

holds_block_checkin

  data_type: 'tinyint'
  is_nullable: 1

holds_get_captured

  data_type: 'tinyint'
  is_nullable: 1

inhouse_item_types

  data_type: 'varchar'
  is_nullable: 1
  size: 255

inhouse_patron_categories

  data_type: 'varchar'
  is_nullable: 1
  size: 255

login_id

  data_type: 'varchar'
  is_nullable: 0
  size: 255

Staff userid for SIP2 authentication

lost_block_checkout

  data_type: 'tinyint'
  is_nullable: 1

actual tinyint, not boolean

lost_block_checkout_value

  data_type: 'tinyint'
  is_nullable: 1

actual tinyint, not boolean

lost_status_for_missing

  data_type: 'tinyint'
  is_nullable: 1

actual tinyint, not boolean

overdues_block_checkout

  data_type: 'tinyint'
  is_nullable: 1

payment_type_writeoff

  data_type: 'varchar'
  is_nullable: 1
  size: 10

prevcheckout_block_checkout

  data_type: 'tinyint'
  is_nullable: 1

register_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

Foreign key to cash_registers.id

seen_on_item_information

  data_type: 'varchar'
  is_nullable: 1
  size: 255

send_patron_home_library_in_af

  data_type: 'tinyint'
  is_nullable: 1

show_checkin_message

  data_type: 'tinyint'
  is_nullable: 1

show_outstanding_amount

  data_type: 'tinyint'
  is_nullable: 1

terminator

  data_type: 'enum'
  default_value: 'CRLF'
  extra: {list => ["CR","CRLF"]}
  is_nullable: 0

PRIMARY KEY

"sip_account_id"

UNIQUE CONSTRAINTS

`account_login_id`

"login_id"

RELATIONS

register

Type: belongs_to

Related object: Koha::Schema::Result::CashRegister

sip_account_custom_item_fields

Type: has_many

sip_account_custom_patron_fields

Type: has_many

sip_account_item_fields

Type: has_many

sip_account_patron_attributes

Type: has_many

sip_account_screen_msg_regexs

Type: has_many

sip_account_sort_bin_mappings

Type: has_many

sip_account_system_preference_overrides

Type: has_many

sip_institution

Type: belongs_to

Related object: Koha::Schema::Result::SipInstitution

koha_objects_class

  Koha Objects class

koha_object_class

  Koha Object class