----- Original Message ----- > From: "Richard Reina" <gatorre...@gmail.com> > Subject: table desin question > > Would this be the best way to design the schema and would it be best to > make the client ID and technician ID the same as the user ID as they relate > to the same person?
Close enough; but I think it would be preferrable to use a unique (autoincrement) PK for all three tables; and use a referential key in client and technician to point at user. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql