<<

NAME

Koha::Schema::Result::SavedSql

TABLE: saved_sql

ACCESSORS

id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique id and primary key assigned by Koha

borrowernumber

  data_type: 'integer'
  is_nullable: 1

the staff member who created this report (borrowers.borrowernumber)

date_created

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date this report was created

last_modified

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date this report was last edited

savedsql

  data_type: 'mediumtext'
  is_nullable: 1

the SQL for this report

last_run

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

report_name

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

the name of this report

type

  data_type: 'varchar'
  is_nullable: 1
  size: 255

always 1 for tabular

notes

  data_type: 'mediumtext'
  is_nullable: 1

the notes or description given to this report

cache_expiry

  data_type: 'integer'
  default_value: 300
  is_nullable: 0

public

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

report_area

  data_type: 'varchar'
  is_nullable: 1
  size: 6

report_group

  data_type: 'varchar'
  is_nullable: 1
  size: 80

report_subgroup

  data_type: 'varchar'
  is_nullable: 1
  size: 80

mana_id

  data_type: 'integer'
  is_nullable: 1

PRIMARY KEY

<<