Posted by dsdevonsomer on 06/12/07 14:25

To the pros:,
I have one question about designing tables and interface (web/windows
applications). The requirement is like this.
I want to design an application to manage upload / review / manage
files which has some meta data associated with them as well. The files
can be any documents. This application can be used in different
companies same way, but each company wants to use different field
names.

So, I want to design tables generic enough to allow custom labelling
fields. So if I have a table

T1 with ID, FileName, FileSize, FileAuthor.... some company may want
to use different field names. What's the best way to design tables
like this and how to maintain relationships, stored procs, triggers
etc linked to these tables.

Many thanks in advance,
DS

[Back to original message]