search for: parent_child_categories

...w well does Rails deal with ActiveRecord classes mapping to self-referencing tables and other more interesting database complexities? i.e. Employees table with supervisor_id and mentor_id both self-referencing Employees on the primary key "id" or Categories table with relation table (Parent_Child_Categories) with foreign keys parent_id and child_id both referencing Categories.id allowing for infinite nesting of many-many related categories or Supervisors table extending Employees table with a one-one relationship (Supervisors.id = Employees.id) allowing for storage of supervisor-specific data ____...