Need to create a user table that stores basic user info and credentials. NOTE: it's a better idea to split into two tables. For example:
id name display_name
id name display_name password_hash student_number create_time update_time
the first table is queried very often, and the smaller the table is, the better. Index could add on id,name and display_name, the second table only need the index on primary key.
But since I don't have too much time, I will just have one table.
Need to create a user table that stores basic user info and credentials. NOTE: it's a better idea to split into two tables. For example:
the first table is queried very often, and the smaller the table is, the better. Index could add on
id
,name
anddisplay_name
, the second table only need the index on primary key.But since I don't have too much time, I will just have one table.