Route constraint
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 | |||||
| allowed | BOOLEAN | X | X | 2 = yes, 1 = No | |||||||
| description | STRING | 80 | X | X | |||||||
| direct | BOOLEAN | X | X | 2 = yes, 1 = No | |||||||
| from code | STRING | 80 | X | resource(group) | code | X | X | X | |||
| from type | NUM | X | X | X | X | 1 = resource, 2 = resource group | |||||
| model name | STRING | 80 | X | Global | model name | X | X | X | |||
| to code | STRING | 80 | X | resource(group) | code | X | X | X | |||
| to type | NUM | X | X | X | X | 1 = resource, 2 = resource group | |||||
| unique key | STRING | 170 | X | X | X | [resource (group)]from code (padded with spaces to 80 characters) + from type (integer, 5 characters) + [resource (group)]to code (padded with spaces to 80 characters) + to type (integer, 5 characters) | |||||