I have these two tables set up by a previous programmer and would like to knwo what the benefit of having the data split up like this is:
person;
+----------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| login | varchar(50)| YES | | NULL | |
| email | varchar(50)| | | | |
| tmp_pass | varchar(50)| YES | | NULL | |
| pass | varchar(50)| YES | | NULL | |
| confirm | tinyint(1) | | | 0 | |
+----------+------------+------+-----+---------+----------------+
personDtls;
+-------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| personID | int(11) | | MUL | 0 | |
| firstname | varchar(50)| YES | | NULL | |
| lname | varchar(50)| YES | | NULL | |
| group | int(11) | | | 0 | |
| level | int(11) | | | 0 | |
| active | tinyint(4) | | | 1 | |
+-------------+------------+------+-----+---------+----------------+
What is the benefit to having these details in two different tables?
the person's membership level is in the personDtls table, and it check the user/pass from another so I cannot see why you would have the two different tables. Is there some sort of db guideline that suggests using the two different tables? I cannot see the benefit.
Thank you
