Tbl1_TimeConflictChart

Description

Used by summer validator to indicate whether a pair of times indicate a conflict

Footnote

This is a growing table that provides a “conflict chart” of times that summer validator will consider in conflict with each other. When scanning for time conflicts, if a conflict is hit that is not in this table, the user will be asked if the two times are a conflict and will answer Yes or No. The pair of times and their answer will be added to this table for future runs of the program. Future: It might make more sense to obsolete this approach, and instead have the program just convert the text to times and decide whether it is a conflict without use of this table. However, it was done this way for a few reasons. Off top of my head (i) the date ranges came in from IMS in inconsistent sorts of ways so it was easier at the time to just build this table instead of having code to parse and interpret each date, and (ii) in the future possible directions of Summer Validator, we could theoretically expand the decision of what is a conflict to consider the campus and location of each class. For example, in current program operations, a start time where class #2 starts 10 minutes after end time of class #1 would not be considered a conflict; however, if we expand this table to work in the locations, we could consider it a conflict of student would need to get from Busch Campus to Collect Avenue campus (and we could even take into consideration time of day and traffic).

Columns

id int(11) NOT NULL AUTO_INCREMENT

Options

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

Time1 varchar(255) DEFAULT NULL

Description

Time range of class #1

Options

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

Time2 varchar(255) DEFAULT NULL

Description

Time range of class #2

Options

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

Conflict bit(1) DEFAULT NULL

Description

TRUE if the two times represent a schedule date/time conflict

Options

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

last_change timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

Options

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