Re: [GENERAL] maintaining referential integrity

2009-06-05 Thread David
On Fri, Jun 5, 2009 at 6:27 PM, Brandon Metcalf wrote: > What would be the best way to maintain referential integrity in the > following situation?   Let's say I have the following table > >  CREATE TABLE workorder ( >      workorder_id INTEGER  NOT NULL, >      part_id      INTEGER  DEFAULT NULL,

Re: [GENERAL] maintaining referential integrity

2009-06-05 Thread Andy Colson
Brandon Metcalf wrote: What would be the best way to maintain referential integrity in the following situation? Let's say I have the following table CREATE TABLE workorder ( workorder_id INTEGER NOT NULL, part_id INTEGER DEFAULT NULL, generic BOOLEAN DEFAULT FA

[GENERAL] maintaining referential integrity

2009-06-05 Thread Brandon Metcalf
What would be the best way to maintain referential integrity in the following situation? Let's say I have the following table CREATE TABLE workorder ( workorder_id INTEGER NOT NULL, part_id INTEGER DEFAULT NULL, generic BOOLEAN DEFAULT FALSE, PRIMARY KEY (