Skip to Content.
Sympa Menu

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

Subject: Grouper Developers Forum

List archive

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

Chronological Thread 
  • From: "Cramton, James" <>
  • To: "blair christensen." <>
  • Cc: <>
  • Subject: RE: [grouper-dev] Grouper DB Schema and Foreign Keys
  • Date: Mon, 9 Jul 2007 11:08:31 -0400

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.


-----Original Message-----

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

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

On 7/3/07, Cramton, James
> 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?

Archive powered by MHonArc 2.6.16.

Top of Page