tbl1_course_docs

Description

This table gives names of documents associated with courses. It is assumed that the documents are saved in a “docs” subfolder under the share path

Relation

many to one relationship with tbl1_Courses table where tbl1_course_docs.CourseID = tbl1_Courses.id

Footnote

We might want to obsolete this table. It is a good feature in that you can link documents to courses in Solutions, and therefore can keep a history of things like past syllabi. However, we have not gotten in the habit of using this feature, and since it is one of the only places in Solutions still using the share path, we might want to remove this capability

Columns

ID int(11) NOT NULL

Options

display="true", null="true", search="false", type=""

CourseID int(11) DEFAULT NULL

Description

relates to CourseID field in tbl1_Courses table

Options

display="true", null="true", search="false", type=""

doc_date datetime DEFAULT NULL

Description

Date document was associated with course in Solutions

Options

display="true", null="true", search="false", type=""

doc_type varchar(255) DEFAULT NULL

Description

user-entered text description of document

Options

display="true", null="true", search="false", type=""

doc_file_name varchar(255) DEFAULT NULL

Description

file name of document without path

Footnote

path is assumed to be in subfolder docs under share_path which is specified in local about table

Options

display="true", null="true", search="false", type=""

last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

Options

display="true", null="true", search="false", type=""