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