| « Prev | Page 1 | Next » |
|
Oh, my god. I nearly hurt myself reading this. You need to add a disclaimer...
|
|
How about adding a column for data type and field length. Come to think of it there are a lot more attributes you could add too.
Works great as a standardized lookup solution though. I can't tell you how many times I have been annoyed by a database with a handful of core tables and about 50 lookups. All of them named pairs. |
|
This #@$! nightmare is so bad it has a name --EAV (entity, attribute, value) design.
|
|
this is the most creative table design i have come across
|
|
Of course, call me crazy, but couldn't you use systables and syscolumns?
I'm no BrainBench (tm) expert, but it just seems to me... |
|
This kind of design cannot handle "NOT NULLS" and other restrictions unless you write triggers on each column.
|
|
Hey I have this great idea why dont we create a system that allows us to specify columns and tables and values for those columns. I even came up with a great name for it. I'll call it a database. And the best part is we can reimplement this "database" on a database. Then we can do it again. I mean seriously if your going to go through the trouble of doing this, why dont you just keep on going. Why not have a table that is tbl that has the same columns that define it for tblStaffDirectory. I mean you never know when we might want to add another column to tblStaffDirectory.
|
|
I first thought hang on this is just a open schema - apparently this is a real technique. But then I looked at the column names and thought - No
|
|
Whoa. That's like RDF without the tools to deal with RDF.
|
|
We tried this once and ended up reproducing most of the syscolumns table... :)
|
|
protege.stanford.edu uses exactly this strategy.
|
|
Am I just being stupid here, or is this not just the data dictionary combined with the actual data?
metadata and data all in the same pretty little package... yeuch |
|
My former employer's flagship software used a layout startlingly similar to this. It was made by outsourced developers, and now I think it's your fault.
I hate you. |
Re: re: tblStaffDirectory
2010-02-17 20:09
•
by
Christian
(unregistered)
|
|
There's a lot more that's wrong with this design than a simple inability to handle "NOT NULL"s, honey.
|
| « Prev | Page 1 | Next » |
