| 5 | | * '''id''' - primary key |
| 6 | | * '''course''' - the course number, ex: APSC 123 |
| 7 | | * '''title''' - a very short course description, ex: Academic Writing |
| 8 | | * '''homepage''' - a link to the course. Must start with !http:// or !https:// |
| 9 | | * '''self_enroll''' - not fully implemented. The UI exists to modify this value, but no effect linked to it can be found in code |
| 10 | | * '''password''' - an MD5 hash of the user password. |
| 11 | | * '''record_status''' - either 'A' or 'I', representing active or inactive. Not always checked by code. |
| 12 | | * '''creator_id''' - the ID of the user who created this course. Foreign Key to ''users'' table. |
| 13 | | * '''created''' - a date entry for this entry's creation. |
| 14 | | * '''updater_id''' - the last user's ID who changed this record. Foreign Key to ''users'' table. |
| 15 | | * '''instructor_id''' - unused, as far as I can tell. The course-instructor is a many-to-many relationship is handled by the ''user_courses'' table. |
| | 5 | ||Column||Type||Description||Foreign Key in...|| |
| | 6 | ||'''id'''||integer||primary key |
| | 7 | ||'''course'''||string||the course number, ex: APSC 123 |
| | 8 | ||'''title'''||string||a very short course description, ex: Academic Writing |
| | 9 | ||'''homepage'''||string||a link to the course. Must start with !http:// or !https:// |
| | 10 | ||'''self_enroll'''||emun(on, off)||not fully implemented. The UI exists to modify this value, but no effect linked to it can be found in code |
| | 11 | ||'''password'''||string||an MD5 hash of the user password. |
| | 12 | ||'''record_status'''||enum(A,I)||either 'A' or 'I', representing active or inactive. Not always checked by code. |
| | 13 | ||'''creator_id'''||integer||the ID of the user who created this course.||users |
| | 14 | ||'''created'''||date||a date entry for this entry's creation. |
| | 15 | ||'''updater_id'''||integer||the last user's ID who changed this record.||users |
| | 16 | ||'''instructor_id'''||unused, as far as I can tell. The course-instructor is a many-to-many relationship is handled by the ''user_courses'' table. |
