Member Junction
    Preparing search index...

    User's customization of a target table to be created.

    interface TargetTableConfig {
        Columns: TargetColumnConfig[];
        Description?: string;
        EntityName: string;
        PrimaryKeyFields: string[];
        SchemaName: string;
        SoftForeignKeys: SoftFKEntry[];
        SourceObjectName: string;
        TableName: string;
    }
    Index

    Properties

    Column configurations (includes PK fields — they are regular columns).

    Description?: string

    Human-readable description for the table (emitted as sp_addextendedproperty).

    EntityName: string

    MJ entity display name (e.g., "HubSpot Deal", "YM Member").

    PrimaryKeyFields: string[]

    Primary key field name(s) from the source system. These columns get a UNIQUE constraint and are registered as soft PKs. Supports composite PKs (multiple fields). Must be a subset of Columns.

    SchemaName: string

    Target database schema name (e.g., "hubspot", "ym").

    SoftForeignKeys: SoftFKEntry[]

    Soft FK relationships to configure.

    SourceObjectName: string

    Source object this table maps from.

    TableName: string

    Target table name (e.g., "Deal", "Member").