+use utf8;
package Koha::Schema::Result::Accountline;
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
+=head1 NAME
+
+Koha::Schema::Result::Accountline
+
+=cut
+
use strict;
use warnings;
use base 'DBIx::Class::Core';
-
-=head1 NAME
-
-Koha::Schema::Result::Accountline
+=head1 TABLE: C<accountlines>
=cut
is_auto_increment: 1
is_nullable: 0
+=head2 issue_id
+
+ data_type: 'integer'
+ is_nullable: 1
+
=head2 borrowernumber
data_type: 'integer'
=head2 date
data_type: 'date'
+ datetime_undef_if_invalid: 1
is_nullable: 1
=head2 amount
=head2 description
- data_type: 'mediumtext'
+ data_type: 'longtext'
is_nullable: 1
-=head2 dispute
+=head2 accounttype
- data_type: 'mediumtext'
+ data_type: 'varchar'
is_nullable: 1
+ size: 5
-=head2 accounttype
+=head2 payment_type
data_type: 'varchar'
is_nullable: 1
- size: 5
+ size: 80
=head2 amountoutstanding
=head2 timestamp
data_type: 'timestamp'
+ datetime_undef_if_invalid: 1
default_value: current_timestamp
is_nullable: 0
-=head2 notify_id
-
- data_type: 'integer'
- default_value: 0
- is_nullable: 0
-
-=head2 notify_level
-
- data_type: 'integer'
- default_value: 0
- is_nullable: 0
-
=head2 note
- data_type: 'text'
+ data_type: 'mediumtext'
is_nullable: 1
=head2 manager_id
__PACKAGE__->add_columns(
"accountlines_id",
{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
+ "issue_id",
+ { data_type => "integer", is_nullable => 1 },
"borrowernumber",
{
data_type => "integer",
"itemnumber",
{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
"date",
- { data_type => "date", is_nullable => 1 },
+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
"amount",
{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
"description",
- { data_type => "mediumtext", is_nullable => 1 },
- "dispute",
- { data_type => "mediumtext", is_nullable => 1 },
+ { data_type => "longtext", is_nullable => 1 },
"accounttype",
{ data_type => "varchar", is_nullable => 1, size => 5 },
+ "payment_type",
+ { data_type => "varchar", is_nullable => 1, size => 80 },
"amountoutstanding",
{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
"lastincrement",
{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
"timestamp",
{
- data_type => "timestamp",
+ data_type => "timestamp",
+ datetime_undef_if_invalid => 1,
default_value => \"current_timestamp",
- is_nullable => 0,
+ is_nullable => 0,
},
- "notify_id",
- { data_type => "integer", default_value => 0, is_nullable => 0 },
- "notify_level",
- { data_type => "integer", default_value => 0, is_nullable => 0 },
"note",
- { data_type => "text", is_nullable => 1 },
+ { data_type => "mediumtext", is_nullable => 1 },
"manager_id",
{ data_type => "integer", is_nullable => 1 },
);
+
+=head1 PRIMARY KEY
+
+=over 4
+
+=item * L</accountlines_id>
+
+=back
+
+=cut
+
__PACKAGE__->set_primary_key("accountlines_id");
=head1 RELATIONS
+=head2 account_offsets_credits
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::AccountOffset>
+
+=cut
+
+__PACKAGE__->has_many(
+ "account_offsets_credits",
+ "Koha::Schema::Result::AccountOffset",
+ { "foreign.credit_id" => "self.accountlines_id" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
+=head2 account_offsets_debits
+
+Type: has_many
+
+Related object: L<Koha::Schema::Result::AccountOffset>
+
+=cut
+
+__PACKAGE__->has_many(
+ "account_offsets_debits",
+ "Koha::Schema::Result::AccountOffset",
+ { "foreign.debit_id" => "self.accountlines_id" },
+ { cascade_copy => 0, cascade_delete => 0 },
+);
+
=head2 borrowernumber
Type: belongs_to
"borrowernumber",
"Koha::Schema::Result::Borrower",
{ borrowernumber => "borrowernumber" },
- { on_delete => "CASCADE", on_update => "CASCADE" },
+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);
=head2 itemnumber
"itemnumber",
"Koha::Schema::Result::Item",
{ itemnumber => "itemnumber" },
- { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
+ {
+ is_deferrable => 1,
+ join_type => "LEFT",
+ on_delete => "SET NULL",
+ on_update => "SET NULL",
+ },
);
-# Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+AbxKjLUR7hQsP2dpsyAPw
+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-16 17:00:24
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pygYYKxFDRLX97PyeUeLvg
+sub koha_objects_class {
+ 'Koha::Account::Lines';
+}
+sub koha_object_class {
+ 'Koha::Account::Line';
+}
-# You can replace this text with custom content, and it will be preserved on regeneration
1;