We require an individual with strong data modeling skills to represent various classified ad sites (think Craigslist, Kijiji, etc.) in a "generic and unified" manner. By this, we mean we need, for example, a combined table to represent all the locations of the all the classified ad sites. We do not want a locations table for each classified ad sites.

This person also needs to be able to model web forms in a generic way -- with the ability to identify validation rules assigned to them. For example, a required text field with a minimum length requirement of 5 characters and maximum length requirement of 15 characters. We must be able to group these fields (e.g. a series of fields are groups as "credit card details"), assign an order (e.g. 1st, 2nd, etc.) to the groups, assign an order to the fields, etc.

Finally, we need someone who can model events (singular and recurring -- RFC 2445 compliant, like Outlook Calendar or iCal).

There will be other minor requirements, such as simple profile details, etc. More about this in a separate document should you be selected for this job.

Deliverable can be just a plain text representation of the database. SQL statements as needed. No ERD required.