I'm trying to design/document a collection of lists with lookups in an Entity Relationship Diagram.
Currently I'm using Visio's built-in ERD template, which is most of the way there, but it lacks two key features:
- A good representation of a Multi-Lookup column relationship
- SharePoint-specific data types (Choice, Lookup, Calculated)
I can create a diagram with hidden data types to avoid the second issue, but that loses a rather important part of the documentation.
Is there a template, plugin, or shape collection for Visio that will allow me to produce a SharePoint List ERD with either or both of these features? Alternatively, is there a different tool that covers this functionality?
Edit: @Tom Resing's answer has made me think about why I'm after a Visio extension or comparable tool:
I need the result to be presentable enough for a formal document, but convenient enough to use for me to change my mind about half the structure part way through (as I often do).