Project

General

Profile

Redmine data dictionary

Added by Hatim Rassili over 11 years ago

Hello,

I want to know if you allow, the signification of the fields 'lft' and 'rgt' in the projects and issues tables

thanks a lot


Replies (1)

RE: Redmine data dictionary - Added by Mischa The Evil over 11 years ago

lft and rgt (and additionally root_id & 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).

    (1-1/1)