Esempio n. 1
0
        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");
        }