I am desingning a table for tracking profile. Every user have basic profile and based on the type of user their detailed profiles are stored in different tables like profile1,profile2.
Where to refer this?
My Table Structure
Here i can track the user with their basic profile, but how about detailed profile ?
2. Also When defining primary keys which one is better to use int or bigint?