sbecker has a great post with some of the most common domain relational patterns needed for Rails apps. Examples include CRM, e-commerce, roles-based access, mailing lists, surveys, content/blogs, and social networking.