HP Device Manager 4.6 - Database Schema Guide

dm_group_schema
This is the manual grouping schema table.
1. Table columns
Column name Type name Column
size
Nullable Primary
key
Foreign key Description
schema_id int 10 NO √ dm_manual_grouping.schema_id Manual schema ID
schema_name nvarchar 50 NO Manual schema
name
user_id nvarchar 50 NO The creator’s user ID
2. Relevant UI
dm_manual_grouping
This is the manual grouping table, which stores the device relationship with a manual schema and path.
1. Table columns
Column name Type name Column size Nullable Primary key Description
device_id nvarchar 50 NO √
path_id int 10 NO √
schema_id int 10 NO √
50