.. index::
   tbl1_Appointments

=================
tbl1_Appointments
=================

.. default-role:: doc

:Description:

   This table holds a list of the department's appointments.  These are the jobs where a person is assigned to the job for a particular amount of time.

:Relation:

   one to many with `tbl1_AppointmentHistory` where tbl1_Appointments.id = tbl1_AppointmentHistory.AppointmentID
   one to one with `tbl1_People` where tbl1_Appointments.appt_PersonID = tbl1_People.PersonID
   one to one with `tbl1_Courses` where tbl1_Appointments.appt_CourseID = tbl1_Courses.Courseid
   one to one with `tbl1_Titles` where tbl1_Appointments.appt_TitleID = tbl1_Titles.ID



Columns
=======


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

   :Options:

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


**appt_name** ``varchar(50) DEFAULT NULL``

   :Description:

      name of appointment, for example "Department Chair" or "251 Course Coordinator"

   :Options:

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


**appt_desc** ``mediumtext DEFAULT NULL``

   :Description:

      Description of appointment

   :Options:

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


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

   :Description:

      id of person currently holding the appointment.
      optional.  can be null if there is no person currently assigned

   :Relation:

      one to one on PersonID in `tbl1_People` table
      can be blank of nobody currently assigned

   :Options:

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


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

   :Description:

      integer corresponding to one of the appointment choices on the appointments table maintenance window within Solutions Databse.

   :Footnote:

      accepted values: 1=Each Semester, 2=Each Year, 3=Every 3 years, 4=Other

   :Options:

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


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

   :Description:

      id of course associated with this course, if relevant

   :Relation:

      one to one on CourseID in `tbl1_Courses` table
      can be blank if no course is directly associated with this assignment

   :Options:

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


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

   :Description:

      id of a title associated with this appointment

   :Relation:

      one to one on ID in `tbl1_Titles` table
      can be blank if no title is directly associated with this assignment

   :Options:

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


**appt_email** ``varchar(75) DEFAULT NULL``

   :Description:

      email specifically associated with this appointment, for example chair@math.rutgers.edu.
      This should not be the appointment holder's email

   :Options:

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


**appt_start_date** ``datetime DEFAULT NULL``

   :Description:

      start date of current appointment holder's term

   :Options:

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


**appt_end_date** ``datetime DEFAULT NULL``

   :Description:

      end date of current appointment holder's term

   :Options:

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


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

   :Description:

      URL if there is a web page specifically associated with this appointment

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