.. index::
   tbl1_sync_messages

==================
tbl1_sync_messages
==================

.. default-role:: doc

:Description:

   Messages generated from Solutions sync with CSS for discrepancies found

:Relation:

   many-to-one relation with tbl1_sync_log where tbl1_sync_log.id = tbl1_sync_messages.sync_id



Columns
=======


**id** ``int(8) NOT NULL``

   :Options:

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


**sync_id** ``int(8) NOT NULL``

   :Description:

      sync id

   :Relation:

      relates to tbl1_sync_log.id

   :Options:

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


**change_type** ``int(8) NOT NULL``

   :Description:

      a code indicating type of change that was detected

   :Footnote:

      see solutions mod_declarations for more details

   :Options:

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


**before_value** ``varchar(255) DEFAULT NULL``

   :Description:

      value in Solutions before a change was automatically made

   :Options:

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


**after_value** ``varchar(255) DEFAULT NULL``

   :Description:

      value in Solutions after a change was automatically made

   :Options:

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


**recommended_action** ``varchar(255) DEFAULT NULL``

   :Description:

      Detail on what office staff should do based on the discreapancy found, viewable on sync report

   :Options:

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


**action_taken** ``varchar(255) DEFAULT NULL``

   :Description:

      summary message of whatever action Solutions automatically performed

   :Options:

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


**change_message** ``longtext DEFAULT NULL``

   :Description:

      Message logged in `tbl1_Schedule_Data` change message field

   :Options:

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


**unit** ``varchar(5) DEFAULT NULL``

   :Description:

      01 or 16

   :Options:

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


**subject** ``varchar(15) DEFAULT NULL``

   :Description:

      subeject code of course

   :Options:

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


**course** ``varchar(15) DEFAULT NULL``

   :Description:

      3-digit course code of course

   :Options:

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


**index** ``varchar(45) DEFAULT NULL``

   :Description:

      5-digit course index number

   :Options:

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


**mode** ``varchar(45) DEFAULT NULL``

   :Description:

      meeting mode of course row (L for lecture, etc)

   :Options:

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


**section** ``varchar(45) DEFAULT NULL``

   :Options:

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


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

   :Description:

       section number

   :Options:

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