Topic: Relationships question (?)
Im currently taking a Senior Design Course at my college. We are developing an online document editor prototype with Rails.
I am not well-versed in Rails. As a matter of fact, we chose it for the project in order to learn it.
The problem we have is the following:
We have a User model (id, username, password, email) and we have a Document model (id, name, content, owner_id). A document can have many users, because we are implementing a collaboration feature, but only one owner. The owner will have administrative rights over the document (add collaborators, delete, etc). Users will only be able to edit the document.
The thing is, we need a documents_users table to handle the many-to-many relationship. We do not know how to handle the owner, though, because in essence the owner is also a user.
Do we need to implement an Owner model? Or can Rails handle two different types of relationships between a couple of models?
In any case, should we still call the field for the owner in the document table 'owner_id'?
Thanks in advance,