VDB format in JSON

To view a VDB as JSON, you can click on the VDB edit ⋮ and click Show Source.

Screen Shot 2024-02-09 at 11.31.36 AM.png

Here is another example of what a VDB file looks like in JSON:

{
 "tables":{
 "Address":{
  "desc":"Physical location",
  "columns":[
   {"type":"integer", "name":"Id",     "desc":"Unique identifier"             },
   {"type":"string",  "name":"Street", "desc":""                              },
   {"type":"string",  "name":"City",   "desc":""                              },
   {"type":"string",  "name":"Country","desc":""                              },
   {"type":"string",  "name":"Zip",    "desc":""                              },
   {"type":"string",  "name":"Type",   "desc":"0 means home, 1 means business"}]},
 "Patient":{
  "desc":"Demographics",
  "columns":[
   {"type":"integer", "name":"Id",       "desc":"Unique ID"     ,"key":1},
   {"type":"string",  "name":"FirstName","desc":"Given name"   },
   {"type":"string",  "name":"LastName", "desc":"Family name"  },
   {"type":"datetime","name":"DOB",      "desc":"Date of birth"},
   {"type":"double",  "name":"Height",   "desc":"In cm"        }]}
}}

Note that there are only 4 basic datatypes:

string
integer
double
datetime

There are no datatypes like text, boolean etc.