Transition matrix
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 | |||||
| description | STRING | 80 | X | X | |||||||
| idle time | TIME | X | X | ||||||||
| last modified | DATE | X | |||||||||
| matrix code | STRING | 80 | X | X | X | X | X | X | |||
| matrix type | NUM | X | X | X | X | X | X | The type of matrix; 1 = duration, 2 = cost | |||
| model name | STRING | 80 | X | Global | model name | X | X | X | |||