I am designing a database for my application, I got issue in implementing the following logic.
A user may be a Vendor and also a Buyer. I have created a table for USER and created an another table called USERTYPE in that, the type had 'VENDOR' and 'BUYER' but I have to know if a user is both 'vendor' and 'buyer' by using a same email_id (User_id). Any idea or suggestion to implement this logic. Thanks in advance.