.. index::
   tbl1_sync_log

=============
tbl1_sync_log
=============

.. default-role:: doc

:Description:

   This table has a log of when the Solutions sync with CSS was performed. It is viewable in the Solutions Control Center "css sync" log tab

:Relation:

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



Columns
=======


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

   :Options:

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


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

   :Description:

      Fall, Spring or Summer

   :Options:

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


**the_year** ``int(8) DEFAULT NULL``

   :Description:

      semester year

   :Options:

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


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

   :Description:

      notes (is this used?)

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


**num_changes_flagged** ``int(8) DEFAULT 0``

   :Description:

      Number of discrepancies detected and reported in sync report

   :Options:

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


**sync_timestamp** ``datetime DEFAULT NULL``

   :Options:

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