HP Device Manager 4.5 - Database Schema Guide

32
Gateway-related tables
dm_gateway
This is the gateway table.
1. Table columns
Column Name
Type Name
Column Size
Nullable
Primary Key
Description
gateway_id
nvarchar
50
NO
√
Gateway ID (use MAC address as
default)
Active
smallint
5
NO
Whether gateway is active or not:
0: inactive
1: active
2: broken (never happen)
authentic smallint 5 NO
Authentic type:
0: unknown
1: acknowledged
2: banned
found_date
datetime
23
NO
Gateway found date
gateway_name
nvarchar
50
NO
Gateway name
Ip
nvarchar
50
NO
Gateway IP
Mac
nvarchar
50
NO
Gateway MAC address
Mask
nvarchar
50
NO
Mask
netaddress
nvarchar
50
NO
Net address
os_type
nvarchar
20
NO
OS type
poll_interval
nvarchar
50
NO
Poll interval, default is null
update_date
datetime
23
NO
Update date
Version nvarchar 50 NO Version
2. Relevant UI