2 package Debbugs::DB::Result::Message;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Debbugs::DB::Result::Message - Messages sent to bugs
16 use base 'DBIx::Class::Core';
18 =head1 COMPONENTS LOADED
22 =item * L<DBIx::Class::InflateColumn::DateTime>
24 =item * L<DBIx::Class::TimeStamp>
30 __PACKAGE__->load_components("InflateColumn::DateTime", "TimeStamp");
32 =head1 TABLE: C<message>
36 __PACKAGE__->table("message");
45 sequence: 'message_id_seq'
52 default_value: (empty string)
60 default_value: (empty string)
63 Complete from header of message
68 default_value: (empty string)
71 Address(es) of From: headers
76 default_value: (empty string)
79 Complete to header of message
84 default_value: (empty string)
87 Address(es) of To: header
92 default_value: (empty string)
95 Subject of the message
99 data_type: 'timestamp with time zone'
102 Time/date message was sent (from Date header)
107 default_value: (empty string)
110 Contents of References: header
114 data_type: 'double precision'
118 Spam score from spamassassin
126 True if this message was spam and should not be shown
130 __PACKAGE__->add_columns(
133 data_type => "integer",
134 is_auto_increment => 1,
136 sequence => "message_id_seq",
139 { data_type => "text", default_value => "", is_nullable => 0 },
141 { data_type => "text", default_value => "", is_nullable => 0 },
143 { data_type => "text", default_value => "", is_nullable => 0 },
145 { data_type => "text", default_value => "", is_nullable => 0 },
147 { data_type => "text", default_value => "", is_nullable => 0 },
149 { data_type => "text", default_value => "", is_nullable => 0 },
151 { data_type => "timestamp with time zone", is_nullable => 1 },
153 { data_type => "text", default_value => "", is_nullable => 0 },
155 { data_type => "double precision", default_value => 0, is_nullable => 0 },
157 { data_type => "boolean", default_value => \"false", is_nullable => 0 },
170 __PACKAGE__->set_primary_key("id");
172 =head1 UNIQUE CONSTRAINTS
174 =head2 C<message_msgid_from_complete_to_complete_subject_idx>
180 =item * L</from_complete>
182 =item * L</to_complete>
190 __PACKAGE__->add_unique_constraint(
191 "message_msgid_from_complete_to_complete_subject_idx",
192 ["msgid", "from_complete", "to_complete", "subject"],
201 Related object: L<Debbugs::DB::Result::BugMessage>
205 __PACKAGE__->has_many(
207 "Debbugs::DB::Result::BugMessage",
208 { "foreign.message" => "self.id" },
209 { cascade_copy => 0, cascade_delete => 0 },
212 =head2 message_correspondents
216 Related object: L<Debbugs::DB::Result::MessageCorrespondent>
220 __PACKAGE__->has_many(
221 "message_correspondents",
222 "Debbugs::DB::Result::MessageCorrespondent",
223 { "foreign.message" => "self.id" },
224 { cascade_copy => 0, cascade_delete => 0 },
227 =head2 message_refs_messages
231 Related object: L<Debbugs::DB::Result::MessageRef>
235 __PACKAGE__->has_many(
236 "message_refs_messages",
237 "Debbugs::DB::Result::MessageRef",
238 { "foreign.message" => "self.id" },
239 { cascade_copy => 0, cascade_delete => 0 },
242 =head2 message_refs_refs
246 Related object: L<Debbugs::DB::Result::MessageRef>
250 __PACKAGE__->has_many(
252 "Debbugs::DB::Result::MessageRef",
253 { "foreign.refs" => "self.id" },
254 { cascade_copy => 0, cascade_delete => 0 },
258 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-11-30 21:56:51
259 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Dow6t1MS7ldAy6KBMtBWRQ
262 # You can replace this text with custom code or comments, and it will be preserved on regeneration