OptionalAdditionalAdditional columns injected by the consumer (e.g., integration sync columns). SchemaEngine appends these after the user-defined Columns.
Column definitions (in order).
OptionalDescriptionHuman-readable description for the table.
MJ entity display name (e.g., "User: Project Milestones").
OptionalForeignForeign key relationships (soft or hard).
OptionalOrganicColumn name tuples that form organic keys (cross-system natural match keys,
such as Email or QuickBooks_ID). Each entry is a single- or multi-column tuple
that receives a non-unique index (IX_{Schema}_{Table}_OK_{Cols}).
OptionalPrimaryColumn names that form the database PRIMARY KEY constraint.
Generates CONSTRAINT PK_{TableName} PRIMARY KEY (col1, col2, ...).
Use this for tables that need a real DB-enforced primary key.
Distinct from SoftPrimaryKeys which creates only a UNIQUE constraint.
Target database schema (e.g., "custom", "hubspot", "dbo").
OptionalSoftColumn names that form the soft primary key (UNIQUE constraint only). No DB-level PK is created — the unique constraint serves as the natural key.
SQL table name (e.g., "UD_ProjectMilestones", "HubSpotContacts").
Platform-agnostic table definition — the universal input for DDL generation. Any consumer provides this; SchemaEngine produces platform-correct SQL.