[Building Sakai] sakai-dev Digest, Vol 43, Issue 25

[Gregory Guthrie]

Aren't there a lot of missing key declarations in the database?

For example, all of tie ID keys in many Sakai_* tables have no declared key references to any other table(s).

An example, SST_EVENTS has user_id, site_id, ID, all of which are references to other tables, but none are so declared.

Another note from this forum earlier;
  " Or lookup the SITE_ID in the SAKAI_SITE table by querying the TITLE field for your site name.  The SITE_ID is the GRADEBOOK_UID in GB_GRADEBOOK_T."

But this is not listed in the foreign keys declarations.

-------------------------------------------
> Subject: Re: [Building Sakai] Sakai DB structure
> 
> Download a tool like DbVis:
> 
>   http://www.dbvis.com/
> 
> Hook it up to your development database and check out the references between the various
> clusters of tables.  MFR = Message Center, SAM=Samigo, ASN=Assignments, etc.
>