tbl1_AppointmentHistory¶
- 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=""