jeudi 3 mars 2016

How to store json array elements to sqlite db

I would to parse the following json and add it to sqlite database.

{
  "group_id": "12",
  "group_name": "ABC Group",
  "employees": [
    {
      "domain_id": "123",
      "from": "abc@gmail.com",
      "to": "def@gmail.com"
    },
    {
      "domain_id": "123",
      "from": "abc@gmail.com",
      "to": "def@gmail.com"
    }
  ]
}

The problem is that I'm not sure how the table design has to be for adding all of those details especially json array values. What is an efficient table design for such a json

Aucun commentaire:

Enregistrer un commentaire