|
Lines 478-488
CREATE TABLE collections_tracking (
Link Here
|
| 478 |
DROP TABLE IF EXISTS courses; |
478 |
DROP TABLE IF EXISTS courses; |
| 479 |
CREATE TABLE `courses` ( |
479 |
CREATE TABLE `courses` ( |
| 480 |
`course_id` int(11) NOT NULL AUTO_INCREMENT, |
480 |
`course_id` int(11) NOT NULL AUTO_INCREMENT, |
| 481 |
`department` varchar(20) DEFAULT NULL, -- Stores the authorised value DEPT |
481 |
`department` varchar(80) DEFAULT NULL, -- Stores the authorised value DEPT |
| 482 |
`course_number` varchar(255) DEFAULT NULL, -- An arbitrary field meant to store the "course number" assigned to a course |
482 |
`course_number` varchar(255) DEFAULT NULL, -- An arbitrary field meant to store the "course number" assigned to a course |
| 483 |
`section` varchar(255) DEFAULT NULL, -- Also arbitrary, but for the 'section' of a course. |
483 |
`section` varchar(255) DEFAULT NULL, -- Also arbitrary, but for the 'section' of a course. |
| 484 |
`course_name` varchar(255) DEFAULT NULL, |
484 |
`course_name` varchar(255) DEFAULT NULL, |
| 485 |
`term` varchar(20) DEFAULT NULL, -- Stores the authorised value TERM |
485 |
`term` varchar(80) DEFAULT NULL, -- Stores the authorised value TERM |
| 486 |
`staff_note` mediumtext, |
486 |
`staff_note` mediumtext, |
| 487 |
`public_note` mediumtext, |
487 |
`public_note` mediumtext, |
| 488 |
`students_count` varchar(20) DEFAULT NULL, -- Meant to be just an estimate of how many students will be taking this course/section |
488 |
`students_count` varchar(20) DEFAULT NULL, -- Meant to be just an estimate of how many students will be taking this course/section |