http://docs.farcrycore.org/ has our ongoing attempts to automatically extract useful information from the framework. Go into the docs for your version and look at "types". Comments on what should be documented but isn't are welcome. Unfortunately system fields (like objectid) aren't included. Almost every table in FarCry uses objectid as the primary key, and those values are universally unique - in theory you could merge separate databases without conflicts. The main exception is refObjects which maps objectids to their content type / table.
Blair On Thu, Feb 11, 2010 at 6:28 PM, West <[email protected]> wrote: > Hi > > Would it be possible to get a data dictionary or some sort of > documentation around the database schema. It would be helpful to know > object definitions such as tables. For example, the table called > "FarFU", when I look inside it appears to be one of the tables > involved in storing the Friendly URLs, it appears they are uniquely > identified by the value in the "ObjectID" column. By I'm just making > educated guesses here. Something more concrete would be nice. > > It could be a word doc, wiki, Excel, I'm not sure of the best way to > publish it, I'll defer to the FarCry team but it would be helpful to > know what these columns represent (bDefault, fuStatus, etc, etc). It > doesn't need to be complex but something even like: > > > Table Name > > dmEmail - Desc goes here > - col Name desc > dmEvent - Desc goes here > - colName desc > - colName desc > dmFacts - Desc goes here...,etc, > dmHTML - Some desc here.. > > > Ideally, we'd have desc for each of the columns too but any forward > progress in this area would be well served to end users and even > internally for the development team. Maybe you have something like > this already?? > > Just a suggestion... > > -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] > To unsubscribe, email: > [email protected]<farcry-dev%[email protected]> > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
