Table testsql_comments.letter
table for all notice templates in Koha

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
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
refund_lost_item_fee_rules.branchcode Implied Constraint R
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.message_transport_type message_transport_type_fk C
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 Constraint Name
module + code + branchcode + message_transport_type + lang Primary key Asc/Asc/Asc/Asc/Asc PRIMARY
message_transport_type Performance Asc message_transport_type_fk

Close relationships  within of separation: