...
Column Name | Description |
---|---|
GROUPID | The primary key of the group. |
GROUPNAME | The name of the group as it appears on the navigation tree. |
PARENTGROUP | Foreign key to a group's primary key. It allows a nested structure. |
OWNER | The name of the group's owner. Used to display user's specific groups. |
APPID | Foreign key to the application's primary key. |
OPERATOR | Not used for now. Meant to somehow contain information on what to do to the contained data when the folder is selected. |
DESCSHORT | Not used for now. Meant for ?. |
DESCLONG | Not used for now. Meant for ?. |
Links are connections between a data or a group in one application to a group and/or a set of data in the same or another application.
Column Name | Description |
---|---|
ID | The primary key of the leaf. |
LINKID | The id of the link the leaf belongs to. |
DATAID | Foreign key to the data's id contained in the leaf. |
Column Name | Description |
---|---|
LINKID | The primary key of the link. |
STARTAPPID | Foreign key to the application's id from which the link originates. |
ENDAPPID | Foreign key to the application's id where the link ends. |
FROMFK | Foreign key of the data from which the link starts. |
TOGROUPID | Foreign key to the group's id where the link ends. |
TODATA | Incorrectly used.Meant to be a comma separated list of ids to which the link goes to. |
OWNER | The owner of the link. Used to display user's specific links. |
TODATA | Obsolete. To be removed. |