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 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 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 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 ExamTable(string schemaName)
: base("CT_ES_EXAM", schemaName)
{
AddColumn(new BigIntColumn("exam_id"));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new BigIntColumn("session_id"));
AddColumn(new IntColumn("duration"));
AddColumn(new BigIntColumn("event_cat_id"));
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new IntColumn("capacity_req"));
AddColumn(new BigIntColumn("dept_id"));
AddColumn(new Ct7BoolColumn("protected"));
AddColumn(new Ct7BoolColumn("suspended"));
AddColumn(new IntColumn("grouping_id"));
AddColumn(new Ct7BoolColumn("registers_req"));
AddColumn(new Ct7BoolColumn(ColumnConstants.RegistersReqResolvedColumnName));
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new ExamSessionIdReferenceCheck());
AddColumnReferenceCheck(new EventCatIdReferenceCheck());
AddColumnReferenceCheck(new DeptIdReferenceCheck());
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public BookingTable(string schemaName)
: base("CT_BOOKING", schemaName)
{
AddColumn(new BigIntColumn("booking_id"));
AddColumn(new StringColumn("title", ColumnConstants.StrLenStd));
AddColumn(new BigIntColumn("user_id"));
AddColumn(new BigIntColumn("dept_id"));
AddColumn(new Ct7NotesColumn("search_criteria"));
AddColumn(new BigIntColumn("event_cat_id"));
AddColumn(new StringColumn("requester_name", ColumnConstants.StrLenStd));
AddColumn(new StringColumn("requester_email", ColumnConstants.StrLenStd));
AddColumn(new Ct7BoolColumn("add_me"));
AddColumn(new IntColumn("status"));
AddColumn(new Ct7NotesColumn());
AddColumn(new Ct7NotesColumn("audit_notes"));
AddColumn(new IntColumn("sb_status"));
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new ColumnReferenceCheck("CT_USER", "user_id"));
AddColumnReferenceCheck(new DeptIdReferenceCheck());
AddColumnReferenceCheck(new EventCatIdReferenceCheck());
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
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 StaffCatTable(string schemaName)
: base("CT_STAFF_CAT", schemaName)
{
AddColumn(new BigIntColumn("staff_cat_id"));
AddColumn(new Ct7NameColumn());
AddColumn(new Ct7DescriptionColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public FixtureTable(string schemaName)
: base("CT_FIXTURE", schemaName)
{
AddColumn(new BigIntColumn("fixture_id"));
AddColumn(new Ct7NameColumn());
AddColumn(new Ct7DescriptionColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
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();
}
public AttendTimeTable(string schemaName)
: base("CT_AT_ATTEND_TIME", schemaName)
{
AddColumn(new BigIntColumn("attend_time_id"));
AddColumn(new BigIntColumn("activity_id"));
AddColumn(new BigIntColumn("student_id"));
AddColumn(new DateTimeColumn("in_time"));
AddColumn(new DateTimeColumn("out_time"));
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumnReferenceCheck(new ActivityIdReferenceCheck());
AddColumnReferenceCheck(new StudentIdReferenceCheck());
AddColumnReferenceCheck(new AuditReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public WeekSchemeTable(string schemaName)
: base("CT_WEEK_SCHEME", schemaName)
{
AddColumn(new BigIntColumn("week_scheme_id"));
AddColumn(new Ct7NameColumn());
for (int n = 0; n < StagingSchema.MaxWeeksInTimetable; ++n)
{
string colName = string.Concat("week_number", n + 1);
AddColumn(new StringColumn(colName, ColumnConstants.StrLenStd));
}
AddColumn(ColumnUtils.CreateAuditColumns());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public LayoutTable(string schemaName)
: base("CT_LAYOUT", schemaName)
{
AddColumn(new BigIntColumn("room_layout_id"));
AddColumn(new Ct7NameColumn());
AddColumn(new Ct7DescriptionColumn());
AddColumn(new Ct7BoolColumn("complex"));
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public NotificationTable(string schemaName)
: base("CT_AT_NOTIFICATION", schemaName)
{
AddColumn(new BigIntColumn("message_id"));
AddColumn(new BigIntColumn("student_id"));
AddColumn(new BigIntColumn("activity_id"));
AddColumn(new StringColumn("msg_text", ColumnConstants.StrLenDescription));
AddColumn(new Ct7BoolColumn("sent"));
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumnReferenceCheck(new StudentIdReferenceCheck());
AddColumnReferenceCheck(new ActivityIdReferenceCheck());
AddColumnReferenceCheck(new AuditReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public AttendTable(string schemaName)
: base("CT_AT_ATTEND", schemaName)
{
AddColumn(new BigIntColumn("attend_id"));
AddColumn(new BigIntColumn("activity_id"));
AddColumn(new BigIntColumn("student_id"));
AddColumn(new BigIntColumn("mark_id"));
AddColumn(new IntColumn("mins_late"));
AddColumn(new StringColumn("comments", ColumnConstants.StrLenComments));
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumnReferenceCheck(new ActivityIdReferenceCheck());
AddColumnReferenceCheck(new StudentIdReferenceCheck());
AddColumnReferenceCheck(new MarkIdReferenceCheck());
AddColumnReferenceCheck(new AuditReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public EventCatTable(string schemaName)
: base("CT_EVENT_CAT", schemaName)
{
AddColumn(new BigIntColumn("event_cat_id"));
AddColumn(new Ct7NameColumn());
AddColumn(new Ct7DescriptionColumn());
AddColumn(new IntColumn("colour"));
AddColumn(new FloatColumn("weighting"));
AddColumn(new Ct7BoolColumn("registers_req"));
AddColumn(new Ct7BoolColumn(ColumnConstants.RegistersReqResolvedColumnName));
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public SupervisorTable(string schemaName)
: base("CT_SUPERVISOR", schemaName)
{
AddColumn(new BigIntColumn("supervisor_id"));
AddColumn(new Ct7NameColumn());
AddColumn(new StringColumn("business_name", ColumnConstants.StrLenStd));
AddColumn(new Ct7TelephoneColumn("mobile"));
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7BoolColumn("can_send_sms"));
AddColumn(new Ct7BoolColumn("can_send_email"));
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new AuditReferenceCheck());
AddColumnReferenceCheck(new OriginReferenceCheck());
RegisterFederatedIdCols();
RegisterConsolidatedIdCols();
}
public RegisterMarkTable(string schemaName)
: base(StagingTablesBuilder.PseudoRegisterMarkTable, schemaName)
{
AddColumn(new BigIntColumn("student_id"));
AddColumn(new BigIntColumn("event_id"));
AddColumn(new IntColumn("week"));
AddColumn(new BigIntColumn("mark_id"));
AddColumn(new IntColumn("mins_late"));
AddColumn(new StringColumn("comments", ColumnConstants.StrLenComments));
AddColumn(new FixedCharColumn("source", 1));
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumnReferenceCheck(new StudentIdReferenceCheck());
AddColumnReferenceCheck(new EventIdReferenceCheck());
AddColumnReferenceCheck(new MarkIdReferenceCheck());
AddColumnReferenceCheck(new AuditReferenceCheck());
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 UserTable(string schemaName)
: base("CT_USER", schemaName)
{
AddColumn(new BigIntColumn("user_id"));
AddColumn(new Ct7NameColumn());
AddColumn(new BigIntColumn("dept_id"));
AddColumn(new BigIntColumn("staff_id"));
AddColumn(new BigIntColumn("student_id"));
AddColumn(new Ct7BoolColumn("active"));
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7BoolColumn("booking_admin"));
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumnReferenceCheck(new DeptIdReferenceCheck());
AddColumnReferenceCheck(new StaffIdReferenceCheck());
AddColumnReferenceCheck(new StudentIdReferenceCheck());
AddColumnReferenceCheck(new AuditReferenceCheck());
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 ActivityTable(string schemaName)
: base("CT_AT_ACTIVITY", schemaName)
{
AddColumn(new BigIntColumn("activity_id"));
AddColumn(new BigIntColumn("event_id"));
AddColumn(new IntColumn("week"));
AddColumn(new DateTimeColumn("start_datetime"));
AddColumn(new DateTimeColumn("end_datetime"));
AddColumn(new Ct7BoolColumn("closed"));
AddColumn(new Ct7NotesColumn());
AddColumn(new BigIntColumn("staff_id"));
AddColumn(new Ct7BoolColumn("staff_present"));
AddColumn(ColumnUtils.CreateAuditColumns());
AddColumn(ColumnUtils.CreateOriginColumns());
AddColumnReferenceCheck(new EventIdReferenceCheck());
AddColumnReferenceCheck(new StaffIdReferenceCheck());
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();
}
