View of /trunk/webwork2/doc/devel/schema-2002

    1 => denotes a field which corresponds to the key of another table
    2 
    3 --------------------------------------------------------------------------------
    4 Database: COURSENAME_classlist (i.e. MTH161Q_classlist)
    5 --------------------------------------------------------------------------------
    6 
    7 Table: user
    8 Read by: scoring tools, classlist tools
    9 Written by: classlist tools
   10 
   11 	login
   12 	last_name
   13 	first_name
   14 	email_address
   15 	student_id
   16 	status
   17 	section
   18 	recitation
   19 	comment
   20 
   21 Table: access
   22 Read by: authorization system
   23 Written by: classlist tools
   24 
   25 	login
   26 	password
   27 	permissions
   28 
   29 --------------------------------------------------------------------------------
   30 Database: COURSENAME_webwork
   31 --------------------------------------------------------------------------------
   32 
   33 Table: set
   34 Read by: set lister, problem lister, harcopy generator, problem processor
   35 Written by: set generator
   36 	
   37 	name
   38 	set_header
   39 	problem_header
   40 	open_date
   41 	due_date
   42 	answer_date
   43 
   44 Table: problem_SETNAME
   45 Read by: problem lister, hardcopy generator, problem processor, scoring tools
   46 Written by: set generator
   47 
   48 	number
   49 	source_file
   50 	value
   51 	max_attempts
   52 
   53 Table: set_user
   54 Read by: same as set table
   55 Written by: set generator
   56 
   57 	login => user.login
   58 	set => set.name
   59 	psvn
   60 	problem_order
   61 	open_date
   62 	due_date
   63 	answer_date
   64 
   65 Table: ww_USERNAME
   66 Read by: same as problem_SETNAME table
   67 Written by: set generator, problem processor
   68 
   69 	set => set.name
   70 	problem => problem.number
   71 	max_attempts
   72 	problem_seed
   73 	status
   74 	attempted
   75 	last_answer
   76 	num_correct
   77 	num_incorrect