Re: Relational Integrity

2004-07-20 Thread Singer Wang
developer tool for InterBase, Firebird, MySQL & MS SQL > Server. > Upscene Productions > http://www.upscene.com > > > > > I need so general guidance on relational integrity. > > I'm setting up a reasonably small DB with 30 or so > > tables for a machine

Re: Relational Integrity

2004-07-20 Thread Martijn Tonies
t; I need so general guidance on relational integrity. > I'm setting up a reasonably small DB with 30 or so > tables for a machine control application. Several of > the tables will have referential links to each other > (e.g. a finished part table will link to a master > part type

RE: Relational Integrity

2004-07-19 Thread Lachlan Mulcahy
Integrity Roy, MyISAM tables also support the FULLTEXT index type, which may be useful, whereas InnoDB doesn't. Lachlan -Original Message- From: John McCaskey [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 July 2004 7:50 AM To: Roy Harrell; [EMAIL PROTECTED] Subject: RE: Relational Inte

RE: Relational Integrity

2004-07-19 Thread Lachlan Mulcahy
Roy, MyISAM tables also support the FULLTEXT index type, which may be useful, whereas InnoDB doesn't. Lachlan -Original Message- From: John McCaskey [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 July 2004 7:50 AM To: Roy Harrell; [EMAIL PROTECTED] Subject: RE: Relational Inte

RE: Relational Integrity

2004-07-19 Thread John McCaskey
just icing on the cake. For the application you describe I think you will do fine with either table type. John A. McCaskey -Original Message- From: Roy Harrell [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 2:03 PM To: [EMAIL PROTECTED] Subject: Relational Integrity I need so ge

Relational Integrity

2004-07-19 Thread Roy Harrell
I need so general guidance on relational integrity. I'm setting up a reasonably small DB with 30 or so tables for a machine control application. Several of the tables will have referential links to each other (e.g. a finished part table will link to a master part type table via the produ