We kinda model our pigtails in Fiber Manager. On the BACKSIDEPORT table, we added a column for PIGTAILCOLOR and gave it a color domain.
While not a patch lead, our method might work for you. You'd have add a PATCHLEADCOLOR column to all the ports that your leads would connect to. Then you could label off that column. It really depends on how much info about the patch lead you need. If you need some manufacturer info about the lead, you could add those columns as well. Yes, there would be a duplication of data entry and you'd have to keep both ends of the lead in mind when you edit. You could get those columns in without a lot of trouble or concern with messing up the Fiber schema.
I imagine you could utilize the flexible data model and add a patch lead table, but the difficulty might depend on where you are at with your Fiber Manager system. New implementation that you're building out now? Pretty easy. Existing implementation? That might be harder to get wedged in there. Someone from SE can comment on that though.
cheers for that. Yes this is a new implementation. Having comments on both ports can work and it prevents having a multitude of Patch Leads in the drop down menus in Connection Manager. I'll model both in Minerville and I'll see how users want to proceed.