i am hoping that i will be able to store these date-ranges (if you will) all inside one field of my db. something like an array perhaps. see the big conflict here for me, is that i need to allow for an unspecified amount of these arrival-departure periods.
consider the following issue:
i place 5 arrival, 5 departure fields in my db (allowing for up to 5 different arrival/departure periods).
someone who only wants to stay for 2 days, 1 time, no more, signs up.
i will end up with 4 empty fields in that newly created record.
i would really like to stay away from this as null values are typically a sign of a poor db design.
do you have any suggestions on a good way for me to take care of this problem, in light of these concerns?