I'm clearly new into database implementation and I'm having doubts about my keys.
I have about 5 tables namely: User, Profile, Client, Stylist and also Posts sirs.
I have a certain foreign key named
bioID which is located in Profile, Client and Stylist (It talks about a little of their biography.)
bioID is pointed to the Posts but I have already set
PostID which is to contain regularity/uniformity for the Posts sirs
Is it okay for the
bioID to be just a foreign key for all of the tables?
it is just "Posts" table sir. So the "Users" table contains the usernames and passwords as well as timestamps of when they are created. "Profile" contains a user information such as name, sex, age, occupation and etc. But there are 2 kinds of users so I split them into two tables which are "Client" and "Stylists". The only thing that differs them is the "Stylists" would have a verification column as they need to verify that they are really stylists. "Posts" contains the post they make whenever a client needs a stylist or a stylists is open and available.
Users has "UserID" which is a foreign key to Table Profile. Profile has a foreign key "user_type" used to Table "Client" and "Stylist". and both Client and Stylist table holds a bioID which is a foreign key to Table Bio(so that it will be organized w/ timestamps).