3
votes
2answers
103 views

Does this situation call for well specified associations, single table inheritance, or polymorphic association?

I'm building a web-app where users can keep track of who owes whom money. I have users and debts. Given a user I want to be able to find out all the debts to other users, and all the loans to other ...
0
votes
2answers
132 views

How to improve database schema with different n:m and 1:n associations between users/tasks/comments/attachments

I'm trying to build a database for an upcoming Ruby on Rails webproject. There will be 4 tables minium: tasks, users, attachments and comments. And 1 table to join the n:m relations (tasks <-> ...
0
votes
1answer
88 views

What is a good design for a container, assignment and items

------------- 1 * -------------- * 1 -------- | Container |--------| Assignment |-----------| User | ------------- -------------- -------- ^ ...
-1
votes
3answers
353 views

Visual Database design Rails [closed]

What techniques, thought processes and tools/apps do you use for setting up a database schema for a rails app? I'm a very visual person so I naturally start with sketching on paper but I was ...