.. index::
   tbl1_AppointmentHistory

=======================
tbl1_AppointmentHistory
=======================

.. default-role:: doc

:Description:

   This table relates to the `tbl1_Appointments` table where one appointment in tbl1_Appointments can have many related records in `tbl1_AppointmentHistory`.
   This tables contains a record for each person who has held a particular appointment during a particular timeframe.

:Relation:

   many to one with `tbl1_Appointments` where tbl1_Appointments.id = tbl1_AppointmentHistory.AppointmentID
   many to one with `tbl1_People` where tbl1_People.PersonID = tbl1_AppointmentHistory.appt_PersonID



Columns
=======


**ID** ``int(11) NOT NULL``

   :Options:

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


**AppointmentID** ``int(11) DEFAULT NULL``

   :Description:

      relates to the id field in `tbl1_Appointments`. What appointment does this history apply to?

   :Options:

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


**start_date** ``datetime DEFAULT NULL``

   :Description:

      start date of this particular person's appointment

   :Footnote:

      Appointment history can be specified in terms of a start/end date AND/OR a start/end semester & year pair (see following fields)

   :Options:

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


**end_date** ``datetime DEFAULT NULL``

   :Description:

      end date of this particular person's appointment

   :Options:

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


**start_term** ``varchar(25) DEFAULT NULL``

   :Description:

      start semester of this particular person's appointment (Fall or Spring)

   :Options:

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


**start_year** ``smallint(6) DEFAULT NULL``

   :Description:

      start year of this particular person's appointment (Fall or Spring)

   :Options:

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


**end_term** ``varchar(25) DEFAULT NULL``

   :Description:

      end semester of this particular person's appointment (Fall or Spring)

   :Options:

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


**end_year** ``smallint(6) DEFAULT NULL``

   :Description:

      end year of this particular person's appointment

   :Options:

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


**appt_PersonID** ``int(11) DEFAULT NULL``

   :Description:

      id of person holding the appointment. Many-to-one relation with PersonID field in `tbl1_People`

   :Options:

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


**appt_Notes** ``mediumtext DEFAULT NULL``

   :Description:

      notes about this appointment history

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