Bug 12461 - Add patron clubs feature
[koha.git] / Koha / Schema / Result / Virtualshelfcontent.pm
1 use utf8;
2 package Koha::Schema::Result::Virtualshelfcontent;
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::Virtualshelfcontent
10
11 =cut
12
13 use strict;
14 use warnings;
15
16 use base 'DBIx::Class::Core';
17
18 =head1 TABLE: C<virtualshelfcontents>
19
20 =cut
21
22 __PACKAGE__->table("virtualshelfcontents");
23
24 =head1 ACCESSORS
25
26 =head2 shelfnumber
27
28   data_type: 'integer'
29   default_value: 0
30   is_foreign_key: 1
31   is_nullable: 0
32
33 =head2 biblionumber
34
35   data_type: 'integer'
36   default_value: 0
37   is_foreign_key: 1
38   is_nullable: 0
39
40 =head2 flags
41
42   data_type: 'integer'
43   is_nullable: 1
44
45 =head2 dateadded
46
47   data_type: 'timestamp'
48   datetime_undef_if_invalid: 1
49   default_value: current_timestamp
50   is_nullable: 0
51
52 =head2 borrowernumber
53
54   data_type: 'integer'
55   is_foreign_key: 1
56   is_nullable: 1
57
58 =cut
59
60 __PACKAGE__->add_columns(
61   "shelfnumber",
62   {
63     data_type      => "integer",
64     default_value  => 0,
65     is_foreign_key => 1,
66     is_nullable    => 0,
67   },
68   "biblionumber",
69   {
70     data_type      => "integer",
71     default_value  => 0,
72     is_foreign_key => 1,
73     is_nullable    => 0,
74   },
75   "flags",
76   { data_type => "integer", is_nullable => 1 },
77   "dateadded",
78   {
79     data_type => "timestamp",
80     datetime_undef_if_invalid => 1,
81     default_value => \"current_timestamp",
82     is_nullable => 0,
83   },
84   "borrowernumber",
85   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
86 );
87
88 =head1 RELATIONS
89
90 =head2 biblionumber
91
92 Type: belongs_to
93
94 Related object: L<Koha::Schema::Result::Biblio>
95
96 =cut
97
98 __PACKAGE__->belongs_to(
99   "biblionumber",
100   "Koha::Schema::Result::Biblio",
101   { biblionumber => "biblionumber" },
102   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
103 );
104
105 =head2 borrowernumber
106
107 Type: belongs_to
108
109 Related object: L<Koha::Schema::Result::Borrower>
110
111 =cut
112
113 __PACKAGE__->belongs_to(
114   "borrowernumber",
115   "Koha::Schema::Result::Borrower",
116   { borrowernumber => "borrowernumber" },
117   {
118     is_deferrable => 1,
119     join_type     => "LEFT",
120     on_delete     => "SET NULL",
121     on_update     => "SET NULL",
122   },
123 );
124
125 =head2 shelfnumber
126
127 Type: belongs_to
128
129 Related object: L<Koha::Schema::Result::Virtualshelve>
130
131 =cut
132
133 __PACKAGE__->belongs_to(
134   "shelfnumber",
135   "Koha::Schema::Result::Virtualshelve",
136   { shelfnumber => "shelfnumber" },
137   { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
138 );
139
140
141 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
142 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ie3Gx+/HthZQ/4fHjcPF0w
143
144 #TODO See BZ 14544: Should be resolved by db revision
145 __PACKAGE__->set_primary_key("shelfnumber","biblionumber");
146
147 # You can replace this text with custom content, and it will be preserved on regeneration
148 1;