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?