Admin User - Company - Employee Users (Database Structure)

Need help Database
1

I would really appreciate some help. I can’t seem to wrap my mind around my data structure. I am creating an app for Admin users to manage a company that has employee users.
Only admin users can sign up, create a company , and add employee users
Employees users can login and be redirected to their landing page.
A typical example:

Admin User > Username
> photo
>company
company> company name
> company logo
> company address
> employee user(s)
employee user > name
>age
>department
>skills

How do i structure my database AND workflow to achieve the tasks

SO FAR:
My Database

D1
D1781×395 20.2 KB
D2
D2918×421 26.1 KB
D3
D3842×488 27.1 KB

My workflows
Sign the user up and login
1 2
Create a new company and make changes to current users company
3 4
(The user gets signed up and the company is created, but the company is not added to the current user)
I’m wobbled up and don’t know how to fix this . Kindly help. Thanks

1 Like
2

I’m struggling with something similar. Have you found a solution?

3

Yes i did

4

Make changes to the current user then add or Link the previously made company to a field in the user database

User

  • Name
  • Ager
  • Linked Company → List of Companies (Add here)