根据我的理解，我将为所有类别创建一个表格，并在其中存储类别的名称和ID。接下来，我将创建一个单独的表来存储每个类别的其他选项。
MysqL Table 1
----------------
Category_ID int PRIMARY KEY
Category_name varchar
MysqL Table 2
----------------
Category_ID int
Entry_Number int PRIMARY KEY (this will keep track of which entry everything belongs to)
Additional_Option varchar
Additional_Option_Answer varchar (this is the one that stores what your user clicks/inputs)
例如，使用：
POSTER TABLE:
- name
- passw
- tel
- email
你会在这CATEGORY_ID数据是在存储Category_ID和存储name passw telemail到Additional_Option在它自己的行以及用户对这些标准输入将被存储在Additional_Option_Answer。
---------------------------------------------------------------------------------------------
Category_ID | Entry_Number | Additional_Options | Additional_Options_Answers
---------------------------------------------------------------------------------------------
1 | 1 | name | doug
1 | 1 | passw | 1234
---------------------------------------------------------------------------------------------
Category_ID | Entry_Number | Additional_Options | Additional_Options_Answers
---------------------------------------------------------------------------------------------
1 | 2 | name | Hamlet
1 | 2 | passw | iliketurtles
此外，让我们应用另一个类别：
AREA TABLE:
- area
- community
---------------------------------------------------------------------------------------------
Category_ID | Entry_Number | Additional_Options | Additional_Options_Answers
---------------------------------------------------------------------------------------------
2 | 3 | area | San Francisco
2 | 3 | community | community_name
602392714
清零编程群