HP Device Manager 4.5 - Database Schema Guide

47
dm_schedule
This is the schedule table.
1. Table columns
Column Name
Type
Name
Column
Size
Nullable
Primary
Key
Foreign Key
Description
schedule_id
nvarchar
50
NO
√
dm_rule.schedule.id
dm_walkingschedule.schedule_id
Schedule ID
category
nvarchar
50
NO
Schedule category
(belong to):
“1”: snapshot
“2”: walking tool
“3”: rule
creator
nvarchar
50
NO
The user ID of creator
lastruntime
datetime
23
YES
Last run time
nextruntime datetime 23 YES Next run time
period
nvarchar
50
NO
The weeks number
(how many weeks)
schedule_time
datetime
23
YES
Schedule time
schedule_type
nvarchar
50
NO
Schedule type:
“1”: daily
“2”: weekly
“3”: once
status
nvarchar
50
NO
“0”: disabled
“1”: enabled
weekday
nvarchar
50
NO
The selected
weekdays
(combined to one
value)
2. Relevant UI