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?