Re: [GENERAL] data modeling question

2009-06-28 Thread andy
Brandon Metcalf wrote: I asked a question similar to this a couple of weeks ago, but the requirement has changed a bit and I want to be sure I'm designing my tables correctly. I have the following table: CREATE TABLE workorder ( numberVARCHAR(8), quantity INTEGER, generic

[GENERAL] data modeling question

2009-06-26 Thread Brandon Metcalf
I asked a question similar to this a couple of weeks ago, but the requirement has changed a bit and I want to be sure I'm designing my tables correctly. I have the following table: CREATE TABLE workorder ( numberVARCHAR(8), quantity INTEGER, generic BOOLEAN, PRIMARY KEY