<<

NAME

Koha::Schema::Result::MessageQueue

TABLE: message_queue

ACCESSORS

message_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

letter_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

Foreign key to the letters table

borrowernumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

subject

  data_type: 'mediumtext'
  is_nullable: 1

content

  data_type: 'mediumtext'
  is_nullable: 1

metadata

  data_type: 'mediumtext'
  is_nullable: 1

letter_code

  data_type: 'varchar'
  is_nullable: 1
  size: 64

message_transport_type

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 0
  size: 20

status

  data_type: 'enum'
  default_value: 'pending'
  extra: {list => ["sent","pending","failed","deleted"]}
  is_nullable: 0

time_queued

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  is_nullable: 1

updated_on

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

to_address

  data_type: 'longtext'
  is_nullable: 1

cc_address

  data_type: 'longtext'
  is_nullable: 1

from_address

  data_type: 'longtext'
  is_nullable: 1

reply_address

  data_type: 'longtext'
  is_nullable: 1

content_type

  data_type: 'mediumtext'
  is_nullable: 1

failure_code

  data_type: 'mediumtext'
  is_nullable: 1

PRIMARY KEY

• "message_id"

RELATIONS

borrowernumber

Type: belongs_to

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

letter

Type: belongs_to

Related object: Koha::Schema::Result::Letter

message_transport_type

Type: belongs_to

Related object: Koha::Schema::Result::MessageTransportType

<<