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(); }