Utility level
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 | utility code | |||||||
| date | DATE | X | date for utility requirement value | ||||||||
| model name | STRING | 80 | X | X | model name | ||||||
| unique key | STRING | 255 | X | X | utility code (padded with spaces to 80 characters) + internal time reference (20 characters) | ||||||
| utility claim | NUM | X | utility requirement value | ||||||||
| utility available | NUM | X | utility available value | ||||||||