Grouper Developers Forum

["Cramton, James" <>]

From my standpoint, a DB schema is the chief concern, so we can better
understand the relationships within the schema. I hesitate to build too
complex a system that directly accesses the data, given the fact that
the schema may change in future versions, but I think this kind of
documentation is important for developers to have so we better
understand the data model.

James

-----Original Message-----
From: 

 
[mailto:]
On Behalf Of blair christensen.
Sent: Friday, July 06, 2007 3:38 PM
To: Cramton, James
Cc: 

Subject: Re: [grouper-dev] Grouper DB Schema and Foreign Keys

On 7/3/07, Cramton, James 
<>
 wrote:
> In working on our Grouper LDAP provisioning project, I notice that 
> there are no foreign keys in our Grouper DB running on Oracle 10g.  Is

> this a glitch in our Oracle dialect, or are the foreign keys 
> intentionally missing from the schema?

That was intentional.  I found Hibernate to be far less annoying to work
with, more reliable (and in this case: faster) after eliminating the
foreign keys.

> I've poked around on the wiki, but I can't find an ER diagram or any 
> docs that might shed some light.

We used to publish one of those with each release but I guess we haven't
for the last couple.  Tom and I can look into creating a new one.  What
other documentation would be useful?