I want to store on MySQL two kind of information:
1) Information with fields A, B, C, D
2) Information with fields C, D, E, F
Should I create two tables, one for each type of information or should I create only one table that has fields A, B, C, D, E, F and null records depending if the information entered was type 1 or type 2?
Table_info_1
id
field_A
field_B
field_C
field_D
Table_info_2:
id
field_C
field_D
field_E
field_F
or
Table_info_1_and_2:
id
field_A
field_B
field_C
field_D
field_E
field_F
information_type (1 or 2)