There is a website driven by Django where the user logs in and can answer thousands of questions. I want to persistently save whether a given user has answered a given question or not.
My approach so far is for the User table to have thousands of columns in the PostgreSQL database - a column for each question containing 0 if the question hasn't been answered yet and 1 if it has. However, there is a 1,600 column limit in PostgreSQL, which I haven't reached yet, but would reach eventually, so this approach won't do.
What is a viable alternative architecture to persistently save thousands of variables for each user?