LogoLogo
Release notesDocs homeFabricateTonic.ai
  • Tonic Fabricate User Guide
  • Fabricate workflow
  • Tutorial videos
  • Fabricate account
    • Getting started with Fabricate
    • Fabricate license plans
    • Managing your Fabricate account and profile
    • Managing users in your account
  • Databases
    • Supported database types
    • Creating and managing databases
  • Backing up and restoring the database definition
  • Configuring database variables
  • Exporting data from a database
  • Tables and columns
    • Managing database tables
      • Configuring table settings
      • Adding a table to a database
      • Removing a table from a database
      • Attaching static data to a table
      • Regenerating table data
  • Managing table columns
    • Adding and removing columns
    • Configuring a column
    • Generator reference
      • Calculated or related values
      • Unstructured Data
      • Data type and specific values
      • Names and other identifying information
      • Telephone numbers and email addresses
      • Geographic locations
      • Air travel
      • Natural science
      • Networks and files
      • Banking and finance
      • Dates and times
      • Vehicles
      • Companies and products
      • Healthcare and health insurance
      • Languages
      • Movies
      • Education
    • Fabricate custom SQLite functions
  • Views
    • Creating and managing views
    • Views reference
  • Workspaces
    • About workspaces
  • Creating and managing workspaces
  • Database mock API
    • About mock APIs
    • Defining a mock API
    • Creating and querying database snapshots
  • Mock API reference
  • Fabricate API and CLI
    • Managing Fabricate API keys
    • Daily limits on generated data
    • Using the Fabricate API
      • Authentication for the API
      • Data model
        • Database attributes
        • Entity (table) attributes
        • Constraint attributes
        • Column attributes
          • General column configuration
          • Calculated or related values
          • Unstructured Data
          • Data type and specific values
          • Names and other identifying information
          • Telephone numbers and email addresses
          • Geographic locations
          • Air travel
          • Natural science
          • Networks and files
          • Banking and finance
          • Dates and times
          • Vehicles
          • Companies and products
          • Healthcare and health insurance
          • Languages
          • Movies
          • Education
      • Managing databases from the API
      • Generating data from the API
    • Using the Fabricate CLI
      • Setting up CLI access
      • Using the CLI to load data
  • Self-hosted Fabricate
    • Fabricate architecture
    • Setting up the Fabricate components
    • Limiting login attempts
    • Starting a Fabricate instance
    • Upgrading a Fabricate instance
Powered by GitBook
On this page
Export as PDF
  1. Fabricate API and CLI
  2. Using the Fabricate API
  3. Data model
  4. Column attributes

General column configuration

The following general column configuration properties apply to most generators.

For information on about the general properties and how they are set in the application, go to Configuring a column.

{
  "name": string, // Name of the column.
  "data_type": string,  // Data type of the column values.
  "generator": string, // The name of the generator.
  "conditions": [  // Weighted distribution configuration.
                   // Available for a smaller set of generators
    {
      "subset_field": string, // Field for the weight condition
      "operator": "is_one_of"|"is_not_one_of"|"is_not_null",
                  // Comparison operator for the weight condition
      "subset_value": string  // Comparison value for the weight condition
      "weight": integer // The weight value
    }
  ],
  "default_weight": integer // Default weight if conditions aren't met
  "group_key": string,  // Group key to link related columns.
  "percent_null": integer,  // Percent of records to be null.
  "virtual": boolean,  // Whether to exclude the column from exported data.
  // Advanced options
  "primary_key": boolean, //Whether the column is a primary key.
  "index": boolean,  // Whether to index the column.
  "seed": string,  // The seed for random value generation.
                   /// Setting this freezes the column until the seed changes.
  "postprocessing_sql": string, // SQL script to run after data generation.
}

Last updated 5 days ago