package com.miniframe.model.system;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class VExtUserSQLBuilder {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public VExtUserSQLBuilder() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUserTypeIsNull() {
            addCriterion("user_type is null");
            return (Criteria) this;
        }

        public Criteria andUserTypeIsNotNull() {
            addCriterion("user_type is not null");
            return (Criteria) this;
        }

        public Criteria andUserTypeEqualTo(String value) {
            addCriterion("user_type =", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeNotEqualTo(String value) {
            addCriterion("user_type <>", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeGreaterThan(String value) {
            addCriterion("user_type >", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeGreaterThanOrEqualTo(String value) {
            addCriterion("user_type >=", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeLessThan(String value) {
            addCriterion("user_type <", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeLessThanOrEqualTo(String value) {
            addCriterion("user_type <=", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeLike(String value) {
            addCriterion("user_type like", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeNotLike(String value) {
            addCriterion("user_type not like", value, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeIn(List<String> values) {
            addCriterion("user_type in", values, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeNotIn(List<String> values) {
            addCriterion("user_type not in", values, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeBetween(String value1, String value2) {
            addCriterion("user_type between", value1, value2, "userType");
            return (Criteria) this;
        }

        public Criteria andUserTypeNotBetween(String value1, String value2) {
            addCriterion("user_type not between", value1, value2, "userType");
            return (Criteria) this;
        }

        public Criteria andOrgcodeIsNull() {
            addCriterion("orgcode is null");
            return (Criteria) this;
        }

        public Criteria andOrgcodeIsNotNull() {
            addCriterion("orgcode is not null");
            return (Criteria) this;
        }

        public Criteria andOrgcodeEqualTo(String value) {
            addCriterion("orgcode =", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotEqualTo(String value) {
            addCriterion("orgcode <>", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeGreaterThan(String value) {
            addCriterion("orgcode >", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeGreaterThanOrEqualTo(String value) {
            addCriterion("orgcode >=", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeLessThan(String value) {
            addCriterion("orgcode <", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeLessThanOrEqualTo(String value) {
            addCriterion("orgcode <=", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeLike(String value) {
            addCriterion("orgcode like", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotLike(String value) {
            addCriterion("orgcode not like", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeIn(List<String> values) {
            addCriterion("orgcode in", values, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotIn(List<String> values) {
            addCriterion("orgcode not in", values, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeBetween(String value1, String value2) {
            addCriterion("orgcode between", value1, value2, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotBetween(String value1, String value2) {
            addCriterion("orgcode not between", value1, value2, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeIsNull() {
            addCriterion("org_dept_code is null");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeIsNotNull() {
            addCriterion("org_dept_code is not null");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeEqualTo(String value) {
            addCriterion("org_dept_code =", value, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeNotEqualTo(String value) {
            addCriterion("org_dept_code <>", value, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeGreaterThan(String value) {
            addCriterion("org_dept_code >", value, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeGreaterThanOrEqualTo(String value) {
            addCriterion("org_dept_code >=", value, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeLessThan(String value) {
            addCriterion("org_dept_code <", value, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeLessThanOrEqualTo(String value) {
            addCriterion("org_dept_code <=", value, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeLike(String value) {
            addCriterion("org_dept_code like", value, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeNotLike(String value) {
            addCriterion("org_dept_code not like", value, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeIn(List<String> values) {
            addCriterion("org_dept_code in", values, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeNotIn(List<String> values) {
            addCriterion("org_dept_code not in", values, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeBetween(String value1, String value2) {
            addCriterion("org_dept_code between", value1, value2, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andOrgDeptCodeNotBetween(String value1, String value2) {
            addCriterion("org_dept_code not between", value1, value2, "orgDeptCode");
            return (Criteria) this;
        }

        public Criteria andUserstateIsNull() {
            addCriterion("userstate is null");
            return (Criteria) this;
        }

        public Criteria andUserstateIsNotNull() {
            addCriterion("userstate is not null");
            return (Criteria) this;
        }

        public Criteria andUserstateEqualTo(String value) {
            addCriterion("userstate =", value, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserstateNotEqualTo(String value) {
            addCriterion("userstate <>", value, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserstateGreaterThan(String value) {
            addCriterion("userstate >", value, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserstateGreaterThanOrEqualTo(String value) {
            addCriterion("userstate >=", value, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserstateLessThan(String value) {
            addCriterion("userstate <", value, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserstateLessThanOrEqualTo(String value) {
            addCriterion("userstate <=", value, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserstateLike(String value) {
            addCriterion("userstate like", value, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserstateNotLike(String value) {
            addCriterion("userstate not like", value, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserstateIn(List<String> values) {
            addCriterion("userstate in", values, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserstateNotIn(List<String> values) {
            addCriterion("userstate not in", values, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserstateBetween(String value1, String value2) {
            addCriterion("userstate between", value1, value2, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserstateNotBetween(String value1, String value2) {
            addCriterion("userstate not between", value1, value2, "userstate");
            return (Criteria) this;
        }

        public Criteria andUserpwdIsNull() {
            addCriterion("userpwd is null");
            return (Criteria) this;
        }

        public Criteria andUserpwdIsNotNull() {
            addCriterion("userpwd is not null");
            return (Criteria) this;
        }

        public Criteria andUserpwdEqualTo(String value) {
            addCriterion("userpwd =", value, "userpwd");
            return (Criteria) this;
        }

        public Criteria andUserpwdNotEqualTo(String value) {
            addCriterion("userpwd <>", value, "userpwd");
            return (Criteria) this;
        }

        public Criteria andUserpwdGreaterThan(String value) {
            addCriterion("userpwd >", value, "userpwd");
            return (Criteria) this;
        }

        public Criteria andUserpwdGreaterThanOrEqualTo(String value) {
            addCriterion("userpwd >=", value, "userpwd");
            return (Criteria) this;
        }

        public Criteria andUserpwdLessThan(String value) {
            addCriterion("userpwd <", value, "userpwd");
            return (Criteria) this;
        }

        public Criteria andUserpwdLessThanOrEqualTo(String value) {
            addCriterion("userpwd <=", value, "userpwd");
            return (Criteria) this;
        }

        public Criteria andUserpwdLike(String value) {
            addCriterion("userpwd like", value, "userpwd");
            return (Criteria) this;
        }

        public Criteria andUserpwdNotLike(String value) {
            addCriterion("userpwd not like", value, "userpwd");
            return (Criteria) this;
        }

        public Criteria andUserpwdIn(List<String> values) {
            addCriterion("userpwd in", values, "userpwd");
            return (Criteria) this;
        }

        public Criteria andUserpwdNotIn(List<String> values) {
            addCriterion("userpwd not in", values, "userpwd");
            return (Criteria) this;
        }

        public Criteria andUserpwdBetween(String value1, String value2) {
            addCriterion("userpwd between", value1, value2, "userpwd");
            return (Criteria) this;
        }

        public Criteria andUserpwdNotBetween(String value1, String value2) {
            addCriterion("userpwd not between", value1, value2, "userpwd");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNull() {
            addCriterion("nickname is null");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNotNull() {
            addCriterion("nickname is not null");
            return (Criteria) this;
        }

        public Criteria andNicknameEqualTo(String value) {
            addCriterion("nickname =", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotEqualTo(String value) {
            addCriterion("nickname <>", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThan(String value) {
            addCriterion("nickname >", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("nickname >=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThan(String value) {
            addCriterion("nickname <", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThanOrEqualTo(String value) {
            addCriterion("nickname <=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLike(String value) {
            addCriterion("nickname like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotLike(String value) {
            addCriterion("nickname not like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameIn(List<String> values) {
            addCriterion("nickname in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotIn(List<String> values) {
            addCriterion("nickname not in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameBetween(String value1, String value2) {
            addCriterion("nickname between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotBetween(String value1, String value2) {
            addCriterion("nickname not between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andUserdnIsNull() {
            addCriterion("userdn is null");
            return (Criteria) this;
        }

        public Criteria andUserdnIsNotNull() {
            addCriterion("userdn is not null");
            return (Criteria) this;
        }

        public Criteria andUserdnEqualTo(String value) {
            addCriterion("userdn =", value, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnNotEqualTo(String value) {
            addCriterion("userdn <>", value, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnGreaterThan(String value) {
            addCriterion("userdn >", value, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnGreaterThanOrEqualTo(String value) {
            addCriterion("userdn >=", value, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnLessThan(String value) {
            addCriterion("userdn <", value, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnLessThanOrEqualTo(String value) {
            addCriterion("userdn <=", value, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnLike(String value) {
            addCriterion("userdn like", value, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnNotLike(String value) {
            addCriterion("userdn not like", value, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnIn(List<String> values) {
            addCriterion("userdn in", values, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnNotIn(List<String> values) {
            addCriterion("userdn not in", values, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnBetween(String value1, String value2) {
            addCriterion("userdn between", value1, value2, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnNotBetween(String value1, String value2) {
            addCriterion("userdn not between", value1, value2, "userdn");
            return (Criteria) this;
        }

        public Criteria andUserdnflagIsNull() {
            addCriterion("userdnflag is null");
            return (Criteria) this;
        }

        public Criteria andUserdnflagIsNotNull() {
            addCriterion("userdnflag is not null");
            return (Criteria) this;
        }

        public Criteria andUserdnflagEqualTo(Integer value) {
            addCriterion("userdnflag =", value, "userdnflag");
            return (Criteria) this;
        }

        public Criteria andUserdnflagNotEqualTo(Integer value) {
            addCriterion("userdnflag <>", value, "userdnflag");
            return (Criteria) this;
        }

        public Criteria andUserdnflagGreaterThan(Integer value) {
            addCriterion("userdnflag >", value, "userdnflag");
            return (Criteria) this;
        }

        public Criteria andUserdnflagGreaterThanOrEqualTo(Integer value) {
            addCriterion("userdnflag >=", value, "userdnflag");
            return (Criteria) this;
        }

        public Criteria andUserdnflagLessThan(Integer value) {
            addCriterion("userdnflag <", value, "userdnflag");
            return (Criteria) this;
        }

        public Criteria andUserdnflagLessThanOrEqualTo(Integer value) {
            addCriterion("userdnflag <=", value, "userdnflag");
            return (Criteria) this;
        }

        public Criteria andUserdnflagIn(List<Integer> values) {
            addCriterion("userdnflag in", values, "userdnflag");
            return (Criteria) this;
        }

        public Criteria andUserdnflagNotIn(List<Integer> values) {
            addCriterion("userdnflag not in", values, "userdnflag");
            return (Criteria) this;
        }

        public Criteria andUserdnflagBetween(Integer value1, Integer value2) {
            addCriterion("userdnflag between", value1, value2, "userdnflag");
            return (Criteria) this;
        }

        public Criteria andUserdnflagNotBetween(Integer value1, Integer value2) {
            addCriterion("userdnflag not between", value1, value2, "userdnflag");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNull() {
            addCriterion("username is null");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNotNull() {
            addCriterion("username is not null");
            return (Criteria) this;
        }

        public Criteria andUsernameEqualTo(String value) {
            addCriterion("username =", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotEqualTo(String value) {
            addCriterion("username <>", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThan(String value) {
            addCriterion("username >", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThanOrEqualTo(String value) {
            addCriterion("username >=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThan(String value) {
            addCriterion("username <", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThanOrEqualTo(String value) {
            addCriterion("username <=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLike(String value) {
            addCriterion("username like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotLike(String value) {
            addCriterion("username not like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameIn(List<String> values) {
            addCriterion("username in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotIn(List<String> values) {
            addCriterion("username not in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameBetween(String value1, String value2) {
            addCriterion("username between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotBetween(String value1, String value2) {
            addCriterion("username not between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andUsersexIsNull() {
            addCriterion("usersex is null");
            return (Criteria) this;
        }

        public Criteria andUsersexIsNotNull() {
            addCriterion("usersex is not null");
            return (Criteria) this;
        }

        public Criteria andUsersexEqualTo(Short value) {
            addCriterion("usersex =", value, "usersex");
            return (Criteria) this;
        }

        public Criteria andUsersexNotEqualTo(Short value) {
            addCriterion("usersex <>", value, "usersex");
            return (Criteria) this;
        }

        public Criteria andUsersexGreaterThan(Short value) {
            addCriterion("usersex >", value, "usersex");
            return (Criteria) this;
        }

        public Criteria andUsersexGreaterThanOrEqualTo(Short value) {
            addCriterion("usersex >=", value, "usersex");
            return (Criteria) this;
        }

        public Criteria andUsersexLessThan(Short value) {
            addCriterion("usersex <", value, "usersex");
            return (Criteria) this;
        }

        public Criteria andUsersexLessThanOrEqualTo(Short value) {
            addCriterion("usersex <=", value, "usersex");
            return (Criteria) this;
        }

        public Criteria andUsersexIn(List<Short> values) {
            addCriterion("usersex in", values, "usersex");
            return (Criteria) this;
        }

        public Criteria andUsersexNotIn(List<Short> values) {
            addCriterion("usersex not in", values, "usersex");
            return (Criteria) this;
        }

        public Criteria andUsersexBetween(Short value1, Short value2) {
            addCriterion("usersex between", value1, value2, "usersex");
            return (Criteria) this;
        }

        public Criteria andUsersexNotBetween(Short value1, Short value2) {
            addCriterion("usersex not between", value1, value2, "usersex");
            return (Criteria) this;
        }

        public Criteria andUseremailIsNull() {
            addCriterion("useremail is null");
            return (Criteria) this;
        }

        public Criteria andUseremailIsNotNull() {
            addCriterion("useremail is not null");
            return (Criteria) this;
        }

        public Criteria andUseremailEqualTo(String value) {
            addCriterion("useremail =", value, "useremail");
            return (Criteria) this;
        }

        public Criteria andUseremailNotEqualTo(String value) {
            addCriterion("useremail <>", value, "useremail");
            return (Criteria) this;
        }

        public Criteria andUseremailGreaterThan(String value) {
            addCriterion("useremail >", value, "useremail");
            return (Criteria) this;
        }

        public Criteria andUseremailGreaterThanOrEqualTo(String value) {
            addCriterion("useremail >=", value, "useremail");
            return (Criteria) this;
        }

        public Criteria andUseremailLessThan(String value) {
            addCriterion("useremail <", value, "useremail");
            return (Criteria) this;
        }

        public Criteria andUseremailLessThanOrEqualTo(String value) {
            addCriterion("useremail <=", value, "useremail");
            return (Criteria) this;
        }

        public Criteria andUseremailLike(String value) {
            addCriterion("useremail like", value, "useremail");
            return (Criteria) this;
        }

        public Criteria andUseremailNotLike(String value) {
            addCriterion("useremail not like", value, "useremail");
            return (Criteria) this;
        }

        public Criteria andUseremailIn(List<String> values) {
            addCriterion("useremail in", values, "useremail");
            return (Criteria) this;
        }

        public Criteria andUseremailNotIn(List<String> values) {
            addCriterion("useremail not in", values, "useremail");
            return (Criteria) this;
        }

        public Criteria andUseremailBetween(String value1, String value2) {
            addCriterion("useremail between", value1, value2, "useremail");
            return (Criteria) this;
        }

        public Criteria andUseremailNotBetween(String value1, String value2) {
            addCriterion("useremail not between", value1, value2, "useremail");
            return (Criteria) this;
        }

        public Criteria andUsertelnumIsNull() {
            addCriterion("usertelnum is null");
            return (Criteria) this;
        }

        public Criteria andUsertelnumIsNotNull() {
            addCriterion("usertelnum is not null");
            return (Criteria) this;
        }

        public Criteria andUsertelnumEqualTo(String value) {
            addCriterion("usertelnum =", value, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsertelnumNotEqualTo(String value) {
            addCriterion("usertelnum <>", value, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsertelnumGreaterThan(String value) {
            addCriterion("usertelnum >", value, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsertelnumGreaterThanOrEqualTo(String value) {
            addCriterion("usertelnum >=", value, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsertelnumLessThan(String value) {
            addCriterion("usertelnum <", value, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsertelnumLessThanOrEqualTo(String value) {
            addCriterion("usertelnum <=", value, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsertelnumLike(String value) {
            addCriterion("usertelnum like", value, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsertelnumNotLike(String value) {
            addCriterion("usertelnum not like", value, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsertelnumIn(List<String> values) {
            addCriterion("usertelnum in", values, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsertelnumNotIn(List<String> values) {
            addCriterion("usertelnum not in", values, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsertelnumBetween(String value1, String value2) {
            addCriterion("usertelnum between", value1, value2, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsertelnumNotBetween(String value1, String value2) {
            addCriterion("usertelnum not between", value1, value2, "usertelnum");
            return (Criteria) this;
        }

        public Criteria andUsermobnubIsNull() {
            addCriterion("usermobnub is null");
            return (Criteria) this;
        }

        public Criteria andUsermobnubIsNotNull() {
            addCriterion("usermobnub is not null");
            return (Criteria) this;
        }

        public Criteria andUsermobnubEqualTo(String value) {
            addCriterion("usermobnub =", value, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andUsermobnubNotEqualTo(String value) {
            addCriterion("usermobnub <>", value, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andUsermobnubGreaterThan(String value) {
            addCriterion("usermobnub >", value, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andUsermobnubGreaterThanOrEqualTo(String value) {
            addCriterion("usermobnub >=", value, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andUsermobnubLessThan(String value) {
            addCriterion("usermobnub <", value, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andUsermobnubLessThanOrEqualTo(String value) {
            addCriterion("usermobnub <=", value, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andUsermobnubLike(String value) {
            addCriterion("usermobnub like", value, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andUsermobnubNotLike(String value) {
            addCriterion("usermobnub not like", value, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andUsermobnubIn(List<String> values) {
            addCriterion("usermobnub in", values, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andUsermobnubNotIn(List<String> values) {
            addCriterion("usermobnub not in", values, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andUsermobnubBetween(String value1, String value2) {
            addCriterion("usermobnub between", value1, value2, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andUsermobnubNotBetween(String value1, String value2) {
            addCriterion("usermobnub not between", value1, value2, "usermobnub");
            return (Criteria) this;
        }

        public Criteria andRoleidsIsNull() {
            addCriterion("roleids is null");
            return (Criteria) this;
        }

        public Criteria andRoleidsIsNotNull() {
            addCriterion("roleids is not null");
            return (Criteria) this;
        }

        public Criteria andRoleidsEqualTo(String value) {
            addCriterion("roleids =", value, "roleids");
            return (Criteria) this;
        }

        public Criteria andRoleidsNotEqualTo(String value) {
            addCriterion("roleids <>", value, "roleids");
            return (Criteria) this;
        }

        public Criteria andRoleidsGreaterThan(String value) {
            addCriterion("roleids >", value, "roleids");
            return (Criteria) this;
        }

        public Criteria andRoleidsGreaterThanOrEqualTo(String value) {
            addCriterion("roleids >=", value, "roleids");
            return (Criteria) this;
        }

        public Criteria andRoleidsLessThan(String value) {
            addCriterion("roleids <", value, "roleids");
            return (Criteria) this;
        }

        public Criteria andRoleidsLessThanOrEqualTo(String value) {
            addCriterion("roleids <=", value, "roleids");
            return (Criteria) this;
        }

        public Criteria andRoleidsLike(String value) {
            addCriterion("roleids like", value, "roleids");
            return (Criteria) this;
        }

        public Criteria andRoleidsNotLike(String value) {
            addCriterion("roleids not like", value, "roleids");
            return (Criteria) this;
        }

        public Criteria andRoleidsIn(List<String> values) {
            addCriterion("roleids in", values, "roleids");
            return (Criteria) this;
        }

        public Criteria andRoleidsNotIn(List<String> values) {
            addCriterion("roleids not in", values, "roleids");
            return (Criteria) this;
        }

        public Criteria andRoleidsBetween(String value1, String value2) {
            addCriterion("roleids between", value1, value2, "roleids");
            return (Criteria) this;
        }

        public Criteria andRoleidsNotBetween(String value1, String value2) {
            addCriterion("roleids not between", value1, value2, "roleids");
            return (Criteria) this;
        }

        public Criteria andStylenameIsNull() {
            addCriterion("stylename is null");
            return (Criteria) this;
        }

        public Criteria andStylenameIsNotNull() {
            addCriterion("stylename is not null");
            return (Criteria) this;
        }

        public Criteria andStylenameEqualTo(String value) {
            addCriterion("stylename =", value, "stylename");
            return (Criteria) this;
        }

        public Criteria andStylenameNotEqualTo(String value) {
            addCriterion("stylename <>", value, "stylename");
            return (Criteria) this;
        }

        public Criteria andStylenameGreaterThan(String value) {
            addCriterion("stylename >", value, "stylename");
            return (Criteria) this;
        }

        public Criteria andStylenameGreaterThanOrEqualTo(String value) {
            addCriterion("stylename >=", value, "stylename");
            return (Criteria) this;
        }

        public Criteria andStylenameLessThan(String value) {
            addCriterion("stylename <", value, "stylename");
            return (Criteria) this;
        }

        public Criteria andStylenameLessThanOrEqualTo(String value) {
            addCriterion("stylename <=", value, "stylename");
            return (Criteria) this;
        }

        public Criteria andStylenameLike(String value) {
            addCriterion("stylename like", value, "stylename");
            return (Criteria) this;
        }

        public Criteria andStylenameNotLike(String value) {
            addCriterion("stylename not like", value, "stylename");
            return (Criteria) this;
        }

        public Criteria andStylenameIn(List<String> values) {
            addCriterion("stylename in", values, "stylename");
            return (Criteria) this;
        }

        public Criteria andStylenameNotIn(List<String> values) {
            addCriterion("stylename not in", values, "stylename");
            return (Criteria) this;
        }

        public Criteria andStylenameBetween(String value1, String value2) {
            addCriterion("stylename between", value1, value2, "stylename");
            return (Criteria) this;
        }

        public Criteria andStylenameNotBetween(String value1, String value2) {
            addCriterion("stylename not between", value1, value2, "stylename");
            return (Criteria) this;
        }

        public Criteria andUserdescIsNull() {
            addCriterion("userdesc is null");
            return (Criteria) this;
        }

        public Criteria andUserdescIsNotNull() {
            addCriterion("userdesc is not null");
            return (Criteria) this;
        }

        public Criteria andUserdescEqualTo(String value) {
            addCriterion("userdesc =", value, "userdesc");
            return (Criteria) this;
        }

        public Criteria andUserdescNotEqualTo(String value) {
            addCriterion("userdesc <>", value, "userdesc");
            return (Criteria) this;
        }

        public Criteria andUserdescGreaterThan(String value) {
            addCriterion("userdesc >", value, "userdesc");
            return (Criteria) this;
        }

        public Criteria andUserdescGreaterThanOrEqualTo(String value) {
            addCriterion("userdesc >=", value, "userdesc");
            return (Criteria) this;
        }

        public Criteria andUserdescLessThan(String value) {
            addCriterion("userdesc <", value, "userdesc");
            return (Criteria) this;
        }

        public Criteria andUserdescLessThanOrEqualTo(String value) {
            addCriterion("userdesc <=", value, "userdesc");
            return (Criteria) this;
        }

        public Criteria andUserdescLike(String value) {
            addCriterion("userdesc like", value, "userdesc");
            return (Criteria) this;
        }

        public Criteria andUserdescNotLike(String value) {
            addCriterion("userdesc not like", value, "userdesc");
            return (Criteria) this;
        }

        public Criteria andUserdescIn(List<String> values) {
            addCriterion("userdesc in", values, "userdesc");
            return (Criteria) this;
        }

        public Criteria andUserdescNotIn(List<String> values) {
            addCriterion("userdesc not in", values, "userdesc");
            return (Criteria) this;
        }

        public Criteria andUserdescBetween(String value1, String value2) {
            addCriterion("userdesc between", value1, value2, "userdesc");
            return (Criteria) this;
        }

        public Criteria andUserdescNotBetween(String value1, String value2) {
            addCriterion("userdesc not between", value1, value2, "userdesc");
            return (Criteria) this;
        }

        public Criteria andPersonWordsIsNull() {
            addCriterion("person_words is null");
            return (Criteria) this;
        }

        public Criteria andPersonWordsIsNotNull() {
            addCriterion("person_words is not null");
            return (Criteria) this;
        }

        public Criteria andPersonWordsEqualTo(String value) {
            addCriterion("person_words =", value, "personWords");
            return (Criteria) this;
        }

        public Criteria andPersonWordsNotEqualTo(String value) {
            addCriterion("person_words <>", value, "personWords");
            return (Criteria) this;
        }

        public Criteria andPersonWordsGreaterThan(String value) {
            addCriterion("person_words >", value, "personWords");
            return (Criteria) this;
        }

        public Criteria andPersonWordsGreaterThanOrEqualTo(String value) {
            addCriterion("person_words >=", value, "personWords");
            return (Criteria) this;
        }

        public Criteria andPersonWordsLessThan(String value) {
            addCriterion("person_words <", value, "personWords");
            return (Criteria) this;
        }

        public Criteria andPersonWordsLessThanOrEqualTo(String value) {
            addCriterion("person_words <=", value, "personWords");
            return (Criteria) this;
        }

        public Criteria andPersonWordsLike(String value) {
            addCriterion("person_words like", value, "personWords");
            return (Criteria) this;
        }

        public Criteria andPersonWordsNotLike(String value) {
            addCriterion("person_words not like", value, "personWords");
            return (Criteria) this;
        }

        public Criteria andPersonWordsIn(List<String> values) {
            addCriterion("person_words in", values, "personWords");
            return (Criteria) this;
        }

        public Criteria andPersonWordsNotIn(List<String> values) {
            addCriterion("person_words not in", values, "personWords");
            return (Criteria) this;
        }

        public Criteria andPersonWordsBetween(String value1, String value2) {
            addCriterion("person_words between", value1, value2, "personWords");
            return (Criteria) this;
        }

        public Criteria andPersonWordsNotBetween(String value1, String value2) {
            addCriterion("person_words not between", value1, value2, "personWords");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitIsNull() {
            addCriterion("head_portait is null");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitIsNotNull() {
            addCriterion("head_portait is not null");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitEqualTo(String value) {
            addCriterion("head_portait =", value, "headPortait");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitNotEqualTo(String value) {
            addCriterion("head_portait <>", value, "headPortait");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitGreaterThan(String value) {
            addCriterion("head_portait >", value, "headPortait");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitGreaterThanOrEqualTo(String value) {
            addCriterion("head_portait >=", value, "headPortait");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitLessThan(String value) {
            addCriterion("head_portait <", value, "headPortait");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitLessThanOrEqualTo(String value) {
            addCriterion("head_portait <=", value, "headPortait");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitLike(String value) {
            addCriterion("head_portait like", value, "headPortait");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitNotLike(String value) {
            addCriterion("head_portait not like", value, "headPortait");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitIn(List<String> values) {
            addCriterion("head_portait in", values, "headPortait");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitNotIn(List<String> values) {
            addCriterion("head_portait not in", values, "headPortait");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitBetween(String value1, String value2) {
            addCriterion("head_portait between", value1, value2, "headPortait");
            return (Criteria) this;
        }

        public Criteria andHeadPortaitNotBetween(String value1, String value2) {
            addCriterion("head_portait not between", value1, value2, "headPortait");
            return (Criteria) this;
        }

        public Criteria andInviteCodeIsNull() {
            addCriterion("invite_code is null");
            return (Criteria) this;
        }

        public Criteria andInviteCodeIsNotNull() {
            addCriterion("invite_code is not null");
            return (Criteria) this;
        }

        public Criteria andInviteCodeEqualTo(String value) {
            addCriterion("invite_code =", value, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andInviteCodeNotEqualTo(String value) {
            addCriterion("invite_code <>", value, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andInviteCodeGreaterThan(String value) {
            addCriterion("invite_code >", value, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andInviteCodeGreaterThanOrEqualTo(String value) {
            addCriterion("invite_code >=", value, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andInviteCodeLessThan(String value) {
            addCriterion("invite_code <", value, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andInviteCodeLessThanOrEqualTo(String value) {
            addCriterion("invite_code <=", value, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andInviteCodeLike(String value) {
            addCriterion("invite_code like", value, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andInviteCodeNotLike(String value) {
            addCriterion("invite_code not like", value, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andInviteCodeIn(List<String> values) {
            addCriterion("invite_code in", values, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andInviteCodeNotIn(List<String> values) {
            addCriterion("invite_code not in", values, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andInviteCodeBetween(String value1, String value2) {
            addCriterion("invite_code between", value1, value2, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andInviteCodeNotBetween(String value1, String value2) {
            addCriterion("invite_code not between", value1, value2, "inviteCode");
            return (Criteria) this;
        }

        public Criteria andPayPasswordIsNull() {
            addCriterion("pay_password is null");
            return (Criteria) this;
        }

        public Criteria andPayPasswordIsNotNull() {
            addCriterion("pay_password is not null");
            return (Criteria) this;
        }

        public Criteria andPayPasswordEqualTo(String value) {
            addCriterion("pay_password =", value, "payPassword");
            return (Criteria) this;
        }

        public Criteria andPayPasswordNotEqualTo(String value) {
            addCriterion("pay_password <>", value, "payPassword");
            return (Criteria) this;
        }

        public Criteria andPayPasswordGreaterThan(String value) {
            addCriterion("pay_password >", value, "payPassword");
            return (Criteria) this;
        }

        public Criteria andPayPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("pay_password >=", value, "payPassword");
            return (Criteria) this;
        }

        public Criteria andPayPasswordLessThan(String value) {
            addCriterion("pay_password <", value, "payPassword");
            return (Criteria) this;
        }

        public Criteria andPayPasswordLessThanOrEqualTo(String value) {
            addCriterion("pay_password <=", value, "payPassword");
            return (Criteria) this;
        }

        public Criteria andPayPasswordLike(String value) {
            addCriterion("pay_password like", value, "payPassword");
            return (Criteria) this;
        }

        public Criteria andPayPasswordNotLike(String value) {
            addCriterion("pay_password not like", value, "payPassword");
            return (Criteria) this;
        }

        public Criteria andPayPasswordIn(List<String> values) {
            addCriterion("pay_password in", values, "payPassword");
            return (Criteria) this;
        }

        public Criteria andPayPasswordNotIn(List<String> values) {
            addCriterion("pay_password not in", values, "payPassword");
            return (Criteria) this;
        }

        public Criteria andPayPasswordBetween(String value1, String value2) {
            addCriterion("pay_password between", value1, value2, "payPassword");
            return (Criteria) this;
        }

        public Criteria andPayPasswordNotBetween(String value1, String value2) {
            addCriterion("pay_password not between", value1, value2, "payPassword");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeIsNull() {
            addCriterion("my_invite_code is null");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeIsNotNull() {
            addCriterion("my_invite_code is not null");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeEqualTo(String value) {
            addCriterion("my_invite_code =", value, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeNotEqualTo(String value) {
            addCriterion("my_invite_code <>", value, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeGreaterThan(String value) {
            addCriterion("my_invite_code >", value, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeGreaterThanOrEqualTo(String value) {
            addCriterion("my_invite_code >=", value, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeLessThan(String value) {
            addCriterion("my_invite_code <", value, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeLessThanOrEqualTo(String value) {
            addCriterion("my_invite_code <=", value, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeLike(String value) {
            addCriterion("my_invite_code like", value, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeNotLike(String value) {
            addCriterion("my_invite_code not like", value, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeIn(List<String> values) {
            addCriterion("my_invite_code in", values, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeNotIn(List<String> values) {
            addCriterion("my_invite_code not in", values, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeBetween(String value1, String value2) {
            addCriterion("my_invite_code between", value1, value2, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andMyInviteCodeNotBetween(String value1, String value2) {
            addCriterion("my_invite_code not between", value1, value2, "myInviteCode");
            return (Criteria) this;
        }

        public Criteria andScoreIsNull() {
            addCriterion("score is null");
            return (Criteria) this;
        }

        public Criteria andScoreIsNotNull() {
            addCriterion("score is not null");
            return (Criteria) this;
        }

        public Criteria andScoreEqualTo(Integer value) {
            addCriterion("score =", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotEqualTo(Integer value) {
            addCriterion("score <>", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThan(Integer value) {
            addCriterion("score >", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThanOrEqualTo(Integer value) {
            addCriterion("score >=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThan(Integer value) {
            addCriterion("score <", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThanOrEqualTo(Integer value) {
            addCriterion("score <=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreIn(List<Integer> values) {
            addCriterion("score in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotIn(List<Integer> values) {
            addCriterion("score not in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreBetween(Integer value1, Integer value2) {
            addCriterion("score between", value1, value2, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotBetween(Integer value1, Integer value2) {
            addCriterion("score not between", value1, value2, "score");
            return (Criteria) this;
        }

        public Criteria andInviteNumberIsNull() {
            addCriterion("invite_number is null");
            return (Criteria) this;
        }

        public Criteria andInviteNumberIsNotNull() {
            addCriterion("invite_number is not null");
            return (Criteria) this;
        }

        public Criteria andInviteNumberEqualTo(Integer value) {
            addCriterion("invite_number =", value, "inviteNumber");
            return (Criteria) this;
        }

        public Criteria andInviteNumberNotEqualTo(Integer value) {
            addCriterion("invite_number <>", value, "inviteNumber");
            return (Criteria) this;
        }

        public Criteria andInviteNumberGreaterThan(Integer value) {
            addCriterion("invite_number >", value, "inviteNumber");
            return (Criteria) this;
        }

        public Criteria andInviteNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("invite_number >=", value, "inviteNumber");
            return (Criteria) this;
        }

        public Criteria andInviteNumberLessThan(Integer value) {
            addCriterion("invite_number <", value, "inviteNumber");
            return (Criteria) this;
        }

        public Criteria andInviteNumberLessThanOrEqualTo(Integer value) {
            addCriterion("invite_number <=", value, "inviteNumber");
            return (Criteria) this;
        }

        public Criteria andInviteNumberIn(List<Integer> values) {
            addCriterion("invite_number in", values, "inviteNumber");
            return (Criteria) this;
        }

        public Criteria andInviteNumberNotIn(List<Integer> values) {
            addCriterion("invite_number not in", values, "inviteNumber");
            return (Criteria) this;
        }

        public Criteria andInviteNumberBetween(Integer value1, Integer value2) {
            addCriterion("invite_number between", value1, value2, "inviteNumber");
            return (Criteria) this;
        }

        public Criteria andInviteNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("invite_number not between", value1, value2, "inviteNumber");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdIsNull() {
            addCriterion("superior_user_id is null");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdIsNotNull() {
            addCriterion("superior_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdEqualTo(String value) {
            addCriterion("superior_user_id =", value, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdNotEqualTo(String value) {
            addCriterion("superior_user_id <>", value, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdGreaterThan(String value) {
            addCriterion("superior_user_id >", value, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("superior_user_id >=", value, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdLessThan(String value) {
            addCriterion("superior_user_id <", value, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdLessThanOrEqualTo(String value) {
            addCriterion("superior_user_id <=", value, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdLike(String value) {
            addCriterion("superior_user_id like", value, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdNotLike(String value) {
            addCriterion("superior_user_id not like", value, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdIn(List<String> values) {
            addCriterion("superior_user_id in", values, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdNotIn(List<String> values) {
            addCriterion("superior_user_id not in", values, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdBetween(String value1, String value2) {
            addCriterion("superior_user_id between", value1, value2, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andSuperiorUserIdNotBetween(String value1, String value2) {
            addCriterion("superior_user_id not between", value1, value2, "superiorUserId");
            return (Criteria) this;
        }

        public Criteria andFuncidsIsNull() {
            addCriterion("funcids is null");
            return (Criteria) this;
        }

        public Criteria andFuncidsIsNotNull() {
            addCriterion("funcids is not null");
            return (Criteria) this;
        }

        public Criteria andFuncidsEqualTo(String value) {
            addCriterion("funcids =", value, "funcids");
            return (Criteria) this;
        }

        public Criteria andFuncidsNotEqualTo(String value) {
            addCriterion("funcids <>", value, "funcids");
            return (Criteria) this;
        }

        public Criteria andFuncidsGreaterThan(String value) {
            addCriterion("funcids >", value, "funcids");
            return (Criteria) this;
        }

        public Criteria andFuncidsGreaterThanOrEqualTo(String value) {
            addCriterion("funcids >=", value, "funcids");
            return (Criteria) this;
        }

        public Criteria andFuncidsLessThan(String value) {
            addCriterion("funcids <", value, "funcids");
            return (Criteria) this;
        }

        public Criteria andFuncidsLessThanOrEqualTo(String value) {
            addCriterion("funcids <=", value, "funcids");
            return (Criteria) this;
        }

        public Criteria andFuncidsLike(String value) {
            addCriterion("funcids like", value, "funcids");
            return (Criteria) this;
        }

        public Criteria andFuncidsNotLike(String value) {
            addCriterion("funcids not like", value, "funcids");
            return (Criteria) this;
        }

        public Criteria andFuncidsIn(List<String> values) {
            addCriterion("funcids in", values, "funcids");
            return (Criteria) this;
        }

        public Criteria andFuncidsNotIn(List<String> values) {
            addCriterion("funcids not in", values, "funcids");
            return (Criteria) this;
        }

        public Criteria andFuncidsBetween(String value1, String value2) {
            addCriterion("funcids between", value1, value2, "funcids");
            return (Criteria) this;
        }

        public Criteria andFuncidsNotBetween(String value1, String value2) {
            addCriterion("funcids not between", value1, value2, "funcids");
            return (Criteria) this;
        }

        public Criteria andMenuidsIsNull() {
            addCriterion("menuids is null");
            return (Criteria) this;
        }

        public Criteria andMenuidsIsNotNull() {
            addCriterion("menuids is not null");
            return (Criteria) this;
        }

        public Criteria andMenuidsEqualTo(String value) {
            addCriterion("menuids =", value, "menuids");
            return (Criteria) this;
        }

        public Criteria andMenuidsNotEqualTo(String value) {
            addCriterion("menuids <>", value, "menuids");
            return (Criteria) this;
        }

        public Criteria andMenuidsGreaterThan(String value) {
            addCriterion("menuids >", value, "menuids");
            return (Criteria) this;
        }

        public Criteria andMenuidsGreaterThanOrEqualTo(String value) {
            addCriterion("menuids >=", value, "menuids");
            return (Criteria) this;
        }

        public Criteria andMenuidsLessThan(String value) {
            addCriterion("menuids <", value, "menuids");
            return (Criteria) this;
        }

        public Criteria andMenuidsLessThanOrEqualTo(String value) {
            addCriterion("menuids <=", value, "menuids");
            return (Criteria) this;
        }

        public Criteria andMenuidsLike(String value) {
            addCriterion("menuids like", value, "menuids");
            return (Criteria) this;
        }

        public Criteria andMenuidsNotLike(String value) {
            addCriterion("menuids not like", value, "menuids");
            return (Criteria) this;
        }

        public Criteria andMenuidsIn(List<String> values) {
            addCriterion("menuids in", values, "menuids");
            return (Criteria) this;
        }

        public Criteria andMenuidsNotIn(List<String> values) {
            addCriterion("menuids not in", values, "menuids");
            return (Criteria) this;
        }

        public Criteria andMenuidsBetween(String value1, String value2) {
            addCriterion("menuids between", value1, value2, "menuids");
            return (Criteria) this;
        }

        public Criteria andMenuidsNotBetween(String value1, String value2) {
            addCriterion("menuids not between", value1, value2, "menuids");
            return (Criteria) this;
        }

        public Criteria andCertIdIsNull() {
            addCriterion("cert_id is null");
            return (Criteria) this;
        }

        public Criteria andCertIdIsNotNull() {
            addCriterion("cert_id is not null");
            return (Criteria) this;
        }

        public Criteria andCertIdEqualTo(String value) {
            addCriterion("cert_id =", value, "certId");
            return (Criteria) this;
        }

        public Criteria andCertIdNotEqualTo(String value) {
            addCriterion("cert_id <>", value, "certId");
            return (Criteria) this;
        }

        public Criteria andCertIdGreaterThan(String value) {
            addCriterion("cert_id >", value, "certId");
            return (Criteria) this;
        }

        public Criteria andCertIdGreaterThanOrEqualTo(String value) {
            addCriterion("cert_id >=", value, "certId");
            return (Criteria) this;
        }

        public Criteria andCertIdLessThan(String value) {
            addCriterion("cert_id <", value, "certId");
            return (Criteria) this;
        }

        public Criteria andCertIdLessThanOrEqualTo(String value) {
            addCriterion("cert_id <=", value, "certId");
            return (Criteria) this;
        }

        public Criteria andCertIdLike(String value) {
            addCriterion("cert_id like", value, "certId");
            return (Criteria) this;
        }

        public Criteria andCertIdNotLike(String value) {
            addCriterion("cert_id not like", value, "certId");
            return (Criteria) this;
        }

        public Criteria andCertIdIn(List<String> values) {
            addCriterion("cert_id in", values, "certId");
            return (Criteria) this;
        }

        public Criteria andCertIdNotIn(List<String> values) {
            addCriterion("cert_id not in", values, "certId");
            return (Criteria) this;
        }

        public Criteria andCertIdBetween(String value1, String value2) {
            addCriterion("cert_id between", value1, value2, "certId");
            return (Criteria) this;
        }

        public Criteria andCertIdNotBetween(String value1, String value2) {
            addCriterion("cert_id not between", value1, value2, "certId");
            return (Criteria) this;
        }

        public Criteria andCertTypeIsNull() {
            addCriterion("cert_type is null");
            return (Criteria) this;
        }

        public Criteria andCertTypeIsNotNull() {
            addCriterion("cert_type is not null");
            return (Criteria) this;
        }

        public Criteria andCertTypeEqualTo(String value) {
            addCriterion("cert_type =", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeNotEqualTo(String value) {
            addCriterion("cert_type <>", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeGreaterThan(String value) {
            addCriterion("cert_type >", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeGreaterThanOrEqualTo(String value) {
            addCriterion("cert_type >=", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeLessThan(String value) {
            addCriterion("cert_type <", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeLessThanOrEqualTo(String value) {
            addCriterion("cert_type <=", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeLike(String value) {
            addCriterion("cert_type like", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeNotLike(String value) {
            addCriterion("cert_type not like", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeIn(List<String> values) {
            addCriterion("cert_type in", values, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeNotIn(List<String> values) {
            addCriterion("cert_type not in", values, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeBetween(String value1, String value2) {
            addCriterion("cert_type between", value1, value2, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeNotBetween(String value1, String value2) {
            addCriterion("cert_type not between", value1, value2, "certType");
            return (Criteria) this;
        }

        public Criteria andCertNameIsNull() {
            addCriterion("cert_name is null");
            return (Criteria) this;
        }

        public Criteria andCertNameIsNotNull() {
            addCriterion("cert_name is not null");
            return (Criteria) this;
        }

        public Criteria andCertNameEqualTo(String value) {
            addCriterion("cert_name =", value, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNameNotEqualTo(String value) {
            addCriterion("cert_name <>", value, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNameGreaterThan(String value) {
            addCriterion("cert_name >", value, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNameGreaterThanOrEqualTo(String value) {
            addCriterion("cert_name >=", value, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNameLessThan(String value) {
            addCriterion("cert_name <", value, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNameLessThanOrEqualTo(String value) {
            addCriterion("cert_name <=", value, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNameLike(String value) {
            addCriterion("cert_name like", value, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNameNotLike(String value) {
            addCriterion("cert_name not like", value, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNameIn(List<String> values) {
            addCriterion("cert_name in", values, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNameNotIn(List<String> values) {
            addCriterion("cert_name not in", values, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNameBetween(String value1, String value2) {
            addCriterion("cert_name between", value1, value2, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNameNotBetween(String value1, String value2) {
            addCriterion("cert_name not between", value1, value2, "certName");
            return (Criteria) this;
        }

        public Criteria andCertNumberIsNull() {
            addCriterion("cert_number is null");
            return (Criteria) this;
        }

        public Criteria andCertNumberIsNotNull() {
            addCriterion("cert_number is not null");
            return (Criteria) this;
        }

        public Criteria andCertNumberEqualTo(String value) {
            addCriterion("cert_number =", value, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertNumberNotEqualTo(String value) {
            addCriterion("cert_number <>", value, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertNumberGreaterThan(String value) {
            addCriterion("cert_number >", value, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertNumberGreaterThanOrEqualTo(String value) {
            addCriterion("cert_number >=", value, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertNumberLessThan(String value) {
            addCriterion("cert_number <", value, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertNumberLessThanOrEqualTo(String value) {
            addCriterion("cert_number <=", value, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertNumberLike(String value) {
            addCriterion("cert_number like", value, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertNumberNotLike(String value) {
            addCriterion("cert_number not like", value, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertNumberIn(List<String> values) {
            addCriterion("cert_number in", values, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertNumberNotIn(List<String> values) {
            addCriterion("cert_number not in", values, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertNumberBetween(String value1, String value2) {
            addCriterion("cert_number between", value1, value2, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertNumberNotBetween(String value1, String value2) {
            addCriterion("cert_number not between", value1, value2, "certNumber");
            return (Criteria) this;
        }

        public Criteria andCertStateIsNull() {
            addCriterion("cert_state is null");
            return (Criteria) this;
        }

        public Criteria andCertStateIsNotNull() {
            addCriterion("cert_state is not null");
            return (Criteria) this;
        }

        public Criteria andCertStateEqualTo(String value) {
            addCriterion("cert_state =", value, "certState");
            return (Criteria) this;
        }

        public Criteria andCertStateNotEqualTo(String value) {
            addCriterion("cert_state <>", value, "certState");
            return (Criteria) this;
        }

        public Criteria andCertStateGreaterThan(String value) {
            addCriterion("cert_state >", value, "certState");
            return (Criteria) this;
        }

        public Criteria andCertStateGreaterThanOrEqualTo(String value) {
            addCriterion("cert_state >=", value, "certState");
            return (Criteria) this;
        }

        public Criteria andCertStateLessThan(String value) {
            addCriterion("cert_state <", value, "certState");
            return (Criteria) this;
        }

        public Criteria andCertStateLessThanOrEqualTo(String value) {
            addCriterion("cert_state <=", value, "certState");
            return (Criteria) this;
        }

        public Criteria andCertStateLike(String value) {
            addCriterion("cert_state like", value, "certState");
            return (Criteria) this;
        }

        public Criteria andCertStateNotLike(String value) {
            addCriterion("cert_state not like", value, "certState");
            return (Criteria) this;
        }

        public Criteria andCertStateIn(List<String> values) {
            addCriterion("cert_state in", values, "certState");
            return (Criteria) this;
        }

        public Criteria andCertStateNotIn(List<String> values) {
            addCriterion("cert_state not in", values, "certState");
            return (Criteria) this;
        }

        public Criteria andCertStateBetween(String value1, String value2) {
            addCriterion("cert_state between", value1, value2, "certState");
            return (Criteria) this;
        }

        public Criteria andCertStateNotBetween(String value1, String value2) {
            addCriterion("cert_state not between", value1, value2, "certState");
            return (Criteria) this;
        }

        public Criteria andCertFileIsNull() {
            addCriterion("cert_file is null");
            return (Criteria) this;
        }

        public Criteria andCertFileIsNotNull() {
            addCriterion("cert_file is not null");
            return (Criteria) this;
        }

        public Criteria andCertFileEqualTo(String value) {
            addCriterion("cert_file =", value, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertFileNotEqualTo(String value) {
            addCriterion("cert_file <>", value, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertFileGreaterThan(String value) {
            addCriterion("cert_file >", value, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertFileGreaterThanOrEqualTo(String value) {
            addCriterion("cert_file >=", value, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertFileLessThan(String value) {
            addCriterion("cert_file <", value, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertFileLessThanOrEqualTo(String value) {
            addCriterion("cert_file <=", value, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertFileLike(String value) {
            addCriterion("cert_file like", value, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertFileNotLike(String value) {
            addCriterion("cert_file not like", value, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertFileIn(List<String> values) {
            addCriterion("cert_file in", values, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertFileNotIn(List<String> values) {
            addCriterion("cert_file not in", values, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertFileBetween(String value1, String value2) {
            addCriterion("cert_file between", value1, value2, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertFileNotBetween(String value1, String value2) {
            addCriterion("cert_file not between", value1, value2, "certFile");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameIsNull() {
            addCriterion("cert_linked_person_name is null");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameIsNotNull() {
            addCriterion("cert_linked_person_name is not null");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameEqualTo(String value) {
            addCriterion("cert_linked_person_name =", value, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameNotEqualTo(String value) {
            addCriterion("cert_linked_person_name <>", value, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameGreaterThan(String value) {
            addCriterion("cert_linked_person_name >", value, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameGreaterThanOrEqualTo(String value) {
            addCriterion("cert_linked_person_name >=", value, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameLessThan(String value) {
            addCriterion("cert_linked_person_name <", value, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameLessThanOrEqualTo(String value) {
            addCriterion("cert_linked_person_name <=", value, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameLike(String value) {
            addCriterion("cert_linked_person_name like", value, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameNotLike(String value) {
            addCriterion("cert_linked_person_name not like", value, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameIn(List<String> values) {
            addCriterion("cert_linked_person_name in", values, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameNotIn(List<String> values) {
            addCriterion("cert_linked_person_name not in", values, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameBetween(String value1, String value2) {
            addCriterion("cert_linked_person_name between", value1, value2, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonNameNotBetween(String value1, String value2) {
            addCriterion("cert_linked_person_name not between", value1, value2, "certLinkedPersonName");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoIsNull() {
            addCriterion("cert_linked_person_id_no is null");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoIsNotNull() {
            addCriterion("cert_linked_person_id_no is not null");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoEqualTo(String value) {
            addCriterion("cert_linked_person_id_no =", value, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoNotEqualTo(String value) {
            addCriterion("cert_linked_person_id_no <>", value, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoGreaterThan(String value) {
            addCriterion("cert_linked_person_id_no >", value, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoGreaterThanOrEqualTo(String value) {
            addCriterion("cert_linked_person_id_no >=", value, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoLessThan(String value) {
            addCriterion("cert_linked_person_id_no <", value, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoLessThanOrEqualTo(String value) {
            addCriterion("cert_linked_person_id_no <=", value, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoLike(String value) {
            addCriterion("cert_linked_person_id_no like", value, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoNotLike(String value) {
            addCriterion("cert_linked_person_id_no not like", value, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoIn(List<String> values) {
            addCriterion("cert_linked_person_id_no in", values, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoNotIn(List<String> values) {
            addCriterion("cert_linked_person_id_no not in", values, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoBetween(String value1, String value2) {
            addCriterion("cert_linked_person_id_no between", value1, value2, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonIdNoNotBetween(String value1, String value2) {
            addCriterion("cert_linked_person_id_no not between", value1, value2, "certLinkedPersonIdNo");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelIsNull() {
            addCriterion("cert_linked_person_tel is null");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelIsNotNull() {
            addCriterion("cert_linked_person_tel is not null");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelEqualTo(String value) {
            addCriterion("cert_linked_person_tel =", value, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelNotEqualTo(String value) {
            addCriterion("cert_linked_person_tel <>", value, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelGreaterThan(String value) {
            addCriterion("cert_linked_person_tel >", value, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelGreaterThanOrEqualTo(String value) {
            addCriterion("cert_linked_person_tel >=", value, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelLessThan(String value) {
            addCriterion("cert_linked_person_tel <", value, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelLessThanOrEqualTo(String value) {
            addCriterion("cert_linked_person_tel <=", value, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelLike(String value) {
            addCriterion("cert_linked_person_tel like", value, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelNotLike(String value) {
            addCriterion("cert_linked_person_tel not like", value, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelIn(List<String> values) {
            addCriterion("cert_linked_person_tel in", values, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelNotIn(List<String> values) {
            addCriterion("cert_linked_person_tel not in", values, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelBetween(String value1, String value2) {
            addCriterion("cert_linked_person_tel between", value1, value2, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinkedPersonTelNotBetween(String value1, String value2) {
            addCriterion("cert_linked_person_tel not between", value1, value2, "certLinkedPersonTel");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderIsNull() {
            addCriterion("cert_lined_gender is null");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderIsNotNull() {
            addCriterion("cert_lined_gender is not null");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderEqualTo(String value) {
            addCriterion("cert_lined_gender =", value, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderNotEqualTo(String value) {
            addCriterion("cert_lined_gender <>", value, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderGreaterThan(String value) {
            addCriterion("cert_lined_gender >", value, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderGreaterThanOrEqualTo(String value) {
            addCriterion("cert_lined_gender >=", value, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderLessThan(String value) {
            addCriterion("cert_lined_gender <", value, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderLessThanOrEqualTo(String value) {
            addCriterion("cert_lined_gender <=", value, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderLike(String value) {
            addCriterion("cert_lined_gender like", value, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderNotLike(String value) {
            addCriterion("cert_lined_gender not like", value, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderIn(List<String> values) {
            addCriterion("cert_lined_gender in", values, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderNotIn(List<String> values) {
            addCriterion("cert_lined_gender not in", values, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderBetween(String value1, String value2) {
            addCriterion("cert_lined_gender between", value1, value2, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertLinedGenderNotBetween(String value1, String value2) {
            addCriterion("cert_lined_gender not between", value1, value2, "certLinedGender");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoIsNull() {
            addCriterion("cert_reject_info is null");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoIsNotNull() {
            addCriterion("cert_reject_info is not null");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoEqualTo(String value) {
            addCriterion("cert_reject_info =", value, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoNotEqualTo(String value) {
            addCriterion("cert_reject_info <>", value, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoGreaterThan(String value) {
            addCriterion("cert_reject_info >", value, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoGreaterThanOrEqualTo(String value) {
            addCriterion("cert_reject_info >=", value, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoLessThan(String value) {
            addCriterion("cert_reject_info <", value, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoLessThanOrEqualTo(String value) {
            addCriterion("cert_reject_info <=", value, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoLike(String value) {
            addCriterion("cert_reject_info like", value, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoNotLike(String value) {
            addCriterion("cert_reject_info not like", value, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoIn(List<String> values) {
            addCriterion("cert_reject_info in", values, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoNotIn(List<String> values) {
            addCriterion("cert_reject_info not in", values, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoBetween(String value1, String value2) {
            addCriterion("cert_reject_info between", value1, value2, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertRejectInfoNotBetween(String value1, String value2) {
            addCriterion("cert_reject_info not between", value1, value2, "certRejectInfo");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameIsNull() {
            addCriterion("cert_legal_name is null");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameIsNotNull() {
            addCriterion("cert_legal_name is not null");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameEqualTo(String value) {
            addCriterion("cert_legal_name =", value, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameNotEqualTo(String value) {
            addCriterion("cert_legal_name <>", value, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameGreaterThan(String value) {
            addCriterion("cert_legal_name >", value, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameGreaterThanOrEqualTo(String value) {
            addCriterion("cert_legal_name >=", value, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameLessThan(String value) {
            addCriterion("cert_legal_name <", value, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameLessThanOrEqualTo(String value) {
            addCriterion("cert_legal_name <=", value, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameLike(String value) {
            addCriterion("cert_legal_name like", value, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameNotLike(String value) {
            addCriterion("cert_legal_name not like", value, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameIn(List<String> values) {
            addCriterion("cert_legal_name in", values, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameNotIn(List<String> values) {
            addCriterion("cert_legal_name not in", values, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameBetween(String value1, String value2) {
            addCriterion("cert_legal_name between", value1, value2, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalNameNotBetween(String value1, String value2) {
            addCriterion("cert_legal_name not between", value1, value2, "certLegalName");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoIsNull() {
            addCriterion("cert_legal_idno is null");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoIsNotNull() {
            addCriterion("cert_legal_idno is not null");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoEqualTo(String value) {
            addCriterion("cert_legal_idno =", value, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoNotEqualTo(String value) {
            addCriterion("cert_legal_idno <>", value, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoGreaterThan(String value) {
            addCriterion("cert_legal_idno >", value, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoGreaterThanOrEqualTo(String value) {
            addCriterion("cert_legal_idno >=", value, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoLessThan(String value) {
            addCriterion("cert_legal_idno <", value, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoLessThanOrEqualTo(String value) {
            addCriterion("cert_legal_idno <=", value, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoLike(String value) {
            addCriterion("cert_legal_idno like", value, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoNotLike(String value) {
            addCriterion("cert_legal_idno not like", value, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoIn(List<String> values) {
            addCriterion("cert_legal_idno in", values, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoNotIn(List<String> values) {
            addCriterion("cert_legal_idno not in", values, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoBetween(String value1, String value2) {
            addCriterion("cert_legal_idno between", value1, value2, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertLegalIdnoNotBetween(String value1, String value2) {
            addCriterion("cert_legal_idno not between", value1, value2, "certLegalIdno");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeIsNull() {
            addCriterion("cert_id_type is null");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeIsNotNull() {
            addCriterion("cert_id_type is not null");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeEqualTo(String value) {
            addCriterion("cert_id_type =", value, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeNotEqualTo(String value) {
            addCriterion("cert_id_type <>", value, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeGreaterThan(String value) {
            addCriterion("cert_id_type >", value, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeGreaterThanOrEqualTo(String value) {
            addCriterion("cert_id_type >=", value, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeLessThan(String value) {
            addCriterion("cert_id_type <", value, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeLessThanOrEqualTo(String value) {
            addCriterion("cert_id_type <=", value, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeLike(String value) {
            addCriterion("cert_id_type like", value, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeNotLike(String value) {
            addCriterion("cert_id_type not like", value, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeIn(List<String> values) {
            addCriterion("cert_id_type in", values, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeNotIn(List<String> values) {
            addCriterion("cert_id_type not in", values, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeBetween(String value1, String value2) {
            addCriterion("cert_id_type between", value1, value2, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertIdTypeNotBetween(String value1, String value2) {
            addCriterion("cert_id_type not between", value1, value2, "certIdType");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeIsNull() {
            addCriterion("cert_auth_time is null");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeIsNotNull() {
            addCriterion("cert_auth_time is not null");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeEqualTo(Date value) {
            addCriterion("cert_auth_time =", value, "certAuthTime");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeNotEqualTo(Date value) {
            addCriterion("cert_auth_time <>", value, "certAuthTime");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeGreaterThan(Date value) {
            addCriterion("cert_auth_time >", value, "certAuthTime");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("cert_auth_time >=", value, "certAuthTime");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeLessThan(Date value) {
            addCriterion("cert_auth_time <", value, "certAuthTime");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeLessThanOrEqualTo(Date value) {
            addCriterion("cert_auth_time <=", value, "certAuthTime");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeIn(List<Date> values) {
            addCriterion("cert_auth_time in", values, "certAuthTime");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeNotIn(List<Date> values) {
            addCriterion("cert_auth_time not in", values, "certAuthTime");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeBetween(Date value1, Date value2) {
            addCriterion("cert_auth_time between", value1, value2, "certAuthTime");
            return (Criteria) this;
        }

        public Criteria andCertAuthTimeNotBetween(Date value1, Date value2) {
            addCriterion("cert_auth_time not between", value1, value2, "certAuthTime");
            return (Criteria) this;
        }

        public Criteria andCertAuditorIsNull() {
            addCriterion("cert_auditor is null");
            return (Criteria) this;
        }

        public Criteria andCertAuditorIsNotNull() {
            addCriterion("cert_auditor is not null");
            return (Criteria) this;
        }

        public Criteria andCertAuditorEqualTo(String value) {
            addCriterion("cert_auditor =", value, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertAuditorNotEqualTo(String value) {
            addCriterion("cert_auditor <>", value, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertAuditorGreaterThan(String value) {
            addCriterion("cert_auditor >", value, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertAuditorGreaterThanOrEqualTo(String value) {
            addCriterion("cert_auditor >=", value, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertAuditorLessThan(String value) {
            addCriterion("cert_auditor <", value, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertAuditorLessThanOrEqualTo(String value) {
            addCriterion("cert_auditor <=", value, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertAuditorLike(String value) {
            addCriterion("cert_auditor like", value, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertAuditorNotLike(String value) {
            addCriterion("cert_auditor not like", value, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertAuditorIn(List<String> values) {
            addCriterion("cert_auditor in", values, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertAuditorNotIn(List<String> values) {
            addCriterion("cert_auditor not in", values, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertAuditorBetween(String value1, String value2) {
            addCriterion("cert_auditor between", value1, value2, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertAuditorNotBetween(String value1, String value2) {
            addCriterion("cert_auditor not between", value1, value2, "certAuditor");
            return (Criteria) this;
        }

        public Criteria andCertUidIsNull() {
            addCriterion("cert_uid is null");
            return (Criteria) this;
        }

        public Criteria andCertUidIsNotNull() {
            addCriterion("cert_uid is not null");
            return (Criteria) this;
        }

        public Criteria andCertUidEqualTo(String value) {
            addCriterion("cert_uid =", value, "certUid");
            return (Criteria) this;
        }

        public Criteria andCertUidNotEqualTo(String value) {
            addCriterion("cert_uid <>", value, "certUid");
            return (Criteria) this;
        }

        public Criteria andCertUidGreaterThan(String value) {
            addCriterion("cert_uid >", value, "certUid");
            return (Criteria) this;
        }

        public Criteria andCertUidGreaterThanOrEqualTo(String value) {
            addCriterion("cert_uid >=", value, "certUid");
            return (Criteria) this;
        }

        public Criteria andCertUidLessThan(String value) {
            addCriterion("cert_uid <", value, "certUid");
            return (Criteria) this;
        }

        public Criteria andCertUidLessThanOrEqualTo(String value) {
            addCriterion("cert_uid <=", value, "certUid");
            return (Criteria) this;
        }

        public Criteria andCertUidLike(String value) {
            addCriterion("cert_uid like", value, "certUid");
            return (Criteria) this;
        }

        public Criteria andCertUidNotLike(String value) {
            addCriterion("cert_uid not like", value, "certUid");
            return (Criteria) this;
        }

        public Criteria andCertUidIn(List<String> values) {
            addCriterion("cert_uid in", values, "certUid");
            return (Criteria) this;
        }

        public Criteria andCertUidNotIn(List<String> values) {
            addCriterion("cert_uid not in", values, "certUid");
            return (Criteria) this;
        }

        public Criteria andCertUidBetween(String value1, String value2) {
            addCriterion("cert_uid between", value1, value2, "certUid");
            return (Criteria) this;
        }

        public Criteria andCertUidNotBetween(String value1, String value2) {
            addCriterion("cert_uid not between", value1, value2, "certUid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}