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);
}
}