public static TableColumn[] CreateResourceTypeAndIdColumns(ColumnNullable nullable = ColumnNullable.True)
{
return(new TableColumn[]
{
new IntColumn("resource_type", nullable),
new BigIntColumn("resource_id", nullable)
});
}
public static TableColumn[] CreateUserIdAndNameColumns(ColumnNullable nullable = ColumnNullable.True)
{
return(new TableColumn[]
{
new BigIntColumn("user_id", nullable),
new StringColumn("user_name", ColumnConstants.StrLenStd, nullable)
});
}
public static TableColumn[] CreateAuditColumnsWithNames(ColumnNullable nullable = ColumnNullable.True)
{
return(new TableColumn[]
{
new DateTimeColumn("date_change", nullable),
new BigIntColumn("user_id_change", nullable),
new StringColumn("user_name_change", ColumnConstants.StrLenStd, nullable)
});
}
public TableColumn(
string name, SqlDbType sqlDbType, int length = 0, ColumnNullable nullable = ColumnNullable.True, bool identity = false)
{
_name = name;
_sqlDbType = sqlDbType;
_length = length;
_nullable = nullable;
_identity = identity;
}
public static TableColumn[] CreateResourceTypeAndIdColumnsWithName(ColumnNullable nullable)
{
return(new TableColumn[]
{
new IntColumn("resource_type", nullable),
new BigIntColumn("resource_id", nullable),
new Ct7UniqueNameColumn("resource_unique_name"),
new Ct7NameColumn("resource_name")
});
}
public IdColumn(string name, ColumnNullable nullable = ColumnNullable.False, bool identity = false)
: base(name, nullable, identity)
{
}
public DateTimeColumn(string name, ColumnNullable nullable = ColumnNullable.True)
: base(name, SqlDbType.DateTime, 0, nullable)
{
}
public FloatColumn(string name, ColumnNullable nullable = ColumnNullable.True)
: base(name, SqlDbType.Float, 0, nullable)
{
}
public BigIntColumn(string name, ColumnNullable nullable = ColumnNullable.True, bool identity = false)
: base(name, SqlDbType.BigInt, 0, nullable, identity)
{
}
public Ct7NameColumn(string colName = "name", ColumnNullable nullable = ColumnNullable.True)
: base(colName, ColumnConstants.StrLenStd, nullable)
{
}
public BitColumn(string name, ColumnNullable nullable = ColumnNullable.False)
: base(name, SqlDbType.Bit, 0, nullable)
{
}
public CharColumn(string name, int length, ColumnNullable nullable = ColumnNullable.True)
: base(name, SqlDbType.VarChar, length, nullable)
{
}
public GuidColumn(string name, ColumnNullable nullable = ColumnNullable.True)
: base(name, SqlDbType.UniqueIdentifier, 0, nullable)
{
}
public TableColumn()
{
_nullable = ColumnNullable.True;
}