Hi,
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

Users
UserID
UserName
BasicProfileID(FK)

BasicProfile
BasicProfileID(PK)
Other details....

Here i can track the user with their basic profile, but how about detailed profile ?

Profile1
ProfileID1(PK)
other details...

Profile2
ProfileID2(PK)
other details...

Any Ideas?

2. Also When defining primary keys which one is better to use int or bigint?

Thanks in advance...

do a search for supertype/subtype

use INTEGER unless you are sure that your table will have over 4 billion rows