Table testsql_comments.letter
table for all notice templates in Koha

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
module varchar 20 Koha module that triggers this notice or slip
code varchar 20 unique identifier for this notice or slip
branchcode varchar 10
the branch this notice or slip is used at (branches.branchcode)
name varchar 100 plain text name for this notice or slip
is_html bit 0  √  0 does this notice or slip use HTML (1 for yes, 0 for no)
title varchar 200 subject line of the notice
content text 65535  √  null body text for the notice or slip
message_transport_type varchar 20 email
message_transport_types
transport type for this notice
lang varchar 25 default lang of the notice

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

Indexes:
Column(s) Type Sort
module + code + branchcode + message_transport_type + lang Primary key Asc/Asc/Asc/Asc/Asc
message_transport_type Performance Asc

Close relationships  within of separation: