When a user Signs up I would like to set his/her type by default. Types are defined in another table which I created.
I created two tables and linked them but now I don’t know how to assign a default type when he/she signs up.
So I have these tables with the following fields
Users:
- Name (text)
- User types (User types)
User types:
-User type (text)
-Description (text)
The table “User types” contains the following rows:
- Observer
- Member
- Investor
- Pending
- etc
to each record, I attached the description.
I want to make all new users by default “Observer” when they sign up. Then they may wish to pass KYC, so they will submit the KYC form and become “Pending”. And then when the manager checks their IDs, he manually changes the status to Member.
Why do I want to have a separate table for types of users? I want to have a page where users. will read descriptions to all types of users and may decide where they wanna go.
So how to automatically set value Observer from table User types when the user signs up?
I assume this will be similar when the user submits KYC form, he/she will change to “Pending”