Database for reservation system

[meigwil]

Hi,

I'm building a reservation system for a client, and need advice on the best way to set up the db.

I've got three ideas, but I'm not sure which one I should go for. Simply, the system is for more than one accommodation, and users should be able to choose an arrival date and a leaving date.

So, which one would be best?

Store the arrival and leaving date

accom_id :: client_id :: checkin_date :: checkout_date

Store the arrival date and the number of nights

accom_id :: client_id :: checkin_date :: number_of_nights

Store each night in a single record

accom_id :: client_id :: reserved_date

I'd appreciate your thoughts on this.

Best,

Mei

[LordShryku]

One of the first two would be better, if only to cut down on unnecessary records. I'd probably store checkin and checkout dates. You can always do date math later on to get the number of days, if needed.