devicestatus

The devicestatus table stores data for device statuses. This table has a primary key based on the Status column.

Table 1. devicestatus table
Column Description
Status

varchar(100) NOT NULL

The device status.

Description

text

A description of the device status.

DeletedFlag

int(1) unsigned zerofill default '0'

Indicates whether a device status has been deleted (0 = false, 1 = true).

Although the entity may be flagged as deleted, it is not purged from the database because historical data (that is, older report logs) may continue to reference it.