View of /trunk/webwork2/doc/devel/DBglue.notes

    1 ##############
    2 # webwork_DB #
    3 ##############
    4 
    5 PSVN =>
    6   <field_name_in_hash> => <field_name_in_api>
    7 
    8   (Generated during problem set build process:)
    9 
   10   stlg  StudentLogin    the login name of the student who owns this PSVN
   11   stnm  SetNumber   the "number" (name) of the problem set associated with this PSVN
   12   pse#  ProblemSeed(#)    the problem seed, a random integer between 0 and 5000
   13 
   14   (Taken from set definition file:)
   15 
   16   shfn  SetHeaderFileName     the file name of the set header file (shown when selecting problem?)
   17   phfn  ProbHeaderFileName      the file name of the problem header file (shown when viewing a problem)
   18   opdt  OpenDate        the date that the problem set "opens"
   19   dudt  DueDate         the date after which no credit can be recieved
   20   andt  AnswerDate        the date when answers can be shown
   21   pfn#  ProblemFileName(#)      the file name of the problem
   22   pva#  ProblemValue(#)       the number of points that the problem is worth
   23   pmia# ProblemMaxNumOfIncorrectAttempts(#) the number of times a student is allowed to answer incorrectly
   24 
   25   (Added when student works on problem set:)
   26 
   27   pst#  ProblemStatus(#)    the "correctness" of the problem: [0,1]
   28   pat#  ProblemAttempted(#)   boolean, whether the problem has been attempted (answer has been submitted)
   29   pan#  ProblemStudentAnswer(#)   the student's last answer (attempt) for a problem
   30   pca#  ProblemNumOfCorrectAns(#) number of correct answers (there can be more than one ANS per problem)
   31   pia#  ProblemNumOfIncorrectAns(#) number of incorrect answers
   32 
   33 LOGIN =>
   34   SetNumber => PSVN
   35   ...
   36 
   37 SET_NUMBER =>
   38   StudentLogin => PSVN
   39   ...
   40 
   41 ################
   42 # classlist_DB #
   43 ################
   44 
   45 LOGIN =>
   46   stln  StudentLastName
   47   stfn  StudentFirstName
   48   stea  StudentEmailAddress
   49   stid  StudentID
   50   stst  StudentStatus
   51   clsn  ClassSection
   52   clrc  ClassRecitation
   53   comt  Comment
   54 
   55 ########
   56 # keys #
   57 ########
   58 
   59 LOGIN =>
   60   KEY   the last key associated with the user
   61   TIMESTAMP the time that this key was last used
   62 
   63 ###############
   64 # password_DB #
   65 ###############
   66 
   67 LOGIN =>
   68   PASSWORD  the password set for this user
   69 
   70 ##################
   71 # permissions_DB #
   72 ##################
   73 
   74 LOGIN =>
   75   PERMISSIONS an integer representing the permissions allowed to the user (i.e. 10=prof, 5=ta)