Web lists-archives.com

Re: table desin question




On 2015/08/12 09:42, Johan De Meersman wrote:
----- Original Message -----
>From: "Richard Reina"<gatorreina@xxxxxxxxx>
>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.
If there never are more client or technician records for one user, the autoincrementing PK in the user table is enough, with the referential key enough PK for each other table, too.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql