Downtime
           Note: The X icon indicates Yes. In Mode columns, X indicates that the fields are optional in the specified operation. Where noted as mandatory, the field is required in the specified action.
          
         | Type | Length | PK | FK | Mode | Mandatory | Remarks | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Table | Field | Read | Write | Delete | Create | Update | |||||
| code | STRING | 80 | X | X | X | X | X | ||||
| duration | TIME | 20 | X | X | X | ||||||
| end time | DATE | X | X | X | |||||||
| locked | BOOLEAN | X | X | X | For ASCII interfaces a boolean can be numeric (true=2, false=1, no value=0) alpha numeric (true/false/novalue) or free text. For ODBC, this is a numeric value | ||||||
| model name | STRING | 80 | X | resource | model name | X | |||||
| remarks | STRING | 80 | X | X | X | ||||||
| resource | STRING | 80 | resource | code | X | X | X | ||||
| start time | DATE | X | X | X | |||||||