.. index::
   instructor_assignments

======================
instructor_assignments
======================

.. default-role:: doc



Columns
=======


**id** ``int(11) NOT NULL AUTO_INCREMENT``

   :Options:

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


**year** ``char(4) NOT NULL``

   :Options:

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


**term** ``char(1) NOT NULL``

   :Options:

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


**lead_index_no** ``char(5) NOT NULL``

   :Options:

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


**unit** ``char(2) DEFAULT NULL``

   :Options:

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


**subject_cd** ``char(3) DEFAULT NULL``

   :Options:

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


**course_no** ``char(3) DEFAULT NULL``

   :Options:

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


**lead_section_no** ``char(2) DEFAULT NULL``

   :Options:

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


**mode_cd** ``char(2) DEFAULT NULL``

   :Options:

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


**role_cd** ``char(2) DEFAULT NULL``

   :Options:

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


**schedule_flag** ``tinyint(1) DEFAULT 1``

   :Options:

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


**eab_flag** ``tinyint(1) DEFAULT 1``

   :Options:

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


**percentage** ``decimal(5,1) DEFAULT 100.0``

   :Options:

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


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

   :Options:

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


**notified** ``date DEFAULT NULL``

   :Options:

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


**accepted** ``date DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**access_notified** ``date DEFAULT NULL``

   :Options:

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


**access_accepted** ``date DEFAULT NULL``

   :Options:

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


**hide_from_css** ``tinyint(1) DEFAULT 0``

   :Options:

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


**hide_from_web** ``tinyint(1) DEFAULT 0``

   :Options:

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


**section_nos** ``varchar(63) DEFAULT NULL``

   :Options:

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


**periods** ``varchar(31) DEFAULT NULL``

   :Options:

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


**hours** ``varchar(31) DEFAULT NULL``

   :Options:

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


**room** ``varchar(31) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**campus** ``varchar(31) DEFAULT NULL``

   :Options:

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


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

   :Options:

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