Database design for project management application

Em Andamento Postado Sep 23, 2014 Pago na entrega
Em Andamento Pago na entrega

Need a top notch DBA to help us re-design an existing database to make it more flexible and scalable. Database is in MySQL. Would prefer someone with experience designing EAV (entity-attribute-value) model databases.

the application is a web-based project management tool geared towards the architecture/construction business. there are a lot of details that go into each project. right now, the database is designed where (for example) the project table has hundreds of columns that are strictly defined (like sitevisit1,sitevisit2,sitevisit3, etc)

i want to move it to an EAV model (entity attribute value) so that the users can customize which fields they need for their individual projects

users need to be able to add and remove fields, etc.


right now there are about 200 users, this will grow to 2,000 by next year.

think along the lines of basecamp dot com but specific to construction/architecture fields.

Administração de Bancos de Dados Programação de Banco de Dados MySQL

ID do Projeto: #6496101

Sobre o projeto

29 propostas Projeto remoto Ativo em Sep 26, 2014