2 package Koha::Schema::Result::Statistic;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Statistic
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<statistics>
22 __PACKAGE__->table("statistics");
29 datetime_undef_if_invalid: 1
32 date and time of the transaction
40 foreign key, branch where the transaction occurred
44 data_type: 'double precision'
48 monetary value associated with the transaction
56 transaction type (localuse, issue, return, renew, writeoff, payment)
70 foreign key from the items table, links transaction to a specific item
78 foreign key from the itemtypes table, links transaction to a specific item type
86 authorized value for the shelving location for this item (MARC21 952$c)
93 foreign key from the borrowers table, links transaction to a specific borrower
101 foreign key from the items table, links transaction to a specific collection code
109 foreign key from the borrowers table, links transaction to a specific borrower category
113 __PACKAGE__->add_columns(
116 data_type => "datetime",
117 datetime_undef_if_invalid => 1,
121 { data_type => "varchar", is_nullable => 1, size => 10 },
123 { data_type => "double precision", is_nullable => 1, size => [16, 4] },
125 { data_type => "varchar", is_nullable => 1, size => 16 },
127 { data_type => "longtext", is_nullable => 1 },
129 { data_type => "integer", is_nullable => 1 },
131 { data_type => "varchar", is_nullable => 1, size => 10 },
133 { data_type => "varchar", is_nullable => 1, size => 80 },
135 { data_type => "integer", is_nullable => 1 },
137 { data_type => "varchar", is_nullable => 1, size => 80 },
139 { data_type => "varchar", is_nullable => 1, size => 10 },
143 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-09-22 12:36:29
144 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q1L7HqO/OkyzmiUcO3c0gg
147 # You can replace this text with custom content, and it will be preserved on regeneration