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 UserTable()
: base("TIMETABLE_USER")
{
AddColumn(new BigIntColumn("user_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("name"));
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateStaffIdAndNameColumns());
AddColumn(ColumnUtils.CreateStudentIdAndNameColumns());
AddColumn(new BitColumn("active"));
AddColumn(new Ct7EmailColumn());
AddColumn(new BitColumn("booking_admin"));
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddPrimaryKey("user_id");
}
public ActivityTable()
: base("ACTIVITY")
{
AddColumn(new BigIntColumn("activity_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("event_instance_id", ColumnConstants.StrLenEventInstance));
AddColumn(new BigIntColumn("event_id", ColumnNullable.False));
AddColumn(new IntColumn("timetable_week", ColumnNullable.False));
AddColumn(new DateTimeColumn("start_datetime", ColumnNullable.False));
AddColumn(new DateTimeColumn("end_datetime", ColumnNullable.False));
AddColumn(new BitColumn("closed"));
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateStaffIdAndNameColumns());
AddColumn(new BitColumn("staff_present"));
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("activity_id");
}
