Schema
{
"$schema": "http://json-schema.org/draft-07/schema#",
"$id": "/schema/Api/DataSet/1.0/index.json",
"title": "DataSet",
"x-family": "Api",
"x-version": "1.0",
"x-owner": "zero-api",
"type": "object",
"properties": {
"Id": {
"$ref": "#/$defs/guid"
},
"Properties": {
"type": [
"object",
"null"
],
"additionalProperties": {
"$ref": "#/$defs/object"
}
},
"Name": {
"type": "string"
},
"Source": {
"type": "string"
},
"DataSetType": {
"enum": [
"Relational",
"KeyValue",
"Graph",
"Blockchain"
]
},
"DataSourceDriver": {
"enum": [
"MySql",
"MsSql",
"MongoDb"
]
},
"Columns": {
"type": "array",
"items": {
"type": "object",
"properties": {
"ColumnName": {
"type": "string"
},
"Description": {
"type": [
"string",
"null"
]
},
"DataType": {
"type": "string"
},
"Length": {
"type": "string"
},
"NotNull": {
"type": "boolean"
},
"PrimaryKey": {
"type": "boolean"
},
"DefaultValue": {
"type": [
"string",
"null"
]
},
"OnUpdate": {
"type": [
"string",
"null"
]
}
}
}
},
"Indices": {
"type": "array",
"items": {
"type": "object",
"properties": {
"IndexName": {
"type": "string"
},
"IsUnique": {
"type": "boolean"
},
"IndexColumns": {
"type": "array",
"items": {
"type": "string"
}
}
}
}
},
"ForeignKeys": {
"type": "array",
"items": {
"type": "object",
"properties": {
"ColumnName": {
"type": "string"
},
"ReferencedTable": {
"type": "string"
},
"ReferencedColumn": {
"type": "string"
},
"OnDelete": {
"type": "string"
}
}
}
},
"ApplicationId": {
"type": [
"string",
"null"
],
"format": "uuid"
},
"ConnectionId": {
"type": [
"string",
"null"
],
"format": "uuid"
}
},
"$defs": {
"guid": {
"type": "string",
"format": "uuid"
},
"object": true
},
"x-icon": "<svg viewBox=\"0 0 24 24\" width=\"16\" height=\"16\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"1.7\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><ellipse cx=\"12\" cy=\"5\" rx=\"8\" ry=\"3\"/><path d=\"M4 5v6c0 1.7 3.6 3 8 3s8-1.3 8-3V5\"/><path d=\"M4 11v6c0 1.7 3.6 3 8 3s8-1.3 8-3v-6\"/></svg>",
"x-name": "DataSet",
"x-source-package": "zero-schema"
}