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 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() : base("ROOM") { AddColumn(new BigIntColumn("room_id", ColumnNullable.False)); AddColumn(new Ct7UniqueNameColumn()); AddColumn(new Ct7NameColumn()); AddColumn(ColumnUtils.CreateDeptIdAndNameColumns()); AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns()); AddColumn(ColumnUtils.CreateSiteIdAndNameColumns()); AddColumn(new FloatColumn("area")); AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames()); AddColumn(ColumnUtils.CreateCustomColumns()); AddColumn(ColumnUtils.CreateSchedulableColumn()); 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.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("room_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 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 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(); }