Re: [GENERAL] Database Design for Components and Interconnections

2011-03-20 Thread Andy Colson
On 03/20/2011 09:25 PM, ray joseph wrote: From: Andy Colson [mailto:a...@squeakycode.net] Sent: Sunday, March 20, 2011 8:48 PM Subject: Re: [GENERAL] Database Design for Components and Interconnections You may, or may not, want a top level table: create table chips ( chipid serial

Re: [GENERAL] Database Design for Components and Interconnections

2011-03-20 Thread ray joseph
> From: Andy Colson [mailto:a...@squeakycode.net] > Sent: Sunday, March 20, 2011 8:48 PM > Subject: Re: [GENERAL] Database Design for Components and Interconnections > > >> > >> You may, or may not, want a top level table: > >> > >> create table c

Re: [GENERAL] Database Design for Components and Interconnections

2011-03-20 Thread Andy Colson
You may, or may not, want a top level table: create table chips ( chipid serial, descr text ); Yes, I see great value in a top level component table. I am not sure how to handle multiple instances of the same type of chip in different services. I think the idea is to give eac

Re: [GENERAL] Database Design for Components and Interconnections

2011-03-20 Thread ray joseph
> From: Andy Colson [mailto:a...@squeakycode.net] > Sent: Sunday, March 20, 2011 9:01 AM > > On 03/19/2011 11:40 PM, ray wrote: > > I am looking for some help in database design. I would like to design > > a database to help design alternative designs of a basic electronic > > circuit design.

Re: [GENERAL] Database Design for Components and Interconnections

2011-03-20 Thread ray joseph
two items) David J. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ray Sent: Sunday, March 20, 2011 12:40 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Database Design for Components and Interconnections I am l

Re: [GENERAL] Database Design for Components and Interconnections

2011-03-20 Thread David Johnston
ssage- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ray Sent: Sunday, March 20, 2011 12:40 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Database Design for Components and Interconnections I am looking for some help in database design. I

Re: [GENERAL] Database Design for Components and Interconnections

2011-03-20 Thread Andy Colson
On 03/19/2011 11:40 PM, ray wrote: I am looking for some help in database design. I would like to design a database to help design alternative designs of a basic electronic circuit design. I have a list of components that will be interconnected for a basic design. Additional components and ass

[GENERAL] Database Design for Components and Interconnections

2011-03-19 Thread ray
I am looking for some help in database design. I would like to design a database to help design alternative designs of a basic electronic circuit design. I have a list of components that will be interconnected for a basic design. Additional components and associated connections are identified fo