Reply To: Inserting data into two tables on user sign up

[Josh Johnson]

@traq, @shaneisme Thanks for your responses. Yes, i’m using bcrypt for hashing passwords – don’t worry!

Here is my database table structure:

Designers & Developers (two tables at the moment, but I’m seeing your point)

user_id  | jobtitle | age | experience | bio | speciality

Employers

user_id  | businessname | businesstype | businesswebsite | businessbio |

Users

id | firstname | lastname | email | email_code | email_code | time | password | confirmed | email_code | generated_string | email_code | ip | user_type |

I’m pretty sure user_id needs to be a foreign key in the user table right?