<<

NAME

Koha::Schema::Result::Overduerule

TABLE: overduerules

ACCESSORS

overduerules_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique identifier for the overduerules

branchcode

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

foreign key from the branches table to define which branch this rule is for (if blank it's all libraries)

categorycode

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

foreign key from the categories table to define which patron category this rule is for

delay1

  data_type: 'integer'
  is_nullable: 1

number of days after the item is overdue that the first notice is sent

letter1

  data_type: 'varchar'
  is_nullable: 1
  size: 20

foreign key from the letter table to define which notice should be sent as the first notice

debarred1

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

is the patron restricted when the first notice is sent (1 for yes, 0 for no)

delay2

  data_type: 'integer'
  is_nullable: 1

number of days after the item is overdue that the second notice is sent

debarred2

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

is the patron restricted when the second notice is sent (1 for yes, 0 for no)

letter2

  data_type: 'varchar'
  is_nullable: 1
  size: 20

foreign key from the letter table to define which notice should be sent as the second notice

delay3

  data_type: 'integer'
  is_nullable: 1

number of days after the item is overdue that the third notice is sent

letter3

  data_type: 'varchar'
  is_nullable: 1
  size: 20

foreign key from the letter table to define which notice should be sent as the third notice

debarred3

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

is the patron restricted when the third notice is sent (1 for yes, 0 for no)

PRIMARY KEY

UNIQUE CONSTRAINTS

overduerules_branch_cat

RELATIONS

overduerules_transport_types

Type: has_many

Related object: Koha::Schema::Result::OverduerulesTransportType

<<