August 22, 200917 yr Hi, I need to design a database which stores worksheets. A worksheet is basically a table with columns and rows. A user will be able to define their own worksheets with variable number of columns and decide on their own column names. A worksheet has many columns A user has many worksheets I want the database to be relational (I'll be using mysql) and should meet 1NF. So far I have something like: http://pastie.org/591681 I think this is an EAV model. I'd be grateful for any advice or tips. I suspect this problem has already been solved in the DB world so an existing solution would be fine. codecowboy
Create an account or sign in to comment