Database design structure for CRM

Hey!

I am making a king of crm for Real Estate.

There will be two types of users: Agents and Clients.

This is the design I have in mind:

Table User:

Table Agent:
*ID
*user_ID(Reference field)

Tabler Client
*ID
*user_ID(Reference field)

This looks ok?

How can I do that in the agent user there would be a agent who created the event and other join?

Cheers

Community Page
Last updated: