<<

NAME

Koha::Schema::Result::Message

TABLE: messages

ACCESSORS

message_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique identifier assigned by Koha

borrowernumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

foreign key linking this message to the borrowers table

branchcode

  data_type: 'varchar'
  is_nullable: 1
  size: 10

foreign key linking the message to the branches table

message_type

  data_type: 'varchar'
  is_nullable: 0
  size: 1

whether the message is for the librarians (L) or the patron (B)

message

  data_type: 'mediumtext'
  is_nullable: 0

the text of the message

message_date

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

the date and time the message was written

manager_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

creator of message

patron_read_date

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date and time the patron dismissed the message

PRIMARY KEY

RELATIONS

borrowernumber

Type: belongs_to

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

manager

Type: belongs_to

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

<<