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 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() : base("EXAM") { AddColumn(new BigIntColumn("exam_id", ColumnNullable.False)); AddColumn(new Ct7UniqueNameColumn()); AddColumn(new Ct7NameColumn()); AddColumn(new BigIntColumn("session_id", ColumnNullable.False)); AddColumn(new NotNullStringColumn("session_name")); AddColumn(new IntColumn("duration")); AddColumn(ColumnUtils.CreateEventCatIdAndNameColumns()); AddColumn(ColumnUtils.CreateCustomColumns()); AddColumn(new IntColumn("capacity_req")); AddColumn(ColumnUtils.CreateDeptIdAndNameColumns()); AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns()); AddColumn(new BitColumn("protected")); AddColumn(new BitColumn("suspended")); AddColumn(new IntColumn("grouping_id")); AddColumn(new BitColumn("registers_req", ColumnNullable.True)); AddColumn(new Ct7BoolColumn(ColumnConstants.RegistersReqResolvedColumnName)); AddColumn(new Ct7NotesColumn()); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("exam_id"); }
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 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 EventInstanceTable() : base("EVENT_INSTANCE") { AddColumn(new NotNullStringColumn("event_instance_id", ColumnConstants.StrLenEventInstance)); AddColumn(new BigIntColumn("event_id", ColumnNullable.False)); AddColumn(new BigIntColumn("timetable_id", ColumnNullable.False)); AddColumn(new BigIntColumn("timetable_event_id", ColumnNullable.False)); AddColumn(new IntColumn("timetable_week", ColumnNullable.False)); AddColumn(new IntColumn("timetable_occurrence", ColumnNullable.False)); AddColumn(new StringColumn("event_name", ColumnConstants.StrLenStd)); AddColumn(new IntColumn("day_of_week", ColumnNullable.False)); AddColumn(new DateTimeColumn("start_time", ColumnNullable.False)); AddColumn(new DateTimeColumn("end_time", ColumnNullable.False)); AddColumn(new IntColumn("break_mins")); AddColumn(ColumnUtils.CreateSpanIdAndNameColumns()); AddColumn(ColumnUtils.CreateEventCatIdAndNameColumns()); AddColumn(ColumnUtils.CreateCustomColumns()); AddColumn(new IntColumn("capacity_req")); AddColumn(ColumnUtils.CreateDeptIdAndNameColumns()); AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns()); AddColumn(new BitColumn("global_event")); AddColumn(new BitColumn("protected")); AddColumn(new BitColumn("suspended")); AddColumn(new IntColumn("grouping_id")); AddColumn(new BitColumn("registers_req", ColumnNullable.True)); AddColumn(new BitColumn(ColumnConstants.RegistersReqResolvedColumnName)); AddColumn(new Ct7NotesColumn()); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("event_instance_id"); }
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 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 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 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() : 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 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 StaffCatTable() : base("STAFF_CAT") { AddColumn(new BigIntColumn("staff_cat_id", ColumnNullable.False)); AddColumn(new NotNullStringColumn("name")); AddColumn(new Ct7DescriptionColumn()); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("staff_cat_id"); AddNameIndex(); }
public FixtureTable() : base("FIXTURE") { AddColumn(new BigIntColumn("fixture_id", ColumnNullable.False)); AddColumn(new NotNullStringColumn("name")); AddColumn(new Ct7DescriptionColumn()); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("fixture_id"); AddNameIndex(); }
public LayoutTable() : base("LAYOUT") { AddColumn(new BigIntColumn("room_layout_id", ColumnNullable.False)); AddColumn(new NotNullStringColumn("name")); AddColumn(new Ct7DescriptionColumn()); AddColumn(new BitColumn("complex")); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("room_layout_id"); AddNameIndex(); }
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 SiteTable() : base("SITE") { AddColumn(new BigIntColumn("site_id", ColumnNullable.False)); AddColumn(new NotNullStringColumn("name")); AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames()); AddColumn(new Ct7TelephoneColumn()); AddColumn(new Ct7EmailColumn()); AddColumn(new Ct7WebColumn()); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("site_id"); AddNameIndex(); }
public CourseTable() : base("COURSE") { AddColumn(new BigIntColumn("course_id", ColumnNullable.False)); AddColumn(new NotNullStringColumn("name")); AddColumn(ColumnUtils.CreateDeptIdAndNameColumns()); AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames()); AddColumn(new Ct7WebColumn()); AddColumn(new Ct7NotesColumn()); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("course_id"); AddNameIndex(); }
public EventCatTable() : base("EVENT_CAT") { AddColumn(new BigIntColumn("event_cat_id", ColumnNullable.False)); AddColumn(new NotNullStringColumn("name")); AddColumn(new Ct7DescriptionColumn()); AddColumn(new IntColumn("colour")); AddColumn(new FloatColumn("weighting")); AddColumn(new BitColumn("registers_req", ColumnNullable.True)); AddColumn(new BitColumn(ColumnConstants.RegistersReqResolvedColumnName, ColumnNullable.True)); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("event_cat_id"); }
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 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 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 FacultyTable() : base("FACULTY") { AddColumn(new BigIntColumn("faculty_id", ColumnNullable.False)); AddColumn(new NotNullStringColumn("name")); AddColumn(new IntColumn("colour")); AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames()); AddColumn(new Ct7TelephoneColumn()); AddColumn(new Ct7EmailColumn()); AddColumn(new Ct7WebColumn()); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("faculty_id"); AddNameIndex(); }
public SupervisorTable() : base("SUPERVISOR") { AddColumn(new BigIntColumn("supervisor_id", ColumnNullable.False)); AddColumn(new Ct7NameColumn()); AddColumn(new StringColumn("business_name", ColumnConstants.StrLenStd)); AddColumn(new Ct7TelephoneColumn("mobile")); AddColumn(new Ct7EmailColumn()); AddColumn(new BitColumn("can_send_sms")); AddColumn(new BitColumn("can_send_email")); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("supervisor_id"); AddNameIndex(); }
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 TeamTable() : base("TEAM") { AddColumn(new BigIntColumn("team_id", ColumnNullable.False)); AddColumn(new Ct7UniqueNameColumn()); AddColumn(new Ct7NameColumn()); AddColumn(ColumnUtils.CreateDeptIdAndNameColumns()); AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns()); AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames()); AddColumn(ColumnUtils.CreateCustomColumns()); AddColumn(ColumnUtils.CreateSchedulableColumn()); AddColumn(new Ct7WebColumn()); AddColumn(new Ct7NotesColumn()); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("team_id"); AddUniqueNameIndex(); AddNameIndex(); }
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 BookingTable() : base("BOOKING") { AddColumn(new BigIntColumn("booking_id", ColumnNullable.False)); AddColumn(new NullStringColumn("title")); AddColumn(ColumnUtils.CreateUserIdAndNameColumns()); AddColumn(ColumnUtils.CreateDeptIdAndNameColumns()); AddColumn(new Ct7NotesColumn("search_criteria")); AddColumn(ColumnUtils.CreateEventCatIdAndNameColumns()); AddColumn(new NullStringColumn("requester_name")); AddColumn(new NullStringColumn("requester_email")); AddColumn(new BitColumn("add_me")); AddColumn(new IntColumn("status", ColumnNullable.False)); AddColumn(new Ct7NotesColumn()); AddColumn(new Ct7NotesColumn("audit_notes")); AddColumn(new IntColumn("sb_status")); AddColumn(ColumnUtils.CreateLookupColumns()); AddColumn(ColumnUtils.CreateAuditColumnsWithNames()); AddColumn(ColumnUtils.CreateOriginColumns()); AddPrimaryKey("booking_id"); }