2 package Koha::Schema::Result::Letter;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Letter
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<letter>
22 __PACKAGE__->table("letter");
32 primary key identifier
37 default_value: (empty string)
41 Koha module that triggers this notice or slip
46 default_value: (empty string)
50 unique identifier for this notice or slip
55 default_value: (empty string)
59 the branch this notice or slip is used at (branches.branchcode)
64 default_value: (empty string)
68 plain text name for this notice or slip
76 does this notice or slip use HTML (1 for yes, 0 for no)
81 default_value: (empty string)
85 subject line of the notice
89 data_type: 'mediumtext'
92 body text for the notice or slip
94 =head2 message_transport_type
97 default_value: 'email'
102 transport type for this notice
107 default_value: 'default'
115 data_type: 'timestamp'
116 datetime_undef_if_invalid: 1
117 default_value: current_timestamp
124 __PACKAGE__->add_columns(
126 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
128 { data_type => "varchar", default_value => "", is_nullable => 0, size => 20 },
130 { data_type => "varchar", default_value => "", is_nullable => 0, size => 20 },
132 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
134 { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
136 { data_type => "tinyint", default_value => 0, is_nullable => 1 },
138 { data_type => "varchar", default_value => "", is_nullable => 0, size => 200 },
140 { data_type => "mediumtext", is_nullable => 1 },
141 "message_transport_type",
143 data_type => "varchar",
144 default_value => "email",
151 data_type => "varchar",
152 default_value => "default",
158 data_type => "timestamp",
159 datetime_undef_if_invalid => 1,
160 default_value => \"current_timestamp",
175 __PACKAGE__->set_primary_key("id");
177 =head1 UNIQUE CONSTRAINTS
179 =head2 C<letter_uniq_1>
187 =item * L</branchcode>
189 =item * L</message_transport_type>
197 __PACKAGE__->add_unique_constraint(
199 ["module", "code", "branchcode", "message_transport_type", "lang"],
204 =head2 message_queues
208 Related object: L<Koha::Schema::Result::MessageQueue>
212 __PACKAGE__->has_many(
214 "Koha::Schema::Result::MessageQueue",
215 { "foreign.letter_id" => "self.id" },
216 { cascade_copy => 0, cascade_delete => 0 },
219 =head2 message_transport_type
223 Related object: L<Koha::Schema::Result::MessageTransportType>
227 __PACKAGE__->belongs_to(
228 "message_transport_type",
229 "Koha::Schema::Result::MessageTransportType",
230 { message_transport_type => "message_transport_type" },
231 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
235 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-18 12:50:14
236 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MA3WvXK/1ZBc407iU7ZcrA
238 sub koha_object_class {
239 'Koha::Notice::Template';
241 sub koha_objects_class {
242 'Koha::Notice::Templates';