Does anyone have recommendations for creating a database of questions you have asked?
It occurred to me that I might want to create a database with Access or LibreOffice Base of my questions. I am not new to creating and maintaining databases, but I am far from an expert. Because I don't know what types of queries I might want to run in the future, I am wondering what types of data I should try to capture from the beginning so that I don't end up having to go back and add things later. So far I am leaving space for up to three categories that the question might fit into, the question text, the answer, the date originally asked, and any dates that I have asked the question again. I don't like to do repeats, but I've got a few questions that have come back around over the years.
My goal is to have queries that can pull up questions according to their categories and reports that will essentially compile a full night of random text-based questions that I have asked before. It will help me if I ever need to make something on the fly and the crowd hasn't heard my questions before.