So if we want to store first name, last name, we should create an associated profiles table right?

That is the most flexible way as it allows access as desired for joining, updating with standard database calls. You could store that in user meta data in the auth.users table, but then it is harder to use.

Gotcha, thanks!