<<

NAME

Koha::Schema::Result::Suggestion

TABLE: suggestions

ACCESSORS

suggestionid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

suggestedby

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

suggesteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 0

managedby

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

manageddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

acceptedby

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

accepteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

rejectedby

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

rejecteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

lastmodificationby

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

lastmodificationdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

STATUS

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

archived

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

note

  data_type: 'longtext'
  is_nullable: 1

author

  data_type: 'varchar'
  is_nullable: 1
  size: 80

title

  data_type: 'varchar'
  is_nullable: 1
  size: 255

copyrightdate

  data_type: 'smallint'
  is_nullable: 1

publishercode

  data_type: 'varchar'
  is_nullable: 1
  size: 255

date

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

volumedesc

  data_type: 'varchar'
  is_nullable: 1
  size: 255

publicationyear

  data_type: 'smallint'
  default_value: 0
  is_nullable: 1

place

  data_type: 'varchar'
  is_nullable: 1
  size: 255

isbn

  data_type: 'varchar'
  is_nullable: 1
  size: 30

biblionumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

reason

  data_type: 'mediumtext'
  is_nullable: 1

patronreason

  data_type: 'mediumtext'
  is_nullable: 1

budgetid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

branchcode

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 10

collectiontitle

  data_type: 'mediumtext'
  is_nullable: 1

itemtype

  data_type: 'varchar'
  is_nullable: 1
  size: 30

quantity

  data_type: 'smallint'
  is_nullable: 1

currency

  data_type: 'varchar'
  is_nullable: 1
  size: 10

price

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

total

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

PRIMARY KEY

• "suggestionid"

RELATIONS

acceptedby

Type: belongs_to

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

biblionumber

Type: belongs_to

Related object: Koha::Schema::Result::Biblio

branchcode

Type: belongs_to

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

budgetid

Type: belongs_to

Related object: Koha::Schema::Result::Aqbudget

lastmodificationby

Type: belongs_to

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

managedby

Type: belongs_to

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

rejectedby

Type: belongs_to

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

suggestedby

Type: belongs_to

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

<<