Re: table desin question

2015-08-12 Thread Johan De Meersman
- 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

table desin question

2015-08-12 Thread Richard Reina
I am ceating a database application with two different types of users, clients and technicians. Both types of users have to create and account in which they become users. From there they can become clients or technicians or perhaps even both. Since each type describe different attributes -- user

Re: table desin question

2015-08-12 Thread hsv
On 2015/08/12 09:42, Johan De Meersman wrote: - Original Message - From: Richard Reinagatorre...@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