__PACKAGE__->table(
"device_browser"
);
__PACKAGE__->add_columns(
"ip"
,
{
data_type
=>
"inet"
,
is_nullable
=> 0 },
"oid"
,
{
data_type
=>
"text"
,
is_nullable
=> 0 },
"oid_parts"
,
{
data_type
=>
"integer[]"
,
is_nullable
=> 0 },
"leaf"
,
{
data_type
=>
"text"
,
is_nullable
=> 0 },
"munge"
,
{
data_type
=>
"text"
,
is_nullable
=> 1 },
"value"
,
{
data_type
=>
"text"
,
is_nullable
=> 1 },
);
__PACKAGE__->set_primary_key(
"ip"
,
"oid"
);
__PACKAGE__->belongs_to(
snmp_object
=>
'App::Netdisco::DB::Result::SNMPObject'
,
sub
{
my
$args
=
shift
;
return
{
"$args->{self_alias}.oid"
=> {
-ident
=>
"$args->{foreign_alias}.oid"
},
"$args->{self_alias}.ip"
=> {
'='
=> \
'?'
},
};
},
{
join_type
=>
'RIGHT'
}
);
__PACKAGE__->belongs_to(
oid_fields
=>
'App::Netdisco::DB::Result::SNMPObject'
,
'oid'
);
1;