Photo of Joe Carroll


Data Model help

Is the data model documented anywhere?  I'm trying to write some SQL and am not sure where to look for some of the custom person attributes that we have added.

  • Photo of Jim Michael


    There is a Model Map under Admin | Power Tools on all Rock instances. There is also a SQL Map plugin in the Rock Shop that gives you a list of all tables and their relationships. 

    That said, all attributes will end up in Attributes and AttributeValues tables, regardless of the kind of attribute,