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 | ||||||||