public ModuleClusterTable(string schemaName)
: base("CT_MODULE_CLUSTER", schemaName)
{
AddColumn(new BigIntColumn("module_id"));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumns());
AddColumnReferenceCheck(new ModuleIdReferenceCheck());
AddColumnReferenceCheck(new ResourceIdReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public BookingRequirementTable(string schemaName)
: base("CT_BOOKING_REQUIREMENT", schemaName)
{
AddColumn(new BigIntColumn("booking_id"));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumns());
AddColumn(new Ct7BoolColumn("send_email"));
AddColumnReferenceCheck(new BookingIdReferenceCheck());
AddColumnReferenceCheck(new ResourceIdReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public ModuleFpTable(string schemaName)
: base("CT_MODULE_FP", schemaName)
{
AddColumn(new BigIntColumn("module_id"));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumns());
AddColumn(new FixedCharColumn("fix_pref", 1));
AddColumn(new IntColumn("preference"));
AddColumnReferenceCheck(new ModuleIdReferenceCheck());
AddColumnReferenceCheck(new ResourceIdReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public AuxMarkTable(string schemaName)
: base("CT_AT_AUX_MARK", schemaName)
{
AddColumn(new BigIntColumn("student_id"));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateCustomColumns(2));
AddColumnReferenceCheck(new StudentIdReferenceCheck());
AddColumnReferenceCheck(new ResourceIdReferenceCheck());
AddColumnReferenceCheck(new AuditReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public AuxTimeTable(string schemaName)
: base("CT_AT_AUX_TIME", schemaName)
{
AddColumn(new BigIntColumn("activity_id"));
AddColumn(new BigIntColumn("student_id"));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumnReferenceCheck(new ActivityIdReferenceCheck());
AddColumnReferenceCheck(new StudentIdReferenceCheck());
AddColumnReferenceCheck(new ResourceIdReferenceCheck());
AddColumnReferenceCheck(new AuditReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}