Changes between Version 71 and Version 72 of iPeerDatabaseSchema

Timestamp:

2010-10-25T16:15:38Z (15 years ago)

Author:

Serge Okon

Comment:

--

iPeerDatabaseSchema

@@ -368 +368 @@
 ||__Column__||__Type__||__Description__||__Foreign Key to table...__||
 ||'''id'''||integer||Primary_Key
+||'''role'''||enum('A','S','I')||The role of this user. ''A'' stands for Admin, ''I'' for instructor, and ''S'' for student.
+||'''username'''||string||The login username for the user. Expected to be numeric for Students, but can be anything for other user roles.
+||'''password'''||string||An md5 hash of a users password
+||'''first_name'''||string||The user's first name.
+||'''last_name'''||string||The user's last name.
+||'''student_no'''||string||If the user is a student, this is their student number. it should be identical to username.
+||'''title'''||string||The title of the user, like mr, or ms.
+||'''email'''||string||The email of the user
+||'''last_login'''||date||unused, all NULL
+||'''last_logout'''||date||unused, all NULL
+||'''last_accessed'''||date||unused, all NULL.
 
 == user_enrols ==