question

moondaddy-3009 avatar image
0 Votes"
moondaddy-3009 asked MelissaMa-msft edited

Sample DB Schema for EDC/Form Builder App

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-generalsql-server-transact-sql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered moondaddy-3009 commented

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.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Then what are the options for a schema that allows for users to build screens on the fly and then add data?

0 Votes 0 ·