CodePudding user response:
Is evidently a table has four fields, represent the four kinds of people, another table to store the id and the name of different kinds of people, now interface to access all need access to the table, to display the name, id, the redundant fields, or take a list in the first or the second table in redis, then queries to the results, directly from the slow access for adaptation