1use utf8; 2package App::Netdisco::DB::Result::DevicePortProperties; 3 4use strict; 5use warnings; 6 7use base 'App::Netdisco::DB::Result'; 8__PACKAGE__->table("device_port_properties"); 9__PACKAGE__->add_columns( 10 "ip", 11 { data_type => "inet", is_nullable => 0 }, 12 "port", 13 { data_type => "text", is_nullable => 0 }, 14 "error_disable_cause", 15 { data_type => "text", is_nullable => 1 }, 16 "remote_is_wap", 17 { data_type => "boolean", default_value => \"false", is_nullable => 1 }, 18 "remote_is_phone", 19 { data_type => "boolean", default_value => \"false", is_nullable => 1 }, 20 "remote_vendor", 21 { data_type => "text", is_nullable => 1 }, 22 "remote_model", 23 { data_type => "text", is_nullable => 1 }, 24 "remote_os_ver", 25 { data_type => "text", is_nullable => 1 }, 26 "remote_serial", 27 { data_type => "text", is_nullable => 1 }, 28 "raw_speed", 29 { data_type => "bigint", default_value => 0, is_nullable => 1 }, 30 "faststart", 31 { data_type => "boolean", default_value => \"false", is_nullable => 1 }, 32 "ifindex", 33 { data_type => "bigint", is_nullable => 1 }, 34); 35__PACKAGE__->set_primary_key("port", "ip"); 36 37 38=head1 RELATIONSHIPS 39 40=head2 port 41 42Returns the entry from the C<port> table for which this Power entry applies. 43 44=cut 45 46__PACKAGE__->belongs_to( port => 'App::Netdisco::DB::Result::DevicePort', { 47 'foreign.ip' => 'self.ip', 'foreign.port' => 'self.port', 48}); 49 501; 51