The Database Design Resource Center

Ranges of Ids


In the company I am working for my boss refuses to believe surrogate keys shouldn't be a range of numbers for different objects.

I.e. 4000-4999 for cars, 5000-5999 for employees, 6000-6999 for projects.

He insists that it is "useful" to have the leading number the same for all objects to see quickly what the object is. The funny thing is he refuses to change his mind even though they've had to extend the range of numbers for all objects in the last year as they ran out. But it's okay, we now have "enough for 20 years". Well at least management know exactly how the company and industry will grow...

Comments for Ranges of Ids

Average Rating starstarstarstarstar

Click here to add your own comments

Sep 02, 2015
Ranges of Ids NEW
by: Anonymous

I found your blog using msn. This is an extremely well written article. I’ll make sure to bookmark it and come back to read more of your useful info. Thanks for the post. I will definitely return.
New York Bus Charter

Aug 25, 2015
Delmar NEW
by: Anonymous

Yes, surrogate keys are useful in managing the

Jun 23, 2015
Good post NEW
by: Coy Kunze

Hi! First of all, thanks for your site! You have really great articles! May I ask to do a favor for me, please?
I would like to advertise my new project Safes4gun on your site, I really love your content and articles and will pay you the amount you want.
I prefer banner ads, but if you could suggest other ways I will gladly review it, please, answer me!

Thank you!

May 19, 2015
Guiding info NEW
by: Stormy

Not every country has the power to facilitate their generation with advance technologies of the educational system, so they should start from the low towards the high but if they are spending their money on other things it’s just waste. Getting good materials in writing you should visit our and improve your assignments work.

Nov 25, 2009
Run numbers run
by: Anonymous

"He insists that it is "useful" to have the leading number the same for all objects to see quickly what the object is."

This is true in one way, that an object is a "car", but subject to problems when 5000+ need to be searched. Problem, none of the running numbers with the same start number, not one says anything about a specific object. What is needed is a system of numbers that id specific objects with that same start number. I did this with a security cctv system, no db, but the programming worked. Someone looking at a monitor, is able to know the specific camera, being cameras are grouped in tours, so they will also know a given tour the camera is in as well. I idea is simple if one can get their head around KISS !.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Worst Database Design Experience.

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:

What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Database Normalization eBook:

Database Normalization eBook

Copyright © / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.