Date: 06/17/06 (MySQL Communtiy)    Keywords: database, sql

I am looking for work in the Atlanta area and I have been taking skills tests for the last two weeks. One of the companies that I went to had this strange(to me) concept of a super id. All their tables in all their databases had an auto incrementing id plus a superId that was unique through the database. They told me to only use the superID to deal with the data. They had some functions that would handle the superID and I just had to pass them SQL. The functions also kept track of date created and date modified for each record. Each table would look something like this:

superID | date_modified | date_created | table_id |~ fields for the table ~|

I get that its easier to use in some ways but they could not really explain the concept to me. Has anyone ever heard of this or done it?

Source: http://community.livejournal.com/mysql/97788.html