View of /trunk/webwork-modperl/doc/new-DB-structure

    1 --------------------------------------------------------------------------------
    2 DB table structure
    3 --------------------------------------------------------------------------------
    4 
    5 The DB API models an underlying table structure that may or may not literally exist, depending on what transformations the schema modules make. However, this is the table structure that is presented to users of the DB module.
    6 
    7 The order of key fields in this list is the order that arguments should be passed to the exists(), get(), and delete() schema functions, and the order of the values in the return value of the list() schema function.
    8 
    9 *  indicates a key
   10 => indicates a relation
   11 !  indicates an override field
   12 ~  indicates a "dynamic" field (modified by the problem processor)
   13 
   14 password
   15 	user_id		*,=> user.id
   16 	password
   17 permission
   18 	user_id		*,=> user.id
   19 	permission
   20 key
   21 	user_id		*,=> user.id
   22 	key
   23 user
   24 	id		*
   25 	first_name
   26 	last_name
   27 	email_address
   28 	student_id
   29 	status
   30 	section
   31 	recitation
   32 	comment
   33 set
   34 	id		*
   35 	set_header
   36 	problem_header
   37 	open_date
   38 	due_date
   39 	answer_date
   40 	problem_order		(not implemented)
   41 set_user
   42 	user_id		*,=> user.id
   43 	set_id		*,=> set.id
   44 	psvn
   45 	set_header	!
   46 	problem_header	!
   47 	open_date	!
   48 	due_date	!
   49 	answer_date	!
   50 	problem_order	!	(not implemented)
   51 problem
   52 	id		*
   53 	set_id		*,=> set.id
   54 	source_file
   55 	value
   56 	max_attempts
   57 problem_user
   58 	user_id		*,=> user.id
   59 	set_id		*,=> set.id
   60 	problem_id	*,=> problem.id
   61 	source_file	!
   62 	value		!
   63 	max_attempts	!
   64 	problem_seed
   65 	status		~
   66 	attempted	~
   67 	last_answer	~
   68 	num_correct	~
   69 	num_incorrect	~