User tables and login details

Hi,
What is the best practice/recommended setup for user details and user login details in the Database when using Wappler? Is it better to have two tables? For example:

Table 1 - {users}: user_id; user_username; user_password; user_createddate
Table 2 - {users_details}: user_id; user_firstname; user_lastname; user_address1; user_address2; user_phone; etc

If we do have two table, how do we make the user_username unique so its not the same for any user?

Thank you.

Community Page
Last updated: