Re: [PHP-DB] table relationship

Yes. You have to use the subtype relational design: USER user_id (PK) | | | || | |

Re: [PHP-DB] table relationship

Three tables seems wasteful, and could mean that you have to do three queries when looking for someone. Why not approach it this way. Users table - info on all users, regardless of category Levels table - sets different access levels, e.g. clients, staff, administrators User_levels table -