On 8/2/06, DJ Delorie <[EMAIL PROTECTED]> wrote:

> I have been using the following attributes for building BOMs and orders ---
>
>   manufacturer
>   manufacturer_part_number
>   vendor
>   vendor_part_number
>
> all lower case with underscores replacing spaces.

I changed my recommendations to match yours, although I specified
"case insensitive" which lets the web server stick with pretty
capitalized columns when it displays the tables.

You may want to specify lowercase. If someone configures their database for
case sensitive and uses the attribute name as a column name they could get
an error.

You could still treat names as case insensitive for your webserver.

(* jcl *)

P.S. One of the reasons I do not like to add vendor part number
information to the
schematic is that sometimes there is a one-to-many relationship between the
manufacturer/manufacturer_part_number and the vendor/vendor_part_number.

For example ----

A Yageo resistor with part number  RC0805FR-071KL from Digikey
is 311-1.00KCRCT-ND in cut tape and 311-1.00KCRTR-ND in tape and reel.
No change to the Yageo part number to specifiy packaging. Some manufacturers
have a packaging suffix others don't.

--
http://www.luciani.org


_______________________________________________
geda-user mailing list
geda-user@moria.seul.org
http://www.seul.org/cgi-bin/mailman/listinfo/geda-user

Reply via email to