Route constraint

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)