> For the complete documentation index, see [llms.txt](https://flow-docs.cloudio.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://flow-docs.cloudio.io/getting-started-with-flow/basics/events-and-schemas/sample-schema.md).

# Sample Schema

```javascript
{
  "table": {
    "columns": [
      {
        "columnName": "Id",
        "columnType": "VARCHAR2",
        "isComplexType": false,
        "jdbcType": 0,
        "maxLength": 40,
        "primaryKey": true,
        "required": false,
        "scale": 0
      },
      {
        "columnName": "IsDeleted",
        "columnType": "VARCHAR2",
        "isComplexType": false,
        "jdbcType": 0,
        "maxLength": 5,
        "primaryKey": false,
        "required": false,
        "scale": 0
      },
      {
        "columnName": "Site",
        "columnType": "VARCHAR2",
        "isComplexType": false,
        "jdbcType": 0,
        "maxLength": 240,
        "primaryKey": false,
        "required": false,
        "scale": 0
      },
      {
        "columnName": "CurrencyIsoCode",
        "columnType": "VARCHAR2",
        "isComplexType": false,
        "jdbcType": 0,
        "maxLength": 2000,
        "primaryKey": false,
        "required": false,
        "scale": 0
      },
      {
        "columnName": "OwnerId",
        "columnType": "VARCHAR2",
        "isComplexType": false,
        "jdbcType": 0,
        "maxLength": 40,
        "primaryKey": false,
        "required": false,
        "scale": 0
      },
      {
        "columnName": "CreatedDate",
        "columnType": "DATE",
        "isComplexType": false,
        "jdbcType": 0,
        "maxLength": 0,
        "primaryKey": false,
        "required": false,
        "scale": 0
      },
      {
        "columnName": "CreatedById",
        "columnType": "VARCHAR2",
        "isComplexType": false,
        "jdbcType": 0,
        "maxLength": 40,
        "primaryKey": false,
        "required": false,
        "scale": 0
      },
      {
        "columnName": "LastModifiedDate",
        "columnType": "DATE",
        "isComplexType": false,
        "jdbcType": 0,
        "maxLength": 0,
        "primaryKey": false,
        "required": false,
        "scale": 0
      },
      {
        "columnName": "LastModifiedById",
        "columnType": "VARCHAR2",
        "isComplexType": false,
        "jdbcType": 0,
        "maxLength": 40,
        "primaryKey": false,
        "required": false,
        "scale": 0
      },
      ...
    ],
    "tableName": "Account"
  }
}
```