Skip to content

Instantly share code, notes, and snippets.

@ruchim
Created September 28, 2021 13:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ruchim/d448214506930f0d5678f1f678d78cd3 to your computer and use it in GitHub Desktop.
Save ruchim/d448214506930f0d5678f1f678d78cd3 to your computer and use it in GitHub Desktop.
{
"defaultProfileId": "390e7a85-d47f-4531-b612-165fc977d3bd",
"description": "example data repo dataset",
"name": "example_demo_dataset",
"schema": {
"relationships": [
{
"from": {
"column": "participant_id",
"table": "sample"
},
"name": "participant_sample",
"to": {
"column": "participant_id",
"table": "participant"
}
},
{
"from": {
"column": "participant_id",
"table": "pair"
},
"name": "participant_pair",
"to": {
"column": "participant_id",
"table": "participant"
}
},
{
"from": {
"column": "file",
"table": "sample"
},
"name": "file",
"to": {
"column": "file_id",
"table": "file"
}
},
{
"from": {
"column": "case_sample",
"table": "pair"
},
"name": "case_same",
"to": {
"column": "sample_id",
"table": "sample"
}
},
{
"from": {
"column": "control_sample",
"table": "pair"
},
"name": "control_sample",
"to": {
"column": "sample_id",
"table": "sample"
}
}
],
"tables": [
{
"columns": [
{
"array_of": false,
"datatype": "string",
"name": "participant_id"
},
{
"array_of": false,
"datatype": "string",
"name": "sex"
},
{
"array_of": false,
"datatype": "integer",
"name": "age"
}
],
"name": "participant",
"primaryKey": [
"participant_id"
]
},
{
"columns": [
{
"array_of": false,
"datatype": "string",
"name": "sample_id"
},
{
"array_of": false,
"datatype": "string",
"name": "participant_id"
},
{
"array_of": false,
"datatype": "fileref",
"name": "file"
},
{
"array_of": false,
"datatype": "string",
"name": "type"
}
],
"name": "sample",
"primaryKey": [
"sample_id"
]
},
{
"columns": [
{
"array_of": false,
"datatype": "fileref",
"name": "file_id"
},
{
"array_of": false,
"datatype": "string",
"name": "path"
}
],
"name": "file",
"primaryKey": [
"file_id"
]
},
{
"columns": [
{
"array_of": false,
"datatype": "integer",
"name": "pair_id"
},
{
"array_of": false,
"datatype": "string",
"name": "participant_id"
},
{
"array_of": false,
"datatype": "string",
"name": "case_sample"
},
{
"array_of": false,
"datatype": "string",
"name": "control_sample"
}
],
"name": "pair",
"primaryKey": [
"pair_id"
]
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment