对于存储此表单中的数据感到困惑

Question

I have been practising mysql and then I have came across an issue that I can't solve. I am making a large form that will be able to store information from user in the database. I have managed to make and store data from simple form fields like Name, Country, Age, Interest and etc using mysql and php.

I have a table called users in my database which have approximate 15 column for different data like Name, Country, Age etc.

Now I have added this from field to my from and confused about how to store data from this field.

Here is the img of my form ....

Now if I create a column emp_name then how am I going to store 1-4 values for each user with 5 fields each?

Even if I create a different table ex - emp_history then how to store data from this form for each user?

Answer 1

Create two tables

tbl_more_detail ( here you store all for info 1-4)

id (PK)
emp_id
emp_name
emp_country
emp_position
emp_from
emp_to

tbl_emp_detail ( here you give reference to above ids, will have 4 rows with different detail_id)

id(PK)
emp_id
detail_id ( FK Refer to tbl_more_detail.id)

NOTE: to prevent duplicate entry, create UNIQUE KEY INDEX on (emp_id, detail_id)