View | Details | Raw Unified | Return to bug 19166
Collapse All | Expand All

(-)a/Koha/Schema/Result/AqinvoiceAdjustment.pm (-1 / +155 lines)
Line 0 Link Here
0
- 
1
use utf8;
2
package Koha::Schema::Result::AqinvoiceAdjustment;
3
4
# Created by DBIx::Class::Schema::Loader
5
# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
7
=head1 NAME
8
9
Koha::Schema::Result::AqinvoiceAdjustment
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<aqinvoice_adjustments>
19
20
=cut
21
22
__PACKAGE__->table("aqinvoice_adjustments");
23
24
=head1 ACCESSORS
25
26
=head2 adjustment_id
27
28
  data_type: 'integer'
29
  is_auto_increment: 1
30
  is_nullable: 0
31
32
=head2 invoiceid
33
34
  data_type: 'integer'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
38
=head2 adjustment
39
40
  data_type: 'decimal'
41
  is_nullable: 1
42
  size: [28,6]
43
44
=head2 reason
45
46
  data_type: 'varchar'
47
  is_nullable: 1
48
  size: 80
49
50
=head2 note
51
52
  data_type: 'mediumtext'
53
  is_nullable: 1
54
55
=head2 budget_id
56
57
  data_type: 'integer'
58
  is_foreign_key: 1
59
  is_nullable: 1
60
61
=head2 encumber_open
62
63
  data_type: 'smallint'
64
  default_value: 1
65
  is_nullable: 0
66
67
=head2 timestamp
68
69
  data_type: 'timestamp'
70
  datetime_undef_if_invalid: 1
71
  default_value: current_timestamp
72
  is_nullable: 0
73
74
=cut
75
76
__PACKAGE__->add_columns(
77
  "adjustment_id",
78
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
79
  "invoiceid",
80
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
81
  "adjustment",
82
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
83
  "reason",
84
  { data_type => "varchar", is_nullable => 1, size => 80 },
85
  "note",
86
  { data_type => "mediumtext", is_nullable => 1 },
87
  "budget_id",
88
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
89
  "encumber_open",
90
  { data_type => "smallint", default_value => 1, is_nullable => 0 },
91
  "timestamp",
92
  {
93
    data_type => "timestamp",
94
    datetime_undef_if_invalid => 1,
95
    default_value => \"current_timestamp",
96
    is_nullable => 0,
97
  },
98
);
99
100
=head1 PRIMARY KEY
101
102
=over 4
103
104
=item * L</adjustment_id>
105
106
=back
107
108
=cut
109
110
__PACKAGE__->set_primary_key("adjustment_id");
111
112
=head1 RELATIONS
113
114
=head2 budget
115
116
Type: belongs_to
117
118
Related object: L<Koha::Schema::Result::Aqbudget>
119
120
=cut
121
122
__PACKAGE__->belongs_to(
123
  "budget",
124
  "Koha::Schema::Result::Aqbudget",
125
  { budget_id => "budget_id" },
126
  {
127
    is_deferrable => 1,
128
    join_type     => "LEFT",
129
    on_delete     => "SET NULL",
130
    on_update     => "CASCADE",
131
  },
132
);
133
134
=head2 invoiceid
135
136
Type: belongs_to
137
138
Related object: L<Koha::Schema::Result::Aqinvoice>
139
140
=cut
141
142
__PACKAGE__->belongs_to(
143
  "invoiceid",
144
  "Koha::Schema::Result::Aqinvoice",
145
  { invoiceid => "invoiceid" },
146
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
147
);
148
149
150
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-19 13:03:59
151
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0wlYkziLx7xYplqR5a1EIg
152
153
154
# You can replace this text with custom code or comments, and it will be preserved on regeneration
155
1;

Return to bug 19166