0
votes

I am trying to develop database table structure from following JSON Structure. "requiredfields" are straight forward and I table setup for those. However, I am stuck on how to created schema to store "Configuration" and its nested properties in SQL Database. Any help will be appreciated. Thanks.

{
    "requiredFields": [
        "hello",
        "world"
    ],
    "configuration": {
        "hello": {
            "fallbacks": [
                {
                    "type": "constant",
                    "value": "30"
                }
            ]
        },
        "world": {
            "fallbacks": [
                {
                    "type": "fromInputFile",
                    "value": "patientFirstName"
                },
                {
                    "type": "fromInputFile",
                    "value": "subscriberFirstName"
                },
                {
                    "type": "constant",
                    "value": "alpha"
                }
            ]
        }
    }
}