<<

NAME

Koha::Schema::Result::ProblemReport

TABLE: problem_reports

ACCESSORS

reportid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique identifier assigned by Koha

title

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

report subject line

content

  data_type: 'text'
  is_nullable: 0

report message content

borrowernumber

  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

the user who created the problem report

branchcode

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

borrower's branch

username

  data_type: 'varchar'
  is_nullable: 1
  size: 75

OPAC username

problempage

  data_type: 'text'
  is_nullable: 1

page the user triggered the problem report form from

recipient

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

the 'to-address' of the problem report

created_on

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

timestamp of report submission

status

  data_type: 'varchar'
  default_value: 'New'
  is_nullable: 0
  size: 6

status of the report. New, Viewed, Closed

PRIMARY KEY

RELATIONS

borrowernumber

Type: belongs_to

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

branchcode

Type: belongs_to

Related object: Koha::Schema::Result::Branch

<<