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
  • First Name
  • Full Name
  • Last Name
  • Nickname
  • Sex
  • SSN
  • Username
Export as PDF
  1. Fabricate API and CLI
  2. Using the Fabricate API
  3. Data model
  4. Column attributes

Names and other identifying information

The following generators produce names and other identifying values for an individual.

Fabricate automatically correlates name and gender columns within a table.

For more information about these generators and how they are configured in the application, go to Names and other identifying information in the generator reference.

First Name

Produces a given name, such as John or Mary.

Uses the General column configuration.

Full Name

Produces a full name (given name and family name), such as John Smith and Mary Jones.

Uses the General column configuration.

Last Name

Produces a family name, such as Smith or Jones.

Uses the General column configuration.

Nickname

Produces a common nickname for the person, such as Bobby or Lefty.

Uses the General column configuration.

Sex

Populates a column with either Male or Female.

Uses the General column configuration.

SSN

Populates a column with valid United States Social Security numbers (SSNs).

{ 
  "name": string,
  "data_type": string,
  "generator": "Phone Number",
  // Generator-specific fields
  "include_dash": boolean, // Whether to include dashes
  // End generator-specific fields
  "conditions": [
    {
      "subset_field": string,
      "operator": "is_one_of"|"is_not_one_of"|"is_not_null",
      "subset_value": string
      "weight": integer
    }
  ],
  "default_weight": integer,
  "group_key": string,
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

Username

Populates a column with a username. For example, johndoe.

Uses the General column configuration.

Last updated 5 days ago