ID_,USER_ID_,REL_ID_,TYPE_ID_,UPDATE_TIME_,IS_DELE_,VERSION_
SELECT a.*,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM uc_rel_auth a
left join uc_user b on a.USER_ID_ = b.ID_
left join uc_user_rel c on a.REL_ID_ = c.ID_
WHERE
a.ID_=#{id} AND a.IS_DELE_!='1' AND b.IS_DELE_!='1' AND c.IS_DELE_!='1'
SELECT a.ID_,a.USER_ID_,a.REL_ID_,a.TYPE_ID_,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM uc_rel_auth a
left join uc_user b on a.USER_ID_ = b.ID_
left join uc_user_rel c on a.REL_ID_ = c.ID_
${ew.customSqlSegment}
SELECT * FROM uc_rel_auth
${ew.customSqlSegment}
DELETE FROM uc_rel_auth WHERE IS_DELE_='1'
SELECT a.ID_,a.USER_ID_,a.REL_ID_,a.TYPE_ID_,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM uc_rel_auth a
inner join uc_user b on a.USER_ID_ = b.ID_
inner join uc_user_rel c on a.REL_ID_ = c.ID_
WHERE 1= 1 AND a.IS_DELE_!='1' AND b.IS_DELE_!='1' AND c.IS_DELE_!='1'
AND a.USER_ID_ =#{ew.paramNameValuePairs.userId}
AND a.REL_ID_ = #{ew.paramNameValuePairs.relId}
AND b.FULLNAME_ = #{ew.paramNameValuePairs.userName}
AND c.NAME_ = #{ew.paramNameValuePairs.relName}
AND a.TYPE_ID_ = #{ew.paramNameValuePairs.typeId}
ORDER BY ${ew.paramNameValuePairs.orderBySql}
SELECT a.*,b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM uc_rel_auth a
inner join uc_user b on a.USER_ID_ = b.ID_
inner join uc_user_rel c on a.REL_ID_ = c.ID_
where a.REL_ID_ = #{relId} and a.USER_ID_ = #{userId} AND a.IS_DELE_!='1'
UPDATE uc_rel_auth SET IS_DELE_='1',UPDATE_TIME_ = #{updateTime,jdbcType=TIMESTAMP}
WHERE
REL_ID_=#{relId}
SELECT a.ID_,a.USER_ID_,a.REL_ID_,a.TYPE_ID_,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM uc_rel_auth a
left join uc_user b on a.USER_ID_ = b.ID_
left join uc_user_rel c on a.REL_ID_ = c.ID_
where a.USER_ID_ = #{userId}
AND a.IS_DELE_!='1' AND b.IS_DELE_!='1' AND c.IS_DELE_!='1'
SELECT a.ID_,a.USER_ID_,a.REL_ID_,a.TYPE_ID_,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM uc_rel_auth a
left join uc_user b on a.USER_ID_ = b.ID_
left join uc_user_rel c on a.REL_ID_ = c.ID_
WHERE b.ACCOUNT_=#{account} AND a.IS_DELE_!='1'
SELECT a.ID_,a.USER_ID_,a.REL_ID_,a.TYPE_ID_,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM uc_rel_auth a
left join uc_user b on a.USER_ID_ = b.ID_
left join uc_user_rel c on a.REL_ID_ = c.ID_
WHERE b.ID_=#{userId} AND a.IS_DELE_!='1'