.. index::
   tbl1_About_sd

=============
tbl1_About_sd
=============

.. default-role:: doc

: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=""``