What are the database tables used for maintenance schedules?

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When creating a maintenance schedule what tables in the UIM database are updated with the schedule details? 

Environment

Release : 20.3.x or later

Component : UIM MAINTENANCE MODE

Resolution

Maintenance schedules details are written to these tables:
MAINTENANCE_SCHEDULE
MAINTENANCE_SCHEDULE_MEMBERS
MAINTENANCE_WINDOW
MAINTENANCE_WINDOW_HISTORY

Here are the columns each table has:
MAINTENANCE_SCHEDULE
SCHEDULE_ID,SCHEDULE_NAME,START_TIME,DURATION,DESCRIPTION,ACCOUNT_ID,RECURRENCE_PATTERN,RECURRENCE_PERIOD,RECURRENCE_DAYS_OF_THE_WEEK,RECURRENCE_DAY_OF_THE_MONTH,RECURRENCE_INSTANCE,RECURRENCE_END_TIME,TIMEZONE

MAINTENANCE_SCHEDULE_MEMBERS
SCHEDULE_ID,CS_ID

MAINTENANCE_WINDOW
WINDOW_ID,SCHEDULE_ID,DEV_ID,START_TIME,END_TIME

MAINTENANCE_WINDOW_HISTORY
WINDOW_ID,SCHEDULE_ID,DEV_ID,START_TIME,END_TIME

Note all tables use SCHEDULE_ID for identifying the schedule. 

Additional Information

How to run a query to show devices in maintenance mode: 
https://knowledge.broadcom.com/external/article?articleId=33948