DataFakery Studio
🏠 Home💬Support
  • What is DataFakery Studio?
    • 🚀What's new in 2025.1
      • Changelog Archive
    • Editions / Licenses
    • Installation requirements
    • Setup guide
    • 👩‍💻Roadmap
  • Guides
    • Creating a DataFakery Project
    • Anonymize Microsoft SQL Server Data Source
    • Anonymize PostgreSQL Database
    • Anonymize MySQL Database
    • Docker Integration
    • Export to CSV File
  • Fundamentals
    • Project
    • Data Sources
    • Data Models
      • Virtual Tables
    • Generators / Fakers
      • Strings
      • Numbers
      • Date & Time
      • Custom Expression
      • Text Pattern
      • Regular expressions
      • Foreign Keys Generator
      • Table Lookups
      • Default Values
      • Sequence Generator
      • Constant Value
      • List Values
    • Randomizer Options
    • Optimizations
    • Data Exploration
  • Extras
    • Data Storage
    • Keyboard Shortcuts
    • Appearance / Theme
  • Support
    • Contact Support
    • Troubleshooting
Powered by GitBook
On this page

Was this helpful?

  1. Fundamentals
  2. Generators / Fakers

Foreign Keys Generator

Uses an existing primary key of a table or virtual table

PreviousRegular expressionsNextTable Lookups

Last updated 11 months ago

Was this helpful?

Faker Configuration

  • Source: Define the source of the foreign key values. In this example:

    • Source Type: Select the type of source (e.g., SQL Table).

    • Table Name: Choose the table from which to fetch the foreign key values (e.g., Person).

    • Value Lookup (Mapping): Select the column used for value lookup and mapping (e.g., FirstName).

  • Add Suffix: Enter any additional suffix to append to the generated data (optional).

  • Replace only if Non-Null: Check this box to ensure that the faker only replaces non-null values in the column. If unchecked, it will replace all values, including nulls.