Re: Natural keys vs Aritficial Keys
Date: Sat, 16 May 2009 20:49:37 GMT
Message-ID: <f39u055ekvpbln2i4ug8m8nrskdhkjt7cr_at_4ax.com>
paul c <toledobythesea_at_oohay.ac> wrote:
>The so-called 'natural' key for all the airwaybills in a ULD on a
>typical airline flight segment is about seven or eight attributes. When
>the cargo master, at the last minute, offloads a container or two onto
>the tarmac, you don't want a ponderous logic to un-assign it and put it
>on the plane at the next gate. You need a form of indirection, for that
>matter the same is needed in any robotic application such as a freight
>warehouse.
Preumably though there are bar codes on the cargo containers and a simple form where
the cargo master can remove selected containers from the airplane.
A welding shop client that empoyed hundreds of welders built and assembled very
complex piping assemblies for refineries, power plants and oil sands plants. These
are designed to, usually, fit on a 50' flat bed trailer. The client number could be
in excess of 20 or 25 characters. The internal number they used went from 1 to
whatever. It in turn was prefixed with a job number which started at 1 and went to
whatever. The system printed multiple weather proof tag with the internal number as
well as the bar coded long client number.
Tony
-- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Granite Fleet Manager http://www.granitefleet.com/Received on Sat May 16 2009 - 22:49:37 CEST