Sample DB Schema for EDC/Form Builder App

asked 2021-04-14T21:01:00.453+00:00
moondaddy 1 Reputation point

I'm looking into building a database for an EDC system where the users can dynamically build each screen/form online. These are like simplified "No Code" apps. My understanding is that all fields for all screens will be in one table (vertical rather than horizontal) and the screens and data will be constructed from metadata. Obviously performance will be an issue among other things.

Are there examples db schemas for this type of solution I can look at to see how others handled this?

Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,453 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2021-04-14T21:27:46.31+00:00
    Erland Sommarskog 67,481 Reputation points Microsoft MVP

    My understanding is that all fields for all screens will be in one table (vertical rather than horizontal)

    This sounds like you will end up with what is known as an EAV design, Entity-Attribute-Value.

    Obviously performance will be an issue among other things.

    EAV is generally frowned upon, because far to often it is a cop-out from doing proper data modelling. However, EAV has its place, and I have used it some corners of applications I have worked with. I would not like to make a centrepiece of the design, though. And least of all if performance is of interest.