public BookingRequirementTable()
: base("BOOKING_REQUIREMENT")
{
AddColumn(new BigIntColumn("booking_id", ColumnNullable.False));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumnsWithName(ColumnNullable.False));
AddColumn(new BitColumn("send_email", ColumnNullable.True));
AddPrimaryKey("booking_id", "resource_type", "resource_id");
}
public ModuleClusterTable()
: base("MODULE_CLUSTER")
{
AddColumn(new BigIntColumn("module_id", ColumnNullable.False));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumnsWithName(ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn("module_unique_name"));
AddColumn(new Ct7NameColumn("module_name"));
AddPrimaryKey("module_id", "resource_type", "resource_id");
}
public ModuleFpTable()
: base("MODULE_FP")
{
AddColumn(new BigIntColumn("module_id", ColumnNullable.False));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumnsWithName(ColumnNullable.False));
AddColumn(new FixedCharColumn("fix_pref", 1, ColumnNullable.False));
AddColumn(new IntColumn("preference"));
AddColumn(new Ct7UniqueNameColumn("module_unique_name"));
AddColumn(new Ct7NameColumn("module_name"));
AddPrimaryKey("module_id", "resource_type", "resource_id", "fix_pref");
}
public AuxMarkTable()
: base("AUX_MARK")
{
AddColumn(new BigIntColumn("student_id", ColumnNullable.False));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumnsWithName(ColumnNullable.False));
AddColumn(ColumnUtils.CreateAuditColumnsWithNames(ColumnNullable.False));
AddColumn(ColumnUtils.CreateCustomColumns(2));
AddColumn(new Ct7UniqueNameColumn("student_unique_name"));
AddColumn(new Ct7NameColumn("student_name"));
AddPrimaryKey("student_id", "resource_type", "resource_id", "date_change");
}
public AuxTimeTable()
: base("AUX_TIME")
{
AddColumn(new BigIntColumn("activity_id", ColumnNullable.False));
AddColumn(new BigIntColumn("student_id", ColumnNullable.False));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumnsWithName(ColumnNullable.False));
AddColumn(ColumnUtils.CreateAuditColumnsWithNames(ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn("student_unique_name"));
AddColumn(new Ct7NameColumn("student_name"));
AddPrimaryKey("activity_id", "student_id", "resource_type", "resource_id");
}
