We have a common database schema that we use for some tables in our system. Them main reason is that we are running a multi-tenant database so not all of our users require the same fields. However, I do not know what the 'proper' name for this type of schema is.
Here's an example of what one of our tables might look like:
ClientID | SurveyID | AnswerKey | AnswerVal ------------------------------------------- 1 | 1 | Fname | Fred 1 | 1 | Lname | Flintsone 1 | 1 | Email | [email protected] 1 | 2 | Fname | Mickey 1 | 2 | Lname | Mouse 1 | 2 | Phone | 555-3343
We have been calling them 'Vertical tables', but I don't know if this is correct.