Home › Forums › Other › Inserting data into two tables on user sign up › Reply To: Inserting data into two tables on user sign up
February 28, 2014 at 4:10 am
#164349
Participant
@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?