public StaffTable()
: base("STAFF")
{
AddColumn(new BigIntColumn("staff_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new StringColumn("title", ColumnConstants.StrLenStaffStudentTitle));
AddColumn(new Ct7SexColumn());
AddColumn(ColumnUtils.CreateAddressColumns());
AddColumn(ColumnUtils.CreateRoomIdAndNameColumns());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new IntColumn("allowance_week"));
AddColumn(new IntColumn("allowance_total"));
AddColumn(ColumnUtils.CreateTargetColumns());
AddColumn(ColumnUtils.CreateSchedulableColumn());
AddColumn(ColumnUtils.CreateStdTelColumns());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new StringColumn("profile", ColumnConstants.StrLenStd));
AddColumn(ColumnUtils.CreateSpecialNeedsColumns());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("staff_id");
AddUniqueNameIndex();
AddNameIndex();
}
public StudentTable()
: base("STUDENT")
{
AddColumn(new BigIntColumn("student_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new StringColumn("title", ColumnConstants.StrLenStaffStudentTitle));
AddColumn(new Ct7SexColumn());
AddColumn(new DateTimeColumn("dob"));
AddColumn(ColumnUtils.CreateAddressColumns());
AddColumn(ColumnUtils.CreateRoomIdAndNameColumns());
AddColumn(new Ct7AcademicYearColumn());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateStaffIdAndNameColumns());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new StringColumn("card_num", ColumnConstants.StrLenStd));
AddColumn(ColumnUtils.CreateTargetColumns());
AddColumn(ColumnUtils.CreateSchedulableColumn());
AddColumn(ColumnUtils.CreateStdTelColumns());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new StringColumn("profile", ColumnConstants.StrLenStd));
AddColumn(new StringColumn("photo_file", ColumnConstants.StrLenPhotoFile));
AddColumn(ColumnUtils.CreateSpecialNeedsColumns());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("student_id");
AddUniqueNameIndex();
AddNameIndex();
}
public StaffTable(string schemaName)
: base("CT_STAFF", schemaName)
{
AddColumn(new BigIntColumn("staff_id"));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new StringColumn("title", ColumnConstants.StrLenStaffStudentTitle));
AddColumn(new Ct7SexColumn());
AddColumn(ColumnUtils.CreateAddressColumns());
AddColumn(new BigIntColumn("room_id"));
AddColumn(new BigIntColumn("dept_id"));
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new IntColumn("allowance_week"));
AddColumn(new IntColumn("allowance_total"));
AddColumn(ColumnUtils.CreateTargetColumns());
AddColumn(new Ct7SchedulableColumn());
AddColumn(ColumnUtils.CreateStdTelColumns());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new StringColumn("profile", ColumnConstants.StrLenStd));
AddColumn(ColumnUtils.CreateSpecialNeedsColumns());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new RoomIdReferenceCheck());
AddColumnReferenceCheck(new DeptIdReferenceCheck());
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public GroupTable()
: base("GROUP")
{
AddColumn(new BigIntColumn("group_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new Ct7AcademicYearColumn());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames());
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(ColumnUtils.CreateSchedulableColumn());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("group_id");
AddUniqueNameIndex();
AddNameIndex();
}
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 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 StudentTable(string schemaName)
: base("CT_STUDENT", schemaName)
{
AddColumn(new BigIntColumn("student_id"));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new StringColumn("title", ColumnConstants.StrLenStaffStudentTitle));
AddColumn(new Ct7SexColumn());
AddColumn(new DateTimeColumn("dob"));
AddColumn(ColumnUtils.CreateAddressColumns());
AddColumn(new BigIntColumn("room_id"));
AddColumn(new Ct7AcademicYearColumn());
AddColumn(new BigIntColumn("dept_id"));
AddColumn(new BigIntColumn("staff_id"));
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new StringColumn("card_num", ColumnConstants.StrLenStd));
AddColumn(ColumnUtils.CreateTargetColumns());
AddColumn(new Ct7SchedulableColumn());
AddColumn(ColumnUtils.CreateStdTelColumns());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new StringColumn("profile", ColumnConstants.StrLenStd));
AddColumn(new StringColumn("photo_file", ColumnConstants.StrLenPhotoFile));
AddColumn(ColumnUtils.CreateSpecialNeedsColumns());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new RoomIdReferenceCheck());
AddColumnReferenceCheck(new DeptIdReferenceCheck());
AddColumnReferenceCheck(new StaffIdReferenceCheck());
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public ModuleTable()
: base("MODULE")
{
AddColumn(new BigIntColumn("module_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new Ct7AcademicYearColumn());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(ColumnUtils.CreateTargetColumns());
AddColumn(ColumnUtils.CreateSchedulableColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("module_id");
AddUniqueNameIndex();
AddNameIndex();
}