Redmine data dictionary
I want to know if you allow, the signification of the fields 'lft' and 'rgt' in the projects and issues tables
thanks a lot
RE: Redmine data dictionary - Added by Mischa The Evil 11 months ago
rgt (and additionally
parent_id) are columns used by the Awesome Nested Set plugin, vendored with Redmine (source:/trunk/lib/plugins/awesome_nested_set). Their values are used to determine the position of either a project or an issue in a nested tree hierarchy.
See I have upgraded to 1.0.1 ,significance of lft and rgt for some more info and references to documentation which explains the way tree traversal is executed on projects and issues (modified preorder tree traversal).