HP Device Manager 4.5 - Database Schema Guide

25
dm_device_subtasks
This is the device sub task table, which stores the device’s related tasks.
1. Table columns
Column Name
Type Name
Column Size
Nullable
Primary Key
Description
task_id
varchar
50
NO
√
subtask_id
varchar
50
NO
√
device_id
varchar
50
NO
√
start_time
datetime
23
NO
end_time
datetime
23
NO
status varchar 16 YES
It contains one of the following values:
“ready”, “waiting”, “sending”,
“processing”, “success”, “failure”,
“waitForAgent”, “processPercent”,
“pause”, “waiting”, “chaos”,
“unretrieved”, “Operational”,
“Deleting…”, “Deleted”, “Canceling…”,
“Canceled”
visible
char
1
YES
error_code
varchar
20
YES
update_date
datetime
23
NO
2. Relevant UI