I'm trying to understand the database model of lime surveys but I'm confused about how data is stored for each type of question as well as how I can create a custom type of question.

I was hoping someone could walk me though what happens in the database when a question is created for the following scenarios all dealing with the same survey(what tables are affected and how?):

user creates an open text question (1st question to be displayed and answers randomized)

user create a single choice question with 4 answers (2nd question displayed)

user creates a checkbox question with 3 answers (3rd question to display; text box for third answer)

user creates a ranking question with 5 answers to rank

Thanks.