User accounts data
id nome sobrenome pais estado cidade telefone url_perfil
User login data
id email senha prioridade
My questions are:
- How can I bind them to
foreign key
usingstring
? - Is it best to do this with
ID
? Because? (Can there be problems when a user registers his data in a table, and his account has 2id
's different being one per each table, making it difficult to use the foreign key?) - For the use of the foreign key, does%% of the bank have to be
ENGINE
? - What would be the
INNODB
for these tables?
PS: I searched for Join
and other places if there was a "question" that answered my doubts, or at least gave me a light but I did not find it, and because of that I'm opening this