Reservations may not overlap with existing reservations for the same seat. Each reservation type has different use-cases and rules:
assigned An assigned seat. Optionally may have no end date, representing a permanent assignment.
hot An ad-hoc, single-day booking. Must have an end time that is the same calendar day as the start time.
hoteled A reservation booked in advance that can be multi-day. Must have an end time.