forsit
forsit copied to clipboard
Database structure changes
- Rename
uidtouser_id,pidtoproblem_id,time_createdtocreated_at,time_updatedtoupdated_at - Change
scoreandstateto more descriptive names. It is unclear if they refer to difficulty score or similarity score or something else. - It might be a better idea to change
is_deletedtodeleted_atand save the UNIX timestamp when the row is deleted,NULLotherwise. - For all problem IDs, store just the numeric ID and not
erd27and so on. Create a separate table calledplatformsand a corresponding column calledplatform_idin recommendation tables if you want to keep it generic and not Erdős-specific. Same for Erdős handles: use username directly and noterdabhshkdzand so on.