Column configurations (includes PK fields — they are regular columns).
OptionalDescriptionHuman-readable description for the table (emitted as sp_addextendedproperty).
MJ entity display name (e.g., "HubSpot Deal", "YM Member").
OptionalOrganicOptional organic key column tuples (cross-system natural match keys, e.g., [['Email']]).
Each tuple receives a non-unique index (IX_{Schema}_{Table}_OK_{Cols}).
Primary key field name(s) from the source system.
These columns receive a non-unique index (IX_{Schema}_{Table}_PK) and are registered as soft PKs.
Supports composite PKs (multiple fields). Must be a subset of Columns.
Target database schema name (e.g., "hubspot", "ym").
Soft FK relationships to configure.
Source object this table maps from.
Target table name (e.g., "Deal", "Member").
User's customization of a target table to be created.