HP Device Manager 4.6 - Database Schema Guide

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
44