Unique time range or database schema for a scheduling system I'm having to design a table which contains scheduled times for media to be displayed. These scheduled times should not overlap.

In my SheduledSlot table I have:

id    integer PRIMARY KEY
begin datetime(or integer for SQLite)
end   datetime(or integer for SQLite unixtime)
media_item integer (foreign key)


How do I enforce a constraint which ensures a unique time range for each scheduled item?
You should implement this on the database side in the method that can be called by your create schedule time and modify schedule time methods.