Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Use IDs or strings?

 
Goto page Previous  1, 2, 3
   Database Help (Home) -> General Discussion RSS
Next:  Must we also create separate tables?  
Author Message
--CELKO--

External


Since: Jan 11, 2008
Posts: 1089



(Msg. 31) Posted: Tue Dec 23, 2008 3:27 pm
Post subject: Re: Use IDs or strings? [Login to view extended thread Info.]
Archived from groups: comp>databases (more info?)

>> How does one handle cars manufactured before VINs came into use? <<

You will be issued a VIN if you want to drive the vehicle on a public
road. If you build your own vehicle, then you inherit the VIN on the
engine block or you get issued one. If the manufacturer went out of
business before 1950, you get a dummy value from a DMV or national
agency. Hey, they want your money.

Here are some more details: http://www.vinguard.org/vin.htm

>> How about books before ISBNs began to be used? Which identification systems are commonly used? <<

Having owned some bookstores in the past, it is much the same scheme.
We used a dummy language sub-code of 99 (97 is Esperanto), a Dewey
Decimal Classification and then a sequence within the DDC.

In retail, if you make a product in-house (bakery in a grocery store),
there are "open codes" in the UPC so you can bar-code the goods.

If you look for it, you will find a standard or two that will help and
give you validation and verification rules.

 >> Stay informed about: Use IDs or strings? 
Back to top
Login to vote
Elmer Fudd

External


Since: Dec 19, 2008
Posts: 2



(Msg. 32) Posted: Wed Dec 24, 2008 12:29 pm
Post subject: Re: Use IDs or strings? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you, great to know!

On Tue, 23 Dec 2008 15:27:34 -0800 (PST), --CELKO-- wrote:

>>> How does one handle cars manufactured before VINs came into use? <<
>
>You will be issued a VIN if you want to drive the vehicle on a public
>road. If you build your own vehicle, then you inherit the VIN on the
>engine block or you get issued one. If the manufacturer went out of
>business before 1950, you get a dummy value from a DMV or national
>agency. Hey, they want your money.
>
> Here are some more details: http://www.vinguard.org/vin.htm
>
>>> How about books before ISBNs began to be used? Which identification systems are commonly used? <<
>
>Having owned some bookstores in the past, it is much the same scheme.
>We used a dummy language sub-code of 99 (97 is Esperanto), a Dewey
>Decimal Classification and then a sequence within the DDC.
>
>In retail, if you make a product in-house (bakery in a grocery store),
>there are "open codes" in the UPC so you can bar-code the goods.
>
>If you look for it, you will find a standard or two that will help and
>give you validation and verification rules.
>

 >> Stay informed about: Use IDs or strings? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Erwin modeling basic question - Hi, Can anyone tell me when doing db design in ERWin, how do you make the table column area longer so more attributes can be shown in the diagram? I thought it'd be as simple as dragging the lower corner of the table, but it didn't work. And I didn't....

number of attributes - Is there a maximum to how many attributes a table should have? I'm implementing a user-based web-application for school. Should I, for example, put all the user characteristics and preferences in one table or should I split it in multiple tables.

History function - G'day, First of all, I'm using PostgreSQL 8.0.1 on a Debian Linux machine. I've got to set up a database which as well features some sort of history function. For example, if there's a table tbl_persons like: id | name | surname | ... there should b...

looking for a tool/ middleware tool which... - Hi all. I'm looking for a tool which should act like some kind of middleware/ logical layer bewtween the SQL server and the webbased user interface. - It should be possible to easily create simple web forms (only data input and output) without..

Designing large databases - Hi, I don't know how to formulate this question, so I try this and see where it ends. I want to create a database that will probably grow very big. How should I do? My database is a Mysql DB and it will store free text where you can search in it. //M
   Database Help (Home) -> General Discussion All times are: Pacific Time (US & Canada)
Goto page Previous  1, 2, 3
Page 3 of 3

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]