Beispiel #1
0
        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");
        }