Database and model design for multiple user roles

Rails
1

I would like to create a web application that has two types of users,
producer and consumer.
Both users have three fields in common : username,password and email.
Producer has also the fields address and telephone.
I could make separate models,views,controller and tables for each user
types but this violates DRY. Could Single table inheritance be used and
how?

2

On 25 March 2012 09:52, pavlos kallis [email protected] wrote:

I would like to create a web application that has two types of users,
producer and consumer.
Both users have three fields in common : username,password and email.
Producer has also the fields address and telephone.
I could make separate models,views,controller and tables for each user types
but this violates DRY. Could Single table inheritance be used and how?

I would probably keep it simple and have a users table with all the
fields in (leave the ones you don’t need empty) and use the cancan gem
to give the different types of users different roles.

Colin

3

Interested to know which direction you went in since I’m working on this
issue now.

thanks.