We need a DB schema that can handle users, requests, and comments on those request.
Users need to have different roles (e.g. admin, developer, client) and have ownership over their requests and comments. They should need to contain other identifying information (e.g. name, company role).
Requests are basically just a title and description of the request. They have comments attached to them and they can also hold a special link in case someone wants to link the request directly back to a project board task or bug tracker issue. This link is just a simple hyperlink in an eye catching location. Requests can also be upvoted by users. This is not anonymous so a user can track the requests they have upvoted easily.
Comments are just comments attached to requests. We'll allow subcomments and collapsing comment threads so as to not limit conversations on requests.
We need a DB schema that can handle users, requests, and comments on those request. Users need to have different roles (e.g. admin, developer, client) and have ownership over their requests and comments. They should need to contain other identifying information (e.g. name, company role). Requests are basically just a title and description of the request. They have comments attached to them and they can also hold a special link in case someone wants to link the request directly back to a project board task or bug tracker issue. This link is just a simple hyperlink in an eye catching location. Requests can also be upvoted by users. This is not anonymous so a user can track the requests they have upvoted easily. Comments are just comments attached to requests. We'll allow subcomments and collapsing comment threads so as to not limit conversations on requests.