I have a table with 25 columns (counting the FK) and two groups of users, one will only access 10 columns and the other will access almost all. Because I thought I had many columns in a single table (and think of object orientation as well) I ended up splitting it in two, but I think this only increased complexity.
Then I would like to know:
- 25 columns is too much for a table?
- Thinking about goal orientation, are many attributes for a class? (Large Class?)
- 6 FK is a high number?
- What would be ideal in a situation like this?
Columns:
codigo_projeto
codigo_interno
valor *
nota_fiscal *
data_entrega_relatorio
status
observacao1
observacao2
finalidade
tipo
setor
data_instalacao
data_ultima_avaliacao
data_conclusao
data_conclusao_laudo
concluido
idlocalizacao
idcultura
idalvo
idagrotoxico
You can add a few more fields.