Utility (availability exception)
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 | |||||
| available | NUM | X | X | X | |||||||
| code | STRING | 80 | X | utility | code | X | X | X | |||
| color | NUM | X | X | X | |||||||
| description | STRING | 80 | X | X | X | ||||||
| end outflow | DATE | X | X | X | X | ||||||
| model name | STRING | 80 | X | utility | model name | X | X | X | |||
| sequence | NUM | X | X | X | |||||||
| start inflow | DATE | X | X | X | X | ||||||
| unique key | STRING | 255 | X | X | X | utility code+start+stop | |||||