No comment


This table was in a database of a company where I worked some years ago.

ImageI can’t think of any reason someone would create a table like this one, can you?

About these ads

2 thoughts on “No comment

  1. That seems to be the support of a tree (a “forest” actually as you can have multiple root nodes) …. in such a way that a root is a node that reference itself <- ID == ref_id; something like the nested-type comments of a blog; is it??

    If that is the case, ID should be the only PK. Or whatever…
    Well, some gods work in misterious ways!!

  2. A consultant from Mind Tree Inc., had instructed me to design the table this way. As a Tech Lead of an organization have rejected the instruction since it becomes very hard to read and is time consuming during search

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s