node.js Sequelize - (include, attributes)

 

const chatRoom = await ChatRoom.findOne (
        {
          where: {CR_SEQ : cr_seq}
          , include:
                [{
                model: ChatUser, as:'AIAB_CR_USER', required: false
                , include:
                    [{
                        model: User
                        , attributes:['USER_ID','USER_NM','NICK_NM','BRTHDY','AGE','GENDER','CITY_CODE'
                                        ,'EMAIL','PROVIDER','PROVIDER_ID','THUMBNAIL','CR_EXIT_AT']
                        , as:'TB_USER'
                        , required: false
                    }]
                }]
        }
    );

 

include - 하위 테이블 조인
attributes - 해당 테이블에서 조회 하려는 컬럼 배열