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