public TableSchema()
{
this.DatabaseOwner = string.Empty;
this.Name = string.Empty;
this.Columns = new ColumnList();
this.Indexes = new IndexList();
this.ForeignKeys = new ForeignKeyList();
}
public TableSchema(string databaseOwner, string schemaName, ColumnList columns)
{
this.DatabaseOwner = databaseOwner ?? @"";
this.Name = schemaName ?? @"";
this.Columns = new ColumnList();
if (columns != null) this.Columns.InsertRange(0, columns);
this.Indexes = new IndexList();
this.ForeignKeys = new ForeignKeyList();
}
public TableSchema(string schemaName, ColumnList columns, IndexList indexes, ForeignKeyList foreignKeys)
{
this.DatabaseOwner = string.Empty;
this.Name = schemaName ?? @"";
this.Columns = new ColumnList();
if (columns != null) this.Columns.InsertRange(0, columns);
this.Indexes = new IndexList();
if (indexes != null) this.Indexes.InsertRange(0, indexes);
this.ForeignKeys = new ForeignKeyList();
this.ForeignKeys.InsertRange(0, foreignKeys);
}
public ForeignKey AddForeignKey(string name, string referenceSchema = "", string referenceTable = "", string deleteAction = "", string updateAction = "")
{
var item = new ForeignKey(GenDataBase)
{
GenObject = ((GenObject)GenObject).CreateGenObject("ForeignKey"),
Name = name,
ReferenceSchema = referenceSchema,
ReferenceTable = referenceTable,
DeleteAction = deleteAction,
UpdateAction = updateAction
};
ForeignKeyList.Add(item);
return(item);
}
public void AddForeignKey(ForeignKey foreignKey)
{
if (ForeignKeys == null) ForeignKeys = new ForeignKeyList();
if (foreignKey.Name == null)
{
foreignKey.Name = @"FK_";
foreignKey.Name += Name + @"_";
foreignKey.Name += foreignKey.ForeignTable + @"_";
for (int idx = 0; idx < foreignKey.Columns.Length; idx++)
{
if (idx > 0) foreignKey.Name += @"_";
foreignKey.Name += foreignKey.Columns[idx];
}
}
ForeignKeys.Add(foreignKey);
}
