Help with creating a solr schema

[JaredM]

Hi,

I'm new to Solr but so far I think its great.  I've spent 2 weeks reading
through the wiki and mailing list info.

I have a use case and I'm not sure what the best way is to implement it.  I
am keeping track of peoples calendar schedules in a really simple way: each
user can login and input a number of date ranges where they are available
(so for example - User Alice might be available between 1-Jan-2010 -
15-Jan-2010 and 20-Feb-2010 - 22-Feb-2010 and 1-Mar-2010-5-Mar-2010.

In my data model I have this modelled as a one-to-many with a User table
(consisting of username, some metadata) and an Availability table
(consisting of start date and end date).

Now I need to search which users are available between a given date range. 
The bit I'm having trouble with is how to store multiple start & end date
pairs.  Can someone provide some guidance?
-- 
View this message in context: 
http://old.nabble.com/Help-with-creating-a-solr-schema-tp26979319p26979319.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: Help with creating a solr schema

[JaredM]

Thanks Ahmet and Israel.  I prefer Israel's approach since the amount of
metadata for the user is quite high but I'm not clear how to get around one
problem:

If I had 2 availabilities (I've left it in human-readable form instead of as
a UNIX timestamp only for ease of understanding):

10-Jan-2010
20-Jan-2010
25-Jan-2010
28-Jan-2010

and I wanted to query for availability between 12-Jan-2010 to 26-Jan-2010
then then wouldn't the above document be returned (even though the use would
not be available 20-25 Jan?
-- 
View this message in context: 
http://old.nabble.com/Help-with-creating-a-solr-schema-tp26979319p26990178.html
Sent from the Solr - User mailing list archive at Nabble.com.