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
message_transports.letter_module message_transports_ibfk_3 C
Koha module that triggers this notice or slip
code varchar 20
message_transports.letter_code message_transports_ibfk_3 C
unique identifier for this notice or slip
branchcode varchar 10
message_transports.branchcode message_transports_ibfk_3 C
branches.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

Table contained 0 rows at Tue Dec 27 15:49 NZDT 2016

Indexes:
Column(s) Type Sort Constraint Name
module + code + branchcode + message_transport_type Primary key Asc/Asc/Asc/Asc PRIMARY
message_transport_type Performance Asc message_transport_type_fk

Close relationships  within of separation: