<<

NAME

Koha::Schema::Result::Letter

TABLE: letter

ACCESSORS

id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key identifier

module

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

Koha module that triggers this notice or slip

code

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

unique identifier for this notice or slip

branchcode

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

the branch this notice or slip is used at (branches.branchcode)

name

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

plain text name for this notice or slip

is_html

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 1

does this notice or slip use HTML (1 for yes, 0 for no)

title

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

subject line of the notice

content

  data_type: 'mediumtext'
  is_nullable: 1

body text for the notice or slip

message_transport_type

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

transport type for this notice

lang

  data_type: 'varchar'
  default_value: 'default'
  is_nullable: 0
  size: 25

lang of the notice

updated_on

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

last modification

PRIMARY KEY

UNIQUE CONSTRAINTS

letter_uniq_1

RELATIONS

message_queues

Type: has_many

Related object: Koha::Schema::Result::MessageQueue

message_transport_type

Type: belongs_to

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

<<