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 describes users basic information and login credentials, client describes client information such as billing info and payment method and technician describes technican information such as areas of expertese, experience and qualifications -- would it be best to create three tables and use user ID as the primary key for all?
For example:
TABLE: user | ID | first_name| last_name| email |phone| password |
TABLE Techician |ID | type | years_of_exp | current | zone |
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?
Aug 12
Johan De Meersman Re: table desin question
Aug 12, 2015; 15:42
Johan De Meersman
Re: table desin question
Aug 12
hsv Re: table desin question
Aug 12, 2015; 14:50
hsv
Re: table desin question
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!