2 package Koha::Schema::Result::BorrowerDebarment;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::BorrowerDebarment
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<borrower_debarments>
22 __PACKAGE__->table("borrower_debarments");
26 =head2 borrower_debarment_id
32 unique key for the restriction
40 foreign key for borrowers.borrowernumber for patron who is restricted
45 datetime_undef_if_invalid: 1
48 expiration date of the restriction
57 type of restriction, FK to restriction_types.code
61 data_type: 'mediumtext'
64 comments about the restriction
71 foreign key for borrowers.borrowernumber for the librarian managing the restriction
75 data_type: 'timestamp'
76 datetime_undef_if_invalid: 1
77 default_value: current_timestamp
80 date the restriction was added
84 data_type: 'timestamp'
85 datetime_undef_if_invalid: 1
88 date the restriction was updated
92 __PACKAGE__->add_columns(
93 "borrower_debarment_id",
94 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
96 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
98 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
100 { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 50 },
102 { data_type => "mediumtext", is_nullable => 1 },
104 { data_type => "integer", is_nullable => 1 },
107 data_type => "timestamp",
108 datetime_undef_if_invalid => 1,
109 default_value => \"current_timestamp",
114 data_type => "timestamp",
115 datetime_undef_if_invalid => 1,
124 =item * L</borrower_debarment_id>
130 __PACKAGE__->set_primary_key("borrower_debarment_id");
134 =head2 borrowernumber
138 Related object: L<Koha::Schema::Result::Borrower>
142 __PACKAGE__->belongs_to(
144 "Koha::Schema::Result::Borrower",
145 { borrowernumber => "borrowernumber" },
146 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
153 Related object: L<Koha::Schema::Result::RestrictionType>
157 __PACKAGE__->belongs_to(
159 "Koha::Schema::Result::RestrictionType",
161 { is_deferrable => 1, on_delete => "NO ACTION", on_update => "CASCADE" },
165 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-08-19 17:53:04
166 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kDCkA7XrjKXlrFG5lk8Lgg
169 # You can replace this text with custom code or comments, and it will be preserved on regeneration