<<

NAME

Koha::Schema::Result::Suggestion

TABLE: suggestions

ACCESSORS

suggestionid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

suggestedby

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

suggesteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 0

managedby

  data_type: 'integer'
  is_nullable: 1

manageddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

acceptedby

  data_type: 'integer'
  is_nullable: 1

accepteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

rejectedby

  data_type: 'integer'
  is_nullable: 1

rejecteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

status

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

note

  data_type: 'mediumtext'
  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

mailoverseeing

  data_type: 'smallint'
  default_value: 0
  is_nullable: 1

biblionumber

  data_type: 'integer'
  is_nullable: 1

reason

  data_type: 'text'
  is_nullable: 1

patronreason

  data_type: 'text'
  is_nullable: 1

budgetid

  data_type: 'integer'
  is_nullable: 1

branchcode

  data_type: 'varchar'
  is_nullable: 1
  size: 10

collectiontitle

  data_type: 'text'
  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: 3

price

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

total

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

PRIMARY KEY

• "suggestionid"

<<