public EquipTable(string schemaName)
: base("CT_EQUIP", schemaName)
{
AddColumn(new BigIntColumn("equip_id"));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new BigIntColumn("dept_id"));
AddColumn(ColumnUtils.CreateStaff1And2Columns());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new IntColumn("booking_interval"));
AddColumn(new Ct7SchedulableColumn());
AddColumn(new FloatColumn("charge"));
AddColumn(new Ct7WebColumn());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new DeptIdReferenceCheck());
AddColumnReferenceCheck(new StaffReferenceCheck(1));
AddColumnReferenceCheck(new StaffReferenceCheck(2));
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public GroupTable(string schemaName)
: base("CT_GROUP", schemaName)
{
AddColumn(new BigIntColumn("group_id"));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new Ct7AcademicYearColumn());
AddColumn(new BigIntColumn("dept_id"));
AddColumn(ColumnUtils.CreateStaff1And2Columns());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(ColumnUtils.CreateTargetColumns());
AddColumn(new IntColumn("target_size"));
AddColumn(new IntColumn("group_size"));
AddColumn(new IntColumn("additional"));
AddColumn(new IntColumn("split_id"));
AddColumn(new Ct7SchedulableColumn());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new DeptIdReferenceCheck());
AddColumnReferenceCheck(new StaffReferenceCheck(1));
AddColumnReferenceCheck(new StaffReferenceCheck(2));
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public RoomTable(string schemaName)
: base("CT_ROOM", schemaName)
{
AddColumn(new BigIntColumn("room_id"));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new BigIntColumn("dept_id"));
AddColumn(new BigIntColumn("site_id"));
AddColumn(new FloatColumn("area"));
AddColumn(ColumnUtils.CreateStaff1And2Columns());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new Ct7SchedulableColumn());
AddColumn(new IntColumn("default_capacity"));
AddColumn(new FloatColumn("charge"));
AddColumn(new Ct7TelephoneColumn());
AddColumn(new Ct7WebColumn());
AddColumn(ColumnUtils.CreateSpecialNeedsColumns());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new DeptIdReferenceCheck());
AddColumnReferenceCheck(new SiteIdReferenceCheck());
AddColumnReferenceCheck(new StaffReferenceCheck(1));
AddColumnReferenceCheck(new StaffReferenceCheck(2));
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public ModuleTable(string schemaName)
: base("CT_MODULE", schemaName)
{
AddColumn(new BigIntColumn("module_id"));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new Ct7AcademicYearColumn());
AddColumn(new BigIntColumn("dept_id"));
AddColumn(ColumnUtils.CreateStaff1And2Columns());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(ColumnUtils.CreateTargetColumns());
AddColumn(new Ct7SchedulableColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new DeptIdReferenceCheck());
AddColumnReferenceCheck(new StaffReferenceCheck(1));
AddColumnReferenceCheck(new StaffReferenceCheck(2));
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public SiteTable(string schemaName)
: base("CT_SITE", schemaName)
{
AddColumn(new BigIntColumn("site_id"));
AddColumn(new Ct7NameColumn());
AddColumn(ColumnUtils.CreateStaff1And2Columns());
AddColumn(new Ct7TelephoneColumn());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new StaffReferenceCheck(1));
AddColumnReferenceCheck(new StaffReferenceCheck(2));
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public CourseTable(string schemaName)
: base("CT_COURSE", schemaName)
{
AddColumn(new BigIntColumn("course_id"));
AddColumn(new Ct7NameColumn());
AddColumn(new BigIntColumn("dept_id"));
AddColumn(ColumnUtils.CreateStaff1And2Columns());
AddColumn(new Ct7WebColumn());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new DeptIdReferenceCheck());
AddColumnReferenceCheck(new StaffReferenceCheck(1));
AddColumnReferenceCheck(new StaffReferenceCheck(2));
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public DeptTable(string schemaName)
: base("CT_DEPT", schemaName)
{
AddColumn(new BigIntColumn("dept_id"));
AddColumn(new Ct7NameColumn());
AddColumn(new BigIntColumn("faculty_id"));
AddColumn(new IntColumn("colour"));
AddColumn(ColumnUtils.CreateStaff1And2Columns());
AddColumn(new Ct7TelephoneColumn());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new FacultyIdReferenceCheck());
AddColumnReferenceCheck(new StaffReferenceCheck(1));
AddColumnReferenceCheck(new StaffReferenceCheck(2));
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
