Level 70
@johndoe220 How about this?
plans
- id
- title
consultants
- id
- name
consultant_plan table
- id
- consultant_id
- plan_id
- price
1 like
Feb 20, 2023
1
Level 8
how to create multi plan for consulation in database
Hello, I am implementing a consulting site. Anyone can be a consultant. The challenge I have now faced is that, I have considered three advisory panels for each consultant. (text, video and voice call consultation). The problem I have is that I don't know how to create the tables.
Any consultant can have all three plans or one of these. How should I implement the tables?
This is the idea that came to my mind.
plans table
id - title
details table
id - plan_id - user_id - price - time_call
1- What exactly is your idea for implementing this structure? 2- Are these tables the best method? 3- What is the best way to record these plans in the details table?
If you have a better idea, I welcome it and thank you
Please or to participate in this conversation.