FLOW
  • FLOW
  • Getting Started with FLOW
    • Overview
    • The Basics
      • FLOW Concepts
      • Events & Schemas
        • Event Metadata
        • Sample Event
        • Sample Schema
      • Connections
    • Architecture
    • FLOW Schedule
      • Cron Expression
  • Stages
    • Validations
    • Transform
    • Actions
    • Mapper
  • Recipes
  • Scripts
  • Webhooks
  • REST Connector
  • Flow Monitoring
  • Live Monitoring
  • Advanced Topics
    • Post Process
    • Naming Policy
    • Manage Patches
  • Installation
  • FAQ
  • Tutorials
    • Creating a Connection
    • Creating a Flow
    • Creating a Script
    • Creating a Recipe
  • How To
    • OTBI Input
    • CSV File from Amazon S3
  • Changelog
  • Environment Variables
  • Data Security & Privacy
Powered by GitBook
On this page

Was this helpful?

  1. Getting Started with FLOW
  2. The Basics
  3. Events & Schemas

Sample Schema

{
  "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"
  }
}
PreviousSample EventNextConnections

Last updated 5 years ago

Was this helpful?