tbl1_About_sd¶
- Description
This is the Solutions “About” table for the Solutions Database application. Solutions will compare version numbers in this table with version numbers in the local tbl1_About_sd_local table in SolutionsDashboard.accdb If version numbers do not match, the program will not be allowed to start up. Future Direction: It would be nice to have a single solutions “About” table with a field for the version number of each application, instead of all of these separate tables.
Columns¶
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
Version_Number varchar(255) DEFAULT NULL
- Description
data version number for this application
- Options
display="true", null="true", search="false", type=""
Release_Date datetime DEFAULT NULL
- Description
date latest version of this application was prepared
- Options
display="true", null="true", search="false", type=""
share_path varchar(255) DEFAULT NULL
- Description
this is from before solutions used MySQL. but not quite obsolete yet since SolutionsDashboard.accdb still uses this for images and docs subfolders.
- Options
display="true", null="true", search="false", type=""
database_type varchar(255) DEFAULT NULL
- Description
obsolete? This was from when we allowed choice of MSAccess vs MySQL databases
- Options
display="true", null="true", search="false", type=""
people_url_prefix varchar(255) DEFAULT NULL
- Description
When building URL for a persons page, this is used as beginning part of URL and the program will append netid.
- Footnote
Recommendation: move this field to a global options table instead of in this table
- Options
display="true", null="true", search="false", type=""
course_url_prefix_undergraduate varchar(255) DEFAULT NULL
- Description
When building URL for an undergraduate course, this is used as beginning part of URL and the program will append the value of the course’s associated url_reference value from tbl1_Courses table
- Footnote
Recommendation: move this field to a global options table instead of in this table
- Options
display="true", null="true", search="false", type=""
course_url_prefix_graduate varchar(255) DEFAULT NULL
- Description
When building URL for an graduate course, this is used as beginning part of URL and the program will append the value of the course’s associated url_reference value from tbl1_Courses table
- Footnote
Recommendation: move this field to a global options table instead of in this table
- Options
display="true", null="true", search="false", type=""
syllabus_url_undergraduate varchar(255) DEFAULT NULL
- Description
obsolete?
- Footnote
I think the intention here was a link to undergraduate syllabi but not sure this was ever used. Comments in code say ‘fill this in when IT has more requirements.’ Not sure the full history. I think the intention of this is now accomplished via the section-specific section_url field in the tbl1_Instructors_ClassesTaught table
- Options
display="true", null="true", search="false", type=""
syllabus_url_graduate varchar(255) DEFAULT NULL
- Description
obsolete?
- Footnote
I think the intention here was a link to graduate syllabi but not sure this was ever used. Comments in code say ‘fill this in when IT has more requirements.’ Not sure the full history. I think the intention of this is now accomplished via the section-specific section_url field in the tbl1_Instructors_ClassesTaught table
- Options
display="true", null="true", search="false", type=""
connection_string varchar(255) DEFAULT NULL
- Description
not used in data db; only 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=""
about_notes varchar(255) DEFAULT NULL
- Description
obsolete?
- Options
display="true", null="true", search="false", type=""