What best practice to create a user table?

Asked

Viewed 25 times

2

I’m creating a web system in PHP, and I’m in doubt about how best to create the table that will receive user information (Speed, organization and etc).

Beyond the nome, email and senha, need to store CPF, telefone, data nascimento and endereço.

I store all this information in a single table or create two tables:

  • USUARIO, that will receive the nome, email and senha; and
  • INF-COMPLEMENTARES, to the CPF, telefone, data nascimento and endereço?

1 answer

0

I’ll summarize that and attach some reference materials; let’s go there

In a project for study and practice, having a table for users with their information will speed up their development,

- USUARIOS

In scalable projects (much larger) you will begin to subdivide this

- USUARIOS
- DETALHES_USUARIOS
- LOCALIZAÇÂO
- Emprendimentos

But for a start read about SQL and the php implementation

https://medium.com/@Alexandre.malavasi/25-dicas-e-boas-pr%C3%A1ticas-de-database-for-developers-7a60bfc28f1f

https://webdevacademy.com.br/tutoriais/crud-bootstrap-php-mysql-parte1/

Search for database modeling and its structuring.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.