[OpenWeBWorK-devel] WWDBv3

[Sam H. <sa...@uo...>]

Hi all,

Here's the first draft of the schema for WWDBv3, the long-promised  
SQL-only database schema for WeBWorK:  
<http://devel.webwork.rochester.edu/twiki/bin/view/Webwork/ 
DatabaseSchemaV3>. Some features:

* Global user table and course-specific participant tables eliminate  
duplication of user data.
* Separation of user-specific data and global-override data.
* version table allows set and problem versioning.
* attempt table keeps a complete record of problem attempts,  
per-version.
* section, recitation, and status tables enumerate the possible values  
for these fields.
* role table represents a participant's role in the course (i.e.  
"instructor", "teaching assistant", "student").
* Privileges are associated with roles via the role_privilege table  
(replacing the "permission level" mechanism).

If you're interested, please check it out and post any questions,  
suggestions, concerns, etc.

Thanks.
-sam