——————use
utf8;
package
Schema::Result::DeptManager;
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
=head1 NAME
Schema::Result::DeptManager
=cut
use
strict;
use
warnings;
=head1 TABLE: C<dept_manager>
=cut
__PACKAGE__->table(
"dept_manager"
);
=head1 ACCESSORS
=head2 emp_no
data_type: 'integer'
is_foreign_key: 1
is_nullable: 0
=head2 dept_no
data_type: 'char'
is_foreign_key: 1
is_nullable: 0
size: 4
=head2 from_date
data_type: 'date'
datetime_undef_if_invalid: 1
is_nullable: 0
=head2 to_date
data_type: 'date'
datetime_undef_if_invalid: 1
is_nullable: 0
=cut
__PACKAGE__->add_columns(
"emp_no"
,
{
data_type
=>
"integer"
,
is_foreign_key
=> 1,
is_nullable
=> 0 },
"dept_no"
,
{
data_type
=>
"char"
,
is_foreign_key
=> 1,
is_nullable
=> 0,
size
=> 4 },
"from_date"
,
{
data_type
=>
"date"
,
datetime_undef_if_invalid
=> 1,
is_nullable
=> 0 },
"to_date"
,
{
data_type
=>
"date"
,
datetime_undef_if_invalid
=> 1,
is_nullable
=> 0 },
);
=head1 PRIMARY KEY
=over 4
=item * L</emp_no>
=item * L</dept_no>
=back
=cut
__PACKAGE__->set_primary_key(
"emp_no"
,
"dept_no"
);
=head1 RELATIONS
=head2 dept_no
Type: belongs_to
Related object: L<Schema::Result::Department>
=cut
__PACKAGE__->belongs_to(
"dept_no"
,
"Schema::Result::Department"
,
{
dept_no
=>
"dept_no"
},
{
is_deferrable
=> 1,
on_delete
=>
"CASCADE"
,
on_update
=>
"RESTRICT"
},
);
=head2 emp_no
Type: belongs_to
Related object: L<Schema::Result::Employee>
=cut
__PACKAGE__->belongs_to(
"emp_no"
,
"Schema::Result::Employee"
,
{
emp_no
=>
"emp_no"
},
{
is_deferrable
=> 1,
on_delete
=>
"CASCADE"
,
on_update
=>
"RESTRICT"
},
);
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2019-02-20 11:39:40
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KhWSCtUweR9QTWrJOM2yJQ
# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;