public ConsolidationDetailTable(
            string tableName,
            string masterTable,
            string schemaName,
            bool includeForeignKeyConstraints = true)
            : base(tableName, schemaName)
        {
            AddColumn(new BigIdColumn(FederationSchema.ConsolidationIdColName, false));
            AddColumn(new BigIdColumn(FederationSchema.MasterIdColName, false));

            AddPrimaryKey(FederationSchema.ConsolidationIdColName, FederationSchema.MasterIdColName);

            // index on ctds_id
            var indexName = string.Concat("IX_", tableName, "_CTDS_ID");

            AddIndex(indexName, true, FederationSchema.MasterIdColName);

            if (includeForeignKeyConstraints)
            {
                var ct = new ConsolidationTable(masterTable, FederationSchema.FederationSchemaName);
                var fk = new ForeignKey(ct);
                fk.AddReference(FederationSchema.ConsolidationIdColName);
                fk.OnDeleteCascade();
                AddForeignKey(fk);
            }
        }